SUSP_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 CSS_ID Character(7) VARCHAR2(7) NOT NULL CSS ID Number
    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

    Prompt Table: AID_YEAR_TBL

    4 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
    5 AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
    A=Academic
    N=Non Standard

    Default Value: A

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

    Default Value: U

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

    Y/N Table Edit

    Default Value: N

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