Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACADEMIC_PROGRAM_KEY	Key for the academic program dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
AGE	Calculated by a function that subtracts the birth date from the load date.	NUMBER	PERSON PERSON	FUNCTION FUNCTION	NO NO	NO	ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE
CONCENTRATION_COUNT	Number of concentrations in this academic program.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
CONCENTRATION_GROUP_KEY	Key for the concentration group dimension.	VARCHAR2(63)	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
CONCENTRATION_GROUP_NO_ORDER	Concentration group keys not by first, second etc but by alphabetical sequence.	VARCHAR2(63)	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
CONCENTRATION_KEY	Key for the concentration dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
CONCENTRATION_ORDER	Concentration sequence within this academic program - first, second, third etc.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
CONC_GROUP_NO_ORDER_DESC	Concentration group key description not by first, second etc but by alphabetical sequence.	VARCHAR2(4000)	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
CONC_MAJOR_COUNT	Number of concentrations within this major within this academic program.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
CONC_MAJOR_GROUP	Concentration group key within an associated major.	VARCHAR2(20)	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
CONC_MAJOR_GROUP_NO_ORDER	Concentration group keys within an associated major group not by first, second etc but by alphabetical sequence.	VARCHAR2(20)	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
CONC_MAJOR_GROUP_NO_ORDER_DESC	Concentration group key descriptions within an associated major group not by first, second etc but by alphabetical sequence.	VARCHAR2(4000)	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
CONC_MAJOR_ORDER	Concentration sequence within this major within this academic program - first, second, third etc.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
COURSE_KEY	Key for the course dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
COURSE_REFERENCE_NUMBER	System internally generated ID to uniquely identify the schedule offering.	VARCHAR2(63)	STUDENT_COURSE	COURSE_REFERENCE_NUMBER	NO	NO	ACADEMIC PROGRAM COURSE
CURRICULUM_PRIORITY_NUMBER	System internally generated ID to uniquely identify the curriculum priority.	NUMBER	ACADEMIC_STUDY	CURRICULUM_PRIORITY_NUMBER	NO	NO	ACADEMIC PROGRAM COURSE
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
ENROLLMENT_STATUS_KEY	Key for enrollment status dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
INSTRUCTOR_KEY	Key for the instructor dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
MAJOR_COUNT	Number of majors in this academic program.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
MAJOR_GROUP_KEY	Key for the major group dimension.	VARCHAR2(20)	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
MAJOR_GROUP_NO_ORDER	Major group keys not by first, second etc but by alphabetical sequence.	VARCHAR2(20)	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
MAJOR_GROUP_NO_ORDER_DESC	Major group key descriptions not by first, second etc but by alphabetical sequence.	VARCHAR2(4000)	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
MAJOR_KEY	Key for the major dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
MAJOR_ORDER	Major sequence within this academic program - first, second, third etc.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
MINOR_COUNT	Number of minors in this academic program.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
MINOR_GROUP_KEY	Key for the minor group dimension.	VARCHAR2(20)	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
MINOR_GROUP_NO_ORDER	Minor group keys not by first, second etc but by alphabetical sequence.	VARCHAR2(20)	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
MINOR_GROUP_NO_ORDER_DESC	Minor group key descriptions not by first, second etc but by alphabetical sequence.	VARCHAR2(4000)	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
MINOR_KEY	Key for the minor dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
MINOR_ORDER	Minor sequence within this academic program - first, second, third etc.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
PERSON_UID	System internally generated ID to uniquely identify the person.	NUMBER	PERSON PERSON	PERSON_UID PERSON_UID	NO NO	NO	ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE  ACADEMIC PROGRAM COURSE, ACADEMIC PROGRAM COURSE
REGISTRATION_KEY	Key for the registration dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE
TIME_KEY	Key for the time dimension.	NUMBER	ETL GENERATED	NA	NO	NO	ACADEMIC PROGRAM COURSE

Ver: 9.0