Go To View:
| RETURN TO REPORTING VIEW REPORTS LIST |

Financial Aid Reporting View Reports |

Reporting View Target: NEED_ANALYSIS_INST_METHOD

Description
| Contains information specific to the institutional methodology of computing applicant need. |

Key & Frequency
| One row per Aid Year per Person per Interface Tape Code per Application Number. |

Recommended Search Columns
| AID_YEAR, PERSON_UID, INTERFACE_TAPE_CODE, APPLICATION_NUMBER, CURRENT_RECORD_IND |

Target Column | Business Definition | Database Data Type | Source Name | Source Column |
---|---|---|---|---|

ACTIVITY_DATE | Date record was inserted or updated | DATE | ||

ADMINISTRATIVE_GROUP | Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined. | VARCHAR2(255) | ||

AID_YEAR | Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005). | VARCHAR2(63) | ||

AID_YEAR_DESC | Financial aid year name. | VARCHAR2(255) | ||

APPLICATION_NUMBER | Financial aid application unique sequence number. | NUMBER | ||

CURRENT_RECORD_IND | Specifies that this is the current need analysis record. | VARCHAR2(63) | ||

ID | Person's or organization's current identification number. | VARCHAR2(63) | ||

IM_ADJUSTED_AVAILABLE_INCOME | Amount of the adjusted available income that was used in the Institutional Method calculation of the student contribution. | NUMBER | ||

IM_ADJUSTED_BUS_NET_WORTH | Amount of business and farm net worth used in the calculation of the Institutional Method student contribution. | NUMBER | ||

IM_ADJUSTED_GROSS_INCOME | Adjusted gross taxable income used in the calculation of the Institutional Method student contribution. | NUMBER | ||

IM_ANALYSIS_TYPE | Analysis type used for the Institutional Method student contribution. | VARCHAR2(63) | ||

IM_ANALYSIS_TYPE_DESC | Analysis type description. | VARCHAR2(255) | ||

IM_ASSET_PROTECT_ALLOWANCE | Asset protection allowance used in the calculation of the student Institutional Method contribution. | NUMBER | ||

IM_AVAILABLE_INCOME | Student's available discretionary income for the Institutional Method calculation. | NUMBER | ||

IM_AVAILABLE_TAX_INCOME | Student's available taxable income for the Institutional Method calculation. | NUMBER | ||

IM_BUDGET_DURATION | Budget duration used for the Institutional Method calculation. | NUMBER | ||

IM_CALC_AVAILABLE_INCOME | Student's calculated available income for the Institutional Method calculation. | NUMBER | ||

IM_CASH_AMOUNT | Student's amounts in cash, savings and checking accounts used in the Institutional Method calculation. | NUMBER | ||

IM_CONTRIBUTION | Primary institutional methodology student contribution. | NUMBER | ||

IM_CONTRIBUTION_AMOUNT | Student Institutional Method contribution amount. | NUMBER | ||

IM_CONTRIBUTION_ASSET | Student's contribution from assets for the primary calculation. | NUMBER | ||

IM_CONTRIBUTION_INCOME | Student's contribution from income for the primary calculation. | NUMBER | ||

IM_CONTRIBUTION_OFFICIAL | Indicates if the Institutional Method student contribution is official or estimated. | VARCHAR2(63) | ||

IM_CONTRIBUTION_OFFICIAL_DESC | Description of the Institutional Method student contribution. | VARCHAR2(255) | ||

IM_CONVERSION_PERCENT | Conversion percent used in the student's Institutional Method calculation. | NUMBER | ||

IM_CUSTODIAL_PARENT | Custodial parent used for Institutional Method only calculation of custodial parent's adjustment contribution. | VARCHAR2(63) | ||

IM_CUSTODIAL_PARENT_DESC | Institutional Method custodial parent description. | VARCHAR2(255) | ||

IM_DISCRET_NET_WORTH | Student's discretionary net worth used in the Institutional Method calculation. | NUMBER | ||

IM_EMPLOYMENT_ALLOWANCE | Employment allowance used in the calculation of the student Institutional Method contribution. | NUMBER | ||

IM_FEDERAL_TAX_PAID | Amount of federal income taxes paid used in the calculation of the Institutional Method student contribution. | NUMBER | ||

IM_HOME_EQUITY | Home equity used in the student's Institutional Method calculation. | NUMBER | ||

IM_INAS | The student contribution for the Institutional Method calculation. | NUMBER | ||

