Dimension Table Target: WDT_HR

	RETURN TO BANNER EDW META DATA 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
EMPLOYEE_POSITION

POSITION_MID_SALARY

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

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