Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACADEMIC_TIME_KEY	Key for the Academic Time dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT COURSE
COURSE_ATTEMPTED_HEADCOUNT	???? - email to MAC.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT COURSE
COURSE_CREDITS	Credits associated with this course.	NUMBER	STUDENT_COURSE	COURSE_CREDITS	NO	NO	STUDENT COURSE
COURSE_CREDITS_ATTEMPTED	Credits attempted as defined by the grading rules of the institution. In-progress or transfer courses may be defined not to add to the credits attempted.	NUMBER	STUDENT_COURSE	CREDITS_ATTEMPTED	NO	NO	STUDENT COURSE
COURSE_CREDITS_EARNED	Credits earned as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student.	NUMBER	STUDENT_COURSE	CREDITS_EARNED	NO	NO	STUDENT COURSE
COURSE_CREDITS_FOR_GPA	Credits used in the calculation of the average or GPA based on the rules of the institution.	NUMBER	STUDENT_COURSE	CREDITS_FOR_GPA	NO	NO	STUDENT COURSE
COURSE_CREDITS_PASSED	Credits passed as defined by the grading rules of the institution. This number must be calculated by the system after the final grade is recorded for the student.	NUMBER	STUDENT_COURSE	CREDITS_PASSED	NO	NO	STUDENT COURSE
COURSE_DROPPED_HEADCOUNT	???? - email to MAC.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT COURSE
COURSE_FAILED_HEADCOUNT	???? - email to MAC.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT COURSE
COURSE_FEEDBACK_GROUP_KEY	Unique identifier for all the faculty feedback the person in a student course.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT COURSE
COURSE_IDENTIFICATION_SECTION	Concated column that combines the course identification (subject and course number) with the course section number created to indentify a distinct schedule offering within an academic period. For Example, ENG:110_001.	VARCHAR2(320)	CALCULATION	COURSE_IDENTIFICATION ||'_' || NVL(OFFERING_NUMBER, PARM_REC.MTVPARM_EXTERNAL_CODE);	NO	NO
COURSE_INTREGISTERED_HEADCOUNT	INsTitution Registered Headcount is set to person_uid when the course is one that is either a) currently in progress at this institution, or b) has been completed and graded at this institution.	NUMBER	FUNCTION	CASE WHEN STUDENT_COURSE_REC.IN_PROGRESS_COURSE_IND = 1 THEN RET_ROW.COURSE_INTREGISTERED_HEADCOUNT := STUDENT_COURSE_REC.WAREHOUSE_ENTITY_UID; WHEN STUDENT_COURSE_REC.INSTITUTION_COURSE_IND = 1 THEN RET_ROW.COURSE_INTREGISTERED_HEADCOUNT := ST	NO	NO
COURSE_KEY	Key for the course dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT COURSE
COURSE_PASSED_HEADCOUNT	???? - email to MAC.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT COURSE
COURSE_REFERENCE_NUMBER_KEY	Key for the course reference number dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT COURSE
COURSE_REGISTERED_HEADCOUNT	???? - email to MAC.	NUMBER	FUNCTION	IF STUDENT_COURSE_REC.COURSE_REGISTER_IND ='Y' THEN RET_ROW.COURSE_REGISTERED_HEADCOUNT := STUDENT_COURSE_REC.WAREHOUSE_ENTITY_UID	NO	NO
COURSE_SECTION_KEY	Key for the Course Section dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT COURSE
COURSE_WITHDRAWN_HEADCOUNT	???? - email to MAC.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT COURSE
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT COURSE
DEVELOPMENTAL_COURSE_IND	Institution defined value which indicates if a course is considered a remedial or developmental course.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT COURSE
FINAL_GRADE	Final grade earned by the student for this course.	VARCHAR2(63)	STUDENT_COURSE	FINAL_GRADE	NO	NO	STUDENT COURSE
FINAL_GRADE_CHANGE_KEY	??.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT COURSE
FINAL_GRADE_DATE	Date associated with this grade.	DATE	STUDENT_COURSE	FINAL_GRADE_DATE	NO	NO	STUDENT COURSE
FINAL_GRADE_QUALITY_POINTS	Quality points associated with the final grade.	NUMBER	STUDENT_COURSE	QUALITY_POINTS	NO	NO	STUDENT COURSE
GRADE_CHANGE_COUNT	Number of grade changes recorded for this student for this course.	NUMBER	FUNCTION	SELECT COUNT(*) COUNT_NO FROM MST_STUDENT_COURSE_GRADE_CHG WHERE PERSON_UID = PERSON_IN AND ACADEMIC_PERIOD = ACADEMIC_PERIOD_IN AND COURSE_REFERENCE_NUMBER = COURSE_REFERENCE_NUMBER_IN AND NVL(MIF_VALUE, DEF_MULT	NO	NO
GRADE_CHANGE_GROUP_KEY	Unique identifier for all the grade changes done for the person in a student course.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT COURSE
INITIAL_REGISTRATION_DATE	Date associated with the initial course registration status of this section.	DATE	STUDENT_COURSE	SECTION_ADD_DATE	NO	NO	STUDENT COURSE
INSTITUTION_COURSE_IND	Indicates whether the subject or course was taken at this institution and is in academic history.	NUMBER	STUDENT_COURSE	INSTITUTION_COURSE_IND	NO	NO	STUDENT COURSE
INSTRUCTOR_GROUP_KEY	Unique identifier for all the instructors for the course (CRN) for the academic period.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT COURSE
INSTRUCTOR_KEY	Key for the Instructor dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT COURSE
IN_PROGRESS_COURSE_IND	Indicates whether the course is in progress and not yet graded.	NUMBER	STUDENT_COURSE	IN_PROGRESS_COURSE_IND	NO	NO	STUDENT COURSE
MEETING_TIME_GROUP_KEY	Unique identifier for all the meeting times associated with at student course.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT COURSE
MID_TERM_GRADE	Mid-term grade code associated with this CRN.	VARCHAR2(63)	STUDENT_COURSE	MID_TERM_GRADE	NO	NO	STUDENT COURSE
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT COURSE
PERSON_UID	Key for the Person dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT COURSE
REGISTRATION_KEY	Key for the Registration dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT COURSE
REGISTRATION_STATUS_DATE	Date associated with the latest course registration status of this section.	DATE	STUDENT_COURSE	REGISTRATION_STATUS_DATE	NO	NO	STUDENT COURSE
REPEAT_COURSE_IND	Identifies this course appears in more than one academic period for the student. Valid values in this data include'E' exclude in any calculations,'I' include in all calculations, or'A' average in all calculations.	NUMBER	STUDENT_COURSE	REPEAT_COURSE_IND	NO	NO	STUDENT COURSE
SOURCE_TYPE	Identifies if this course is in registration, in institutional history or a transfer course.	VARCHAR2(63)	ETL GENERATED	NA	NO	NO	STUDENT COURSE
SPECIAL_APPROVAL_IND	Indicates whether special approval was received to register in this section.	NUMBER	STUDENT_COURSE	SPECIAL_APPROVAL_IND	NO	NO	STUDENT COURSE
STUDENT_COURSE_ATTR_GROUP_KEY	Unique identifier for all the student course attributes for a student course taken by a person.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT COURSE
STUDENT_COURSE_COUNT_KEY	Unique key to count Student Course for a person.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT COURSE
STUDENT_COURSE_GROUP_KEY	Unique identifier for all the student course for a persons.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT COURSE
SUB_ACADEMIC_PERIOD_KEY	Key for the Sub Academic Period dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT COURSE
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL_GENERATED	NA	NO	NO	STUDENT COURSE
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL_GENERATED	NA	NO	NO	STUDENT COURSE
TRANSFER_COURSE_IND	Indicates whether this course was taken at and transferred from another post secondary institution.	NUMBER	STUDENT_COURSE	TRANSFER_COURSE_IND	NO	NO	STUDENT COURSE

Ver: 9.0