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	ASSIGNMENT_ID ADVANCEMENT_PROGRAM_KEY CONTRACT_GRANT_KEY ENTITY_ASSIGNMENT_IND ASSIGNMENT_UNIT_KEY COMMITTEE_ASSIGNMENT_IND DESIGNATION_DETAIL_KEY ADVANCEMENT_PROGRAM_YEAR_KEY ASSIGNMENT_OFFICE_KEY DESIGNATION_ADV_PROGRAM_KEY FUNDRAISING_INITIATIVE_KEY ALLOCATION_ASSIGNMENT_IND PGM_PROSPECT_ASSIGNMENT_IND CONTRACT_GRANT_ASSIGNMENT_IND COMMITTEE_KEY DESIGNATION_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_FORM_RECEIVED_DATE MATCH_CLAIM_STATUS_DATE	MATCHING CLAIM MATCHING CLAIM	NO NO
NULL	NO	FACT TABLE	WFT_ASSIGNMENT	PROS_PGM_YR_ID	ASSIGNMENT	NO

Ver: 9.0