FAN_AWD_SEL_VW(SQL View) |
Index Back |
|---|---|
Student Award Period ViewSTDNT_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. This is a view used by FANLTR equations, because equations cannot read long varchars. |
| SELECT INSTITUTION ,AID_YEAR ,EMPLID ,AWARD_PERIOD ,FED_EFC ,EFC_STATUS ,INST_EFC ,FED_NEED_BASE_AID ,INST_NEED_BASE_AID ,FED_YEAR_COA ,INST_YEAR_COA ,PELL_YEAR_COA ,FED_NEED ,INST_NEED ,FED_UNMET_NEED ,FED_OVRAWD_AMT ,INST_UNMET_NEED ,INST_OVRAWD_AMT ,FED_PARENT_CONTRB ,INST_PARENT_CONTRB ,FED_STDNT_CONTRB ,INST_STDNT_CONTRB ,INST_EFC_OVERIDE ,BASE_WEEKS ,WEEKS_ENROLLED ,WEEKLY_PC ,WEEKLY_SC ,PRORATED_EFC ,FED_SPECIAL_AID ,INST_SPECIAL_AID ,FED_TOTAL_AID ,INST_TOTAL_AID ,FED_UNMET_COA ,INST_UNMET_COA ,FED_OVRAWD_COA ,INST_OVRAWD_COA ,VET_ED_BENEFIT ,VET_ED_FAN_PRINT ,PRORATED_PAR_CNTRB ,PRORATED_STU_CNTRB ,BDGT_DURATION_FED ,BDGT_DURATION_INST ,FANLTR_STATUS ,FANLTR_STATUS_PREH ,INST_CALC_SC ,INST_CALC_PC ,INST_CALC_EFC ,ISIR_CALC_SC ,ISIR_CALC_PC ,ISIR_CALC_EFC ,SFA_PELLYR_COA_LHT FROM PS_STDNT_AWD_PER |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  INSTITUTION |
Character(5) | VARCHAR2(5) NOT NULL |
Academic Institution
Prompt Table: INSTITUTION_TBL |
| 2 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: STUDENT_AID |
| 3 | EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSONAL_DATA |
| 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. |