Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACADEMIC_OUTCOME_GROUP_KEY	Key for the academic outcome group.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
ACADEMIC_OUTCOME_ROLL_KEY	Number associated with the specific academic outcome record that was created when the priority curriculum was rolled to history.	NUMBER	STUDENT	OUTCOME_NUMBER	NO	NO	STUDENT
ACADEMIC_PERIOD_FRSTATTEND_KEY	Key for the academic time dimension that identifies the first academic period that the student attended this institution at the student level by finding the earliest academic period with a student course that has a source type of history or registration. In Banner this is the minimum term with either an SFRSTCR or SHRTCKN record for the person at the student level.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
ACADEMIC_PERIOD_GPA	Student's academic period GPA includes all completed student courses within this academic period only.	NUMBER	GPA_BY_LEVEL	GPA	NO	NO	STUDENT
ACADEMIC_PERIOD_LASTATTEND_KEY	Specifies the latest academic period that the student attended this institution by verifying there are course in history or current registration for the highest academic period value.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
ACADEMIC_STANDING_END_DATE	Date the end of academic period academic standing from the history record was last calculated or manually updated for this student.	DATE	FUNCTION	TO_DATE(MSKFUNC.F_ACADEMIC_STAND_DATA(PERSON_IN, Y.ACADEMIC_PERIOD, LEVEL_IN,'ACADEMIC_STANDING_END_DT'),'YYYYMMDD')	NO	NO
ACADEMIC_STUDY_KEY	Key for the academic study dimension.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
ACADEMIC_TIME_KEY	Key for the academic time dimension.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
ACADEMIC_YEAR_GPA	Student's academic year GPA includes all completed student courses within all academic periods associated with the specific academic year.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
ACAD_PERIOD_ATTEND_COUNT	Count of the number of academic periods the student attended the institution at the student level as a running total to this academic period. Each academic period with one student course in either history or registration will increment the count by one.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
ACAD_STUDY_REGISTERED_IN_COUNT	Number of academic periods where an attribute of the academic study was changed to a different value than the prior academic period. Changes apply within the student level to a change in program, college, degree or major.	NUMBER	STUDENT	ACAD_STUDY_REGISTERED_IN_COUNT	NO	NO	STUDENT
ADMIT_AGE	Age of the student at time of admission. This is calculated using the student birthdate compared to the start date for the academic period admit recorded for this student.	NUMBER	ACADEMIC_STUDY	AGE_ADMITTED	NO	NO	STUDENT
APPLICATION_POSTAL_KEY	Key for application postal dimension.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
CHANGED_MAJOR_COUNT	Number of different major codes recorded since the academic period first attended for this student.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
COURSE_ATTEMPTED_COUNT	Number of student courses attempted by the student.	NUMBER	WFT_STUDENT_COURSE	COURSE_ATTEMPTED_HEADCOUNT	NO	NO	STUDENT
COURSE_DROP_COUNT	Number of student courses dropped by the student as identified by the course registration status on the course section record.	NUMBER	WFT_STUDENT_COURSE	COURSE_DROPPED_HEADCOUNT	NO	NO	STUDENT
COURSE_FAILED_COUNT	Number of student courses failed by the student as identified by the final grade having a no in a credits passed indicator.	NUMBER	WFT_STUDENT_COURSE	COURSE_FAILED_HEADCOUNT	NO	NO	STUDENT
COURSE_IN_PROGRESS_COUNT	Number of student courses retrieved as registered courses.	NUMBER	FUNCTION	COUNT(*) FROM WFT_STUDENT_COURSE	NO	NO	STUDENT
COURSE_PASSED_COUNT	Number of student courses pased by the student as identified by the final grade having a yes in a credits passed indicator.	NUMBER	WFT_STUDENT_COURSE	COURSE_PASSED_HEADCOUNT	NO	NO	STUDENT
COURSE_WITHDRAWN_COUNT	Number of student courses withdrawn by the student as identified by the course registration status on the course section record.	NUMBER	WFT_STUDENT_COURSE	COURSE_WITHDRAWN_HEADCOUNT	NO	NO	STUDENT
CUMULATIVE_CREDITS_ATTEMPTED	Cumulative credits attempted based on the final grades for the student courses taken by the student.	NUMBER	FUNCTION	SUM(F.COURSE_CREDITS_ATTEMPTED ) CUMULATIVE_CREDITS_ATTEMPTED,	NO	NO
CUMULATIVE_CREDITS_EARNED	Students cumulative GPA that includes all completed student courses through this academic period.	NUMBER	FUNCTION	SUM(F.COURSE_CREDITS_EARNED ) CUMULATIVE_CREDITS_EARNED,	NO	NO
CUMULATIVE_CREDITS_FOR_GPA	Cumulative credits used in the GPA calculation based on the final grades for the student courses taken by the student.	NUMBER	FUNCTION	SUM(F.COURSE_CREDITS_FOR_GPA ) CUMULATIVE_CREDITS_FOR_GPA	NO	NO
CUMULATIVE_CREDITS_PASSED	Cumulative credits passed based on the final grades for the student courses taken by the student.	NUMBER	FUNCTION	SUM(F.COURSE_CREDITS_PASSED ) CUMULATIVE_CREDITS_PASSED,	NO	NO
CUMULATIVE_GPA	Student's cumulative GPA that includes all completed student courses through this academic period.	NUMBER	GPA_BY_LEVEL	GPA	NO	NO	STUDENT
CUMULATIVE_QUALITY_POINTS	Cumulative quality points based on the final grades for the student courses taken by the student.	NUMBER	FUNCTION	SUM(F.FINAL_GRADE_QUALITY_POINTS ) CUMULATIVE_QUALITY_POINTS,	NO	NO
CURRENT_TIME_STATUS_DATE	Date the last system calculated or manually assigned time status record was created for the student in this academic period.	DATE	ENROLLMENT	CURRENT_TIME_STATUS_DATE	NO	NO	STUDENT
CURRICULUM_ORDER	Order of curriculum assigned by the system when multiple curriculums are recorded for a student. Determined by examining the active and current indicators on the curriculum rows along with the institution assigned curriculum priority to determine the main curriculum.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
CURRICULUM_PRIORITY	Institution assigned curriculum priority when creating multiple or concurrent curriculum records for a student. These numbers do not need to be sequential but the lowest number is considered the primary curriculum.	NUMBER	FIELD_OF_STUDY	CURRICULUM_PRIORITY	NO	NO	STUDENT
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
DEVELOPMENTAL_COURSE_IND	Institution defined value which indicates if a course is considered a remedial or developmental course.	NUMBER	WFT_STUDENT_COURSE	DEVELOPMENTAL_COURSE_IND	NO	NO	STUDENT
END_DATE	End date for the academic period last attended recorded for this student.	DATE	ETL GENERATED	NA	NO	NO	STUDENT
ENROLLMENT_STATUS_DATE	Date the academic period enrollment status code was assigned.	DATE	ENROLLMENT	ENROLLMENT_STATUS_DATE	NO	NO	STUDENT
ENROLLMENT_STATUS_KEY	Key for enrollment status dimension.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
EXPECTED_GRAD_DATE	Date recorded when the student is expected graduate based on the student population (new or transfer), student time status (full or part time) and the academic period first attended that is manually input by the institution.	DATE	ACADEMIC_STUDY	EXPECTED_GRADUATION_DATE	NO	NO	STUDENT
FINANCIAL_AID_STATUS_KEY	Key for financial aid status dimension.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
FINANCIAL_AID_YEAR_KEY	Key for financial aid year dimension.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
FTE_DIVISOR	Normal student credit load for this academic period.	NUMBER	ACADEMIC_STUDY	FTE_DIVISOR	NO	NO	STUDENT
GEOGRAPHIC_REGION_KEY	Key for the geographic region dimension.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
INITIAL_ENROLL_STATUS_DATE	Date the student was first enrolled in an academic period that will not change when a new enrollment status is assigned and the enrollment status date is updated.	DATE	ENROLLMENT	ENROLLMENT_ADD_DATE	NO	NO	STUDENT
LEAVE_FROM_DATE	Date the student was approved to officially be on leave from the institution.	DATE	ACADEMIC_STUDY	LEAVE_DATE_FROM	NO	NO	STUDENT
LEAVE_TO_DATE	Date the student was approved to officially return from leave to continue attending the institution.	DATE	ACADEMIC_STUDY	LEAVE_DATE_TO	NO	NO	STUDENT
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
OUTCOME_APPLICATION_DATE	Date the student officially applied for graduation and degree compliance verification.	DATE	ACADEMIC_OUTCOME	OUTCOME_APPLICATION_DATE	NO	NO	STUDENT
OUTCOME_GRADUATION_DATE	Date the outcome (award, degree, certificate, etc.) was officially awarded.	DATE	ACADEMIC_OUTCOME	OUTCOME_GRADUATION_DATE	NO	NO	STUDENT
PERSON_UID	Key for the person dimension.	NUMBER	STUDENT	PERSON_UID	NO	NO	STUDENT
POSTAL_KEY	Key for the postal dimension.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
PREVIOUS_ACADEMIC_PERIOD_GPA	Student's academic period GPA includes all completed student courses within the academic period that was just prior to this academic period.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
PRE_STUDENT_STATUS_KEY	Key for the pre-student status dimension.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
RACE_GROUP_KEY	Key for race group dimension.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
RETENTION_LIKE_KEY	Key for retention like dimension.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
RETENTION_SEQUENTIAL_KEY	Key for retention sequential dimension.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
RETENTION_TIME_KEY	Key for the retention time dimension.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
START_DATE	Start date for the academic period first attended recorded for this student.	DATE	ACADEMIC_STUDY	START_DATE	NO	NO	STUDENT
START_DATE_ADMITTED	Start date for the academic period admitted recorded for this student.	DATE	ACADEMIC_STUDY	START_DATE_ADMITTED	NO	NO	STUDENT
START_DATE_MATRICULATED	Start date for the academic period matriculated recorded for this student.	DATE	ACADEMIC_STUDY	START_DATE_MATRICULATED	NO	NO	STUDENT
STREET_LINE_KEY	Key for street line dimension.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
STUDENT_COURSE_GROUP_KEY	Key for the student course group.	NUMBER	WFT_STUDENT_COURSE	STUDENT_COURSE_GROUP_KEY	NO	NO	STUDENT
STUDENT_FTE	Calculated value the uses the academic period registered credits divided by the normal full time student credit load to specify the portion of an FTE this student represents in this academic period. For example if this student has 15 credits and a normal credit load is 12, this student would be 1.25 FTE.	NUMBER	ACADEMIC_STUDY	STUDENT_FTE	NO	NO	STUDENT
STUDENT_KEY	Key for the Student dimension.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
STUDENT_LEVEL	Level of study for the students program or course work. For example, Undergraduate, Graduate, Credit, Continuing Education, etc.	VARCHAR2(63)	ACADEMIC_STUDY	STUDENT_LEVEL	NO	NO	STUDENT
STUDENT_PERFORMANCE_KEY	Key for student performance dimension.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
STUDENT_STATUS_KEY	Key for student status dimension.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
SYSTEM_LOAD_PROCESS	Name of the transformation that created the row during the load activity process.	VARCHAR2(30)	ETL GENERATED	NA	NO	NO	STUDENT
SYSTEM_LOAD_TMSTMP	Most current date this record was created or updated.	DATE	ETL GENERATED	NA	NO	NO	STUDENT
TOTAL_ACAD_PERIOD_ATTEND_COUNT	Count of the number of academic periods this student attended the institution. Each academic period in history and the current registration are counted as one regardless of its relationship to this academic period. So if the student attend 5 through and 2 after this academic period the total academic periods attended count would equal 7.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT
TOTAL_CREDITS	Sum of the registered credits for the student for this academic period.	NUMBER	FUNCTION	SUM(COURSE_CREDITS )	NO	NO	STUDENT
TOTAL_CREDITS_ATTEMPTED	Total credits attempted based on the final grades for the student courses taken by the student.	NUMBER	FUNCTION	SUM(COURSE_CREDITS_ATTEMPTED ) TOTAL_CREDITS_ATTM,	NO	NO
TOTAL_CREDITS_EARNED	Total credits earned based on the final grades for the student courses taken by the student.	NUMBER	FUNCTION	SUM(COURSE_CREDITS_EARNED ) TOTAL_CREDITS_EARN,	NO	NO
TOTAL_CREDITS_FOR_GPA	Total credits used in the GPA calculation based on the final grades for the student courses taken by the student.	NUMBER	FUNCTION	SUM(COURSE_CREDITS_FOR_GPA ) TOT_CRED_GPA	NO	NO
TOTAL_CREDITS_PASSED	Total credits passed based on the final grades for the student courses taken by the student.	NUMBER	FUNCTION	SUM(COURSE_CREDITS_PASSED ) TOTAL_CREDITS_PASS,	NO	NO
TOTAL_QUALITY_POINTS	Total quality points based on the final grades for the student courses taken by the student.	NUMBER	FUNCTION	SUM(FINAL_GRADE_QUALITY_POINTS ) FINAL_GRD_QLTY_PNTS,	NO	NO
UNDECLARED_MAJOR_COUNT	Number of academic periods prior to the academic period when a major code other than the one specified in the institution undeclared major code rule. So if the rule using'0000' as undeclared and the student attended four academic period with that code and in the fifth academic period changed to'HIST', the undeclared major count would equal 4.	NUMBER	ETL GENERATED	NA	NO	NO	STUDENT

Ver: 9.0