| 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
|
EMPLOYMENT APPLICATION
|
|
AGE
|
Calculated by a function that subtracts the birth date from the load date.
|
NUMBER
|
CALCULATION
|
FUNCTION
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
|
DEMOGRAPHIC_KEY
|
Key for the demographic dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
|
DESIRED_HOURLY_SALARY
|
Hourly rate requested by the applicant.
|
NUMBER
|
HR_APPLICATION
|
DESIRED_HOURLY
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
|
DESIRED_YEARLY_SALARY
|
Annual salary requested by the applicant.
|
NUMBER
|
HR_APPLICATION
|
DESIRED_SALARY
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
|
EMPLOYMENT_HISTORY_KEY
|
Key for the employment history dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
|
FINAL_DEGREE_IND
|
Final degree indicator.
|
NUMBER
|
CALCULATION
|
" IF PREV_EDUCATION_REC.PERSON_UID IS NULL THEN RET_ROW.FINAL_DEGREE_IND := 0; ELSE RET_ROW.FINAL_DEGREE_IND := 1; END IF;"
|
NO
|
NO
|
|
|
HR_APPLICANT_KEY
|
Key for the HR applicant dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
|
HR_APPLICANT_STATUS_KEY
|
Key for the HR applicant status dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
|
HR_REQUISITION_KEY
|
Key for the HR requisition dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
|
MULTI_SOURCE_KEY
|
Key for the multi source dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
|
PERSON_UID
|
System internally generated ID to uniquely identify the person.
|
NUMBER
|
HR_APPLICATION
|
PERSON_UID
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
|
POSITION_KEY
|
Key for the position dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
|
POST_SECONDARY_SCHOOL_KEY
|
Key for the post secondary school dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
|
PREVIOUS_MONTHS_OF_SERVICE
|
Months of service in most recent prior employment.
|
NUMBER
|
EMPLOYMENT_HISTORY
|
MONTHS_IN_POSITION
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
|
PREVIOUS_YEARLY_SALARY
|
Annual salary in most recent prior employment.
|
NUMBER
|
EMPLOYEE_POSITION EMPLOYMENT_HISTORY
|
ANNUAL_SALARY CURRENT_SALARY
|
NO NO
|
NO
|
EMPLOYMENT APPLICATION EMPLOYMENT APPLICATION
|
|
PS_INSTITUTION_KEY
|
Key for the institution dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
|
REQUISITION_NUMBER
|
The number on the requisition that this person applied for employment.
|
VARCHAR2(63)
|
HR_APPLICATION
|
REQUISITION_NUMBER
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
|
SECONDARY_SCHOOL_KEY
|
Key for the secondary school dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
|
SS_INSTITUTION_KEY
|
Key for the institution dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
|
SYSTEM_LOAD_PROCESS
|
Name of the transformation that created the row during the load activity process.
|
VARCHAR2(30)
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
|
SYSTEM_LOAD_TMSTMP
|
Most current date this record was created or updated.
|
DATE
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|
|
TIME_KEY
|
Key for the time dimension.
|
NUMBER
|
ETL GENERATED
|
NA
|
NO
|
NO
|
EMPLOYMENT APPLICATION
|