Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Advancement Reporting View Reports

SGHE Banner Operational Data Store
Reporting View Target: SPECIAL_ACTIVITY_YEAR_SLOT

Description Uses data from the SPECIAL_ACTIVITY_YEAR reporting view. Displays up to 10 sets of values based on the activity for the entity and currently there are no associated display rules. The last 10 years of participation will be displayed.
Key & Frequency One row per entity per activity.
Recommended Search Columns ENTITY_UID, ACTIVITY, ACTIVITY_TYPE, ACTIVITY_CATEGORY
ACTIVITY_DATE

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACTIVITY Activity recorded for the student or alumnus. Activities may include leadership councils, seminars, fraternity or sorority, chess or debate clubs, etc.    

APRACTY

APRACTY_ACTC_CODE

 
ACTIVITY_CATEGORY Specifies a grouping of activities that can be used for reporting like activites together.    

STVACTC

STVACTC_ACCG_CODE

 
ACTIVITY_CATEGORY_DESC Activity category description.    

FUNCTION

GOKODSF.F_GET_DESC

 
ACTIVITY_DATE Date record was inserted or updated    

NA

SYSDATE

 
ACTIVITY_DESC Student activity description.    

STVACTC

STVACTC_DESC

 
ACTIVITY_TYPE Specifies a type of activity that is used to group like activites together for reporting.    

STVACTC

STVACTC_ACTP_CODE

 
ACTIVITY_TYPE_DESC Activity type description.    

FUNCTION

GOKODSF.F_GET_DESC

 
ADMINISTRATIVE_GROUP Organization-oriented identifier used to determine access authorization to this record. Institution defined.    

NA

NA

 
ENTITY_UID System generated, unique, internal identification number assigned to this person.    

APRACTY

APRACTY_ACTC_CODE

 
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

 
PARTICIPATION_YEAR1 Organization-oriented identifier used to determine access authorization to this record. Institution defined.    

APRACYR

APRACYR_YEAR

 
PARTICIPATION_YEAR10 Year that the person participated in the activity recorded.    

APRACYR

APRACYR_YEAR

 
PARTICIPATION_YEAR2 Year that the person participated in the activity recorded.    

APRACYR

APRACYR_YEAR

 
PARTICIPATION_YEAR3 Year that the person participated in the activity recorded.    

APRACYR

APRACYR_YEAR

 
PARTICIPATION_YEAR4 Year that the person participated in the activity recorded.    

APRACYR

APRACYR_YEAR

 
PARTICIPATION_YEAR5 Year that the person participated in the activity recorded.    

APRACYR

APRACYR_YEAR

 
PARTICIPATION_YEAR6 Year that the person participated in the activity recorded.    

APRACYR

APRACYR_YEAR

 
PARTICIPATION_YEAR7 Year that the person participated in the activity recorded.    

APRACYR

APRACYR_YEAR

 
PARTICIPATION_YEAR8 Year that the person participated in the activity recorded.    

APRACYR

APRACYR_YEAR

 
PARTICIPATION_YEAR9 Year that the person participated in the activity recorded.    

APRACYR

APRACYR_YEAR

 
PARTICIPATION_YEAR_DESC1 Participation year description.    

NA

NA

 
PARTICIPATION_YEAR_DESC10 Participation year description.    

NA

NA

 
PARTICIPATION_YEAR_DESC2 Participation year description.    

NA

NA

 
PARTICIPATION_YEAR_DESC3 Participation year description.    

NA

NA

 
PARTICIPATION_YEAR_DESC4 Participation year description.    

NA

NA

 
PARTICIPATION_YEAR_DESC5 Participation year description.    

NA

NA

 
PARTICIPATION_YEAR_DESC6 Participation year description.    

NA

NA

 
PARTICIPATION_YEAR_DESC7 Participation year description.    

NA

NA

 
PARTICIPATION_YEAR_DESC8 Participation year description.    

NA

NA

 
PARTICIPATION_YEAR_DESC9 Participation year description.    

NA

NA

 
PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 


Ver: 8.3