RETURN TO REPORTING VIEW REPORTS LIST
Common Reporting View Reports

SGHE Operational Data Store
Reporting View Target: ACTIVITY

Description Contains all of the activity and leadership combinations recorded for the person by the institution, including academic period related activities when the person was a student as well as subsequent activities stored for an alumnus of the institution.
Key & Frequency One row per person per activity and leadership role or per activity and academic period.
Recommended Search Columns ENTITY_UID

Target Column Business Definition Database Data Type Source Name Source Column
ACADEMIC_PERIOD Academic period or time frame this sport activity was recorded for the student. VARCHAR2(63)

SGRSACT

SGRSACT_TERM_CODE

ACADEMIC_PERIOD_DESC Academic period description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

ACADEMIC_YEAR Academic year associated with the academic period. VARCHAR2(63)

STVTERM

STVTERM_ACYR_CODE

ACADEMIC_YEAR_DESC Academic year description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

SGRSACT

APRACTY_ACTC_CODE

SGRSACT_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_COMMENT Comments that describe anything special or unique about this person's participation in this activity. VARCHAR2(255)

APRACTY

APRACTY_COMMENT

ACTIVITY_DESC Student activity description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_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

ADVANCEMENT_ACTIVITY_IND Indicates that this data is from Advancement. CHAR(1)

CONSTANT

'N'

'Y'

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

APRACTY

SGRSACT

APRACTY_PIDM

SGRSACT_PIDM

FIRST_YEAR Initial or earliest year of participation in this activity. NUMBER

FUNCTION

AOKODSF.F_GET_ACTIVITY_YEAR_COUNT

ID Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

LAST_YEAR Last or most recent year of participation in this activity. NUMBER

FUNCTION

AOKODSF.F_GET_ACTIVITY_YEAR_COUNT

LEADERSHIP_ACTIVITY_BEGIN_DATE Date the activity participation began. DATE

APRACLD

APRACLD_BEGIN_DATE

LEADERSHIP_ACTIVITY_END_DATE Date the activity participation ended. DATE

APRACLD

APRACLD_END_DATE

LEADERSHIP_COMMENT Comments that describe anything special or unique about this person's participation in this activity. VARCHAR2(400)

APRACLD

APRACLD_COMMENT

LEADERSHIP_ROLE Specifies the activity to represent a type of leadership activity. VARCHAR2(63)

APRACLD

STVACTC

APRACLD_LEAD_CODE

STVACTC_LEAD_CODE

LEADERSHIP_ROLE_DESC Type of leadership description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

NAME Name of the person (last name, first name, middle initial) or organization. VARCHAR2(94)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

NA

NA

SUB_ACADEMIC_PERIOD A session, portion or part of the academic period. VARCHAR2(63)

NA

NA

SUB_ACADEMIC_PERIOD_DESC Sub academic period description. VARCHAR2(255)

NA

NA

TOTAL_YEARS Total number of years associated with a particular special activity. NUMBER

FUNCTION

AOKODSF.F_GET_ACTIVITY_YEAR_COUNT



Ver: 3.1