RETURN TO DIMENSION TABLE REPORTS LIST
Employment Application Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_HR_APPLICANT

Description HR Applicant Dimension table provides information on the person that is applying for employment. This information includes whether or not they attended this institution (alumnus), if they are currently employed and how they learned of 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
ALUMNUS_IND System determined by the existence of ACADEMIC_OUTCOME reporting view with a GRADUATED_IND equal to YES and it will set this indicator to 'Y', applicant is an alumnus of this institution. VARCHAR2(63)

CONSTITUENT

FUNCTION

NO

NO

EMPLOYMENT APPLICATION

CURRENT_EMPLOYEE_IND System determined by the existence of an EMPLOYEE reporting view with a POSITION_BEGIN_DATE and POSITION_END_DATE that includes the date of the extract. VARCHAR2(63)

EMPLOYEE

FUNCTION

NO

NO

EMPLOYMENT APPLICATION

HR_APPLICANT_KEY Key for the HR applicant dimension. NUMBER

ETL GENERATED

NA

NO

NO

EMPLOYMENT APPLICATION

SOURCE Source where the applicant learned about the position such as newspaper ad, friend, job board, internet, etc. VARCHAR2(63)

HR_APPLICATION

SOURCE

NO

NO

EMPLOYMENT APPLICATION

SOURCE_LD Long name of the source that the applicant learned of the position. VARCHAR2(255)

HR_APPLICATION

SOURCE_DESC

NO

NO

EMPLOYMENT APPLICATION

SOURCE_SD Short name of the source that the applicant learned of the position. VARCHAR2(255)

HR_APPLICATION

SOURCE_DESC

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