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

Financial Aid Reporting View Reports |

Reporting View Target: NEED_ANALYSIS_FEDERAL_METHOD

Description
| Contains information specific to the federal methodology for 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) | ||

FM_ADJUSTED_AVAIL_INCOME | Student's calculated adjusted available income for the primary calculation. | NUMBER | ||

FM_ADJUSTED_BUS_NET_WORTH | Amount of business and farm net worth used in the calculation of the primary student contribution. | NUMBER | ||

FM_ADJUSTED_GROSS_INCOME | Student's adjusted gross taxable income for the primary calculation. | NUMBER | ||

FM_ANALYSIS_TYPE | Analysis type used to determine the primary Student Calculation. | VARCHAR2(63) | ||

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

FM_ASSET_PROTECT_ALLOWANCE | Amount of the student's asset protection allowance in the primary calculation. | NUMBER | ||

FM_AVAILABLE_INCOME | Student's available discretionary income for the primary calculation. | NUMBER | ||

FM_AVAILABLE_TAX_INCOME | Student's available taxable income for the primary calculation. | NUMBER | ||

FM_CALC_AVAILABLE_INCOME | Student's calculated available income for the primary calculation. | NUMBER | ||

FM_CASH_AMOUNT | Student's amounts in cash, savings and checking accounts used in the primary calculation. | NUMBER | ||

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

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

FM_CONTRIBUTION_OFFICIAL | Indicates if the student contribution for the primary calculation is official or estimated. | VARCHAR2(63) | ||

FM_CONTRIBUTION_OFFICIAL_AMT | Official student contribution amount. | NUMBER | ||

FM_CONTRIBUTION_OFFICIAL_DESC | Contribution official description. | VARCHAR2(255) | ||

FM_CONVERSION_PERCENT | Conversion percent used in the student's primary calculation. | NUMBER | ||

FM_DISCRET_NET_WORTH | Student's discretionary net worth used in the primary calculation. | NUMBER | ||

FM_EMPLOYMENT_ALLOWANCE | Student's employment allowance used in the primary calculation. | NUMBER | ||

FM_EST_ADJUSTED_BUS_NET_WORTH | Student's adjusted business or farm net worth used in the primary calculation. | NUMBER | ||

FM_EST_AGI | Total estimated adjusted gross income used in the calculation of the primary student contribution. | NUMBER | ||

FM_EST_ASSET_PROT_ALLOWANCE | Student's estimated asset protection allowance used in the primary calculation. | NUMBER | ||

FM_EST_AVAILABLE_INCOME | Student's estimated available discretionary income used in the student's primary calculation. | NUMBER | ||

FM_EST_CASH_AMOUNT | Student's estimated amounts in cash, savings and checking accounts used in the primary calculation. | NUMBER | ||

FM_EST_CONTRIBUTION_ASSET | Portion of the estimated primary parent contribution that came from assets. | NUMBER | ||

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

FM_EST_CONTRIBUTION_OFFICIAL | Indicates if the estimated primary parent contribution is official or estimated. | VARCHAR2(63) | ||

FM_EST_CONTRIB_OFFICIAL_DESC | Description of the estimated primary parent contribution. | VARCHAR2(255) | ||

FM_EST_CONVERSION_PERCENT | Student's estimated conversion percentage used in the primary calculation. | NUMBER | ||

FM_EST_DISCRET_NET_WORTH | Student's estimated discretionary net worth used in the primary calculation. | NUMBER | ||

FM_EST_EMPLOYMENT_ALLOWANCE | Total estimated employment allowance used in the calculation of the primary student contribution. | NUMBER | ||

FM_EST_FAMILY_IN_COLLEGE | Student's estimated family members in college. | NUMBER | ||

FM_EST_FEDERAL_TAX_PAID | Total estimated federal taxes used in the calculation of the primary student contribution. | NUMBER | ||

FM_EST_INAS | The student estimated contribution for the primary calculation. | NUMBER | ||

FM_EST_NET_WORTH | Student's estimated net worth used in the primary calculation. | NUMBER | ||

FM_EST_OTHER_ASSET | Amount of the other asset (override) used in the student FM calculation. | NUMBER | ||

