SFA_ASG_ELIGSRC

(SQL View)
 Index Back

ACG/SMART Eligibility Detail

Stores information about a student's ACG/SMART eligibility.

SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,A.SFA_ASG_GRANT_TYPE ,A.STRM ,B.SFA_ASG_ELIG_STAT FROM PS_SFA_ASG_ELIG A , PS_SFA_ASG_ELIGDTL B WHERE A.EMPLID=B.EMPLID AND A.INSTITUTION=B.INSTITUTION AND A.AID_YEAR=B.AID_YEAR AND A.AID_YEAR > '2007' AND A.SFA_ASG_GRANT_TYPE=B.SFA_ASG_GRANT_TYPE AND A.STRM=B.STRM AND B.SFA_ASG_ELIG_SEQ =( SELECT MAX(C.SFA_ASG_ELIG_SEQ) FROM PS_SFA_ASG_ELIGDTL C WHERE C.EMPLID=B.EMPLID AND C.INSTITUTION=B.INSTITUTION AND C.AID_YEAR=B.AID_YEAR AND C.SFA_ASG_GRANT_TYPE=B.SFA_ASG_GRANT_TYPE AND C.STRM=B.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: SFA_ASG_AIDYRVW

    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: SFA_ASG_AY_TRM

    6 SFA_ASG_ELIG_STAT Character(1) VARCHAR2(1) NOT NULL Eligibility Status
    C=Cancelled
    E=Eligible
    I=Ineligible
    N=Not Verified
    R=Eligible, pending review
    X=Ineligible, pending review