IM_INCOME_SUPPLEMENT | Amount of the income supplement used in the student's Institutional Method calculation. | NUMBER | ||

IM_MEDICAL_DENTAL_EXPENSE | Amount of medical or dental expenses used in the student's Institutional Method calculation. | NUMBER | ||

IM_MULTI_ENROLL_ADJUSTED | Percentage of adjustment to the student contribution for differing numbers of family members in college. Prior to 2001, this contains the number in college as used in the calculation of EFC. | NUMBER | ||

IM_NET_WORTH | Amount of the student's net worth used in the Institutional Method calculation. | NUMBER | ||

IM_OTHER_ASSET_ALLOW_OVR | Amount of the other asset allowance (override) used in the student Institutional Method calculation. | NUMBER | ||

IM_OTHER_ASSET_OVR | Amount of the other asset (override) used in the student Institutional Method calculation. | NUMBER | ||

IM_PARENT_ADJUST_GROSS_INCOME | Adjusted gross taxable income used in the calculation of the secondary parent contribution. | NUMBER | ||

IM_PARENT_ADJ_AVAILABLE_INCOME | Adjusted available income used in the calculation of the Institutional Method parent contribution. | NUMBER | ||

IM_PARENT_ADJ_BUS_NET_WORTH | Amount of business and farm net worth used in the calculation of the secondary parent contribution. | NUMBER | ||

IM_PARENT_ANALYSIS_TYPE | Analysis type used for the Institutional Method parent contribution. | VARCHAR2(63) | ||

IM_PARENT_ANALYSIS_TYPE_DESC | Analysis type description. | VARCHAR2(255) | ||

IM_PARENT_ASSET_PROT_ALLOWANCE | Amount of the parent's asset protection allowance used in the calculation of the primary parent contribution. | NUMBER | ||

IM_PARENT_AVAILABLE_INCOME | Parent's available discretionary income for the primary calculation. | NUMBER | ||

IM_PARENT_CASH_AMOUNT | Parent's estimated amounts in cash, savings and checking accounts used in the Institutional Method calculation. | NUMBER | ||

IM_PARENT_CONTRIBUTION | Primary institutional methodology parent contribution. | NUMBER | ||

IM_PARENT_CONTRIBUTION_AMOUNT | Parent Institutional Method contribution amount. | NUMBER | ||

IM_PARENT_CONTRIBUTION_ASSET | Portion of the primary parent contribution that came from income. | NUMBER | ||

IM_PARENT_CONTRIBUTION_INCOME | Portion of the primary parent contribution that came from income. | NUMBER | ||

IM_PARENT_CONTRIB_OFFICIAL | Indicates if the Institutional Method parent contribution is official or estimated. | VARCHAR2(63) | ||

IM_PARENT_CONTRIB_OFF_DESC | Description of the Institutional Method parent contribution. | VARCHAR2(255) | ||

IM_PARENT_CONVERSION_PERCENT | Conversion percent used in the parent's Institutional Method calculation. | NUMBER | ||

IM_PARENT_DATA_AVAILABLE_IND | Indicates whether parent data was available for the Institutional Method calculation. | VARCHAR2(63) | ||

IM_PARENT_DISCRET_NET_WORTH | Parent's discretionary net worth used in the primary calculation. | NUMBER | ||

IM_PARENT_EMPLOYMENT_ALLOWANCE | Employment allowance used in the Institutional Method calculation of the parent contribution. | NUMBER | ||

IM_PARENT_FEDERAL_INCOME_TAX | Amount of federal income tax paid by the parent. | NUMBER | ||

IM_PARENT_HOME_EQUITY | Home equity used in the parent's Institutional Method calculation. | NUMBER | ||

IM_PARENT_INAS | The parent contribution for the Institutional Method calculation. | NUMBER | ||

IM_PARENT_INCOME_SUPPLEMENT | Amount of the income supplement used in the parent's Institutional Method calculation. | NUMBER | ||

IM_PARENT_MEDICAL_DENTAL_EXP | Amount of medical and dental expenses used in the Institutional Method calculation of the parent contribution. | NUMBER | ||

IM_PARENT_MULTI_ENROLLMENT_ADJ | Percentage of adjustment to the parent contribution for differing numbers of family members in college. Prior to 2001, this contains the number in college as used in the calculation of EFC. | NUMBER | ||

IM_PARENT_NET_WORTH | Amount of the parent's net worth used in the primary calculation. | NUMBER | ||

