RETURN TO BANNER EDW META DATA REPORTS LIST
Athletic Star  Student Activity Star  

SGHE Enterprise Data Warehouse
Dimension Table Target: WDT_ACTIVITY

Description Contains attributes about an activity associated with a person within a time frame. Details include the activity codes that permit the activities to be grouped different ways for reporting purposes that include activity type and activity category.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name
ACTIVITY Activity recorded for the student or alumnus. Activities may include leadership councils, seminars, fraternity or sorority, chess or debate clubs, etc. VARCHAR2(63)

STUDENT_ACTIVITY

ACTIVITY

NO

NO ATHLETIC, STUDENT ACTIVITY
ACTIVITY_CATEGORY Specifies a grouping of activities that can be used for reporting like activities together. VARCHAR2(63)

STUDENT_ACTIVITY

ACTIVITY_CATEGORY

NO

NO ATHLETIC, STUDENT ACTIVITY
ACTIVITY_CATEGORY_LD Long description for the activity category. VARCHAR2(255)

STUDENT_ACTIVITY

ACTIVITY_CATEGORY_DESC

NO

NO ATHLETIC, STUDENT ACTIVITY
ACTIVITY_CATEGORY_SD Short description for the activity category. VARCHAR2(255)

STUDENT_ACTIVITY

ACTIVITY_CATEGORY_DESC

NO

NO ATHLETIC, STUDENT ACTIVITY
ACTIVITY_KEY Key for the activity dimension. NUMBER

ETL_GENERATED

NA

NO

NO ATHLETIC, STUDENT ACTIVITY
ACTIVITY_LD Long description for the activity. VARCHAR2(255)

STUDENT_ACTIVITY

ACTIVITY_DESC

NO

NO ATHLETIC, STUDENT ACTIVITY
ACTIVITY_SD Short description for the activity. VARCHAR2(255)

STUDENT_ACTIVITY

ACTIVITY_DESC

NO

NO ATHLETIC, STUDENT ACTIVITY
ACTIVITY_TYPE Specifies a type of activity that is used to group like activities together for reporting. VARCHAR2(63)

STUDENT_ACTIVITY

ACTIVITY_TYPE

NO

NO ATHLETIC, STUDENT ACTIVITY
ACTIVITY_TYPE_LD Long description for the activity type. VARCHAR2(255)

STUDENT_ACTIVITY

ACTIVITY_TYPE_DESC

NO

NO ATHLETIC, STUDENT ACTIVITY
ACTIVITY_TYPE_SD Short description for the activity type. VARCHAR2(255)

STUDENT_ACTIVITY

ACTIVITY_TYPE_DESC

NO

NO ATHLETIC, STUDENT ACTIVITY
SYSTEM_LOAD_PROCESS Name of the transformation that created the row during the load activity process. VARCHAR2(30)

ETL_GENERATED

NA

NO

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

ETL_GENERATED

NA

NO

NO STUDENT ACTIVITY


Ver: 9.0