Versions Compared

Old Version 1

changes.mady.by.user Michael Citi

Saved on

compared with

New Version Current

changes.mady.by.user Michael Citi

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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

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.

📄 Results

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

Code Block
languagesql
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

...

Change History