[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_AP_CSS_FNAR_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGF |
| FND Design Data: |  IGF.IGF_AP_CSS_FNAR_ALL
|
| Subobject Name: | |
| Status: | VALID |
Holds the Financial Need Analysis Report related information.This comes along with college board's profile information.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGF_AP_CSS_FNAR_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 FNAR_ID
|
| IGF_AP_CSS_FNAR_U2 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
CSSP_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| FNAR_ID | NUMBER | (15) | Yes | Holds he primary key column |
| CSSP_ID | NUMBER | (15) | Yes | Unique Identifier |
| ORG_ID | NUMBER | (15) | Operating unit identifier | |
| R_S_EMAIL_ADDRESS | VARCHAR2 | (30) | Holds the e-mail address | |
| EPS_CODE | VARCHAR2 | (4) | Holds the EPS code | |
| COMP_CSS_DEPENDENCY_STATUS | VARCHAR2 | (30) | Describes computed CSS dependency status | |
| STU_AGE | VARCHAR2 | (2) | Holds student age | |
| ASSUMED_STU_YR_IN_COLL | VARCHAR2 | (30) | Holds the assumed number of years the student has spent in college | |
| COMP_STU_MARITAL_STATUS | VARCHAR2 | (30) | Computed student marital status | |
| STU_FAMILY_MEMBERS | NUMBER | (15) | Student family members | |
| STU_FAM_MEMBERS_IN_COLLEGE | NUMBER | (15) | Student family members in college | |
| PAR_MARITAL_STATUS | VARCHAR2 | (30) | Parents marital status | |
| PAR_FAMILY_MEMBERS | NUMBER | (15) | Parents family members | |
| PAR_TOTAL_IN_COLLEGE | NUMBER | (15) | Parents in college | |
| PAR_PAR_IN_COLLEGE | NUMBER | (15) | Parents in college | |
| PAR_OTHERS_IN_COLLEGE | NUMBER | (15) | Parents others in college | |
| PAR_AESA | NUMBER | (15) | Holds the parents AESA | |
| PAR_CESA | NUMBER | (15) | Holds the parents CESA | |
| STU_AESA | NUMBER | (15) | Holds the students AESA | |
| STU_CESA | NUMBER | (15) | Holds the students CESA | |
| IM_P_BAS_AGI_TAXABLE_INCOME | NUMBER | (15) | Parents basic adjust gross taxable income | |
| IM_P_BAS_UNTX_INC_AND_BEN | NUMBER | (15) | Parents basic untaxed income and benefits | |
| IM_P_BAS_INC_ADJ | NUMBER | (15) | Parents basic income adjust | |
| IM_P_BAS_TOTAL_INCOME | NUMBER | (15) | Parents basic total income | |
| IM_P_BAS_US_INCOME_TAX | NUMBER | (15) | Parents basic us income tax | |
| IM_P_BAS_ST_AND_OTHER_TAX | NUMBER | (15) | Parents basic state and other taxes | |
| IM_P_BAS_FICA_TAX | NUMBER | (15) | Parents basic FICA tax | |
| IM_P_BAS_MED_DENTAL | NUMBER | (15) | Parents basic medical and dental | |
| IM_P_BAS_EMPLOYMENT_ALLOW | NUMBER | (15) | Parents basic employment allowance | |
| IM_P_BAS_ANNUAL_ED_SAVINGS | NUMBER | (15) | Parents basic annual education savings | |
| IM_P_BAS_INC_PROT_ALLOW_M | NUMBER | (15) | Parents basic income protection allowance or MMA | |
| IM_P_BAS_TOTAL_INC_ALLOW | NUMBER | (15) | Parents basic total income allowance | |
| IM_P_BAS_CAL_AVAIL_INC | NUMBER | (15) | Parents basic calculated available income | |
| IM_P_BAS_AVAIL_INCOME | NUMBER | (15) | Parents basic available income | |
| IM_P_BAS_TOTAL_CONT_INC | NUMBER | (15) | Parents basic total contribution income | |
| IM_P_BAS_CASH_BANK_ACCOUNTS | NUMBER | (15) | Parents basic cash bank accounts | |
| IM_P_BAS_HOME_EQUITY | NUMBER | (15) | Parents basic home equity | |
| IM_P_BAS_OT_RL_EST_INV_EQ | NUMBER | (15) | Other parents basic real estate invest equity | |
| IM_P_BAS_ADJ_BUS_FARM_WORTH | NUMBER | (15) | Parents basic adjust business farm worth | |
| IM_P_BAS_ASS_SIBS_PRE_TUI | NUMBER | (15) | Parents basic assets siblings or pre tuition | |
| IM_P_BAS_NET_WORTH | NUMBER | (15) | Parents basic net worth | |
| IM_P_BAS_EMERG_RES_ALLOW | NUMBER | (15) | Parents basic emergency residence allowance | |
| IM_P_BAS_CUM_ED_SAVINGS | NUMBER | (15) | Parents basic cumulative education savings | |
| IM_P_BAS_LOW_INC_ALLOW | NUMBER | (15) | Parents basic low income allowance | |
| IM_P_BAS_TOTAL_ASSET_ALLOW | NUMBER | (15) | Parents basic total asset allowance | |
| IM_P_BAS_DISC_NET_WORTH | NUMBER | (15) | Parents basic discretionary net worth | |
| IM_P_BAS_TOTAL_CONT_ASSET | NUMBER | (15) | Parents basic total contribution asset | |
| IM_P_BAS_TOTAL_CONT | NUMBER | (15) | Parents basic total contribution | |
| IM_P_BAS_NUM_IN_COLL_ADJ | NUMBER | (12) | Parents basic number in college adjustment | |
| IM_P_BAS_CONT_FOR_STU | NUMBER | (15) | Parents basic contribution for student | |
| IM_P_BAS_CONT_FROM_INCOME | NUMBER | (15) | Parents basic contribution from income | |
| IM_P_BAS_CONT_FROM_ASSETS | NUMBER | (15) | Parents basic contribution from assets | |
| IM_P_OPT_AGI_TAXABLE_INCOME | NUMBER | (15) | Parents optional adjust gross taxable income | |
| IM_P_OPT_UNTX_INC_AND_BEN | NUMBER | (15) | Parents optional untaxed income and benefits | |
| IM_P_OPT_INC_ADJ | NUMBER | (15) | Parents optional income adjustable | |
| IM_P_OPT_TOTAL_INCOME | NUMBER | (15) | Parents optional total income | |
| IM_P_OPT_US_INCOME_TAX | NUMBER | (15) | Parents optional US income tax | |
| IM_P_OPT_ST_AND_OTHER_TAX | NUMBER | (15) | Parents optional state and other taxes | |
| IM_P_OPT_FICA_TAX | NUMBER | (15) | Parents optional FICA tax | |
| IM_P_OPT_MED_DENTAL | NUMBER | (15) | Parents optional medical or dental | |
| IM_P_OPT_ELEM_SEC_TUIT | NUMBER | (15) | Parents optional elementary or secondary tuition | |
| IM_P_OPT_EMPLOYMENT_ALLOW | NUMBER | (15) | Parents optional employment allowance | |
| IM_P_OPT_ANNUAL_ED_SAVINGS | NUMBER | (15) | Parents optional annual educational savings | |
| IM_P_OPT_INC_PROT_ALLOW_M | NUMBER | (15) | Parents optional income protection allowance or MMA | |
| IM_P_OPT_TOTAL_INC_ALLOW | NUMBER | (15) | Parents optional total income allowance | |
| IM_P_OPT_CAL_AVAIL_INC | NUMBER | (15) | Parents optional calculated available income | |
| IM_P_OPT_AVAIL_INCOME | NUMBER | (15) | Parents optional available income | |
| IM_P_OPT_TOTAL_CONT_INC | NUMBER | (15) | Parents optional total contribution income | |
| IM_P_OPT_CASH_BANK_ACCOUNTS | NUMBER | (15) | Parents optional cash bank accounts | |
| IM_P_OPT_HOME_EQUITY | NUMBER | (15) | Parents optional home equity | |
| IM_P_OPT_OT_RL_EST_INV_EQ | NUMBER | (15) | Other Parents optional real estate investment equity | |
| IM_P_OPT_ADJ_BUS_FARM_WORTH | NUMBER | (15) | Parents optional adjust business farm worth | |
| IM_P_OPT_ASS_SIBS_PRE_TUI | NUMBER | (15) | Parents optional assets siblings pre tuition | |
| IM_P_OPT_NET_WORTH | NUMBER | (15) | Parents optional net worth | |
| IM_P_OPT_EMERG_RES_ALLOW | NUMBER | (15) | Parents optional emergency residence allowance | |
| IM_P_OPT_CUM_ED_SAVINGS | NUMBER | (15) | Parents optional cumulative education savings | |
| IM_P_OPT_LOW_INC_ALLOW | NUMBER | (15) | Parents optional low income allowance | |
| IM_P_OPT_TOTAL_ASSET_ALLOW | NUMBER | (15) | Parents optional total asset allowance | |
| IM_P_OPT_DISC_NET_WORTH | NUMBER | (15) | Parents optional discretionary net worth | |
| IM_P_OPT_TOTAL_CONT_ASSET | NUMBER | (15) | Parents optional total contribution asset | |
| IM_P_OPT_TOTAL_CONT | NUMBER | (15) | Parents optional total contribution | |
| IM_P_OPT_NUM_IN_COLL_ADJ | NUMBER | (15) | Parents optional number in college adjust | |
| IM_P_OPT_CONT_FOR_STU | NUMBER | (15) | Parents optional contribution for student | |
| IM_P_OPT_CONT_FROM_INCOME | NUMBER | (15) | Parents optional contribution from income | |
| IM_P_OPT_CONT_FROM_ASSETS | NUMBER | (15) | Parents optional contribution from assets | |
| FM_P_ANALYSIS_TYPE | VARCHAR2 | (30) | Parents analysis type | |
| FM_P_AGI_TAXABLE_INCOME | NUMBER | (15) | Parents adjust gross income taxable | |
| FM_P_UNTX_INC_AND_BEN | NUMBER | (15) | Parents untaxed income and benefits | |
| FM_P_INC_ADJ | NUMBER | (15) | Holds the Parents income adjust | |
| FM_P_TOTAL_INCOME | NUMBER | (15) | Holds the parents total income | |
| FM_P_US_INCOME_TAX | NUMBER | (15) | Holds the parents US income tax | |
| FM_P_STATE_AND_OTHER_TAXES | NUMBER | (15) | Parents state and other taxes | |
| FM_P_FICA_TAX | NUMBER | (15) | Holds the parents FICA tax | |
| FM_P_EMPLOYMENT_ALLOW | NUMBER | (15) | Holds the parents employment allowance | |
| FM_P_INCOME_PROT_ALLOW | NUMBER | (15) | Parents income protection allowance | |
| FM_P_TOTAL_ALLOW | NUMBER | (15) | Holds the parents total allowance | |
| FM_P_AVAIL_INCOME | NUMBER | (15) | Parents available income | |
| FM_P_CASH_BANK_ACCOUNTS | NUMBER | (15) | Parents cash bank accounts | |
| FM_P_OT_RL_EST_INV_EQUITY | NUMBER | (15) | Parents other real estate investment equity | |
| FM_P_ADJ_BUS_FARM_NET_WORTH | NUMBER | (15) | Parents adjust business farm net worth | |
| FM_P_NET_WORTH | NUMBER | (15) | Holds the parents net worth | |
| FM_P_ASSET_PROT_ALLOW | NUMBER | (15) | Parents asset protection allowance | |
| FM_P_DISC_NET_WORTH | NUMBER | (15) | Holds the parents discretionary net worth | |
| FM_P_TOTAL_CONTRIBUTION | NUMBER | (15) | Holds the parents total contribution | |
| FM_P_NUM_IN_COLL | NUMBER | (15) | Holds the parents number in college | |
| FM_P_CONT_FOR_STU | NUMBER | (15) | Holds the parents contribution for student | |
| FM_P_CONT_FROM_INCOME | NUMBER | (15) | Holds the parents contribution from income | |
| FM_P_CONT_FROM_ASSETS | NUMBER | (15) | Holds the parents contribution from assets | |
| IM_S_BAS_AGI_TAXABLE_INCOME | NUMBER | (15) | Students basic adjust gross income taxable | |
| IM_S_BAS_UNTX_INC_AND_BEN | NUMBER | (15) | Students basic untaxed income and benefits | |
| IM_S_BAS_INC_ADJ | NUMBER | (15) | Holds the students basic income adjust | |
| IM_S_BAS_TOTAL_INCOME | NUMBER | (15) | Holds the students basic total income | |
| IM_S_BAS_US_INCOME_TAX | NUMBER | (15) | Holds the students basic US income tax | |
| IM_S_BAS_STATE_AND_OTH_TAXES | NUMBER | (15) | Students basic state and other taxes | |
| IM_S_BAS_FICA_TAX | NUMBER | (15) | Holds the students basic FICA tax | |
| IM_S_BAS_MED_DENTAL | NUMBER | (15) | Describes the students basic medical or dental | |
| IM_S_BAS_EMPLOYMENT_ALLOW | NUMBER | (15) | Holds the students basic employment allowance | |
| IM_S_BAS_ANNUAL_ED_SAVINGS | NUMBER | (15) | Holds the students basic annual education savings | |
| IM_S_BAS_INC_PROT_ALLOW_M | NUMBER | (15) | Holds the students basic income protection allowance or MMA | |
| IM_S_BAS_TOTAL_INC_ALLOW | NUMBER | (15) | Holds the students basic total income allowance | |
| IM_S_BAS_CAL_AVAIL_INCOME | NUMBER | (15) | Holds the students basic calculated available income | |
| IM_S_BAS_AVAIL_INCOME | NUMBER | (15) | Holds the students basic available income | |
| IM_S_BAS_TOTAL_CONT_INC | NUMBER | (15) | Students basic total contribution income | |
| IM_S_BAS_CASH_BANK_ACCOUNTS | NUMBER | (15) | Holds the students basic cash bank accounts | |
| IM_S_BAS_HOME_EQUITY | NUMBER | (15) | Holds the students basic home equity | |
| IM_S_BAS_OT_RL_EST_INV_EQ | NUMBER | (15) | Holds the students basic or estimated investment equity | |
| IM_S_BAS_ADJ_BUSFARM_WORTH | NUMBER | (15) | Students basic adjust business farm worth | |
| IM_S_BAS_TRUSTS | NUMBER | (15) | Holds the students basic trusts | |
| IM_S_BAS_NET_WORTH | NUMBER | (15) | Holds the students basic net worth | |
| IM_S_BAS_EMERG_RES_ALLOW | NUMBER | (15) | Students basic emergency residence allowance | |
| IM_S_BAS_CUM_ED_SAVINGS | NUMBER | (15) | Students basic cumulative education savings | |
| IM_S_BAS_TOTAL_ASSET_ALLOW | NUMBER | (15) | Holds the students basic total asset allowance | |
| IM_S_BAS_DISC_NET_WORTH | NUMBER | (15) | Holds the students basic discretionary net worth | |
| IM_S_BAS_TOTAL_CONT_ASSET | NUMBER | (15) | Holds the students basic total contribution asset | |
| IM_S_BAS_TOTAL_CONT | NUMBER | (15) | Holds the students basic total contribution | |
| IM_S_BAS_NUM_IN_COLL_ADJ | NUMBER | (13) | Students basic number in college adjust | |
| IM_S_BAS_CONT_FOR_STU | NUMBER | (15) | Holds the students basic contribution for student | |
| IM_S_BAS_CONT_FROM_INCOME | NUMBER | (15) | Holds the students basic contribution from income | |
| IM_S_BAS_CONT_FROM_ASSETS | NUMBER | (15) | Holds the students basic contribution from assets | |
| IM_S_EST_AGITAXABLE_INCOME | NUMBER | (15) | Students estimated adjust gross taxable income | |
| IM_S_EST_UNTX_INC_AND_BEN | NUMBER | (15) | Holds the students estimated untaxed income and benefits | |
| IM_S_EST_INC_ADJ | NUMBER | (15) | Holds the students estimated income adjust | |
| IM_S_EST_TOTAL_INCOME | NUMBER | (15) | Holds the students estimated total income | |
| IM_S_EST_US_INCOME_TAX | NUMBER | (15) | Holds the students estimated US income tax | |
| IM_S_EST_STATE_AND_OTH_TAXES | NUMBER | (15) | Holds the students estimated state and other taxes | |
| IM_S_EST_FICA_TAX | NUMBER | (15) | Holds the students estimated FICA tax | |
| IM_S_EST_MED_DENTAL | NUMBER | (15) | Holds the students estimated medical and dental | |
| IM_S_EST_EMPLOYMENT_ALLOW | NUMBER | (15) | Holds the students estimated employment allowance | |
| IM_S_EST_ANNUAL_ED_SAVINGS | NUMBER | (15) | Holds the students estimated annual education savings | |
| IM_S_EST_INC_PROT_ALLOW_M | NUMBER | (15) | Holds the students estimated income protection allowance or MMA | |
| IM_S_EST_TOTAL_INC_ALLOW | NUMBER | (15) | Holds the students estimated total income allowance | |
| IM_S_EST_CAL_AVAIL_INCOME | NUMBER | (15) | Holds the students estimated calculated available income | |
| IM_S_EST_AVAIL_INCOME | NUMBER | (15) | Holds the students estimated available income | |
| IM_S_EST_TOTAL_CONT_INC | NUMBER | (15) | Holds the students estimated total contribution income | |
| IM_S_EST_CASH_BANK_ACCOUNTS | NUMBER | (15) | Holds the students estimated cash bank accounts | |
| IM_S_EST_HOME_EQUITY | NUMBER | (15) | Holds the students estimated home equity | |
| IM_S_EST_OT_RL_EST_INV_EQ | NUMBER | (15) | Holds the students estimated other real estate investment equity | |
| IM_S_EST_ADJ_BUS_FARM_WORTH | NUMBER | (15) | Holds the students estimated adjust business farm worth | |
| IM_S_EST_EST_TRUSTS | NUMBER | (15) | Holds the students estimated estimated trusts | |
| IM_S_EST_NET_WORTH | NUMBER | (15) | Holds the students estimated net worth | |
| IM_S_EST_EMERG_RES_ALLOW | NUMBER | (15) | Holds the students estimated emergency residence allowance | |
| IM_S_EST_CUM_ED_SAVINGS | NUMBER | (15) | Holds the students estimated cumulative education savings | |
| IM_S_EST_TOTAL_ASSET_ALLOW | NUMBER | (15) | Holds the students estimated total asset allowance | |
| IM_S_EST_DISC_NET_WORTH | NUMBER | (15) | Holds the students estimated discretionary net worth | |
| IM_S_EST_TOTAL_CONT_ASSET | NUMBER | (15) | Holds the students estimated total contribution asset | |
| IM_S_EST_TOTAL_CONT | NUMBER | (15) | Holds the students estimated total contribution | |
| IM_S_EST_NUM_IN_COLL_ADJ | NUMBER | (13) | Holds the students estimated number in college adjust | |
| IM_S_EST_CONT_FOR_STU | NUMBER | (15) | Holds the students estimated contribution for student | |
| IM_S_EST_CONT_FROM_INCOME | NUMBER | (15) | Students estimated contribution from income | |
| IM_S_EST_CONT_FROM_ASSETS | NUMBER | (15) | Holds the students estimated contribution from assets | |
| IM_S_OPT_AGI_TAXABLE_INCOME | NUMBER | (15) | Holds the students optional adjust gross taxable income | |
| IM_S_OPT_UNTX_INC_AND_BEN | NUMBER | (15) | Holds the students optional untaxed income and benefits | |
| IM_S_OPT_INC_ADJ | NUMBER | (15) | Holds the students optional income adjust | |
| IM_S_OPT_TOTAL_INCOME | NUMBER | (15) | Holds the students optional total income | |
| IM_S_OPT_US_INCOME_TAX | NUMBER | (15) | Holds the students optional US income tax | |
| IM_S_OPT_STATE_AND_OTH_TAXES | NUMBER | (15) | Holds the students optional state and other taxes | |
| IM_S_OPT_FICA_TAX | NUMBER | (15) | Holds the students optional FICA tax | |
| IM_S_OPT_MED_DENTAL | NUMBER | (15) | Holds the students optional medical or dental | |
| IM_S_OPT_EMPLOYMENT_ALLOW | NUMBER | (15) | Holds the students optional employment allowance | |
| IM_S_OPT_ANNUAL_ED_SAVINGS | NUMBER | (15) | Holds the students optional annual education savings | |
| IM_S_OPT_INC_PROT_ALLOW_M | NUMBER | (15) | Students optional income protection allowance or MMA | |
| IM_S_OPT_TOTAL_INC_ALLOW | NUMBER | (15) | Holds the students optional total income allowance | |
| IM_S_OPT_CAL_AVAIL_INCOME | NUMBER | (15) | Holds the students optional calculated available income | |
| IM_S_OPT_AVAIL_INCOME | NUMBER | (15) | Holds the students optional available income | |
| IM_S_OPT_TOTAL_CONT_INC | NUMBER | (15) | Holds the students optional total contribution income | |
| IM_S_OPT_CASH_BANK_ACCOUNTS | NUMBER | (15) | Holds the students optional cash bank accounts | |
| IM_S_OPT_IRA_KEOGH_ACCOUNTS | NUMBER | (15) | Holds the students optional IRA KEOGH accounts | |
| IM_S_OPT_HOME_EQUITY | NUMBER | (15) | Holds the students optional home equity | |
| IM_S_OPT_OT_RL_EST_INV_EQ | NUMBER | (15) | Holds the students optional adjust business farm worth | |
| IM_S_OPT_ADJ_BUS_FARM_WORTH | NUMBER | (15) | Holds the students optional adjust business farm worth | |
| IM_S_OPT_TRUSTS | NUMBER | (15) | Holds the students optional trusts | |
| IM_S_OPT_NET_WORTH | NUMBER | (15) | Holds the students optional net worth | |
| IM_S_OPT_EMERG_RES_ALLOW | NUMBER | (15) | Holds the students optional emergency residence allowance | |
| IM_S_OPT_CUM_ED_SAVINGS | NUMBER | (15) | Holds the students optional cumulative education savings | |
| IM_S_OPT_TOTAL_ASSET_ALLOW | NUMBER | (15) | Holds the students optional total asset allowance | |
| IM_S_OPT_DISC_NET_WORTH | NUMBER | (15) | Holds the students estimated discretionary net worth | |
| IM_S_OPT_TOTAL_CONT_ASSET | NUMBER | (15) | Holds the students optional total contribution asset | |
| IM_S_OPT_TOTAL_CONT | NUMBER | (15) | Holds the students optional total contribution | |
| IM_S_OPT_NUM_IN_COLL_ADJ | NUMBER | (15) | Holds the students optional number in college adjust | |
| IM_S_OPT_CONT_FOR_STU | NUMBER | (15) | Holds the students optional contribution for student | |
| IM_S_OPT_CONT_FROM_INCOME | NUMBER | (15) | Holds the students optional contribution from income | |
| IM_S_OPT_CONT_FROM_ASSETS | NUMBER | (15) | Holds the students optional contribution from assets | |
| FM_S_ANALYSIS_TYPE | VARCHAR2 | (30) | Holds the students analysis type | |
| FM_S_AGI_TAXABLE_INCOME | NUMBER | (15) | Holds the students adjust gross income taxable | |
| FM_S_UNTX_INC_AND_BEN | NUMBER | (15) | Holds the students untaxed income and benefits | |
| FM_S_INC_ADJ | NUMBER | (15) | Holds the students income adjust | |
| FM_S_TOTAL_INCOME | NUMBER | (15) | Holds the students total income | |
| FM_S_US_INCOME_TAX | NUMBER | (15) | Holds the students US income tax | |
| FM_S_STATE_AND_OTH_TAXES | NUMBER | (15) | Holds the students state and other taxes | |
| FM_S_FICA_TAX | NUMBER | (15) | Holds the students FICA tax | |
| FM_S_EMPLOYMENT_ALLOW | NUMBER | (15) | Holds the students employment allowance | |
| FM_S_INCOME_PROT_ALLOW | NUMBER | (15) | Holds the students income protection allowance | |
| FM_S_TOTAL_ALLOW | NUMBER | (15) | Holds the students total allowance | |
| FM_S_CAL_AVAIL_INCOME | NUMBER | (15) | Holds the students calculated available income | |
| FM_S_AVAIL_INCOME | NUMBER | (15) | Holds the students available income | |
| FM_S_CASH_BANK_ACCOUNTS | NUMBER | (15) | Holds the students cash bank accounts | |
| FM_S_OT_RL_EST_INV_EQUITY | NUMBER | (15) | Holds the students other real estate investment equity | |
| FM_S_ADJ_BUS_FARM_WORTH | NUMBER | (15) | Holds the students adjust business farm net worth | |
| FM_S_TRUSTS | NUMBER | (15) | Holds the students trusts | |
| FM_S_NET_WORTH | NUMBER | (15) | Holds the students net worth | |
| FM_S_ASSET_PROT_ALLOW | NUMBER | (15) | Holds the students asset protection allowance | |
| FM_S_DISC_NET_WORTH | NUMBER | (15) | Holds the students discretionary net worth | |
| FM_S_TOTAL_CONT | NUMBER | (15) | Holds the students total contribution | |
| FM_S_NUM_IN_COLL | NUMBER | (15) | Holds the students number in college | |
| FM_S_CONT_FOR_STU | NUMBER | (15) | Describes the contribution for student | |
| FM_S_CONT_FROM_INCOME | NUMBER | (15) | Holds the students contribution from income | |
| FM_S_CONT_FROM_ASSETS | NUMBER | (15) | Holds the students contribution from assets | |
| IM_INST_RESIDENT_IND | VARCHAR2 | (30) | Holds the institutional resident indicator | |
| INSTITUTIONAL_1_BUDGET_NAME | VARCHAR2 | (7) | Holds the institutional budget name | |
| IM_INST_1_BUDGET_DURATION | NUMBER | (15) | Holds the institutional budget duration | |
| IM_INST_1_TUITION_FEES | NUMBER | (15) | Holds the institutional tuition fees | |
| IM_INST_1_BOOKS_SUPPLIES | NUMBER | (15) | Holds the institutional books supplies | |
| IM_INST_1_LIVING_EXPENSES | NUMBER | (15) | Holds the institutional living expenses | |
| IM_INST_1_TOT_EXPENSES | NUMBER | (15) | Holds the institutional total expenses | |
| IM_INST_1_TOT_STU_CONT | NUMBER | (15) | Holds the institutional total student contribution | |
| IM_INST_1_TOT_PAR_CONT | NUMBER | (15) | Holds the institutional total parent contribution | |
| IM_INST_1_TOT_FAMILY_CONT | NUMBER | (15) | Holds the institutional total family contribution | |
| IM_INST_1_VA_BENEFITS | NUMBER | (15) | Holds the institutional veteran benefits | |
| IM_INST_1_OT_CONT | NUMBER | (15) | Holds the institutional other contribution | |
| IM_INST_1_EST_FINANCIAL_NEED | NUMBER | (15) | Holds the institutional estimated financial need | |
| INSTITUTIONAL_2_BUDGET_NAME | VARCHAR2 | (7) | Holds the institutional budget name | |
| IM_INST_2_BUDGET_DURATION | VARCHAR2 | (2) | Holds the institutional budget duration | |
| IM_INST_2_TUITION_FEES | NUMBER | (15) | Holds the institutional tuition fees | |
| IM_INST_2_BOOKS_SUPPLIES | NUMBER | (15) | Holds the institutional books supplies | |
| IM_INST_2_LIVING_EXPENSES | NUMBER | (15) | Holds the institutional living expenses | |
| IM_INST_2_TOT_EXPENSES | NUMBER | (15) | Holds the institutional total expenses | |
| IM_INST_2_TOT_STU_CONT | NUMBER | (15) | Holds the institutional total student contribution | |
| IM_INST_2_TOT_PAR_CONT | NUMBER | (15) | Holds the institutional total parent contribution | |
| IM_INST_2_TOT_FAMILY_CONT | NUMBER | (15) | Holds the institutional total family contribution | |
| IM_INST_2_VA_BENEFITS | NUMBER | (15) | Holds the institutional veteran benefits | |
| IM_INST_2_EST_FINANCIAL_NEED | NUMBER | (15) | Contains the institutional estimated financial need | |
| INSTITUTIONAL_3_BUDGET_NAME | VARCHAR2 | (7) | Contains the institutional budget name | |
| IM_INST_3_BUDGET_DURATION | NUMBER | (15) | Contains the institutional budget duration | |
| IM_INST_3_TUITION_FEES | NUMBER | (15) | Contains the institutional tuition fees | |
| IM_INST_3_BOOKS_SUPPLIES | NUMBER | (15) | Contains the institutional books supplies | |
| IM_INST_3_LIVING_EXPENSES | NUMBER | (15) | Contains the institutional living expenses | |
| IM_INST_3_TOT_EXPENSES | NUMBER | (15) | Contains the institutional total expenses | |
| IM_INST_3_TOT_STU_CONT | NUMBER | (15) | Contains the institutional total student contribution | |
| IM_INST_3_TOT_PAR_CONT | NUMBER | (15) | Contains the institutional total parent contribution | |
| IM_INST_3_TOT_FAMILY_CONT | NUMBER | (15) | Contains the institutional total family contribution | |
| IM_INST_3_VA_BENEFITS | NUMBER | (15) | Institutional veteran benefits | |
| IM_INST_3_EST_FINANCIAL_NEED | NUMBER | (15) | Contains the institutional estimated financial need | |
| FM_INST_1_FEDERAL_EFC | VARCHAR2 | (5) | Contains the institutional federal effective family contribution | |
| FM_INST_1_VA_BENEFITS | VARCHAR2 | (5) | Contains the institutional veteran benefits | |
| FM_INST_1_FED_ELIGIBILITY | VARCHAR2 | (5) | Contains the institutional federal eligibility | |
| FM_INST_1_PELL | VARCHAR2 | (4) | Contains the institution pell | |
| OPTION_PAR_LOSS_ALLOW_IND | VARCHAR2 | (30) | Contains the option parent loss allowance indicator | |
| OPTION_PAR_TUITION_IND | VARCHAR2 | (30) | Contains the option parent tuition indicator | |
| OPTION_PAR_HOME_IND | VARCHAR2 | (30) | Contains the option parent tuition indicator | |
| OPTION_PAR_HOME_VALUE | VARCHAR2 | (7) | Contains the option parent home value | |
| OPTION_PAR_HOME_DEBT | VARCHAR2 | (7) | Contains the option parent home debt | |
| OPTION_STU_IRA_KEOGH_IND | VARCHAR2 | (30) | Contains the option student IRA KEOGH indicator | |
| OPTION_STU_HOME_IND | VARCHAR2 | (30) | Contains the option student home indicator | |
| OPTION_STU_HOME_VALUE | VARCHAR2 | (6) | Contains the option student home value | |
| OPTION_STU_HOME_DEBT | VARCHAR2 | (6) | Contains the optional student home debt | |
| OPTION_STU_SUM_AY_INC_IND | VARCHAR2 | (30) | Contains the option student summer award year income indicator | |
| OPTION_PAR_HOPE_LL_CREDIT | VARCHAR2 | (30) | Contains the option parents hope LL credit | |
| OPTION_STU_HOPE_LL_CREDIT | VARCHAR2 | (30) | Contains the option student hope LL credit | |
| IM_PARENT_1_8_MONTHS_BAS | VARCHAR2 | (5) | Parent 1 to 8 months basic year | |
| IM_P_MORE_THAN_9_MTH_BA | VARCHAR2 | (5) | Parent more than 9 month basic year | |
| IM_PARENT_1_8_MONTHS_OPT | VARCHAR2 | (5) | Parent 1 to 8 months optional | |
| IM_P_MORE_THAN_9_MTH_OP | VARCHAR2 | (5) | Parent more than 9 month optional | |
| FNAR_MESSAGE_1 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_2 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_3 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_4 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_5 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_6 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_7 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_8 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_9 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_10 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_11 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_12 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_13 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_20 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_21 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_22 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_23 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_24 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_25 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_26 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_27 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_30 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_31 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_32 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_33 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_34 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_35 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_36 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_37 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_38 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_39 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_45 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_46 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_47 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_48 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_50 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_51 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_52 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_53 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_56 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_57 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_58 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_59 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_60 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_61 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_62 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_63 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_64 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_65 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_71 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_72 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_73 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_74 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_75 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_76 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_77 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_78 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESG_10_STU_FAM_MEM | VARCHAR2 | (2) | Holds the FNAR message student family members | |
| FNAR_MESG_11_STU_NO_IN_COLL | VARCHAR2 | (30) | Holds the FNAR message student number in college | |
| FNAR_MESG_24_STU_AVAIL_INC | VARCHAR2 | (7) | Holds the FNAR message student available income | |
| FNAR_MESG_26_STU_TAXES | VARCHAR2 | (6) | Holds the FNAR message student taxes | |
| FNAR_MESG_33_STU_HOME_VALUE | VARCHAR2 | (6) | Holds the FNAR message student home value | |
| FNAR_MESG_34_STU_HOME_VALUE | VARCHAR2 | (6) | Holds the FNAR message student home value | |
| FNAR_MESG_34_STU_HOME_EQUITY | VARCHAR2 | (6) | Holds the FNAR message student home equity | |
| FNAR_MESG_35_STU_HOME_VALUE | VARCHAR2 | (6) | Holds the FNAR message student home value | |
| FNAR_MESG_35_STU_HOME_EQUITY | VARCHAR2 | (6) | Holds the FNAR message student home equity | |
| FNAR_MESG_36_STU_HOME_EQUITY | VARCHAR2 | (6) | Holds the FNAR message student home equity | |
| FNAR_MESG_48_PAR_FAM_MEM | VARCHAR2 | (2) | Holds the FNAR message parent family member | |
| FNAR_MESG_49_PAR_NO_IN_COLL | VARCHAR2 | (30) | Holds the FNAR message parent number in college | |
| FNAR_MESG_56_PAR_AGI | VARCHAR2 | (8) | Holds the FNAR message parent adjust gross income | |
| FNAR_MESG_62_PAR_TAXES | VARCHAR2 | (7) | Holds the FNAR message parent taxes | |
| FNAR_MESG_73_PAR_HOME_VALUE | VARCHAR2 | (7) | Holds the FNAR message parent home value | |
| FNAR_MESG_74_PAR_HOME_VALUE | VARCHAR2 | (7) | Holds the FNAR message parent home value | |
| FNAR_MESG_74_PAR_HOME_EQUITY | VARCHAR2 | (7) | Holds the FNAR message parent home equity | |
| FNAR_MESG_75_PAR_HOME_VALUE | VARCHAR2 | (7) | Holds the FNAR message parent home value | |
| FNAR_MESG_75_PAR_HOME_EQUITY | VARCHAR2 | (7) | Holds the FNAR message parent home equity | |
| FNAR_MESG_76_PAR_HOME_EQUITY | VARCHAR2 | (7) | Holds the FNAR message parent home equity | |
| ASSUMPTION_MESSAGE_1 | VARCHAR2 | (30) | Holds the assumption message | |
| ASSUMPTION_MESSAGE_2 | VARCHAR2 | (30) | Holds the assumption message | |
| ASSUMPTION_MESSAGE_3 | VARCHAR2 | (30) | Holds the assumption message | |
| ASSUMPTION_MESSAGE_4 | VARCHAR2 | (30) | Holds the assumption message | |
| ASSUMPTION_MESSAGE_5 | VARCHAR2 | (30) | Holds the assumption message | |
| ASSUMPTION_MESSAGE_6 | VARCHAR2 | (30) | Holds the assumption message | |
| RECORD_MARK | VARCHAR2 | (30) | Indicates end of record | |
| CREATED_BY | NUMBER | (15) | Yes | Standard who column |
| CREATION_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATED_BY | NUMBER | (15) | Yes | Standard who column |
| LAST_UPDATE_DATE | DATE | Yes | Standard who column | |
| LAST_UPDATE_LOGIN | NUMBER | (15) | Yes | Standard who column |
| OPTION_PAR_COLA_ADJ_IND | VARCHAR2 | (30) | Holds the option parent Cost of Living Adjustment Indicator | |
| OPTION_PAR_STU_FA_ASSETS_IND | VARCHAR2 | (30) | Holds the option student Assets treated as Parents Asset Indicator | |
| OPTION_PAR_IPT_ASSETS_IND | VARCHAR2 | (30) | Holds the option parent Assets from Interest and Dividend Income Indicator | |
| OPTION_STU_IPT_ASSETS_IND | VARCHAR2 | (30) | Holds the option student Assets from Interest and Dividend Income Indicator | |
| OPTION_PAR_COLA_ADJ_VALUE | NUMBER | (12) | Holds the option parent Adjustment factor used to modify IPA and ERA | |
| FNAR_MESSAGE_49 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_55 | VARCHAR2 | (30) | Holds the FNAR message | |
| LEGACY_RECORD_FLAG | VARCHAR2 | (1) | Indicates weather the record was imported through a legacy process or not | |
| OPTION_IND_STU_IPT_ASSETS_FLAG | VARCHAR2 | (1) | Independent Student Assets from Interest and Dividend Income indicator | |
| CUST_PARENT_CONT_ADJ_NUM | NUMBER | Custodial Parent Contribution Adjustment | ||
| CUSTODIAL_PARENT_NUM | NUMBER | Custodial Parent | ||
| CUST_PAR_BASE_PRCNT_INC_AMT | NUMBER | Custodial Parent Base Percentage from Income | ||
| CUST_PAR_BASE_CONT_INC_AMT | NUMBER | Custodial Parent Base Contribution from Income | ||
| CUST_PAR_BASE_CONT_AST_AMT | NUMBER | Custodial Parent Base Contribution from Assets | ||
| CUST_PAR_BASE_TOT_CONT_AMT | NUMBER | Custodial Parent Base Total Contribution | ||
| CUST_PAR_OPT_PRCNT_INC_AMT | NUMBER | Custodial Parent Optional Percentage from Income | ||
| CUST_PAR_OPT_CONT_INC_AMT | NUMBER | Custodial Parent Optional Contribution from Income | ||
| CUST_PAR_OPT_CONT_AST_AMT | NUMBER | Custodial Parent Optional Contribution from Assets | ||
| CUST_PAR_OPT_TOT_CONT_AMT | NUMBER | Custodial Parent Optional Total Contribution | ||
| PARENTS_EMAIL_TXT | VARCHAR2 | (50) | Parent's Email | |
| PARENT_1_BIRTH_DATE | DATE | Parent 1 Date of Birth | ||
| PARENT_2_BIRTH_DATE | DATE | Parent 2 Date of Birth |
Cut, paste (and edit) the following text to query this object:
SELECT FNAR_ID
, CSSP_ID
, ORG_ID
, R_S_EMAIL_ADDRESS
, EPS_CODE
, COMP_CSS_DEPENDENCY_STATUS
, STU_AGE
, ASSUMED_STU_YR_IN_COLL
, COMP_STU_MARITAL_STATUS
, STU_FAMILY_MEMBERS
, STU_FAM_MEMBERS_IN_COLLEGE
, PAR_MARITAL_STATUS
, PAR_FAMILY_MEMBERS
, PAR_TOTAL_IN_COLLEGE
, PAR_PAR_IN_COLLEGE
, PAR_OTHERS_IN_COLLEGE
, PAR_AESA
, PAR_CESA
, STU_AESA
, STU_CESA
, IM_P_BAS_AGI_TAXABLE_INCOME
, IM_P_BAS_UNTX_INC_AND_BEN
, IM_P_BAS_INC_ADJ
, IM_P_BAS_TOTAL_INCOME
, IM_P_BAS_US_INCOME_TAX
, IM_P_BAS_ST_AND_OTHER_TAX
, IM_P_BAS_FICA_TAX
, IM_P_BAS_MED_DENTAL
, IM_P_BAS_EMPLOYMENT_ALLOW
, IM_P_BAS_ANNUAL_ED_SAVINGS
, IM_P_BAS_INC_PROT_ALLOW_M
, IM_P_BAS_TOTAL_INC_ALLOW
, IM_P_BAS_CAL_AVAIL_INC
, IM_P_BAS_AVAIL_INCOME
, IM_P_BAS_TOTAL_CONT_INC
, IM_P_BAS_CASH_BANK_ACCOUNTS
, IM_P_BAS_HOME_EQUITY
, IM_P_BAS_OT_RL_EST_INV_EQ
, IM_P_BAS_ADJ_BUS_FARM_WORTH
, IM_P_BAS_ASS_SIBS_PRE_TUI
, IM_P_BAS_NET_WORTH
, IM_P_BAS_EMERG_RES_ALLOW
, IM_P_BAS_CUM_ED_SAVINGS
, IM_P_BAS_LOW_INC_ALLOW
, IM_P_BAS_TOTAL_ASSET_ALLOW
, IM_P_BAS_DISC_NET_WORTH
, IM_P_BAS_TOTAL_CONT_ASSET
, IM_P_BAS_TOTAL_CONT
, IM_P_BAS_NUM_IN_COLL_ADJ
, IM_P_BAS_CONT_FOR_STU
, IM_P_BAS_CONT_FROM_INCOME
, IM_P_BAS_CONT_FROM_ASSETS
, IM_P_OPT_AGI_TAXABLE_INCOME
, IM_P_OPT_UNTX_INC_AND_BEN
, IM_P_OPT_INC_ADJ
, IM_P_OPT_TOTAL_INCOME
, IM_P_OPT_US_INCOME_TAX
, IM_P_OPT_ST_AND_OTHER_TAX
, IM_P_OPT_FICA_TAX
, IM_P_OPT_MED_DENTAL
, IM_P_OPT_ELEM_SEC_TUIT
, IM_P_OPT_EMPLOYMENT_ALLOW
, IM_P_OPT_ANNUAL_ED_SAVINGS
, IM_P_OPT_INC_PROT_ALLOW_M
, IM_P_OPT_TOTAL_INC_ALLOW
, IM_P_OPT_CAL_AVAIL_INC
, IM_P_OPT_AVAIL_INCOME
, IM_P_OPT_TOTAL_CONT_INC
, IM_P_OPT_CASH_BANK_ACCOUNTS
, IM_P_OPT_HOME_EQUITY
, IM_P_OPT_OT_RL_EST_INV_EQ
, IM_P_OPT_ADJ_BUS_FARM_WORTH
, IM_P_OPT_ASS_SIBS_PRE_TUI
, IM_P_OPT_NET_WORTH
, IM_P_OPT_EMERG_RES_ALLOW
, IM_P_OPT_CUM_ED_SAVINGS
, IM_P_OPT_LOW_INC_ALLOW
, IM_P_OPT_TOTAL_ASSET_ALLOW
, IM_P_OPT_DISC_NET_WORTH
, IM_P_OPT_TOTAL_CONT_ASSET
, IM_P_OPT_TOTAL_CONT
, IM_P_OPT_NUM_IN_COLL_ADJ
, IM_P_OPT_CONT_FOR_STU
, IM_P_OPT_CONT_FROM_INCOME
, IM_P_OPT_CONT_FROM_ASSETS
, FM_P_ANALYSIS_TYPE
, FM_P_AGI_TAXABLE_INCOME
, FM_P_UNTX_INC_AND_BEN
, FM_P_INC_ADJ
, FM_P_TOTAL_INCOME
, FM_P_US_INCOME_TAX
, FM_P_STATE_AND_OTHER_TAXES
, FM_P_FICA_TAX
, FM_P_EMPLOYMENT_ALLOW
, FM_P_INCOME_PROT_ALLOW
, FM_P_TOTAL_ALLOW
, FM_P_AVAIL_INCOME
, FM_P_CASH_BANK_ACCOUNTS
, FM_P_OT_RL_EST_INV_EQUITY
, FM_P_ADJ_BUS_FARM_NET_WORTH
, FM_P_NET_WORTH
, FM_P_ASSET_PROT_ALLOW
, FM_P_DISC_NET_WORTH
, FM_P_TOTAL_CONTRIBUTION
, FM_P_NUM_IN_COLL
, FM_P_CONT_FOR_STU
, FM_P_CONT_FROM_INCOME
, FM_P_CONT_FROM_ASSETS
, IM_S_BAS_AGI_TAXABLE_INCOME
, IM_S_BAS_UNTX_INC_AND_BEN
, IM_S_BAS_INC_ADJ
, IM_S_BAS_TOTAL_INCOME
, IM_S_BAS_US_INCOME_TAX
, IM_S_BAS_STATE_AND_OTH_TAXES
, IM_S_BAS_FICA_TAX
, IM_S_BAS_MED_DENTAL
, IM_S_BAS_EMPLOYMENT_ALLOW
, IM_S_BAS_ANNUAL_ED_SAVINGS
, IM_S_BAS_INC_PROT_ALLOW_M
, IM_S_BAS_TOTAL_INC_ALLOW
, IM_S_BAS_CAL_AVAIL_INCOME
, IM_S_BAS_AVAIL_INCOME
, IM_S_BAS_TOTAL_CONT_INC
, IM_S_BAS_CASH_BANK_ACCOUNTS
, IM_S_BAS_HOME_EQUITY
, IM_S_BAS_OT_RL_EST_INV_EQ
, IM_S_BAS_ADJ_BUSFARM_WORTH
, IM_S_BAS_TRUSTS
, IM_S_BAS_NET_WORTH
, IM_S_BAS_EMERG_RES_ALLOW
, IM_S_BAS_CUM_ED_SAVINGS
, IM_S_BAS_TOTAL_ASSET_ALLOW
, IM_S_BAS_DISC_NET_WORTH
, IM_S_BAS_TOTAL_CONT_ASSET
, IM_S_BAS_TOTAL_CONT
, IM_S_BAS_NUM_IN_COLL_ADJ
, IM_S_BAS_CONT_FOR_STU
, IM_S_BAS_CONT_FROM_INCOME
, IM_S_BAS_CONT_FROM_ASSETS
, IM_S_EST_AGITAXABLE_INCOME
, IM_S_EST_UNTX_INC_AND_BEN
, IM_S_EST_INC_ADJ
, IM_S_EST_TOTAL_INCOME
, IM_S_EST_US_INCOME_TAX
, IM_S_EST_STATE_AND_OTH_TAXES
, IM_S_EST_FICA_TAX
, IM_S_EST_MED_DENTAL
, IM_S_EST_EMPLOYMENT_ALLOW
, IM_S_EST_ANNUAL_ED_SAVINGS
, IM_S_EST_INC_PROT_ALLOW_M
, IM_S_EST_TOTAL_INC_ALLOW
, IM_S_EST_CAL_AVAIL_INCOME
, IM_S_EST_AVAIL_INCOME
, IM_S_EST_TOTAL_CONT_INC
, IM_S_EST_CASH_BANK_ACCOUNTS
, IM_S_EST_HOME_EQUITY
, IM_S_EST_OT_RL_EST_INV_EQ
, IM_S_EST_ADJ_BUS_FARM_WORTH
, IM_S_EST_EST_TRUSTS
, IM_S_EST_NET_WORTH
, IM_S_EST_EMERG_RES_ALLOW
, IM_S_EST_CUM_ED_SAVINGS
, IM_S_EST_TOTAL_ASSET_ALLOW
, IM_S_EST_DISC_NET_WORTH
, IM_S_EST_TOTAL_CONT_ASSET
, IM_S_EST_TOTAL_CONT
, IM_S_EST_NUM_IN_COLL_ADJ
, IM_S_EST_CONT_FOR_STU
, IM_S_EST_CONT_FROM_INCOME
, IM_S_EST_CONT_FROM_ASSETS
, IM_S_OPT_AGI_TAXABLE_INCOME
, IM_S_OPT_UNTX_INC_AND_BEN
, IM_S_OPT_INC_ADJ
, IM_S_OPT_TOTAL_INCOME
, IM_S_OPT_US_INCOME_TAX
, IM_S_OPT_STATE_AND_OTH_TAXES
, IM_S_OPT_FICA_TAX
, IM_S_OPT_MED_DENTAL
, IM_S_OPT_EMPLOYMENT_ALLOW
, IM_S_OPT_ANNUAL_ED_SAVINGS
, IM_S_OPT_INC_PROT_ALLOW_M
, IM_S_OPT_TOTAL_INC_ALLOW
, IM_S_OPT_CAL_AVAIL_INCOME
, IM_S_OPT_AVAIL_INCOME
, IM_S_OPT_TOTAL_CONT_INC
, IM_S_OPT_CASH_BANK_ACCOUNTS
, IM_S_OPT_IRA_KEOGH_ACCOUNTS
, IM_S_OPT_HOME_EQUITY
, IM_S_OPT_OT_RL_EST_INV_EQ
, IM_S_OPT_ADJ_BUS_FARM_WORTH
, IM_S_OPT_TRUSTS
, IM_S_OPT_NET_WORTH
, IM_S_OPT_EMERG_RES_ALLOW
, IM_S_OPT_CUM_ED_SAVINGS
, IM_S_OPT_TOTAL_ASSET_ALLOW
, IM_S_OPT_DISC_NET_WORTH
, IM_S_OPT_TOTAL_CONT_ASSET
, IM_S_OPT_TOTAL_CONT
, IM_S_OPT_NUM_IN_COLL_ADJ
, IM_S_OPT_CONT_FOR_STU
, IM_S_OPT_CONT_FROM_INCOME
, IM_S_OPT_CONT_FROM_ASSETS
, FM_S_ANALYSIS_TYPE
, FM_S_AGI_TAXABLE_INCOME
, FM_S_UNTX_INC_AND_BEN
, FM_S_INC_ADJ
, FM_S_TOTAL_INCOME
, FM_S_US_INCOME_TAX
, FM_S_STATE_AND_OTH_TAXES
, FM_S_FICA_TAX
, FM_S_EMPLOYMENT_ALLOW
, FM_S_INCOME_PROT_ALLOW
, FM_S_TOTAL_ALLOW
, FM_S_CAL_AVAIL_INCOME
, FM_S_AVAIL_INCOME
, FM_S_CASH_BANK_ACCOUNTS
, FM_S_OT_RL_EST_INV_EQUITY
, FM_S_ADJ_BUS_FARM_WORTH
, FM_S_TRUSTS
, FM_S_NET_WORTH
, FM_S_ASSET_PROT_ALLOW
, FM_S_DISC_NET_WORTH
, FM_S_TOTAL_CONT
, FM_S_NUM_IN_COLL
, FM_S_CONT_FOR_STU
, FM_S_CONT_FROM_INCOME
, FM_S_CONT_FROM_ASSETS
, IM_INST_RESIDENT_IND
, INSTITUTIONAL_1_BUDGET_NAME
, IM_INST_1_BUDGET_DURATION
, IM_INST_1_TUITION_FEES
, IM_INST_1_BOOKS_SUPPLIES
, IM_INST_1_LIVING_EXPENSES
, IM_INST_1_TOT_EXPENSES
, IM_INST_1_TOT_STU_CONT
, IM_INST_1_TOT_PAR_CONT
, IM_INST_1_TOT_FAMILY_CONT
, IM_INST_1_VA_BENEFITS
, IM_INST_1_OT_CONT
, IM_INST_1_EST_FINANCIAL_NEED
, INSTITUTIONAL_2_BUDGET_NAME
, IM_INST_2_BUDGET_DURATION
, IM_INST_2_TUITION_FEES
, IM_INST_2_BOOKS_SUPPLIES
, IM_INST_2_LIVING_EXPENSES
, IM_INST_2_TOT_EXPENSES
, IM_INST_2_TOT_STU_CONT
, IM_INST_2_TOT_PAR_CONT
, IM_INST_2_TOT_FAMILY_CONT
, IM_INST_2_VA_BENEFITS
, IM_INST_2_EST_FINANCIAL_NEED
, INSTITUTIONAL_3_BUDGET_NAME
, IM_INST_3_BUDGET_DURATION
, IM_INST_3_TUITION_FEES
, IM_INST_3_BOOKS_SUPPLIES
, IM_INST_3_LIVING_EXPENSES
, IM_INST_3_TOT_EXPENSES
, IM_INST_3_TOT_STU_CONT
, IM_INST_3_TOT_PAR_CONT
, IM_INST_3_TOT_FAMILY_CONT
, IM_INST_3_VA_BENEFITS
, IM_INST_3_EST_FINANCIAL_NEED
, FM_INST_1_FEDERAL_EFC
, FM_INST_1_VA_BENEFITS
, FM_INST_1_FED_ELIGIBILITY
, FM_INST_1_PELL
, OPTION_PAR_LOSS_ALLOW_IND
, OPTION_PAR_TUITION_IND
, OPTION_PAR_HOME_IND
, OPTION_PAR_HOME_VALUE
, OPTION_PAR_HOME_DEBT
, OPTION_STU_IRA_KEOGH_IND
, OPTION_STU_HOME_IND
, OPTION_STU_HOME_VALUE
, OPTION_STU_HOME_DEBT
, OPTION_STU_SUM_AY_INC_IND
, OPTION_PAR_HOPE_LL_CREDIT
, OPTION_STU_HOPE_LL_CREDIT
, IM_PARENT_1_8_MONTHS_BAS
, IM_P_MORE_THAN_9_MTH_BA
, IM_PARENT_1_8_MONTHS_OPT
, IM_P_MORE_THAN_9_MTH_OP
, FNAR_MESSAGE_1
, FNAR_MESSAGE_2
, FNAR_MESSAGE_3
, FNAR_MESSAGE_4
, FNAR_MESSAGE_5
, FNAR_MESSAGE_6
, FNAR_MESSAGE_7
, FNAR_MESSAGE_8
, FNAR_MESSAGE_9
, FNAR_MESSAGE_10
, FNAR_MESSAGE_11
, FNAR_MESSAGE_12
, FNAR_MESSAGE_13
, FNAR_MESSAGE_20
, FNAR_MESSAGE_21
, FNAR_MESSAGE_22
, FNAR_MESSAGE_23
, FNAR_MESSAGE_24
, FNAR_MESSAGE_25
, FNAR_MESSAGE_26
, FNAR_MESSAGE_27
, FNAR_MESSAGE_30
, FNAR_MESSAGE_31
, FNAR_MESSAGE_32
, FNAR_MESSAGE_33
, FNAR_MESSAGE_34
, FNAR_MESSAGE_35
, FNAR_MESSAGE_36
, FNAR_MESSAGE_37
, FNAR_MESSAGE_38
, FNAR_MESSAGE_39
, FNAR_MESSAGE_45
, FNAR_MESSAGE_46
, FNAR_MESSAGE_47
, FNAR_MESSAGE_48
, FNAR_MESSAGE_50
, FNAR_MESSAGE_51
, FNAR_MESSAGE_52
, FNAR_MESSAGE_53
, FNAR_MESSAGE_56
, FNAR_MESSAGE_57
, FNAR_MESSAGE_58
, FNAR_MESSAGE_59
, FNAR_MESSAGE_60
, FNAR_MESSAGE_61
, FNAR_MESSAGE_62
, FNAR_MESSAGE_63
, FNAR_MESSAGE_64
, FNAR_MESSAGE_65
, FNAR_MESSAGE_71
, FNAR_MESSAGE_72
, FNAR_MESSAGE_73
, FNAR_MESSAGE_74
, FNAR_MESSAGE_75
, FNAR_MESSAGE_76
, FNAR_MESSAGE_77
, FNAR_MESSAGE_78
, FNAR_MESG_10_STU_FAM_MEM
, FNAR_MESG_11_STU_NO_IN_COLL
, FNAR_MESG_24_STU_AVAIL_INC
, FNAR_MESG_26_STU_TAXES
, FNAR_MESG_33_STU_HOME_VALUE
, FNAR_MESG_34_STU_HOME_VALUE
, FNAR_MESG_34_STU_HOME_EQUITY
, FNAR_MESG_35_STU_HOME_VALUE
, FNAR_MESG_35_STU_HOME_EQUITY
, FNAR_MESG_36_STU_HOME_EQUITY
, FNAR_MESG_48_PAR_FAM_MEM
, FNAR_MESG_49_PAR_NO_IN_COLL
, FNAR_MESG_56_PAR_AGI
, FNAR_MESG_62_PAR_TAXES
, FNAR_MESG_73_PAR_HOME_VALUE
, FNAR_MESG_74_PAR_HOME_VALUE
, FNAR_MESG_74_PAR_HOME_EQUITY
, FNAR_MESG_75_PAR_HOME_VALUE
, FNAR_MESG_75_PAR_HOME_EQUITY
, FNAR_MESG_76_PAR_HOME_EQUITY
, ASSUMPTION_MESSAGE_1
, ASSUMPTION_MESSAGE_2
, ASSUMPTION_MESSAGE_3
, ASSUMPTION_MESSAGE_4
, ASSUMPTION_MESSAGE_5
, ASSUMPTION_MESSAGE_6
, RECORD_MARK
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, OPTION_PAR_COLA_ADJ_IND
, OPTION_PAR_STU_FA_ASSETS_IND
, OPTION_PAR_IPT_ASSETS_IND
, OPTION_STU_IPT_ASSETS_IND
, OPTION_PAR_COLA_ADJ_VALUE
, FNAR_MESSAGE_49
, FNAR_MESSAGE_55
, LEGACY_RECORD_FLAG
, OPTION_IND_STU_IPT_ASSETS_FLAG
, CUST_PARENT_CONT_ADJ_NUM
, CUSTODIAL_PARENT_NUM
, CUST_PAR_BASE_PRCNT_INC_AMT
, CUST_PAR_BASE_CONT_INC_AMT
, CUST_PAR_BASE_CONT_AST_AMT
, CUST_PAR_BASE_TOT_CONT_AMT
, CUST_PAR_OPT_PRCNT_INC_AMT
, CUST_PAR_OPT_CONT_INC_AMT
, CUST_PAR_OPT_CONT_AST_AMT
, CUST_PAR_OPT_TOT_CONT_AMT
, PARENTS_EMAIL_TXT
, PARENT_1_BIRTH_DATE
, PARENT_2_BIRTH_DATE
FROM IGF.IGF_AP_CSS_FNAR_ALL;
IGF.IGF_AP_CSS_FNAR_ALL does not reference any database object
IGF.IGF_AP_CSS_FNAR_ALL is referenced by following:
APPS
IGF_AP_CSS_FNAR_ALL
|
|
|
|