Fact Table Target: WFT_STUDENT

	RETURN TO BANNER EDW META DATA REPORTS LIST
	Student Activity Star

SGHE Enterprise Data Warehouse
Fact Table Target: WFT_STUDENT_ACTIVITY

Description Current version of all activities for each academic period for a student. Use the Student Activity star schema to understand the numbers for the academic period grouping by the categories and types defined with the student activity. This data may be joined with other star schemas for analysis.

Target Column Business Definition Database Data Type Source Name Source Column Local Source Local Target Star Name

ACADEMIC_TIME_KEY Key for the academic time dimension. NUMBER
ETL_GENERATED

NA

NO
NO STUDENT ACTIVITY

ACTIVITY_FIRST_ACADTIME_KEY Key for the academic time dimension that identifies the first academic period for an activity. NUMBER
ETL_GENERATED

NA

NO
NO STUDENT ACTIVITY

ACTIVITY_FIRST_YEAR Initial or earliest academic year of participation in this activity. NUMBER
FUNCTION

NVL((SELECT NVL(MIN(ACADEMIC_YEAR),'1900') FROM MST_STUDENT_ACTIVITY ACT WHERE ACT.PERSON_UID = SA.PERSON_UID AND ACT.STUDENT_ACTIVITY = SA.STUDENT_ACTIVITY), 1900)

NO
NO STUDENT ACTIVITY

ACTIVITY_LAST_ACADTIME_KEY Key for the academic time dimension that identifies the last academic period for an activity. NUMBER
ETL GENERATED
ETL_GENERATED

NA
NA

NO
NO
NO STUDENT ACTIVITY
STUDENT ACTIVITY

ACTIVITY_LAST_YEAR Last or latest academic year of participation in this activity. NUMBER
FUNCTION

NVL((SELECT NVL(MAX(ACADEMIC_YEAR),'2099') FROM MST_STUDENT_ACTIVITY ACT WHERE ACT.PERSON_UID = SA.PERSON_UID AND ACT.STUDENT_ACTIVITY = SA.STUDENT_ACTIVITY), 2099)

NO
NO STUDENT ACTIVITY

ACTIVITY_TOTAL_ACAD_PERIODS Calculation that counts the number of academic periods in which a student participated in an activity. NUMBER
FUNCTION

(SELECT COUNT(DISTINCT ACADEMIC_PERIOD) FROM MST_STUDENT_ACTIVITY ACT WHERE ACT.PERSON_UID = SA.PERSON_UID AND ACT.STUDENT_ACTIVITY = SA.STUDENT_ACTIVITY)

NO
NO STUDENT ACTIVITY

ACTIVITY_TOTAL_YEARS Number of years from the initial to the last academic year associated with the activity. This will be an attribute of the person and activity combination and not be automatically totaled. NUMBER
FUNCTION

(SELECT COUNT(DISTINCT ACADEMIC_YEAR) FROM MST_STUDENT_ACTIVITY ACT WHERE ACT.PERSON_UID = SA.PERSON_UID AND ACT.STUDENT_ACTIVITY = SA.STUDENT_ACTIVITY)

NO
NO STUDENT ACTIVITY

DEMOGRAPHIC_KEY Key for the demographic dimension. NUMBER
ETL_GENERATED

NA

NO
NO STUDENT ACTIVITY

MULTI_SOURCE_KEY Key for the multi source dimension. NUMBER
ETL_GENERATED

NA

NO
NO STUDENT ACTIVITY

PERSON_UID Key for the person dimension. NUMBER
ETL_GENERATED

NA

NO
NO STUDENT ACTIVITY

STUDENT_ACTIVITY_COUNT_KEY Key for the student activity count. NUMBER
ETL_GENERATED

NA

NO
NO STUDENT ACTIVITY

STUDENT_ACTIVITY_GROUP_KEY Key for the student activity group. NUMBER
ETL_GENERATED

NA

NO
NO STUDENT ACTIVITY

STUDENT_ACTIVITY_KEY Key for the student activity dimension. NUMBER
ETL_GENERATED

NA

NO
NO 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

Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target	Star Name
ACADEMIC_TIME_KEY	Key for the academic time dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT ACTIVITY
ACTIVITY_FIRST_ACADTIME_KEY	Key for the academic time dimension that identifies the first academic period for an activity.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT ACTIVITY
ACTIVITY_FIRST_YEAR	Initial or earliest academic year of participation in this activity.	NUMBER	FUNCTION	NVL((SELECT NVL(MIN(ACADEMIC_YEAR),'1900') FROM MST_STUDENT_ACTIVITY ACT WHERE ACT.PERSON_UID = SA.PERSON_UID AND ACT.STUDENT_ACTIVITY = SA.STUDENT_ACTIVITY), 1900)	NO	NO	STUDENT ACTIVITY
ACTIVITY_LAST_ACADTIME_KEY	Key for the academic time dimension that identifies the last academic period for an activity.	NUMBER	ETL GENERATED ETL_GENERATED	NA NA	NO NO	NO	STUDENT ACTIVITY STUDENT ACTIVITY
ACTIVITY_LAST_YEAR	Last or latest academic year of participation in this activity.	NUMBER	FUNCTION	NVL((SELECT NVL(MAX(ACADEMIC_YEAR),'2099') FROM MST_STUDENT_ACTIVITY ACT WHERE ACT.PERSON_UID = SA.PERSON_UID AND ACT.STUDENT_ACTIVITY = SA.STUDENT_ACTIVITY), 2099)	NO	NO	STUDENT ACTIVITY
ACTIVITY_TOTAL_ACAD_PERIODS	Calculation that counts the number of academic periods in which a student participated in an activity.	NUMBER	FUNCTION	(SELECT COUNT(DISTINCT ACADEMIC_PERIOD) FROM MST_STUDENT_ACTIVITY ACT WHERE ACT.PERSON_UID = SA.PERSON_UID AND ACT.STUDENT_ACTIVITY = SA.STUDENT_ACTIVITY)	NO	NO	STUDENT ACTIVITY
ACTIVITY_TOTAL_YEARS	Number of years from the initial to the last academic year associated with the activity. This will be an attribute of the person and activity combination and not be automatically totaled.	NUMBER	FUNCTION	(SELECT COUNT(DISTINCT ACADEMIC_YEAR) FROM MST_STUDENT_ACTIVITY ACT WHERE ACT.PERSON_UID = SA.PERSON_UID AND ACT.STUDENT_ACTIVITY = SA.STUDENT_ACTIVITY)	NO	NO	STUDENT ACTIVITY
DEMOGRAPHIC_KEY	Key for the demographic dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT ACTIVITY
MULTI_SOURCE_KEY	Key for the multi source dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT ACTIVITY
PERSON_UID	Key for the person dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT ACTIVITY
STUDENT_ACTIVITY_COUNT_KEY	Key for the student activity count.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT ACTIVITY
STUDENT_ACTIVITY_GROUP_KEY	Key for the student activity group.	NUMBER	ETL_GENERATED	NA	NO	NO	STUDENT ACTIVITY
STUDENT_ACTIVITY_KEY	Key for the student activity dimension.	NUMBER	ETL_GENERATED	NA	NO	NO	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