SUSP_PROF_SBCLC(SQL Table) |
Index Back |
|---|---|
Inst Computed Suspense 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 |  CSS_ID |
Character(7) | VARCHAR2(7) NOT NULL | CSS ID Number |
| 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 | EMPLMNT_ALLWNCE | Signed Number(5,0) | DECIMAL(4) NOT NULL | Employment Allowance |
| 15 | INC_PROT_ALLWNCE | Signed Number(6,0) | DECIMAL(5) NOT NULL | Inc Protection Allwnc |
| 16 | TOTAL_ALLWNCE | Signed Number(12,0) | DECIMAL(11) NOT NULL | Total Allowances |
| 17 | CALC_AVAIL_INCOME | Signed Number(9,0) | DECIMAL(8) NOT NULL | Calc Avail Income |
| 18 | AVAILABLE_INCOME | Signed Number(9,0) | DECIMAL(8) NOT NULL | Available Income |
| 19 | CASH_SAVINGS | Signed Number(11,0) | DECIMAL(10) NOT NULL | Cash Savings |
| 20 | HOME_EQUITY | Signed Number(8,0) | DECIMAL(7) NOT NULL | Home Equity |
| 21 | RE_INVEST_EQUITY | Signed Number(9,0) | DECIMAL(8) NOT NULL | RE & Invest Equity |
| 22 | ADJ_BUS_FARM_VAL | Signed Number(9,0) | DECIMAL(8) NOT NULL | Adj Bus/Farm Val |
| 23 | TRUSTS | Signed Number(12,0) | DECIMAL(11) NOT NULL | Value of Trusts |
| 24 | NET_WORTH | Signed Number(9,0) | DECIMAL(8) NOT NULL | Net Worth |
| 25 | ASSET_PROT_ALLWNCE | Signed Number(6,0) | DECIMAL(5) NOT NULL | Asset Protection Allwnc |
| 26 | DISC_NET_WORTH | Signed Number(10,0) | DECIMAL(9) NOT NULL | Discretionary Net Worth |
| 27 | CONV_PERCENTAGE | Number(4,1) | DECIMAL(3,1) NOT NULL | Conversion Pct |
| 28 | INCOME_SUPP | Signed Number(10,0) | DECIMAL(9) NOT NULL | Income Supp |
| 29 | ADJ_AVAIL_INC | Signed Number(10,0) | DECIMAL(9) NOT NULL | Adj Avail Inc |
| 30 | TOTAL_CONTRIB | Signed Number(8,0) | DECIMAL(7) NOT NULL | Total Contribution |
| 31 | NUM_IN_COLL | Character(1) | VARCHAR2(1) NOT NULL | Nbr in College |
| 32 | CONTRIB_FOR_STDNT | Signed Number(6,0) | DECIMAL(5) NOT NULL | Contrib for Std |
| 33 | INCOME_CONTRIB | Signed Number(7,0) | DECIMAL(6) NOT NULL | Tot Cont Income |
| 34 | ASSET_CONTRIB | Signed Number(7,0) | DECIMAL(6) NOT NULL | Tot Cont Assets |
| 35 | ELEM_SEC_TUIT | Signed Number(6,0) | DECIMAL(5) NOT NULL | Elem/Sec Tuition |
| 36 | IRA_VALUE | Signed Number(11,0) | DECIMAL(10) NOT NULL | IRA, Keogh, 401K Value |