[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_AP_LI_CSS_INTS |
|---|---|
| Object Type: | TABLE |
| Owner: | IGF |
| FND Design Data: |  IGF.IGF_AP_LI_CSS_INTS
|
| Subobject Name: | |
| Status: | VALID |
Interface table for Profile used for uploading profile data into the system
Scope: public
Product: IGF
Lifecycle: active
Display Name: Legacy - PROFILE Import Process using Legacy Interface Tables
Category: BUSINESS_ENTITY IGF_PROFILE
| Tablespace: |  APPS_TS_INTERFACE |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGF_AP_LI_CSS_INTS_PK | NORMAL | UNIQUE |
APPS_TS_INTERFACE
|
 CSSINT_ID
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| BATCH_NUM | NUMBER | (15) | Yes | Batch Identifier, used to identify the set of records to be processed. |
| CSSINT_ID | NUMBER | Yes | Uniquely identify each record in the interface table. | |
| PERSON_NUMBER | VARCHAR2 | (30) | Yes | Identifier for student |
| COLLEGE_CD | VARCHAR2 | (4) | College code of the college receiving this application | |
| ACADEMIC_YEAR_TXT | VARCHAR2 | (2) | Yes | Holds the year for which this record is valid |
| STU_RECORD_TYPE | VARCHAR2 | (1) | Contains the type of student profile record | |
| CSS_ID_NUMBER_TXT | VARCHAR2 | (7) | Yes | Holds the Unique identifier for the CSS record |
| REGISTRATION_RECEIPT_DATE | DATE | Holds the date on which the registration was received | ||
| REGISTRATION_TYPE | VARCHAR2 | (1) | Contains the type of registration | |
| APPLICATION_RECEIPT_DATE | DATE | Date on which the application was received by the college board | ||
| APPLICATION_TYPE | VARCHAR2 | (1) | Describes the type of application | |
| ORIGINAL_FNAR_COMPUTE_TXT | VARCHAR2 | (8) | Describes the computed Original FNAR | |
| REVISION_FNAR_COMPUTE_DATE | DATE | Holds the Revision FNAR compute date | ||
| ELECTRONIC_EXTRACT_DATE | DATE | holds the electronic extract date | ||
| INSTIT_REPORTING_TYPE | VARCHAR2 | (1) | Describes the institutional reporting type | |
| ASR_RECEIPT_DATE | DATE | Holds the ASR receipt date | ||
| LAST_NAME | VARCHAR2 | (16) | Yes | Holds the last name of the student |
| FIRST_NAME | VARCHAR2 | (12) | Yes | Indicates first name of applicant student |
| MIDDLE_INITIAL_TXT | VARCHAR2 | (1) | Holds the middle initial of the student | |
| ADDRESS_NUMBER_AND_STREET_TXT | VARCHAR2 | (28) | Contains the street address of the student | |
| CITY_TXT | VARCHAR2 | (17) | Holds the students' city of residence | |
| STATE_MAILING_TXT | VARCHAR2 | (2) | Holds the state mailing address | |
| ZIP_CD | VARCHAR2 | (5) | Holds the zip code | |
| S_TELEPHONE_NUMBER_TXT | VARCHAR2 | (10) | Holds the telephone number of the student | |
| S_TITLE_TYPE | VARCHAR2 | (1) | Holds the title of the student | |
| BIRTH_DATE | DATE | Holds the students' Date of Birth | ||
| SOCIAL_SECURITY_NUM | NUMBER | (9) | Holds the students' Social Security Number | |
| STATE_LEGAL_RESIDENCE_TXT | VARCHAR2 | (2) | Holds the students' state of legal residence | |
| FOREIGN_ADDRESS_FLAG | VARCHAR2 | (1) | Indicates if a student has a foreign address | |
| FOREIGN_POSTAL_CD | VARCHAR2 | (9) | Holds the students' foreign postal code | |
| COUNTRY_CD | VARCHAR2 | (25) | Holds the students' country | |
| FINANCIAL_AID_STATUS_TYPE | VARCHAR2 | (1) | Holds the student's financial aid status | |
| YEAR_IN_COLLEGE_TYPE | VARCHAR2 | (1) | Holds the number of years spent in college by the student | |
| MARITAL_STATUS_FLAG | VARCHAR2 | (1) | Holds the student's marital status | |
| WARD_COURT_FLAG | VARCHAR2 | (1) | Indicates if the student is ward of count | |
| LEGAL_DEPENDENTS_OTHER_FLAG | VARCHAR2 | (1) | Indicates if the student has other legal dependents | |
| HOUSEHOLD_SIZE_NUM | NUMBER | (2) | Holds the student's households size | |
| NUMBER_IN_COLLEGE_NUM | NUMBER | (1) | Number of student's family members in college | |
| CITIZENSHIP_STATUS_TYPE | VARCHAR2 | (1) | Holds the student's citizenship status | |
| CITIZENSHIP_COUNTRY_CD | VARCHAR2 | (15) | Holds the student's citizenship country | |
| VISA_CLASSIFICATION_TYPE | VARCHAR2 | (1) | Indicates the Visa classification for the student | |
| TAX_FIGURES_TYPE | VARCHAR2 | (1) | Holds the tax figures of the student | |
| NUMBER_EXEMPTIONS_TXT | VARCHAR2 | (2) | Number of exemptions claimed by the student | |
| ADJUSTED_GROSS_AMT | NUMBER | (7) | Holds the student's adjusted gross income | |
| US_TAX_PAID_AMT | NUMBER | (6) | Indicates the US tax paid by the student | |
| ITEMIZED_DEDUCTIONS_AMT | NUMBER | (6) | Holds the student's itemized deductions | |
| STU_INCOME_WORK_AMT | NUMBER | (7) | Holds the students income from work | |
| SPOUSE_INCOME_WORK_AMT | NUMBER | (7) | Holds the student's spouse's income from work | |
| DIVID_INT_INCOME_AMT | NUMBER | (6) | student's income from dividends and interest | |
| SOC_SEC_BENEFITS_AMT | NUMBER | (6) | Holds the student's social security benefits | |
| WELFARE_TANF_AMT | NUMBER | (6) | Indicates the welfare TANF gains for the student | |
| CHILD_SUPP_RCVD_AMT | NUMBER | (6) | Holds the child support received by student | |
| EARNED_INCOME_CREDIT_AMT | NUMBER | (6) | Holds the earned income credit of the student | |
| OTHER_UNTAX_INCOME_AMT | NUMBER | (6) | Holds the other untaxed income of student | |
| TAX_STU_AID_AMT | NUMBER | (6) | Holds the taxable aid received by the student | |
| CASH_SAV_CHECK_AMT | NUMBER | (7) | Holds the cash saving or checking balance of the student | |
| IRA_KEOGH_AMT | NUMBER | (7) | Holds the IRA KEOGH received by the student | |
| INVEST_VALUE_AMT | NUMBER | (7) | Holds the student's investment value | |
| INVEST_DEBT_AMT | NUMBER | (7) | Holds the student's investment debt | |
| HOME_VALUE_AMT | NUMBER | (7) | Holds the student's home value | |
| HOME_DEBT_AMT | NUMBER | (7) | Holds the student's home debt | |
| OTH_REAL_VALUE_AMT | NUMBER | (7) | Holds the student's other real value | |
| OTH_REAL_DEBT_AMT | NUMBER | (7) | Holds the student's other real debt | |
| BUS_FARM_VALUE_AMT | NUMBER | (7) | Holds the student's business farm value | |
| BUS_FARM_DEBT_AMT | NUMBER | (7) | Holds the student's business farm debt | |
| LIVE_ON_FARM_FLAG | VARCHAR2 | (1) | Indicates if student lives on a farm | |
| HOME_PURCH_PRICE_AMT | NUMBER | (7) | Holds the student's home purchase price | |
| HOPE_LL_CREDIT_AMT | NUMBER | (6) | Holds the student's hope credit received | |
| HOME_PURCH_YEAR_TXT | VARCHAR2 | (4) | Indicates students home purchase year | |
| TRUST_AMOUNT_TXT | VARCHAR2 | (7) | Indicates the trust amount for the student | |
| TRUST_AVAIL_FLAG | VARCHAR2 | (1) | Indicates when the trust was established was established for the student | |
| TRUST_ESTAB_FLAG | VARCHAR2 | (1) | Indicates when the trust was established was established for the student | |
| CHILD_SUPPORT_PAID_TXT | VARCHAR2 | (6) | Indicates child support paid by the student | |
| MED_DENT_EXPENSES_TXT | VARCHAR2 | (6) | Holds the medical dental expenses of the student | |
| VET_US_FLAG | VARCHAR2 | (1) | Indicates if the student is US Veteran | |
| VET_BEN_AMT | NUMBER | (4) | Holds the veteran benefit amount for the student | |
| VET_BEN_MONTHS_NUM | NUMBER | (2) | Holds the veteran benefit months for the student | |
| STU_SUMMER_WAGES_AMT | NUMBER | (6) | Holds summer wages of the student | |
| STU_SCHOOL_YR_WAGES_AMT | NUMBER | (6) | Holds school year wages of the student | |
| SPOUSE_SUMMER_WAGES_AMT | NUMBER | (6) | Holds students spouse summer wages | |
| SPOUSE_SCHOOL_YR_WAGES_AMT | NUMBER | (6) | Holds students spouse school year wages | |
| SUMMER_OTHER_TAX_INC_AMT | NUMBER | (6) | Holds other taxable income of the student during summer | |
| SCHOOL_YR_OTHER_TAX_INC_AMT | NUMBER | (6) | Holds other taxable income of the student during school year | |
| SUMMER_UNTAX_INC_AMT | NUMBER | (6) | Holds the untaxed income of the student during summer | |
| SCHOOL_YR_UNTAX_INC_AMT | NUMBER | (6) | Holds untaxed income of the student during school year | |
| GRANTS_SCHOL_ETC_AMT | NUMBER | (6) | Holds whether the grants are received from school for the student | |
| TUIT_BENEFITS_AMT | NUMBER | (6) | Hold the tuition benefits for the student | |
| CONT_PARENTS_AMT | NUMBER | (6) | Holds the contribution made by the parent of the student | |
| CONT_RELATIVES_AMT | NUMBER | (6) | Holds the contribution made by the relatives of the student | |
| P_SIBLINGS_PRE_TUIT_AMT | NUMBER | (8) | Holds parents siblings pre tuition | |
| P_STUDENT_PRE_TUIT_AMT | NUMBER | (8) | Holds student pre tuition | |
| P_HOUSEHOLD_SIZE_NUM | NUMBER | (2) | Holds parents household size | |
| P_IN_COLLEGE_NUM | NUMBER | (1) | Holds parents number in college | |
| P_PARENTS_IN_COLLEGE_NUM | NUMBER | (1) | Holds parents in college | |
| P_MARITAL_STATUS_TYPE | VARCHAR2 | (1) | Holds parents marital status | |
| P_STATE_LEGAL_RESIDENCE_CD | VARCHAR2 | (2) | Holds parents state legal residence | |
| P_NATURAL_PAR_STATUS_FLAG | VARCHAR2 | (1) | Holds natural parents status | |
| P_CHILD_SUPP_PAID_AMT | NUMBER | (6) | Holds parents child support paid | |
| P_REPAY_ED_LOANS_AMT | NUMBER | (6) | Holds parents repay education loans | |
| P_MED_DENT_EXPENSES_AMT | NUMBER | (6) | Holds parents medical and dental expenses | |
| P_TUIT_PAID_AMT | NUMBER | (6) | Holds parents tuition paid amount | |
| P_TUIT_PAID_NUM | NUMBER | (1) | Holds parents tuition paid number | |
| P_EXP_CHILD_SUPP_PAID_AMT | NUMBER | (6) | Holds parents expected child support paid | |
| P_EXP_REPAY_ED_LOANS_AMT | NUMBER | (6) | Holds parents expected to repay education loans | |
| P_EXP_MED_DENT_EXPENSES_AMT | NUMBER | (6) | Holds parents expected medical and dental expenses | |
| P_EXP_TUIT_PD_AMT | NUMBER | (6) | Holds parents expected tuition paid amount | |
| P_EXP_TUIT_PD_NUM | NUMBER | (1) | Holds parents expected tuition paid number | |
| P_CASH_SAV_CHECK_AMT | NUMBER | (7) | Holds parents cash save check | |
| P_MONTH_MORTGAGE_PAY_AMT | NUMBER | (6) | Holds parents month mortgage pay | |
| P_INVEST_VALUE_AMT | NUMBER | (8) | Holds parents invest value | |
| P_INVEST_DEBT_AMT | NUMBER | (8) | Holds parents invest debt | |
| P_HOME_VALUE_AMT | NUMBER | (8) | Holds parents home value | |
| P_HOME_DEBT_AMT | NUMBER | (8) | Holds parents home debt | |
| P_HOME_PURCH_PRICE_AMT | NUMBER | (8) | Holds parents home purchase price | |
| P_OWN_BUSINESS_FARM_FLAG | VARCHAR2 | (1) | Holds parents own business farm | |
| P_BUSINESS_VALUE_AMT | NUMBER | (8) | Holds parents business value | |
| P_BUSINESS_DEBT_AMT | NUMBER | (8) | Holds parents business debt | |
| P_FARM_VALUE_AMT | NUMBER | (8) | Holds parents farm value | |
| P_FARM_DEBT_AMT | NUMBER | (8) | Holds parents farm debt | |
| P_LIVE_ON_FARM_NUM | NUMBER | (1) | Holds parents live on farm | |
| P_OTH_REAL_ESTATE_VALUE_AMT | NUMBER | (8) | Holds parents other real estate value | |
| P_OTH_REAL_ESTATE_DEBT_AMT | NUMBER | (8) | Holds parents other real estate debt | |
| P_OTH_REAL_PURCH_PRICE_AMT | NUMBER | (8) | Holds parents other real purchase price | |
| P_SIBLINGS_ASSETS_AMT | NUMBER | (8) | Holds parents siblings assets | |
| P_HOME_PURCH_YEAR_TXT | VARCHAR2 | (4) | Holds parents home purchase year | |
| P_OTH_REAL_PURCH_YEAR_TXT | VARCHAR2 | (4) | Holds parents other real purchase year | |
| P_PRIOR_AGI_AMT | NUMBER | (8) | Holds parents Actual Gross Income | |
| P_PRIOR_US_TAX_PAID_AMT | NUMBER | (7) | Holds parents prior us tax paid | |
| P_PRIOR_ITEM_DEDUCTIONS_AMT | NUMBER | (7) | Holds parents prior item deductions | |
| P_PRIOR_OTHER_UNTAX_INC_AMT | NUMBER | (7) | Holds parents prior other untaxed income | |
| P_TAX_FIGURES_NUM | NUMBER | (1) | Holds parents tax figures | |
| P_NUMBER_EXEMPTIONS_NUM | NUMBER | (2) | Holds parents number exemptions | |
| P_ADJUSTED_GROSS_INC_AMT | NUMBER | (8) | Holds parents adjusted gross income | |
| P_WAGES_SAL_TIPS_AMT | NUMBER | (7) | Holds parents wages salary tips | |
| P_INTEREST_INCOME_AMT | NUMBER | (7) | Holds parents interest income | |
| P_DIVIDEND_INCOME_AMT | NUMBER | (7) | Holds parents dividend income | |
| P_NET_INC_BUS_FARM_AMT | NUMBER | (7) | Holds parents net income bus farm | |
| P_OTHER_TAXABLE_INCOME_AMT | NUMBER | (7) | Holds parents other taxable income | |
| P_ADJ_TO_INCOME_AMT | NUMBER | (7) | Holds parents adjust to income | |
| P_US_TAX_PAID_AMT | NUMBER | (7) | Holds parents US tax paid | |
| P_ITEMIZED_DEDUCTIONS_AMT | NUMBER | (7) | Holds parents itemized deductions | |
| P_FATHER_INCOME_WORK_AMT | NUMBER | (7) | Holds father income work | |
| P_MOTHER_INCOME_WORK_AMT | NUMBER | (7) | Holds Mother's income from work | |
| P_SOC_SEC_BEN_AMT | NUMBER | (6) | Holds parents social security benefits | |
| P_WELFARE_TANF_AMT | NUMBER | (6) | Holds parents welfare transfer | |
| P_CHILD_SUPP_RCVD_AMT | NUMBER | (6) | Holds children support received | |
| P_DED_IRA_KEOGH_AMT | NUMBER | (6) | Deductions IRA KEOGH | |
| P_TAX_DEFER_PENS_SAVS_AMT | NUMBER | (6) | Holds parents tax defer pension savings | |
| P_DEP_CARE_MED_SPENDING_AMT | NUMBER | (6) | Describes dependents care medical spending | |
| P_EARNED_INCOME_CREDIT_AMT | NUMBER | (6) | Holds parents earned income credit | |
| P_LIVING_ALLOW_AMT | NUMBER | (6) | Parents living allowance | |
| P_TAX_EXMPT_INT_AMT | NUMBER | (6) | tax exempt interest | |
| P_FOREIGN_INC_EXCL_AMT | NUMBER | (6) | Holds parents foreign income exclusion | |
| P_OTHER_UNTAX_INC_AMT | NUMBER | (6) | Contains other untaxed income | |
| P_HOPE_LL_CREDIT_AMT | NUMBER | (6) | Holds parents hope LL credit | |
| P_YR_SEPARATION_AMT | NUMBER | (4) | Holds parents year separation | |
| P_YR_DIVORCE_AMT | NUMBER | (4) | Holds parents year divorce | |
| P_EXP_FATHER_INC_AMT | NUMBER | (7) | Holds expected father income | |
| P_EXP_MOTHER_INC_AMT | NUMBER | (7) | Holds expected mother income | |
| P_EXP_OTHER_TAX_INC_AMT | NUMBER | (7) | Contains expected other tax income | |
| P_EXP_OTHER_UNTAX_INC_AMT | NUMBER | (7) | Contains expected other untaxed income | |
| LINE_2_RELATION_TYPE | VARCHAR2 | (1) | Holds line relation | |
| LINE_2_ATTEND_COLLEGE_TYPE | VARCHAR2 | (1) | Contains line attend college | |
| LINE_3_RELATION_TYPE | VARCHAR2 | (1) | Holds line relation | |
| LINE_3_ATTEND_COLLEGE_TYPE | VARCHAR2 | (1) | Contains line attend college | |
| LINE_4_RELATION_TYPE | VARCHAR2 | (1) | Holds line relation | |
| LINE_4_ATTEND_COLLEGE_TYPE | VARCHAR2 | (1) | Contains line attend college | |
| LINE_5_RELATION_TYPE | VARCHAR2 | (1) | Holds line relation | |
| LINE_5_ATTEND_COLLEGE_TYPE | VARCHAR2 | (1) | Contains line attend college | |
| LINE_6_RELATION_TYPE | VARCHAR2 | (1) | Holds line relation | |
| LINE_6_ATTEND_COLLEGE_TYPE | VARCHAR2 | (1) | Contains line attend college | |
| LINE_7_RELATION_TYPE | VARCHAR2 | (1) | Holds line relation | |
| LINE_7_ATTEND_COLLEGE_TYPE | VARCHAR2 | (1) | Contains line attend college | |
| LINE_8_RELATION_TYPE | VARCHAR2 | (1) | Holds line relation | |
| LINE_8_ATTEND_COLLEGE_TYPE | VARCHAR2 | (1) | Contains line attend college | |
| P_AGE_FATHER_NUM | NUMBER | (2) | Holds age of father | |
| P_AGE_MOTHER_NUM | NUMBER | (2) | Holds age of mother | |
| P_DIV_SEP_FLAG | VARCHAR2 | (1) | Holds parents divorce or separation indicator | |
| B_CONT_NON_CUSTODIAL_PAR_TXT | VARCHAR2 | (6) | Contribution of non custodial parents | |
| COLLEGE_2_TYPE | VARCHAR2 | (1) | Describes the College type | |
| COLLEGE_3_TYPE | VARCHAR2 | (1) | Describes the College type | |
| COLLEGE_4_TYPE | VARCHAR2 | (1) | Describes the College type | |
| COLLEGE_5_TYPE | VARCHAR2 | (1) | Describes the College type | |
| COLLEGE_6_TYPE | VARCHAR2 | (1) | Describes the College type | |
| COLLEGE_7_TYPE | VARCHAR2 | (1) | Describes the College type | |
| COLLEGE_8_TYPE | VARCHAR2 | (1) | Describes the College type | |
| SCHOOL_1_CD | VARCHAR2 | (4) | Contains School code | |
| HOUSING_1_TYPE | VARCHAR2 | (1) | Contains housing code | |
| SCHOOL_2_CD | VARCHAR2 | (4) | Contains School code | |
| HOUSING_2_TYPE | VARCHAR2 | (1) | Contains housing code | |
| SCHOOL_3_CD | VARCHAR2 | (4) | Contains School code | |
| HOUSING_3_TYPE | VARCHAR2 | (1) | Contains housing code | |
| SCHOOL_4_CD | VARCHAR2 | (4) | Contains School code | |
| HOUSING_4_TYPE | VARCHAR2 | (1) | Contains housing code | |
| SCHOOL_5_CD | VARCHAR2 | (4) | Contains School code | |
| HOUSING_5_TYPE | VARCHAR2 | (1) | Contains housing code | |
| SCHOOL_6_CD | VARCHAR2 | (4) | Contains School code | |
| HOUSING_6_TYPE | VARCHAR2 | (1) | Contains housing code | |
| SCHOOL_7_CD | VARCHAR2 | (4) | Contains School code | |
| HOUSING_7_TYPE | VARCHAR2 | (1) | Contains housing code | |
| SCHOOL_8_CD | VARCHAR2 | (4) | Contains School code | |
| HOUSING_8_TYPE | VARCHAR2 | (1) | Contains housing code | |
| SCHOOL_9_CD | VARCHAR2 | (4) | Contains School code | |
| HOUSING_9_TYPE | VARCHAR2 | (1) | Contains housing code | |
| SCHOOL_10_CD | VARCHAR2 | (4) | Contains School code | |
| HOUSING_10_TYPE | VARCHAR2 | (1) | Contains housing code | |
| ADDITIONAL_SCHOOL_1_CD | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_2_CD | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_3_CD | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_4_CD | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_5_CD | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_6_CD | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_7_CD | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_8_CD | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_9_CD | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_10_CD | VARCHAR2 | (4) | Holds the additional school code | |
| EXPLANATION_SPEC_CIRCUM_FLAG | VARCHAR2 | (1) | Explanation special circumstance | |
| SIGNATURE_STUDENT_FLAG | VARCHAR2 | (1) | Holds signature of student | |
| SIGNATURE_SPOUSE_FLAG | VARCHAR2 | (1) | Holds signature of spouse | |
| SIGNATURE_FATHER_FLAG | VARCHAR2 | (1) | Holds signature of father | |
| SIGNATURE_MOTHER_FLAG | VARCHAR2 | (1) | Holds signature of mother | |
| MONTH_DAY_COMPLETED | VARCHAR2 | (4) | Describes Month day completed | |
| YEAR_COMPLETED_FLAG | VARCHAR2 | (1) | Holds year completed | |
| AGE_LINE_2_NUM | NUMBER | (2) | Holds Age line | |
| AGE_LINE_3_NUM | NUMBER | (2) | Holds Age line | |
| AGE_LINE_4_NUM | NUMBER | (2) | Holds Age line | |
| AGE_LINE_5_NUM | NUMBER | (2) | Holds Age line | |
| AGE_LINE_6_NUM | NUMBER | (2) | Holds Age line | |
| AGE_LINE_7_NUM | NUMBER | (2) | Holds Age line | |
| AGE_LINE_8_NUM | NUMBER | (2) | Holds Age line | |
| A_ONLINE_SIGNATURE_FLAG | VARCHAR2 | (1) | Holds Online Signature | |
| QUESTION_1_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_1_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_1_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_2_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_2_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_2_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_3_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_3_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_3_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_4_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_4_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_4_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_5_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_5_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_5_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_6_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_6_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_6_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_7_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_7_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_7_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_8_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_8_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_8_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_9_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_9_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_9_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_10_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_10_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_10_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_11_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_11_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_11_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_12_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_12_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_12_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_13_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_13_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_13_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_14_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_14_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_14_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_15_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_15_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_15_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_16_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_16_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_16_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_17_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_17_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_17_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_18_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_18_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_18_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_19_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_19_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_19_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_20_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_20_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_20_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_21_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_21_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_21_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_22_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_22_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_22_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_23_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_23_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_23_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_24_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_24_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_24_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_25_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_25_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_25_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_26_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_26_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_26_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_27_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_27_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_27_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_28_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_28_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_28_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_29_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTION_29_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_29_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_30_NUMBER_TXT | VARCHAR2 | (3) | Holds question number | |
| QUESTIONS_30_SIZE_NUM | NUMBER | (2) | Describes Question size | |
| QUESTION_30_ANSWER_TXT | VARCHAR2 | (20) | Describes answer to the question | |
| R_S_EMAIL_ADDRESS_TXT | VARCHAR2 | (30) | Holds the e-mail address | |
| EPS_CD | VARCHAR2 | (4) | Holds the EPS code | |
| COMP_CSS_DEPENDCY_STATUS_TYPE | VARCHAR2 | (1) | Describes computed CSS dependency status | |
| STU_AGE_NUM | NUMBER | (2) | Holds student age | |
| ASSUMED_STU_YR_IN_COLL_TYPE | VARCHAR2 | (1) | Assumed student year in college | |
| COMP_STU_MARITAL_STATUS_TYPE | VARCHAR2 | (1) | Holds computed student marital status | |
| STU_FAMILY_MEMBERS_NUM | NUMBER | (2) | Holds student family members | |
| STU_FAM_MEMBERS_IN_COLLEGE_NUM | NUMBER | (1) | Holds student family members in college | |
| PAR_MARITAL_STATUS_TYPE | VARCHAR2 | (1) | Holds parents marital status | |
| PAR_FAMILY_MEMBERS_NUM | NUMBER | (2) | Holds parents family members | |
| PAR_TOTAL_IN_COLLEGE_NUM | NUMBER | (1) | Holds parents total in college | |
| PAR_PAR_IN_COLLEGE_NUM | NUMBER | (1) | Holds parents of parents in college | |
| PAR_OTHERS_IN_COLLEGE_NUM | NUMBER | (1) | Holds parents others in college | |
| PAR_AESA_NUM | NUMBER | (1) | Holds the parents AESA | |
| PAR_CESA_NUM | NUMBER | (2) | Holds the parents CESA | |
| STU_AESA_NUM | NUMBER | (1) | Holds the students AESA | |
| STU_CESA_NUM | NUMBER | (2) | Holds the students CESA | |
| IM_P_BAS_AGI_TAXABLE_AMT | NUMBER | (7) | Parents basic adjust gross income taxable | |
| IM_P_BAS_UNTX_INC_AND_BEN_AMT | NUMBER | (7) | Holds Parents basic untaxed income and benefits | |
| IM_P_BAS_INC_ADJ_AMT | NUMBER | (6) | Holds parents basic income adjust | |
| IM_P_BAS_TOTAL_INCOME_AMT | NUMBER | (8) | Holds parents basic total income | |
| IM_P_BAS_US_INCOME_TAX_AMT | NUMBER | (6) | Holds parents basic us income tax | |
| IM_P_BAS_ST_AND_OTHER_TAX_AMT | NUMBER | (5) | Holds parents basic state and other taxes | |
| IM_P_BAS_FICA_TAX_AMT | NUMBER | (5) | Holds parents basic FICA tax | |
| IM_P_BAS_MED_DENTAL_AMT | NUMBER | (5) | Holds parents basic medical and dental | |
| IM_P_BAS_EMPLOYMENT_ALLOW_AMT | NUMBER | (4) | Holds parents basic employment allowance | |
| IM_P_BAS_ANNUAL_ED_SAVINGS_AMT | NUMBER | (5) | Holds parents basic annual education savings | |
| IM_P_BAS_INC_PROT_ALLOW_M_AMT | NUMBER | (5) | Holds parents basic income protection allowance or MMA | |
| IM_P_BAS_TOTAL_INC_ALLOW_AMT | NUMBER | (6) | Holds parents basic total income allowance | |
| IM_P_BAS_CAL_AVAIL_INC_AMT | NUMBER | (9) | Holds parents basic calculated available income | |
| IM_P_BAS_AVAIL_INCOME_AMT | NUMBER | (9) | Holds parents basic available income | |
| IM_P_BAS_TOTAL_CONT_INC_AMT | NUMBER | (6) | Holds parents basic total contribution income | |
| IM_P_BAS_CASH_BANK_ACCOUNT_AMT | NUMBER | (6) | Holds parents basic cash bank accounts | |
| IM_P_BAS_HOME_EQUITY_AMT | NUMBER | (7) | Holds parents basic home equity | |
| IM_P_BAS_OT_RL_EST_INV_EQ_AMT | NUMBER | (8) | Holds other parents basic real estate invest equity | |
| IM_P_BAS_ADJ_BUS_FARM_WRTH_AMT | NUMBER | (8) | Holds parents basic adjust business farm worth | |
| IM_P_BAS_ASS_SIBS_PRE_TUI_AMT | NUMBER | (8) | Holds parents basic assets siblings or pre tuition | |
| IM_P_BAS_NET_WORTH_AMT | NUMBER | (8) | Holds parents basic net worth | |
| IM_P_BAS_EMERG_RES_ALLOW_AMT | NUMBER | (5) | Holds parents basic emergency reserve allowance | |
| IM_P_BAS_CUM_ED_SAVINGS_AMT | NUMBER | (6) | Holds parents basic cumulative education savings | |
| IM_P_BAS_LOW_INC_ALLOW_AMT | NUMBER | (8) | Holds parents basic low income allowance | |
| IM_P_BAS_TOTAL_ASSET_ALLOW_AMT | NUMBER | (9) | Holds parents basic total asset allowance | |
| IM_P_BAS_DISC_NET_WORTH_AMT | NUMBER | (9) | Holds parents basic discretionary net worth | |
| IM_P_BAS_TOTAL_CONT_ASSET_AMT | NUMBER | (6) | Holds parents basic total contribution asset | |
| IM_P_BAS_TOTAL_CONT_AMT | NUMBER | (7) | Holds parents basic total contribution | |
| IM_P_BAS_NUM_IN_COLL_ADJ_AMT | NUMBER | (4) | Holds parents basic number in college adjustment | |
| IM_P_BAS_CONT_FOR_STU_AMT | NUMBER | (5) | Holds parents basic contribution for student | |
| IM_P_BAS_CONT_FROM_INCOME_AMT | NUMBER | (6) | Parents optional contribution from income | |
| IM_P_BAS_CONT_FROM_ASSETS_AMT | NUMBER | (6) | Holds parents basic contribution from assets | |
| IM_P_OPT_AGI_TAX_INCOME_AMT | NUMBER | (7) | Holds parents optional adjust gross income taxable | |
| IM_P_OPT_UNTX_INC_BEN_AMT | NUMBER | (7) | Holds parents optional untaxed income and benefits | |
| IM_P_OPT_INC_ADJ_AMT | NUMBER | (6) | Holds parents optional income adjustable | |
| IM_P_OPT_TOTAL_INCOME_AMT | NUMBER | (8) | Holds parents optional total income | |
| IM_P_OPT_US_INCOME_TAX_AMT | NUMBER | (6) | Holds parents optional US income tax | |
| IM_P_OPT_ST_AND_OTHER_TAX_AMT | NUMBER | (5) | Holds parents optional state and other taxes | |
| IM_P_OPT_FICA_TAX_AMT | NUMBER | (5) | Holds parents optional FICA tax | |
| IM_P_OPT_MED_DENTAL_AMT | NUMBER | (5) | Holds parents optional medical or dental | |
| IM_P_OPT_ELEM_SEC_TUIT_AMT | NUMBER | (5) | Holds parents optional elementary or secondary tuition | |
| IM_P_OPT_EMPLOYMENT_ALLOW_AMT | NUMBER | (4) | Holds Parents optional employment allowance | |
| IM_P_OPT_ANNUAL_ED_SAVING_AMT | NUMBER | (5) | Holds parents optional annual educational savings | |
| IM_P_OPT_INC_PROT_ALLOW_M_AMT | NUMBER | (5) | Holds parents optional income protection allowance or MMA | |
| IM_P_OPT_TOTAL_INC_ALLOW_AMT | NUMBER | (6) | Holds parents optional total income allowance | |
| IM_P_OPT_CAL_AVAIL_INC_AMT | NUMBER | (9) | Holds parents optional calculated available income | |
| IM_P_OPT_AVAIL_INCOME_AMT | NUMBER | (9) | Holds parents optional available income | |
| IM_P_OPT_TOTAL_CONT_INC_AMT | NUMBER | (6) | Holds parents optional total contribution income | |
| IM_P_OPT_CASH_BANK_ACCNT_AMT | NUMBER | (6) | Holds parents optional cash bank accounts | |
| IM_P_OPT_HOME_EQUITY_AMT | NUMBER | (7) | Holds parents optional home equity | |
| IM_P_OPT_OT_RL_EST_INV_EQ_AMT | NUMBER | (8) | Holds other Parents optional real estate investment equity | |
| IM_P_OPT_ADJ_FARM_WORTH_AMT | NUMBER | (8) | Holds parents optional adjust business farm worth | |
| IM_P_OPT_ASS_SIBS_PRE_T_AMT | NUMBER | (8) | Holds parents optional assets siblings pre tuition | |
| IM_P_OPT_NET_WORTH_AMT | NUMBER | (8) | Holds parents optional net worth | |
| IM_P_OPT_EMERG_RES_ALLOW_AMT | NUMBER | (5) | Holds parents optional emergency residence allowance | |
| IM_P_OPT_CUM_ED_SAVINGS_AMT | NUMBER | (6) | Holds parents optional cumulative education savings | |
| IM_P_OPT_LOW_INC_ALLOW_AMT | NUMBER | (8) | Holds parents optional low income allowance | |
| IM_P_OPT_TOTAL_ASSET_ALLOW_AMT | NUMBER | (9) | Contains the parents optional total asset allowance | |
| IM_P_OPT_DISC_NET_WORTH_AMT | NUMBER | (9) | Contains the parents optional discretionary net worth | |
| IM_P_OPT_TOTAL_CONT_ASSET_AMT | NUMBER | (6) | Contains the parents optional total contribution asset | |
| IM_P_OPT_TOTAL_CONT_AMT | NUMBER | (7) | Contains the parents optional total contribution | |
| IM_P_OPT_NUM_IN_COLL_ADJ_AMT | NUMBER | (4) | Contains the parents optional number in college adjust | |
| IM_P_OPT_CONT_FOR_STU_AMT | NUMBER | (5) | Contains the parents optional contribution for student | |
| IM_P_OPT_CONT_FROM_INCOME_AMT | NUMBER | (6) | Contains the parents optional contribution from income | |
| IM_P_OPT_CONT_FROM_ASSETS_AMT | NUMBER | (6) | Contains the parents optional contribution from assets | |
| FM_P_ANALYSIS_TYPE | VARCHAR2 | (1) | Contains the parents analysis type | |
| FM_P_AGI_TAXABLE_INCOME_AMT | NUMBER | (7) | Contains the parents adjust gross income taxable | |
| FM_P_UNTX_INC_AND_BEN_AMT | NUMBER | (7) | Contains the parents untaxed income and benefits | |
| FM_P_INC_ADJ_AMT | NUMBER | (6) | Holds the Parents income adjust | |
| FM_P_TOTAL_INCOME_AMT | NUMBER | (8) | Contains the parents total income | |
| FM_P_US_INCOME_TAX_AMT | NUMBER | (6) | Contains the parents US income tax | |
| FM_P_STATE_AND_OTHER_TAX_AMT | NUMBER | (5) | Contains the parents state and other taxes | |
| FM_P_FICA_TAX_AMT | NUMBER | (5) | Contains the parents FICA tax | |
| FM_P_EMPLOYMENT_ALLOW_AMT | NUMBER | (4) | Contains the parents employment allowance | |
| FM_P_INCOME_PROT_ALLOW_AMT | NUMBER | (5) | Contains the parents income protection allowance | |
| FM_P_TOTAL_ALLOW_AMT | NUMBER | (6) | Contains the parents total allowance | |
| FM_P_AVAIL_INCOME_AMT | NUMBER | (9) | Contains the parents total allowance | |
| FM_P_CASH_BANK_ACCOUNTS_AMT | NUMBER | (6) | Contains the parents cash bank accounts | |
| FM_P_OT_RL_EST_INV_EQ_AMT | NUMBER | (8) | Contains the parents other real estate investment equity | |
| FM_P_ADJ_FARM_NET_WORTH_AMT | NUMBER | (8) | Contains the parents adjust business farm net worth | |
| FM_P_NET_WORTH_AMT | NUMBER | (8) | Contains the parents net worth | |
| FM_P_ASSET_PROT_ALLOW_AMT | NUMBER | (5) | Contains the parents asset protection allowance | |
| FM_P_DISC_NET_WORTH_AMT | NUMBER | (9) | Contains the parents discretionary net worth | |
| FM_P_TOTAL_CONTRIBUTION_AMT | NUMBER | (7) | Contains the parents total contribution | |
| FM_P_NUM_IN_COLL_NUM | NUMBER | (1) | Contains the parents number in college | |
| FM_P_CONT_FOR_STU_AMT | NUMBER | (5) | Contains the parents contribution for student | |
| FM_P_CONT_FROM_INCOME_AMT | NUMBER | (6) | Holds the students contribution from income | |
| FM_P_CONT_FROM_ASSETS_AMT | NUMBER | (5) | Holds the parents contribution from assets | |
| IM_S_BAS_AGI_TAX_INCOME_AMT | NUMBER | (6) | Holds the students basic adjust gross income taxable | |
| IM_S_BAS_UNTX_INC_AND_BEN_AMT | NUMBER | (6) | Holds the students basic untaxed income and benefits | |
| IM_S_BAS_INC_ADJ_AMT | NUMBER | (6) | Holds the students basic income adjust | |
| IM_S_BAS_TOTAL_INCOME_AMT | NUMBER | (7) | Holds the students basic total income | |
| IM_S_BAS_US_INCOME_TAX_AMT | NUMBER | (5) | Holds the students basic US income tax | |
| IM_S_BAS_ST_AND_OTH_TAX_AMT | NUMBER | (5) | Holds the students basic state and other taxes | |
| IM_S_BAS_FICA_TAX_AMT | NUMBER | (5) | Holds the students basic FICA tax | |
| IM_S_BAS_MED_DENTAL_AMT | NUMBER | (5) | Holds the students basic medical or dental | |
| IM_S_BAS_EMPLOYMENT_ALLOW_AMT | NUMBER | (4) | Holds the students basic employment allowance | |
| IM_S_BAS_ANNUAL_ED_SAVINGS_AMT | NUMBER | (5) | Holds the students basic annual education savings | |
| IM_S_BAS_INC_PROT_ALLOW_M_AMT | NUMBER | (5) | Holds the students basic income protection allowance or MMA | |
| IM_S_BAS_TOTAL_INC_ALLOW_AMT | NUMBER | (6) | Holds the students basic total income allowance | |
| IM_S_BAS_CAL_AVAIL_INCOME_AMT | NUMBER | (8) | Holds the students basic calculated available income | |
| IM_S_BAS_AVAIL_INCOME_AMT | NUMBER | (7) | Holds the students basic available income | |
| IM_S_BAS_TOTAL_CONT_INC_AMT | NUMBER | (6) | Holds the students basic total contribution income | |
| IM_S_BAS_CASH_BANK_ACCOUNT_AMT | NUMBER | (6) | Holds the students basic cash bank accounts | |
| IM_S_BAS_HOME_EQUITY_AMT | NUMBER | (6) | Holds the students basic home equity | |
| IM_S_BAS_OT_RL_EST_INV_EQ_AMT | NUMBER | (7) | Holds the students basic or estimated investment equity | |
| IM_S_BAS_ADJ_FARM_WORTH_AMT | NUMBER | (7) | Holds the students basic adjust business farm worth | |
| IM_S_BAS_TRUSTS_AMT | NUMBER | (6) | Holds the students basic trusts | |
| IM_S_BAS_NET_WORTH_AMT | NUMBER | (8) | Holds the students basic net worth | |
| IM_S_BAS_EMERG_RES_ALLOW_AMT | NUMBER | (5) | Holds the students basic emergency residence allowance | |
| IM_S_BAS_CUM_ED_SAVINGS_AMT | NUMBER | (6) | Holds the students basic cumulative education savings | |
| IM_S_BAS_TOTAL_ASSET_ALLOW_AMT | NUMBER | (9) | Holds the students basic total asset allowance | |
| IM_S_BAS_DISC_NET_WORTH_AMT | NUMBER | (9) | Holds the students basic discretionary net worth | |
| IM_S_BAS_TOTAL_CONT_ASSET_AMT | NUMBER | (6) | Holds the students basic total contribution asset | |
| IM_S_BAS_TOTAL_CONT_AMT | NUMBER | (6) | Holds the students basic total contribution | |
| IM_S_BAS_NUM_IN_COLL_ADJ_AMT | NUMBER | (4) | Holds the students basic number in college adjust | |
| IM_S_BAS_CONT_FOR_STU_AMT | NUMBER | (5) | Holds the students basic contribution for student | |
| IM_S_BAS_CONT_FROM_INCOME_AMT | NUMBER | (6) | Holds the students basic contribution from income | |
| IM_S_BAS_CONT_FROM_ASSETS_AMT | NUMBER | (6) | Holds the students basic contribution from assets | |
| IM_S_EST_AGI_TAX_INCOME_AMT | NUMBER | (6) | Holds the students estimated adjust gross taxable income | |
| IM_S_EST_UNTX_INC_AND_BEN_AMT | NUMBER | (6) | Holds the students estimated untaxed income and benefits | |
| IM_S_EST_INC_ADJ_AMT | NUMBER | (6) | Holds the students estimated income adjust | |
| IM_S_EST_TOTAL_INCOME_AMT | NUMBER | (7) | Holds the students estimated total income | |
| IM_S_EST_US_INCOME_TAX_AMT | NUMBER | (5) | Holds the students estimated US income tax | |
| IM_S_EST_ST_AND_OTH_TAX_AMT | NUMBER | (5) | Holds the students estimated state and other taxes | |
| IM_S_EST_FICA_TAX_AMT | NUMBER | (5) | Holds the students estimated FICA tax | |
| IM_S_EST_MED_DENTAL_AMT | NUMBER | (5) | Holds the students estimated medical and dental | |
| IM_S_EST_EMPLOYMENT_ALLOW_AMT | NUMBER | (4) | Holds the students estimated employment allowance | |
| IM_S_EST_ANNUAL_ED_SAVINGS_AMT | NUMBER | (5) | Holds the students estimated annual education savings | |
| IM_S_EST_INC_PROT_ALLOW_M_AMT | NUMBER | (5) | Holds the students estimated income protection allowance or MMA | |
| IM_S_EST_TOTAL_INC_ALLOW_AMT | NUMBER | (6) | Holds the students estimated total income allowance | |
| IM_S_EST_CAL_AVAIL_INCOME_AMT | NUMBER | (8) | Holds the students estimated calculated available income | |
| IM_S_EST_AVAIL_INCOME_AMT | NUMBER | (7) | Holds the students estimated available income | |
| IM_S_EST_TOTAL_CONT_INC_AMT | NUMBER | (6) | Holds the students estimated total contribution income | |
| IM_S_EST_CASH_BANK_ACCOUNT_AMT | NUMBER | (6) | Holds the students estimated cash bank accounts | |
| IM_S_EST_HOME_EQUITY_AMT | NUMBER | (6) | Holds the students estimated home equity | |
| IM_S_EST_OT_RL_EST_INV_EQU_AMT | NUMBER | (7) | Holds the students estimated other real estate investment equity | |
| IM_S_EST_ADJ_FARM_WORTH_AMT | NUMBER | (7) | Holds the students estimated adjust business farm worth | |
| IM_S_EST_EST_TRUSTS_AMT | NUMBER | (6) | Holds the students estimated trusts | |
| IM_S_EST_NET_WORTH_AMT | NUMBER | (8) | Holds the students estimated net worth | |
| IM_S_EST_EMERG_RES_ALLOW_AMT | NUMBER | (5) | Holds the students estimated emergency residence allowance | |
| IM_S_EST_CUM_ED_SAVINGS_AMT | NUMBER | (6) | Holds the students estimated cumulative education savings | |
| IM_S_EST_TOTAL_ASSET_ALLOW_AMT | NUMBER | (9) | Holds the students estimated total asset allowance | |
| IM_S_EST_DISC_NET_WORTH_AMT | NUMBER | (9) | Holds the students estimated discretionary net worth | |
| IM_S_EST_TOTAL_CONT_ASSET_AMT | NUMBER | (6) | Holds the students estimated total contribution asset | |
| IM_S_EST_TOTAL_CONT_AMT | NUMBER | (6) | Holds the students estimated total contribution | |
| IM_S_EST_NUM_IN_COLL_ADJ_AMT | NUMBER | (4) | students estimated number in college adjust | |
| IM_S_EST_CONT_FOR_STU_AMT | NUMBER | (5) | Holds the students estimated contribution for student | |
| IM_S_EST_CONT_FROM_INCOME_AMT | NUMBER | (6) | Holds the students estimated contribution from income | |
| IM_S_EST_CONT_FROM_ASSETS_AMT | NUMBER | (6) | Holds the students estimated contribution from assets | |
| IM_S_OPT_AGI_TAX_INCOME_AMT | NUMBER | (6) | Holds the students optional adjust gross taxable income | |
| IM_S_OPT_UNTX_INC_AND_BEN_AMT | NUMBER | (6) | students optional untaxed income and benefits | |
| IM_S_OPT_INC_ADJ_AMT | NUMBER | (6) | Holds the students optional income adjust | |
| IM_S_OPT_TOTAL_INCOME_AMT | NUMBER | (7) | Holds the students optional total income | |
| IM_S_OPT_US_INCOME_TAX_AMT | NUMBER | (5) | Holds the students optional US income tax | |
| IM_S_OPT_STATE_OTH_TAXES_AMT | NUMBER | (5) | Holds the students optional state and other taxes | |
| IM_S_OPT_FICA_TAX_AMT | NUMBER | (5) | Holds the students optional FICA tax | |
| IM_S_OPT_MED_DENTAL_AMT | NUMBER | (5) | Holds the students optional medical or dental | |
| IM_S_OPT_EMPLOYMENT_ALLOW_AMT | NUMBER | (4) | Holds the students optional employment allowance | |
| IM_S_OPT_ANNUAL_ED_SAVINGS_AMT | NUMBER | (5) | Holds the students optional annual education savings | |
| IM_S_OPT_INC_PROT_ALLOW_M_AMT | NUMBER | (5) | Holds the students optional income protection allowance or MMA | |
| IM_S_OPT_TOTAL_INC_ALLOW_AMT | NUMBER | (6) | Holds the students optional total income allow | |
| IM_S_OPT_CAL_AVAIL_INCOME_AMT | NUMBER | (8) | Holds the students optional calculated available income | |
| IM_S_OPT_AVAIL_INCOME_AMT | NUMBER | (7) | Holds the students optional available income | |
| IM_S_OPT_TOTAL_CONT_INC_AMT | NUMBER | (6) | Holds the students optional total contribution income | |
| IM_S_OPT_CASH_BANK_ACCOUNT_AMT | NUMBER | (6) | Holds the students optional cash bank accounts | |
| IM_S_OPT_IRA_KEOGH_ACCOUNT_AMT | NUMBER | (6) | Holds the students optional IRA KEOGH accounts | |
| IM_S_OPT_HOME_EQUITY_AMT | NUMBER | (6) | Holds the students optional home equity | |
| IM_S_OPT_OT_RL_EST_INV_EQ_AMT | NUMBER | (7) | Holds the students optional other real estate investment equity | |
| IM_S_OPT_ADJ_BUS_FRM_WORTH_AMT | NUMBER | (7) | Holds the students optional adjust business farm worth | |
| IM_S_OPT_TRUSTS_AMT | NUMBER | (6) | Holds the students optional trusts | |
| IM_S_OPT_NET_WORTH_AMT | NUMBER | (8) | Holds the students optional net worth | |
| IM_S_OPT_EMERG_RES_ALLOW_AMT | NUMBER | (5) | Holds the students optional emergency residence allowance | |
| IM_S_OPT_CUM_ED_SAVINGS_AMT | NUMBER | (6) | Holds the student optional cumulative education savings | |
| IM_S_OPT_TOTAL_ASSET_ALLOW_AMT | NUMBER | (9) | Holds the students optional total asset allowance | |
| IM_S_OPT_DISC_NET_WORTH_AMT | NUMBER | (9) | Holds the students estimated discretionary net worth | |
| IM_S_OPT_TOTAL_CONT_ASSET_AMT | NUMBER | (6) | Holds the students optional total contribution asset | |
| IM_S_OPT_TOTAL_CONT_AMT | NUMBER | (6) | Holds the students optional total contribution | |
| IM_S_OPT_NUM_IN_COLL_ADJ_AMT | NUMBER | (4) | Holds the students optional number in college adjust | |
| IM_S_OPT_CONT_FOR_STU_AMT | NUMBER | (5) | Holds the students optional contribution for student | |
| IM_S_OPT_CONT_FROM_INCOME_AMT | NUMBER | (6) | Holds the students optional contribution from income | |
| IM_S_OPT_CONT_FROM_ASSETS_AMT | NUMBER | (6) | Holds the students optional contribution from assets | |
| FM_S_ANALYSIS_TYPE | VARCHAR2 | (1) | Holds the analysis type | |
| FM_S_AGI_TAXABLE_INCOME_AMT | NUMBER | (6) | Holds the students adjust gross income taxable | |
| FM_S_UNTX_INC_AND_BEN_AMT | NUMBER | (6) | Holds the students untaxed income and benefits | |
| FM_S_INC_ADJ_AMT | NUMBER | (6) | Holds the students income adjust | |
| FM_S_TOTAL_INCOME_AMT | NUMBER | (7) | Holds the students total income | |
| FM_S_US_INCOME_TAX_AMT | NUMBER | (5) | Holds the students US income tax | |
| FM_S_STATE_AND_OTH_TAXES_AMT | NUMBER | (5) | Holds the students state and other taxes | |
| FM_S_FICA_TAX_AMT | NUMBER | (5) | Holds the students FICA tax | |
| FM_S_EMPLOYMENT_ALLOW_AMT | NUMBER | (4) | Holds the students employment allowance | |
| FM_S_INCOME_PROT_ALLOW_AMT | NUMBER | (5) | Holds the students income protection allowance | |
| FM_S_TOTAL_ALLOW_AMT | NUMBER | (6) | Holds the students total allowance | |
| FM_S_CAL_AVAIL_INCOME_AMT | NUMBER | (8) | Holds the students calculated available income | |
| FM_S_AVAIL_INCOME_AMT | NUMBER | (8) | Holds the students available income | |
| FM_S_CASH_BANK_ACCOUNTS_AMT | NUMBER | (6) | Holds the students cash bank accounts | |
| FM_S_OT_RL_EST_INV_EQUITY_AMT | NUMBER | (7) | Holds the students other real estate investment equity | |
| FM_S_ADJ_BUS_FARM_WORTH_AMT | NUMBER | (7) | Describes the Students net worth from adjust business farm | |
| FM_S_TRUSTS_AMT | NUMBER | (6) | Holds the students trusts | |
| FM_S_NET_WORTH_AMT | NUMBER | (8) | Holds the students net worth | |
| FM_S_ASSET_PROT_ALLOW_AMT | NUMBER | (5) | Holds the students asset protection allowance | |
| FM_S_DISC_NET_WORTH_AMT | NUMBER | (9) | Holds the students discretionary net worth | |
| FM_S_TOTAL_CONT_AMT | NUMBER | (5) | Holds the students total contribution | |
| FM_S_NUM_IN_COLL_NUM | NUMBER | (1) | Holds the students number in college | |
| FM_S_CONT_FOR_STU_AMT | NUMBER | (5) | Holds the students contribution for student | |
| FM_S_CONT_FROM_INCOME_AMT | NUMBER | (6) | Holds the students contribution from income | |
| FM_S_CONT_FROM_ASSETS_AMT | NUMBER | (5) | Holds the students contribution from assets | |
| IM_INST_RESIDENT_FLAG | VARCHAR2 | (1) | Describes the institutional resident indicator | |
| INSTITUTIONAL_1_BUDGET_NAME | VARCHAR2 | (7) | Describes the institutional budget name | |
| IM_INST_1_BUDGET_DURATION_NUM | NUMBER | (2) | Describes the institutional budget duration | |
| IM_INST_1_TUITION_FEES_AMT | NUMBER | (5) | Describes the institutional tuition fees | |
| IM_INST_1_BOOKS_SUPPLIES_AMT | NUMBER | (5) | Describes the institutional books supplies | |
| IM_INST_1_LIVING_EXPENSES_AMT | NUMBER | (5) | Describes the institutional living expenses | |
| IM_INST_1_TOT_EXPENSES_AMT | NUMBER | (5) | Describes the institutional total expenses | |
| IM_INST_1_TOT_STU_CONT_AMT | NUMBER | (5) | Describes the institutional total student contribution | |
| IM_INST_1_TOT_PAR_CONT_AMT | NUMBER | (5) | Describes the institutional total parent contribution | |
| IM_INST_1_TOT_FAMILY_CONT_AMT | NUMBER | (5) | Describes the institutional total family contribution | |
| IM_INST_1_VA_BENEFITS_AMT | NUMBER | (5) | Describes the institutional veteran benefits | |
| IM_INST_1_OT_CONT_AMT | NUMBER | (5) | Describes the institutional other contribution | |
| IM_INST_1_EST_FINAN_NEED_AMT | NUMBER | (5) | Describes the institutional estimated financial need | |
| INSTITUTIONAL_2_BUDGET_TXT | VARCHAR2 | (7) | Describes the institutional budget name | |
| IM_INST_2_BUDGET_DURATION_NUM | NUMBER | (2) | Describes the institutional budget duration | |
| IM_INST_2_TUITION_FEES_AMT | NUMBER | (5) | Describes the institutional tuition fees | |
| IM_INST_2_BOOKS_SUPPLIES_AMT | NUMBER | (5) | Describes the institutional books supplies | |
| IM_INST_2_LIVING_EXPENSES_AMT | NUMBER | (5) | Describes the institutional living expenses | |
| IM_INST_2_TOT_EXPENSES_AMT | NUMBER | (5) | Describes the institutional total expenses | |
| IM_INST_2_TOT_STU_CONT_AMT | NUMBER | (5) | Describes the institutional total student contribution | |
| IM_INST_2_TOT_PAR_CONT_AMT | NUMBER | (5) | Describes the institutional total parent contribution | |
| IM_INST_2_TOT_FAMILY_CONT_AMT | NUMBER | (5) | Describes the institutional total family contribution | |
| IM_INST_2_VA_BENEFITS_AMT | NUMBER | (5) | Describes the institutional veteran benefits | |
| IM_INST_2_EST_FINAN_NEED_AMT | NUMBER | (5) | Describes the institutional estimated financial need | |
| INSTITUTIONAL_3_BUDGET_TXT | VARCHAR2 | (7) | Describes the institutional budget name | |
| IM_INST_3_BUDGET_DURATION_NUM | NUMBER | (2) | Describes the institutional budget duration | |
| IM_INST_3_TUITION_FEES_AMT | NUMBER | (5) | Describes the institutional tuition fees | |
| IM_INST_3_BOOKS_SUPPLIES_AMT | NUMBER | (5) | Describes the institutional books supplies | |
| IM_INST_3_LIVING_EXPENSES_AMT | NUMBER | (5) | Describes the institutional living expenses | |
| IM_INST_3_TOT_EXPENSES_AMT | NUMBER | (5) | Describes the institutional total expenses | |
| IM_INST_3_TOT_STU_CONT_AMT | NUMBER | (5) | Describes the institutional total parent contribution | |
| IM_INST_3_TOT_PAR_CONT_AMT | NUMBER | (5) | Describes the institutional parent contribution | |
| IM_INST_3_TOT_FAMILY_CONT_AMT | NUMBER | (5) | Describes the institutional total family contribution | |
| IM_INST_3_VA_BENEFITS_AMT | NUMBER | (5) | Describes the institutional veteran benefits | |
| IM_INST_3_EST_FINAN_NEED_AMT | NUMBER | (5) | Describes the institutional estimated financial need | |
| FM_INST_1_FEDERAL_EFC_TXT | VARCHAR2 | (5) | Institutional federal effective family contribution | |
| FM_INST_1_VA_BENEFITS_TXT | VARCHAR2 | (5) | Describes the institutional veteran benefits | |
| FM_INST_1_FED_ELIGIBILITY_TXT | VARCHAR2 | (5) | Describes the institutional federal eligibility | |
| FM_INST_1_PELL_TXT | VARCHAR2 | (4) | Holds the institution Pell | |
| OPTION_PAR_LOSS_ALLOW_FLAG | VARCHAR2 | (1) | Holds the option parent loss allowance indicator | |
| OPTION_PAR_TUITION_FLAG | VARCHAR2 | (1) | Holds the option parent tuition indicator | |
| OPTION_PAR_HOME_TYPE | VARCHAR2 | (1) | Holds the option parent home indicator | |
| OPTION_PAR_HOME_VALUE_TXT | VARCHAR2 | (7) | Holds the option parent home value | |
| OPTION_PAR_HOME_DEBT_TXT | VARCHAR2 | (7) | Holds the option parent home debt | |
| OPTION_STU_IRA_KEOGH_FLAG | VARCHAR2 | (1) | Holds the option student IRA KEOGH indicator | |
| OPTION_STU_HOME_TYPE | VARCHAR2 | (1) | Holds the option student home indicator | |
| OPTION_STU_HOME_VALUE_TXT | VARCHAR2 | (6) | Holds the optional student home value | |
| OPTION_STU_HOME_DEBT_TXT | VARCHAR2 | (6) | Holds the option student home debt | |
| OPTION_STU_SUM_AY_INC_FLAG | VARCHAR2 | (1) | Holds the option student summer award year income indicator | |
| OPTION_PAR_HOPE_LL_CREDIT_FLAG | VARCHAR2 | (1) | Holds the option parents hope LL credit | |
| OPTION_STU_HOPE_LL_CREDIT_FLAG | VARCHAR2 | (1) | Holds the option student hope LL credit | |
| IM_PARENT_1_8_MONTHS_BAS_TXT | VARCHAR2 | (5) | Parent 1 to 8 months basic year | |
| IM_P_MORE_THAN_9_MTH_BA_TXT | VARCHAR2 | (5) | Parent more than 9 month basic year | |
| IM_PARENT_1_8_MONTHS_OPT_TXT | VARCHAR2 | (5) | Parent 1 to 8 months optional | |
| IM_P_MORE_THAN_9_MTH_OP_TXT | VARCHAR2 | (5) | Parent more than 9 month optional | |
| FNAR_MESSAGE_1_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_2_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_3_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_4_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_5_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_6_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_7_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_8_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_9_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_10_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_11_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_12_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_13_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_20_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_21_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_22_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_23_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_24_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_25_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_26_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_27_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_30_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_31_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_32_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_33_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_34_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_35_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_36_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_37_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_38_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_39_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_45_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_46_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_47_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_48_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_50_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_51_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_52_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_53_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_56_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_57_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_58_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_59_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_60_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_61_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_62_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_63_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_64_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_65_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_71_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_72_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_73_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_74_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_75_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_76_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_77_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESSAGE_78_FLAG | VARCHAR2 | (1) | Holds the FNAR message | |
| FNAR_MESG_10_STU_FAM_MEM_NUM | NUMBER | (2) | Holds the FNAR message student family members | |
| FNAR_MESG_11_STU_NO_IN_COL_NUM | NUMBER | (1) | Holds the FNAR message student number in college | |
| FNAR_MESG_24_STU_AVAIL_INC_AMT | NUMBER | (7) | Holds the FNAR message student available income | |
| FNAR_MESG_26_STU_TAXES_AMT | NUMBER | (6) | Holds the FNAR message student taxes | |
| FNAR_MESG_33_STU_HOME_VAL_AMT | NUMBER | (6) | Holds the FNAR message student home value | |
| FNAR_MESG_34_STU_HOME_VAL_AMT | NUMBER | (6) | Holds the FANR message student home value | |
| FNAR_MESG_34_STU_HOME_EQU_AMT | NUMBER | (6) | Holds the FNAR message student home equity | |
| FNAR_MESG_35_STU_HOME_VAL_AMT | NUMBER | (6) | Holds the FNAR message student home value | |
| FNAR_MESG_35_STU_HOME_EQU_AMT | NUMBER | (6) | Holds the FNAR message student home equity | |
| FNAR_MESG_36_STU_HOME_EQU_AMT | NUMBER | (6) | Holds the FNAR message student home equity | |
| FNAR_MESG_48_PAR_FAM_MEM_NUM | NUMBER | (2) | Holds the FNAR message parent family member | |
| FNAR_MESG_49_PAR_NO_IN_COL_NUM | NUMBER | (1) | Holds the FNAR message parent number in college | |
| FNAR_MESG_56_PAR_AGI_AMT | NUMBER | (8) | Holds the FNAR message parent adjust gross income | |
| FNAR_MESG_62_PAR_TAXES_AMT | NUMBER | (7) | Holds the FNAR message parent taxes | |
| FNAR_MESG_73_PAR_HOME_VAL_AMT | NUMBER | (7) | Holds the FNAR message parent home value | |
| FNAR_MESG_74_PAR_HOME_VAL_AMT | NUMBER | (7) | Holds the FNAR message parent home value | |
| FNAR_MESG_74_PAR_HOME_EQU_AMT | NUMBER | (7) | Holds the FNAR message parent home equity | |
| FNAR_MESG_75_PAR_HOME_VAL_AMT | NUMBER | (7) | Holds the FNAR message parent home value | |
| FNAR_MESG_75_PAR_HOME_EQU_AMT | NUMBER | (7) | Holds the FNAR message parent home equity | |
| FNAR_MESG_76_PAR_HOME_EQU_AMT | NUMBER | (7) | Holds the FNAR message parent home equity | |
| ASSUMPTION_MESSAGE_1_FLAG | VARCHAR2 | (1) | Holds the assumption message | |
| ASSUMPTION_MESSAGE_2_FLAG | VARCHAR2 | (1) | Holds the assumption message | |
| ASSUMPTION_MESSAGE_3_FLAG | VARCHAR2 | (1) | Holds the assumption message | |
| ASSUMPTION_MESSAGE_4_FLAG | VARCHAR2 | (1) | Holds the assumption message | |
| ASSUMPTION_MESSAGE_5_FLAG | VARCHAR2 | (1) | Holds the assumption message | |
| ASSUMPTION_MESSAGE_6_FLAG | VARCHAR2 | (1) | Holds the assumption message | |
| OPTION_PAR_COLA_ADJ_FLAG | VARCHAR2 | (1) | Holds the option parent Cost of Living Adjustment Indicator | |
| OPTION_PAR_STU_FA_ASSETS_FLAG | VARCHAR2 | (1) | Holds the option student Assets treated as Parents Asset Indicator | |
| OPTION_PAR_IPT_ASSETS_FLAG | VARCHAR2 | (1) | Holds the option parent Assets from Interest and Dividend Income Indicator | |
| OPTION_STU_IPT_ASSETS_FLAG | VARCHAR2 | (1) | Holds the option student Assets from Interest and Dividend Income Indicator | |
| OPTION_PAR_COLA_ADJ_VALUE | VARCHAR2 | (5) | Holds the option parent Adjustment factor used to modify IPA and ERS | |
| FNAR_MESSAGE_49_FLAG | VARCHAR2 | (1) | Holds the FNAR message 49 | |
| FNAR_MESSAGE_55_FLAG | VARCHAR2 | (1) | Holds the FNAR message 55 | |
| CREATED_BY | NUMBER | (15) | Standard who column | |
| CREATION_DATE | DATE | Standard who column | ||
| LAST_UPDATED_BY | NUMBER | (15) | Standard who column | |
| LAST_UPDATE_DATE | DATE | Standard who column | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | Standard who column | |
| REQUEST_ID | NUMBER | (15) | Standard who column | |
| PROGRAM_ID | NUMBER | (15) | Standard who column | |
| PROGRAM_APPLICATION_ID | NUMBER | (15) | Standard who column | |
| PROGRAM_UPDATE_DATE | DATE | Standard who column | ||
| IMPORT_STATUS_TYPE | VARCHAR2 | (1) | Yes | Record's Import status |
| P_SOC_SEC_BEN_STUDENT_AMT | NUMBER | (6) | Social security benefits - Student Amount | |
| P_TUIT_FEE_DEDUCT_AMT | NUMBER | (6) | Tuition and Fees deduction amount | |
| OPTION_IND_STU_IPT_ASSETS_FLAG | VARCHAR2 | (1) | Independent student assets from interest and dividend income indicator | |
| STU_LIVES_WITH_NUM | NUMBER | Student Lives With | ||
| STU_MOST_SUPPORT_FROM_NUM | NUMBER | Student Received Most Support From | ||
| LOCATION_COMPUTER_NUM | NUMBER | (22) | Computer Location | |
| 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 BATCH_NUM
, CSSINT_ID
, PERSON_NUMBER
, COLLEGE_CD
, ACADEMIC_YEAR_TXT
, STU_RECORD_TYPE
, CSS_ID_NUMBER_TXT
, REGISTRATION_RECEIPT_DATE
, REGISTRATION_TYPE
, APPLICATION_RECEIPT_DATE
, APPLICATION_TYPE
, ORIGINAL_FNAR_COMPUTE_TXT
, REVISION_FNAR_COMPUTE_DATE
, ELECTRONIC_EXTRACT_DATE
, INSTIT_REPORTING_TYPE
, ASR_RECEIPT_DATE
, LAST_NAME
, FIRST_NAME
, MIDDLE_INITIAL_TXT
, ADDRESS_NUMBER_AND_STREET_TXT
, CITY_TXT
, STATE_MAILING_TXT
, ZIP_CD
, S_TELEPHONE_NUMBER_TXT
, S_TITLE_TYPE
, BIRTH_DATE
, SOCIAL_SECURITY_NUM
, STATE_LEGAL_RESIDENCE_TXT
, FOREIGN_ADDRESS_FLAG
, FOREIGN_POSTAL_CD
, COUNTRY_CD
, FINANCIAL_AID_STATUS_TYPE
, YEAR_IN_COLLEGE_TYPE
, MARITAL_STATUS_FLAG
, WARD_COURT_FLAG
, LEGAL_DEPENDENTS_OTHER_FLAG
, HOUSEHOLD_SIZE_NUM
, NUMBER_IN_COLLEGE_NUM
, CITIZENSHIP_STATUS_TYPE
, CITIZENSHIP_COUNTRY_CD
, VISA_CLASSIFICATION_TYPE
, TAX_FIGURES_TYPE
, NUMBER_EXEMPTIONS_TXT
, ADJUSTED_GROSS_AMT
, US_TAX_PAID_AMT
, ITEMIZED_DEDUCTIONS_AMT
, STU_INCOME_WORK_AMT
, SPOUSE_INCOME_WORK_AMT
, DIVID_INT_INCOME_AMT
, SOC_SEC_BENEFITS_AMT
, WELFARE_TANF_AMT
, CHILD_SUPP_RCVD_AMT
, EARNED_INCOME_CREDIT_AMT
, OTHER_UNTAX_INCOME_AMT
, TAX_STU_AID_AMT
, CASH_SAV_CHECK_AMT
, IRA_KEOGH_AMT
, INVEST_VALUE_AMT
, INVEST_DEBT_AMT
, HOME_VALUE_AMT
, HOME_DEBT_AMT
, OTH_REAL_VALUE_AMT
, OTH_REAL_DEBT_AMT
, BUS_FARM_VALUE_AMT
, BUS_FARM_DEBT_AMT
, LIVE_ON_FARM_FLAG
, HOME_PURCH_PRICE_AMT
, HOPE_LL_CREDIT_AMT
, HOME_PURCH_YEAR_TXT
, TRUST_AMOUNT_TXT
, TRUST_AVAIL_FLAG
, TRUST_ESTAB_FLAG
, CHILD_SUPPORT_PAID_TXT
, MED_DENT_EXPENSES_TXT
, VET_US_FLAG
, VET_BEN_AMT
, VET_BEN_MONTHS_NUM
, STU_SUMMER_WAGES_AMT
, STU_SCHOOL_YR_WAGES_AMT
, SPOUSE_SUMMER_WAGES_AMT
, SPOUSE_SCHOOL_YR_WAGES_AMT
, SUMMER_OTHER_TAX_INC_AMT
, SCHOOL_YR_OTHER_TAX_INC_AMT
, SUMMER_UNTAX_INC_AMT
, SCHOOL_YR_UNTAX_INC_AMT
, GRANTS_SCHOL_ETC_AMT
, TUIT_BENEFITS_AMT
, CONT_PARENTS_AMT
, CONT_RELATIVES_AMT
, P_SIBLINGS_PRE_TUIT_AMT
, P_STUDENT_PRE_TUIT_AMT
, P_HOUSEHOLD_SIZE_NUM
, P_IN_COLLEGE_NUM
, P_PARENTS_IN_COLLEGE_NUM
, P_MARITAL_STATUS_TYPE
, P_STATE_LEGAL_RESIDENCE_CD
, P_NATURAL_PAR_STATUS_FLAG
, P_CHILD_SUPP_PAID_AMT
, P_REPAY_ED_LOANS_AMT
, P_MED_DENT_EXPENSES_AMT
, P_TUIT_PAID_AMT
, P_TUIT_PAID_NUM
, P_EXP_CHILD_SUPP_PAID_AMT
, P_EXP_REPAY_ED_LOANS_AMT
, P_EXP_MED_DENT_EXPENSES_AMT
, P_EXP_TUIT_PD_AMT
, P_EXP_TUIT_PD_NUM
, P_CASH_SAV_CHECK_AMT
, P_MONTH_MORTGAGE_PAY_AMT
, P_INVEST_VALUE_AMT
, P_INVEST_DEBT_AMT
, P_HOME_VALUE_AMT
, P_HOME_DEBT_AMT
, P_HOME_PURCH_PRICE_AMT
, P_OWN_BUSINESS_FARM_FLAG
, P_BUSINESS_VALUE_AMT
, P_BUSINESS_DEBT_AMT
, P_FARM_VALUE_AMT
, P_FARM_DEBT_AMT
, P_LIVE_ON_FARM_NUM
, P_OTH_REAL_ESTATE_VALUE_AMT
, P_OTH_REAL_ESTATE_DEBT_AMT
, P_OTH_REAL_PURCH_PRICE_AMT
, P_SIBLINGS_ASSETS_AMT
, P_HOME_PURCH_YEAR_TXT
, P_OTH_REAL_PURCH_YEAR_TXT
, P_PRIOR_AGI_AMT
, P_PRIOR_US_TAX_PAID_AMT
, P_PRIOR_ITEM_DEDUCTIONS_AMT
, P_PRIOR_OTHER_UNTAX_INC_AMT
, P_TAX_FIGURES_NUM
, P_NUMBER_EXEMPTIONS_NUM
, P_ADJUSTED_GROSS_INC_AMT
, P_WAGES_SAL_TIPS_AMT
, P_INTEREST_INCOME_AMT
, P_DIVIDEND_INCOME_AMT
, P_NET_INC_BUS_FARM_AMT
, P_OTHER_TAXABLE_INCOME_AMT
, P_ADJ_TO_INCOME_AMT
, P_US_TAX_PAID_AMT
, P_ITEMIZED_DEDUCTIONS_AMT
, P_FATHER_INCOME_WORK_AMT
, P_MOTHER_INCOME_WORK_AMT
, P_SOC_SEC_BEN_AMT
, P_WELFARE_TANF_AMT
, P_CHILD_SUPP_RCVD_AMT
, P_DED_IRA_KEOGH_AMT
, P_TAX_DEFER_PENS_SAVS_AMT
, P_DEP_CARE_MED_SPENDING_AMT
, P_EARNED_INCOME_CREDIT_AMT
, P_LIVING_ALLOW_AMT
, P_TAX_EXMPT_INT_AMT
, P_FOREIGN_INC_EXCL_AMT
, P_OTHER_UNTAX_INC_AMT
, P_HOPE_LL_CREDIT_AMT
, P_YR_SEPARATION_AMT
, P_YR_DIVORCE_AMT
, P_EXP_FATHER_INC_AMT
, P_EXP_MOTHER_INC_AMT
, P_EXP_OTHER_TAX_INC_AMT
, P_EXP_OTHER_UNTAX_INC_AMT
, LINE_2_RELATION_TYPE
, LINE_2_ATTEND_COLLEGE_TYPE
, LINE_3_RELATION_TYPE
, LINE_3_ATTEND_COLLEGE_TYPE
, LINE_4_RELATION_TYPE
, LINE_4_ATTEND_COLLEGE_TYPE
, LINE_5_RELATION_TYPE
, LINE_5_ATTEND_COLLEGE_TYPE
, LINE_6_RELATION_TYPE
, LINE_6_ATTEND_COLLEGE_TYPE
, LINE_7_RELATION_TYPE
, LINE_7_ATTEND_COLLEGE_TYPE
, LINE_8_RELATION_TYPE
, LINE_8_ATTEND_COLLEGE_TYPE
, P_AGE_FATHER_NUM
, P_AGE_MOTHER_NUM
, P_DIV_SEP_FLAG
, B_CONT_NON_CUSTODIAL_PAR_TXT
, COLLEGE_2_TYPE
, COLLEGE_3_TYPE
, COLLEGE_4_TYPE
, COLLEGE_5_TYPE
, COLLEGE_6_TYPE
, COLLEGE_7_TYPE
, COLLEGE_8_TYPE
, SCHOOL_1_CD
, HOUSING_1_TYPE
, SCHOOL_2_CD
, HOUSING_2_TYPE
, SCHOOL_3_CD
, HOUSING_3_TYPE
, SCHOOL_4_CD
, HOUSING_4_TYPE
, SCHOOL_5_CD
, HOUSING_5_TYPE
, SCHOOL_6_CD
, HOUSING_6_TYPE
, SCHOOL_7_CD
, HOUSING_7_TYPE
, SCHOOL_8_CD
, HOUSING_8_TYPE
, SCHOOL_9_CD
, HOUSING_9_TYPE
, SCHOOL_10_CD
, HOUSING_10_TYPE
, ADDITIONAL_SCHOOL_1_CD
, ADDITIONAL_SCHOOL_2_CD
, ADDITIONAL_SCHOOL_3_CD
, ADDITIONAL_SCHOOL_4_CD
, ADDITIONAL_SCHOOL_5_CD
, ADDITIONAL_SCHOOL_6_CD
, ADDITIONAL_SCHOOL_7_CD
, ADDITIONAL_SCHOOL_8_CD
, ADDITIONAL_SCHOOL_9_CD
, ADDITIONAL_SCHOOL_10_CD
, EXPLANATION_SPEC_CIRCUM_FLAG
, SIGNATURE_STUDENT_FLAG
, SIGNATURE_SPOUSE_FLAG
, SIGNATURE_FATHER_FLAG
, SIGNATURE_MOTHER_FLAG
, MONTH_DAY_COMPLETED
, YEAR_COMPLETED_FLAG
, AGE_LINE_2_NUM
, AGE_LINE_3_NUM
, AGE_LINE_4_NUM
, AGE_LINE_5_NUM
, AGE_LINE_6_NUM
, AGE_LINE_7_NUM
, AGE_LINE_8_NUM
, A_ONLINE_SIGNATURE_FLAG
, QUESTION_1_NUMBER_TXT
, QUESTION_1_SIZE_NUM
, QUESTION_1_ANSWER_TXT
, QUESTION_2_NUMBER_TXT
, QUESTION_2_SIZE_NUM
, QUESTION_2_ANSWER_TXT
, QUESTION_3_NUMBER_TXT
, QUESTION_3_SIZE_NUM
, QUESTION_3_ANSWER_TXT
, QUESTION_4_NUMBER_TXT
, QUESTION_4_SIZE_NUM
, QUESTION_4_ANSWER_TXT
, QUESTION_5_NUMBER_TXT
, QUESTION_5_SIZE_NUM
, QUESTION_5_ANSWER_TXT
, QUESTION_6_NUMBER_TXT
, QUESTION_6_SIZE_NUM
, QUESTION_6_ANSWER_TXT
, QUESTION_7_NUMBER_TXT
, QUESTION_7_SIZE_NUM
, QUESTION_7_ANSWER_TXT
, QUESTION_8_NUMBER_TXT
, QUESTION_8_SIZE_NUM
, QUESTION_8_ANSWER_TXT
, QUESTION_9_NUMBER_TXT
, QUESTION_9_SIZE_NUM
, QUESTION_9_ANSWER_TXT
, QUESTION_10_NUMBER_TXT
, QUESTION_10_SIZE_NUM
, QUESTION_10_ANSWER_TXT
, QUESTION_11_NUMBER_TXT
, QUESTION_11_SIZE_NUM
, QUESTION_11_ANSWER_TXT
, QUESTION_12_NUMBER_TXT
, QUESTION_12_SIZE_NUM
, QUESTION_12_ANSWER_TXT
, QUESTION_13_NUMBER_TXT
, QUESTION_13_SIZE_NUM
, QUESTION_13_ANSWER_TXT
, QUESTION_14_NUMBER_TXT
, QUESTION_14_SIZE_NUM
, QUESTION_14_ANSWER_TXT
, QUESTION_15_NUMBER_TXT
, QUESTION_15_SIZE_NUM
, QUESTION_15_ANSWER_TXT
, QUESTION_16_NUMBER_TXT
, QUESTION_16_SIZE_NUM
, QUESTION_16_ANSWER_TXT
, QUESTION_17_NUMBER_TXT
, QUESTION_17_SIZE_NUM
, QUESTION_17_ANSWER_TXT
, QUESTION_18_NUMBER_TXT
, QUESTION_18_SIZE_NUM
, QUESTION_18_ANSWER_TXT
, QUESTION_19_NUMBER_TXT
, QUESTION_19_SIZE_NUM
, QUESTION_19_ANSWER_TXT
, QUESTION_20_NUMBER_TXT
, QUESTION_20_SIZE_NUM
, QUESTION_20_ANSWER_TXT
, QUESTION_21_NUMBER_TXT
, QUESTION_21_SIZE_NUM
, QUESTION_21_ANSWER_TXT
, QUESTION_22_NUMBER_TXT
, QUESTION_22_SIZE_NUM
, QUESTION_22_ANSWER_TXT
, QUESTION_23_NUMBER_TXT
, QUESTION_23_SIZE_NUM
, QUESTION_23_ANSWER_TXT
, QUESTION_24_NUMBER_TXT
, QUESTION_24_SIZE_NUM
, QUESTION_24_ANSWER_TXT
, QUESTION_25_NUMBER_TXT
, QUESTION_25_SIZE_NUM
, QUESTION_25_ANSWER_TXT
, QUESTION_26_NUMBER_TXT
, QUESTION_26_SIZE_NUM
, QUESTION_26_ANSWER_TXT
, QUESTION_27_NUMBER_TXT
, QUESTION_27_SIZE_NUM
, QUESTION_27_ANSWER_TXT
, QUESTION_28_NUMBER_TXT
, QUESTION_28_SIZE_NUM
, QUESTION_28_ANSWER_TXT
, QUESTION_29_NUMBER_TXT
, QUESTION_29_SIZE_NUM
, QUESTION_29_ANSWER_TXT
, QUESTION_30_NUMBER_TXT
, QUESTIONS_30_SIZE_NUM
, QUESTION_30_ANSWER_TXT
, R_S_EMAIL_ADDRESS_TXT
, EPS_CD
, COMP_CSS_DEPENDCY_STATUS_TYPE
, STU_AGE_NUM
, ASSUMED_STU_YR_IN_COLL_TYPE
, COMP_STU_MARITAL_STATUS_TYPE
, STU_FAMILY_MEMBERS_NUM
, STU_FAM_MEMBERS_IN_COLLEGE_NUM
, PAR_MARITAL_STATUS_TYPE
, PAR_FAMILY_MEMBERS_NUM
, PAR_TOTAL_IN_COLLEGE_NUM
, PAR_PAR_IN_COLLEGE_NUM
, PAR_OTHERS_IN_COLLEGE_NUM
, PAR_AESA_NUM
, PAR_CESA_NUM
, STU_AESA_NUM
, STU_CESA_NUM
, IM_P_BAS_AGI_TAXABLE_AMT
, IM_P_BAS_UNTX_INC_AND_BEN_AMT
, IM_P_BAS_INC_ADJ_AMT
, IM_P_BAS_TOTAL_INCOME_AMT
, IM_P_BAS_US_INCOME_TAX_AMT
, IM_P_BAS_ST_AND_OTHER_TAX_AMT
, IM_P_BAS_FICA_TAX_AMT
, IM_P_BAS_MED_DENTAL_AMT
, IM_P_BAS_EMPLOYMENT_ALLOW_AMT
, IM_P_BAS_ANNUAL_ED_SAVINGS_AMT
, IM_P_BAS_INC_PROT_ALLOW_M_AMT
, IM_P_BAS_TOTAL_INC_ALLOW_AMT
, IM_P_BAS_CAL_AVAIL_INC_AMT
, IM_P_BAS_AVAIL_INCOME_AMT
, IM_P_BAS_TOTAL_CONT_INC_AMT
, IM_P_BAS_CASH_BANK_ACCOUNT_AMT
, IM_P_BAS_HOME_EQUITY_AMT
, IM_P_BAS_OT_RL_EST_INV_EQ_AMT
, IM_P_BAS_ADJ_BUS_FARM_WRTH_AMT
, IM_P_BAS_ASS_SIBS_PRE_TUI_AMT
, IM_P_BAS_NET_WORTH_AMT
, IM_P_BAS_EMERG_RES_ALLOW_AMT
, IM_P_BAS_CUM_ED_SAVINGS_AMT
, IM_P_BAS_LOW_INC_ALLOW_AMT
, IM_P_BAS_TOTAL_ASSET_ALLOW_AMT
, IM_P_BAS_DISC_NET_WORTH_AMT
, IM_P_BAS_TOTAL_CONT_ASSET_AMT
, IM_P_BAS_TOTAL_CONT_AMT
, IM_P_BAS_NUM_IN_COLL_ADJ_AMT
, IM_P_BAS_CONT_FOR_STU_AMT
, IM_P_BAS_CONT_FROM_INCOME_AMT
, IM_P_BAS_CONT_FROM_ASSETS_AMT
, IM_P_OPT_AGI_TAX_INCOME_AMT
, IM_P_OPT_UNTX_INC_BEN_AMT
, IM_P_OPT_INC_ADJ_AMT
, IM_P_OPT_TOTAL_INCOME_AMT
, IM_P_OPT_US_INCOME_TAX_AMT
, IM_P_OPT_ST_AND_OTHER_TAX_AMT
, IM_P_OPT_FICA_TAX_AMT
, IM_P_OPT_MED_DENTAL_AMT
, IM_P_OPT_ELEM_SEC_TUIT_AMT
, IM_P_OPT_EMPLOYMENT_ALLOW_AMT
, IM_P_OPT_ANNUAL_ED_SAVING_AMT
, IM_P_OPT_INC_PROT_ALLOW_M_AMT
, IM_P_OPT_TOTAL_INC_ALLOW_AMT
, IM_P_OPT_CAL_AVAIL_INC_AMT
, IM_P_OPT_AVAIL_INCOME_AMT
, IM_P_OPT_TOTAL_CONT_INC_AMT
, IM_P_OPT_CASH_BANK_ACCNT_AMT
, IM_P_OPT_HOME_EQUITY_AMT
, IM_P_OPT_OT_RL_EST_INV_EQ_AMT
, IM_P_OPT_ADJ_FARM_WORTH_AMT
, IM_P_OPT_ASS_SIBS_PRE_T_AMT
, IM_P_OPT_NET_WORTH_AMT
, IM_P_OPT_EMERG_RES_ALLOW_AMT
, IM_P_OPT_CUM_ED_SAVINGS_AMT
, IM_P_OPT_LOW_INC_ALLOW_AMT
, IM_P_OPT_TOTAL_ASSET_ALLOW_AMT
, IM_P_OPT_DISC_NET_WORTH_AMT
, IM_P_OPT_TOTAL_CONT_ASSET_AMT
, IM_P_OPT_TOTAL_CONT_AMT
, IM_P_OPT_NUM_IN_COLL_ADJ_AMT
, IM_P_OPT_CONT_FOR_STU_AMT
, IM_P_OPT_CONT_FROM_INCOME_AMT
, IM_P_OPT_CONT_FROM_ASSETS_AMT
, FM_P_ANALYSIS_TYPE
, FM_P_AGI_TAXABLE_INCOME_AMT
, FM_P_UNTX_INC_AND_BEN_AMT
, FM_P_INC_ADJ_AMT
, FM_P_TOTAL_INCOME_AMT
, FM_P_US_INCOME_TAX_AMT
, FM_P_STATE_AND_OTHER_TAX_AMT
, FM_P_FICA_TAX_AMT
, FM_P_EMPLOYMENT_ALLOW_AMT
, FM_P_INCOME_PROT_ALLOW_AMT
, FM_P_TOTAL_ALLOW_AMT
, FM_P_AVAIL_INCOME_AMT
, FM_P_CASH_BANK_ACCOUNTS_AMT
, FM_P_OT_RL_EST_INV_EQ_AMT
, FM_P_ADJ_FARM_NET_WORTH_AMT
, FM_P_NET_WORTH_AMT
, FM_P_ASSET_PROT_ALLOW_AMT
, FM_P_DISC_NET_WORTH_AMT
, FM_P_TOTAL_CONTRIBUTION_AMT
, FM_P_NUM_IN_COLL_NUM
, FM_P_CONT_FOR_STU_AMT
, FM_P_CONT_FROM_INCOME_AMT
, FM_P_CONT_FROM_ASSETS_AMT
, IM_S_BAS_AGI_TAX_INCOME_AMT
, IM_S_BAS_UNTX_INC_AND_BEN_AMT
, IM_S_BAS_INC_ADJ_AMT
, IM_S_BAS_TOTAL_INCOME_AMT
, IM_S_BAS_US_INCOME_TAX_AMT
, IM_S_BAS_ST_AND_OTH_TAX_AMT
, IM_S_BAS_FICA_TAX_AMT
, IM_S_BAS_MED_DENTAL_AMT
, IM_S_BAS_EMPLOYMENT_ALLOW_AMT
, IM_S_BAS_ANNUAL_ED_SAVINGS_AMT
, IM_S_BAS_INC_PROT_ALLOW_M_AMT
, IM_S_BAS_TOTAL_INC_ALLOW_AMT
, IM_S_BAS_CAL_AVAIL_INCOME_AMT
, IM_S_BAS_AVAIL_INCOME_AMT
, IM_S_BAS_TOTAL_CONT_INC_AMT
, IM_S_BAS_CASH_BANK_ACCOUNT_AMT
, IM_S_BAS_HOME_EQUITY_AMT
, IM_S_BAS_OT_RL_EST_INV_EQ_AMT
, IM_S_BAS_ADJ_FARM_WORTH_AMT
, IM_S_BAS_TRUSTS_AMT
, IM_S_BAS_NET_WORTH_AMT
, IM_S_BAS_EMERG_RES_ALLOW_AMT
, IM_S_BAS_CUM_ED_SAVINGS_AMT
, IM_S_BAS_TOTAL_ASSET_ALLOW_AMT
, IM_S_BAS_DISC_NET_WORTH_AMT
, IM_S_BAS_TOTAL_CONT_ASSET_AMT
, IM_S_BAS_TOTAL_CONT_AMT
, IM_S_BAS_NUM_IN_COLL_ADJ_AMT
, IM_S_BAS_CONT_FOR_STU_AMT
, IM_S_BAS_CONT_FROM_INCOME_AMT
, IM_S_BAS_CONT_FROM_ASSETS_AMT
, IM_S_EST_AGI_TAX_INCOME_AMT
, IM_S_EST_UNTX_INC_AND_BEN_AMT
, IM_S_EST_INC_ADJ_AMT
, IM_S_EST_TOTAL_INCOME_AMT
, IM_S_EST_US_INCOME_TAX_AMT
, IM_S_EST_ST_AND_OTH_TAX_AMT
, IM_S_EST_FICA_TAX_AMT
, IM_S_EST_MED_DENTAL_AMT
, IM_S_EST_EMPLOYMENT_ALLOW_AMT
, IM_S_EST_ANNUAL_ED_SAVINGS_AMT
, IM_S_EST_INC_PROT_ALLOW_M_AMT
, IM_S_EST_TOTAL_INC_ALLOW_AMT
, IM_S_EST_CAL_AVAIL_INCOME_AMT
, IM_S_EST_AVAIL_INCOME_AMT
, IM_S_EST_TOTAL_CONT_INC_AMT
, IM_S_EST_CASH_BANK_ACCOUNT_AMT
, IM_S_EST_HOME_EQUITY_AMT
, IM_S_EST_OT_RL_EST_INV_EQU_AMT
, IM_S_EST_ADJ_FARM_WORTH_AMT
, IM_S_EST_EST_TRUSTS_AMT
, IM_S_EST_NET_WORTH_AMT
, IM_S_EST_EMERG_RES_ALLOW_AMT
, IM_S_EST_CUM_ED_SAVINGS_AMT
, IM_S_EST_TOTAL_ASSET_ALLOW_AMT
, IM_S_EST_DISC_NET_WORTH_AMT
, IM_S_EST_TOTAL_CONT_ASSET_AMT
, IM_S_EST_TOTAL_CONT_AMT
, IM_S_EST_NUM_IN_COLL_ADJ_AMT
, IM_S_EST_CONT_FOR_STU_AMT
, IM_S_EST_CONT_FROM_INCOME_AMT
, IM_S_EST_CONT_FROM_ASSETS_AMT
, IM_S_OPT_AGI_TAX_INCOME_AMT
, IM_S_OPT_UNTX_INC_AND_BEN_AMT
, IM_S_OPT_INC_ADJ_AMT
, IM_S_OPT_TOTAL_INCOME_AMT
, IM_S_OPT_US_INCOME_TAX_AMT
, IM_S_OPT_STATE_OTH_TAXES_AMT
, IM_S_OPT_FICA_TAX_AMT
, IM_S_OPT_MED_DENTAL_AMT
, IM_S_OPT_EMPLOYMENT_ALLOW_AMT
, IM_S_OPT_ANNUAL_ED_SAVINGS_AMT
, IM_S_OPT_INC_PROT_ALLOW_M_AMT
, IM_S_OPT_TOTAL_INC_ALLOW_AMT
, IM_S_OPT_CAL_AVAIL_INCOME_AMT
, IM_S_OPT_AVAIL_INCOME_AMT
, IM_S_OPT_TOTAL_CONT_INC_AMT
, IM_S_OPT_CASH_BANK_ACCOUNT_AMT
, IM_S_OPT_IRA_KEOGH_ACCOUNT_AMT
, IM_S_OPT_HOME_EQUITY_AMT
, IM_S_OPT_OT_RL_EST_INV_EQ_AMT
, IM_S_OPT_ADJ_BUS_FRM_WORTH_AMT
, IM_S_OPT_TRUSTS_AMT
, IM_S_OPT_NET_WORTH_AMT
, IM_S_OPT_EMERG_RES_ALLOW_AMT
, IM_S_OPT_CUM_ED_SAVINGS_AMT
, IM_S_OPT_TOTAL_ASSET_ALLOW_AMT
, IM_S_OPT_DISC_NET_WORTH_AMT
, IM_S_OPT_TOTAL_CONT_ASSET_AMT
, IM_S_OPT_TOTAL_CONT_AMT
, IM_S_OPT_NUM_IN_COLL_ADJ_AMT
, IM_S_OPT_CONT_FOR_STU_AMT
, IM_S_OPT_CONT_FROM_INCOME_AMT
, IM_S_OPT_CONT_FROM_ASSETS_AMT
, FM_S_ANALYSIS_TYPE
, FM_S_AGI_TAXABLE_INCOME_AMT
, FM_S_UNTX_INC_AND_BEN_AMT
, FM_S_INC_ADJ_AMT
, FM_S_TOTAL_INCOME_AMT
, FM_S_US_INCOME_TAX_AMT
, FM_S_STATE_AND_OTH_TAXES_AMT
, FM_S_FICA_TAX_AMT
, FM_S_EMPLOYMENT_ALLOW_AMT
, FM_S_INCOME_PROT_ALLOW_AMT
, FM_S_TOTAL_ALLOW_AMT
, FM_S_CAL_AVAIL_INCOME_AMT
, FM_S_AVAIL_INCOME_AMT
, FM_S_CASH_BANK_ACCOUNTS_AMT
, FM_S_OT_RL_EST_INV_EQUITY_AMT
, FM_S_ADJ_BUS_FARM_WORTH_AMT
, FM_S_TRUSTS_AMT
, FM_S_NET_WORTH_AMT
, FM_S_ASSET_PROT_ALLOW_AMT
, FM_S_DISC_NET_WORTH_AMT
, FM_S_TOTAL_CONT_AMT
, FM_S_NUM_IN_COLL_NUM
, FM_S_CONT_FOR_STU_AMT
, FM_S_CONT_FROM_INCOME_AMT
, FM_S_CONT_FROM_ASSETS_AMT
, IM_INST_RESIDENT_FLAG
, INSTITUTIONAL_1_BUDGET_NAME
, IM_INST_1_BUDGET_DURATION_NUM
, IM_INST_1_TUITION_FEES_AMT
, IM_INST_1_BOOKS_SUPPLIES_AMT
, IM_INST_1_LIVING_EXPENSES_AMT
, IM_INST_1_TOT_EXPENSES_AMT
, IM_INST_1_TOT_STU_CONT_AMT
, IM_INST_1_TOT_PAR_CONT_AMT
, IM_INST_1_TOT_FAMILY_CONT_AMT
, IM_INST_1_VA_BENEFITS_AMT
, IM_INST_1_OT_CONT_AMT
, IM_INST_1_EST_FINAN_NEED_AMT
, INSTITUTIONAL_2_BUDGET_TXT
, IM_INST_2_BUDGET_DURATION_NUM
, IM_INST_2_TUITION_FEES_AMT
, IM_INST_2_BOOKS_SUPPLIES_AMT
, IM_INST_2_LIVING_EXPENSES_AMT
, IM_INST_2_TOT_EXPENSES_AMT
, IM_INST_2_TOT_STU_CONT_AMT
, IM_INST_2_TOT_PAR_CONT_AMT
, IM_INST_2_TOT_FAMILY_CONT_AMT
, IM_INST_2_VA_BENEFITS_AMT
, IM_INST_2_EST_FINAN_NEED_AMT
, INSTITUTIONAL_3_BUDGET_TXT
, IM_INST_3_BUDGET_DURATION_NUM
, IM_INST_3_TUITION_FEES_AMT
, IM_INST_3_BOOKS_SUPPLIES_AMT
, IM_INST_3_LIVING_EXPENSES_AMT
, IM_INST_3_TOT_EXPENSES_AMT
, IM_INST_3_TOT_STU_CONT_AMT
, IM_INST_3_TOT_PAR_CONT_AMT
, IM_INST_3_TOT_FAMILY_CONT_AMT
, IM_INST_3_VA_BENEFITS_AMT
, IM_INST_3_EST_FINAN_NEED_AMT
, FM_INST_1_FEDERAL_EFC_TXT
, FM_INST_1_VA_BENEFITS_TXT
, FM_INST_1_FED_ELIGIBILITY_TXT
, FM_INST_1_PELL_TXT
, OPTION_PAR_LOSS_ALLOW_FLAG
, OPTION_PAR_TUITION_FLAG
, OPTION_PAR_HOME_TYPE
, OPTION_PAR_HOME_VALUE_TXT
, OPTION_PAR_HOME_DEBT_TXT
, OPTION_STU_IRA_KEOGH_FLAG
, OPTION_STU_HOME_TYPE
, OPTION_STU_HOME_VALUE_TXT
, OPTION_STU_HOME_DEBT_TXT
, OPTION_STU_SUM_AY_INC_FLAG
, OPTION_PAR_HOPE_LL_CREDIT_FLAG
, OPTION_STU_HOPE_LL_CREDIT_FLAG
, IM_PARENT_1_8_MONTHS_BAS_TXT
, IM_P_MORE_THAN_9_MTH_BA_TXT
, IM_PARENT_1_8_MONTHS_OPT_TXT
, IM_P_MORE_THAN_9_MTH_OP_TXT
, FNAR_MESSAGE_1_FLAG
, FNAR_MESSAGE_2_FLAG
, FNAR_MESSAGE_3_FLAG
, FNAR_MESSAGE_4_FLAG
, FNAR_MESSAGE_5_FLAG
, FNAR_MESSAGE_6_FLAG
, FNAR_MESSAGE_7_FLAG
, FNAR_MESSAGE_8_FLAG
, FNAR_MESSAGE_9_FLAG
, FNAR_MESSAGE_10_FLAG
, FNAR_MESSAGE_11_FLAG
, FNAR_MESSAGE_12_FLAG
, FNAR_MESSAGE_13_FLAG
, FNAR_MESSAGE_20_FLAG
, FNAR_MESSAGE_21_FLAG
, FNAR_MESSAGE_22_FLAG
, FNAR_MESSAGE_23_FLAG
, FNAR_MESSAGE_24_FLAG
, FNAR_MESSAGE_25_FLAG
, FNAR_MESSAGE_26_FLAG
, FNAR_MESSAGE_27_FLAG
, FNAR_MESSAGE_30_FLAG
, FNAR_MESSAGE_31_FLAG
, FNAR_MESSAGE_32_FLAG
, FNAR_MESSAGE_33_FLAG
, FNAR_MESSAGE_34_FLAG
, FNAR_MESSAGE_35_FLAG
, FNAR_MESSAGE_36_FLAG
, FNAR_MESSAGE_37_FLAG
, FNAR_MESSAGE_38_FLAG
, FNAR_MESSAGE_39_FLAG
, FNAR_MESSAGE_45_FLAG
, FNAR_MESSAGE_46_FLAG
, FNAR_MESSAGE_47_FLAG
, FNAR_MESSAGE_48_FLAG
, FNAR_MESSAGE_50_FLAG
, FNAR_MESSAGE_51_FLAG
, FNAR_MESSAGE_52_FLAG
, FNAR_MESSAGE_53_FLAG
, FNAR_MESSAGE_56_FLAG
, FNAR_MESSAGE_57_FLAG
, FNAR_MESSAGE_58_FLAG
, FNAR_MESSAGE_59_FLAG
, FNAR_MESSAGE_60_FLAG
, FNAR_MESSAGE_61_FLAG
, FNAR_MESSAGE_62_FLAG
, FNAR_MESSAGE_63_FLAG
, FNAR_MESSAGE_64_FLAG
, FNAR_MESSAGE_65_FLAG
, FNAR_MESSAGE_71_FLAG
, FNAR_MESSAGE_72_FLAG
, FNAR_MESSAGE_73_FLAG
, FNAR_MESSAGE_74_FLAG
, FNAR_MESSAGE_75_FLAG
, FNAR_MESSAGE_76_FLAG
, FNAR_MESSAGE_77_FLAG
, FNAR_MESSAGE_78_FLAG
, FNAR_MESG_10_STU_FAM_MEM_NUM
, FNAR_MESG_11_STU_NO_IN_COL_NUM
, FNAR_MESG_24_STU_AVAIL_INC_AMT
, FNAR_MESG_26_STU_TAXES_AMT
, FNAR_MESG_33_STU_HOME_VAL_AMT
, FNAR_MESG_34_STU_HOME_VAL_AMT
, FNAR_MESG_34_STU_HOME_EQU_AMT
, FNAR_MESG_35_STU_HOME_VAL_AMT
, FNAR_MESG_35_STU_HOME_EQU_AMT
, FNAR_MESG_36_STU_HOME_EQU_AMT
, FNAR_MESG_48_PAR_FAM_MEM_NUM
, FNAR_MESG_49_PAR_NO_IN_COL_NUM
, FNAR_MESG_56_PAR_AGI_AMT
, FNAR_MESG_62_PAR_TAXES_AMT
, FNAR_MESG_73_PAR_HOME_VAL_AMT
, FNAR_MESG_74_PAR_HOME_VAL_AMT
, FNAR_MESG_74_PAR_HOME_EQU_AMT
, FNAR_MESG_75_PAR_HOME_VAL_AMT
, FNAR_MESG_75_PAR_HOME_EQU_AMT
, FNAR_MESG_76_PAR_HOME_EQU_AMT
, ASSUMPTION_MESSAGE_1_FLAG
, ASSUMPTION_MESSAGE_2_FLAG
, ASSUMPTION_MESSAGE_3_FLAG
, ASSUMPTION_MESSAGE_4_FLAG
, ASSUMPTION_MESSAGE_5_FLAG
, ASSUMPTION_MESSAGE_6_FLAG
, OPTION_PAR_COLA_ADJ_FLAG
, OPTION_PAR_STU_FA_ASSETS_FLAG
, OPTION_PAR_IPT_ASSETS_FLAG
, OPTION_STU_IPT_ASSETS_FLAG
, OPTION_PAR_COLA_ADJ_VALUE
, FNAR_MESSAGE_49_FLAG
, FNAR_MESSAGE_55_FLAG
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_UPDATE_DATE
, IMPORT_STATUS_TYPE
, P_SOC_SEC_BEN_STUDENT_AMT
, P_TUIT_FEE_DEDUCT_AMT
, OPTION_IND_STU_IPT_ASSETS_FLAG
, STU_LIVES_WITH_NUM
, STU_MOST_SUPPORT_FROM_NUM
, LOCATION_COMPUTER_NUM
, 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_LI_CSS_INTS;
IGF.IGF_AP_LI_CSS_INTS does not reference any database object
IGF.IGF_AP_LI_CSS_INTS is referenced by following:
APPS
IGF_AP_LI_CSS_INTS
|
|
|
|