SFA_AWDPER_SUMM

(SQL View)
 Index Back

Student Award Period Summary

This is a summary view that adds the 'A' and 'N' rows and yields a 'B' row. Character fields return the maximum between the two rows.

SELECT MAX(EMPLID) ,MAX(INSTITUTION) ,MAX(AID_YEAR) ,'B' ,SUM(FED_EFC) ,MAX(EFC_STATUS) ,SUM(INST_EFC) ,SUM(FED_NEED_BASE_AID) ,SUM(INST_NEED_BASE_AID) ,SUM(FED_YEAR_COA) ,SUM(INST_YEAR_COA) ,SUM(PELL_YEAR_COA) ,SUM(FED_NEED) ,SUM(INST_NEED) ,SUM(FED_UNMET_NEED) ,SUM(FED_OVRAWD_AMT) ,SUM(INST_UNMET_NEED) ,SUM(INST_OVRAWD_AMT) ,SUM(FED_PARENT_CONTRB) ,SUM(INST_PARENT_CONTRB) ,SUM(FED_STDNT_CONTRB) ,SUM(INST_STDNT_CONTRB) ,MAX(INST_EFC_OVERIDE) ,SUM(BASE_WEEKS) ,SUM(WEEKS_ENROLLED) ,SUM(WEEKLY_PC) ,SUM(WEEKLY_SC) ,SUM(PRORATED_EFC) ,SUM(FED_SPECIAL_AID) ,SUM(INST_SPECIAL_AID) ,SUM(FED_TOTAL_AID) ,SUM(INST_TOTAL_AID) ,SUM(FED_UNMET_COA) ,SUM(INST_UNMET_COA) ,SUM(FED_OVRAWD_COA) ,SUM(INST_OVRAWD_COA) ,SUM(VET_ED_BENEFIT) ,MAX(VET_ED_FAN_PRINT) ,SUM(PRORATED_PAR_CNTRB) ,SUM(PRORATED_STU_CNTRB) ,SUM(BDGT_DURATION_FED) ,SUM(BDGT_DURATION_INST) ,MAX(FANLTR_STATUS) ,MAX(FANLTR_STATUS_PREH) ,SUM(INST_CALC_SC) ,SUM(INST_CALC_PC) ,SUM(INST_CALC_EFC) ,SUM(ISIR_CALC_SC) ,SUM(ISIR_CALC_PC) ,SUM(ISIR_CALC_EFC) ,SUM(SFA_PELLYR_COA_LHT) FROM PS_STDNT_AWD_PER GROUP BY EMPLID ,INSTITUTION ,AID_YEAR

  • Parent record: STUDENT_AID

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID

    Prompt Table: PERSONAL_DATA

    2 INSTITUTION Character(5) VARCHAR2(5) NOT NULL Academic Institution

    Prompt Table: INSTITUTION_TBL

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

    Prompt Table: STUDENT_AID

    4 AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
    A=Academic
    N=Non Standard
    5 FED_EFC Signed Number(7,0) DECIMAL(6) NOT NULL Federal EFC
    6 EFC_STATUS Character(1) VARCHAR2(1) NOT NULL EFC Status Indicator
    O=Official
    R=Rejected
    U=Unofficial
    Z=Provisional
    7 INST_EFC Number(6,0) INTEGER NOT NULL Institutional EFC
    8 FED_NEED_BASE_AID Number(9,2) DECIMAL(8,2) NOT NULL N/B Aid (Fed)
    9 INST_NEED_BASE_AID Number(9,2) DECIMAL(8,2) NOT NULL N/B Aid (Inst)
    10 FED_YEAR_COA Number(9,2) DECIMAL(8,2) NOT NULL Fed Year COA
    11 INST_YEAR_COA Number(9,2) DECIMAL(8,2) NOT NULL Inst Year COA
    12 PELL_YEAR_COA Number(9,2) DECIMAL(8,2) NOT NULL Pell Year COA
    13 FED_NEED Number(9,2) DECIMAL(8,2) NOT NULL Fed Need
    14 INST_NEED Number(9,2) DECIMAL(8,2) NOT NULL Inst Need
    15 FED_UNMET_NEED Number(9,2) DECIMAL(8,2) NOT NULL Unmet Need (Fed)
    16 FED_OVRAWD_AMT Number(9,2) DECIMAL(8,2) NOT NULL Overaward (Fed)
    17 INST_UNMET_NEED Number(9,2) DECIMAL(8,2) NOT NULL Unmet Need (Inst)
    18 INST_OVRAWD_AMT Number(9,2) DECIMAL(8,2) NOT NULL Overaward (Inst)
    19 FED_PARENT_CONTRB Signed Number(7,0) DECIMAL(6) NOT NULL Parents Contribution - Federal
    20 INST_PARENT_CONTRB Signed Number(7,0) DECIMAL(6) NOT NULL Parents Contribution - Inst
    21 FED_STDNT_CONTRB Signed Number(7,0) DECIMAL(6) NOT NULL Student Contribution - Federal
    22 INST_STDNT_CONTRB Signed Number(7,0) DECIMAL(6) NOT NULL Student Contribution - Inst
    23 INST_EFC_OVERIDE Character(1) VARCHAR2(1) NOT NULL Override Institutional EFC

    Y/N Table Edit

    24 BASE_WEEKS Number(4,1) DECIMAL(3,1) NOT NULL Base Number of Weeks
    25 WEEKS_ENROLLED Number(4,1) DECIMAL(3,1) NOT NULL Number of Weeks Enrolled
    26 WEEKLY_PC Signed Number(7,0) DECIMAL(6) NOT NULL Weekly EFC Parent Contribution
    27 WEEKLY_SC Signed Number(7,0) DECIMAL(6) NOT NULL Weekly EFC Stdnt Contribution
    28 PRORATED_EFC Signed Number(7,0) DECIMAL(6) NOT NULL Prorated EFC
    29 FED_SPECIAL_AID Number(9,2) DECIMAL(8,2) NOT NULL Special Need/Cost Aid (Fed)
    30 INST_SPECIAL_AID Number(9,2) DECIMAL(8,2) NOT NULL Special Need/Cost Aid (Inst)
    31 FED_TOTAL_AID Number(9,2) DECIMAL(8,2) NOT NULL Total Aid (Fed)
    32 INST_TOTAL_AID Number(9,2) DECIMAL(8,2) NOT NULL Total Aid (Inst)
    33 FED_UNMET_COA Number(9,2) DECIMAL(8,2) NOT NULL Unmet COA(Fed)
    34 INST_UNMET_COA Number(9,2) DECIMAL(8,2) NOT NULL Unmet COA(Inst)
    35 FED_OVRAWD_COA Number(9,2) DECIMAL(8,2) NOT NULL COA Overaward(Fed)
    36 INST_OVRAWD_COA Number(9,2) DECIMAL(8,2) NOT NULL COA Overaward(Inst)
    37 VET_ED_BENEFIT Number(5,0) INTEGER NOT NULL Educational Resources
    38 VET_ED_FAN_PRINT Character(1) VARCHAR2(1) NOT NULL Print as Other Resource

    Y/N Table Edit

    39 PRORATED_PAR_CNTRB Signed Number(7,0) DECIMAL(6) NOT NULL Prorated Parent Contribution
    40 PRORATED_STU_CNTRB Signed Number(7,0) DECIMAL(6) NOT NULL Prorated Student Contribution
    41 BDGT_DURATION_FED Number(2,0) SMALLINT NOT NULL Budget Duration
    42 BDGT_DURATION_INST Number(4,1) DECIMAL(3,1) NOT NULL Budget Duration
    43 FANLTR_STATUS Character(4) VARCHAR2(4) NOT NULL Fin Aid Award Notification Letter (FANLTR) Status
    HOLD=Hold
    INIT=Initial
    PRTD=Printed
    REV=Revised
    44 FANLTR_STATUS_PREH Character(4) VARCHAR2(4) NOT NULL Prior value of FanLtr_Status, before it was changed to HOLD status.
    45 INST_CALC_SC Signed Number(8,0) DECIMAL(7) NOT NULL Non-Overridden Institutional SC calculated by INAS.
    46 INST_CALC_PC Signed Number(8,0) DECIMAL(7) NOT NULL Non-Overridden Institutional PC calculated by INAS.
    47 INST_CALC_EFC Signed Number(8,0) DECIMAL(7) NOT NULL Non-Overridden Institutional EFC calculated by INAS.
    48 ISIR_CALC_SC Signed Number(7,0) DECIMAL(6) NOT NULL Non-Overridden Federal SC calculated by INAS.
    49 ISIR_CALC_PC Signed Number(7,0) DECIMAL(6) NOT NULL Non-Overridden Federal PC calculated by INAS.
    50 ISIR_CALC_EFC Signed Number(7,0) DECIMAL(6) NOT NULL Non-Overridden Federal EFC calculated by INAS.
    51 SFA_PELLYR_COA_LHT Number(9,2) DECIMAL(8,2) NOT NULL Used to calculate Less than Half Time Pell Year COA.