SFAATHPARSTATVW

(SQL View)
 Index Back

Athletic Part. Status View

View of ATHL_PART_STAT table for use by financial aid.

SELECT A.EMPLID ,A.SPORT ,A.ATHL_PARTIC_CD ,A.NCAA_ELIGIBLE ,A.CUR_PARTICIPANT FROM PS_ATHL_PART_STAT A WHERE A.EFFDT = ( SELECT MAX(B.EFFDT) FROM PS_ATHL_PART_STAT B WHERE B.EMPLID = A.EMPLID AND B.SPORT = A.SPORT AND B.EFFDT <= %CurrentDateIn )

  • 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 ATHL_PARTIC_CD Character(5) VARCHAR2(5) NOT NULL Athletic Participation Code

    Prompt Table: ATHL_PART_TBL

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

    Y/N Table Edit

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

    Y/N Table Edit