FM_EST_REAL_ESTATE_EQ | Student's estimated real estate equity used in the primary calculation. | NUMBER | ||

FM_EST_STAND_MAINT_ALLOWANCE | Total estimated standard maintenance allowance used in the calculation of the primary student contribution. | NUMBER | ||

FM_EST_STATE_PROV_TAX_PAID | Total estimated state or province taxes used in the calculation of the primary student contribution. | NUMBER | ||

FM_EST_TOTAL_ALLOWANCE | Estimated amount of total allowances used in the student's FM calculation. | NUMBER | ||

FM_EST_TOTAL_CONTRIBUTION | Student's estimated total contribution used in the primary calculation. | NUMBER | ||

FM_EST_TOTAL_INCOME | Total estimated income used in the calculation of the primary student contribution. | NUMBER | ||

FM_EST_TOTAL_UNTAX_INCOME | Total estimated untaxable income used in the calculation of the primary student contribution. | NUMBER | ||

FM_FAMILY_IN_COLLEGE | Number of people in the student's household that will be in college as used in the student's primary calculation. | NUMBER | ||

FM_FEDERAL_TAX_PAID | Amount of federal income taxes paid used in the student's primary calculation. | NUMBER | ||

FM_FORMULA | Formula used for the FM calculation. | VARCHAR2(63) | ||

FM_FORMULA_DESC | FM formula description. | VARCHAR2(255) | ||

FM_HOME_EQUITY | Home equity used in the student's primary calculation. | NUMBER | ||

FM_INAS | The student contribution for the primary calculation. | NUMBER | ||

FM_INCOME_SUPPLEMENT | Amount of the income supplement used in the student's primary calculation. | NUMBER | ||

FM_MEDICAL_DENTAL_EXPENSE | Amount of medical and dental expenses used in the student's primary calculation. | NUMBER | ||

FM_NET_WORTH | Amount of the student's net worth used in the primary calculation. | NUMBER | ||

FM_PARENT_ADJUST_GROSS_INCOME | The adjusted gross taxable income used in the calculation of the primary parents' contribution. | NUMBER | ||

FM_PARENT_ADJ_AVAILABLE_INCOME | Amount of the adjusted available income that was used in the primary calculation of the parent contribution. | NUMBER | ||

FM_PARENT_ADJ_BUS_NET_WORTH | Adjusted business/farm net worth used in the primary calculation of the parent contribution. | NUMBER | ||

FM_PARENT_ANALYSIS_TYPE | Analysis type used to determine the primary Parent Calculation. | VARCHAR2(63) | ||

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

FM_PARENT_ASSET_PROT_ALLOWANCE | Asset protection allowance used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_AVAILABLE_INCOME | Available discretionary income used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_CASH_AMOUNT | Amount of parents' cash, savings and checking accounts used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_CONTRIBUTION_ASSET | Portion of the primary parent contribution that came from assets. | NUMBER | ||

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

FM_PARENT_CONTRIB_OFFICIAL | Indicates if the primary parent contribution is official or estimated. | VARCHAR2(63) | ||

FM_PARENT_CONTRIB_OFFICIAL_AMT | Official parent contribution amount. | NUMBER | ||

FM_PARENT_CONTRIB_OFFICIAL_EST | Indicates if the parental contribution amount is official or estimated. | VARCHAR2(63) | ||

FM_PARENT_CONTRIB_OFF_DESC | Description of the primary parent contribution. | VARCHAR2(255) | ||

FM_PARENT_CONTRIB_OFF_EST_DESC | Parent contribution official/estimate description. | VARCHAR2(255) | ||

FM_PARENT_CONVERSION_PERCENT | Discretionary net worth conversion percent used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_DATA_AVAILABLE_IND | Indicates whether parent data was available for the FM calculation. | VARCHAR2(63) | ||

FM_PARENT_DISCRET_NET_WORTH | Discretionary net worth used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_EMPLOYMENT_ALLOWANCE | Employment allowance used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_EST_AGI | The estimated adjusted gross taxable income used in the calculation of the primary parents' contribution. | NUMBER | ||

