STDNT_AWDPR_TMP(SQL Table) |
Index Back |
|---|---|
Student Award Period Temp TblSTDNT_AWD_PER is the child table to STUDENT_AID. This temporary/work table contains COA, EFC, and need data for the academic and/or non standard award periods used in the Awarding process. |
| # | 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 |
| 39 | SFA_PELLYR_COA_LHT | Number(9,2) | DECIMAL(8,2) NOT NULL | Used to calculate Less than Half Time Pell Year COA. |
| 40 | SFA_RPKG_PLAN_ID | Character(10) | VARCHAR2(10) NOT NULL | Repackaging Plan ID |
| 41 | SFA_PRCNT_USED_TOT | Number(8,4) | DECIMAL(7,4) NOT NULL | Total Percent Scheduled Used |