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

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_ADVANCEMENT_DEG_MAJR

Description Advancement degree major fact table provides a group table association between a degree and the unlimited degree majors for Banner or the 3 degree majors for Advance, including a degree major count.

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

GROUP_COUNT_EXPRESSIONS

ADVANCEMENT_DEG_MAJR_COUNT_EXPRESSION

NO

NO ADVANCEMENT DEG MAJR
ADVANCEMENT_DEG_MAJR_GRP_KEY Advancement Degree Major Group KEY. NUMBER

GROUP_COUNT_EXPRESSIONS

ADVANCEMENT_DEG_MAJR_GRP_KEY_EXPRESSION

NO

NO ADVANCEMENT DEG MAJR
ADVANCEMENT_DEG_MAJR_KEY Advancement Degree Major KEY. NUMBER

CLN_ADVANCEMENT_DEG_MAJR

ADVANCEMENT_DEG_MAJR_KEY

NO

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

SYSTEM_LOAD_PROCESS

'ADVANCEMENT_DEG_MAJR_F1B'

NO

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