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

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_ADVANCEMENT_DEG_DEPT

Description Advancement degree department fact table provides a group table association between a degree and the 2 optional degree departments for Banner or the single degree department for Advance.

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

GROUP_COUNT_EXPRESSIONS

ADVANCEMENT_DEG_DEPT_GRP_KEY_EXPRESSION

NO

NO ADVANCEMENT DEG DEPT
ADVANCEMENT_DEG_DEPT_KEY Advancement Degree Department KEY. NUMBER

CLN_ADVANCEMENT_DEG_DEPT

ADVANCEMENT_DEG_DEPT_KEY

NO

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

SYSTEM_LOAD_PROCESS

'ADVANCEMENT_DEG_DEPT_F1B'

NO

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