Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
ADVICE_DESC	Advice description.	VARCHAR2(255)	DAP_RESULT_DTL	DAP_FREETEXT	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_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_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)	DAP_REQ_BLOCK	TITLE	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)	DAP_RESULT_DTL	DAP_RULE_ID	NO	NO
BLOCK_RULE_LABEL	Label text uniquely identifying the rule within the block.	VARCHAR2(255)	DAP_RESULT_DTL	DAP_FREETEXT	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
COURSE_IDENTIFICATION	Course subject and course number combined.	VARCHAR2(63)	CALCULATION	DAP_VALUE1 || DAP_VALUE2	NO	NO
COURSE_NUMBER	Course number associated with the subject for the course.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE2	NO	NO
COURSE_TITLE_SHORT	Course title short.	VARCHAR2(255)	DAP_RESCLASS_DTL	DAP_COURSE_TITLE	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
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RAD_PRIMARY_MST	RAD_USER_DEF1	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_COURSES_NEEDED	Number of courses still needed on the rule.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE2	NO	NO
RULE_COURSE_REQUIRED	Number of courses originally required on the rule.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE2	NO	NO
RULE_CREDITS_NEEDED	Number of credits still needed on the rule.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE1	NO	NO
RULE_CREDITS_REQUIRED	Number of credits originally required on the rule.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE1	NO	NO
RULE_OPERATOR_NEEDED	Determines if the relationship between the courses and credits is an AND relationship or an OR relationship.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE3	NO	NO
RULE_OPERATOR_REQUIRED	Determines if the relationship between the courses and credits is an AND relationship or an OR relationship.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE3	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)	STVCLAS	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
SUBJECT	Main instructional subject area for this course.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE1	NO	NO
SUBJECT_DESC	Subject code description.	VARCHAR2(255)	STVSUBJ	STVSUBJ_DESC	NO	NO
SUBJECT_DESC_DW	Subject/discipline code description from Degree Works.	VARCHAR2(255)	UCX_STU352	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
WITH_ADVICE	Advice information.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_VALUE3	NO	NO

Ver: 9.2