INST_P_OPT_CALC(SQL Table) |
Index Back |
|---|---|
Institutional Computed ValuesThis record houses INAS calculations for Institutional Methodology as part of the institutional application data. |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  EMPLID |
Character(11) | VARCHAR2(11) NOT NULL |
Employee ID
Prompt Table: STDNT_AID_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 | APP_SOURCE_CODE |
Character(1) | VARCHAR2(1) NOT NULL |
Application Source Code
0=Need Access 0=Need Access 1=Electronic Initial Application 2=Electronic Renewal Aplication 3=Electronic Correction 4=FAFSA Express 5=ACT 6=I-NET 7=NCS 8=Profile 9=Institutional Application O=FT Canada Student Loan P=PT Canada Student Loan |
| 5 | ANALYSIS_TYPE | Character(3) | VARCHAR2(3) NOT NULL | Analysis Type |
| 6 | TAXABLE_INCOME | Signed Number(12,0) | DECIMAL(11) NOT NULL | Taxable Income |
| 7 | UNTAXED_INC_BEN | Signed Number(12,0) | DECIMAL(11) NOT NULL | Untaxed Income |
| 8 | ADJ_TO_INCOME | Signed Number(11,0) | DECIMAL(10) NOT NULL | Adjustments to Income |
| 9 | TOTAL_INCOME | Signed Number(16,0) | DECIMAL(15) NOT NULL | Total Income |
| 10 | FED_TAX_PD | Signed Number(12,0) | DECIMAL(11) NOT NULL | U.S. Income Tax |
| 11 | STATE_TAX_PD | Signed Number(12,0) | DECIMAL(11) NOT NULL | State Income Tax |
| 12 | FICA_TAX_PD | Signed Number(12,0) | DECIMAL(11) NOT NULL | FICA Taxes |
| 13 | MED_DENT_EXPENSES | Signed Number(11,0) | DECIMAL(10) NOT NULL | Medical/Dental |
| 14 | ELEM_SEC_TUIT | Signed Number(6,0) | DECIMAL(5) NOT NULL | Elem/Sec Tuition |
| 15 | EMPLMNT_ALLWNCE | Signed Number(5,0) | DECIMAL(4) NOT NULL | Employment Allowance |
| 16 | INC_PROT_ALLWNCE | Signed Number(6,0) | DECIMAL(5) NOT NULL | Inc Protection Allwnc |
| 17 | TOTAL_ALLWNCE | Signed Number(12,0) | DECIMAL(11) NOT NULL | Total Allowances |
| 18 | CALC_AVAIL_INCOME | Signed Number(9,0) | DECIMAL(8) NOT NULL | Calc Avail Income |
| 19 | AVAILABLE_INCOME | Signed Number(9,0) | DECIMAL(8) NOT NULL | Available Income |
| 20 | CASH_SAVINGS | Signed Number(11,0) | DECIMAL(10) NOT NULL | Cash Savings |
| 21 | IRA_VALUE | Signed Number(11,0) | DECIMAL(10) NOT NULL | IRA, Keogh, 401K Value |
| 22 | HOME_EQUITY | Signed Number(8,0) | DECIMAL(7) NOT NULL | Home Equity |
| 23 | RE_INVEST_EQUITY | Signed Number(9,0) | DECIMAL(8) NOT NULL | RE & Invest Equity |
| 24 | ADJ_BUS_FARM_VAL | Signed Number(9,0) | DECIMAL(8) NOT NULL | Adj Bus/Farm Val |
| 25 | TRUSTS | Signed Number(12,0) | DECIMAL(11) NOT NULL | Value of Trusts |
| 26 | NET_WORTH | Signed Number(9,0) | DECIMAL(8) NOT NULL | Net Worth |
| 27 | ASSET_PROT_ALLWNCE | Signed Number(6,0) | DECIMAL(5) NOT NULL | Asset Protection Allwnc |
| 28 | DISC_NET_WORTH | Signed Number(10,0) | DECIMAL(9) NOT NULL | Discretionary Net Worth |
| 29 | CONV_PERCENTAGE | Number(4,1) | DECIMAL(3,1) NOT NULL | Conversion Pct |
| 30 | INCOME_SUPP | Signed Number(10,0) | DECIMAL(9) NOT NULL | Income Supp |
| 31 | ADJ_AVAIL_INC | Signed Number(10,0) | DECIMAL(9) NOT NULL | Adj Avail Inc |
| 32 | TOTAL_CONTRIB | Signed Number(8,0) | DECIMAL(7) NOT NULL | Total Contribution |
| 33 | NUM_IN_COLL | Character(1) | VARCHAR2(1) NOT NULL | Nbr in College |
| 34 | CONTRIB_FOR_STDNT | Signed Number(6,0) | DECIMAL(5) NOT NULL | Contrib for Std |
| 35 | INCOME_CONTRIB | Signed Number(7,0) | DECIMAL(6) NOT NULL | Tot Cont Income |
| 36 | ASSET_CONTRIB | Signed Number(7,0) | DECIMAL(6) NOT NULL | Tot Cont Assets |
| 37 | ANN_ED_SAV_ALWNC | Signed Number(9,0) | DECIMAL(8) NOT NULL | Annual Ed Savings Allowance |
| 38 | ASSETS_SIBLINGS | Signed Number(9,0) | DECIMAL(8) NOT NULL | Assets in Sibling's Name |
| 39 | EMERG_RESRV_ALWNC | Signed Number(9,0) | DECIMAL(8) NOT NULL | Emergency Reserve Allowance |
| 40 | CUM_EDUC_SAV_ALWNC | Signed Number(9,0) | DECIMAL(8) NOT NULL | Cumulative Ed Savings Allwnce |
| 41 | LOW_INC_ASSET_ALLW | Signed Number(9,0) | DECIMAL(8) NOT NULL | Low Income Asset Allowance |
| 42 | NUM_IN_COL_ADJ_PCT | Signed Number(6,1) | DECIMAL(4,1) NOT NULL | Number In College Adj Percent |
| 43 | INST_CALC_PC | Signed Number(8,0) | DECIMAL(7) NOT NULL | Non-Overridden Institutional PC calculated by INAS. |
| 44 | SFA_CP_PERCENT_INC | Character(3) | VARCHAR2(3) NOT NULL | Custodial Parent Percent Inc |
| 45 | SFA_CP_INC_CONTRIB | Signed Number(6,0) | DECIMAL(5) NOT NULL | Custodial Parnt Contrib Income |
| 46 | SFA_CP_AST_CONTRIB | Signed Number(6,0) | DECIMAL(5) NOT NULL | Custodial Parnt Contrib Assets |
| 47 | SFA_CP_TOT_CONTRIB | Signed Number(6,0) | DECIMAL(5) NOT NULL | Custodial Parent Total Income |
| 48 | SFA_CP_NIC_ADJ_PCT | Number(3,0) | SMALLINT NOT NULL | Number in College Adjustment |
| 49 | SFA_PF_STUCONTRI14 | Signed Number(11,0) | DECIMAL(10) NOT NULL | Contribution For Student |
| 50 | SFA_PF_INCCONTRI14 | Signed Number(11,0) | DECIMAL(10) NOT NULL | Contribution From Income |
| 51 | SFA_PF_ASTCONTRI14 | Signed Number(11,0) | DECIMAL(10) NOT NULL | Contribution From Assets |
| 52 | SFA_PF_CP_TOTCON14 | Signed Number(11,0) | DECIMAL(10) NOT NULL | Total Parent Contribution |
| 53 | SFA_PF_CP_INCCON14 | Signed Number(11,0) | DECIMAL(10) NOT NULL | Contribution From Income |
| 54 | SFA_PF_CP_ASTCON14 | Signed Number(11,0) | DECIMAL(10) NOT NULL | Contribution From Assets |
| 55 | SFA_INST_CALC_PC | Signed Number(8,0) | DECIMAL(7) NOT NULL | Non-Overridden Institutional PC calculated by INAS. |