SFA_STDNT_AWD

(SQL Table)
 Index Back

Student Award PeriodTable

STDNT_AWD_PER is the child table to STUDENT_AID. This table contains COA, EFC, and need data for the academic and/or non standard award periods.

  • Parent record: SUSP_PROF_CNTRL

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 SFA_PF_QUEUE_INST Number(9,0) DECIMAL(9) NOT NULL Load Instance
    2 CSS_ID Character(7) VARCHAR2(7) NOT NULL CSS ID Number
    3 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Default Value: OPR_DEF_TBL_CS.INSTITUTION

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: AID_YEAR_TBL

    5 APP_SOURCE_CODE Character(1) VARCHAR2(1) NOT NULL Application Source Code
    0=Need Access
    0=Need Access
    1=Electronic Initial Application
    2=Electronic Renewal Aplication
    3=Electronic Correction
    4=FAFSA Express
    5=ACT
    6=I-NET
    7=NCS
    8=Profile
    9=Institutional Application
    O=FT Canada Student Loan
    P=PT Canada Student Loan
    6 AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
    A=Academic
    N=Non Standard

    Default Value: A

    7 INST_DEPEND_STAT Character(1) VARCHAR2(1) NOT NULL Depend Stat (Inst)
    D=Dependent
    I=Independent
    M=Married
    S=Sole Support
    8 FED_DEPEND_STAT Character(1) VARCHAR2(1) NOT NULL Depend Stat (Fed)
    D=Dependent
    I=Independent
    M=Married
    S=Sole Support
    9 FED_EFC Signed Number(7,0) DECIMAL(6) NOT NULL Federal EFC
    10 EFC_STATUS Character(1) VARCHAR2(1) NOT NULL EFC Status Indicator
    O=Official
    R=Rejected
    U=Unofficial
    Z=Provisional

    Default Value: U

    11 INST_EFC Number(6,0) INTEGER NOT NULL Institutional EFC
    12 FED_NEED_BASE_AID Number(9,2) DECIMAL(8,2) NOT NULL N/B Aid (Fed)
    13 INST_NEED_BASE_AID Number(9,2) DECIMAL(8,2) NOT NULL N/B Aid (Inst)
    14 FED_YEAR_COA Number(9,2) DECIMAL(8,2) NOT NULL Fed Year COA
    15 INST_YEAR_COA Number(9,2) DECIMAL(8,2) NOT NULL Inst Year COA
    16 PELL_YEAR_COA Number(9,2) DECIMAL(8,2) NOT NULL Pell Year COA
    17 FED_NEED Number(9,2) DECIMAL(8,2) NOT NULL Fed Need
    18 INST_NEED Number(9,2) DECIMAL(8,2) NOT NULL Inst Need
    19 FED_UNMET_NEED Number(9,2) DECIMAL(8,2) NOT NULL Unmet Need (Fed)
    20 FED_OVRAWD_AMT Number(9,2) DECIMAL(8,2) NOT NULL Overaward (Fed)
    21 INST_UNMET_NEED Number(9,2) DECIMAL(8,2) NOT NULL Unmet Need (Inst)
    22 INST_OVRAWD_AMT Number(9,2) DECIMAL(8,2) NOT NULL Overaward (Inst)
    23 FED_PARENT_CONTRB Signed Number(7,0) DECIMAL(6) NOT NULL Parents Contribution - Federal
    24 INST_PARENT_CONTRB Signed Number(7,0) DECIMAL(6) NOT NULL Parents Contribution - Inst
    25 FED_STDNT_CONTRB Signed Number(7,0) DECIMAL(6) NOT NULL Student Contribution - Federal
    26 INST_STDNT_CONTRB Signed Number(7,0) DECIMAL(6) NOT NULL Student Contribution - Inst
    27 INST_EFC_OVERIDE Character(1) VARCHAR2(1) NOT NULL Override Institutional EFC

    Y/N Table Edit

    Default Value: N

    28 BASE_WEEKS Number(4,1) DECIMAL(3,1) NOT NULL Base Number of Weeks
    29 WEEKS_ENROLLED Number(4,1) DECIMAL(3,1) NOT NULL Number of Weeks Enrolled
    30 WEEKLY_PC Signed Number(7,0) DECIMAL(6) NOT NULL Weekly EFC Parent Contribution
    31 WEEKLY_SC Signed Number(7,0) DECIMAL(6) NOT NULL Weekly EFC Stdnt Contribution
    32 PRORATED_EFC Signed Number(7,0) DECIMAL(6) NOT NULL Prorated EFC