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 WFT_EMPLOYEE_POSITION WFT_EMPLOYEE WFT_EMPLOYEE_POSITION	SALARIED_FTE SALARIED_FTE HOURLY_FTE HOURLY_FTE	EMPLOYEE EMPLOYEE POSITION EMPLOYEE EMPLOYEE POSITION	NO NO NO NO
ANNUAL_SALARY	NO	FACT TABLE	WFT_EMPLOYEE_POSITION WFT_EMPLOYMENT_APPLICATION WFT_EMPLOYEE	ANNUAL_SALARY PREVIOUS_YEARLY_SALARY ANNUAL_SALARY	EMPLOYEE POSITION EMPLOYMENT APPLICATION EMPLOYEE	NO NO 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_POSITION WFT_EMPLOYEE	ENCUMBRANCE_AMOUNT ENCUMBRANCE_AMOUNT	EMPLOYEE POSITION EMPLOYEE	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_LD MULTI_SOURCE_SD	EMPLOYEE POSITION EMPLOYEE POSITION	NO NO
POSITION	NO	DIMENSION TABLE	WDT_POSITION	POSITION	EMPLOYEE POSITION	NO
POSITION_CONTRACT_TYPE	NO	DIMENSION TABLE	WDT_POSITION WDT_POSITION WDT_POSITION	POSITION_CONTRACT_TYPE POSITION_CONTRACT_TYPE_LD POSITION_CONTRACT_TYPE_SD	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_LD POSITION_STATUS_SD	EMPLOYEE POSITION EMPLOYEE POSITION	NO NO
POSITION_TITLE	NO	DIMENSION TABLE	WDT_POSITION WDT_POSITION	POSITION_SD POSITION_LD	EMPLOYEE POSITION EMPLOYEE POSITION	NO NO
PROCESS_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	PROCESS_GROUP	EMPLOYEE POSITION	NO

Ver: 9.0