Data Source	Banner (Oracle)
Job/Process Source (Refresh Interval)	Live
Report Domain	Academic standings for athletes
Functional User(s)
Constituent(s)
Report Owner	Arianna Kennedy
Data Domain(s)	Academic
Contains PII	Yes

What It’s Used For

Report on the academic eligibility status for COS student athletes.

Options

Options	Description

Options	Description
Term	The academic term
Sport	The individual sport of interest (or all)
Student ID	Used to filter down to a specific student’s Banner ID
Eligibility	Eligible/Ineligible/Both - The eligibility status of interest. May also include inactive students.

Field Name	Data Source/Logic	Description (sample)

Field Name	Data Source/Logic	Description (sample)
TERM_CODE	`SGRSPRT_TERM_CODE`	Semester
SPORT	`STVACTC_DESC`	Description of the sport code
ID	`SPRIDEN_ID`	Banner ID
LAST_NAME	`SPRIDEN_LAST_NAME`	Last Name
FIRST_NAME	`SPRIDEN_FIRST_NAME`	First Name
UNITS_REGISTERED	`SUM(NVL(SFRSTCR_CREDIT_HR, 0))`	Registered units
OVERALL_GPA	`COS_F_GET_LGPA(SGRSPRT_PIDM, 'UG', 'O')`	Overall GPA
SPORT_CODE	`SGRSPRT_ACTC_CODE`	Sport Code
ACTIVE_CODE	`DECODE(STVSPST_ACTIVE_IND, 'Y', 'A', SGRSPRT_SPST_CODE)`	Student’s active sport status
ELIGIBILITY_CODE	`SGRSPRT_ELIG_CODE`	Student’s eligibility code
IA_COUNT	`SUM(CASE WHEN SSBSECT_SUBJ_CODE = 'IA' THEN 1 ELSE 0 END)`
RESIDENCE	`F_GET_STUDENT_RESIDENCE(SGRSPRT_PIDM, SGRSPRT_TERM_CODE)`	Student’s residence status
ENROLL_FEES_CHARGED	`SUM(CASE WHEN ac.AR_PAYMENT_TYPE_CODE = 'C' and AC.DETAIL_CODE in ('ENRL', 'ISNR', 'NONR') THEN ac.AR_AMOUNT ELSE NUll END)`
ADDRESS	`SPRADDR_STREET_ADDRESS_LINE1`	Street address
CITY	`SPRADDR_CITY`	City
STATE	`SPRADDR_STAT_CODE`	State
ZIP	`SPRADDR_ZIP`	Zip code
PHONE	`SPRTELE_PHONE_AREA \|\| SPRTELE_PHONE_NUMBER`	Phone number
EMAIL	`COS_F_GET_EMAIL(SPRIDEN_PIDM)`	Email address
SEP_COMPLETION	`F_COMPLETED_EDPLAN(SPRIDEN_PIDM)`	Student education plan completion status

Version	Date	Comment
Current Version (v. 2)	Nov 26, 2024 22:13	Michael Citi
v. 1	Nov 26, 2024 00:32	Michael Citi