ISIR_COMPUTED(SQL Table) |
Index Back |
|---|---|
Computed Data from INAS/DOEThis table contains all the computed fields from the Dept. of Education. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: PERSON |
| 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 | PRIMARY_EFC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Primary EFC |
| 8 | SECONDARY_EFC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Secondary EFC |
| 9 | PELL_SPCL_PRM_EFC | Signed Number(6,0) | DECIMAL(5) NOT NULL | PELL Special Primary EFC |
| 10 | PELL_SPCL_SEC_EFC | Signed Number(6,0) | DECIMAL(5) NOT NULL | PELL Special Secondary EFC |
| 11 | PELL_PAID_EFC_TYPE | Character(1) | VARCHAR2(1) NOT NULL | Pell Paid EFC Type |
| 12 | VALID_EFC_CALC | Character(1) | VARCHAR2(1) NOT NULL |
Valid EFC Calc
Y/N Table Edit |
| 13 | AUTO_ZERO_EFC | Character(1) | VARCHAR2(1) NOT NULL |
Auto Zero EFC
Y=EFC Set To Zero |
| 14 | FORMULA_TYPE | Character(1) | VARCHAR2(1) NOT NULL |
Formula Type
1=Full Needs Test: Dependent 2=Full Needs Test: Ind w/out Dep 3=Full Needs Test: Ind w/Deps 4=Simplified: Dependent 5=Simplified: Ind w/out Deps 6=Simplified: Indep w/Deps A=Dependent B=Independent w/o dependents C=Independent with dependents G=Boolean I=Iterative R=Regular |
| 15 | PRM_ALT_MONTH_1 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 1 |
| 16 | PRM_ALT_MONTH_2 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 2 |
| 17 | PRM_ALT_MONTH_3 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 3 |
| 18 | PRM_ALT_MONTH_4 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 4 |
| 19 | PRM_ALT_MONTH_5 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 5 |
| 20 | PRM_ALT_MONTH_6 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 6 |
| 21 | PRM_ALT_MONTH_7 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 7 |
| 22 | PRM_ALT_MONTH_8 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 8 |
| 23 | PRM_ALT_MONTH_10 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 10 |
| 24 | PRM_ALT_MONTH_11 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 11 |
| 25 | PRM_ALT_MONTH_12 | Character(6) | VARCHAR2(6) NOT NULL | Primary Alternate Month 12 |
| 26 | SEC_ALT_MONTH_1 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 1 |
| 27 | SEC_ALT_MONTH_2 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 2 |
| 28 | SEC_ALT_MONTH_3 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 3 |
| 29 | SEC_ALT_MONTH_4 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 4 |
| 30 | SEC_ALT_MONTH_5 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 5 |
| 31 | SEC_ALT_MONTH_6 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 6 |
| 32 | SEC_ALT_MONTH_7 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 7 |
| 33 | SEC_ALT_MONTH_8 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 8 |
| 34 | SEC_ALT_MONTH_10 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 10 |
| 35 | SEC_ALT_MONTH_11 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 11 |
| 36 | SEC_ALT_MONTH_12 | Character(6) | VARCHAR2(6) NOT NULL | Secondary Alternate Month 12 |
| 37 | TOTAL_INCOME | Signed Number(16,0) | DECIMAL(15) NOT NULL | Total Income |
| 38 | ALWNC_AGAINST_TI | Signed Number(8,0) | DECIMAL(7) NOT NULL | Total Allowances |
| 39 | STATE_TAX_ALWNC | Signed Number(8,0) | DECIMAL(7) NOT NULL | State Tax Allowance |
| 40 | EMPLOYMENT_ALWNC | Signed Number(8,0) | DECIMAL(7) NOT NULL | Employment Allowance |
| 41 | INC_PROTECTN_ALWNC | Signed Number(8,0) | DECIMAL(7) NOT NULL | Inc Protection Allowance |
| 42 | AVAILABLE_INCOME | Signed Number(9,0) | DECIMAL(8) NOT NULL | Available Income |
| 43 | DESCRTN_NET_WORTH | Signed Number(8,0) | DECIMAL(7) NOT NULL | Discretionary Net Worth |
| 44 | AST_PROTECTN_ALWNC | Signed Number(8,0) | DECIMAL(7) NOT NULL | Asset Protection Allowance |
| 45 | CONTRIB_FROM_ASSET | Signed Number(8,0) | DECIMAL(7) NOT NULL | Contribution from Assets |
| 46 | ADJ_AVAILABLE_INC | Signed Number(9,0) | DECIMAL(8) NOT NULL | Adj Available Income |
| 47 | TOTAL_PAR_CONTRIB | Signed Number(8,0) | DECIMAL(7) NOT NULL | Total Parent Contribution |
| 48 | TOTAL_STU_CONTRIB | Signed Number(8,0) | DECIMAL(7) NOT NULL | Total Student Contribution |
| 49 | ADJ_PAR_CONTRIB | Signed Number(8,0) | DECIMAL(7) NOT NULL | Parent Contribution |
| 50 | DEP_STU_I_CONTRIB | Signed Number(8,0) | DECIMAL(7) NOT NULL | Student Income Contribution |
| 51 | DEP_STU_A_CONTRIB | Signed Number(8,0) | DECIMAL(7) NOT NULL | Student Asset Contribution |
| 52 | STU_TOTAL_INC | Signed Number(16,0) | DECIMAL(15) NOT NULL | Students Total Income |
| 53 | CONTRIB_AVAIL_INC | Signed Number(8,0) | DECIMAL(7) NOT NULL | Contribution Available Income |
| 54 | FICA_TAX_PD | Signed Number(12,0) | DECIMAL(11) NOT NULL | FICA Taxes |
| 55 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 56 | EFC_CALC_DT | Date(10) | DATE | EFC Calc'd On |
| 57 | BUDGET_DURATION | Number(2,0) | SMALLINT NOT NULL | Budget Duration |
| 58 | ADJ_EFC_AMT | Signed Number(6,0) | DECIMAL(5) NOT NULL | Adjust EFC |
| 59 | WEEKLY_PC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Weekly EFC Parent Contribution |
| 60 | WEEKLY_SC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Weekly EFC Stdnt Contribution |
| 61 | PRORATED_EFC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Prorated EFC |
| 62 | SECONDARY_EFC_TP | Character(1) | VARCHAR2(1) NOT NULL | Secondary EFC Type |
| 63 | EFC_NET_WORTH | Number(9,0) | DECIMAL(9) NOT NULL | EFC Net Worth |
| 64 | STU_ALLOW_VS_TI | Signed Number(8,0) | DECIMAL(7) NOT NULL | Student's Allowance VS TI |
| 65 | STU_DISC_NET_WORTH | Signed Number(10,0) | DECIMAL(9) NOT NULL | Student's Disc Net Worth |
| 66 | SEC_NET_WORTH | Number(9,0) | DECIMAL(9) NOT NULL | Secondary Net Worth |
| 67 | SEC_ALLOW_VS_TI | Signed Number(8,0) | DECIMAL(7) NOT NULL | Sec Stu Allow VS Total Income |
| 68 | SEC_SDNW | Signed Number(8,0) | DECIMAL(7) NOT NULL | Sec Stu Disc Net Worth |
| 69 | PAID_EFC | Signed Number(6,0) | DECIMAL(5) NOT NULL | Paid EFC |
| 70 | ISIR_CALC_SC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Non-Overridden Federal SC calculated by INAS. |
| 71 | ISIR_CALC_PC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Non-Overridden Federal PC calculated by INAS. |
| 72 | ISIR_CALC_EFC | Signed Number(7,0) | DECIMAL(6) NOT NULL | Non-Overridden Federal EFC calculated by INAS. |
| 73 | SFA_SIG_REJ_EFC | Number(6,0) | INTEGER NOT NULL | Signature Reject EFC |
| 74 | SFA_PRIMARY_PC | Signed Number(12,0) | DECIMAL(11) NOT NULL | Primary Parent Contrb |
| 75 | SFA_PRIMARY_SCA | Signed Number(12,0) | DECIMAL(11) NOT NULL | Primary Stu Contrb from Assets |
| 76 | SFA_PRIMARY_SIC | Signed Number(12,0) | DECIMAL(11) NOT NULL | Primary Stu Contrb from Income |
| 77 | SFA_COMPUT_TYPE | Character(2) | VARCHAR2(2) NOT NULL | 2425 : Computation Type |
| 78 | SFA_MAX_PELLIND | Character(1) | VARCHAR2(1) NOT NULL | 2425: Maximum Pell Indicator |
| 79 | SFA_MIN_PELLIND | Character(1) | VARCHAR2(1) NOT NULL | 2425: Minimum Pell Indicator |
| 80 | SFA_FPS_STD_FWS | Number(12,0) | DECIMAL(12) NOT NULL | 2425:Student Total Federal Work Study Earnings |
| 81 | SFA_FPS_SPS_FWS | Number(12,0) | DECIMAL(12) NOT NULL | 2425:Student Spouse Total Federal Work Study Earnings |
| 82 | SFA_FPS_PAR_FWS | Number(12,0) | DECIMAL(12) NOT NULL | 2425:Parent Total Federal Work Study Earnings |
| 83 | SFA_FPS_OTH_FWS | Number(12,0) | DECIMAL(12) NOT NULL | 2425:Other Parent Total Federal Work Study Earnings |
| 84 | SFA_FPS_PAR_ALLOW | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Total Parent Allowances Against Income |
| 85 | SFA_FPS_PAR_PAYROL | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Parent Payroll Tax Allowance |
| 86 | SFA_FPS_PAR_IPA | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Parent Income Protection Allowance (IPA)� |
| 87 | SFA_FPS_PEEA | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Parent Employment Expense Allowance (PEEA) |
| 88 | SFA_FPS_PAI | Signed Number(16,0) | DECIMAL(15) NOT NULL | 2425:Parent Available Income (PAI) |
| 89 | SFA_FPS_PAAI | Signed Number(16,0) | DECIMAL(15) NOT NULL | 2425:Parent Adjusted Available Income (PAAI) |
| 90 | SFA_FPS_PC | Signed Number(16,0) | DECIMAL(15) NOT NULL | 2425:Parent Contribution (PC) |
| 91 | SFA_FPS_STD_PAYROL | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Student Payroll Tax Allowance |
| 92 | SFA_FPS_STD_IPA | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Student Income Protection Allowance (IPA)� |
| 93 | SFA_FPS_ALLOW | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Student Allowance for Parents negative Adjusted Available Income |
| 94 | SFA_FPS_SEEA | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Student Employment Expense Allowance (SEEA) |
| 95 | SFA_FPS_STD_ALLOW | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Total Student Allowances Against Income |
| 96 | SFA_FPS_STAI | Signed Number(16,0) | DECIMAL(15) NOT NULL | 2425:Student Available Income (StAI) |
| 97 | SFA_FPS_SCI | Signed Number(16,0) | DECIMAL(15) NOT NULL | 2425:Student Contribution from Income (SCI) |
| 98 | SFA_FPS_SAAI | Signed Number(16,0) | DECIMAL(15) NOT NULL | 2425:Student Adjusted Available Income (SAAI) |
| 99 | SFA_FPS_TOT_SAAI | Signed Number(16,0) | DECIMAL(15) NOT NULL | 2425:Total Student Contribution from SAAI |
| 100 | SFA_FPS_PIA | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Parent Income Additions |
| 101 | SFA_FPS_PIO | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Parent Income Additions |
| 102 | SFA_FPS_PNW | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Parent Income Additions |
| 103 | SFA_FPS_SNW | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Parent Income Additions |
| 104 | SFA_FPS_SIA | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Parent Income Additions |
| 105 | SFA_FPS_SIO | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Parent Income Additions |
| 106 | SFA_FPS_PDNW | Number(7,0) | INTEGER NOT NULL | Parent Discretionary Net Worth |
| 107 | SFA_FPS_PAPA | Number(12,0) | DECIMAL(12) NOT NULL | 2425:Parent Asset Protection Allowance |
| 108 | SFA_FPS_PCA | Number(12,0) | DECIMAL(12) NOT NULL | 2425:Parent Contribution from Assets |
| 109 | SFA_FPS_SAPA | Number(12,0) | DECIMAL(12) NOT NULL | 2425:Student Asset Protection Allowance |
| 110 | SFA_FPS_SCA | Number(12,0) | DECIMAL(12) NOT NULL | 2425:Student Contribution from Assets (SCA) |
| 111 | SFA_FPS_TSC | Signed Number(16,0) | DECIMAL(15) NOT NULL | 2425:Total Student Contribution |