Banner EDW Source: HR_APPLICATION

	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	EMPLOYMENT APPLICATION	NO
APPLICATION_DATE	NO	DIMENSION TABLE	WDT_TIME WDT_TIME	CALENDAR_MONTH CALENDAR_YEAR	EMPLOYMENT APPLICATION EMPLOYMENT APPLICATION	NO NO
DESIRED_HOURLY	NO	FACT TABLE	WFT_EMPLOYMENT_APPLICATION	DESIRED_HOURLY_SALARY	EMPLOYMENT APPLICATION	NO
DESIRED_SALARY	NO	FACT TABLE	WFT_EMPLOYMENT_APPLICATION	DESIRED_YEARLY_SALARY	EMPLOYMENT APPLICATION	NO
FUNCTION	NO	DIMENSION TABLE	WDT_HR_APPLICANT_STATUS WDT_HR_APPLICANT_STATUS WDT_HR_APPLICANT_STATUS WDT_HR_APPLICANT_STATUS WDT_HR_APPLICANT_STATUS WDT_HR_APPLICANT_STATUS	EMPLOYMENT_OFFERED_IND INTERVIEWED_IND ACCEPTED_IND APPLIED_IND EMPLOYED_IND INTERVIEW_OFFERED_IND	EMPLOYMENT APPLICATION EMPLOYMENT APPLICATION EMPLOYMENT APPLICATION EMPLOYMENT APPLICATION EMPLOYMENT APPLICATION EMPLOYMENT APPLICATION	NO NO NO NO NO NO
MULTI_SOURCE	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	MULTI_SOURCE	EMPLOYMENT APPLICATION	NO
MULTI_SOURCE_DESC	NO	DIMENSION TABLE	WDT_MULTI_SOURCE WDT_MULTI_SOURCE	MULTI_SOURCE_LD MULTI_SOURCE_SD	EMPLOYMENT APPLICATION EMPLOYMENT APPLICATION	NO NO
PERSON_UID	NO	FACT TABLE	WFT_EMPLOYMENT_APPLICATION	PERSON_UID	EMPLOYMENT APPLICATION	NO
PROCESS_GROUP	NO	DIMENSION TABLE	WDT_MULTI_SOURCE	PROCESS_GROUP	EMPLOYMENT APPLICATION	NO
REQUISITION_NUMBER	NO	FACT TABLE	WFT_EMPLOYMENT_APPLICATION	REQUISITION_NUMBER	EMPLOYMENT APPLICATION	NO
SOURCE	NO	DIMENSION TABLE	WDT_HR_APPLICANT	SOURCE	EMPLOYMENT APPLICATION	NO
SOURCE_DESC	NO	DIMENSION TABLE	WDT_HR_APPLICANT WDT_HR_APPLICANT	SOURCE_SD SOURCE_LD	EMPLOYMENT APPLICATION EMPLOYMENT APPLICATION	NO NO

Ver: 9.0