SFA_ASG_ORGDFLT

(SQL Table)
 Index Back

ACG/SMART Origination Defaults

Holds default values for ACG and SMART Grant Programs. Values in this table will be pulled by ACG/SMART Origination process and stored in the ACG/SMART Origination records.

  • Parent record: SFA_COD_STUDENT

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
    2 SFA_COD_ELIGRSN_CD Character(2) VARCHAR2(2) NOT NULL ACG Eligibility Reason
    01=High School Program
    02=AP/International Bac Course
    03=Coursework
    3 SFA_COD_HS_PROG_CD Character(6) VARCHAR2(6) NOT NULL Rigorous High School Program

    Prompt Table: SFA_ASG_HSPR_VW

    4 SFA_COD_PROGCIP_CD Character(7) VARCHAR2(7) NOT NULL SMART Eligible CIP Code

    Prompt Table: SFA_ASG_CIP_VW

    5 SFA_COD_STDNT_LVL Character(1) VARCHAR2(1) NOT NULL Student Level
    0=1st year ugrd never attend
    1=1st year ugrd prev attended
    2=2nd year ugrd
    3=3rd year ugrd
    4=4th year ugrd
    5=5th year ugrd