FM_PARENT_EST_ANALYSIS_TYPE | Analysis type for the primary system PGI. | VARCHAR2(63) | ||

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

FM_PARENT_EST_FEDERAL_TAX_PAID | Amount of estimated federal taxes used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_EST_INCOME_ADJUST | Amount of the income adjustment used in the parent FM calculation. | NUMBER | ||

FM_PARENT_EST_OTHER_ASSET | Amount of the other asset (override) used in the parent FM calculation. | NUMBER | ||

FM_PARENT_EST_OTH_INCOME_ALLOW | Amount of the other income allowance (override) used in the parent FM calculation. | NUMBER | ||

FM_PARENT_EST_STAT_PROV_TAX_PD | Amount of estimated state_province taxes used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_EST_TOTAL_INCOME | Total estimated income used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_EST_TOT_UNTAX_INCOME | The estimated total untaxed income used in the calculation of the primary parent's contribution. | NUMBER | ||

FM_PARENT_FEDERAL_TAX_PAID | Amount of US income taxes paid used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_HOME_EQUITY | Home equity used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_INAS | Primary parent contribution. | NUMBER | ||

FM_PARENT_INCOME_SUPPLEMENT | Income supplement used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_MEDICAL_DENTAL_EXP | Amount of medical and dental expenses used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_NET_WORTH | Net worth used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_REAL_ESTATE_EQUITY | Other real estate and investment equity used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_SECONDARY_TUITION_PD | Amount of elementary and secondary school tuition paid used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_STAND_MAINT_ALLOW | Standard maintenance allowance used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_STATE_PROV_TAX_PAID | Amount of state and other taxes paid used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_TOTAL_ALLOWANCES | Total allowances used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_TOTAL_CONTRIBUTION | Total primary parent contribution before adjustment for the number of family members in college. | NUMBER | ||

FM_PARENT_TOTAL_INCOME | Total income used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_TOTAL_UNTAX_INCOME | Total untaxed income used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_WAGE_TAX_PAID | Amount of wage taxes used in the calculation of the primary parent contribution. | NUMBER | ||

FM_PARENT_WORKSHEET_A_TOTAL | Parents' Worksheet A untaxed income total. | NUMBER | ||

FM_REAL_ESTATE_EQUITY | Amount of other real estate/investment equity used in the student's primary calculation. | NUMBER | ||

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

FM_STAND_MAINT_ALLOWANCE | Standard maintenance allowance used in the calculation of the student's contribution. | NUMBER | ||

FM_STATE_PROVINCE_TAX_PAID | Amount of state or province and other taxes used in the student's primary calculation. | NUMBER | ||

FM_TAXABLE_INCOME_CONTRIBUTION | Taxable income contribution for single independent students for the primary calculation. | NUMBER | ||

FM_TOTAL_ALLOWANCES | Amount of total allowances used in the student's primary calculation. | NUMBER | ||

FM_TOTAL_CONTRIBUTION | Total student contribution before the number in college adjustment for the primary calculation. | NUMBER | ||

FM_TOTAL_FAMILY_CONTRIBUTION | Total family contribution for the federal methodology calculation. | NUMBER | ||

FM_TOTAL_INCOME | The total income used in the student's primary calculation. | NUMBER | ||

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

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

FM_WAGE_TAX_PAID | Amount of wage taxes used in the student's primary calculation. | NUMBER | ||

FM_WORKSHEET_A_TOTAL | Student's Worksheet A untaxed income total. | NUMBER | ||

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

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) | ||

PELL_EFC | The primary system Pell PGI. | NUMBER | ||

PELL_EFC_OFFICIAL | Indicates if the primary system Pell PGI is official or estimated. | VARCHAR2(63) | ||

PELL_EFC_OFFICIAL_DESC | Pell PGI official description. | VARCHAR2(255) | ||

PELL_EFC_OFFICIAL_ESTIMATE | Indicates if the Pell parental contribution amount is official or estimated. | VARCHAR2(63) | ||

PELL_EFC_OFFICIAL_EST_DESC | Pell EFC official/estimate description. | VARCHAR2(255) | ||

PELL_EFFECTIVE_FAMILY_CONT | Student Pell effective family contribution. | NUMBER | ||

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