Banner EDW Source: CONSTANT

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
'A'	NO	REPORTING VIEW	INTEREST	SOURCE	NA	NO
'ADVANCEMENT'	NO	REPORTING VIEW	INTEREST	SOURCE_DESC	NA	NO
'NO'	NO	DIMENSION TABLE	WDT_PLEDGE WDT_PLEDGE WDT_GIFT WDT_GIFT WDT_PLEDGE WDT_PLEDGE WDT_PLEDGE WDT_PLEDGE WDT_GIFT WDT_GIFT	PLEDGE_RECORDABLE_IND_SD PLEDGE_BINDING_IND_SD GIFT_EXCLUDE_IND_LD GIFT_EXCLUDE_IND_SD PLEDGE_INSTALLMENT_IND_LD PLEDGE_INSTALLMENT_IND_SD PLEDGE_RECORDABLE_IND_LD PLEDGE_BINDING_IND_LD REALIZED_BEQUEST_IND_SD REALIZED_BEQUEST_IND_LD	ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT	NO NO NO NO NO NO NO NO NO NO
'S'	NO	REPORTING VIEW	INTEREST	SOURCE	NA	NO
'STUDENT'	NO	REPORTING VIEW	INTEREST	SOURCE_DESC	NA	NO
0	NO	DIMENSION TABLE DIMENSION TABLE	WDT_GIFT WDT_GIFT WDT_DESIGNATION_DETAIL WDT_PLEDGE WDT_DESIGNATION_DETAIL WDT_PLEDGE WDT_PLEDGE WDT_GIFT WDT_GIFT WDT_DESIGNATION_DETAIL WDT_PLEDGE WDT_DESIGNATION_DETAIL WDT_PLEDGE WDT_PLEDGE	GIFT_EXCLUDE_IND REALIZED_BEQUEST_IND EXTRAMURAL_ATHLETICS_IND PLEDGE_BINDING_IND ATHLETICS_DESIGNATION_IND PLEDGE_RECORDABLE_IND PLEDGE_INSTALLMENT_IND GIFT_EXCLUDE_IND REALIZED_BEQUEST_IND EXTRAMURAL_ATHLETICS_IND PLEDGE_BINDING_IND ATHLETICS_DESIGNATION_IND PLEDGE_RECORDABLE_IND PLEDGE_INSTALLMENT_IND	ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT	NO NO NO NO NO NO NO NO NO NO NO NO NO NO
00	NO
01	NO	REPORTING VIEW	ACCOUNT_HIERARCHY OPERATING_LEDGER	CTRL_ADOPTED_BUDGET_SEQUENCE CTRL_ADOPTED_BUDGET_SEQUENCE	NA NA	NO NO
02	NO	REPORTING VIEW	ACCOUNT_HIERARCHY OPERATING_LEDGER	CTRL_BUDGET_ADJUST_SEQUENCE CTRL_BUDGET_ADJUST_SEQUENCE	NA NA	NO NO
03	NO	REPORTING VIEW	ACCOUNT_HIERARCHY OPERATING_LEDGER	CTRL_ACTUAL_ACTIVITY_SEQUENCE CTRL_ACTUAL_ACTIVITY_SEQUENCE	NA NA	NO NO
04	NO	REPORTING VIEW	OPERATING_LEDGER ACCOUNT_HIERARCHY	CTRL_ENCUMBRANCE_SEQUENCE CTRL_ENCUMBRANCE_SEQUENCE	NA NA	NO NO
05	NO	REPORTING VIEW	OPERATING_LEDGER ACCOUNT_HIERARCHY	CTRL_BUDGET_RESERVE_SEQUENCE CTRL_BUDGET_RESERVE_SEQUENCE	NA NA	NO NO
07	NO	REPORTING VIEW	OPERATING_LEDGER ACCOUNT_HIERARCHY	CTRL_TEMPORARY_BUDGET_SEQUENCE CTRL_TEMPORARY_BUDGET_SEQUENCE	NA NA	NO NO
13	NO
14	NO
85	NO
86	NO
HARDCODED DESCRIPTIONS.	NO	REPORTING VIEW	PORTFOLIO	AUTHORIZATION_STATUS_DESC	NA	NO
NO	NO	DIMENSION TABLE	WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL	EXTRAMURAL_ATHLETICS_IND_LD ATHLETICS_DESIGNATION_IND_SD ATHLETICS_DESIGNATION_IND_LD EXTRAMURAL_ATHLETICS_IND_SD	ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT	NO NO NO NO
NULL	NO	DIMENSION TABLE DIMENSION TABLE DIMENSION TABLE	WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL WDT_DESIGNATION_DETAIL	DESIGNATION_RESTRICTION_SD DESIGNATION_RESTRICTION DESIGNATION_AGENCY DESIGNATION_AGENCY_SD DESIGNATION_AGENCY_LD DESIGNATION_RESTRICTION_LD DESIGNATION_RESTRICTION_SD DESIGNATION_RESTRICTION DESIGNATION_AGENCY DESIGNATION_AGENCY_SD DESIGNATION_AGENCY_LD DESIGNATION_RESTRICTION_LD DESIGNATION_RESTRICTION_SD DESIGNATION_RESTRICTION DESIGNATION_AGENCY DESIGNATION_AGENCY_SD DESIGNATION_AGENCY_LD DESIGNATION_RESTRICTION_LD	ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT ADVANCEMENT GIFT	NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO NO

Ver: 8.4.3