SFA_ASG_ELGPAVW

(SQL View)
 Index Back

ACG/SMART Eligibility GPA Ovrd

Stores information about a student's ACG/SMART GPA Overrode.

SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,A.SFA_ASG_GRANT_TYPE ,A.STRM ,A.SFA_ASG_GPA_OVRD FROM PS_SFA_ASG_ELIGDTL A WHERE A.AID_YEAR > '2007' AND A.SFA_ASG_ELIG_SEQ =( SELECT MAX(B.SFA_ASG_ELIG_SEQ) FROM PS_SFA_ASG_ELIGDTL B WHERE B.EMPLID=A.EMPLID AND B.INSTITUTION=A.INSTITUTION AND B.AID_YEAR=A.AID_YEAR AND B.SFA_ASG_GRANT_TYPE=A.SFA_ASG_GRANT_TYPE AND B.STRM=A.STRM)

  • Parent record: SFA_ASG_ELIG

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

    Prompt Table: SFA_ASG_ORDFSRC

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

    3 AID_YEAR Character(4) VARCHAR2(4) NOT NULL Aid Year

    Default Value: OPR_DEF_TBL_CS.AID_YEAR

    Prompt Table: AID_YEAR_TBL

    4 SFA_ASG_GRANT_TYPE Character(4) VARCHAR2(4) NOT NULL Grant Type
    ACG=Academic Competitiveness
    SMRT=National SMART
    5 STRM Character(4) VARCHAR2(4) NOT NULL Term

    Prompt Table: TERM_VAL_TBL

    6 SFA_ASG_GPA_OVRD Character(1) VARCHAR2(1) NOT NULL GPA Override

    Y/N Table Edit