STDNT_AWP_AIDVW

(SQL View)
 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.

SELECT A.EMPLID ,A.INSTITUTION ,A.AID_YEAR ,A.AWARD_PERIOD ,A.FED_EFC ,A.EFC_STATUS ,A.INST_EFC ,A.FED_NEED_BASE_AID ,A.INST_NEED_BASE_AID ,A.FED_YEAR_COA ,A.INST_YEAR_COA ,A.PELL_YEAR_COA ,A.FED_NEED ,A.INST_NEED ,A.FED_UNMET_NEED ,A.FED_OVRAWD_AMT ,A.INST_UNMET_NEED ,A.INST_OVRAWD_AMT ,A.FED_PARENT_CONTRB ,A.INST_PARENT_CONTRB ,A.FED_STDNT_CONTRB ,A.INST_STDNT_CONTRB ,A.INST_EFC_OVERIDE ,A.BASE_WEEKS ,A.WEEKS_ENROLLED ,A.WEEKLY_PC ,A.WEEKLY_SC ,A.PRORATED_EFC ,A.FED_SPECIAL_AID ,A.INST_SPECIAL_AID ,A.FED_TOTAL_AID ,A.INST_TOTAL_AID ,A.FED_UNMET_COA ,A.INST_UNMET_COA ,A.FED_OVRAWD_COA ,A.INST_OVRAWD_COA ,A.VET_ED_BENEFIT ,A.VET_ED_FAN_PRINT ,A.PRORATED_PAR_CNTRB ,A.PRORATED_STU_CNTRB ,B.INST_DEPEND_STAT ,B.FED_DEPEND_STAT ,A.BDGT_DURATION_FED ,A.BDGT_DURATION_INST ,B.INAS_RULE_SET_INST ,B.INAS_RULE_SET_FED ,B.EFC_USE_IM FROM PS_STDNT_AWD_PER A , PS_STUDENT_AID B WHERE A.EMPLID = B.EMPLID AND A.INSTITUTION = B.INSTITUTION AND A.AID_YEAR = B.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: PEOPLE_SRCH

    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: STUDENT_AID

    4 AWARD_PERIOD Character(1) VARCHAR2(1) NOT NULL Award Period
    A=Academic
    N=Non Standard

    Default Value: A

    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

    Default Value: U

    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

    Default Value: N

    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

    Default Value: N

    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 INST_DEPEND_STAT Character(1) VARCHAR2(1) NOT NULL Depend Stat (Inst)
    D=Dependent
    I=Independent
    M=Married
    S=Sole Support
    42 FED_DEPEND_STAT Character(1) VARCHAR2(1) NOT NULL Depend Stat (Fed)
    D=Dependent
    I=Independent
    M=Married
    S=Sole Support
    43 BDGT_DURATION_FED Number(2,0) SMALLINT NOT NULL Budget Duration
    44 BDGT_DURATION_INST Number(4,1) DECIMAL(3,1) NOT NULL Budget Duration
    45 INAS_RULE_SET_INST Character(4) VARCHAR2(4) NOT NULL INAS Rule Set
    BASE=CSS Rules/Values
    HLTH=Health Professional
    STD=Undergrad/Graduate
    46 INAS_RULE_SET_FED Character(4) VARCHAR2(4) NOT NULL INAS Rule Set
    BASE=CSS Rules/Values
    HLTH=Health Professional
    STD=Undergrad/Graduate
    47 EFC_USE_IM Character(1) VARCHAR2(1) NOT NULL Use Which EFC
    F=Estimated Federal
    G=Greatest
    I=Institutional
    O=Institutional W/Opt