FED_S_CALC(SQL Table) |
Index Back |
|---|---|
Federal Meth Computed ValsThis record is houses the 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 | TAXABLE_INCOME | Signed Number(12,0) | DECIMAL(11) NOT NULL | Taxable Income |
| 6 | UNTAXED_INC_BEN | Signed Number(12,0) | DECIMAL(11) NOT NULL | Untaxed Income |
| 7 | INCOME_ADJUSTMENTS | Signed Number(11,0) | DECIMAL(10) NOT NULL | Income Adjustments |
| 8 | TOTAL_INCOME | Signed Number(16,0) | DECIMAL(15) NOT NULL | Total Income |
| 9 | FED_TAX_PD | Signed Number(12,0) | DECIMAL(11) NOT NULL | U.S. Income Tax |
| 10 | STATE_TAX_PD | Signed Number(12,0) | DECIMAL(11) NOT NULL | State Income Tax |
| 11 | FICA_TAX_PD | Signed Number(12,0) | DECIMAL(11) NOT NULL | FICA Taxes |
| 12 | EMPLMNT_ALLWNCE | Signed Number(5,0) | DECIMAL(4) NOT NULL | Employment Allowance |
| 13 | INC_PROTECTN_ALWNC | Signed Number(8,0) | DECIMAL(7) NOT NULL | Inc Protection Allowance |
| 14 | TOTAL_ALLWNCE | Signed Number(12,0) | DECIMAL(11) NOT NULL | Total Allowances |
| 15 | CALC_AVAIL_INCOME | Signed Number(9,0) | DECIMAL(8) NOT NULL | Calc Avail Income |
| 16 | AVAILABLE_INCOME | Signed Number(9,0) | DECIMAL(8) NOT NULL | Available Income |
| 17 | CASH_SAVINGS | Signed Number(11,0) | DECIMAL(10) NOT NULL | Cash Savings |
| 18 | RE_INVEST_VALUE | Signed Number(11,0) | DECIMAL(10) NOT NULL | Real Estate Invest Value |
| 19 | ADJ_BUS_FARM_VAL | Signed Number(9,0) | DECIMAL(8) NOT NULL | Adj Bus/Farm Val |
| 20 | TRUSTS | Signed Number(12,0) | DECIMAL(11) NOT NULL | Value of Trusts |
| 21 | NET_WORTH | Signed Number(9,0) | DECIMAL(8) NOT NULL | Net Worth |
| 22 | ASSET_PROT_ALLWNCE | Signed Number(6,0) | DECIMAL(5) NOT NULL | Asset Protection Allwnc |
| 23 | DISC_NET_WORTH | Signed Number(10,0) | DECIMAL(9) NOT NULL | Discretionary Net Worth |
| 24 | CONV_PERCENTAGE | Number(4,1) | DECIMAL(3,1) NOT NULL | Conversion Pct |
| 25 | INCOME_SUPP | Signed Number(10,0) | DECIMAL(9) NOT NULL | Income Supp |
| 26 | ADJ_AVAIL_INC | Signed Number(10,0) | DECIMAL(9) NOT NULL | Adj Avail Inc |
| 27 | TOTAL_CONTRIB | Signed Number(8,0) | DECIMAL(7) NOT NULL | Total Contribution |
| 28 | NUM_IN_COLL | Character(1) | VARCHAR2(1) NOT NULL | Nbr in College |
| 29 | CONTRIB_FOR_STDNT | Signed Number(6,0) | DECIMAL(5) NOT NULL | Contrib for Std |
| 30 | INCOME_CONTRIB | Signed Number(7,0) | DECIMAL(6) NOT NULL | Tot Cont Income |
| 31 | ASSET_CONTRIB | Signed Number(7,0) | DECIMAL(6) NOT NULL | Tot Cont Assets |
| 32 | HOME_EQUITY | Signed Number(8,0) | DECIMAL(7) NOT NULL | Home Equity |
| 33 | MED_DENT_EXPENSES | Signed Number(11,0) | DECIMAL(10) NOT NULL | Medical/Dental |
| 34 | IRA_VALUE | Signed Number(11,0) | DECIMAL(10) NOT NULL | IRA, Keogh, 401K Value |
| 35 | ELEM_SEC_TUIT | Signed Number(6,0) | DECIMAL(5) NOT NULL | Elem/Sec Tuition |
| 36 | INST_CALC_SC | Signed Number(8,0) | DECIMAL(7) NOT NULL | Non-Overridden Institutional SC calculated by INAS. |
| 37 | SFA_PF_STUCONTRI14 | Signed Number(11,0) | DECIMAL(10) NOT NULL | Contribution For Student |
| 38 | SFA_PF_INCCONTRI14 | Signed Number(11,0) | DECIMAL(10) NOT NULL | Contribution From Income |
| 39 | SFA_PF_ASTCONTRI14 | Signed Number(11,0) | DECIMAL(10) NOT NULL | Contribution From Assets |
| 40 | SFA_INST_CALC_SC | Signed Number(8,0) | DECIMAL(7) NOT NULL | Non-Overridden Institutional SC calculated by INAS. |
| 41 | SFA_PF_CHLD_SUPRCV | Number(10,0) | DECIMAL(10) NOT NULL | Child Support Received Student |
| 42 | SFA_NAC_EFM_SIA | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Parent Income Additions |
| 43 | SFA_NAC_EFM_SIO | Number(15,0) | DECIMAL(15) NOT NULL | 2425:Parent Income Additions |
| 44 | SFA_NAC_BYPASS_CAL | Character(1) | VARCHAR2(1) NOT NULL | Bypass Calculation |
| 45 | SFA_ALWNC_PNAAI | Number(15,0) | DECIMAL(15) NOT NULL | Stu Allwnc Parent Negative AAI |
| 46 | SFA_NAC_EFM_AAI | Signed Number(16,0) | DECIMAL(15) NOT NULL | Adjusted Available Income |
| 47 | SFA_EFM_ALWNC_PAAI | Signed Number(16,0) | DECIMAL(15) NOT NULL | Student's Allowance for AAI |
| 48 | SFA_NAC_EFM_APA | Signed Number(13,0) | DECIMAL(12) NOT NULL | Asset Protection Allowance |
| 49 | SFA_NAC_EFM_AV_INC | Signed Number(16,0) | DECIMAL(15) NOT NULL | Available Income |
| 50 | SFA_EFM_CNTRB_ASET | Signed Number(13,0) | DECIMAL(12) NOT NULL | Contribution From Assets |
| 51 | SFA_EFM_INC_CONTRI | Signed Number(16,0) | DECIMAL(15) NOT NULL | Contribution From Income |
| 52 | SFA_EFM_CNRB_SAAI | Signed Number(16,0) | DECIMAL(15) NOT NULL | Student Contribution From SAAI |
| 53 | SFA_EFM_EMPEXPALWN | Signed Number(16,0) | DECIMAL(15) NOT NULL | Employment Expense Allowance |
| 54 | SFA_EFM_INC_ALWNC | Signed Number(16,0) | DECIMAL(15) NOT NULL | Income Allowances |
| 55 | SFA_NAC_EFM_IPA | Signed Number(16,0) | DECIMAL(15) NOT NULL | Income Protection Allowance |
| 56 | SFA_EFM_PAY_ALWNC | Signed Number(16,0) | DECIMAL(15) NOT NULL | Payroll Tax Allowance |
| 57 | SFA_NAC_EFM_TOTINC | Signed Number(16,0) | DECIMAL(15) NOT NULL | Total Income |