RETURN TO BANNER EDW META DATA REPORTS LIST
Advancement Deg Honr Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_ADVANCEMENT_DEG_HONR

Description Advancement degree honor dimension table identifies the degree honor and description, including the honor type to distinguish between an institution or departmental honor for Banner. 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_HONR   VARCHAR2(63)

APRADEG_HOND_CODE_4

APRADEG_HOND_CODE_4

NO

NO ADVANCEMENT DEG HONR
ADVANCEMENT_DEG_HONR_KEY Advancement Degree Honor KEY. NUMBER       NO
ADVANCEMENT_DEG_HONR_LD   VARCHAR2(255)

STVHOND

STVHOND_DESC

NO

NO ADVANCEMENT DEG HONR
ADVANCEMENT_DEG_HONR_SD   VARCHAR2(255)

STVHOND

STVHOND_DESC

NO

NO ADVANCEMENT DEG HONR
ADVANCEMENT_DEG_HONR_TYPE   VARCHAR2(63)

CONSTANT

'0'

NO

NO ADVANCEMENT DEG HONR
ADVANCEMENT_DEG_HONR_TYPE_LD   VARCHAR2(255)

EXPRESSION

ADVANCEMENT_DEG_HONR_TYPE_LD_EXPRESSION

NO

NO ADVANCEMENT DEG HONR
ADVANCEMENT_DEG_HONR_TYPE_SD   VARCHAR2(255)

EXPRESSION

ADVANCEMENT_DEG_HONR_TYPE_SD_EXPRESSION

NO

NO ADVANCEMENT DEG HONR
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

SYSTEM_LOAD_PROCESS

'ADVANCEMENT_DEG_HONR_D1B'

NO

NO ADVANCEMENT DEG HONR
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_01   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_01_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_01_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_02   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_02_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_02_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_03   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_03_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_03_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_04   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_04_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_04_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_05   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_05_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_05_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO


Ver: 9.0