| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
ACADEMIC_PERIOD_FRSTATTEND_KEY
|
Key for the academic time dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
GRADUATION COMPLETION
|
|
ACADEMIC_STUDY_KEY
|
Key for the academic study dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
GRADUATION COMPLETION
|
|
ACTIVE_ACADEMIC_PERIODS
|
Calculated number of academic periods in that the student enrolled and completed coursework applied toward this graduation record.
|
NUMBER
|
CONSTANT
|
0
|
NO
|
NO
|
GRADUATION COMPLETION
|
|
ACTIVE_ACADEMIC_YEARS
|
Average number of years the student has registered for courses prior to completing an outcome, degree or award and graduated.
|
NUMBER
|
FUNCTION
|
COUNT OF WDT_WAREHOUSE_ENTITY.WAREHOUSE_ENTITY_UID WHERE THAT PERSON HAS A RECORD IN MST_ENROLLMENT AND MST_ACADEMIC_OUTCOME JOIN PERSON_UID AND ACADEMIC_YEAR (ACADEMIC_YEAR_GRADUATION)
|
NO
|
NO
|
GRADUATION COMPLETION
|
|
AGE
|
Calculated by a function that subtracts the birth date from the load date.
|
NUMBER
|
CALCULATION
|
FUNCTION
|
NO
|
NO
|
GRADUATION COMPLETION
|
|
CREDITS_ATTEMPTED
|
Number of credits attempted and used for the academic outcome requirement completion.
|
NUMBER
|
ACADEMIC_OUTCOME
|
CREDITS_ATTEMPTED
|
NO
|
NO
|
GRADUATION COMPLETION
|
|
CREDITS_EARNED
|
Number of credits earned and used for the academic outcome requirement completion.
|
NUMBER
|
ACADEMIC_OUTCOME
|
CREDITS_EARNED
|
NO
|
NO
|
GRADUATION COMPLETION
|
|
CREDITS_PASSED
|
Number of credits passed and used for the academic outcome requirement completion.
|
NUMBER
|
ACADEMIC_OUTCOME
|
CREDITS_PASSED
|
NO
|
NO
|
GRADUATION COMPLETION
|
|
DEMOGRAPHIC_KEY
|
Key for the demographic dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
GRADUATION COMPLETION
|
|
GPA_CREDITS
|
Number of credits to be used in the GPA calculation for courses used to complete the academic outcome requirements.
|
NUMBER
|
ACADEMIC_OUTCOME
|
GPA_CREDITS
|
NO
|
NO
|
GRADUATION COMPLETION
|
|
GRADUATION_KEY
|
Key for the graduation dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
GRADUATION COMPLETION
|
|
INSTITUTION_KEY
|
Key for the institution dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
GRADUATION COMPLETION
|
|
MULTI_SOURCE_KEY
|
Key for the multi source dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
GRADUATION COMPLETION
|
|
OUTCOME_NUMBER
|
Outcome sequence number.
|
NUMBER
|
ACADEMIC_OUTCOME
|
OUTCOME_NUMBER
|
NO
|
NO
|
GRADUATION COMPLETION
|
|
PERSON_UID
|
System internally generated ID to uniquely identify the person.
|
NUMBER
|
PERSON
|
PERSON_UID
|
NO
|
NO
|
GRADUATION COMPLETION
|
|
POSTAL_KEY
|
Key for the postal dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
GRADUATION COMPLETION
|
|
QUALITY_POINTS
|
Number of quality points to be used in the GPA calculation for courses used to complete the academic outcome requirements.
|
NUMBER
|
ACADEMIC_OUTCOME
|
QUALITY_POINTS
|
NO
|
NO
|
GRADUATION COMPLETION
|
|
STUDENT_KEY
|
Key for the Student dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
GRADUATION COMPLETION
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
GRADUATION COMPLETION
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
GRADUATION COMPLETION
|
|
TIME_KEY
|
Key for the time dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
GRADUATION COMPLETION
|