IM_PARENT_OTH_ASSET_ALLOW_OVR | Amount of the other asset allowance (override) used in the parent Institutional Method calculation. | NUMBER | ||

IM_PARENT_REAL_ESTATE_EQUITY | Amount of other real estate/investment equity used in the parent's Institutional Method calculation. | NUMBER | ||

IM_PARENT_SECONDARY_TUITION_PD | The amount of elementary, jr. high, and high school tuition paid by the student's secondary parent contributor in the base year. | NUMBER | ||

IM_PARENT_STAND_MAINT_ALLOW | Standard maintenance allownace used in the Institutional Method calculation of the parent contribution. | NUMBER | ||

IM_PARENT_STATE_PROV_TAX_PAID | Amount of state and other taxes paid used in the Institutional Method calculation of the parent contribution. | NUMBER | ||

IM_PARENT_TOTAL_ALLOWANCE | Estimated amount of total allowances used in the parent's Institutional Method calculation. | NUMBER | ||

IM_PARENT_TOTAL_CONTRIBUTION | Total parent contribution before the number in college adjustment for the Institutional Method calculation. | NUMBER | ||

IM_PARENT_TOTAL_INCOME | Total income used in the calculation of the parent Institutional Method contribution. | NUMBER | ||

IM_PARENT_TOTAL_UNTAX_INCOME | Amount of total untaxed income used in the parent's Institutional Method calculation. | NUMBER | ||

IM_PARENT_WAGE_TAX_PAID | Amount of wage taxes used in the Institutional Method calculation of the parent contribution. | NUMBER | ||

IM_REAL_ESTATE_EQUITY | Amount of other real estate/investment equity used in the student's Institutional Method calculation. | NUMBER | ||

IM_SECOND_TUITION_PAID | Amount of elementary/secondary school tuition paid that was used in the student's Institutional Method calculation. | NUMBER | ||

IM_STAND_MAINT_ALLOWANCE | Standard maintenance allowance used in the Institutional Method calculation of the student's contribution. | NUMBER | ||

IM_STATE_PROVINCE_TAX_PAID | Amount of state or province and other taxes used in the student's Institutional Method calculation. | NUMBER | ||

IM_TAXABLE_INCOME_CONTRIBUTION | Taxable income contribution for single independent students for the Institutional Method calculation. | NUMBER | ||

IM_TOTAL_ALLOWANCES | Amount of total allowances used in the student's Institutional Method calculation. | NUMBER | ||

IM_TOTAL_CONTRIBUTION | Total student contribution before the number in college adjustment for the Institutional Method calculation. | NUMBER | ||

IM_TOTAL_FAMILY_CONTRIBUTION | Primary institutional methodology total family contribution. | NUMBER | ||

IM_TOTAL_INCOME | The total income used in the student's Institutional Method calculation. | NUMBER | ||

IM_TOTAL_UNTAX_INCOME | Amount of total untaxed income used in the student's primary calculation. | NUMBER | ||

IM_TRUST_AMOUNT | Amount of the student trust account used in the student Institutional Method calculation. | NUMBER | ||

IM_UNASSESSED_VETERAN_BENEFITS | Unassessed VA benefits used in the primary Institutional Method student contribution calculation. | NUMBER | ||

IM_VETERAN_BENEFITS_IND | Indicates if VA benefits have been included in the calculation of the student's Institutional Method contribution. | VARCHAR2(63) | ||

IM_WAGE_TAX_PAID | Amount of wage taxes used in the student's IM calculation. | NUMBER | ||

INTERFACE_TAPE_CODE | Interface tape table indicating the source and format of the application record. (e.g., ACT, CSS, SAT, etc.). | VARCHAR2(63) | ||

INTERFACE_TAPE_DESC | Description of the interface tape code. | VARCHAR2(255) | ||

MULTI_SOURCE | Institution value for the record when the optional multi-institution facility feature has been applied. | VARCHAR2(63) | ||

MULTI_SOURCE_DESC | Institution description when the optional multi-institution facility feature has been applied. | VARCHAR2(255) | ||

NAME | Name of the person (last name, first name, middle initial) or organization. | VARCHAR2(255) | ||

PERSON_UID | System generated, unique, internal identification number assigned to this person. | NUMBER | ||

PROCESS_GROUP | Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. | VARCHAR2(255) | ||

USER_ID | Unique identification code of the user who entered or last touched the transaction. | VARCHAR2(63) |

Ver: 8.0