ATHL_PART_STAT

(SQL Table)
 Index Back

Athletic Participation Status

This record maintains information about a student's participation in university/college sponsored sports. The athletic paricipation codes defaults a student's status and NCAA eligibility.

  • Parent record: ATHL_PART_SPORT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PEOPLE_SRCH

    2 SPORT Character(3) VARCHAR2(3) NOT NULL Sport
    BA=Baseball
    BB=Basketball
    CC=Cross Country
    CR=Crew
    FB=Football
    GO=Golf
    GY=Gymnastics
    IT=Indoor Track
    NO=None
    OT=Outdoor Track
    SB=Softball
    SO=Soccer
    SW=Swimming
    TN=Tennis
    TR=Track
    UN=Unknown
    VB=Volleyball
    WP=Water Polo
    WR=Wrestling

    Prompt Table: ATHL_PART_SPORT

    3 EFFDT Date(10) DATE NOT NULL Effective Date

    Default Value: %date

    4 ATHL_PARTIC_CD Character(5) VARCHAR2(5) NOT NULL Athletic Participation Code

    Prompt Table: ATHL_PART_TBL

    5 NCAA_ELIGIBLE Character(1) VARCHAR2(1) NOT NULL NCAA Eligible

    Y/N Table Edit

    6 CUR_PARTICIPANT Character(1) VARCHAR2(1) NOT NULL Current Participant

    Y/N Table Edit

    7 DESCRLONG Long Character CLOB Long Description