RETURN TO BANNER EDW META DATA REPORTS LIST

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_ADV_STUDENT_ACTIVITY

Description Advancement student activity fact table provides measures for each student related activity in which a constituent has participated, including activity counts and participation start and stop dates.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ENTITY_KEY System generated, unique, internal primary key for an entity. NUMBER       NO
ENTITY_UID   NUMBER       NO
MULTI_SOURCE_KEY   NUMBER       NO
STUDENT_ACTIVITY_ATTRIB_KEY   NUMBER       NO
STUDENT_ACTIVITY_COMMENT_KEY   NUMBER       NO
STUDENT_ACTIVITY_COUNT   NUMBER       NO
STUDENT_ACTIVITY_GROUP_KEY   NUMBER       NO
STUDENT_ACTIVITY_KEY   NUMBER       NO
STUDENT_ACTIVITY_RECORD_COUNT   NUMBER       NO
STUDENT_ACT_SEQUENCE_NUMBER   NUMBER       NO
STUDENT_ACT_START_DT_PARTIAL   VARCHAR2(63)       NO
STUDENT_ACT_STOP_DT_PARTIAL   VARCHAR2(63)       NO
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)       NO
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE       NO
USER_MEASURE_01   NUMBER       NO
USER_MEASURE_02   NUMBER       NO
USER_MEASURE_03   NUMBER       NO
USER_MEASURE_04   NUMBER       NO
USER_MEASURE_05   NUMBER       NO


Ver: 9.0