RETURN TO REPORTING VIEW REPORTS LIST
Advancement Reporting View Reports

SGHE 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

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

APRACTY

APRACTY_ACTC_CODE

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

STVACTC

STVACTC_ACCG_CODE

ACTIVITY_CATEGORY_DESC Activity category description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACTIVITY_DATE Date record was inserted or updated DATE

NA

SYSDATE

ACTIVITY_DESC Student activity description. VARCHAR2(255)

STVACTC

STVACTC_DESC

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

STVACTC

STVACTC_ACTP_CODE

ACTIVITY_TYPE_DESC Activity type description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ADMINISTRATIVE_GROUP Organization-oriented identifier used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

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

APRACTY

APRACTY_ACTC_CODE

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

NA

NA

MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)

NA

NA

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

APRACYR

APRACYR_YEAR

PARTICIPATION_YEAR10 Year that the person participated in the activity recorded. NUMBER

APRACYR

APRACYR_YEAR

PARTICIPATION_YEAR2 Year that the person participated in the activity recorded. NUMBER

APRACYR

APRACYR_YEAR

PARTICIPATION_YEAR3 Year that the person participated in the activity recorded. NUMBER

APRACYR

APRACYR_YEAR

PARTICIPATION_YEAR4 Year that the person participated in the activity recorded. NUMBER

APRACYR

APRACYR_YEAR

PARTICIPATION_YEAR5 Year that the person participated in the activity recorded. NUMBER

APRACYR

APRACYR_YEAR

PARTICIPATION_YEAR6 Year that the person participated in the activity recorded. NUMBER

APRACYR

APRACYR_YEAR

PARTICIPATION_YEAR7 Year that the person participated in the activity recorded. NUMBER

APRACYR

APRACYR_YEAR

PARTICIPATION_YEAR8 Year that the person participated in the activity recorded. NUMBER

APRACYR

APRACYR_YEAR

PARTICIPATION_YEAR9 Year that the person participated in the activity recorded. NUMBER

APRACYR

APRACYR_YEAR

PARTICIPATION_YEAR_DESC1 Participation year description. VARCHAR2(255)

NA

NA

PARTICIPATION_YEAR_DESC10 Participation year description. VARCHAR2(255)

NA

NA

PARTICIPATION_YEAR_DESC2 Participation year description. VARCHAR2(255)

NA

NA

PARTICIPATION_YEAR_DESC3 Participation year description. VARCHAR2(255)

NA

NA

PARTICIPATION_YEAR_DESC4 Participation year description. VARCHAR2(255)

NA

NA

PARTICIPATION_YEAR_DESC5 Participation year description. VARCHAR2(255)

NA

NA

PARTICIPATION_YEAR_DESC6 Participation year description. VARCHAR2(255)

NA

NA

PARTICIPATION_YEAR_DESC7 Participation year description. VARCHAR2(255)

NA

NA

PARTICIPATION_YEAR_DESC8 Participation year description. VARCHAR2(255)

NA

NA

PARTICIPATION_YEAR_DESC9 Participation year description. VARCHAR2(255)

NA

NA

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

NA

NA



Ver: 3.1