ISIR_NEED_VW(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.EFFDT , A.EFFSEQ , 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.PRORATED_EFC ,A.BUDGET_DURATION FROM PS_ISIR_COMPUTED A , PS_ISIR_PARENT B , PS_ISIR_STUDENT C where A.Emplid= B.Emplid and A.Emplid = C.Emplid and A.Institution = B.Institution and A.Institution = C.Institution and A.Aid_Year = B.Aid_Year and A.Aid_Year = C.Aid_Year and A.Effdt = B.Effdt and A.Effdt = C.Effdt and A.Effseq = B.Effseq and A.Effseq = C.Effseq and A.Table_ID = B.Table_ID and A.Table_ID = C.Table_ID |
| # | 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 | EFFDT |
Date(10) | DATE NOT NULL |
Effective Date
Default Value: %date |
| 5 | EFFSEQ |
Number(3,0) | SMALLINT NOT NULL | Effective Sequence |
| 6 | TABLE_ID |
Character(1) | VARCHAR2(1) NOT NULL |
Child Table Key
Default Value: 1 |
| 7 | AGI | Signed Number(11,0) | DECIMAL(10) NOT NULL | Adjusted Gross Income |
| 8 | 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 |
| 9 | DEP_STU_A_CONTRIB | Signed Number(8,0) | DECIMAL(7) NOT NULL | Student Asset Contribution |
| 10 | DEP_STU_I_CONTRIB | Signed Number(8,0) | DECIMAL(7) NOT NULL | Student Income Contribution |
| 11 | TOTAL_STU_CONTRIB | Signed Number(8,0) | DECIMAL(7) NOT NULL | Total Student Contribution |
| 12 | ALWNC_AGAINST_TI | Signed Number(8,0) | DECIMAL(7) NOT NULL | Total Allowances |
| 13 | AVAILABLE_INCOME | Signed Number(9,0) | DECIMAL(8) NOT NULL | Available Income |
| 14 | ADJ_PAR_CONTRIB | Signed Number(8,0) | DECIMAL(7) NOT NULL | Parent Contribution |
| 15 | PRIMARY_EFC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Primary EFC |
| 16 | TOTAL_INCOME | Signed Number(16,0) | DECIMAL(15) NOT NULL | Total Income |
| 17 | VALID_EFC_CALC | Character(1) | VARCHAR2(1) NOT NULL | Valid EFC Calc |
| 18 | PRORATED_EFC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Prorated EFC |
| 19 | BUDGET_DURATION | Number(2,0) | SMALLINT NOT NULL | Budget Duration |