[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGF_AP_CSS_INTERFACE_ALL |
|---|---|
| Object Type: | TABLE |
| Owner: | IGF |
| FND Design Data: |  IGF.IGF_AP_CSS_INTERFACE_ALL
|
| Subobject Name: | |
| Status: | VALID |
Interface Table for CSS profile records.The profile records will be loaded initially into this table and processed further.
| Tablespace: |  APPS_TS_TX_DATA |
|---|---|
| PCT Free: | 10 |
| PCT Used: |
| Index | Type | Uniqueness | Tablespace | Column |
|---|---|---|---|---|
| IGF_AP_CSS_INTERFACE_U1 | NORMAL | UNIQUE |
APPS_TS_TX_IDX
|
 CSS_ID
|
| IGF_AP_CSS_INTERFACE_N1 | NORMAL | NONUNIQUE |
APPS_TS_TX_IDX
|
ACADEMIC_YEAR
RECORD_STATUS
|
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| CSS_ID | NUMBER | (15) | Yes | Holds the Primary Key |
| ORG_ID | NUMBER | (15) | Org ID indicates the org unit this record belongs to | |
| RECORD_STATUS | VARCHAR2 | (30) | Yes | Holds the values 'NEW','MATCHED' or 'UNMATCHED' |
| COLLEGE_CODE | VARCHAR2 | (4) | College code of the college receiving this application | |
| ACADEMIC_YEAR | VARCHAR2 | (2) | Holds the year for which this record is valid | |
| STU_RECORD_TYPE | VARCHAR2 | (30) | Contains the type of student profile record | |
| CSS_ID_NUMBER | VARCHAR2 | (7) | Holds the Unique identifier for the CSS record | |
| REGISTRATION_RECEIPT_DATE | VARCHAR2 | (8) | Holds the date on which the registration was received | |
| REGISTRATION_TYPE | VARCHAR2 | (30) | Contains the type of registration | |
| APPLICATION_RECEIPT_DATE | VARCHAR2 | (8) | Date on which the application was received by the college board | |
| APPLICATION_TYPE | VARCHAR2 | (30) | Describes the type of application | |
| ORIGINAL_FNAR_COMPUTE | VARCHAR2 | (8) | Describes the computed Original FNAR | |
| REVISION_FNAR_COMPUTE_DATE | VARCHAR2 | (8) | Holds the Revision FNAR compute date | |
| ELECTRONIC_EXTRACT_DATE | VARCHAR2 | (8) | Holds the electronic extract date | |
| INSTITUTIONAL_REPORTING_TYPE | VARCHAR2 | (30) | Describes the institutional reporting type | |
| ASR_RECEIPT_DATE | VARCHAR2 | (8) | 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 | VARCHAR2 | (30) | Holds the middle initial of the student | |
| ADDRESS_NUMBER_AND_STREET | VARCHAR2 | (28) | Contains the street address of the student | |
| CITY | VARCHAR2 | (17) | Holds the students' city of residence | |
| STATE_MAILING | VARCHAR2 | (2) | Holds the state mailing address | |
| ZIP_CODE | VARCHAR2 | (5) | Holds the zip code | |
| S_TELEPHONE_NUMBER | VARCHAR2 | (10) | Holds the telephone number of the student | |
| S_TITLE | VARCHAR2 | (30) | Holds the title of the student | |
| DATE_OF_BIRTH | VARCHAR2 | (8) | Holds the students' Date of Birth | |
| SOCIAL_SECURITY_NUMBER | VARCHAR2 | (9) | Holds the students' Social Security Number | |
| STATE_LEGAL_RESIDENCE | VARCHAR2 | (2) | Holds the students' state of legal residence | |
| FOREIGN_ADDRESS_INDICATOR | VARCHAR2 | (30) | Indicates if a student has a foreign address | |
| FOREIGN_POSTAL_CODE | VARCHAR2 | (9) | Holds the students' foreign postal code | |
| COUNTRY | VARCHAR2 | (25) | Holds the students' country | |
| FINANCIAL_AID_STATUS | VARCHAR2 | (30) | Holds the student's financial aid status | |
| YEAR_IN_COLLEGE | VARCHAR2 | (30) | Holds the number of years spent in college by the student | |
| MARITAL_STATUS | VARCHAR2 | (30) | Holds the student's marital status | |
| WARD_COURT | VARCHAR2 | (30) | Indicates if the student is ward of count | |
| LEGAL_DEPENDENTS_OTHER | VARCHAR2 | (30) | Indicates if the student has other legal dependents. | |
| HOUSEHOLD_SIZE | VARCHAR2 | (2) | Holds the student's households size | |
| NUMBER_IN_COLLEGE | VARCHAR2 | (30) | Number of student's family members in college | |
| CITIZENSHIP_STATUS | VARCHAR2 | (30) | Holds the student's citizenship status | |
| CITIZENSHIP_COUNTRY | VARCHAR2 | (15) | Holds the student's citizenship country | |
| VISA_CLASSIFICATION | VARCHAR2 | (30) | Indicates the Visa classification for the student | |
| TAX_FIGURES | VARCHAR2 | (30) | Holds the tax figures of the student | |
| NUMBER_EXEMPTIONS | VARCHAR2 | (2) | Number of exemptions claimed by the student | |
| ADJUSTED_GROSS_INC | VARCHAR2 | (7) | Holds the student's adjusted gross income | |
| US_TAX_PAID | VARCHAR2 | (6) | Indicates the US tax paid by the student | |
| ITEMIZED_DEDUCTIONS | VARCHAR2 | (6) | Holds the student's itemized deductions | |
| STU_INCOME_WORK | VARCHAR2 | (7) | Holds the students income from work | |
| SPOUSE_INCOME_WORK | VARCHAR2 | (7) | Holds the student's spouse's income from work | |
| DIVID_INT_INC | VARCHAR2 | (6) | student's income from dividends and interest | |
| SOC_SEC_BENEFITS | VARCHAR2 | (6) | Holds the student's social security benefits | |
| WELFARE_TANF | VARCHAR2 | (6) | Indicates the welfare TANF gains for the student | |
| CHILD_SUPP_RCVD | VARCHAR2 | (6) | Holds the child support received by student | |
| EARNED_INCOME_CREDIT | VARCHAR2 | (6) | Holds the earned income credit of the student | |
| OTHER_UNTAX_INCOME | VARCHAR2 | (6) | Holds the other untaxed income of student | |
| TAX_STU_AID | VARCHAR2 | (6) | Holds the taxable aid received by the student | |
| CASH_SAV_CHECK | VARCHAR2 | (7) | Holds the cash saving or checking balance of the student | |
| IRA_KEOGH | VARCHAR2 | (7) | Holds the IRA KEOGH received by the student | |
| INVEST_VALUE | VARCHAR2 | (7) | Holds the student's investment value | |
| INVEST_DEBT | VARCHAR2 | (7) | Holds the student's investment debt | |
| HOME_VALUE | VARCHAR2 | (7) | Holds the student's home value | |
| HOME_DEBT | VARCHAR2 | (7) | Holds the student's home debt | |
| OTH_REAL_VALUE | VARCHAR2 | (7) | Holds the student's other real value | |
| OTH_REAL_DEBT | VARCHAR2 | (7) | Holds the student's other real debt | |
| BUS_FARM_VALUE | VARCHAR2 | (7) | Holds the student's business farm value | |
| BUS_FARM_DEBT | VARCHAR2 | (7) | Holds the student's business farm debt | |
| LIVE_ON_FARM | VARCHAR2 | (30) | Indicates if student lives on a farm | |
| HOME_PURCH_PRICE | VARCHAR2 | (7) | Holds the student's home purchase price | |
| HOPE_LL_CREDIT | VARCHAR2 | (6) | Holds the student's hope credit received | |
| HOME_PURCH_YEAR | VARCHAR2 | (4) | Indicates students home purchase year | |
| TRUST_AMOUNT | VARCHAR2 | (7) | Indicates the trust amount for the student | |
| TRUST_AVAIL | VARCHAR2 | (30) | Indicates if the trust is available for the student | |
| TRUST_ESTAB | VARCHAR2 | (30) | Indicates when the trust was established was established for the student | |
| CHILD_SUPPORT_PAID | VARCHAR2 | (6) | Indicates child support paid by the student | |
| MED_DENT_EXPENSES | VARCHAR2 | (6) | Holds the medical dental expenses of the student | |
| VET_US | VARCHAR2 | (30) | Indicates if the student is US Veteran | |
| VET_BEN_AMOUNT | VARCHAR2 | (4) | Holds the veteran benefit amount for the student | |
| VET_BEN_MONTHS | VARCHAR2 | (2) | Holds the veteran benefit months for the student | |
| STU_SUMMER_WAGES | VARCHAR2 | (6) | Holds summer wages of the student | |
| STU_SCHOOL_YR_WAGES | VARCHAR2 | (6) | Holds school year wages of the student | |
| SPOUSE_SUMMER_WAGES | VARCHAR2 | (6) | Holds students spouse summer wages | |
| SPOUSE_SCHOOL_YR_WAGES | VARCHAR2 | (6) | Holds students spouse school year wages | |
| SUMMER_OTHER_TAX_INC | VARCHAR2 | (6) | Holds other taxable income of the student during summer | |
| SCHOOL_YR_OTHER_TAX_INC | VARCHAR2 | (6) | Holds other taxable income of the student during school year | |
| SUMMER_UNTAX_INC | VARCHAR2 | (6) | Holds the untaxed income of the student during summer | |
| SCHOOL_YR_UNTAX_INC | VARCHAR2 | (6) | Holds untaxed income of the student during school year | |
| GRANTS_SCHOL_ETC | VARCHAR2 | (6) | Holds whether the grants are received from school for the student | |
| TUIT_BENEFITS | VARCHAR2 | (6) | Hold the tuition benefits for the student | |
| CONT_PARENTS | VARCHAR2 | (6) | Holds the contribution made by the parent of the student | |
| CONT_RELATIVES | VARCHAR2 | (6) | Holds the contribution made by the relatives of the student | |
| P_SIBLINGS_PRE_TUIT | VARCHAR2 | (8) | Holds parents siblings pre tuition | |
| P_STUDENT_PRE_TUIT | VARCHAR2 | (8) | Holds student pre tuition | |
| P_HOUSEHOLD_SIZE | VARCHAR2 | (2) | Holds parents household size | |
| P_NUMBER_IN_COLLEGE | VARCHAR2 | (30) | Holds parents number in college | |
| P_PARENTS_IN_COLLEGE | VARCHAR2 | (30) | Holds parents in college | |
| P_MARITAL_STATUS | VARCHAR2 | (30) | Holds parents marital status | |
| P_STATE_LEGAL_RESIDENCE | VARCHAR2 | (2) | Holds parents state legal residence | |
| P_NATURAL_PAR_STATUS | VARCHAR2 | (30) | Holds natural parents status | |
| P_CHILD_SUPP_PAID | VARCHAR2 | (6) | Holds parents child support paid | |
| P_REPAY_ED_LOANS | VARCHAR2 | (6) | Holds parents repay education loans | |
| P_MED_DENT_EXPENSES | VARCHAR2 | (6) | Holds parents medical and dental expenses | |
| P_TUIT_PAID_AMOUNT | VARCHAR2 | (6) | Holds parents tuition paid amount | |
| P_TUIT_PAID_NUMBER | VARCHAR2 | (30) | Holds parents tuition paid number | |
| P_EXP_CHILD_SUPP_PAID | VARCHAR2 | (6) | Holds parents expected child support paid | |
| P_EXP_REPAY_ED_LOANS | VARCHAR2 | (6) | Holds parents expected to repay education loans | |
| P_EXP_MED_DENT_EXPENSES | VARCHAR2 | (6) | Holds parents expected medical and dental expenses | |
| P_EXP_TUIT_PD_AMOUNT | VARCHAR2 | (6) | Holds parents expected tuition paid amount | |
| P_EXP_TUIT_PD_NUMBER | VARCHAR2 | (30) | Holds parents expected tuition paid number | |
| P_CASH_SAV_CHECK | VARCHAR2 | (7) | Holds parents cash save check | |
| P_MONTH_MORTGAGE_PAY | VARCHAR2 | (6) | Holds parents month mortgage pay | |
| P_INVEST_VALUE | VARCHAR2 | (8) | Holds parents invest value | |
| P_INVEST_DEBT | VARCHAR2 | (8) | Holds parents invest debt | |
| P_HOME_VALUE | VARCHAR2 | (8) | Holds parents home value | |
| P_HOME_DEBT | VARCHAR2 | (8) | Holds parents home debt | |
| P_HOME_PURCH_PRICE | VARCHAR2 | (8) | Holds parents home purchase price | |
| P_OWN_BUSINESS_FARM | VARCHAR2 | (30) | Holds parents own business farm | |
| P_BUSINESS_VALUE | VARCHAR2 | (8) | Holds parents business value | |
| P_BUSINESS_DEBT | VARCHAR2 | (8) | Holds parents business debt | |
| P_FARM_VALUE | VARCHAR2 | (8) | Holds parents farm value | |
| P_FARM_DEBT | VARCHAR2 | (8) | Holds parents farm debt | |
| P_LIVE_ON_FARM | VARCHAR2 | (30) | Holds parents live on farm | |
| P_OTH_REAL_ESTATE_VALUE | VARCHAR2 | (8) | Holds parents other real estate value | |
| P_OTH_REAL_ESTATE_DEBT | VARCHAR2 | (8) | Holds parents other real estate debt | |
| P_OTH_REAL_PURCH_PRICE | VARCHAR2 | (8) | Holds parents other real purchase price | |
| P_SIBLINGS_ASSETS | VARCHAR2 | (8) | Holds parents siblings assets | |
| P_HOME_PURCH_YEAR | VARCHAR2 | (4) | Holds parents home purchase year | |
| P_OTH_REAL_PURCH_YEAR | VARCHAR2 | (4) | Holds parents other real purchase year | |
| P_PRIOR_AGI | VARCHAR2 | (8) | Holds parents Actual Gross Income | |
| P_PRIOR_US_TAX_PAID | VARCHAR2 | (7) | Holds parents prior us tax paid | |
| P_PRIOR_ITEM_DEDUCTIONS | VARCHAR2 | (7) | Holds parents prior item deductions | |
| P_PRIOR_OTHER_UNTAX_INC | VARCHAR2 | (7) | Holds parents prior other untaxed income | |
| P_TAX_FIGURES | VARCHAR2 | (30) | Holds parents tax figures | |
| P_NUMBER_EXEMPTIONS | VARCHAR2 | (2) | Holds parents number exemptions | |
| P_ADJUSTED_GROSS_INC | VARCHAR2 | (8) | Holds parents adjusted gross income | |
| P_WAGES_SAL_TIPS | VARCHAR2 | (7) | Holds parents wages salary tips | |
| P_INTEREST_INCOME | VARCHAR2 | (7) | Holds parents interest income | |
| P_DIVIDEND_INCOME | VARCHAR2 | (7) | Holds parents dividend income | |
| P_NET_INC_BUS_FARM | VARCHAR2 | (7) | Holds parents net income bus farm | |
| P_OTHER_TAXABLE_INCOME | VARCHAR2 | (7) | Holds parents other taxable income | |
| P_ADJ_TO_INCOME | VARCHAR2 | (7) | Holds parents adjust to income | |
| P_US_TAX_PAID | VARCHAR2 | (7) | Holds parents US tax paid | |
| P_ITEMIZED_DEDUCTIONS | VARCHAR2 | (7) | Holds parents itemized deductions | |
| P_FATHER_INCOME_WORK | VARCHAR2 | (7) | Holds father income work | |
| P_MOTHER_INCOME_WORK | VARCHAR2 | (7) | Holds Mother's income from work | |
| P_SOC_SEC_BEN | VARCHAR2 | (6) | Holds parents social security benefits | |
| P_WELFARE_TANF | VARCHAR2 | (6) | Holds parents welfare transfer | |
| P_CHILD_SUPP_RCVD | VARCHAR2 | (6) | Holds children support received | |
| P_DED_IRA_KEOGH | VARCHAR2 | (6) | Deductions IRA KEOGH | |
| P_TAX_DEFER_PENS_SAVS | VARCHAR2 | (6) | Holds parents tax defer pension savings | |
| P_DEP_CARE_MED_SPENDING | VARCHAR2 | (6) | Describes dependents care medical spending | |
| P_EARNED_INCOME_CREDIT | VARCHAR2 | (6) | Holds parents earned income credit | |
| P_LIVING_ALLOW | VARCHAR2 | (6) | Parents living allowance | |
| P_TAX_EXMPT_INT | VARCHAR2 | (6) | tax exempt interest | |
| P_FOREIGN_INC_EXCL | VARCHAR2 | (7) | Holds parents foreign income exclusion | |
| P_OTHER_UNTAX_INC | VARCHAR2 | (7) | Contains other untaxed income | |
| P_HOPE_LL_CREDIT | VARCHAR2 | (6) | Holds parents hope LL credit | |
| P_YR_SEPARATION | VARCHAR2 | (4) | Holds parents year separation | |
| P_YR_DIVORCE | VARCHAR2 | (4) | Holds parents year divorce | |
| P_EXP_FATHER_INC | VARCHAR2 | (7) | Holds expected father income | |
| P_EXP_MOTHER_INC | VARCHAR2 | (7) | Holds expected mother income | |
| P_EXP_OTHER_TAX_INC | VARCHAR2 | (7) | Contains expected other tax income | |
| P_EXP_OTHER_UNTAX_INC | VARCHAR2 | (7) | Contains expected other untaxed income | |
| LINE_2_RELATION | VARCHAR2 | (30) | Holds line relation | |
| LINE_2_ATTEND_COLLEGE | VARCHAR2 | (30) | Contains line attend college | |
| LINE_3_RELATION | VARCHAR2 | (30) | Holds line relation | |
| LINE_3_ATTEND_COLLEGE | VARCHAR2 | (30) | Contains line attend college | |
| LINE_4_RELATION | VARCHAR2 | (30) | Holds line relation | |
| LINE_4_ATTEND_COLLEGE | VARCHAR2 | (30) | Contains line attend college | |
| LINE_5_RELATION | VARCHAR2 | (30) | Holds line relation | |
| LINE_5_ATTEND_COLLEGE | VARCHAR2 | (30) | Contains line attend college | |
| LINE_6_RELATION | VARCHAR2 | (30) | Holds line relation | |
| LINE_6_ATTEND_COLLEGE | VARCHAR2 | (30) | Contains line attend college | |
| LINE_7_RELATION | VARCHAR2 | (30) | Holds line relation | |
| LINE_7_ATTEND_COLLEGE | VARCHAR2 | (30) | Contains line attend college | |
| LINE_8_RELATION | VARCHAR2 | (30) | Holds line relation | |
| LINE_8_ATTEND_COLLEGE | VARCHAR2 | (30) | Contains line attend college | |
| P_AGE_FATHER | VARCHAR2 | (2) | Holds age of father | |
| P_AGE_MOTHER | VARCHAR2 | (2) | Holds age of mother | |
| P_DIV_SEP_IND | VARCHAR2 | (30) | Holds parents divorce or separation indicator | |
| B_CONT_NON_CUSTODIAL_PAR | VARCHAR2 | (6) | Contribution of non custodial parents | |
| COLLEGE_TYPE_2 | VARCHAR2 | (30) | Describes the College type | |
| COLLEGE_TYPE_3 | VARCHAR2 | (30) | Describes the College type | |
| COLLEGE_TYPE_4 | VARCHAR2 | (30) | Describes the College type | |
| COLLEGE_TYPE_5 | VARCHAR2 | (30) | Describes the College type | |
| COLLEGE_TYPE_6 | VARCHAR2 | (30) | Describes the College type | |
| COLLEGE_TYPE_7 | VARCHAR2 | (30) | Describes the College type | |
| COLLEGE_TYPE_8 | VARCHAR2 | (30) | Describes the College type | |
| SCHOOL_CODE_1 | VARCHAR2 | (4) | Contains School code | |
| HOUSING_CODE_1 | VARCHAR2 | (30) | Contains housing code | |
| SCHOOL_CODE_2 | VARCHAR2 | (4) | Contains School code | |
| HOUSING_CODE_2 | VARCHAR2 | (30) | Contains housing code | |
| SCHOOL_CODE_3 | VARCHAR2 | (4) | Contains School code | |
| HOUSING_CODE_3 | VARCHAR2 | (30) | Contains housing code | |
| SCHOOL_CODE_4 | VARCHAR2 | (4) | Contains School code | |
| HOUSING_CODE_4 | VARCHAR2 | (30) | Contains housing code | |
| SCHOOL_CODE_5 | VARCHAR2 | (4) | Contains School code | |
| HOUSING_CODE_5 | VARCHAR2 | (30) | Contains housing code | |
| SCHOOL_CODE_6 | VARCHAR2 | (4) | Contains School code | |
| HOUSING_CODE_6 | VARCHAR2 | (30) | Contains housing code | |
| SCHOOL_CODE_7 | VARCHAR2 | (4) | Contains School code | |
| HOUSING_CODE_7 | VARCHAR2 | (30) | Contains housing code | |
| SCHOOL_CODE_8 | VARCHAR2 | (4) | Contains School code | |
| HOUSING_CODE_8 | VARCHAR2 | (30) | Contains housing code | |
| SCHOOL_CODE_9 | VARCHAR2 | (4) | Contains School code | |
| HOUSING_CODE_9 | VARCHAR2 | (30) | Contains housing code | |
| SCHOOL_CODE_10 | VARCHAR2 | (4) | Contains School code | |
| HOUSING_CODE_10 | VARCHAR2 | (30) | Contains housing code | |
| ADDITIONAL_SCHOOL_CODE_1 | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_CODE_2 | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_CODE_3 | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_CODE_4 | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_CODE_5 | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_CODE_6 | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_CODE_7 | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_CODE_8 | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_CODE_9 | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_CODE_10 | VARCHAR2 | (4) | Holds the additional school code | |
| EXPLANATION_SPEC_CIRCUM | VARCHAR2 | (30) | Explanation special circumstance | |
| SIGNATURE_STUDENT | VARCHAR2 | (30) | Holds signature of student | |
| SIGNATURE_SPOUSE | VARCHAR2 | (30) | Holds signature of spouse | |
| SIGNATURE_FATHER | VARCHAR2 | (30) | Holds signature of father | |
| SIGNATURE_MOTHER | VARCHAR2 | (30) | Holds signature of mother | |
| MONTH_DAY_COMPLETED | VARCHAR2 | (4) | Describes Month day completed | |
| YEAR_COMPLETED | VARCHAR2 | (30) | Holds year completed | |
| AGE_LINE_2 | VARCHAR2 | (2) | Holds Age line | |
| AGE_LINE_3 | VARCHAR2 | (2) | Holds Age line | |
| AGE_LINE_4 | VARCHAR2 | (2) | Holds Age line | |
| AGE_LINE_5 | VARCHAR2 | (2) | Holds Age line | |
| AGE_LINE_6 | VARCHAR2 | (2) | Holds Age line | |
| AGE_LINE_7 | VARCHAR2 | (2) | Holds Age line | |
| AGE_LINE_8 | VARCHAR2 | (2) | Holds Age line | |
| A_ONLINE_SIGNATURE | VARCHAR2 | (30) | Holds Online Signature | |
| QUESTION_1_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_1_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_1_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_2_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_2_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_2_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_3_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_3_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_3_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_4_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_4_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_4_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_5_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_5_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_5_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_6_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_6_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_6_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_7_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_7_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_7_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_8_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_8_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_8_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_9_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_9_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_9_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_10_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_10_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_10_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_11_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_11_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_11_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_12_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_12_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_12_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_13_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_13_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_13_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_14_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_14_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_14_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_15_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_15_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_15_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_16_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_16_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_16_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_17_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_17_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_17_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_18_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_18_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_18_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_19_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_19_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_19_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_20_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_20_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_20_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_21_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_21_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_21_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_22_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_22_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_22_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_23_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_23_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_23_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_24_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_24_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_24_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_25_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_25_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_25_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_26_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_26_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_26_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_27_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_27_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_27_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_28_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_28_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_28_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_29_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_29_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_29_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_30_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTIONS_30_SIZE | VARCHAR2 | (2) | Describes Question size | |
| QUESTION_30_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| 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) | Assumed student year in college | |
| COMP_STU_MARITAL_STATUS | VARCHAR2 | (30) | Holds computed student marital status | |
| STU_FAMILY_MEMBERS | VARCHAR2 | (2) | Holds student family members | |
| STU_FAM_MEMBERS_IN_COLLEGE | VARCHAR2 | (30) | Holds student family members in college | |
| PAR_MARITAL_STATUS | VARCHAR2 | (30) | Holds parents marital status | |
| PAR_FAMILY_MEMBERS | VARCHAR2 | (2) | Holds parents family members | |
| PAR_TOTAL_IN_COLLEGE | VARCHAR2 | (30) | Holds parents total in college | |
| PAR_PAR_IN_COLLEGE | VARCHAR2 | (30) | Holds parents parents in college | |
| PAR_OTHERS_IN_COLLEGE | VARCHAR2 | (30) | Holds parents others in college | |
| PAR_AESA | VARCHAR2 | (30) | Holds the parents AESA | |
| PAR_CESA | VARCHAR2 | (2) | Holds the parents CESA | |
| STU_AESA | VARCHAR2 | (30) | Holds the students AESA | |
| STU_CESA | VARCHAR2 | (2) | Holds the students CESA | |
| IM_P_BAS_AGI_TAXABLE_INCOME | VARCHAR2 | (7) | Parents basic adjust gross income taxable | |
| IM_P_BAS_UNTX_INC_AND_BEN | VARCHAR2 | (7) | Holds Parents basic untaxed income and benefits | |
| IM_P_BAS_INC_ADJ | VARCHAR2 | (6) | Holds parents basic income adjust | |
| IM_P_BAS_TOTAL_INCOME | VARCHAR2 | (8) | Holds parents basic total income | |
| IM_P_BAS_US_INCOME_TAX | VARCHAR2 | (6) | Holds parents basic us income tax | |
| IM_P_BAS_ST_AND_OTHER_TAX | VARCHAR2 | (5) | Holds parents basic state and other taxes | |
| IM_P_BAS_FICA_TAX | VARCHAR2 | (5) | Holds parents basic FICA tax | |
| IM_P_BAS_MED_DENTAL | VARCHAR2 | (5) | Holds parents basic medical and dental | |
| IM_P_BAS_EMPLOYMENT_ALLOW | VARCHAR2 | (4) | Holds parents basic employment allowance | |
| IM_P_BAS_ANNUAL_ED_SAVINGS | VARCHAR2 | (5) | Holds parents basic annual education savings | |
| IM_P_BAS_INC_PROT_ALLOW_M | VARCHAR2 | (5) | Holds parents basic income protection allowance or MMA | |
| IM_P_BAS_TOTAL_INC_ALLOW | VARCHAR2 | (6) | Holds parents basic total income allowance | |
| IM_P_BAS_CAL_AVAIL_INC | VARCHAR2 | (9) | Holds parents basic calculated available income | |
| IM_P_BAS_AVAIL_INCOME | VARCHAR2 | (9) | Holds parents basic available income | |
| IM_P_BAS_TOTAL_CONT_INC | VARCHAR2 | (6) | Holds parents basic total contribution income | |
| IM_P_BAS_CASH_BANK_ACCOUNTS | VARCHAR2 | (6) | Holds parents basic cash bank accounts | |
| IM_P_BAS_HOME_EQUITY | VARCHAR2 | (7) | Holds parents basic home equity | |
| IM_P_BAS_OT_RL_EST_INV_EQ | VARCHAR2 | (8) | Holds other parents basic real estate invest equity | |
| IM_P_BAS_ADJ_BUS_FARM_WORTH | VARCHAR2 | (8) | Holds parents basic adjust business farm worth | |
| IM_P_BAS_ASS_SIBS_PRE_TUI | VARCHAR2 | (8) | Holds parents basic assets siblings or pre tuition | |
| IM_P_BAS_NET_WORTH | VARCHAR2 | (8) | Holds parents basic net worth | |
| IM_P_BAS_EMERG_RES_ALLOW | VARCHAR2 | (5) | Holds parents basic emergency reserve allowance | |
| IM_P_BAS_CUM_ED_SAVINGS | VARCHAR2 | (6) | Holds parents basic cumulative education savings | |
| IM_P_BAS_LOW_INC_ALLOW | VARCHAR2 | (8) | Holds parents basic low income allowance | |
| IM_P_BAS_TOTAL_ASSET_ALLOW | VARCHAR2 | (9) | Holds parents basic total asset allowance | |
| IM_P_BAS_DISC_NET_WORTH | VARCHAR2 | (9) | Holds parents basic discretionary net worth | |
| IM_P_BAS_TOTAL_CONT_ASSET | VARCHAR2 | (6) | Holds parents basic total contribution asset | |
| IM_P_BAS_TOTAL_CONT | VARCHAR2 | (7) | Holds parents basic total contribution | |
| IM_P_BAS_NUM_IN_COLL_ADJ | VARCHAR2 | (4) | Holds parents basic number in college adjustment | |
| IM_P_BAS_CONT_FOR_STU | VARCHAR2 | (5) | Holds parents basic contribution for student | |
| IM_P_BAS_CONT_FROM_INCOME | VARCHAR2 | (6) | Parents optional contribution from income | |
| IM_P_BAS_CONT_FROM_ASSETS | VARCHAR2 | (6) | Holds parents basic contribution from assets | |
| IM_P_OPT_AGI_TAXABLE_INCOME | VARCHAR2 | (7) | Holds parents optional adjust gross income taxable | |
| IM_P_OPT_UNTX_INC_AND_BEN | VARCHAR2 | (7) | Holds parents optional untaxed income and benefits | |
| IM_P_OPT_INC_ADJ | VARCHAR2 | (6) | Holds parents optional income adjustable | |
| IM_P_OPT_TOTAL_INCOME | VARCHAR2 | (8) | Holds parents optional total income | |
| IM_P_OPT_US_INCOME_TAX | VARCHAR2 | (6) | Holds parents optional US income tax | |
| IM_P_OPT_ST_AND_OTHER_TAX | VARCHAR2 | (5) | Holds parents optional state and other taxes | |
| IM_P_OPT_FICA_TAX | VARCHAR2 | (5) | Holds parents optional FICA tax | |
| IM_P_OPT_MED_DENTAL | VARCHAR2 | (5) | Holds parents optional medical or dental | |
| IM_P_OPT_ELEM_SEC_TUIT | VARCHAR2 | (5) | Holds parents optional elementary or secondary tuition | |
| IM_P_OPT_EMPLOYMENT_ALLOW | VARCHAR2 | (4) | Holds Parents optional employment allowance | |
| IM_P_OPT_ANNUAL_ED_SAVINGS | VARCHAR2 | (5) | Holds parents optional annual educational savings | |
| IM_P_OPT_INC_PROT_ALLOW_M | VARCHAR2 | (5) | Holds parents optional income protection allowance or MMA | |
| IM_P_OPT_TOTAL_INC_ALLOW | VARCHAR2 | (6) | Holds parents optional total income allowance | |
| IM_P_OPT_CAL_AVAIL_INC | VARCHAR2 | (9) | Holds parents optional calculated available income | |
| IM_P_OPT_AVAIL_INCOME | VARCHAR2 | (9) | Holds parents optional available income | |
| IM_P_OPT_TOTAL_CONT_INC | VARCHAR2 | (6) | Holds parents optional total contribution income | |
| IM_P_OPT_CASH_BANK_ACCOUNTS | VARCHAR2 | (6) | Holds parents optional cash bank accounts | |
| IM_P_OPT_HOME_EQUITY | VARCHAR2 | (7) | Holds parents optional home equity | |
| IM_P_OPT_OT_RL_EST_INV_EQ | VARCHAR2 | (8) | Holds other Parents optional real estate investment equity | |
| IM_P_OPT_ADJ_BUS_FARM_WORTH | VARCHAR2 | (8) | Holds parents optional adjust business farm worth | |
| IM_P_OPT_ASS_SIBS_PRE_T | VARCHAR2 | (8) | Holds parents optional assets siblings pre tuition | |
| IM_P_OPT_NET_WORTH | VARCHAR2 | (8) | Holds parents optional net worth | |
| IM_P_OPT_EMERG_RES_ALLOW | VARCHAR2 | (5) | Holds parents optional emergency residence allowance | |
| IM_P_OPT_CUM_ED_SAVINGS | VARCHAR2 | (6) | Holds parents optional cumulative education savings | |
| IM_P_OPT_LOW_INC_ALLOW | VARCHAR2 | (8) | Holds parents optional low income allowance | |
| IM_P_OPT_TOTAL_ASSET_ALLOW | VARCHAR2 | (9) | Contains the parents optional total asset allowance | |
| IM_P_OPT_DISC_NET_WORTH | VARCHAR2 | (9) | Contains the parents optional discretionary net worth | |
| IM_P_OPT_TOTAL_CONT_ASSET | VARCHAR2 | (6) | Contains the parents optional total contribution asset | |
| IM_P_OPT_TOTAL_CONT | VARCHAR2 | (7) | Contains the parents optional total contribution | |
| IM_P_OPT_NUM_IN_COLL_ADJ | VARCHAR2 | (4) | Contains the parents optional number in college adjust | |
| IM_P_OPT_CONT_FOR_STU | VARCHAR2 | (5) | Contains the parents optional contribution for student | |
| IM_P_OPT_CONT_FROM_INCOME | VARCHAR2 | (6) | Contains the parents optional contribution from income | |
| IM_P_OPT_CONT_FROM_ASSETS | VARCHAR2 | (6) | Contains the parents optional contribution from assets | |
| FM_P_ANALYSIS_TYPE | VARCHAR2 | (30) | Contains the parents analysis type | |
| FM_P_AGI_TAXABLE_INCOME | VARCHAR2 | (7) | Contains the parents adjust gross income taxable | |
| FM_P_UNTX_INC_AND_BEN | VARCHAR2 | (7) | Contains the parents untaxed income and benefits | |
| FM_P_INC_ADJ | VARCHAR2 | (6) | Holds the Parents income adjust | |
| FM_P_TOTAL_INCOME | VARCHAR2 | (8) | Contains the parents total income | |
| FM_P_US_INCOME_TAX | VARCHAR2 | (6) | Contains the parents US income tax | |
| FM_P_STATE_AND_OTHER_TAXES | VARCHAR2 | (5) | Contains the parents state and other taxes | |
| FM_P_FICA_TAX | VARCHAR2 | (5) | Contains the parents FICA tax | |
| FM_P_EMPLOYMENT_ALLOW | VARCHAR2 | (4) | Contains the parents employment allowance | |
| FM_P_INCOME_PROT_ALLOW | VARCHAR2 | (5) | Contains the parents income protection allowance | |
| FM_P_TOTAL_ALLOW | VARCHAR2 | (6) | Contains the parents total allowance | |
| FM_P_AVAIL_INCOME | VARCHAR2 | (9) | Contains the parents total allowance | |
| FM_P_CASH_BANK_ACCOUNTS | VARCHAR2 | (6) | Contains the parents cash bank accounts | |
| FM_P_OT_RL_EST_INV_EQ | VARCHAR2 | (8) | Contains the parents other real estate investment equity | |
| FM_P_ADJ_BUS_FARM_NET_WORTH | VARCHAR2 | (8) | Contains the parents adjust business farm net worth | |
| FM_P_NET_WORTH | VARCHAR2 | (8) | Contains the parents net worth | |
| FM_P_ASSET_PROT_ALLOW | VARCHAR2 | (5) | Contains the parents asset protection allowance | |
| FM_P_DISC_NET_WORTH | VARCHAR2 | (9) | Contains the parents discretionary net worth | |
| FM_P_TOTAL_CONTRIBUTION | VARCHAR2 | (7) | Contains the parents total contribution | |
| FM_P_NUM_IN_COLL | VARCHAR2 | (30) | Contains the parents number in college | |
| FM_P_CONT_FOR_STU | VARCHAR2 | (5) | Contains the parents contribution for student | |
| FM_P_CONT_FROM_INCOME | VARCHAR2 | (6) | Holds the students contribution from income | |
| FM_P_CONT_FROM_ASSETS | VARCHAR2 | (5) | Holds the parents contribution from assets | |
| IM_S_BAS_AGI_TAXABLE_INCOME | VARCHAR2 | (6) | Holds the students basic adjust gross income taxable | |
| IM_S_BAS_UNTX_INC_AND_BEN | VARCHAR2 | (6) | Holds the students basic untaxed income and benefits | |
| IM_S_BAS_INC_ADJ | VARCHAR2 | (6) | Holds the students basic income adjust | |
| IM_S_BAS_TOTAL_INCOME | VARCHAR2 | (7) | Holds the students basic total income | |
| IM_S_BAS_US_INCOME_TAX | VARCHAR2 | (5) | Holds the students basic US income tax | |
| IM_S_BAS_ST_AND_OTH_TAX | VARCHAR2 | (5) | Holds the students basic state and other taxes | |
| IM_S_BAS_FICA_TAX | VARCHAR2 | (5) | Holds the students basic FICA tax | |
| IM_S_BAS_MED_DENTAL | VARCHAR2 | (5) | Holds the students basic medical or dental | |
| IM_S_BAS_EMPLOYMENT_ALLOW | VARCHAR2 | (4) | Holds the students basic employment allowance | |
| IM_S_BAS_ANNUAL_ED_SAVINGS | VARCHAR2 | (5) | Holds the students basic annual education savings | |
| IM_S_BAS_INC_PROT_ALLOW_M | VARCHAR2 | (5) | Holds the students basic income protection allowance or MMA | |
| IM_S_BAS_TOTAL_INC_ALLOW | VARCHAR2 | (6) | Holds the students basic total income allowance | |
| IM_S_BAS_CAL_AVAIL_INCOME | VARCHAR2 | (8) | Holds the students basic calculated available income | |
| IM_S_BAS_AVAIL_INCOME | VARCHAR2 | (7) | Holds the students basic available income | |
| IM_S_BAS_TOTAL_CONT_INC | VARCHAR2 | (6) | Holds the students basic total contribution income | |
| IM_S_BAS_CASH_BANK_ACCOUNTS | VARCHAR2 | (6) | Holds the students basic cash bank accounts | |
| IM_S_BAS_HOME_EQUITY | VARCHAR2 | (6) | Holds the students basic home equity | |
| IM_S_BAS_OT_RL_EST_INV_EQ | VARCHAR2 | (7) | Holds the students basic or estimated investment equity | |
| IM_S_BAS_ADJ_BUS_FARM_WORTH | VARCHAR2 | (7) | Holds the students basic adjust business farm worth | |
| IM_S_BAS_TRUSTS | VARCHAR2 | (6) | Holds the students basic trusts | |
| IM_S_BAS_NET_WORTH | VARCHAR2 | (8) | Holds the students basic net worth | |
| IM_S_BAS_EMERG_RES_ALLOW | VARCHAR2 | (5) | Holds the students basic emergency residence allowance | |
| IM_S_BAS_CUM_ED_SAVINGS | VARCHAR2 | (6) | Holds the students basic cumulative education savings | |
| IM_S_BAS_TOTAL_ASSET_ALLOW | VARCHAR2 | (9) | Holds the students basic total asset allowance | |
| IM_S_BAS_DISC_NET_WORTH | VARCHAR2 | (9) | Holds the students basic discretionary net worth | |
| IM_S_BAS_TOTAL_CONT_ASSET | VARCHAR2 | (6) | Holds the students basic total contribution asset | |
| IM_S_BAS_TOTAL_CONT | VARCHAR2 | (6) | Holds the students basic total contribution | |
| IM_S_BAS_NUM_IN_COLL_ADJ | VARCHAR2 | (4) | Holds the students basic number in college adjust | |
| IM_S_BAS_CONT_FOR_STU | VARCHAR2 | (5) | Holds the students basic contribution for student | |
| IM_S_BAS_CONT_FROM_INCOME | VARCHAR2 | (6) | Holds the students basic contribution from income | |
| IM_S_BAS_CONT_FROM_ASSETS | VARCHAR2 | (6) | Holds the students basic contribution from assets | |
| IM_S_EST_AGI_TAXABLE_INCOME | VARCHAR2 | (6) | Holds the students estimated adjust gross taxable income | |
| IM_S_EST_UNTX_INC_AND_BEN | VARCHAR2 | (6) | Holds the students estimated untaxed income and benefits | |
| IM_S_EST_INC_ADJ | VARCHAR2 | (6) | Holds the students estimated income adjust | |
| IM_S_EST_TOTAL_INCOME | VARCHAR2 | (7) | Holds the students estimated total income | |
| IM_S_EST_US_INCOME_TAX | VARCHAR2 | (5) | Holds the students estimated US income tax | |
| IM_S_EST_ST_AND_OTH_TAX | VARCHAR2 | (5) | Holds the students estimated state and other taxes | |
| IM_S_EST_FICA_TAX | VARCHAR2 | (5) | Holds the students estimated FICA tax | |
| IM_S_EST_MED_DENTAL | VARCHAR2 | (5) | Holds the students estimated medical and dental | |
| IM_S_EST_EMPLOYMENT_ALLOW | VARCHAR2 | (4) | Holds the students estimated employment allowance | |
| IM_S_EST_ANNUAL_ED_SAVINGS | VARCHAR2 | (5) | Holds the students estimated annual education savings | |
| IM_S_EST_INC_PROT_ALLOW_M | VARCHAR2 | (5) | Holds the students estimated income protection allowance or MMA | |
| IM_S_EST_TOTAL_INC_ALLOW | VARCHAR2 | (6) | Holds the students estimated total income allowance | |
| IM_S_EST_CAL_AVAIL_INCOME | VARCHAR2 | (8) | Holds the students estimated calculated available income | |
| IM_S_EST_AVAIL_INCOME | VARCHAR2 | (7) | Holds the students estimated available income | |
| IM_S_EST_TOTAL_CONT_INC | VARCHAR2 | (6) | Holds the students estimated total contribution income | |
| IM_S_EST_CASH_BANK_ACCOUNTS | VARCHAR2 | (6) | Holds the students estimated cash bank accounts | |
| IM_S_EST_HOME_EQUITY | VARCHAR2 | (6) | Holds the students estimated home equity | |
| IM_S_EST_OT_RL_EST_INV_EQU | VARCHAR2 | (7) | Holds the students estimated other real estate investment equity | |
| IM_S_EST_ADJ_BUS_FARM_WORTH | VARCHAR2 | (7) | Holds the students estimated adjust business farm worth | |
| IM_S_EST_EST_TRUSTS | VARCHAR2 | (6) | Holds the students estimated trusts | |
| IM_S_EST_NET_WORTH | VARCHAR2 | (8) | Holds the students estimated net worth | |
| IM_S_EST_EMERG_RES_ALLOW | VARCHAR2 | (5) | Holds the students estimated emergency residence allowance | |
| IM_S_EST_CUM_ED_SAVINGS | VARCHAR2 | (6) | Holds the students estimated cumulative education savings | |
| IM_S_EST_TOTAL_ASSET_ALLOW | VARCHAR2 | (9) | Holds the students estimated total asset allowance | |
| IM_S_EST_DISC_NET_WORTH | VARCHAR2 | (9) | Holds the students estimated discretionary net worth | |
| IM_S_EST_TOTAL_CONT_ASSET | VARCHAR2 | (6) | Holds the students estimated total contribution asset | |
| IM_S_EST_TOTAL_CONT | VARCHAR2 | (6) | Holds the students estimated total contribution | |
| IM_S_EST_NUM_IN_COLL_ADJ | VARCHAR2 | (4) | students estimated number in college adjust | |
| IM_S_EST_CONT_FOR_STU | VARCHAR2 | (5) | Holds the students estimated contribution for student | |
| IM_S_EST_CONT_FROM_INCOME | VARCHAR2 | (6) | Holds the students estimated contribution from income | |
| IM_S_EST_CONT_FROM_ASSETS | VARCHAR2 | (6) | Holds the students estimated contribution from assets | |
| IM_S_OPT_AGI_TAXABLE_INCOME | VARCHAR2 | (6) | Holds the students optional adjust gross taxable income | |
| IM_S_OPT_UNTX_INC_AND_BEN | VARCHAR2 | (6) | students optional untaxed income and benefits | |
| IM_S_OPT_INC_ADJ | VARCHAR2 | (6) | Holds the students optional income adjust | |
| IM_S_OPT_TOTAL_INCOME | VARCHAR2 | (7) | Holds the students optional total income | |
| IM_S_OPT_US_INCOME_TAX | VARCHAR2 | (5) | Holds the students optional US income tax | |
| IM_S_OPT_STATE_AND_OTH_TAXES | VARCHAR2 | (5) | Holds the students optional state and other taxes | |
| IM_S_OPT_FICA_TAX | VARCHAR2 | (5) | Holds the students optional FICA tax | |
| IM_S_OPT_MED_DENTAL | VARCHAR2 | (5) | Holds the students optional medical or dental | |
| IM_S_OPT_EMPLOYMENT_ALLOW | VARCHAR2 | (4) | Holds the students optional employment allowance | |
| IM_S_OPT_ANNUAL_ED_SAVINGS | VARCHAR2 | (5) | Holds the students optional annual education savings | |
| IM_S_OPT_INC_PROT_ALLOW_M | VARCHAR2 | (5) | Holds the students optional income protection allowance or MMA | |
| IM_S_OPT_TOTAL_INC_ALLOW | VARCHAR2 | (6) | Holds the students optional total income allow | |
| IM_S_OPT_CAL_AVAIL_INCOME | VARCHAR2 | (8) | Holds the students optional calculated available income | |
| IM_S_OPT_AVAIL_INCOME | VARCHAR2 | (7) | Holds the students optional available income | |
| IM_S_OPT_TOTAL_CONT_INC | VARCHAR2 | (6) | Holds the students optional total contribution income | |
| IM_S_OPT_CASH_BANK_ACCOUNTS | VARCHAR2 | (6) | Holds the students optional cash bank accounts | |
| IM_S_OPT_IRA_KEOGH_ACCOUNTS | VARCHAR2 | (6) | Holds the students optional IRA KEOGH accounts | |
| IM_S_OPT_HOME_EQUITY | VARCHAR2 | (6) | Holds the students optional home equity | |
| IM_S_OPT_OT_RL_EST_INV_EQ | VARCHAR2 | (7) | Holds the students optional other real estate investment equity | |
| IM_S_OPT_ADJ_BUS_FARM_WORTH | VARCHAR2 | (7) | Holds the students optional adjust business farm worth | |
| IM_S_OPT_TRUSTS | VARCHAR2 | (6) | Holds the students optional trusts | |
| IM_S_OPT_NET_WORTH | VARCHAR2 | (8) | Holds the students optional net worth | |
| IM_S_OPT_EMERG_RES_ALLOW | VARCHAR2 | (5) | Holds the students optional emergency residence allowance | |
| IM_S_OPT_CUM_ED_SAVINGS | VARCHAR2 | (6) | Holds the student optional cumulative education savings | |
| IM_S_OPT_TOTAL_ASSET_ALLOW | VARCHAR2 | (9) | Holds the students optional total asset allowance | |
| IM_S_OPT_DISC_NET_WORTH | VARCHAR2 | (9) | Holds the students estimated discretionary net worth | |
| IM_S_OPT_TOTAL_CONT_ASSET | VARCHAR2 | (6) | Holds the students optional total contribution asset | |
| IM_S_OPT_TOTAL_CONT | VARCHAR2 | (6) | Holds the students optional total contribution | |
| IM_S_OPT_NUM_IN_COLL_ADJ | VARCHAR2 | (4) | Holds the students optional number in college adjust | |
| IM_S_OPT_CONT_FOR_STU | VARCHAR2 | (5) | Holds the students optional contribution for student | |
| IM_S_OPT_CONT_FROM_INCOME | VARCHAR2 | (6) | Holds the students optional contribution from income | |
| IM_S_OPT_CONT_FROM_ASSETS | VARCHAR2 | (6) | Holds the students optional contribution from assets | |
| FM_S_ANALYSIS_TYPE | VARCHAR2 | (30) | Holds the analysis type | |
| FM_S_AGI_TAXABLE_INCOME | VARCHAR2 | (6) | Holds the students adjust gross income taxable | |
| FM_S_UNTX_INC_AND_BEN | VARCHAR2 | (6) | Holds the students untaxed income and benefits | |
| FM_S_INC_ADJ | VARCHAR2 | (6) | Holds the students income adjust | |
| FM_S_TOTAL_INCOME | VARCHAR2 | (7) | Holds the students total income | |
| FM_S_US_INCOME_TAX | VARCHAR2 | (5) | Holds the students US income tax | |
| FM_S_STATE_AND_OTH_TAXES | VARCHAR2 | (5) | Holds the students state and other taxes | |
| FM_S_FICA_TAX | VARCHAR2 | (5) | Holds the students FICA tax | |
| FM_S_EMPLOYMENT_ALLOW | VARCHAR2 | (4) | Holds the students employment allowance | |
| FM_S_INCOME_PROT_ALLOW | VARCHAR2 | (5) | Holds the students income protection allowance | |
| FM_S_TOTAL_ALLOW | VARCHAR2 | (6) | Holds the students total allowance | |
| FM_S_CAL_AVAIL_INCOME | VARCHAR2 | (8) | Holds the students calculated available income | |
| FM_S_AVAIL_INCOME | VARCHAR2 | (8) | Holds the students available income | |
| FM_S_CASH_BANK_ACCOUNTS | VARCHAR2 | (6) | Holds the students cash bank accounts | |
| FM_S_OT_RL_EST_INV_EQUITY | VARCHAR2 | (7) | Holds the students other real estate investment equity | |
| FM_S_ADJ_BUS_FARM_WORTH | VARCHAR2 | (7) | Describes the Students net worth from adjust business farm | |
| FM_S_TRUSTS | VARCHAR2 | (6) | Holds the students trusts | |
| FM_S_NET_WORTH | VARCHAR2 | (8) | Holds the students net worth | |
| FM_S_ASSET_PROT_ALLOW | VARCHAR2 | (5) | Holds the students asset protection allowance | |
| FM_S_DISC_NET_WORTH | VARCHAR2 | (9) | Holds the students discretionary net worth | |
| FM_S_TOTAL_CONT | VARCHAR2 | (5) | Holds the students total contribution | |
| FM_S_NUM_IN_COLL | VARCHAR2 | (30) | Holds the students number in college | |
| FM_S_CONT_FOR_STU | VARCHAR2 | (5) | Holds the students contribution for student | |
| FM_S_CONT_FROM_INCOME | VARCHAR2 | (6) | Holds the students contribution from income | |
| FM_S_CONT_FROM_ASSETS | VARCHAR2 | (5) | Holds the students contribution from assets | |
| IM_INST_RESIDENT_IND | VARCHAR2 | (30) | Describes the institutional resident indicator | |
| INSTITUTIONAL_1_BUDGET_NAME | VARCHAR2 | (7) | Describes the institutional budget name | |
| IM_INST_1_BUDGET_DURATION | VARCHAR2 | (2) | Describes the institutional budget duration | |
| IM_INST_1_TUITION_FEES | VARCHAR2 | (5) | Describes the institutional tuition fees | |
| IM_INST_1_BOOKS_SUPPLIES | VARCHAR2 | (5) | Describes the institutional books supplies | |
| IM_INST_1_LIVING_EXPENSES | VARCHAR2 | (5) | Describes the institutional living expenses | |
| IM_INST_1_TOT_EXPENSES | VARCHAR2 | (5) | Describes the institutional total expenses | |
| IM_INST_1_TOT_STU_CONT | VARCHAR2 | (5) | Describes the institutional total student contribution | |
| IM_INST_1_TOT_PAR_CONT | VARCHAR2 | (5) | Describes the institutional total parent contribution | |
| IM_INST_1_TOT_FAMILY_CONT | VARCHAR2 | (5) | Describes the institutional total family contribution | |
| IM_INST_1_VA_BENEFITS | VARCHAR2 | (5) | Describes the institutional veteran benefits | |
| IM_INST_1_OT_CONT | VARCHAR2 | (5) | Describes the institutional other contribution | |
| IM_INST_1_EST_FINANCIAL_NEED | VARCHAR2 | (5) | Describes the institutional estimated financial need | |
| INSTITUTIONAL_2_BUDGET_NAME | VARCHAR2 | (7) | Describes the institutional budget name | |
| IM_INST_2_BUDGET_DURATION | VARCHAR2 | (2) | Describes the institutional budget duration | |
| IM_INST_2_TUITION_FEES | VARCHAR2 | (5) | Describes the institutional tuition fees | |
| IM_INST_2_BOOKS_SUPPLIES | VARCHAR2 | (5) | Describes the institutional books supplies | |
| IM_INST_2_LIVING_EXPENSES | VARCHAR2 | (5) | Describes the institutional living expenses | |
| IM_INST_2_TOT_EXPENSES | VARCHAR2 | (5) | Describes the institutional total expenses | |
| IM_INST_2_TOT_STU_CONT | VARCHAR2 | (5) | Describes the institutional total student contribution | |
| IM_INST_2_TOT_PAR_CONT | VARCHAR2 | (5) | Describes the institutional total parent contribution | |
| IM_INST_2_TOT_FAMILY_CONT | VARCHAR2 | (5) | Describes the institutional total family contribution | |
| IM_INST_2_VA_BENEFITS | VARCHAR2 | (5) | Describes the institutional veteran benefits | |
| IM_INST_2_EST_FINANCIAL_NEED | VARCHAR2 | (5) | Describes the institutional estimated financial need | |
| INSTITUTIONAL_3_BUDGET_NAME | VARCHAR2 | (7) | Describes the institutional budget name | |
| IM_INST_3_BUDGET_DURATION | VARCHAR2 | (2) | Describes the institutional budget duration | |
| IM_INST_3_TUITION_FEES | VARCHAR2 | (5) | Describes the institutional tuition fees | |
| IM_INST_3_BOOKS_SUPPLIES | VARCHAR2 | (5) | Describes the institutional books supplies | |
| IM_INST_3_LIVING_EXPENSES | VARCHAR2 | (5) | Describes the institutional living expenses | |
| IM_INST_3_TOT_EXPENSES | VARCHAR2 | (5) | Describes the institutional total expenses | |
| IM_INST_3_TOT_STU_CONT | VARCHAR2 | (5) | Describes the institutional total student contribution | |
| IM_INST_3_TOT_PAR_CONT | VARCHAR2 | (5) | Describes the institutional total parent contribution | |
| IM_INST_3_TOT_FAMILY_CONT | VARCHAR2 | (5) | Describes the institutional total family contribution | |
| IM_INST_3_VA_BENEFITS | VARCHAR2 | (5) | Describes the institutional veteran benefits | |
| IM_INST_3_EST_FINANCIAL_NEED | VARCHAR2 | (5) | Describes the institutional estimated financial need | |
| FM_INST_1_FEDERAL_EFC | VARCHAR2 | (5) | Institutional federal effective family contribution | |
| FM_INST_1_VA_BENEFITS | VARCHAR2 | (5) | Describes the institutional veteran benefits | |
| FM_INST_1_FED_ELIGIBILITY | VARCHAR2 | (5) | Describes the institutional federal eligibility | |
| FM_INST_1_PELL | VARCHAR2 | (4) | Holds the institution pell | |
| OPTION_PAR_LOSS_ALLOW_IND | VARCHAR2 | (30) | Holds the option parent loss allowance indicator | |
| OPTION_PAR_TUITION_IND | VARCHAR2 | (30) | Holds the option parent tuition indicator | |
| OPTION_PAR_HOME_IND | VARCHAR2 | (30) | Holds the option parent home indicator | |
| OPTION_PAR_HOME_VALUE | VARCHAR2 | (7) | Holds the option parent home value | |
| OPTION_PAR_HOME_DEBT | VARCHAR2 | (7) | Holds the option parent home debt | |
| OPTION_STU_IRA_KEOGH_IND | VARCHAR2 | (30) | Holds the option student IRA KEOGH indicator | |
| OPTION_STU_HOME_IND | VARCHAR2 | (30) | Holds the option student home indicator | |
| OPTION_STU_HOME_VALUE | VARCHAR2 | (6) | Holds the optional student home value | |
| OPTION_STU_HOME_DEBT | VARCHAR2 | (6) | Holds the option student home debt | |
| OPTION_STU_SUM_AY_INC_IND | VARCHAR2 | (30) | Holds the option student summer award year income indicator | |
| OPTION_PAR_HOPE_LL_CREDIT | VARCHAR2 | (30) | Holds the option parents hope LL credit | |
| OPTION_STU_HOPE_LL_CREDIT | VARCHAR2 | (30) | Holds 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 FANR 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 the 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 | VARCHAR2 | (30) | Holds the option parent Adjustment factor used to modify IPA and ERS | |
| FNAR_MESSAGE_49 | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_55 | VARCHAR2 | (30) | Holds the FNAR message | |
| 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 Assests from Interest and Dividend Income Indicator | |
| MATCH_CODE | VARCHAR2 | (30) | Name of Record Matching criteria used for Importing the PROFILE | |
| STU_LIVES_WITH_NUM | NUMBER | Student Lives With | ||
| STU_MOST_SUPPORT_FROM_NUM | NUMBER | Student Received Most Support From | ||
| LOCATION_COMPUTER_NUM | NUMBER | 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 CSS_ID
, ORG_ID
, RECORD_STATUS
, COLLEGE_CODE
, ACADEMIC_YEAR
, STU_RECORD_TYPE
, CSS_ID_NUMBER
, REGISTRATION_RECEIPT_DATE
, REGISTRATION_TYPE
, APPLICATION_RECEIPT_DATE
, APPLICATION_TYPE
, ORIGINAL_FNAR_COMPUTE
, REVISION_FNAR_COMPUTE_DATE
, ELECTRONIC_EXTRACT_DATE
, INSTITUTIONAL_REPORTING_TYPE
, ASR_RECEIPT_DATE
, LAST_NAME
, FIRST_NAME
, MIDDLE_INITIAL
, ADDRESS_NUMBER_AND_STREET
, CITY
, STATE_MAILING
, ZIP_CODE
, S_TELEPHONE_NUMBER
, S_TITLE
, DATE_OF_BIRTH
, SOCIAL_SECURITY_NUMBER
, STATE_LEGAL_RESIDENCE
, FOREIGN_ADDRESS_INDICATOR
, FOREIGN_POSTAL_CODE
, COUNTRY
, FINANCIAL_AID_STATUS
, YEAR_IN_COLLEGE
, MARITAL_STATUS
, WARD_COURT
, LEGAL_DEPENDENTS_OTHER
, HOUSEHOLD_SIZE
, NUMBER_IN_COLLEGE
, CITIZENSHIP_STATUS
, CITIZENSHIP_COUNTRY
, VISA_CLASSIFICATION
, TAX_FIGURES
, NUMBER_EXEMPTIONS
, ADJUSTED_GROSS_INC
, US_TAX_PAID
, ITEMIZED_DEDUCTIONS
, STU_INCOME_WORK
, SPOUSE_INCOME_WORK
, DIVID_INT_INC
, SOC_SEC_BENEFITS
, WELFARE_TANF
, CHILD_SUPP_RCVD
, EARNED_INCOME_CREDIT
, OTHER_UNTAX_INCOME
, TAX_STU_AID
, CASH_SAV_CHECK
, IRA_KEOGH
, INVEST_VALUE
, INVEST_DEBT
, HOME_VALUE
, HOME_DEBT
, OTH_REAL_VALUE
, OTH_REAL_DEBT
, BUS_FARM_VALUE
, BUS_FARM_DEBT
, LIVE_ON_FARM
, HOME_PURCH_PRICE
, HOPE_LL_CREDIT
, HOME_PURCH_YEAR
, TRUST_AMOUNT
, TRUST_AVAIL
, TRUST_ESTAB
, CHILD_SUPPORT_PAID
, MED_DENT_EXPENSES
, VET_US
, VET_BEN_AMOUNT
, VET_BEN_MONTHS
, STU_SUMMER_WAGES
, STU_SCHOOL_YR_WAGES
, SPOUSE_SUMMER_WAGES
, SPOUSE_SCHOOL_YR_WAGES
, SUMMER_OTHER_TAX_INC
, SCHOOL_YR_OTHER_TAX_INC
, SUMMER_UNTAX_INC
, SCHOOL_YR_UNTAX_INC
, GRANTS_SCHOL_ETC
, TUIT_BENEFITS
, CONT_PARENTS
, CONT_RELATIVES
, P_SIBLINGS_PRE_TUIT
, P_STUDENT_PRE_TUIT
, P_HOUSEHOLD_SIZE
, P_NUMBER_IN_COLLEGE
, P_PARENTS_IN_COLLEGE
, P_MARITAL_STATUS
, P_STATE_LEGAL_RESIDENCE
, P_NATURAL_PAR_STATUS
, P_CHILD_SUPP_PAID
, P_REPAY_ED_LOANS
, P_MED_DENT_EXPENSES
, P_TUIT_PAID_AMOUNT
, P_TUIT_PAID_NUMBER
, P_EXP_CHILD_SUPP_PAID
, P_EXP_REPAY_ED_LOANS
, P_EXP_MED_DENT_EXPENSES
, P_EXP_TUIT_PD_AMOUNT
, P_EXP_TUIT_PD_NUMBER
, P_CASH_SAV_CHECK
, P_MONTH_MORTGAGE_PAY
, P_INVEST_VALUE
, P_INVEST_DEBT
, P_HOME_VALUE
, P_HOME_DEBT
, P_HOME_PURCH_PRICE
, P_OWN_BUSINESS_FARM
, P_BUSINESS_VALUE
, P_BUSINESS_DEBT
, P_FARM_VALUE
, P_FARM_DEBT
, P_LIVE_ON_FARM
, P_OTH_REAL_ESTATE_VALUE
, P_OTH_REAL_ESTATE_DEBT
, P_OTH_REAL_PURCH_PRICE
, P_SIBLINGS_ASSETS
, P_HOME_PURCH_YEAR
, P_OTH_REAL_PURCH_YEAR
, P_PRIOR_AGI
, P_PRIOR_US_TAX_PAID
, P_PRIOR_ITEM_DEDUCTIONS
, P_PRIOR_OTHER_UNTAX_INC
, P_TAX_FIGURES
, P_NUMBER_EXEMPTIONS
, P_ADJUSTED_GROSS_INC
, P_WAGES_SAL_TIPS
, P_INTEREST_INCOME
, P_DIVIDEND_INCOME
, P_NET_INC_BUS_FARM
, P_OTHER_TAXABLE_INCOME
, P_ADJ_TO_INCOME
, P_US_TAX_PAID
, P_ITEMIZED_DEDUCTIONS
, P_FATHER_INCOME_WORK
, P_MOTHER_INCOME_WORK
, P_SOC_SEC_BEN
, P_WELFARE_TANF
, P_CHILD_SUPP_RCVD
, P_DED_IRA_KEOGH
, P_TAX_DEFER_PENS_SAVS
, P_DEP_CARE_MED_SPENDING
, P_EARNED_INCOME_CREDIT
, P_LIVING_ALLOW
, P_TAX_EXMPT_INT
, P_FOREIGN_INC_EXCL
, P_OTHER_UNTAX_INC
, P_HOPE_LL_CREDIT
, P_YR_SEPARATION
, P_YR_DIVORCE
, P_EXP_FATHER_INC
, P_EXP_MOTHER_INC
, P_EXP_OTHER_TAX_INC
, P_EXP_OTHER_UNTAX_INC
, LINE_2_RELATION
, LINE_2_ATTEND_COLLEGE
, LINE_3_RELATION
, LINE_3_ATTEND_COLLEGE
, LINE_4_RELATION
, LINE_4_ATTEND_COLLEGE
, LINE_5_RELATION
, LINE_5_ATTEND_COLLEGE
, LINE_6_RELATION
, LINE_6_ATTEND_COLLEGE
, LINE_7_RELATION
, LINE_7_ATTEND_COLLEGE
, LINE_8_RELATION
, LINE_8_ATTEND_COLLEGE
, P_AGE_FATHER
, P_AGE_MOTHER
, P_DIV_SEP_IND
, B_CONT_NON_CUSTODIAL_PAR
, COLLEGE_TYPE_2
, COLLEGE_TYPE_3
, COLLEGE_TYPE_4
, COLLEGE_TYPE_5
, COLLEGE_TYPE_6
, COLLEGE_TYPE_7
, COLLEGE_TYPE_8
, SCHOOL_CODE_1
, HOUSING_CODE_1
, SCHOOL_CODE_2
, HOUSING_CODE_2
, SCHOOL_CODE_3
, HOUSING_CODE_3
, SCHOOL_CODE_4
, HOUSING_CODE_4
, SCHOOL_CODE_5
, HOUSING_CODE_5
, SCHOOL_CODE_6
, HOUSING_CODE_6
, SCHOOL_CODE_7
, HOUSING_CODE_7
, SCHOOL_CODE_8
, HOUSING_CODE_8
, SCHOOL_CODE_9
, HOUSING_CODE_9
, SCHOOL_CODE_10
, HOUSING_CODE_10
, ADDITIONAL_SCHOOL_CODE_1
, ADDITIONAL_SCHOOL_CODE_2
, ADDITIONAL_SCHOOL_CODE_3
, ADDITIONAL_SCHOOL_CODE_4
, ADDITIONAL_SCHOOL_CODE_5
, ADDITIONAL_SCHOOL_CODE_6
, ADDITIONAL_SCHOOL_CODE_7
, ADDITIONAL_SCHOOL_CODE_8
, ADDITIONAL_SCHOOL_CODE_9
, ADDITIONAL_SCHOOL_CODE_10
, EXPLANATION_SPEC_CIRCUM
, SIGNATURE_STUDENT
, SIGNATURE_SPOUSE
, SIGNATURE_FATHER
, SIGNATURE_MOTHER
, MONTH_DAY_COMPLETED
, YEAR_COMPLETED
, AGE_LINE_2
, AGE_LINE_3
, AGE_LINE_4
, AGE_LINE_5
, AGE_LINE_6
, AGE_LINE_7
, AGE_LINE_8
, A_ONLINE_SIGNATURE
, QUESTION_1_NUMBER
, QUESTION_1_SIZE
, QUESTION_1_ANSWER
, QUESTION_2_NUMBER
, QUESTION_2_SIZE
, QUESTION_2_ANSWER
, QUESTION_3_NUMBER
, QUESTION_3_SIZE
, QUESTION_3_ANSWER
, QUESTION_4_NUMBER
, QUESTION_4_SIZE
, QUESTION_4_ANSWER
, QUESTION_5_NUMBER
, QUESTION_5_SIZE
, QUESTION_5_ANSWER
, QUESTION_6_NUMBER
, QUESTION_6_SIZE
, QUESTION_6_ANSWER
, QUESTION_7_NUMBER
, QUESTION_7_SIZE
, QUESTION_7_ANSWER
, QUESTION_8_NUMBER
, QUESTION_8_SIZE
, QUESTION_8_ANSWER
, QUESTION_9_NUMBER
, QUESTION_9_SIZE
, QUESTION_9_ANSWER
, QUESTION_10_NUMBER
, QUESTION_10_SIZE
, QUESTION_10_ANSWER
, QUESTION_11_NUMBER
, QUESTION_11_SIZE
, QUESTION_11_ANSWER
, QUESTION_12_NUMBER
, QUESTION_12_SIZE
, QUESTION_12_ANSWER
, QUESTION_13_NUMBER
, QUESTION_13_SIZE
, QUESTION_13_ANSWER
, QUESTION_14_NUMBER
, QUESTION_14_SIZE
, QUESTION_14_ANSWER
, QUESTION_15_NUMBER
, QUESTION_15_SIZE
, QUESTION_15_ANSWER
, QUESTION_16_NUMBER
, QUESTION_16_SIZE
, QUESTION_16_ANSWER
, QUESTION_17_NUMBER
, QUESTION_17_SIZE
, QUESTION_17_ANSWER
, QUESTION_18_NUMBER
, QUESTION_18_SIZE
, QUESTION_18_ANSWER
, QUESTION_19_NUMBER
, QUESTION_19_SIZE
, QUESTION_19_ANSWER
, QUESTION_20_NUMBER
, QUESTION_20_SIZE
, QUESTION_20_ANSWER
, QUESTION_21_NUMBER
, QUESTION_21_SIZE
, QUESTION_21_ANSWER
, QUESTION_22_NUMBER
, QUESTION_22_SIZE
, QUESTION_22_ANSWER
, QUESTION_23_NUMBER
, QUESTION_23_SIZE
, QUESTION_23_ANSWER
, QUESTION_24_NUMBER
, QUESTION_24_SIZE
, QUESTION_24_ANSWER
, QUESTION_25_NUMBER
, QUESTION_25_SIZE
, QUESTION_25_ANSWER
, QUESTION_26_NUMBER
, QUESTION_26_SIZE
, QUESTION_26_ANSWER
, QUESTION_27_NUMBER
, QUESTION_27_SIZE
, QUESTION_27_ANSWER
, QUESTION_28_NUMBER
, QUESTION_28_SIZE
, QUESTION_28_ANSWER
, QUESTION_29_NUMBER
, QUESTION_29_SIZE
, QUESTION_29_ANSWER
, QUESTION_30_NUMBER
, QUESTIONS_30_SIZE
, QUESTION_30_ANSWER
, 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_T
, 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_EQ
, 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_ST_AND_OTH_TAX
, 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_BUS_FARM_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_AGI_TAXABLE_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_ST_AND_OTH_TAX
, 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_EQU
, 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
, P_SOC_SEC_BEN_STUDENT_AMT
, P_TUIT_FEE_DEDUCT_AMT
, OPTION_IND_STU_IPT_ASSETS_FLAG
, MATCH_CODE
, 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_CSS_INTERFACE_ALL;
IGF.IGF_AP_CSS_INTERFACE_ALL does not reference any database object
IGF.IGF_AP_CSS_INTERFACE_ALL is referenced by following:
APPS
IGF_AP_CSS_INTERFACE_ALL
|
|
|
|