RETURN TO BANNER EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_COMMITTEE_MEMBER

Description Committee dimension table provides information about committee memberships. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
COMMITTEE_MEMBER_KEY Committee Member KEY. NUMBER       NO
COMMITTEE_MEMBER_ROLE Role that the entity is fulfilling on this committee (president, volunteer, etc.). VARCHAR2(63)       NO
COMMITTEE_MEMBER_ROLE_LD Committee role long description. VARCHAR2(255)       NO
COMMITTEE_MEMBER_ROLE_SD Committee role short description. VARCHAR2(255)       NO
COMMITTEE_MEMBER_SOURCE Source of the committee member data. VARCHAR2(63)       NO
COMMITTEE_MEMBER_SOURCE_LD Committee source long description. VARCHAR2(255)       NO
COMMITTEE_MEMBER_SOURCE_SD Committee source short description. VARCHAR2(255)       NO
COMMITTEE_MEMBER_STATUS Committee member status for as Active, Former, Planned, Resigned. VARCHAR2(63)       NO
COMMITTEE_MEMBER_STATUS_LD Committee status long description. VARCHAR2(255)       NO
COMMITTEE_MEMBER_STATUS_SD Committee status short description. VARCHAR2(255)       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_ATTRIBUTE_01   VARCHAR2(63)       NO
USER_ATTRIBUTE_01_LD   VARCHAR2(255)       NO
USER_ATTRIBUTE_01_SD   VARCHAR2(255)       NO
USER_ATTRIBUTE_02   VARCHAR2(63)       NO
USER_ATTRIBUTE_02_LD   VARCHAR2(255)       NO
USER_ATTRIBUTE_02_SD   VARCHAR2(255)       NO
USER_ATTRIBUTE_03   VARCHAR2(63)       NO
USER_ATTRIBUTE_03_LD   VARCHAR2(255)       NO
USER_ATTRIBUTE_03_SD   VARCHAR2(255)       NO
USER_ATTRIBUTE_04   VARCHAR2(63)       NO
USER_ATTRIBUTE_04_LD   VARCHAR2(255)       NO
USER_ATTRIBUTE_04_SD   VARCHAR2(255)       NO
USER_ATTRIBUTE_05   VARCHAR2(63)       NO
USER_ATTRIBUTE_05_LD   VARCHAR2(255)       NO
USER_ATTRIBUTE_05_SD   VARCHAR2(255)       NO


Ver: 9.0