RETURN TO BANNER EDW META DATA REPORTS LIST
Advancement Activity Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_ADVANCEMENT_ACTIVITY

Description Advancement activity dimension table provides information about an activity. It uses the cleansing rules in the EDW for the short and long descriptions.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ACTIVITY Activity or event recorded for the alumnus participation. VARCHAR2(63)

APRACTY

APRACTY_ACTC_CODE

NO

NO ADVANCEMENT ACTIVITY
ACTIVITY_CATEGORY Category associated with the activity for reporting. VARCHAR2(63)

STVACCG

STVACCG_CODE

NO

NO ADVANCEMENT ACTIVITY
ACTIVITY_CATEGORY_LD Activity category long description. VARCHAR2(255)

STVACCG

STVACCG_DESC

NO

NO ADVANCEMENT ACTIVITY
ACTIVITY_CATEGORY_SD Activity category short description. VARCHAR2(255)

STVACCG

STVACCG_DESC

NO

NO ADVANCEMENT ACTIVITY
ACTIVITY_LD Activity long description. VARCHAR2(255)

STVACTC

STVACTC_DESC

NO

NO ADVANCEMENT ACTIVITY
ACTIVITY_SD Activity short description. VARCHAR2(255)

STVACTC

STVACTC_DESC

NO

NO ADVANCEMENT ACTIVITY
ACTIVITY_TYPE Broad type of activity in which activity can be grouped. VARCHAR2(63)

STVACTP

STVACTP_CODE

NO

NO ADVANCEMENT ACTIVITY
ACTIVITY_TYPE_LD Activity type long description. VARCHAR2(255)

STVACTP

STVACTP_DESC

NO

NO ADVANCEMENT ACTIVITY
ACTIVITY_TYPE_SD Activity type short description. VARCHAR2(255)

STVACTP

STVACTP_DESC

NO

NO ADVANCEMENT ACTIVITY
ADVANCEMENT_ACTIVITY_KEY System generated, unique, internal primary key for an advancement activity. NUMBER       NO
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

SYSTEM_LOAD_PROCESS

'ADVANCEMENT_ACTIVITY_D1B'

NO

NO ADVANCEMENT ACTIVITY
SYSTEM_LOAD_TMSTMP Most current date this record was created or updated. DATE

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_01   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_01_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_01_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_02   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_02_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_02_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_03   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_03_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_03_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_04   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_04_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_04_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_05   VARCHAR2(63)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_05_LD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO
USER_ATTRIBUTE_05_SD   VARCHAR2(255)

NO SOURCE

NO SOURCE

NO

NO


Ver: 9.0