[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | IGFFV_PROFILE_INFORMATION |
|---|---|
| Object Type: | VIEW |
| Owner: | APPS |
| FND Design Data: |  IGF.IGFFV_PROFILE_INFORMATION
|
| Subobject Name: | |
| Status: | VALID |
A Business Intelligence System view
Full View for the Entity that holds the complete Profile record of the students
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| ACTIVE_PROFILE | VARCHAR2 | (1) | Yes | This indicates if the profile is the active profile of the student |
| 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 | |
| STUDENT_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_DATE | 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 | |
| _LA:STATE_MAILING | CHAR | (66) | Holds the state mailing address | |
| ZIP_CODE | VARCHAR2 | (5) | Holds the zip code | |
| STUDENT_TELEPHONE_NUMBER | VARCHAR2 | (10) | Holds the telephone number of the student | |
| STUDENT_TITLE | VARCHAR2 | (30) | Holds the title of the student | |
| BIRTH_DATE | DATE | Holds the students' Date of Birth | ||
| SOCIAL_SECURITY_NUMBER | VARCHAR2 | (9) | Holds the students' Social Security Number | |
| _LA:STATE_LEGAL_RESIDENCE | CHAR | (74) | Holds the students' state of legal residence | |
| FOREIGN_ADDRESS_FLAG | 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 | |
| _LA:FINANCIAL_AID_STATUS | CHAR | (75) | Holds the student's financial aid status | |
| YEAR_IN_COLLEGE | VARCHAR2 | (30) | Holds the number of years spent in college by the student | |
| _LA:MARITAL_STATUS | CHAR | (73) | Holds the student's marital status | |
| _LA:WARD_COURT | CHAR | (72) | Indicates if the student is ward of count | |
| _LA:LEGAL_DEPENDENTS_OTHER | CHAR | (84) | Indicates if the student has other legal dependents | |
| HOUSEHOLD_SIZE | NUMBER | (15) | Holds the student's households size | |
| _LA:NUMBER_IN_COLLEGE | CHAR | (65) | Number of student's family members in college | |
| _LA:CITIZENSHIP_STATUS | CHAR | (73) | 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 | NUMBER | (15) | Number of exemptions claimed by the student | |
| ADJUSTED_GROSS_INCOME | NUMBER | (15) | Holds the student's adjusted gross income | |
| US_TAX_PAID | NUMBER | (15) | Indicates the US tax paid by the student | |
| ITEMIZED_DEDUCTIONS | NUMBER | (15) | Holds the student's itemized deductions | |
| STUDENT_INCOME_WORK | NUMBER | (15) | Holds the students income from work | |
| SPOUSE_INCOME_WORK | NUMBER | (15) | Holds the student's spouse's income from work | |
| DIVIDENT_INTEREST_INCOME | NUMBER | (15) | student's income from dividends and interest | |
| SOCIAL_SECURITY_BENEFITS | NUMBER | (15) | Holds the student's social security benefits | |
| WELFARE_TANF | NUMBER | (15) | Indicates the welfare TANF gains for the student | |
| CHILD_SUPPORT_RECEIVED | NUMBER | (15) | Holds the child support received by student | |
| EARNED_INCOME_CREDIT | NUMBER | (15) | Holds the earned income credit of the student | |
| OTHER_UNTAXED_INCOME | NUMBER | (15) | Holds the other untaxed income of student | |
| TAX_STUDENT_AID_AMOUNT | NUMBER | (15) | Holds the taxable aid received by the student | |
| CASH_SAVINGS_CHECK_AMOUNT | NUMBER | (15) | Holds the cash saving or checking balance of the student | |
| IRA_KEOGH_AMOUNT | NUMBER | (15) | Holds the IRA KEOGH received by the student | |
| INVESTMENT_VALUE_AMOUNT | NUMBER | (15) | Holds the student's investment value | |
| INVESTMENT_DEBT_AMOUNT | NUMBER | (15) | Holds the student's investment debt | |
| HOME_VALUE_AMOUNT | NUMBER | (15) | Holds the student's home value | |
| HOME_DEBT_AMOUNT | NUMBER | (15) | Holds the student's home debt | |
| OTHER_REAL_VALUE_AMOUNT | NUMBER | (15) | Holds the student's other real value | |
| OTHER_REAL_DEBT_AMOUNT | NUMBER | (15) | Holds the student's other real debt | |
| BUSINESS_FARM_VALUE_AMOUNT | NUMBER | (15) | Holds the student's business farm value | |
| BUSINESS_FARM_DEBT_AMOUNT | NUMBER | (15) | Holds the student's business farm debt | |
| _LA:LIVE_ON_FARM | CHAR | (74) | Indicates if student lives on a farm | |
| HOME_PURCH_PRICE | NUMBER | (15) | Holds the student's home purchase price | |
| HOPE_LL_CREDIT_AMOUNT | NUMBER | (15) | Holds the student's hope credit received | |
| HOME_PURCH_YEAR | VARCHAR2 | (4) | Indicates students home purchase year | |
| STUDENT_TRUST_AMOUNT | NUMBER | (15) | Indicates the trust amount for the student | |
| _LA:STUDENT_TRUST_AVAILABLE | CHAR | (73) | Indicates if the trust is available for the student | |
| STUDENT_TRUST_ESTABLISHED | VARCHAR2 | (30) | Indicates when the trust was established was established for the student | |
| CHILD_SUPPORT_PAID | NUMBER | (15) | Indicates child support paid by the student | |
| MEDICAL_DENTAL_EXPENSES | NUMBER | (15) | Holds the medical dental expenses of the student | |
| _LA:VETERAN_US_FLAG | CHAR | (68) | Indicates if the student is US Veteran | |
| VETERAN_BENEFIT_AMOUNT | NUMBER | (15) | Holds the veteran benefit amount for the student | |
| VETERAN_BENEFIT_MONTHS | NUMBER | (15) | Holds the veteran benefit months for the student | |
| STUDENT_SUMMER_WAGES_AMOUNT | NUMBER | (15) | Holds summer wages of the student | |
| STUDENT_SCHOOL_YR_WAGES_AMOUNT | NUMBER | (15) | Holds school year wages of the student | |
| SPOUSE_SUMMER_WAGES_AMOUNT | NUMBER | (15) | Holds students spouse summer wages | |
| SPOUSE_SCHOOL_YR_WAGES_AMOUNT | NUMBER | (15) | Holds students spouse school year wages | |
| SUMMER_OTHER_TAX_INC_AMOUNT | NUMBER | (15) | Holds other taxable income of the student during summer | |
| SCHOOL_YR_OTHER_TAX_INC_AMOUNT | NUMBER | (15) | Holds other taxable income of the student during school year | |
| SUMMER_UNTAX_INC_AMOUNT | NUMBER | (15) | Holds the untaxed income of the student during summer | |
| SCHOOL_YR_UNTAX_INC_AMOUNT | NUMBER | (15) | Holds untaxed income of the student during school year | |
| GRANTS_SCHOL_ETC_AMOUNT | NUMBER | (15) | Holds whether the grants are received from school for the student | |
| TUITION_BENEFITS_AMOUNT | NUMBER | (15) | Hold the tuition benefits for the student | |
| PARENTS_CONTIBUTION_AMOUNT | NUMBER | (15) | Holds the contribution made by the parent of the student | |
| RELATIVES_CONTIBUTION_AMOUNT | NUMBER | (15) | Holds the contribution made by the relatives of the student | |
| PARENT_SIBLINGS_PRE_TUITION | NUMBER | (15) | Holds parents siblings pre tuition | |
| PARENT_STUDENT_PRE_TUITION | NUMBER | (15) | Holds student pre tuition | |
| PARENTS_HOUSEHOLD_SIZE | NUMBER | (15) | Holds parents household size | |
| PARENTS_NUMBER_IN_COLLEGE | NUMBER | (15) | Holds parents number in college | |
| _LA:PARENTS_IN_COLLEGE | CHAR | (73) | Holds parents in college | |
| _LA:PARENTS_MARITAL_STATUS | CHAR | (75) | Holds parents marital status | |
| _LA:PARENTS_STATE_LEGAL_RES | CHAR | (76) | Holds parents state legal residence | |
| _LA:NATURAL_PARENTS_STATUS | CHAR | (82) | Holds natural parents status | |
| PARENTS_CHILD_SUPPORT_PAID | NUMBER | (15) | Holds parents child support paid | |
| PARENTS_REPAY_EDUCATION_LOANS | NUMBER | (15) | Holds parents repay education loans | |
| PARENTS_MEDICAL_DENTAL_EXPENS | NUMBER | (15) | Holds parents medical and dental expenses | |
| PARENTS_TUITION_PAID_AMOUNT | NUMBER | (15) | Holds parents tuition paid amount | |
| PARENTS_TUITION_PAID_NUMBER | NUMBER | (15) | Holds parents tuition paid number | |
| PARENTS_EXP_CHILD_SUPPORT_PAID | NUMBER | (15) | Holds parents expected child support paid | |
| PARENTS_EXP_REPAY_ED_LOANS | NUMBER | (15) | Holds parents expected to repay education loans | |
| PARENTS_EXP_MED_DENT_EXPENSES | NUMBER | (15) | Holds parents expected medical and dental expenses | |
| PARENTS_EXP_TUIT_PD_AMOUNT | NUMBER | (15) | Holds parents expected tuition paid amount | |
| PARENTS_EXP_TUIT_PD_NUMBER | NUMBER | (15) | Holds parents expected tuition paid number | |
| PARENTS_CASH_SAVINGS_CHECK | NUMBER | (15) | Holds parents cash save check | |
| PARENTS_MONTH_MORTGAGE_PAY | NUMBER | (15) | Holds parents month mortgage pay | |
| PARENTS_INVEST_VALUE | NUMBER | (15) | Holds parents invest value | |
| PARENTS_INVEST_DEBT | NUMBER | (15) | Holds parents invest debt | |
| PARENTS_HOME_VALUE | NUMBER | (15) | Holds parents home value | |
| PARENTS_HOME_DEBT | NUMBER | (15) | Holds parents home debt | |
| PARENTS_HOME_PURCH_PRICE | NUMBER | (15) | Holds parents home purchase price | |
| _LA:PARENTS_OWN_BUSINES_FARM | CHAR | (82) | Holds parents own business farm | |
| PARENTS_BUSINESS_VALUE | NUMBER | (15) | Holds parents business value | |
| PARENTS_BUSINESS_DEBT | NUMBER | (15) | Holds parents business debt | |
| PARENTS_FARM_VALUE | NUMBER | (15) | Holds parents farm value | |
| PARENTS_FARM_DEBT | NUMBER | (15) | Holds parents farm debt | |
| _LA:PARENTS_LIVE_ON_FARM | CHAR | (76) | Holds parents live on farm | |
| PARENTS_OTHER_REAL_ESTATE_VAL | NUMBER | (15) | Holds parents other real estate value | |
| PARENTS_OTHER_REAL_ESTATE_DEBT | NUMBER | (15) | Holds parents other real estate debt | |
| PARENTS_OTHER_REAL_PURCH_PRICE | NUMBER | (15) | Holds parents other real purchase price | |
| PARENTS_SIBLINGS_ASSETS | NUMBER | (15) | Holds parents siblings assets | |
| PARENTS_HOME_PURCH_YEAR | VARCHAR2 | (4) | Holds parents home purchase year | |
| PARENTS_OTHER_REAL_PURCH_YEAR | VARCHAR2 | (4) | Holds parents other real purchase year | |
| PARENTS_PRIOR_AGI | NUMBER | (15) | Holds parents Actual Gross Income | |
| PARENTS_PRIOR_US_TAX_PAID | NUMBER | (15) | Holds parents prior us tax paid | |
| PARENTS_PRIOR_ITEM_DEDUCTIONS | NUMBER | (15) | Holds parents prior item deductions | |
| PARENTS_PRIOR_OTHER_UNTAX_INC | NUMBER | (15) | Holds parents prior other untaxed income | |
| _LA:PARENTS_TAX_FIGURES | CHAR | (63) | Holds parents tax figures | |
| PARENTS_NUMBER_EXEMPTIONS | NUMBER | (15) | Holds parents number exemptions | |
| PARENTS_ADJUSTED_GROSS_INCOME | NUMBER | (15) | Holds parents adjusted gross income | |
| PARENTS_WAGES_SAL_TIPS | NUMBER | (15) | Holds parents wages salary tips | |
| PARENTS_INTEREST_INCOME | NUMBER | (15) | Holds parents interest income | |
| PARENTS_DIVIDEND_INCOME | NUMBER | (15) | Holds parents dividend income | |
| PARENTS_NET_INC_BUSINESS_FARM | NUMBER | (15) | Holds parents net income bus farm | |
| PARENTS_OTHER_TAXABLE_INCOME | NUMBER | (15) | Holds parents other taxable income | |
| PARENTS_ADJ_TO_INCOME | NUMBER | (15) | Holds parents adjust to income | |
| PARENTS_US_TAX_PAID | NUMBER | (15) | Holds parents US tax paid | |
| PARENTS_ITEMIZED_DEDUCTIONS | NUMBER | (15) | Holds parents itemized deductions | |
| PARENTS_FATHER_INCOME_WORK | NUMBER | (15) | Holds father income work | |
| PARENTS_MOTHER_INCOME_WORK | NUMBER | (15) | Holds Mother's income from work | |
| PARENTS_SOCICAL_SEC_BENEFITS | NUMBER | (15) | Holds parents social security benefits | |
| PARENTS_WELFARE_TRANSFER | NUMBER | (15) | Holds parents welfare transfer | |
| PARENTS_CHILD_SUPPARENTS_RCVD | NUMBER | (15) | Holds children support received | |
| PARENTS_DEDUCTIONS_IRA_KEOGH | NUMBER | (15) | Deductions IRA KEOGH | |
| PARENTS_TAX_DEFER_PENSION_SAVS | NUMBER | (15) | Holds parents tax defer pension savings | |
| PARENTS_DEP_CARE_MED_SPENDING | NUMBER | (15) | Describes dependents care medical spending | |
| PARENTS_EARNED_INCOME_CREDIT | NUMBER | (15) | Holds parents earned income credit | |
| PARENTS_LIVING_ALLOWANCE | NUMBER | (15) | Parents living allowance | |
| PARENTS_TAX_EXEMPT_INTEREST | NUMBER | (15) | tax exempt interest | |
| PARENTS_FOREIGN_INC_EXCLUSION | NUMBER | (15) | Holds parents foreign income exclusion | |
| PARENTS_OTHER_UNTAX_INCOME | NUMBER | (15) | Contains other untaxed income | |
| PARENTS_HOPE_LL_CREDIT | NUMBER | (15) | Holds parents hope LL credit | |
| PARENTS_YEAR_SEPARATION | NUMBER | (15) | Holds parents year separation | |
| PARENTS_YEAR_DIVORCE | NUMBER | (15) | Holds parents year divorce | |
| PARENTS_EXPECTED_FATHER_INC | NUMBER | (15) | Holds expected father income | |
| PARENTS_EXPECTED_MOTHER_INC | NUMBER | (15) | Holds expected mother income | |
| PARENTS_EXPECTED_OTHER_TAX_INC | NUMBER | (15) | Contains expected other tax income | |
| PARENTS_EXPECTED_OTHR_UNTX_INC | NUMBER | (15) | Contains expected other untaxed income | |
| _LA:LINE_2_RELATION | CHAR | (66) | Holds line relation | |
| _LA:LINE_2_ATTEND_COLLEGE | CHAR | (71) | Contains line attend college | |
| _LA:LINE_3_RELATION | CHAR | (66) | Holds line relation | |
| _LA:LINE_3_ATTEND_COLLEGE | CHAR | (71) | Contains line attend college | |
| _LA:LINE_4_RELATION | CHAR | (66) | Holds line relation | |
| _LA:LINE_4_ATTEND_COLLEGE | CHAR | (71) | Contains line attend college | |
| _LA:LINE_5_RELATION | CHAR | (66) | Holds line relation | |
| _LA:LINE_5_ATTEND_COLLEGE | CHAR | (71) | Contains line attend college | |
| _LA:LINE_6_RELATION | CHAR | (66) | Holds line relation | |
| _LA:LINE_6_ATTEND_COLLEGE | CHAR | (71) | Contains line attend college | |
| _LA:LINE_7_RELATION | CHAR | (66) | Holds line relation | |
| _LA:LINE_7_ATTEND_COLLEGE | CHAR | (71) | Contains line attend college | |
| _LA:LINE_8_RELATION | CHAR | (66) | Holds line relation | |
| _LA:LINE_8_ATTEND_COLLEGE | CHAR | (71) | Contains line attend college | |
| PARENTS_AGE_FATHER | VARCHAR2 | (2) | Holds age of father | |
| PARENTS_AGE_MOTHER | VARCHAR2 | (2) | Holds age of mother | |
| PARENTS_DIVORCE_SEPERATION | VARCHAR2 | (30) | Holds parents divorce or separation indicator | |
| NON_CUSTODIAL_PARENTS_CONTRIB | VARCHAR2 | (6) | Contribution of non custodial parents | |
| _LA:COLLEGE_2_TYPE | CHAR | (61) | Describes the College type | |
| _LA:COLLEGE_3_TYPE | CHAR | (61) | Describes the College type | |
| _LA:COLLEGE_4_TYPE | CHAR | (61) | Describes the College type | |
| _LA:COLLEGE_5_TYPE | CHAR | (61) | Describes the College type | |
| _LA:COLLEGE_6_TYPE | CHAR | (61) | Describes the College type | |
| _LA:COLLEGE_7_TYPE | CHAR | (61) | Describes the College type | |
| _LA:COLLEGE_8_TYPE | CHAR | (61) | Describes the College type | |
| SCHOOL_1_CODE | VARCHAR2 | (4) | Contains School code | |
| _LA:HOUSING_1_CODE | CHAR | (67) | Contains housing code | |
| SCHOOL_2_CODE | VARCHAR2 | (4) | Contains School code | |
| _LA:HOUSING_2_CODE | CHAR | (67) | Contains housing code | |
| SCHOOL_3_CODE | VARCHAR2 | (4) | Contains School code | |
| _LA:HOUSING_3_CODE | CHAR | (67) | Contains housing code | |
| SCHOOL_4_CODE | VARCHAR2 | (4) | Contains School code | |
| _LA:HOUSING_4_CODE | CHAR | (67) | Contains housing code | |
| SCHOOL_5_CODE | VARCHAR2 | (4) | Contains School code | |
| _LA:HOUSING_5_CODE | CHAR | (67) | Contains housing code | |
| SCHOOL_6_CODE | VARCHAR2 | (4) | Contains School code | |
| _LA:HOUSING_6_CODE | CHAR | (67) | Contains housing code | |
| SCHOOL_7_CODE | VARCHAR2 | (4) | Contains School code | |
| _LA:HOUSING_7_CODE | CHAR | (67) | Contains housing code | |
| SCHOOL_8_CODE | VARCHAR2 | (4) | Contains School code | |
| _LA:HOUSING_8_CODE | CHAR | (67) | Contains housing code | |
| SCHOOL_9_CODE | VARCHAR2 | (4) | Contains School code | |
| _LA:HOUSING_9_CODE | CHAR | (67) | Contains housing code | |
| SCHOOL_10_CODE | VARCHAR2 | (4) | Contains School code | |
| _LA:HOUSING_10_CODE | CHAR | (68) | Contains housing code | |
| ADDITIONAL_SCHOOL_1_CODE | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_2_CODE | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_3_CODE | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_4_CODE | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_5_CODE | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_6_CODE | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_7_CODE | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_8_CODE | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_9_CODE | VARCHAR2 | (4) | Holds the additional school code | |
| ADDITIONAL_SCHOOL_10_CODE | VARCHAR2 | (4) | Holds the additional school code | |
| EXPLANATION_SPECIAL_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_NUMBER | NUMBER | (15) | Holds Age line | |
| AGE_LINE_3_NUMBER | NUMBER | (15) | Holds Age line | |
| AGE_LINE_4_NUMBER | NUMBER | (15) | Holds Age line | |
| AGE_LINE_5_NUMBER | NUMBER | (15) | Holds Age line | |
| AGE_LINE_6_NUMBER | NUMBER | (15) | Holds Age line | |
| AGE_LINE_7_NUMBER | NUMBER | (15) | Holds Age line | |
| AGE_LINE_8_NUMBER | NUMBER | (15) | Holds Age line | |
| A_ONLINE_SIGNATURE | VARCHAR2 | (30) | Holds Online Signature | |
| QUESTION_1_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_1_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_1_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_2_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_2_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_2_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_3_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_3_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_3_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_4_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_4_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_4_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_5_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_5_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_5_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_6_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_6_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_6_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_7_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_7_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_7_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_8_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_8_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_8_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_9_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_9_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_9_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_10_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_10_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_10_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_11_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_11_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_11_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_12_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_12_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_12_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_13_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_13_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_13_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_14_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_14_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_14_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_15_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_15_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_15_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_16_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_16_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_16_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_17_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_17_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_17_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_18_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_18_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_18_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_19_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_19_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_19_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_20_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_20_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_20_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_21_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_21_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_21_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_22_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_22_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_22_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_23_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_23_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_23_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_24_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_24_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_24_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_25_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_25_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_25_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_26_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_26_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_26_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_27_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_27_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_27_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_28_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_28_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_28_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_29_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTION_29_SIZE | NUMBER | (15) | Describes Question size | |
| QUESTION_29_ANSWER | VARCHAR2 | (20) | Describes answer to the question | |
| QUESTION_30_NUMBER | VARCHAR2 | (3) | Holds question number | |
| QUESTIONS_30_SIZE | NUMBER | (15) | 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_CD | VARCHAR2 | (4) | Holds the EPS code | |
| _LA:COMP_CSS_DEPNDNCY_STATUS | CHAR | (80) | Describes computed CSS dependency status | |
| STUDENTS_AGE | VARCHAR2 | (2) | Holds student age | |
| ASSUMED_STUDENT_YR_IN_COLLEGE | VARCHAR2 | (30) | Assumed student year in college | |
| COMP_STUDENT_MARITAL_STATUS | VARCHAR2 | (30) | Holds computed student marital status | |
| STUDENT_FAMILY_MEMBERS | NUMBER | (15) | Holds student family members | |
| STUDENT_FAM_MEMBERS_IN_COLLEGE | NUMBER | (15) | Holds student family members in college | |
| PARENTS_FAMILY_MEMBERS | NUMBER | (15) | Holds parents family members | |
| PARENTS_TOTAL_IN_COLLEGE | NUMBER | (15) | Holds parents total in college | |
| PARENTS_PAR_IN_COLLEGE | NUMBER | (15) | Holds parents of parents in college | |
| PARENTS_OTHERS_IN_COLLEGE | NUMBER | (15) | Holds parents others in college | |
| PARENTS_AESA | NUMBER | (15) | Holds the parents AESA | |
| PARENTS_CESA | NUMBER | (15) | Holds the parents CESA | |
| STUDENT_AESA | NUMBER | (15) | Holds the students AESA | |
| STUDENT_CESA | NUMBER | (15) | Holds the students CESA | |
| IM_PARENTS_BAS_AGI_TAXABLE_INC | NUMBER | (15) | Parents basic adjust gross income taxable | |
| IM_PARENTS_BAS_UNTX_INC_BENEFT | NUMBER | (15) | Holds Parents basic untaxed income and benefits | |
| IM_PARENTS_BASE_INCOME_ADJUST | NUMBER | (15) | Holds parents basic income adjust | |
| IM_PARENTS_BASE_TOTAL_INCOME | NUMBER | (15) | Holds parents basic total income | |
| IM_PARENTS_BASE_US_INCOME_TAX | NUMBER | (15) | Holds parents basic us income tax | |
| IM_PARENTS_BAS_ST_AND_OTHR_TAX | NUMBER | (15) | Holds parents basic state and other taxes | |
| IM_PARENTS_BAS_FICA_TAX | NUMBER | (15) | Holds parents basic FICA tax | |
| IM_PARENTS_BAS_MED_DENTAL | NUMBER | (15) | Holds parents basic medical and dental | |
| IM_PARENTS_BAS_EMPLOYMET_ALOW | NUMBER | (15) | Holds parents basic employment allowance | |
| IM_PARENTS_BAS_ANNUAL_ED_SAVS | NUMBER | (15) | Holds parents basic annual education savings | |
| IM_PARENTS_BAS_INC_PROT_ALLOW | NUMBER | (15) | Holds parents basic income protection allowance or MMA | |
| IM_PARENTS_BAS_TOTAL_INC_ALLOW | NUMBER | (15) | Holds parents basic total income allowance | |
| IM_PARENTS_BASE_CAL_AVAIL_INC | NUMBER | (15) | Holds parents basic calculated available income | |
| IM_PARENTS_BASE_AVAIL_INCOME | NUMBER | (15) | Holds parents basic available income | |
| IM_PARENTS_BAS_TOTAL_CONT_INC | NUMBER | (15) | Holds parents basic total contribution income | |
| IM_PARENTS_BAS_CASH_BANK_ACCNT | NUMBER | (15) | Holds parents basic cash bank accounts | |
| IM_PARENTS_BASE_HOME_EQUITY | NUMBER | (15) | Holds parents basic home equity | |
| IM_PARENTS_BAS_OT_RLEST_INV_EQ | NUMBER | (15) | Holds other parents basic real estate invest equity | |
| IM_PARENTS_BAS_ADJ_BUS_FRM_WTH | NUMBER | (15) | Holds parents basic adjust business farm worth | |
| IM_PARENTS_BAS_ASS_SIB_PRE_TUI | NUMBER | (15) | Holds parents basic assets siblings or pre tuition | |
| IM_PARENTS_BAS_NET_WORTH | NUMBER | (15) | Holds parents basic net worth | |
| IM_PARENTS_BAS_EMERG_RES_ALLOW | NUMBER | (15) | Holds parents basic emergency reserve allowance | |
| IM_PARENTS_BAS_CUM_ED_SAVINGS | NUMBER | (15) | Holds parents basic cumulative education savings | |
| IM_PARENTS_BAS_LOW_INC_ALLOW | NUMBER | (15) | Holds parents basic low income allowance | |
| IM_PARENTS_BAS_TOTAL_AST_ALLOW | NUMBER | (15) | Holds parents basic total asset allowance | |
| IM_PARENTS_BAS_DISC_NET_WORTH | NUMBER | (15) | Holds parents basic discretionary net worth | |
| IM_PARENTS_BAS_TOTL_CONT_ASSET | NUMBER | (15) | Holds parents basic total contribution asset | |
| IM_PARENTS_BAS_TOTAL_CONT | NUMBER | (15) | Holds parents basic total contribution | |
| IM_PARENTS_BAS_NUM_IN_COLL_ADJ | NUMBER | (12) | Holds parents basic number in college adjustment | |
| IM_PARENTS_BAS_CONT_FOR_STU | NUMBER | (15) | Holds parents basic contribution for student | |
| IM_PARENTS_BAS_CONT_FROM_INC | NUMBER | (15) | Parents optional contribution from income | |
| IM_PARENTS_BAS_CONT_FROM_ASETS | NUMBER | (15) | Holds parents basic contribution from assets | |
| IM_PARENTS_OPT_AGI_TAX_INCOME | NUMBER | (15) | Holds parents optional adjust gross income taxable | |
| IM_PARENTS_OPT_UNTX_INC_BEN | NUMBER | (15) | Holds parents optional untaxed income and benefits | |
| IM_PARENTS_OPT_INC_ADJUSTABLE | NUMBER | (15) | Holds parents optional income adjustable | |
| IM_PARENTS_OPT_TOTAL_INCOME | NUMBER | (15) | Holds parents optional total income | |
| IM_PARENTS_OPT_US_INCOME_TAX | NUMBER | (15) | Holds parents optional US income tax | |
| IM_PARENTS_OPT_ST_AND_OTHR_TAX | NUMBER | (15) | Holds parents optional state and other taxes | |
| IM_PARENTS_OPT_FICA_TAX | NUMBER | (15) | Holds parents optional FICA tax | |
| IM_PARENTS_OPT_MED_DENTAL | NUMBER | (15) | Holds parents optional medical or dental | |
| IM_PARENTS_OPT_ELEM_SEC_TUIT | NUMBER | (15) | Holds parents optional elementary or secondary tuition | |
| IM_PARENTS_OPT_EMPLOYMENT_ALOW | NUMBER | (15) | Holds Parents optional employment allowance | |
| IM_PARENTS_OPT_ANNUAL_ED_SAVNG | NUMBER | (15) | Holds parents optional annual educational savings | |
| IM_PARENTS_OPT_INC_PROT_ALOW_M | NUMBER | (15) | Holds parents optional income protection allowance or MMA | |
| IM_PARENTS_OPT_TOTAL_INC_ALLOW | NUMBER | (15) | Holds parents optional total income allowance | |
| IM_PARENTS_OPT_CAL_AVAIL_INC | NUMBER | (15) | Holds parents optional calculated available income | |
| IM_PARENTS_OPT_AVAIL_INCOME | NUMBER | (15) | Holds parents optional available income | |
| IM_PARENTS_OPT_TOTAL_CONT_INC | NUMBER | (15) | Holds parents optional total contribution income | |
| IM_PARENTS_OPT_CASH_BANK_ACCNT | NUMBER | (15) | Holds parents optional cash bank accounts | |
| IM_PARENTS_OPT_HOME_EQUITY | NUMBER | (15) | Holds parents optional home equity | |
| IM_PARENTS_OPT_OT_RL_EST_INVEQ | NUMBER | (15) | Holds other Parents optional real estate investment equity | |
| IM_PARENTS_OPT_ADJ_FARM_WORTH | NUMBER | (15) | Holds parents optional adjust business farm worth | |
| IM_PARENTS_OPT_ASS_SIBS_PRE_T | NUMBER | (15) | Holds parents optional assets siblings pre tuition | |
| IM_PARENTS_OPT_NET_WORTH | NUMBER | (15) | Holds parents optional net worth | |
| IM_PARENTS_OPT_EMERG_RES_ALLOW | NUMBER | (15) | Holds parents optional emergency residence allowance | |
| IM_PARENTS_OPT_CUM_ED_SAVINGS | NUMBER | (15) | Holds parents optional cumulative education savings | |
| IM_PARENTS_OPT_LOW_INC_ALLOW | NUMBER | (15) | Holds parents optional low income allowance | |
| IM_PARENTS_OPT_TOTAL_ASET_ALOW | NUMBER | (15) | Contains the parents optional total asset allowance | |
| IM_PARENTS_OPT_DISC_NET_WORTH | NUMBER | (15) | Contains the parents optional discretionary net worth | |
| IM_PARENTS_OPT_TOTAL_CONT_ASET | NUMBER | (15) | Contains the parents optional total contribution asset | |
| IM_PARENTS_OPT_TOTAL_CONT | NUMBER | (15) | Contains the parents optional total contribution | |
| IM_PARENTS_OPT_NUM_IN_COLL_ADJ | NUMBER | (15) | Contains the parents optional number in college adjust | |
| IM_PARENTS_OPT_CONT_FOR_STU | NUMBER | (15) | Contains the parents optional contribution for student | |
| IM_PARENTS_OPT_CONT_FROM_INCOM | NUMBER | (15) | Contains the parents optional contribution from income | |
| IM_PARENTS_OPT_CONT_FROM_ASETS | NUMBER | (15) | Contains the parents optional contribution from assets | |
| FM_PARENTS_ANALYSIS_TYPE | VARCHAR2 | (30) | Contains the parents analysis type | |
| FM_PARENTS_AGI_TAXABLE_INCOME | NUMBER | (15) | Contains the parents adjust gross income taxable | |
| FM_PARENTS_UNTX_INC_AND_BENEF | NUMBER | (15) | Contains the parents untaxed income and benefits | |
| FM_PARENTS_INCOME_ADJUST | NUMBER | (15) | Holds the Parents income adjust | |
| FM_PARENTS_TOTAL_INCOME | NUMBER | (15) | Contains the parents total income | |
| FM_PARENTS_US_INCOME_TAX | NUMBER | (15) | Contains the parents US income tax | |
| FM_PARENTS_STATE_AND_OTHER_TAX | NUMBER | (15) | Contains the parents state and other taxes | |
| FM_PARENTS_FICA_TAX | NUMBER | (15) | Contains the parents FICA tax | |
| FM_PARENTS_EMPLOYMENT_ALLOW | NUMBER | (15) | Contains the parents employment allowance | |
| FM_PARENTS_INCOME_PROT_ALLOW | NUMBER | (15) | Contains the parents income protection allowance | |
| FM_PARENTS_TOTAL_ALLOW | NUMBER | (15) | Contains the parents total allowance | |
| FM_PARENTS_AVAIL_INCOME | NUMBER | (15) | Contains the parents total allowance | |
| FM_PARENTS_CASH_BANK_ACCOUNTS | NUMBER | (15) | Contains the parents cash bank accounts | |
| FM_PARENTS_OT_RL_EST_INV_EQ | NUMBER | (15) | Contains the parents other real estate investment equity | |
| FM_PARENTS_ADJ_FARM_NET_WORTH | NUMBER | (15) | Contains the parents adjust business farm net worth | |
| FM_PARENTS_NET_WORTH | NUMBER | (15) | Contains the parents net worth | |
| FM_PARENTS_ASSET_PROT_ALLOW | NUMBER | (15) | Contains the parents asset protection allowance | |
| FM_PARENTS_DISC_NET_WORTH | NUMBER | (15) | Contains the parents discretionary net worth | |
| FM_PARENTS_TOTAL_CONTRIBUTION | NUMBER | (15) | Contains the parents total contribution | |
| FM_PARENTS_NUM_IN_COLL_NUM | NUMBER | (15) | Contains the parents number in college | |
| FM_PARENTS_CONTRIB_FOR_STUDENT | NUMBER | (15) | Contains the parents contribution for student | |
| FM_PARENTS_CONTRIB_FROM_INCOME | NUMBER | (15) | Holds the students contribution from income | |
| FM_PARENTS_CONTRIB_FROM_ASSETS | NUMBER | (15) | Holds the parents contribution from assets | |
| IM_STUDENTS_BAS_AGI_TAX_INCOME | NUMBER | (15) | Holds the students basic adjust gross income taxable | |
| IM_STUDENTS_BAS_UNTX_INC_BEN | NUMBER | (15) | Holds the students basic untaxed income and benefits | |
| IM_STUDENTS_BAS_INC_ADJ | NUMBER | (15) | Holds the students basic income adjust | |
| IM_STUDENTS_BAS_TOTAL_INCOME | NUMBER | (15) | Holds the students basic total income | |
| IM_STUDENTS_BAS_US_INCOME_TAX | NUMBER | (15) | Holds the students basic US income tax | |
| IM_STUDENTS_BAS_ST_AND_OTH_TAX | NUMBER | (15) | Holds the students basic state and other taxes | |
| IM_STUDENTS_BAS_FICA_TAX | NUMBER | (15) | Holds the students basic FICA tax | |
| IM_STUDENTS_BAS_MED_DENTAL | NUMBER | (15) | Holds the students basic medical or dental | |
| IM_STUDENTS_BAS_EMPLOYMEN_ALOW | NUMBER | (15) | Holds the students basic employment allowance | |
| IM_STUDENTS_BAS_ANNUAL_ED_SAVS | NUMBER | (15) | Holds the students basic annual education savings | |
| IM_STUDENTS_BAS_INC_PROT_ALLOM | NUMBER | (15) | Holds the students basic income protection allowance or MMA | |
| IM_STUDENTS_BAS_TOTAL_INC_ALLW | NUMBER | (15) | Holds the students basic total income allowance | |
| IM_STUDENTS_BAS_CAL_AVAIL_INC | NUMBER | (15) | Holds the students basic calculated available income | |
| IM_STUDENTS_BAS_AVAIL_INCOME | NUMBER | (15) | Holds the students basic available income | |
| IM_STUDENTS_BAS_TOTAL_CONT_INC | NUMBER | (15) | Holds the students basic total contribution income | |
| IM_STUDENTS_BAS_CASH_BANK_ACCT | NUMBER | (15) | Holds the students basic cash bank accounts | |
| IM_STUDENTS_BAS_HOME_EQUITY | NUMBER | (15) | Holds the students basic home equity | |
| IM_STUDENTS_BAS_OT_RL_EST_INVQ | NUMBER | (15) | Holds the students basic or estimated investment equity | |
| IM_STUDENTS_BAS_ADJ_FARM_WORTH | NUMBER | (15) | Holds the students basic adjust business farm worth | |
| IM_STUDENTS_BAS_TRUSTS | NUMBER | (15) | Holds the students basic trusts | |
| IM_STUDENTS_BAS_NET_WORTH | NUMBER | (15) | Holds the students basic net worth | |
| IM_STUDENTS_BAS_EMERG_RES_ALLW | NUMBER | (15) | Holds the students basic emergency residence allowance | |
| IM_STUDENTS_BAS_CUM_ED_SAVINGS | NUMBER | (15) | Holds the students basic cumulative education savings | |
| IM_STUDENTS_BAS_TOT_ASSET_ALOW | NUMBER | (15) | Holds the students basic total asset allowance | |
| IM_STUDENTS_BAS_DISC_NET_WORTH | NUMBER | (15) | Holds the students basic discretionary net worth | |
| IM_STUDENTS_BAS_TOTAL_CONT_AST | NUMBER | (15) | Holds the students basic total contribution asset | |
| IM_STUDENTS_BAS_TOTAL_CONT | NUMBER | (15) | Holds the students basic total contribution | |
| IM_STUDENTS_BAS_NUM_IN_COL_ADJ | NUMBER | (13) | Holds the students basic number in college adjust | |
| IM_STUDENTS_BAS_CONT_FOR_STU | NUMBER | (15) | Holds the students basic contribution for student | |
| IM_STUDENTS_BAS_CONT_FROM_INC | NUMBER | (15) | Holds the students basic contribution from income | |
| IM_STUDENTS_BAS_CONT_FROM_AETS | NUMBER | (15) | Holds the students basic contribution from assets | |
| IM_STUDENTS_EST_AGI_TAX_INCOME | NUMBER | (15) | Holds the students estimated adjust gross taxable income | |
| IM_STUDENTS_EST_UNTX_INC_BEN | NUMBER | (15) | Holds the students estimated untaxed income and benefits | |
| IM_STUDENTS_EST_INC_ADJ | NUMBER | (15) | Holds the students estimated income adjust | |
| IM_STUDENTS_EST_TOTAL_INCOME | NUMBER | (15) | Holds the students estimated total income | |
| IM_STUDENTS_EST_US_INCOME_TAX | NUMBER | (15) | Holds the students estimated US income tax | |
| IM_STUDENTS_EST_ST_AND_OTH_TAX | NUMBER | (15) | Holds the students estimated state and other taxes | |
| IM_STUDENTS_EST_FICA_TAX | NUMBER | (15) | Holds the students estimated FICA tax | |
| IM_STUDENTS_EST_MED_DENTAL | NUMBER | (15) | Holds the students estimated medical and dental | |
| IM_STUDENTS_EST_EMPLOYMEN_ALOW | NUMBER | (15) | Holds the students estimated employment allowance | |
| IM_STUDENTS_EST_ANNUAL_ED_SAVS | NUMBER | (15) | Holds the students estimated annual education savings | |
| IM_STUDENTS_EST_INC_PROT_ALLOM | NUMBER | (15) | Holds the students estimated income protection allowance or MMA | |
| IM_STUDENTS_EST_TOTAL_INC_ALOW | NUMBER | (15) | Holds the students estimated total income allowance | |
| IM_STUDENTS_EST_CAL_AVAIL_INCE | NUMBER | (15) | Holds the students estimated calculated available income | |
| IM_STUDENTS_EST_AVAIL_INCOME | NUMBER | (15) | Holds the students estimated available income | |
| IM_STUDENTS_EST_TOTAL_CONT_INC | NUMBER | (15) | Holds the students estimated total contribution income | |
| IM_STUDENTS_EST_CASH_BANK_ACCT | NUMBER | (15) | Holds the students estimated cash bank accounts | |
| IM_STUDENTS_EST_HOME_EQUITY | NUMBER | (15) | Holds the students estimated home equity | |
| IM_STUDENTS_EST_OT_RL_EST_INVU | NUMBER | (15) | Holds the students estimated other real estate investment equity | |
| IM_STUDENTS_EST_ADJ_FARM_WORTH | NUMBER | (15) | Holds the students estimated adjust business farm worth | |
| IM_STUDENTS_EST_EST_TRUSTS | NUMBER | (15) | Holds the students estimated trusts | |
| IM_STUDENTS_EST_NET_WORTH | NUMBER | (15) | Holds the students estimated net worth | |
| IM_STUDENTS_EST_EMERG_RES_ALOW | NUMBER | (15) | Holds the students estimated emergency residence allowance | |
| IM_STUDENTS_EST_CUM_ED_SAVINGS | NUMBER | (15) | Holds the students estimated cumulative education savings | |
| IM_STUDENTS_EST_TOTL_ASET_ALOW | NUMBER | (15) | Holds the students estimated total asset allowance | |
| IM_STUDENTS_EST_DISC_NET_WORTH | NUMBER | (15) | Holds the students estimated discretionary net worth | |
| IM_STUDENTS_EST_TOTL_CONT_ASET | NUMBER | (15) | Holds the students estimated total contribution asset | |
| IM_STUDENTS_EST_TOTAL_CONTRIB | NUMBER | (15) | Holds the students estimated total contribution | |
| IM_STUDENTS_EST_NUM_IN_COL_ADJ | NUMBER | (13) | students estimated number in college adjust | |
| IM_STUDENTS_EST_CONT_FOR_STU | NUMBER | (15) | Holds the students estimated contribution for student | |
| IM_STUDENTS_EST_CONT_FROM_INC | NUMBER | (15) | Holds the students estimated contribution from income | |
| IM_STUDENTS_EST_CONT_FROM_ASET | NUMBER | (15) | Holds the students estimated contribution from assets | |
| IM_STUDENTS_OPT_AGI_TAX_INCOME | NUMBER | (15) | Holds the students optional adjust gross taxable income | |
| IM_STUDENTS_OPT_UNTX_INC_BEN | NUMBER | (15) | students optional untaxed income and benefits | |
| IM_STUDENTS_OPT_INC_ADJ | NUMBER | (15) | Holds the students optional income adjust | |
| IM_STUDENTS_OPT_TOTAL_INCOME | NUMBER | (15) | Holds the students optional total income | |
| IM_STUDENTS_OPT_US_INCOME_TAX | NUMBER | (15) | Holds the students optional US income tax | |
| IM_STUDENTS_OPT_STATE_OTH_TAXS | NUMBER | (15) | Holds the students optional state and other taxes | |
| IM_STUDENTS_OPT_FICA_TAX | NUMBER | (15) | Holds the students optional FICA tax | |
| IM_STUDENTS_OPT_MED_DENTAL | NUMBER | (15) | Holds the students optional medical or dental | |
| IM_STUDENTS_OPT_EMPLOYMEN_ALOW | NUMBER | (15) | Holds the students optional employment allowance | |
| IM_STUDENTS_OPT_ANNUAL_ED_SAVS | NUMBER | (15) | Holds the students optional annual education savings | |
| IM_STUDENTS_OPT_INC_PROT_ALOWM | NUMBER | (15) | Holds the students optional annual education savings | |
| IM_STUDENTS_OPT_TOTAL_INC_ALOW | NUMBER | (15) | Holds the students optional total income allow | |
| IM_STUDENTS_OPT_CAL_AVAIL_INC | NUMBER | (15) | Holds the students optional calculated available income | |
| IM_STUDENTS_OPT_AVAIL_INCOME | NUMBER | (15) | Holds the students optional available income | |
| IM_STUDENTS_OPT_TOTAL_CONT_INC | NUMBER | (15) | Holds the students optional total contribution income | |
| IM_STUDENTS_OPT_CASH_BANK_ACNT | NUMBER | (15) | Holds the students optional cash bank accounts | |
| IM_STUDENTS_OPT_IRA_KEOGH_ACNT | NUMBER | (15) | Holds the students optional IRA KEOGH accounts | |
| IM_STUDENTS_OPT_HOME_EQUITY | NUMBER | (15) | Holds the students optional home equity | |
| IM_STUDENTS_OPT_OT_RL_EST_INVQ | NUMBER | (15) | Holds the students optional other real estate investment equity | |
| IM_STUDENTS_OPT_ADJ_BUS_FORM | NUMBER | (15) | Holds the students optional adjust business farm worth | |
| IM_STUDENTS_OPT_TRUSTS | NUMBER | (15) | Holds the students optional trusts | |
| IM_STUDENTS_OPT_NET_WORTH | NUMBER | (15) | Holds the students optional net worth | |
| IM_STUDENTS_OPT_EMERG_RES_ALOW | NUMBER | (15) | Holds the students optional emergency residence allowance | |
| IM_STUDENTS_OPT_CUM_ED_SAVINGS | NUMBER | (15) | Holds the student optional cumulative education savings | |
| IM_STUDENTS_OPT_TOTL_ASET_ALOW | NUMBER | (15) | Holds the students optional total asset allowance | |
| IM_STUDENTS_OPT_DISC_NET_WORTH | NUMBER | (15) | Holds the students estimated discretionary net worth | |
| IM_STUDENTS_OPT_TOTL_CONT_ASET | NUMBER | (15) | Holds the students optional total contribution asset | |
| IM_STUDENTS_OPT_TOTAL_CONT | NUMBER | (15) | Holds the students optional total contribution | |
| IM_STUDENTS_OPT_NUM_IN_COL_ADJ | NUMBER | (15) | Holds the students optional number in college adjust | |
| IM_STUDENTS_OPT_CONT_FOR_STU | NUMBER | (15) | Holds the students optional contribution for student | |
| IM_STUDENTS_OPT_CONT_FROM_INC | NUMBER | (15) | Holds the students optional contribution from income | |
| IM_STUDENTS_OPT_CONT_FROM_ASET | NUMBER | (15) | Holds the students optional contribution from assets | |
| FM_STUDENTS_ANALYSIS_TYPE | VARCHAR2 | (30) | Holds the analysis type | |
| FM_STUDENTS_AGI_TAXABLE_INCOME | NUMBER | (15) | Holds the students adjust gross income taxable | |
| FM_STUDENTS_UNTX_INC_AND_BEN | NUMBER | (15) | Holds the students untaxed income and benefits | |
| FM_STUDENTS_INC_ADJ | NUMBER | (15) | Holds the students income adjust | |
| FM_STUDENTS_TOTAL_INCOME | NUMBER | (15) | Holds the students total income | |
| FM_STUDENTS_US_INCOME_TAX | NUMBER | (15) | Holds the students US income tax | |
| FM_STUDENTS_STATE_AND_OTH_TAX | NUMBER | (15) | Holds the students state and other taxes | |
| FM_STUDENTS_FICA_TAX | NUMBER | (15) | Holds the students FICA tax | |
| FM_STUDENTS_EMPLOYMENT_ALLOW | NUMBER | (15) | Holds the students employment allowance | |
| FM_STUDENTS_INCOME_PROT_ALLOW | NUMBER | (15) | Holds the students income protection allowance | |
| FM_STUDENTS_TOTAL_ALLOW | NUMBER | (15) | Holds the students total allowance | |
| FM_STUDENTS_CAL_AVAIL_INCOME | NUMBER | (15) | Holds the students calculated available income | |
| FM_STUDENTS_AVAIL_INCOME | NUMBER | (15) | Holds the students available income | |
| FM_STUDENTS_CASH_BANK_ACCOUNTS | NUMBER | (15) | Holds the students cash bank accounts | |
| FM_STUDENTS_OT_RL_EST_INV_EQUY | NUMBER | (15) | Holds the students other real estate investment equity | |
| FM_STUDENTS_ADJ_BUS_FARM_WORTH | NUMBER | (15) | Describes the Students net worth from adjust business farm | |
| FM_STUDENTS_TRUSTS | NUMBER | (15) | Holds the students trusts | |
| FM_STUDENTS_NET_WORTH | NUMBER | (15) | Holds the students net worth | |
| FM_STUDENTS_ASSET_PROT_ALLOW | NUMBER | (15) | Holds the students asset protection allowance | |
| FM_STUDENTS_DISC_NET_WORTH | NUMBER | (15) | Holds the students discretionary net worth | |
| FM_STUDENTS_TOTAL_CONT | NUMBER | (15) | Holds the students total contribution | |
| FM_STUDENTS_NUM_IN_COLL_NUM | NUMBER | (15) | Holds the students number in college | |
| FM_STUDENTS_CONT_FOR_STUDENT | NUMBER | (15) | Holds the students contribution for student | |
| FM_STUDENTS_CONT_FROM_INCOME | NUMBER | (15) | Holds the students contribution from income | |
| FM_STUDENTS_CONT_FROM_ASSETS | NUMBER | (15) | Holds the students contribution from assets | |
| IM_INSTITUTIONAL_RESIDENT_FLAG | VARCHAR2 | (30) | Describes the institutional resident indicator | |
| INSTITUTIONAL_1_BUDGET_NAME | VARCHAR2 | (7) | Describes the institutional budget name | |
| IM_INSTIT_BUDGET_DURATION | NUMBER | (15) | Describes the institutional budget duration | |
| IM_INSTITUTION_1_TUITION_FEES | NUMBER | (15) | Describes the institutional tuition fees | |
| IM_INST_1_BOOKS_SUPPLIES | NUMBER | (15) | Describes the institutional books supplies | |
| IM_INST_1_LIVING_EXPENSES | NUMBER | (15) | Describes the institutional living expenses | |
| IM_INST_1_TOTAL_EXPENSES | NUMBER | (15) | Describes the institutional total expenses | |
| IM_INST_1_TOTL_STUDENT_CONTRIB | NUMBER | (15) | Describes the institutional total student contribution | |
| IM_INST_1_TOT_PARENTS_CONTRIB | NUMBER | (15) | Describes the institutional total parent contribution | |
| IM_INST_1_TOT_FAMILY_CONTRIB | NUMBER | (15) | Describes the institutional total family contribution | |
| IM_INST_1_VA_BENEFITS | NUMBER | (15) | Describes the institutional veteran benefits | |
| IM_INST_1_OTHER_CONTRIBUTIONS | NUMBER | (15) | Describes the institutional other contribution | |
| IM_INST_1_EST_FINANCIAL_NEED | NUMBER | (15) | Describes the institutional estimated financial need | |
| INSTITUTIONAL_2_BUDGET | VARCHAR2 | (7) | Describes the institutional budget name | |
| IM_INST_2_BUDGET_DURATION | VARCHAR2 | (2) | Describes the institutional budget duration | |
| IM_INST_2_TUITION_FEES | NUMBER | (15) | Describes the institutional tuition fees | |
| IM_INST_2_BOOKS_SUPPLIES | NUMBER | (15) | Describes the institutional books supplies | |
| IM_INST_2_LIVING_EXPENSES | NUMBER | (15) | Describes the institutional living expenses | |
| IM_INST_2_TOTAL_EXPENSES | NUMBER | (15) | Describes the institutional total expenses | |
| IM_INST_2_TOT_STUDENTS_CONTRIB | NUMBER | (15) | Describes the institutional total student contribution | |
| IM_INST_2_TOT_PARENTS_CONTRIB | NUMBER | (15) | Describes the institutional total parent contribution | |
| IM_INST_2_TOT_FAMILY_CONTRIB | NUMBER | (15) | Describes the institutional total family contribution | |
| IM_INST_2_VA_BENEFITS | NUMBER | (15) | Describes the institutional veteran benefits | |
| IM_INST_2_EST_FINANCIAL_NEED | NUMBER | (15) | Describes the institutional estimated financial need | |
| INSTITUTIONAL_3_BUDGET | VARCHAR2 | (7) | Describes the institutional budget name | |
| IM_INST_3_BUDGET_DURATION | NUMBER | (15) | Describes the institutional budget duration | |
| IM_INST_3_TUITION_FEES | NUMBER | (15) | Describes the institutional tuition fees | |
| IM_INST_3_BOOKS_SUPPLIES | NUMBER | (15) | Describes the institutional books supplies | |
| IM_INST_3_LIVING_EXPENSES | NUMBER | (15) | Describes the institutional living expenses | |
| IM_INST_3_TOTAL_EXPENSES | NUMBER | (15) | Describes the institutional total expenses | |
| IM_INST_3_TOT_STUDENTS_CONTRIB | NUMBER | (15) | Describes the institutional total student contribution | |
| IM_INST_3_TOT_PARENTS_CONTRIB | NUMBER | (15) | Describes the institutional total parent contribution | |
| IM_INST_3_TOT_FAMILY_CONTRIB | NUMBER | (15) | Describes the institutional total family contribution | |
| IM_INST_3_VA_BENEFITS | NUMBER | (15) | Describes the institutional veteran benefits | |
| IM_INST_3_EST_FINANCIAL_NEED | NUMBER | (15) | 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_FEDERAL_ELIGIBILITY | VARCHAR2 | (5) | Describes the institutional federal eligibility | |
| FM_INST_1_PELL | VARCHAR2 | (4) | Holds the institution Pell | |
| OPTION_PARENT_LOSS_ALLOWANCE | VARCHAR2 | (30) | Holds the option parent loss allowance indicator | |
| OPTION_PARENT_TUITION_FLAG | VARCHAR2 | (30) | Holds the option parent tuition indicator | |
| OPTION_PARENT_HOME_TYPE | VARCHAR2 | (30) | Holds the option parent home indicator | |
| OPTION_PARENT_HOME_VALUE | VARCHAR2 | (7) | Holds the option parent home value | |
| OPTION_PARENT_HOME_DEBT | VARCHAR2 | (7) | Holds the option parent home debt | |
| OPTION_STUDENT_IRA_KEOGH_FLAG | VARCHAR2 | (30) | Holds the option student IRA KEOGH indicator | |
| OPTION_STUDENT_HOME_TYPE | VARCHAR2 | (30) | Holds the option student home indicator | |
| OPTION_STUDENT_HOME_VALUE | VARCHAR2 | (6) | Holds the optional student home value | |
| OPTION_STUDENT_HOME_DEBT | VARCHAR2 | (6) | Holds the option student home debt | |
| OPTION_STUDENT_SUM_AY_INC | VARCHAR2 | (30) | Holds the option student summer award year income indicator | |
| OPTION_PARENT_HOPE_LL_CREDIT | VARCHAR2 | (30) | Holds the option parents hope LL credit | |
| OPTION_STUDENT_HOPE_LL_CREDIT | VARCHAR2 | (30) | Holds the option student hope LL credit | |
| OPTION_PARENT_COLA_ADJ_FLAG | VARCHAR2 | (30) | Holds the option parent Cost of Living Adjustment Indicator | |
| OPTION_PARENT_STU_FA_ASSETS | VARCHAR2 | (30) | Holds the option student Assets treated as Parents Asset Indicator | |
| OPTION_PARENT_IPT_ASSETS | VARCHAR2 | (30) | Holds the option parent Assets from Interest and Dividend Income Indicator | |
| OPTION_STUDENT_IPT_ASSETS | VARCHAR2 | (30) | Holds the option student Assets from Interest and Dividend Income Indicator | |
| OPTION_PARENT_COLA_ADJ_VALUE | NUMBER | (12) | Holds the option parent Adjustment factor used to modify IPA and ERS | |
| IM_PARENT_1_8_MONTHS_BASIC | VARCHAR2 | (5) | Parent 1 to 8 months basic year | |
| IM_P_MORE_THAN_9_MTH_BASIC | VARCHAR2 | (5) | Parent more than 9 month basic year | |
| IM_PARENT_1_8_MONTHS_OPTIONAL | VARCHAR2 | (5) | Parent 1 to 8 months optional | |
| IM_P_MORE_THAN_9_MTH_OPTIONAL | VARCHAR2 | (5) | Parent more than 9 month optional | |
| FNAR_MESSAGE_1_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_2_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_3_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_4_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_5_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_6_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_7_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_8_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_9_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_10_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_11_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_12_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_13_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_20_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_21_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_22_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_23_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_24_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_25_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_26_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_27_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_30_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_31_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_32_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_33_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_34_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_35_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_36_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_37_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_38_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_39_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_45_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_46_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_47_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_48_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_49_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_50_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_51_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_52_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_53_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_55_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_56_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_57_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_58_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_59_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_60_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_61_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_62_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_63_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_64_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_65_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_71_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_72_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_73_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_74_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_75_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_76_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_77_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESSAGE_78_FLAG | VARCHAR2 | (30) | Holds the FNAR message | |
| FNAR_MESG_10_STUDENT_FAM_MEM | VARCHAR2 | (2) | Holds the FNAR message student family members | |
| FNAR_MESG_11_STUDENT_NO_IN_COL | VARCHAR2 | (30) | Holds the FNAR message student number in college | |
| FNAR_MESG_24_STUDENT_AVAIL_INC | VARCHAR2 | (7) | Holds the FNAR message student available income | |
| FNAR_MESG_26_STUDENT_TAXES | VARCHAR2 | (6) | Holds the FNAR message student taxes | |
| FNAR_MESG_33_STUDENT_HOME_VAL | VARCHAR2 | (6) | Holds the FNAR message student home value | |
| FNAR_MESG_34_STUDENT_HOME_VAL | VARCHAR2 | (6) | Holds the FANR message student home value | |
| FNAR_MESG_34_STUDENT_HOME_EQU | VARCHAR2 | (6) | Holds the FNAR message student home equity | |
| FNAR_MESG_35_STUDENT_HOME_VAL | VARCHAR2 | (6) | Holds the FNAR message student home value | |
| FNAR_MESG_35_STUDENT_HOME_EQU | VARCHAR2 | (6) | Holds the FNAR message student home equity | |
| FNAR_MESG_36_STUDENT_HOME_EQU | VARCHAR2 | (6) | Holds the FNAR message student home equity | |
| FNAR_MESG_48_PARENT_FAM_MEM | VARCHAR2 | (2) | Holds the FNAR message parent family member | |
| FNAR_MESG_49_PARENT_NO_IN_COL | VARCHAR2 | (30) | Holds the FNAR message parent number in college | |
| FNAR_MESG_56_PARENT_AGI | VARCHAR2 | (8) | Holds the FNAR message parent adjust gross income | |
| FNAR_MESG_62_PARENT_TAXES | VARCHAR2 | (7) | Holds the FNAR message parent taxes | |
| FNAR_MESG_73_PARENT_HOME_VAL | VARCHAR2 | (7) | Holds the FNAR message parent home value | |
| FNAR_MESG_74_PARENT_HOME_VAL | VARCHAR2 | (7) | Holds the FNAR message parent home value | |
| FNAR_MESG_74_PARENT_HOME_EQU | VARCHAR2 | (7) | Holds the FNAR message parent home equity | |
| FNAR_MESG_75_PARENT_HOME_VAL | VARCHAR2 | (7) | Holds the FNAR message parent home value | |
| FNAR_MESG_75_PARENT_HOME_EQU | VARCHAR2 | (7) | Holds the FNAR message parent home equity | |
| FNAR_MESG_76_PARENT_HOME_EQU | VARCHAR2 | (7) | Holds the FNAR message parent home equity | |
| ASSUMPTION_MESSAGE_1_FLAG | VARCHAR2 | (30) | Holds the assumption message | |
| ASSUMPTION_MESSAGE_2_FLAG | VARCHAR2 | (30) | Holds the assumption message | |
| ASSUMPTION_MESSAGE_3_FLAG | VARCHAR2 | (30) | Holds the assumption message | |
| ASSUMPTION_MESSAGE_4_FLAG | VARCHAR2 | (30) | Holds the assumption message | |
| ASSUMPTION_MESSAGE_5_FLAG | VARCHAR2 | (30) | Holds the assumption message | |
| ASSUMPTION_MESSAGE_6_FLAG | VARCHAR2 | (30) | Holds the assumption message | |
| SYSTEM_RECORD_TYPE | VARCHAR2 | (30) | Yes | Indicates whether the record is CORRECTION or ORIGINAL profile record |
| _LA:LEGACY_RECORD_FLAG | CHAR | (66) | Indicates weather the record was imported through a legacy process or not | |
| COA_DURATION_EFC_AMT | NUMBER | (10) | Holds the EFC Amount for the COA duration | |
| COA_DURATION_NUM | NUMBER | Holds the duration of which students EFC values are computed | ||
| PARENT_SOC_SEC_BEN_STUDENT | NUMBER | (6) | Social Security Benefits - Student Amount | |
| PARENT_TUITION_FEE_DEDUCT | NUMBER | (6) | Tuition and Fees Deduction Amount | |
| OPTION_IND_STUDENT_IPT_ASSETS | VARCHAR2 | (1) | Independent Student Assets from Interest and Dividend Income Indicator | |
| PROFILE_STATUS | VARCHAR2 | (30) | Profile record status | |
| PROFILE_STATUS_DATE | DATE | Profile record status date | ||
| PERSON_NUMBER | VARCHAR2 | (30) | Yes | Person's unique identifier |
| PERSON_NAME | VARCHAR2 | (360) | Yes | Person's name |
| AWARD_YEAR | VARCHAR2 | (10) | Alternate code for calendar instance | |
| AWARD_YEAR_DESCRIPTION | VARCHAR2 | (30) | Description for calendar alternate code | |
| CSSP_ID | NUMBER | (15) | Yes | Primary Key of Profile data |
| FNAR_CSSP_ID | NUMBER | (15) | Yes | Unique Identifier |
| FNAR_ID | NUMBER | (15) | Yes | Primary Key of FNAR data |
| BASE_ID | NUMBER | (10) | Yes | Unique identifier for student financial aid record |
| _LA:STU_LIVES_WITH_NUM | CHAR | (75) | Student Lives With | |
| _LA:STU_MOST_SUPPORT_FROM | CHAR | (80) | Student Received Most Support From | |
| _LA:LOCATION_COMPUTER_NUM | CHAR | (77) | 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 | ||
| 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 | |
| PERSON_ID | NUMBER | (15) | Yes | Person identifier |
Cut, paste (and edit) the following text to query this object:
SELECT ACTIVE_PROFILE
, COLLEGE_CODE
, ACADEMIC_YEAR
, STUDENT_RECORD_TYPE
, CSS_ID_NUMBER
, REGISTRATION_RECEIPT_DATE
, REGISTRATION_TYPE
, APPLICATION_RECEIPT_DATE
, APPLICATION_TYPE
, ORIGINAL_FNAR_COMPUTE_DATE
, REVISION_FNAR_COMPUTE_DATE
, ELECTRONIC_EXTRACT_DATE
, INSTITUTIONAL_REPORTING_TYPE
, ASR_RECEIPT_DATE
, LAST_NAME
, FIRST_NAME
, MIDDLE_INITIAL
, ADDRESS_NUMBER_AND_STREET
, CITY
, _LA:STATE_MAILING
, ZIP_CODE
, STUDENT_TELEPHONE_NUMBER
, STUDENT_TITLE
, BIRTH_DATE
, SOCIAL_SECURITY_NUMBER
, _LA:STATE_LEGAL_RESIDENCE
, FOREIGN_ADDRESS_FLAG
, FOREIGN_POSTAL_CODE
, COUNTRY
, _LA:FINANCIAL_AID_STATUS
, YEAR_IN_COLLEGE
, _LA:MARITAL_STATUS
, _LA:WARD_COURT
, _LA:LEGAL_DEPENDENTS_OTHER
, HOUSEHOLD_SIZE
, _LA:NUMBER_IN_COLLEGE
, _LA:CITIZENSHIP_STATUS
, CITIZENSHIP_COUNTRY
, VISA_CLASSIFICATION
, TAX_FIGURES
, NUMBER_EXEMPTIONS
, ADJUSTED_GROSS_INCOME
, US_TAX_PAID
, ITEMIZED_DEDUCTIONS
, STUDENT_INCOME_WORK
, SPOUSE_INCOME_WORK
, DIVIDENT_INTEREST_INCOME
, SOCIAL_SECURITY_BENEFITS
, WELFARE_TANF
, CHILD_SUPPORT_RECEIVED
, EARNED_INCOME_CREDIT
, OTHER_UNTAXED_INCOME
, TAX_STUDENT_AID_AMOUNT
, CASH_SAVINGS_CHECK_AMOUNT
, IRA_KEOGH_AMOUNT
, INVESTMENT_VALUE_AMOUNT
, INVESTMENT_DEBT_AMOUNT
, HOME_VALUE_AMOUNT
, HOME_DEBT_AMOUNT
, OTHER_REAL_VALUE_AMOUNT
, OTHER_REAL_DEBT_AMOUNT
, BUSINESS_FARM_VALUE_AMOUNT
, BUSINESS_FARM_DEBT_AMOUNT
, _LA:LIVE_ON_FARM
, HOME_PURCH_PRICE
, HOPE_LL_CREDIT_AMOUNT
, HOME_PURCH_YEAR
, STUDENT_TRUST_AMOUNT
, _LA:STUDENT_TRUST_AVAILABLE
, STUDENT_TRUST_ESTABLISHED
, CHILD_SUPPORT_PAID
, MEDICAL_DENTAL_EXPENSES
, _LA:VETERAN_US_FLAG
, VETERAN_BENEFIT_AMOUNT
, VETERAN_BENEFIT_MONTHS
, STUDENT_SUMMER_WAGES_AMOUNT
, STUDENT_SCHOOL_YR_WAGES_AMOUNT
, SPOUSE_SUMMER_WAGES_AMOUNT
, SPOUSE_SCHOOL_YR_WAGES_AMOUNT
, SUMMER_OTHER_TAX_INC_AMOUNT
, SCHOOL_YR_OTHER_TAX_INC_AMOUNT
, SUMMER_UNTAX_INC_AMOUNT
, SCHOOL_YR_UNTAX_INC_AMOUNT
, GRANTS_SCHOL_ETC_AMOUNT
, TUITION_BENEFITS_AMOUNT
, PARENTS_CONTIBUTION_AMOUNT
, RELATIVES_CONTIBUTION_AMOUNT
, PARENT_SIBLINGS_PRE_TUITION
, PARENT_STUDENT_PRE_TUITION
, PARENTS_HOUSEHOLD_SIZE
, PARENTS_NUMBER_IN_COLLEGE
, _LA:PARENTS_IN_COLLEGE
, _LA:PARENTS_MARITAL_STATUS
, _LA:PARENTS_STATE_LEGAL_RES
, _LA:NATURAL_PARENTS_STATUS
, PARENTS_CHILD_SUPPORT_PAID
, PARENTS_REPAY_EDUCATION_LOANS
, PARENTS_MEDICAL_DENTAL_EXPENS
, PARENTS_TUITION_PAID_AMOUNT
, PARENTS_TUITION_PAID_NUMBER
, PARENTS_EXP_CHILD_SUPPORT_PAID
, PARENTS_EXP_REPAY_ED_LOANS
, PARENTS_EXP_MED_DENT_EXPENSES
, PARENTS_EXP_TUIT_PD_AMOUNT
, PARENTS_EXP_TUIT_PD_NUMBER
, PARENTS_CASH_SAVINGS_CHECK
, PARENTS_MONTH_MORTGAGE_PAY
, PARENTS_INVEST_VALUE
, PARENTS_INVEST_DEBT
, PARENTS_HOME_VALUE
, PARENTS_HOME_DEBT
, PARENTS_HOME_PURCH_PRICE
, _LA:PARENTS_OWN_BUSINES_FARM
, PARENTS_BUSINESS_VALUE
, PARENTS_BUSINESS_DEBT
, PARENTS_FARM_VALUE
, PARENTS_FARM_DEBT
, _LA:PARENTS_LIVE_ON_FARM
, PARENTS_OTHER_REAL_ESTATE_VAL
, PARENTS_OTHER_REAL_ESTATE_DEBT
, PARENTS_OTHER_REAL_PURCH_PRICE
, PARENTS_SIBLINGS_ASSETS
, PARENTS_HOME_PURCH_YEAR
, PARENTS_OTHER_REAL_PURCH_YEAR
, PARENTS_PRIOR_AGI
, PARENTS_PRIOR_US_TAX_PAID
, PARENTS_PRIOR_ITEM_DEDUCTIONS
, PARENTS_PRIOR_OTHER_UNTAX_INC
, _LA:PARENTS_TAX_FIGURES
, PARENTS_NUMBER_EXEMPTIONS
, PARENTS_ADJUSTED_GROSS_INCOME
, PARENTS_WAGES_SAL_TIPS
, PARENTS_INTEREST_INCOME
, PARENTS_DIVIDEND_INCOME
, PARENTS_NET_INC_BUSINESS_FARM
, PARENTS_OTHER_TAXABLE_INCOME
, PARENTS_ADJ_TO_INCOME
, PARENTS_US_TAX_PAID
, PARENTS_ITEMIZED_DEDUCTIONS
, PARENTS_FATHER_INCOME_WORK
, PARENTS_MOTHER_INCOME_WORK
, PARENTS_SOCICAL_SEC_BENEFITS
, PARENTS_WELFARE_TRANSFER
, PARENTS_CHILD_SUPPARENTS_RCVD
, PARENTS_DEDUCTIONS_IRA_KEOGH
, PARENTS_TAX_DEFER_PENSION_SAVS
, PARENTS_DEP_CARE_MED_SPENDING
, PARENTS_EARNED_INCOME_CREDIT
, PARENTS_LIVING_ALLOWANCE
, PARENTS_TAX_EXEMPT_INTEREST
, PARENTS_FOREIGN_INC_EXCLUSION
, PARENTS_OTHER_UNTAX_INCOME
, PARENTS_HOPE_LL_CREDIT
, PARENTS_YEAR_SEPARATION
, PARENTS_YEAR_DIVORCE
, PARENTS_EXPECTED_FATHER_INC
, PARENTS_EXPECTED_MOTHER_INC
, PARENTS_EXPECTED_OTHER_TAX_INC
, PARENTS_EXPECTED_OTHR_UNTX_INC
, _LA:LINE_2_RELATION
, _LA:LINE_2_ATTEND_COLLEGE
, _LA:LINE_3_RELATION
, _LA:LINE_3_ATTEND_COLLEGE
, _LA:LINE_4_RELATION
, _LA:LINE_4_ATTEND_COLLEGE
, _LA:LINE_5_RELATION
, _LA:LINE_5_ATTEND_COLLEGE
, _LA:LINE_6_RELATION
, _LA:LINE_6_ATTEND_COLLEGE
, _LA:LINE_7_RELATION
, _LA:LINE_7_ATTEND_COLLEGE
, _LA:LINE_8_RELATION
, _LA:LINE_8_ATTEND_COLLEGE
, PARENTS_AGE_FATHER
, PARENTS_AGE_MOTHER
, PARENTS_DIVORCE_SEPERATION
, NON_CUSTODIAL_PARENTS_CONTRIB
, _LA:COLLEGE_2_TYPE
, _LA:COLLEGE_3_TYPE
, _LA:COLLEGE_4_TYPE
, _LA:COLLEGE_5_TYPE
, _LA:COLLEGE_6_TYPE
, _LA:COLLEGE_7_TYPE
, _LA:COLLEGE_8_TYPE
, SCHOOL_1_CODE
, _LA:HOUSING_1_CODE
, SCHOOL_2_CODE
, _LA:HOUSING_2_CODE
, SCHOOL_3_CODE
, _LA:HOUSING_3_CODE
, SCHOOL_4_CODE
, _LA:HOUSING_4_CODE
, SCHOOL_5_CODE
, _LA:HOUSING_5_CODE
, SCHOOL_6_CODE
, _LA:HOUSING_6_CODE
, SCHOOL_7_CODE
, _LA:HOUSING_7_CODE
, SCHOOL_8_CODE
, _LA:HOUSING_8_CODE
, SCHOOL_9_CODE
, _LA:HOUSING_9_CODE
, SCHOOL_10_CODE
, _LA:HOUSING_10_CODE
, ADDITIONAL_SCHOOL_1_CODE
, ADDITIONAL_SCHOOL_2_CODE
, ADDITIONAL_SCHOOL_3_CODE
, ADDITIONAL_SCHOOL_4_CODE
, ADDITIONAL_SCHOOL_5_CODE
, ADDITIONAL_SCHOOL_6_CODE
, ADDITIONAL_SCHOOL_7_CODE
, ADDITIONAL_SCHOOL_8_CODE
, ADDITIONAL_SCHOOL_9_CODE
, ADDITIONAL_SCHOOL_10_CODE
, EXPLANATION_SPECIAL_CIRCUM
, SIGNATURE_STUDENT
, SIGNATURE_SPOUSE
, SIGNATURE_FATHER
, SIGNATURE_MOTHER
, MONTH_DAY_COMPLETED
, YEAR_COMPLETED
, AGE_LINE_2_NUMBER
, AGE_LINE_3_NUMBER
, AGE_LINE_4_NUMBER
, AGE_LINE_5_NUMBER
, AGE_LINE_6_NUMBER
, AGE_LINE_7_NUMBER
, AGE_LINE_8_NUMBER
, 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_CD
, _LA:COMP_CSS_DEPNDNCY_STATUS
, STUDENTS_AGE
, ASSUMED_STUDENT_YR_IN_COLLEGE
, COMP_STUDENT_MARITAL_STATUS
, STUDENT_FAMILY_MEMBERS
, STUDENT_FAM_MEMBERS_IN_COLLEGE
, PARENTS_FAMILY_MEMBERS
, PARENTS_TOTAL_IN_COLLEGE
, PARENTS_PAR_IN_COLLEGE
, PARENTS_OTHERS_IN_COLLEGE
, PARENTS_AESA
, PARENTS_CESA
, STUDENT_AESA
, STUDENT_CESA
, IM_PARENTS_BAS_AGI_TAXABLE_INC
, IM_PARENTS_BAS_UNTX_INC_BENEFT
, IM_PARENTS_BASE_INCOME_ADJUST
, IM_PARENTS_BASE_TOTAL_INCOME
, IM_PARENTS_BASE_US_INCOME_TAX
, IM_PARENTS_BAS_ST_AND_OTHR_TAX
, IM_PARENTS_BAS_FICA_TAX
, IM_PARENTS_BAS_MED_DENTAL
, IM_PARENTS_BAS_EMPLOYMET_ALOW
, IM_PARENTS_BAS_ANNUAL_ED_SAVS
, IM_PARENTS_BAS_INC_PROT_ALLOW
, IM_PARENTS_BAS_TOTAL_INC_ALLOW
, IM_PARENTS_BASE_CAL_AVAIL_INC
, IM_PARENTS_BASE_AVAIL_INCOME
, IM_PARENTS_BAS_TOTAL_CONT_INC
, IM_PARENTS_BAS_CASH_BANK_ACCNT
, IM_PARENTS_BASE_HOME_EQUITY
, IM_PARENTS_BAS_OT_RLEST_INV_EQ
, IM_PARENTS_BAS_ADJ_BUS_FRM_WTH
, IM_PARENTS_BAS_ASS_SIB_PRE_TUI
, IM_PARENTS_BAS_NET_WORTH
, IM_PARENTS_BAS_EMERG_RES_ALLOW
, IM_PARENTS_BAS_CUM_ED_SAVINGS
, IM_PARENTS_BAS_LOW_INC_ALLOW
, IM_PARENTS_BAS_TOTAL_AST_ALLOW
, IM_PARENTS_BAS_DISC_NET_WORTH
, IM_PARENTS_BAS_TOTL_CONT_ASSET
, IM_PARENTS_BAS_TOTAL_CONT
, IM_PARENTS_BAS_NUM_IN_COLL_ADJ
, IM_PARENTS_BAS_CONT_FOR_STU
, IM_PARENTS_BAS_CONT_FROM_INC
, IM_PARENTS_BAS_CONT_FROM_ASETS
, IM_PARENTS_OPT_AGI_TAX_INCOME
, IM_PARENTS_OPT_UNTX_INC_BEN
, IM_PARENTS_OPT_INC_ADJUSTABLE
, IM_PARENTS_OPT_TOTAL_INCOME
, IM_PARENTS_OPT_US_INCOME_TAX
, IM_PARENTS_OPT_ST_AND_OTHR_TAX
, IM_PARENTS_OPT_FICA_TAX
, IM_PARENTS_OPT_MED_DENTAL
, IM_PARENTS_OPT_ELEM_SEC_TUIT
, IM_PARENTS_OPT_EMPLOYMENT_ALOW
, IM_PARENTS_OPT_ANNUAL_ED_SAVNG
, IM_PARENTS_OPT_INC_PROT_ALOW_M
, IM_PARENTS_OPT_TOTAL_INC_ALLOW
, IM_PARENTS_OPT_CAL_AVAIL_INC
, IM_PARENTS_OPT_AVAIL_INCOME
, IM_PARENTS_OPT_TOTAL_CONT_INC
, IM_PARENTS_OPT_CASH_BANK_ACCNT
, IM_PARENTS_OPT_HOME_EQUITY
, IM_PARENTS_OPT_OT_RL_EST_INVEQ
, IM_PARENTS_OPT_ADJ_FARM_WORTH
, IM_PARENTS_OPT_ASS_SIBS_PRE_T
, IM_PARENTS_OPT_NET_WORTH
, IM_PARENTS_OPT_EMERG_RES_ALLOW
, IM_PARENTS_OPT_CUM_ED_SAVINGS
, IM_PARENTS_OPT_LOW_INC_ALLOW
, IM_PARENTS_OPT_TOTAL_ASET_ALOW
, IM_PARENTS_OPT_DISC_NET_WORTH
, IM_PARENTS_OPT_TOTAL_CONT_ASET
, IM_PARENTS_OPT_TOTAL_CONT
, IM_PARENTS_OPT_NUM_IN_COLL_ADJ
, IM_PARENTS_OPT_CONT_FOR_STU
, IM_PARENTS_OPT_CONT_FROM_INCOM
, IM_PARENTS_OPT_CONT_FROM_ASETS
, FM_PARENTS_ANALYSIS_TYPE
, FM_PARENTS_AGI_TAXABLE_INCOME
, FM_PARENTS_UNTX_INC_AND_BENEF
, FM_PARENTS_INCOME_ADJUST
, FM_PARENTS_TOTAL_INCOME
, FM_PARENTS_US_INCOME_TAX
, FM_PARENTS_STATE_AND_OTHER_TAX
, FM_PARENTS_FICA_TAX
, FM_PARENTS_EMPLOYMENT_ALLOW
, FM_PARENTS_INCOME_PROT_ALLOW
, FM_PARENTS_TOTAL_ALLOW
, FM_PARENTS_AVAIL_INCOME
, FM_PARENTS_CASH_BANK_ACCOUNTS
, FM_PARENTS_OT_RL_EST_INV_EQ
, FM_PARENTS_ADJ_FARM_NET_WORTH
, FM_PARENTS_NET_WORTH
, FM_PARENTS_ASSET_PROT_ALLOW
, FM_PARENTS_DISC_NET_WORTH
, FM_PARENTS_TOTAL_CONTRIBUTION
, FM_PARENTS_NUM_IN_COLL_NUM
, FM_PARENTS_CONTRIB_FOR_STUDENT
, FM_PARENTS_CONTRIB_FROM_INCOME
, FM_PARENTS_CONTRIB_FROM_ASSETS
, IM_STUDENTS_BAS_AGI_TAX_INCOME
, IM_STUDENTS_BAS_UNTX_INC_BEN
, IM_STUDENTS_BAS_INC_ADJ
, IM_STUDENTS_BAS_TOTAL_INCOME
, IM_STUDENTS_BAS_US_INCOME_TAX
, IM_STUDENTS_BAS_ST_AND_OTH_TAX
, IM_STUDENTS_BAS_FICA_TAX
, IM_STUDENTS_BAS_MED_DENTAL
, IM_STUDENTS_BAS_EMPLOYMEN_ALOW
, IM_STUDENTS_BAS_ANNUAL_ED_SAVS
, IM_STUDENTS_BAS_INC_PROT_ALLOM
, IM_STUDENTS_BAS_TOTAL_INC_ALLW
, IM_STUDENTS_BAS_CAL_AVAIL_INC
, IM_STUDENTS_BAS_AVAIL_INCOME
, IM_STUDENTS_BAS_TOTAL_CONT_INC
, IM_STUDENTS_BAS_CASH_BANK_ACCT
, IM_STUDENTS_BAS_HOME_EQUITY
, IM_STUDENTS_BAS_OT_RL_EST_INVQ
, IM_STUDENTS_BAS_ADJ_FARM_WORTH
, IM_STUDENTS_BAS_TRUSTS
, IM_STUDENTS_BAS_NET_WORTH
, IM_STUDENTS_BAS_EMERG_RES_ALLW
, IM_STUDENTS_BAS_CUM_ED_SAVINGS
, IM_STUDENTS_BAS_TOT_ASSET_ALOW
, IM_STUDENTS_BAS_DISC_NET_WORTH
, IM_STUDENTS_BAS_TOTAL_CONT_AST
, IM_STUDENTS_BAS_TOTAL_CONT
, IM_STUDENTS_BAS_NUM_IN_COL_ADJ
, IM_STUDENTS_BAS_CONT_FOR_STU
, IM_STUDENTS_BAS_CONT_FROM_INC
, IM_STUDENTS_BAS_CONT_FROM_AETS
, IM_STUDENTS_EST_AGI_TAX_INCOME
, IM_STUDENTS_EST_UNTX_INC_BEN
, IM_STUDENTS_EST_INC_ADJ
, IM_STUDENTS_EST_TOTAL_INCOME
, IM_STUDENTS_EST_US_INCOME_TAX
, IM_STUDENTS_EST_ST_AND_OTH_TAX
, IM_STUDENTS_EST_FICA_TAX
, IM_STUDENTS_EST_MED_DENTAL
, IM_STUDENTS_EST_EMPLOYMEN_ALOW
, IM_STUDENTS_EST_ANNUAL_ED_SAVS
, IM_STUDENTS_EST_INC_PROT_ALLOM
, IM_STUDENTS_EST_TOTAL_INC_ALOW
, IM_STUDENTS_EST_CAL_AVAIL_INCE
, IM_STUDENTS_EST_AVAIL_INCOME
, IM_STUDENTS_EST_TOTAL_CONT_INC
, IM_STUDENTS_EST_CASH_BANK_ACCT
, IM_STUDENTS_EST_HOME_EQUITY
, IM_STUDENTS_EST_OT_RL_EST_INVU
, IM_STUDENTS_EST_ADJ_FARM_WORTH
, IM_STUDENTS_EST_EST_TRUSTS
, IM_STUDENTS_EST_NET_WORTH
, IM_STUDENTS_EST_EMERG_RES_ALOW
, IM_STUDENTS_EST_CUM_ED_SAVINGS
, IM_STUDENTS_EST_TOTL_ASET_ALOW
, IM_STUDENTS_EST_DISC_NET_WORTH
, IM_STUDENTS_EST_TOTL_CONT_ASET
, IM_STUDENTS_EST_TOTAL_CONTRIB
, IM_STUDENTS_EST_NUM_IN_COL_ADJ
, IM_STUDENTS_EST_CONT_FOR_STU
, IM_STUDENTS_EST_CONT_FROM_INC
, IM_STUDENTS_EST_CONT_FROM_ASET
, IM_STUDENTS_OPT_AGI_TAX_INCOME
, IM_STUDENTS_OPT_UNTX_INC_BEN
, IM_STUDENTS_OPT_INC_ADJ
, IM_STUDENTS_OPT_TOTAL_INCOME
, IM_STUDENTS_OPT_US_INCOME_TAX
, IM_STUDENTS_OPT_STATE_OTH_TAXS
, IM_STUDENTS_OPT_FICA_TAX
, IM_STUDENTS_OPT_MED_DENTAL
, IM_STUDENTS_OPT_EMPLOYMEN_ALOW
, IM_STUDENTS_OPT_ANNUAL_ED_SAVS
, IM_STUDENTS_OPT_INC_PROT_ALOWM
, IM_STUDENTS_OPT_TOTAL_INC_ALOW
, IM_STUDENTS_OPT_CAL_AVAIL_INC
, IM_STUDENTS_OPT_AVAIL_INCOME
, IM_STUDENTS_OPT_TOTAL_CONT_INC
, IM_STUDENTS_OPT_CASH_BANK_ACNT
, IM_STUDENTS_OPT_IRA_KEOGH_ACNT
, IM_STUDENTS_OPT_HOME_EQUITY
, IM_STUDENTS_OPT_OT_RL_EST_INVQ
, IM_STUDENTS_OPT_ADJ_BUS_FORM
, IM_STUDENTS_OPT_TRUSTS
, IM_STUDENTS_OPT_NET_WORTH
, IM_STUDENTS_OPT_EMERG_RES_ALOW
, IM_STUDENTS_OPT_CUM_ED_SAVINGS
, IM_STUDENTS_OPT_TOTL_ASET_ALOW
, IM_STUDENTS_OPT_DISC_NET_WORTH
, IM_STUDENTS_OPT_TOTL_CONT_ASET
, IM_STUDENTS_OPT_TOTAL_CONT
, IM_STUDENTS_OPT_NUM_IN_COL_ADJ
, IM_STUDENTS_OPT_CONT_FOR_STU
, IM_STUDENTS_OPT_CONT_FROM_INC
, IM_STUDENTS_OPT_CONT_FROM_ASET
, FM_STUDENTS_ANALYSIS_TYPE
, FM_STUDENTS_AGI_TAXABLE_INCOME
, FM_STUDENTS_UNTX_INC_AND_BEN
, FM_STUDENTS_INC_ADJ
, FM_STUDENTS_TOTAL_INCOME
, FM_STUDENTS_US_INCOME_TAX
, FM_STUDENTS_STATE_AND_OTH_TAX
, FM_STUDENTS_FICA_TAX
, FM_STUDENTS_EMPLOYMENT_ALLOW
, FM_STUDENTS_INCOME_PROT_ALLOW
, FM_STUDENTS_TOTAL_ALLOW
, FM_STUDENTS_CAL_AVAIL_INCOME
, FM_STUDENTS_AVAIL_INCOME
, FM_STUDENTS_CASH_BANK_ACCOUNTS
, FM_STUDENTS_OT_RL_EST_INV_EQUY
, FM_STUDENTS_ADJ_BUS_FARM_WORTH
, FM_STUDENTS_TRUSTS
, FM_STUDENTS_NET_WORTH
, FM_STUDENTS_ASSET_PROT_ALLOW
, FM_STUDENTS_DISC_NET_WORTH
, FM_STUDENTS_TOTAL_CONT
, FM_STUDENTS_NUM_IN_COLL_NUM
, FM_STUDENTS_CONT_FOR_STUDENT
, FM_STUDENTS_CONT_FROM_INCOME
, FM_STUDENTS_CONT_FROM_ASSETS
, IM_INSTITUTIONAL_RESIDENT_FLAG
, INSTITUTIONAL_1_BUDGET_NAME
, IM_INSTIT_BUDGET_DURATION
, IM_INSTITUTION_1_TUITION_FEES
, IM_INST_1_BOOKS_SUPPLIES
, IM_INST_1_LIVING_EXPENSES
, IM_INST_1_TOTAL_EXPENSES
, IM_INST_1_TOTL_STUDENT_CONTRIB
, IM_INST_1_TOT_PARENTS_CONTRIB
, IM_INST_1_TOT_FAMILY_CONTRIB
, IM_INST_1_VA_BENEFITS
, IM_INST_1_OTHER_CONTRIBUTIONS
, IM_INST_1_EST_FINANCIAL_NEED
, INSTITUTIONAL_2_BUDGET
, IM_INST_2_BUDGET_DURATION
, IM_INST_2_TUITION_FEES
, IM_INST_2_BOOKS_SUPPLIES
, IM_INST_2_LIVING_EXPENSES
, IM_INST_2_TOTAL_EXPENSES
, IM_INST_2_TOT_STUDENTS_CONTRIB
, IM_INST_2_TOT_PARENTS_CONTRIB
, IM_INST_2_TOT_FAMILY_CONTRIB
, IM_INST_2_VA_BENEFITS
, IM_INST_2_EST_FINANCIAL_NEED
, INSTITUTIONAL_3_BUDGET
, IM_INST_3_BUDGET_DURATION
, IM_INST_3_TUITION_FEES
, IM_INST_3_BOOKS_SUPPLIES
, IM_INST_3_LIVING_EXPENSES
, IM_INST_3_TOTAL_EXPENSES
, IM_INST_3_TOT_STUDENTS_CONTRIB
, IM_INST_3_TOT_PARENTS_CONTRIB
, IM_INST_3_TOT_FAMILY_CONTRIB
, IM_INST_3_VA_BENEFITS
, IM_INST_3_EST_FINANCIAL_NEED
, FM_INST_1_FEDERAL_EFC
, FM_INST_1_VA_BENEFITS
, FM_INST_1_FEDERAL_ELIGIBILITY
, FM_INST_1_PELL
, OPTION_PARENT_LOSS_ALLOWANCE
, OPTION_PARENT_TUITION_FLAG
, OPTION_PARENT_HOME_TYPE
, OPTION_PARENT_HOME_VALUE
, OPTION_PARENT_HOME_DEBT
, OPTION_STUDENT_IRA_KEOGH_FLAG
, OPTION_STUDENT_HOME_TYPE
, OPTION_STUDENT_HOME_VALUE
, OPTION_STUDENT_HOME_DEBT
, OPTION_STUDENT_SUM_AY_INC
, OPTION_PARENT_HOPE_LL_CREDIT
, OPTION_STUDENT_HOPE_LL_CREDIT
, OPTION_PARENT_COLA_ADJ_FLAG
, OPTION_PARENT_STU_FA_ASSETS
, OPTION_PARENT_IPT_ASSETS
, OPTION_STUDENT_IPT_ASSETS
, OPTION_PARENT_COLA_ADJ_VALUE
, IM_PARENT_1_8_MONTHS_BASIC
, IM_P_MORE_THAN_9_MTH_BASIC
, IM_PARENT_1_8_MONTHS_OPTIONAL
, IM_P_MORE_THAN_9_MTH_OPTIONAL
, 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_49_FLAG
, FNAR_MESSAGE_50_FLAG
, FNAR_MESSAGE_51_FLAG
, FNAR_MESSAGE_52_FLAG
, FNAR_MESSAGE_53_FLAG
, FNAR_MESSAGE_55_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_STUDENT_FAM_MEM
, FNAR_MESG_11_STUDENT_NO_IN_COL
, FNAR_MESG_24_STUDENT_AVAIL_INC
, FNAR_MESG_26_STUDENT_TAXES
, FNAR_MESG_33_STUDENT_HOME_VAL
, FNAR_MESG_34_STUDENT_HOME_VAL
, FNAR_MESG_34_STUDENT_HOME_EQU
, FNAR_MESG_35_STUDENT_HOME_VAL
, FNAR_MESG_35_STUDENT_HOME_EQU
, FNAR_MESG_36_STUDENT_HOME_EQU
, FNAR_MESG_48_PARENT_FAM_MEM
, FNAR_MESG_49_PARENT_NO_IN_COL
, FNAR_MESG_56_PARENT_AGI
, FNAR_MESG_62_PARENT_TAXES
, FNAR_MESG_73_PARENT_HOME_VAL
, FNAR_MESG_74_PARENT_HOME_VAL
, FNAR_MESG_74_PARENT_HOME_EQU
, FNAR_MESG_75_PARENT_HOME_VAL
, FNAR_MESG_75_PARENT_HOME_EQU
, FNAR_MESG_76_PARENT_HOME_EQU
, ASSUMPTION_MESSAGE_1_FLAG
, ASSUMPTION_MESSAGE_2_FLAG
, ASSUMPTION_MESSAGE_3_FLAG
, ASSUMPTION_MESSAGE_4_FLAG
, ASSUMPTION_MESSAGE_5_FLAG
, ASSUMPTION_MESSAGE_6_FLAG
, SYSTEM_RECORD_TYPE
, _LA:LEGACY_RECORD_FLAG
, COA_DURATION_EFC_AMT
, COA_DURATION_NUM
, PARENT_SOC_SEC_BEN_STUDENT
, PARENT_TUITION_FEE_DEDUCT
, OPTION_IND_STUDENT_IPT_ASSETS
, PROFILE_STATUS
, PROFILE_STATUS_DATE
, PERSON_NUMBER
, PERSON_NAME
, AWARD_YEAR
, AWARD_YEAR_DESCRIPTION
, CSSP_ID
, FNAR_CSSP_ID
, FNAR_ID
, BASE_ID
, _LA:STU_LIVES_WITH_NUM
, _LA:STU_MOST_SUPPORT_FROM
, _LA: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
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, PERSON_ID
FROM APPS.IGFFV_PROFILE_INFORMATION;
APPS
HZ_PARTIES
IGF_AP_CSS_FNAR_ALL
IGF_AP_CSS_PROFILE_ALL
IGF_AP_FA_BASE_REC_ALL
IGS_CA_INST_ALL
APPS.IGFFV_PROFILE_INFORMATION is not referenced by any database object
|
|
|
|