| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
Star Name |
|
ADMINISTRATION_KEY
|
Key for the administration dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYEE DEGREE
|
|
AGE
|
Calculated by a function that subtracts the birth date from the load date.
|
NUMBER
|
|
|
|
NO
|
|
|
DEMOGRAPHIC_KEY
|
Key for the demographic dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYEE DEGREE
|
|
EMPLOYEE_KEY
|
Key for the employee dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYEE DEGREE
|
|
FINAL_DEGREE_IND
|
Final degree indicator.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYEE DEGREE
|
|
FINAL_DEGREE_IND
|
NULL
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYEE DEGREE
|
|
INSTITUTION_KEY
|
Key for the institution dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYEE DEGREE
|
|
MULTI_SOURCE_KEY
|
Key for the multi source dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYEE DEGREE
|
|
PERSON_UID
|
System internally generated ID to uniquely identify the person.
|
NUMBER
|
EMPLOYEE
|
PERSON_UID
|
NO
|
NO
|
EMPLOYEE DEGREE
|
|
POST_SECONDARY_SCHOOL_KEY
|
Key for the post secondary school dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYEE DEGREE
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYEE DEGREE
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYEE DEGREE
|
|
TIME_KEY
|
Key for the time dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYEE DEGREE
|