Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACADEMIC_PERIOD	Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.	VARCHAR2(63)	DAP_RESNONCR_DTL	DAP_TERM	NO	NO
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC	NO	NO
ACADEMIC_PERIOD_DESC_DW	Current academic period description from Degree Works.	VARCHAR2(255)	UCX_STU016	UCX_VALUE	NO	NO
ACADEMIC_YEAR	Academic year associated with the academic period on this record.	VARCHAR2(63)	STVTERM	STVTERM_ACYR_CODE	NO	NO
ACADEMIC_YEAR_DESC	Audit academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
AUDIT_ACADEMIC_PERIOD	Student's active academic period used in Degree Works for audits.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_ACTIVE_TERM	NO	NO
AUDIT_ACADEMIC_PERIOD_DESC	Current audit academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC	NO	NO
AUDIT_ACADEMIC_PERIOD_DESC_DW	Current academic period description from Degree Works.	VARCHAR2(255)	UCX_STU016	UCX_VALUE	NO	NO
AUDIT_ACADEMIC_YEAR	Audit academic year associated with the academic period on this record.	VARCHAR2(63)	STVTERM	STVTERM_ACYR_CODE	NO	NO
AUDIT_ACADEMIC_YEAR_DESC	Audit academic year description.	VARCHAR2(255)	STVACYR	STVACYR_DESC	NO	NO
AUDIT_NON_COURSE_KEY	Unique system generated sequence number associated to each audit non-course result row.	NUMBER	DAP_RESNONCR_DTL	UNIQUE_ID	NO	NO
AUDIT_RESULT_CREATE_DATE	Date the audit results were created.	DATE	DAP_RESULT_DTL	DAP_CREATE_DATE	NO	NO
AUDIT_RESULT_KEY	Unique system generated sequence number associated to each audit result row.	NUMBER	DAP_RESULT_DTL	UNIQUE_ID	NO	NO
AUDIT_RESULT_TYPE	Result type identified in the student audit such as CLASSAPPLIED or FALLCLASSNEEDED.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_RESULT_TYPE	NO	NO
AUDIT_RESULT_TYPE_DESC	Audit result type description.	VARCHAR2(255)	CALCULATION	CASE WHEN DAP_RESULT_TYPE	NO	NO
AUDIT_RUN_DATE	Date the audit was run.	DATE	CALCULATION	DAP_VALUE2 || DAP_VALUE3 WHERE DAP_RESULT_TYPE = 'AUDITID'	NO	NO
AUDIT_TYPE	Audit type determining if this is an academic audit, financial aid audit or athletic eligibility audit.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_AUDIT_TYPE	NO	NO
AUDIT_TYPE_DESC	Audit type description.	VARCHAR2(255)	CALCULATION	CASE WHEN DAP_AUDIT_TYPE	NO	NO
BLOCK_DESC	Block title.	VARCHAR2(255)	CONSTANT DAP_REQ_BLOCK	'FALL-THROUGH NON-COURSES' TITLE	NO NO	NO
BLOCK_ID	Block identification grouping a set of requirements.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_REQ_ID	NO	NO
BLOCK_RULE_ID	Rule identification associated with a rule used in a scribed block.	VARCHAR2(63)	CONSTANT DAP_RESULT_DTL	'NA' DAP_RULE_ID	NO NO	NO
BLOCK_RULE_LABEL	Label text uniquely identifying the rule within the block.	VARCHAR2(255)	CONSTANT DAP_RESULT_DTL	'NA' DAP_FREETEXT	NO NO	NO
BLOCK_SEQUENCE_NUMBER	One up system generated sequence number associated to the block id in the order in which blocks are processed for the audit.	NUMBER	DAP_RESULT_DTL	DAP_BLOCK_SEQ_NUM	NO	NO
DEGREE	Award, degree, diploma, certification upon completion of all the requirements for a particular academic study. For example, Bachelor of Science, Associate of Arts, Vocational Certificate.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_DEGREE	NO	NO
DEGREE_DESC	Degree description.	VARCHAR2(255)	STVDEGC	STVDEGC_DESC	NO	NO
DEGREE_DESC_DW	Degree description from Degree Works.	VARCHAR2(255)	UCX_STU307	UCX_VALUE	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the student (Last name, First name Middle Initial format).	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
NONCOURSE_APPLIED_IND	Indicates whether this non-course was applied in the audit.	VARCHAR2(1)	CALCULATION	CASE WHEN DAP_RESULT_TYPE = 'NONCRAPPLIED'	NO	NO
NONCOURSE_FALLTHROUGH_IND	Indicates whether this non-course was placed in the fall-through section for the audit.	VARCHAR2(1)	CALCULATION	CASE WHEN DAP_RESULT_TYPE = 'FALLNONCRAPPLIED'	NO	NO
NONCOURSE_NEEDED_IND	Indicates whether this non-course was needed in the audit.	VARCHAR2(1)	CALCULATION	CASE WHEN DAP_RESULT_TYPE = 'NONCRNEEDED'	NO	NO
NON_COURSE	Non-course.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE1	NO	NO
NON_COURSE_DESC	Non-course description.	VARCHAR2(255)	STVNCRQ STVQPTP	STVNCRQ_DESC STVQPTP_DESC	NO NO	NO
NON_COURSE_DESC_DW	Non-course description from Degree Works.	VARCHAR2(255)	DAP_RESNONCR_DTL	DAP_COURSE_TITLE	NO	NO
NON_COURSE_INTERNAL_KEY	Unique system generated sequence number associated to each course or non-course for that student.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE3	NO	NO
NON_COURSE_OPERATOR	Operator like > or = used with the non-course and non-course value.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE2	NO	NO
NON_COURSE_STATUS	Non-course requirement status.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE2	NO	NO
NON_COURSE_STATUS_DESC	Non-course requirement status description.	VARCHAR2(255)	STVNCST	STVNCST_DESC	NO	NO
NON_COURSE_VALUE	Non-course value.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE3	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RAD_PRIMARY_MST	RAD_USER_DEF1	NO	NO
PLANNED_NON_COURSE_IND	Indicates whether the non-course is planned for an audit type of planning. Functional after Degree Works upgrade to 4.1.4.	VARCHAR2(1)	CALCULATION	CASE WHEN DAP_RESULT_TYPE = 'NONCRAPPLIED' AND AUDIT_TYPE = 'PL' AND SUBSTR(VALUE3,1,2) = 'PN'	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
RESULT_SEQUENCE_NUMBER	One up system generated sequence number associated to each result recorded for the block id in the order in which rules are processed for the audit.	NUMBER	DAP_RESULT_DTL	DAP_RESULT_SEQ_NUM	NO	NO
RULE_NON_COURSES_NEEDED	Number of non-courses still needed on the rule.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE2	NO	NO
STUDENT_CLASSIFICATION	Identifies the student's current class at the institution. The typical VALUES are first year, second year, or freshman, sophomore, etc..	VARCHAR2(63)	FUNCTION	SOKODSF.F_CLASS_CALC_FNC	NO	NO
STUDENT_CLASSIFICATION_DESC	Student classification description.	VARCHAR2(255)	STVLCLAS	STVCLAS_DESC	NO	NO
STUDENT_CLASSIFICATION_DESC_DW	Student classification description.	VARCHAR2(255)	CONSTANT	NULL	NO	NO
STUDENT_LEVEL	Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_SCHOOL	NO	NO
STUDENT_LEVEL_DESC	Course level description.	VARCHAR2(255)	STVLEVL	STVLEVL_DESC	NO	NO
STUDENT_LEVEL_DESC_DW	Student level description from Degree Works.	VARCHAR2(255)	UCX_STU350	UCX_VALUE	NO	NO
TAKE_TYPE	Determines if the course must be taken, or may be taken or can't be taken.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE4	NO	NO
TAKE_TYPE_DESC	Course take type description.	VARCHAR2(255)	FUNCTION	CASE WHEN DAP_VALUE4	NO	NO

Ver: 9.2