Fact Table Target: WFT

	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 Affiliation count. VARCHAR2(252) NO

AFFILIATION_GROUP_KEY NUMBER NO

AFFILIATION_KEY NUMBER NO

AFFILIATION_RECORD_COUNT NUMBER NO

AFFILIATION_SEQUENCE System generated, unique, internal identification number assigned to this person or organization entity. NUMBER NO

AFFILIATION_START_DATE Start date for this affiliation. DATE NO

AFFILIATION_STOP_DATE Stop date for this affiliation. DATE NO

ENTITY_KEY System generated, unique, internal primary key for an entity. NUMBER NO

ENTITY_UID System generated, unique, internal identification number assigned to this person or organization entity. NUMBER NO

MULTI_SOURCE_KEY NUMBER NO

PRIMARY_AFFILIATION_IND Indicates if this is the primary occurrence of the affiliation when more than one record with the same affiliation code exists. For single occurrence affiliations this is an optional indicator. 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: 9.0

Target Column	Business Definition	Database Data Type	Local Target
AFFILIATION_COUNT	Affiliation count.	VARCHAR2(252)	NO
AFFILIATION_GROUP_KEY		NUMBER	NO
AFFILIATION_KEY		NUMBER	NO
AFFILIATION_RECORD_COUNT		NUMBER	NO
AFFILIATION_SEQUENCE	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	NO
AFFILIATION_START_DATE	Start date for this affiliation.	DATE	NO
AFFILIATION_STOP_DATE	Stop date for this affiliation.	DATE	NO
ENTITY_KEY	System generated, unique, internal primary key for an entity.	NUMBER	NO
ENTITY_UID	System generated, unique, internal identification number assigned to this person or organization entity.	NUMBER	NO
MULTI_SOURCE_KEY		NUMBER	NO
PRIMARY_AFFILIATION_IND	Indicates if this is the primary occurrence of the affiliation when more than one record with the same affiliation code exists. For single occurrence affiliations this is an optional indicator.	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