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

SGHE Banner Operational Data Store
Reporting View Target: SPORT

Description Contains data regarding persons who are involved in official institution sports activities and need to be tracked within the system. For example, the NCAA details required for reporting on students participating in the sport are accessed using this reporting view.
Key & Frequency One row per person per academic period per activity.
Recommended Search Columns PERSON_UID, ACADEMIC_PERIOD, ACTIVITY

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ACADEMIC_PERIOD Academic period or time frame this sport activity was recorded for the student.    

SGRSPRT

SGRSPRT_TERM_CODE

 
ACADEMIC_PERIOD_DESC Academic period description.    

FUNCTION

GOKODSF.F_GET_DESC

 
ACADEMIC_YEAR Academic year associated with the academic period on this record.    

FUNCTION

GOKODSF.F_GET_DESC

 
ACADEMIC_YEAR_DESC Academic year description.    

FUNCTION

GOKODSF.F_GET_DESC

 
ACTIVITY Activity that identifies student participation that is to be recorded. Activities may include fraternity or sorority, chess or debate clubs, etc.    

SGRSPRT

SGRSPRT_ACTC_CODE

 
ACTIVITY_CATEGORY Category associated with the activity so that like activities can be grouped for reporting.    

STVACTC

STVACTC_ACCG_CODE

 
ACTIVITY_CATEGORY_DESC Activities category description.    

FUNCTION

GOKODSF.F_GET_DESC

 
ACTIVITY_DESC Student activity description.    

FUNCTION

GOKODSF.F_GET_DESC

 
ACTIVITY_TYPE Specifies a broad type of activity in which the specific activity can be grouped (for example, Sports, Cultural, or Volunteer).    

STVACTC

STVACTC_ACTP_CODE

 
ACTIVITY_TYPE_DESC Activity type description.    

FUNCTION

GOKODSF.F_GET_DESC

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

NA

NA

 
ATHLETIC_ACADEMIC_ELIGIBLE Athletic eligibility reporting code.    

SGRSPRT

SGRSPRT_SAEL_CODE

 
ATHLETIC_ACAD_ELIGIBLE_DESC Athletic eligibility reporting code description.    

FUNCTION

GOKODSF.F_GET_DESC

 
ATHLETIC_AID_IND Indicates whether the athletic sport is providing the student financial assistance.    

SGRSPRT

SGRSPRT_ATHL_AID_IND

 
ATHLETIC_SPORT_ACTIVE_IND Indicates whether the student with the associated sports status is active in the sport.    

STVSPST

STVSPST_ACTIVE_IND

 
BEGIN_ACAD_PERIOD_ELIGIBLE Starting academic eligibility term for the athletic competition.    

SGRATHC

SGRATHC_ELIG_BEGIN_TERM_CODE

 
BEGIN_ACAD_PERIOD_ELIG_DESC Beginning academic period eligible description.    

FUNCTION

GOKODSF.F_GET_DESC

 
ELIGIBILITY Identifies the person is eligible to participate in an official sport.    

SGRSPRT

SGRSPRT_ELIG_CODE

 
ELIGIBILITY_DESC Eligibility code description.    

FUNCTION

GOKODSF.F_GET_DESC

 
END_ACAD_PERIOD_ELIGIBLE Ending academic eligibility term for the athletic competition.    

SGRATHC

SGRATHC_ELIG_END_TERM_CODE

 
END_ACAD_PERIOD_ELIGIBLE_DESC Ending academic period eligible description.    

FUNCTION

GOKODSF.F_GET_DESC

 
ID Person's or organization's current identification number.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
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

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

SGRSPRT

SGRSPRT_PIDM

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

NA

NA

 
SEASONS_COMPETITION_AVAILABLE Number of seasons competition is available.    

SGRATHC

SGRATHC_SEASONS_AVAILABLE

 
SEASONS_COMPETITION_REMAINING Number of remaining seasons of competition available.    

CALCUATION

SEASONS_COMPETITION_AVAILABLE - SEASONS_COMPETITION_USED

 
SEASONS_COMPETITION_USED Number of used seasons of competition.    

FUNCTION

TO BE FILLED IN BY DEVELOPER

 
SEASONS_USED_IND Indicates used season of competition.    

SGRATHC

SGRATHC_SEASONS_USED_IND

 
SEASON_CHANGE_REASON Reason for a change to the number of seasons available.    

SGRATHC

SGRATHC_SARE_CODE

 
SEASON_CHANGE_REASON_DESC Season change reason description.    

FUNCTION

GOKODSF.F_GET_DESC

 
SPORT_ACTIVITY_DATE Date record was inserted or updated.    

SGRSPRT

SGRSPRT_ACTIVITY_DATE

 
SPORT_STATUS Identifies the person's current sport's status for the sport in this record.    

SGRSPRT

SGRSPRT_SPST_CODE

 
SPORT_STATUS_DESC Sport status description.    

FUNCTION

GOKODSF.F_GET_DESC

 
SUB_ACADEMIC_PERIOD A session, portion or part of the academic period.    

NA

NA

 
SUB_ACADEMIC_PERIOD_DESC Sub academic period description.    

NA

NA

 


Ver: 8.3