RETURN TO BANNER EDW META DATA REPORTS LIST
Employee Application Star  Employment Application Star  

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_EMPLOYMENT_APPLICATION

Description Employment Application Fact table provides measures that may be compared and displayed based on the dimensions in this star schema. This set of measures is stored per person per time frame per requisition number.

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       NO
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

EMPLOYEE

EMPLOYMENT_HISTORY

EMPLOYMENT_HISTORY

FUNCTION

MONTHS_IN_POSITION

MONTHS_IN_POSITION

NO

NO

NO

NO EMPLOYMENT APPLICATION 

EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION 

EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION

PREVIOUS_YEARLY_SALARY Annual salary in most recent prior employment. NUMBER

EMPLOYEE_POSITION

EMPLOYMENT_HISTORY

EMPLOYMENT_HISTORY

ANNUAL_SALARY

CURRENT_SALARY

CURRENT_SALARY

NO

NO

NO

NO EMPLOYMENT APPLICATION 

EMPLOYMENT APPLICATION, EMPLOYMENT APPLICATION 

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


Ver: 8.4.3