Banner EDW Source: DEFAULT_VALUES

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
'ASSIGNMENT_F1B'	NO	FACT TABLE	WFT_ASSIGNMENT	SYSTEM_LOAD_PROCESS	ASSIGNMENT	NO
'MATCHING_CLAIM_F1B'	NO	FACT TABLE	WFT_MATCHING_CLAIM	SYSTEM_LOAD_PROCESS	MATCHING CLAIM	NO
0	NO	FACT TABLE	WFT_ASSIGNMENT WFT_ASSIGNMENT WFT_ASSIGNMENT WFT_ASSIGNMENT WFT_ASSIGNMENT WFT_ASSIGNMENT WFT_ASSIGNMENT WFT_ASSIGNMENT WFT_ASSIGNMENT WFT_ASSIGNMENT WFT_ASSIGNMENT WFT_ASSIGNMENT WFT_ASSIGNMENT WFT_ASSIGNMENT WFT_ASSIGNMENT WFT_ASSIGNMENT	ENTITY_ASSIGNMENT_IND ALLOCATION_ASSIGNMENT_IND ADVANCEMENT_PROGRAM_KEY FUNDRAISING_INITIATIVE_KEY ASSIGNMENT_OFFICE_KEY CONTRACT_GRANT_ASSIGNMENT_IND ASSIGNMENT_UNIT_KEY DESIGNATION_ADV_PROGRAM_KEY COMMITTEE_ASSIGNMENT_IND ADVANCEMENT_PROGRAM_YEAR_KEY PGM_PROSPECT_ASSIGNMENT_IND COMMITTEE_KEY DESIGNATION_KEY ASSIGNMENT_ID CONTRACT_GRANT_KEY DESIGNATION_DETAIL_KEY	ASSIGNMENT ASSIGNMENT ASSIGNMENT ASSIGNMENT ASSIGNMENT ASSIGNMENT ASSIGNMENT ASSIGNMENT ASSIGNMENT ASSIGNMENT ASSIGNMENT ASSIGNMENT ASSIGNMENT ASSIGNMENT ASSIGNMENT ASSIGNMENT	NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO
1	NO	FACT TABLE	WFT_ASSIGNMENT	PROSPECT_ASSIGNMENT_IND	ASSIGNMENT	NO
TO_DATE ( '31-DEC-2099' , 'DD-MON-YYYY' )	NO	FACT TABLE	WFT_MATCHING_CLAIM WFT_MATCHING_CLAIM	MATCH_CLAIM_STATUS_DATE MATCH_CLAIM_FORM_RECEIVED_DATE	MATCHING CLAIM MATCHING CLAIM	NO NO
NULL	NO	FACT TABLE	WFT_ASSIGNMENT	PROS_PGM_YR_ID	ASSIGNMENT	NO

Ver: 8.4.2