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
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_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 CONSTANT CONSTANT DAP_REQ_BLOCK	'FALL-THROUGH COURSES' 'INSUFFICIENT COURSES' 'OVER-THE-LIMIT COURSES' TITLE	NO NO NO NO	NO
BLOCK_GPA	Block grade point average.	NUMBER	CONSTANT DAP_RESULT_DTL	0 DAP_NUMBER2	NO NO	NO
BLOCK_ID	Block identification grouping a set of requirements.	VARCHAR2(63)	DAP_RESULT_DTL	DAP_REQ_ID	NO	NO
BLOCK_QUALITY_POINTS	Block quality points used in GPA calculation.	NUMBER	DAP_RESULT_DTL	DAP_NUMBER3	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
BLOCK_TYPE	Block categorization such as Degree, Major, Minor, Concentration, etc.	VARCHAR2(63)	DAP_REQ_BLOCK DAP_RESULT_DTL	BLOCK_TYPE DAP_REQ_ID	NO NO	NO
BLOCK_TYPE_DESC	Block type description.	VARCHAR2(255)	CONSTANT CONSTANT CONSTANT UCX_SCR004	'FALL-THROUGH COURSES' 'INSUFFICIENT COURSES' 'OVER-THE-LIMIT COURSES' UCX_VALUE	NO NO NO NO	NO
BLOCK_VALUE	Value of the degree or major like BA for Bachelor of Arts degree or ANTH for a major in anthropology.	VARCHAR2(63)	DAP_REQ_BLOCK	BLOCK_VALUE	NO	NO
BLOCK_VALUE_DESC	Block value description.	VARCHAR2(255)	CONSTANT CONSTANT CONSTANT DAP_REQ_BLOCK	'FALL-THROUGH COURSES' 'INSUFFICIENT COURSES' 'OVER-THE-LIMIT COURSES' TITLE	NO NO NO NO	NO
CATALOG_YEAR_END	Last catalog year where the degree requirements were defined for the institution.	VARCHAR2(63)	DAP_REQ_BLOCK	PERIOD_STOP	NO	NO
CATALOG_YEAR_END_DESC	Catalog year end description.	VARCHAR2(255)	STVACYR	STVACYR_DESC	NO	NO
CATALOG_YEAR_START	Earliest catalog year where the degree requirements were defined for the institution.	VARCHAR2(63)	DAP_REQ_BLOCK	PERIOD_START	NO	NO
CATALOG_YEAR_START_DESC	Catalog year start description.	VARCHAR2(255)	STVACYR	STVACYR_DESC	NO	NO
COURSES_APPLIED	Number of courses counted.	NUMBER	DAP_RESULT_DTL	DAP_NUMBER2	NO	NO
COURSES_APPLIED_RANGE	Range that the number of block courses counted falls within based upon pre-defined cleansing rules.	VARCHAR2(63)	ETL GENERATED	NA	NO	NO
COURSES_APPLIED_RANGE_DESC	Courses applied range description.	VARCHAR2(255)	ETL GENERATED	NA	NO	NO
COURSES_APPLIED_RANGE_ORDER	Courses applied range order concatenated with courses applied range description.	VARCHAR2(255)	ETL GENERATED	NA	NO	NO
COURSES_NEEDED	Number of courses needed.	NUMBER	CONSTANT DAP_RESULT_DTL	0 DAP_NUMBER2	NO NO	NO
COURSES_NEEDED_RANGE	Range that the number of block courses needed falls within based upon pre-defined cleansing rules.	VARCHAR2(63)	ETL GENERATED	NA	NO	NO
COURSES_NEEDED_RANGE_DESC	Courses needed range description.	VARCHAR2(255)	ETL GENERATED	NA	NO	NO
COURSES_NEEDED_RANGE_ORDER	Courses needed range order concatenated with courses needed range description.	VARCHAR2(255)	ETL GENERATED	NA	NO	NO
COURSES_REQUIRED	Minimum number of courses that must be taken.	NUMBER	DAP_RESULT_DTL	DAP_NUMBER2	NO	NO
CREDITS_APPLIED	Number of credits counted.	NUMBER	DAP_RESULT_DTL	DAP_NUMBER1	NO	NO
CREDITS_APPLIED_RANGE	Range that the number of block credits counted falls within based upon pre-defined cleansing rules.	VARCHAR2(63)	ETL GENERATED	NA	NO	NO
CREDITS_APPLIED_RANGE_DESC	Credits applied range description.	VARCHAR2(255)	ETL GENERATED	NA	NO	NO
CREDITS_APPLIED_RANGE_ORDER	Credits applied range order concatenated with credits applied range description.	VARCHAR2(255)	ETL GENERATED	NA	NO	NO
CREDITS_NEEDED	Number of credits needed.	NUMBER	CONSTANT DAP_RESULT_DTL	0 DAP_NUMBER1	NO NO	NO
CREDITS_NEEDED_RANGE	Range that the number of block credits needed falls within based upon pre-defined cleansing rules.	VARCHAR2(63)	ETL GENERATED	NA	NO	NO
CREDITS_NEEDED_RANGE_DESC	Credits needed range description.	VARCHAR2(255)	ETL GENERATED	NA	NO	NO
CREDITS_NEEDED_RANGE_ORDER	Credits needed range order concatenated with credits needed range description.	VARCHAR2(255)	ETL GENERATED	NA	NO	NO
CREDITS_PCT_CMPLETE_RANGE_DESC	Credits percent complete range description.	VARCHAR2(255)	ETL GENERATED	NA	NO	NO
CREDITS_PCT_CMPLTE_RANGE_ORDER	Credits percent complete range order concatenated with credits percent range description.	VARCHAR2(255)	ETL GENERATED	NA	NO	NO
CREDITS_PCT_COMPLETE_RANGE	Range that the block percent credits complete falls within based upon pre-defined ODS EXTRACT PARAMETERS.	VARCHAR2(63)	ETL GENERATED	NA	NO	NO
CREDITS_PERCENT_COMPLETE	Block credits percent complete.	NUMBER	CONSTANT	0	NO	NO
CREDITS_REQUIRED	Minimum number of credits that must be taken.	NUMBER	DAP_RESULT_DTL	DAP_NUMBER2	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
GPA_RANGE	Range that the block GPA falls within based upon pre-defined ODS EXTRACT PARAMETERS.	VARCHAR2(63)	ETL GENERATED	NA	NO	NO
GPA_RANGE_DESC	GPA range description.	VARCHAR2(255)	ETL GENERATED	NA	NO	NO
GPA_RANGE_ORDER	GPA range order concatenated with GPA range description.	VARCHAR2(255)	ETL GENERATED	NA	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
MINIMUM_GPA	Minimum GPA required for the block.	NUMBER	DAP_RESULT_DTL	DAP_NUMBER2	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
OVERFLOW_CREDITS	Fall-through overflow credits. Used in calculation block percentage of credit completed for block sequence 1.	NUMBER	DAP_RESULT_DTL	DAP_NUMBER4	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
REQUIRE_PCT_CMPLETE_RANGE_DESC	Requirements percent complete range description.	VARCHAR2(255)	ETL GENERATED	NA	NO	NO
REQUIRE_PCT_CMPLTE_RANGE_ORDER	Requirements percent complete range order concatenated with requirements percent range description.	VARCHAR2(255)	ETL GENERATED	NA	NO	NO
REQUIRE_PCT_COMPLETE_RANGE	Range that the block percent requirements complete falls within based upon pre-defined ODS EXTRACT PARAMETERS.	VARCHAR2(63)	ETL GENERATED	NA	NO	NO
REQUIRE_PERCENT_COMPLETE	Block requirements percent complete.	NUMBER	CONSTANT DAP_RESULT_DTL	0 DAP_NUMBER1	NO 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 from Degree Works.	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	Student 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

Ver: 9.2