Banner EDW Source: APRPROS

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
APRPROS_COMMENT	NO	REPORTING VIEW	SPECIAL_PURPOSE_GROUP	SPECIAL_PURPOSE_COMMENT	NA	NO
APRPROS_DATE	NO	REPORTING VIEW	SPECIAL_PURPOSE_GROUP	SPECIAL_PURPOSE_DATE	NA	NO
APRPROS_PIDM	NO	REPORTING VIEW	SPECIAL_PURPOSE_SLOT SPECIAL_PURPOSE_GROUP	ENTITY_UID ENTITY_UID	NA NA	NO NO
APRPROS_PRCD_CODE	NO	DIMENSION TABLE REPORTING VIEW	WDT_SPECIAL_PURPOSE SPECIAL_PURPOSE_SLOT SPECIAL_PURPOSE_SLOT SPECIAL_PURPOSE_SLOT SPECIAL_PURPOSE_SLOT SPECIAL_PURPOSE_GROUP SPECIAL_PURPOSE_SLOT	SPECIAL_PURPOSE SPECIAL_PURPOSE_GROUP4 SPECIAL_PURPOSE_GROUP5 SPECIAL_PURPOSE_GROUP2 SPECIAL_PURPOSE_GROUP3 SPECIAL_PURPOSE_GROUP SPECIAL_PURPOSE_GROUP1	SPECIAL PURPOSE NA NA NA NA NA NA	NO NO NO NO NO NO NO
APRPROS_PRTP_CODE	NO	DIMENSION TABLE REPORTING VIEW	WDT_SPECIAL_PURPOSE_TYPE SPECIAL_PURPOSE_GROUP SPECIAL_PURPOSE_SLOT SPECIAL_PURPOSE_SLOT SPECIAL_PURPOSE_SLOT SPECIAL_PURPOSE_SLOT SPECIAL_PURPOSE_SLOT	SPECIAL_PURPOSE_TYPE SPECIAL_PURPOSE_TYPE SPECIAL_PURPOSE_TYPE3 SPECIAL_PURPOSE_TYPE2 SPECIAL_PURPOSE_TYPE1 SPECIAL_PURPOSE_TYPE5 SPECIAL_PURPOSE_TYPE4	SPECIAL PURPOSE NA NA NA NA NA NA	NO NO NO NO NO NO NO

Ver: 9.0