Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACADEMIC_STUDY_KEY	Key for the academic study dimension.	NUMBER	ETL GENERATED	NA	NO	NO	COURSE REGISTRATION
AGE	Calculated by a function that subtracts the birth date from the load date.	NUMBER	ETL GENERATED	NA	NO	NO	COURSE REGISTRATION
COURSE_KEY	Key for the course dimension.	NUMBER	ETL GENERATED	NA	NO	NO	COURSE REGISTRATION
COURSE_REFERENCE_NUMBER	System internally generated ID to uniquely identify the schedule offering.	VARCHAR2(63)	STUDENT_COURSE	COURSE_REFERENCE_NUMBER	NO	NO	COURSE REGISTRATION
CREDITS_ATTEMPTED	Number of credits attempted and used for the academic outcome requirement completion.	NUMBER	STUDENT_COURSE	CREDITS_ATTEMPTED	NO	NO	COURSE REGISTRATION
CREDITS_EARNED	Number of credits earned and used for the academic outcome requirement completion.	NUMBER	STUDENT_COURSE	CREDITS_EARNED	NO	NO	COURSE REGISTRATION
CREDITS_GENERATED	Sum credits assigned to the course based on the STUDENT_COURSE details. When totaled for all students it will be the number of credits generated for a time frame by attributes.	NUMBER	STUDENT_COURSE	COURSE_CREDITS	NO	NO	COURSE REGISTRATION
CREDITS_PASSED	Number of credits passed and used for the academic outcome requirement completion.	NUMBER	STUDENT_COURSE	CREDITS_PASSED	NO	NO	COURSE REGISTRATION
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL GENERATED	NA	NO	NO	COURSE REGISTRATION
ENROLLMENT_STATUS_KEY	Key for enrollment status dimension.	NUMBER	ETL GENERATED	NA	NO	NO	COURSE REGISTRATION
GPA_CREDITS	Number of credits to be used in the GPA calculation for courses used to complete the academic outcome requirements.	NUMBER	STUDENT_COURSE	CREDITS_FOR_GPA	NO	NO	COURSE REGISTRATION
INSTRUCTOR_KEY	Key for the instructor dimension.	NUMBER	ETL GENERATED	NA	NO	NO	COURSE REGISTRATION
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL GENERATED	NA	NO	NO	COURSE REGISTRATION
PERSON_UID	System internally generated ID to uniquely identify the person.	NUMBER	PERSON	PERSON_UID	NO	NO	COURSE REGISTRATION
QUALITY_POINTS	Number of quality points to be used in the GPA calculation for courses used to complete the academic outcome requirements.	NUMBER	STUDENT_COURSE	QUALITY_POINTS	NO	NO	COURSE REGISTRATION
REGISTRATION_KEY	Key for the registration dimension.	NUMBER	ETL GENERATED	NA	NO	NO	COURSE REGISTRATION
STUDENT_KEY	Key for the Student dimension.	NUMBER	ETL GENERATED	NA	NO	NO	COURSE REGISTRATION
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	COURSE REGISTRATION
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	COURSE REGISTRATION
TIME_KEY	Key for the time dimension.	NUMBER	ETL GENERATED	NA	NO	NO	COURSE REGISTRATION

Ver: 9.0