Banner EDW Source: EMPLOYEE_POSITION

	RETURN TO BANNER EDW META DATA REPORTS LIST
	(Banner ODS Target Report)

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
ADMINISTRATIVE_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	ADMINISTRATIVE_GROUP	EMPLOYEE POSITION	NO
ANNUALIZED_FTE	NO	FACT TABLE	WFT_EMPLOYEE_POSITION WFT_EMPLOYEE_POSITION WFT_EMPLOYEE WFT_EMPLOYEE	SALARIED_FTE HOURLY_FTE SALARIED_FTE HOURLY_FTE	EMPLOYEE POSITION EMPLOYEE POSITION EMPLOYEE EMPLOYEE	NO NO NO NO
ANNUAL_SALARY	NO	FACT TABLE	WFT_EMPLOYEE WFT_EMPLOYMENT_APPLICATION WFT_EMPLOYEE_POSITION	ANNUAL_SALARY PREVIOUS_YEARLY_SALARY ANNUAL_SALARY	EMPLOYEE EMPLOYMENT APPLICATION EMPLOYEE POSITION	NO NO NO
EMPLOYEE_CAMPUS	NO
EMPLOYEE_CAMPUS_DESC	NO
EMPLOYEE_PROGRAM_CLASS_DESC	NO
EMPLOYER_CODE	NO	DIMENSION TABLE	WDT_ADMINISTRATION	EMPLOYER_CODE	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION	NO
EMPLOYER_DESC	NO	DIMENSION TABLE	WDT_ADMINISTRATION WDT_ADMINISTRATION	EMPLOYER_CODE_SD EMPLOYER_CODE_LD	EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION EMPLOYEE, EMPLOYEE DEGREE, EMPLOYEE POSITION, EMPLOYMENT APPLICATION	NO NO
ENCUMBRANCE_AMOUNT	NO	FACT TABLE	WFT_EMPLOYEE WFT_EMPLOYEE_POSITION	ENCUMBRANCE_AMOUNT ENCUMBRANCE_AMOUNT	EMPLOYEE EMPLOYEE POSITION	NO NO
JOB_SUFFIX	NO	DIMENSION TABLE	WDT_JOB	JOB_SUFFIX	EMPLOYEE POSITION	NO
MULTI_SOURCE	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	MULTI_SOURCE	EMPLOYEE POSITION	NO
MULTI_SOURCE_DESC	NO	DIMENSION TABLE	WDT_MULTI_SOURCE WDT_MULTI_SOURCE	MULTI_SOURCE_SD MULTI_SOURCE_LD	EMPLOYEE POSITION EMPLOYEE POSITION	NO NO
POSITION	NO	DIMENSION TABLE	WDT_POSITION	POSITION	EMPLOYEE POSITION	NO
POSITION_CLASS	NO
POSITION_CLASS_DESC	NO
POSITION_CONTRACT_TYPE	NO	DIMENSION TABLE	WDT_POSITION WDT_POSITION WDT_POSITION	POSITION_CONTRACT_TYPE POSITION_CONTRACT_TYPE_SD POSITION_CONTRACT_TYPE_LD	EMPLOYEE POSITION, EMPLOYMENT APPLICATION EMPLOYEE POSITION, EMPLOYMENT APPLICATION EMPLOYEE POSITION, EMPLOYMENT APPLICATION	NO NO NO
POSITION_LOCATION	NO	DIMENSION TABLE	WDT_POSITION WDT_POSITION WDT_POSITION	POSITION_CAMPUS_SD POSITION_CAMPUS_LD POSITION_CAMPUS	EMPLOYEE POSITION EMPLOYEE POSITION EMPLOYEE POSITION	NO NO NO
POSITION_MID_SALARY	NO	DIMENSION TABLE	WDT_HR_REQUISITION	SALARY_MIDPOINT	EMPLOYMENT APPLICATION	NO
POSITION_STATUS	NO	DIMENSION TABLE	WDT_POSITION	POSITION_STATUS	EMPLOYEE POSITION	NO
POSITION_STATUS_DESC	NO	DIMENSION TABLE	WDT_POSITION WDT_POSITION	POSITION_STATUS_SD POSITION_STATUS_LD	EMPLOYEE POSITION EMPLOYEE POSITION	NO NO
POSITION_TITLE	NO	DIMENSION TABLE	WDT_POSITION WDT_POSITION	POSITION_LD POSITION_SD	EMPLOYEE POSITION EMPLOYEE POSITION	NO NO
PROCESS_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	PROCESS_GROUP	EMPLOYEE POSITION	NO

Ver: 8.4.2