SFA_ASG_ELIGDTL

(SQL Table)
 Index Back

ACG/SMART Eligibility Detail

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

  • 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_ELIG_SEQ Number(3,0) SMALLINT NOT NULL ACG/SMART Eligibility Sequence
    7 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
    8 SFA_ASG_ELIG_DTTM DateTime(26) TIMESTAMP Status Date
    9 SFA_ASG_ACAD_LEVEL Character(1) VARCHAR2(1) NOT NULL Academic Level
    0=1st Year - Never Attended
    1=1st Year - Previously Attended
    2=2nd Year
    3=3rd Year
    4=4th Year
    5=5th Year
    6=Grad/Professional - 1st Year
    7=Grad/Professional - Continuing
    10 SFA_ASG_ACLVL_OVRD Character(1) VARCHAR2(1) NOT NULL Acad Level Override

    Y/N Table Edit

    Default Value: N

    11 SFA_COD_ELIGRSN_CD Character(2) VARCHAR2(2) NOT NULL ACG Eligibility Reason
    01=High School Program
    02=AP/International Bac Course
    03=Coursework
    12 SFA_COD_HS_PROG_CD Character(6) VARCHAR2(6) NOT NULL Rigorous High School Program

    Prompt Table: SFA_ASG_HSPR_VW

    13 CIP_CODE Character(13) VARCHAR2(13) NOT NULL CIP code

    Prompt Table: CIP_CODE_TBL

    14 SFA_ASG_CIPCD_OVRD Character(1) VARCHAR2(1) NOT NULL CIP Code Override

    Y/N Table Edit

    Default Value: N

    15 SFA_ASG_GPA Number(9,3) DECIMAL(8,3) NOT NULL GPA
    16 SFA_ASG_GPA_OVRD Character(1) VARCHAR2(1) NOT NULL GPA Override

    Y/N Table Edit

    Default Value: N

    17 SFA_ASG_DISB_PRTCT Character(1) VARCHAR2(1) NOT NULL Disbursement Protection

    Y/N Table Edit

    Default Value: Y

    18 SFA_ASG_ELIG_SRC Character(1) VARCHAR2(1) NOT NULL Selection Source
    S=System
    U=User