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

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_ADVANCEMENT_DEG_HONR

Description Advancement degree honor fact table provides a group table association between a degree and the 10 optional degree honors for Banner or the 3 degree honors for Advance, including a degree honor count.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ADVANCEMENT_DEG_HONR_COUNT Advancement Degree Honor Count. NUMBER

GROUP_COUNT_EXPRESSIONS

ADVANCEMENT_DEG_HONR_COUNT_EXPRESSION

NO

NO ADVANCEMENT DEG HONR
ADVANCEMENT_DEG_HONR_GRP_KEY Advancement Degree Honor Group KEY. NUMBER

GROUP_COUNT_EXPRESSIONS

ADVANCEMENT_DEG_HONR_GRP_KEY_EXPRESSION

NO

NO ADVANCEMENT DEG HONR
ADVANCEMENT_DEG_HONR_KEY Advancement Degree Honor KEY. NUMBER

CLN_ADVANCEMENT_DEG_HONR

ADVANCEMENT_DEG_HONR_KEY

NO

NO ADVANCEMENT DEG HONR
MULTI_SOURCE_KEY System generated, unique, internal primary key for the multi-institution facility. NUMBER

CLN_MULTI_SOURCE

MULTI_SOURCE_KEY

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_F1B'

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_MEASURE_01   NUMBER

NO SOURCE

NO SOURCE

NO

NO
USER_MEASURE_02   NUMBER

NO SOURCE

NO SOURCE

NO

NO
USER_MEASURE_03   NUMBER

NO SOURCE

NO SOURCE

NO

NO
USER_MEASURE_04   NUMBER

NO SOURCE

NO SOURCE

NO

NO
USER_MEASURE_05   NUMBER

NO SOURCE

NO SOURCE

NO

NO


Ver: 9.0