ISIR_NEED_VW1(SQL View) |
Index Back |
|---|---|
Need Summary ViewThis table contains those data elements necessary to support professional judgement overrides. |
| SELECT A.EMPLID, A.INSTITUTION, A.AID_YEAR, A.TABLE_ID, B.AGI, C.DEPNDNCY_STAT, A.DEP_STU_A_CONTRIB, A.DEP_STU_I_CONTRIB, A.TOTAL_STU_CONTRIB, A.ALWNC_AGAINST_TI, A.AVAILABLE_INCOME, A.ADJ_PAR_CONTRIB, A.PRIMARY_EFC, A.TOTAL_INCOME, A.VALID_EFC_CALC, A.BUDGET_DURATION, D.AWARD_PERIOD, D.FED_EFC, D.EFC_STATUS, D.INST_EFC, D.FED_NEED_BASE_AID, D.INST_NEED_BASE_AID, D.FED_YEAR_COA, D.INST_YEAR_COA, D.PELL_YEAR_COA, D.FED_NEED, D.INST_NEED, D.FED_UNMET_NEED, D.FED_OVRAWD_AMT, D.INST_UNMET_NEED, D.INST_OVRAWD_AMT, D.FED_PARENT_CONTRB, D.INST_PARENT_CONTRB, D.FED_STDNT_CONTRB, D.INST_STDNT_CONTRB, D.INST_EFC_OVERIDE, D.BASE_WEEKS, D.WEEKS_ENROLLED, D.WEEKLY_PC, D.WEEKLY_SC, D.PRORATED_EFC, D.FED_SPECIAL_AID, D.INST_SPECIAL_AID, D.FED_TOTAL_AID, D.INST_TOTAL_AID, D.VET_ED_BENEFIT FROM PS_ISIR_COMPUTED A, PS_ISIR_PARENT B, PS_ISIR_STUDENT C, PS_STDNT_AWD_PER D WHERE A.EFFDT = (SELECT MAX(EFFDT) FROM PS_ISIR_COMPUTED A1 WHERE A1.EMPLID = A.EMPLID AND A1.INSTITUTION = A.INSTITUTION AND A1.AID_YEAR = A.AID_YEAR AND A1.EFFDT <= %currentdatein) AND A.EFFSEQ = (SELECT Max(EFFSEQ) FROM PS_ISIR_COMPUTED A2 WHERE A2.EMPLID = A.EMPLID AND A2.INSTITUTION = A.INSTITUTION AND A2.AID_YEAR = A.AID_YEAR AND A2.EFFDT = A.EFFDT) AND A.EMPLID = B.EMPLID AND A.EMPLID = C.EMPLID AND A.EMPLID = D.EMPLID AND A.INSTITUTION = B.INSTITUTION AND A.INSTITUTION = C.INSTITUTION AND A.INSTITUTION = D.INSTITUTION AND A.AID_YEAR = B.AID_YEAR AND A.AID_YEAR = C.AID_YEAR AND A.AID_YEAR = D.AID_YEAR AND A.EFFDT = B.EFFDT AND A.EFFDT = C.EFFDT AND A.EFFSEQ = B.EFFSEQ AND A.EFFSEQ = C.EFFSEQ |
| # | 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
Prompt Table: INSTITUTION_TBL |
| 3 | AID_YEAR |
Character(4) | VARCHAR2(4) NOT NULL |
Aid Year
Prompt Table: STUDENT_AID |
| 4 | TABLE_ID |
Character(1) | VARCHAR2(1) NOT NULL |
Child Table Key
Default Value: 1 |
| 5 | AGI | Signed Number(11,0) | DECIMAL(10) NOT NULL | Adjusted Gross Income |
| 6 | DEPNDNCY_STAT | Character(1) | VARCHAR2(1) NOT NULL |
Dependency Status
1=Independent 2=Dependent 3=Indepenedent/Pro Judgmnt D=Dependent I=Independent X=Dependent Reject Y=Independent Reject Z=Provisional Independent |
| 7 | DEP_STU_A_CONTRIB | Signed Number(8,0) | DECIMAL(7) NOT NULL | Student Asset Contribution |
| 8 | DEP_STU_I_CONTRIB | Signed Number(8,0) | DECIMAL(7) NOT NULL | Student Income Contribution |
| 9 | TOTAL_STU_CONTRIB | Signed Number(8,0) | DECIMAL(7) NOT NULL | Total Student Contribution |
| 10 | ALWNC_AGAINST_TI | Signed Number(8,0) | DECIMAL(7) NOT NULL | Total Allowances |
| 11 | AVAILABLE_INCOME | Signed Number(9,0) | DECIMAL(8) NOT NULL | Available Income |
| 12 | ADJ_PAR_CONTRIB | Signed Number(8,0) | DECIMAL(7) NOT NULL | Parent Contribution |
| 13 | PRIMARY_EFC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Primary EFC |
| 14 | TOTAL_INCOME | Signed Number(16,0) | DECIMAL(15) NOT NULL | Total Income |
| 15 | VALID_EFC_CALC | Character(1) | VARCHAR2(1) NOT NULL | Valid EFC Calc |
| 16 | BUDGET_DURATION | Number(2,0) | SMALLINT NOT NULL | Budget Duration |
| 17 | AWARD_PERIOD | Character(1) | VARCHAR2(1) NOT NULL |
Award Period
A=Academic N=Non Standard |
| 18 | FED_EFC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Federal EFC |
| 19 | EFC_STATUS | Character(1) | VARCHAR2(1) NOT NULL |
EFC Status Indicator
O=Official R=Rejected U=Unofficial Z=Provisional |
| 20 | INST_EFC | Number(6,0) | INTEGER NOT NULL | Institutional EFC |
| 21 | FED_NEED_BASE_AID | Number(9,2) | DECIMAL(8,2) NOT NULL | N/B Aid (Fed) |
| 22 | INST_NEED_BASE_AID | Number(9,2) | DECIMAL(8,2) NOT NULL | N/B Aid (Inst) |
| 23 | FED_YEAR_COA | Number(9,2) | DECIMAL(8,2) NOT NULL | Fed Year COA |
| 24 | INST_YEAR_COA | Number(9,2) | DECIMAL(8,2) NOT NULL | Inst Year COA |
| 25 | PELL_YEAR_COA | Number(9,2) | DECIMAL(8,2) NOT NULL | Pell Year COA |
| 26 | FED_NEED | Number(9,2) | DECIMAL(8,2) NOT NULL | Fed Need |
| 27 | INST_NEED | Number(9,2) | DECIMAL(8,2) NOT NULL | Inst Need |
| 28 | FED_UNMET_NEED | Number(9,2) | DECIMAL(8,2) NOT NULL | Unmet Need (Fed) |
| 29 | FED_OVRAWD_AMT | Number(9,2) | DECIMAL(8,2) NOT NULL | Overaward (Fed) |
| 30 | INST_UNMET_NEED | Number(9,2) | DECIMAL(8,2) NOT NULL | Unmet Need (Inst) |
| 31 | INST_OVRAWD_AMT | Number(9,2) | DECIMAL(8,2) NOT NULL | Overaward (Inst) |
| 32 | FED_PARENT_CONTRB | Signed Number(7,0) | DECIMAL(6) NOT NULL | Parents Contribution - Federal |
| 33 | INST_PARENT_CONTRB | Signed Number(7,0) | DECIMAL(6) NOT NULL | Parents Contribution - Inst |
| 34 | FED_STDNT_CONTRB | Signed Number(7,0) | DECIMAL(6) NOT NULL | Student Contribution - Federal |
| 35 | INST_STDNT_CONTRB | Signed Number(7,0) | DECIMAL(6) NOT NULL | Student Contribution - Inst |
| 36 | INST_EFC_OVERIDE | Character(1) | VARCHAR2(1) NOT NULL | Override Institutional EFC |
| 37 | BASE_WEEKS | Number(4,1) | DECIMAL(3,1) NOT NULL | Base Number of Weeks |
| 38 | WEEKS_ENROLLED | Number(4,1) | DECIMAL(3,1) NOT NULL | Number of Weeks Enrolled |
| 39 | WEEKLY_PC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Weekly EFC Parent Contribution |
| 40 | WEEKLY_SC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Weekly EFC Stdnt Contribution |
| 41 | PRORATED_EFC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Prorated EFC |
| 42 | FED_SPECIAL_AID | Number(9,2) | DECIMAL(8,2) NOT NULL | Special Need/Cost Aid (Fed) |
| 43 | INST_SPECIAL_AID | Number(9,2) | DECIMAL(8,2) NOT NULL | Special Need/Cost Aid (Inst) |
| 44 | FED_TOTAL_AID | Number(9,2) | DECIMAL(8,2) NOT NULL | Total Aid (Fed) |
| 45 | INST_TOTAL_AID | Number(9,2) | DECIMAL(8,2) NOT NULL | Total Aid (Inst) |
| 46 | VET_ED_BENEFIT | Number(5,0) | INTEGER NOT NULL | Educational Resources |