RETURN TO DIMENSION TABLE REPORTS LIST
Employment Application Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_HR_APPLICANT_STATUS

Description HR Applicant Status Dimension table provides information on the person that where they are in the process of applying for employment. This information includes whether or not they have a formal application, had an interview, were offered the position and have accepted and started employment in the position. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ACCEPTED_IND Indicates when an offer of employment was accepted by the applicant. VALUES will be yes or no. The HR_APPLICATION_STATUS reporting view will show this information. VARCHAR2(63)

HR_APPLICATION

FUNCTION

NO

NO

EMPLOYMENT APPLICATION

APPLIED_IND Indicates if an application was received by the fact there is information in the HR_APPLICATION reporting view. VALUES will be yes or no. Calculated. VARCHAR2(63)

HR_APPLICATION

FUNCTION

NO

NO

EMPLOYMENT APPLICATION

EMPLOYED_IND Indicates that beginning employment date has passed. VALUES will be yes or no based in the POSITION_BEGIN_DATE in the EMPLOYEE reporting view. VARCHAR2(63)

HR_APPLICATION

FUNCTION

NO

NO

EMPLOYMENT APPLICATION

EMPLOYMENT_OFFERED_IND Indicates when an offer of employment was made. VALUES will be yes or no. The HR_APPLICATION_STATUS reporting view will by???? VARCHAR2(63)

HR_APPLICATION

FUNCTION

NO

NO

EMPLOYMENT APPLICATION

HR_APPLICANT_STATUS_KEY Key for the HR applicant status dimension. NUMBER

ETL GENERATED

NA

NO

NO

EMPLOYMENT APPLICATION

INTERVIEWED_IND Indicates if the applicant attended the interview that was scheduled. VALUES will be yes or no. Calculated based on if the INTERVIEW reporting view has data and the INTERVIEW_DATE has passed. VARCHAR2(63)

HR_APPLICATION

FUNCTION

NO

NO

EMPLOYMENT APPLICATION

INTERVIEW_OFFERED_IND Indicates if the applicant was offered an interview for the position. VALUES will be yes or no. Calculated based on if any records display through the INTERVIEW reporting view VARCHAR2(63)

HR_APPLICATION

FUNCTION

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



Ver: 3.1