RETURN TO BANNER EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_ADVANCEMENT_DEG_ATTR

Description Advancement degree attribute dimension table provides additional attributes related to a constituent's degree. 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
ADVANCEMENT_DEG_ATTR_KEY Advancement Degree Attribute KEY. NUMBER       NO
FINANCIAL_AID_TYPE   VARCHAR2(63)       NO
FINANCIAL_AID_TYPE_LD   VARCHAR2(255)       NO
FINANCIAL_AID_TYPE_SD   VARCHAR2(255)       NO
GRANTING_SCHOOL School of the unit that granted the degree, as opposed to the school where the work towards the degree was completed. VARCHAR2(63)       NO
GRANTING_SCHOOL_LD Granting school long description. VARCHAR2(255)       NO
GRANTING_SCHOOL_SD Granting school short description. VARCHAR2(255)       NO
NON_GRADUATE Determines why this entity is not a graduate from this institution. VARCHAR2(63)       NO
NON_GRADUATE_LD Non graduate long description. VARCHAR2(255)       NO
NON_GRADUATE_SD Non graduate 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