Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Advancement Composite View Reports

SGHE Banner Operational Data Store
Composite View Target: AA_SPECIAL_ACTIVITY_YEAR

Description Special advancement activity year composite view will be repeating data and store all of the years recorded for a person's participation in an activity.

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column
ACTIVITY Activity This field specifies the special activity code. VARCHAR2(8)  

APRACTY

APRACTY_ACTC_CODE

ACTIVITY_CATEGORY Activity Category This field specifies the activity category code. VARCHAR2(5)  

STVACTC

STVACTC_ACCG_CODE

ACTIVITY_CATEGORY_DESC Actvitiy Category Description This field specifies the description of the activity category code. VARCHAR2(30)  

FUNCTION

GOKODSF.F_GET_DESC

ACTIVITY_DESC Activity Description This field specifies a student activity associated with the activity code. VARCHAR2(30)  

STVACTC

STVACTC_DESC

ACTIVITY_TYPE Activity Type This field specifies the code for the activity type. VARCHAR2(5)  

STVACTC

STVACTC_ACTP_CODE

ACTIVITY_TYPE_DESC Activity Type Description This field specifies the description of the activity code. VARCHAR2(30)  

FUNCTION

GOKODSF.F_GET_DESC

CURRENT_DATE Current Date This is the current date. DATE  

NA

SYSDATE

DOMAIN_VALUE Domain Value Domain column for future use, not currently populated. VARCHAR2(6)  

NA

NA

ENTITY_UID Entity Uid This field specifies the internal system generated identification number. NUMBER(8)  

APRACTY

APRACTY_PIDM

MIF_DESC Mif Description The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(30)  

NA

NA

MIF_VALUE Mif Value The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column. VARCHAR2(6)  

NA

NA

PARTICIPATION_YEAR Participation Year This field specifies the year that the person participated in the activity recorded. NUMBER(4)  

APRACYR

APRACYR_YEAR

PARTICIPATION_YEAR_DESC Participation Year Description This field specifies the description of the year that the person participated in the activity recorded. VARCHAR2(30)  

NA

NA

ZONE_VALUE Zone Value Zone column for future use, not currently populated. VARCHAR2(6)  

NA

NA



Ver: