RETURN TO FACT TABLE REPORTS LIST
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

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

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

FUNCTION

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

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

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: 3.1