Banner EDW Source: LKP_EXPRESSION

RETURN TO BANNER EDW META DATA REPORTS LIST

**SGHE Enterprise Data Warehouse**
Source Column	Local Source	Target Type	Target	Target Column	Star Name	Local Target
EXCLUSION_COMMENT_EXPRESSION	NO	DIMENSION TABLE	WDT_EXCLUSION_COMMENT	EXCLUSION_COMMENT	EXCLUSION	NO
EXCLUSION_COMMENT_ID_EXPRESSION	NO	DIMENSION TABLE	WDT_EXCLUSION_COMMENT	EXCLUSION_COMMENT_ID	EXCLUSION	NO
JOB_ID_EXPRESSION	NO	DIMENSION TABLE	WDT_CONST_EMPLOYMENT_JOB	JOB_ID	CONSTITUENT EMPLOYMENT	NO
JOB_TITLE_EXPRESSION	NO	DIMENSION TABLE	WDT_CONST_EMPLOYMENT_JOB	JOB_TITLE	CONSTITUENT EMPLOYMENT	NO
PHONE_STATUS_LD_EXPRESSION	NO	DIMENSION TABLE	WDT_PHONE_TYPE	PHONE_STATUS_LD	COMMITTEE, MAILING LIST, PHONE	NO
PHONE_STATUS_SD_EXPRESSION	NO	DIMENSION TABLE	WDT_PHONE_TYPE	PHONE_STATUS_SD	COMMITTEE, MAILING LIST, PHONE	NO
PRIMARY_ASSIGNMENT_IND_EXPRESSION	NO	FACT TABLE	WFT_ASSIGNMENT	PRIMARY_ASSIGNMENT_IND	ASSIGNMENT	NO

Ver: 9.0