RETURN TO DIMENSION TABLE REPORTS LIST
Employment Application Star

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_HR_REQUISITION

Description HR Requisition Dimension table provides information on the position that has been advertised. This information includes number of days the position has been open, mid point of the salary, whether it is full time or part time, etc.. 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
DAYS_REQUISITION_OPEN Number of days that the requisition was open. NUMBER

HR_REQUISITION

FUNCTION

NO

NO

EMPLOYMENT APPLICATION

HR_REQUISITION_KEY Key for the HR requisition dimension. NUMBER

ETL GENERATED

NA

NO

NO

EMPLOYMENT APPLICATION

INTEND_EMPLOYEE_TIME_STATUS Identifies if the requisition is for a full-time or part-time employment. VARCHAR2(63)

HR_REQUISITION

FULL_OR_PART_TIME

NO

NO

EMPLOYMENT APPLICATION

INTEND_EMPLOYEE_TIME_STATUS_LD Long description for the employment status. VARCHAR2(255)

HR_REQUISITION

FULL_OR_PART_TIME_DESC

NO

NO

EMPLOYMENT APPLICATION

INTEND_EMPLOYEE_TIME_STATUS_SD Short description for the employment status. VARCHAR2(255)

HR_REQUISITION

FULL_OR_PART_TIME_DESC

NO

NO

EMPLOYMENT APPLICATION

MINIMUM_DEGREE_LEVEL Minimum degree level required by the requisition. VARCHAR2(63)

HR_REQUISITION

MINIMUM_DEGREE_LEVEL

NO

NO

EMPLOYMENT APPLICATION

MINIMUM_DEGREE_LEVEL_LD Long description of the minimum degree level. VARCHAR2(255)

HR_REQUISITION

MINIMUM_DEGREE_LEVEL_DESC

NO

NO

EMPLOYMENT APPLICATION

MINIMUM_DEGREE_LEVEL_SD Short description of the minimum degree level. VARCHAR2(255)

HR_REQUISITION

MINIMUM_DEGREE_LEVEL_DESC

NO

NO

EMPLOYMENT APPLICATION

REQUISITION_STATUS Current status for this requisition. VARCHAR2(63)

HR_REQUISITION

REQUISITION_STATUS

NO

NO

EMPLOYMENT APPLICATION

REQUISITION_STATUS_LD Long description of the requisition status. VARCHAR2(255)

HR_REQUISITION

REQUISITION_STATUS_DESC

NO

NO

EMPLOYMENT APPLICATION

REQUISITION_STATUS_SD Short description of the requisition status. VARCHAR2(255)

HR_REQUISITION

REQUISITION_STATUS_DESC

NO

NO

EMPLOYMENT APPLICATION

SALARY_MIDPOINT Midpoint of the salary range for the requisition. NUMBER

HR_REQUISITION

SALARY_MIDPOINT

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