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

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_ADVANCEMENT_DEG_CONC

Description Advancement degree concentration fact table provides a group table association between a degree and the 6 optional degree concentrations for Banner or the single degree concentration for Advance.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ADVANCEMENT_DEG_CONC_GRP_KEY Advancement Degree Concentration Group KEY. NUMBER

GROUP_COUNT_EXPRESSIONS

ADVANCEMENT_DEG_CONC_GRP_KEY_EXPRESSION

NO

NO ADVANCEMENT DEG CONC
ADVANCEMENT_DEG_CONC_KEY Advancement Degree Concentration KEY. NUMBER

CLN_ADVANCEMENT_DEG_CONC

ADVANCEMENT_DEG_CONC_KEY

NO

NO ADVANCEMENT DEG CONC
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 CONC
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

SYSTEM_LOAD_PROCESS

'ADVANCEMENT_DEG_CONC_F1B'

NO

NO ADVANCEMENT DEG CONC
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