ATHL_PART_SPORT

(SQL Table)
Index Back

Athletic Participation Sport

This is the effective dated header record for Athletic Participation Status. These records maintain information about a students participation in university/college sponsored sports.

  • Parent record: PERSON
  • # 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