| 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
|
RECRUITING AND ADMISSION
|
|
AGE
|
Calculated by a function that subtracts the birth date from the load date.
|
NUMBER
|
PERSON PERSON
|
FUNCTION FUNCTION
|
NO NO
|
NO
|
RECRUITING AND ADMISSION, RECRUITING AND ADMISSION RECRUITING AND ADMISSION, RECRUITING AND ADMISSION
|
|
COHORT_KEY
|
Key for the cohort dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
CONTACT_KEY
|
Key for the contact dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
DEMOGRAPHIC_KEY
|
Key for the demographic dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
EMPLOYMENT_HISTORY_KEY
|
Key for the employment history dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
FINAL_DEGREE_IND
|
Final degree indicator.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
FINANCIAL_AID_STATUS_KEY
|
Key for the financial aid status dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
MULTI_SOURCE_KEY
|
Key for the multi source dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
PERSON_UID
|
System internally generated ID to uniquely identify the person.
|
NUMBER
|
ADMISSIONS_APPLICATION
|
PERSON_UID
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
POSTAL_KEY
|
Key for the postal dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
POST_SECONDARY_SCHOOL_KEY
|
Key for the post secondary school dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
PRE_STUDENT_KEY
|
Key for the pre-student dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
PRE_STUDENT_STATUS_KEY
|
Key for the pre-student status dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
PS_INSTITUTION_KEY
|
Key for the post secondary school dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
SECONDARY_SCHOOL_KEY
|
Key for the secondary school dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
SEQUENCE_NUMBER
|
Student application sequence number.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
SS_INSTITUTION_KEY
|
Key for the secondary school dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
STUDENT_APPLICATION_KEY
|
Key for the student application dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
STUDENT_KEY
|
Key for the Student dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECRUITING AND ADMISSION
|
|
TIME_KEY
|
Key for the time dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
RECRUITING AND ADMISSION
|