RETURN TO BANNER EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_AFFILIATION

Description Affiliation fact table provides measures for each constituent affiliation, including primary affiliation indicator, affiliation start and stop dates and a distinct count of affiliations for the constituent.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
AFFILIATION_COUNT   VARCHAR2(252)       NO
AFFILIATION_GROUP_KEY   NUMBER       NO
AFFILIATION_KEY   NUMBER       NO
AFFILIATION_RECORD_COUNT   NUMBER       NO
AFFILIATION_SEQUENCE   NUMBER       NO
AFFILIATION_START_DATE   DATE       NO
AFFILIATION_STOP_DATE   DATE       NO
ENTITY_KEY System generated, unique, internal primary key for an entity. NUMBER       NO
ENTITY_UID   NUMBER       NO
MULTI_SOURCE_KEY   NUMBER       NO
PRIMARY_AFFILIATION_IND   NUMBER       NO
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)       NO
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE       NO
USER_MEASURE_01   NUMBER       NO
USER_MEASURE_02   NUMBER       NO
USER_MEASURE_03   NUMBER       NO
USER_MEASURE_04   NUMBER       NO
USER_MEASURE_05   NUMBER       NO


Ver: 8.4.2