/
Rolling athlete coding from one term to the next - REG_ROLL_ATHLETE_TERM_C

Rolling athlete coding from one term to the next - REG_ROLL_ATHLETE_TERM_C

This process copies a current athlete’s Banner coding to a future term. The process must be run in audit mode and sent to Athletics for approval before updating the students' records.

Appworx request

REG_ROLL_ATHLETE_TERM_C

Parameters

  • Enter the current term code (to pull athlete’s status) - required

    • run for the current registration term

  • Enter the term code to roll athletes to - required

    • enter the upcoming term

  • Run Mode - required

    • Run in Audit (A) mode

      • The process generates the two output files listed below. Send both files to Athletics for approval, Charvi Greer (jgreer1@tulane.edu) and Erinn Banks (ebanks2@tulane.edu).

        • athlete_rolled_(UPCOMING TERM)_A.txt

        • athlete_not_rolled_(UPCOMING TERM)_A.txt

    • Run in Update (U) mode to update student records

      • Once Athletics has approved, run the process in update mode. The output files will then have a U designation:

        • athlete_rolled_(UPCOMING TERM)_U.txt

        • athlete_not_rolled_(UPCOMING TERM)_U.txt

Process Documentation

  1. Prompts:

    1. image-20241216-144625.png

  2. Passes in the current term code getting all the athletes that are registered for the current term: 

    1. To be considered an athlete, the student must have a record in table sgrsprt (Banner screen SGASPRT) for current term

    2. Example:

    3. image-20241216-144730.png

    4. Has a time status of:

      1. 00           No Enrolled Hours

      2. CF            Part Time CS (report as FT)

      3. CH           Part Time CS (report as HT)

      4. CL            Part Time CS (report as LH)

      5. CQ Part Time CS (report as QT)

      6. FT            Full Time

      7. HT           Half Time

      8. LH            Less than Half Time

      9. QT Three Quarter Time

      10. RS            Research

    5. Has a registration status of:

      1. EL            Eligible to Register

      2. RE            Reinstate

    6. Course registration status not:

      1. DC           **Web Dropped**

      2. DD           Dropped/Deleted

      3. DW         **Dropped/Deleted**

  3. Passes in the next term code getting all the students that were gathered above AND are enrolled in the next term

    1. Has a time status of:

      1. 00           No Enrolled Hours

      2. CF            Part Time CS (report as FT)

      3. CH           Part Time CS (report as HT)

      4. CL            Part Time CS (report as LH)

      5. CQ Part Time CS (report as QT)

      6. FT            Full Time

      7. HT           Half Time

      8. LH            Less than Half Time

      9. QT Three Quarter Time

      10. RS            Research

    2. Has a registration status of:

      1. EL            Eligible to Register

      2. RE            Reinstate

    3. Course registration status not:

      1. DC           **Web Dropped**

      2. DD           Dropped/Deleted

      3. DW         **Dropped/Deleted**

  4. Creates 2 reports called: (passes A for Audit or U for Update)

    1. Athlete_not_rolled… (ex: athlete_not_rolled_202510_A.txt) = those students in #2 above but not in #3

    2. Athlete_rolled… (ex: athlete_rolled_202510_A.txt) = those students that were captured in both #2 and #3 above

  5. Passes in run mode.

    1. If it is U, then it INSERTS the athletes into table sgrsprt for that next term.

 

On this page

Related content