Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
(Banner EDW Source Report)
Financial Aid Reporting View Reports

Banner Operational Data Store
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

RCRAPP2

RCRAPP2_ACTIVITY_DATE

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

NA

NA

AID_YEAR Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation. VARCHAR2(63)

RCRAPP2

RCRAPP2_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

APPLICATION_NUMBER Financial aid application unique sequence number. NUMBER

RCRAPP2

RCRAPP2_SEQ_NO

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

RCRAPP1

RCRAPP1_CURR_REC_IND

EFM_DEPENDENCY_STATUS Calculated Estimated Federal Method dependency status. VARCHAR2(63)

RCRAPP4

RCRAPP4_EFM_FORMULA_FOR_CALC

EFM_DEPENDENCY_STATUS_DESC Estimated Federal Method calculated dependency status description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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

RCRAPP2

RCRAPP2_C_1_ADJ_AVAIL_INC

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

RCRAPP2

RCRAPP2_C_1_ADJ_BF_NET_WTH

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

RCRAPP2

RCRAPP2_C_1_AGI_TAX_INC

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

RCRAPP2

RCRAPP2_C_1_ANLY_TYPE

FM_ANALYSIS_TYPE_DESC Analysis type description. VARCHAR2(255)

CALCULATION

RORMVAL

DECODE(RCRAPP2_C_1_ANLY_TYPE)

RORMVAL_DESC

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

RCRAPP2

RCRAPP2_C_1_PROT_ALLOW

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

RCRAPP2

RCRAPP2_C_1_AVAIL_DISC_INC

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

RCRAPP2

RCRAPP2_C_1_AVAIL_TAX_INC

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

RCRAPP2

RCRAPP2_C_1_CALC_AVAIL_INC

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

RCRAPP2

RCRAPP2_C_1_CASH_AMT

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

RCRAPP2

RCRAPP2_C_1_CTRB_FR_ASSET

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

RCRAPP2

RCRAPP2_C_1_CTRB_FR_INC

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

RCRAPP2

RCRAPP2_C_1_CTRB_OFFL_EST

FM_CONTRIBUTION_OFFICIAL_AMT Official student contribution amount. NUMBER

RCRAPP4

RCRAPP4_C_NA_1_CTRB_FOR_STDT

FM_CONTRIBUTION_OFFICIAL_DESC Contribution official description. VARCHAR2(255)

CALCULATION

RORMVAL

DECODE(RCRAPP2_C_1_CTRB_OFFL_EST)

RORMVAL_DESC

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

RCRAPP2

RCRAPP2_C_1_CONV_PCT

FM_DEPENDENCY_STATUS Calculated Federal Method dependency status. VARCHAR2(63)

RCRAPP4

RCRAPP4_FM_FORMULA_FOR_CALC

FM_DEPENDENCY_STATUS_DESC Estimated Federal Method calculated dependency status description. VARCHAR2(255)

RORMVAL

RORMVAL_DESC

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

RCRAPP2

RCRAPP2_C_1_DISC_NET_WTH

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

RCRAPP2

RCRAPP2_C_1_EMP_ALLOW

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

RCRAPP2

RCRAPP2_PELL_ADJ_BF_NET_WTH

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

RCRAPP2

RCRAPP2_PELL_AGI_TAX_INC

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

RCRAPP2

RCRAPP2_PELL_PROT_ALLOW

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

RCRAPP2

RCRAPP2_PELL_AVAIL_DISC_INC

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

RCRAPP2

RCRAPP2_PELL_CASH_AMT

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

RCRAPP2

RCRAPP2_PELL_CTRB_FR_ASSET

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

RCRAPP2

RCRAPP2_PELL_CTRB_FR_INC

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

RCRAPP2

RCRAPP2_PELL_CTRB_OFFL_EST

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

CALCULATION

DECODE(RCRAPP2_PELL_CTRB_OFFL_EST)

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

RCRAPP2

RCRAPP2_PELL_CONV_PCT

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

RCRAPP2

RCRAPP2_PELL_DISC_NET_WTH

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

RCRAPP2

RCRAPP2_PELL_EMP_ALLOW

FM_EST_FAMILY_IN_COLLEGE Student's estimated family members in college. NUMBER

RCRAPP2

RCRAPP2_PELL_NO_IN_COLL

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

RCRAPP2

RCRAPP2_PELL_US_INC_TAX

FM_EST_INAS The student estimated contribution for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_PELL_CTRB_FOR_STDT

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

RCRAPP2

RCRAPP2_PELL_NET_WTH

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

RCRAPP4

RCRAPP4_C_1_OTH_ASSET

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

RCRAPP2

RCRAPP2_PELL_RE_INV_VAL

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

RCRAPP2

RCRAPP2_PELL_MNT_ALLOW

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

RCRAPP2

RCRAPP2_PELL_ST_OTH_TAX

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

RCRAPP2

RCRAPP2_PELL_TOT_ALLOW

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

RCRAPP2

RCRAPP2_PELL_TOT_CTRB

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

RCRAPP2

RCRAPP2_PELL_TOT_INC

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

RCRAPP2

RCRAPP2_PELL_TOT_UNTAX_INC

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

RCRAPP2

RCRAPP2_C_1_NO_IN_COLL

FM_FAMILY_SIZE Independent student's computed number of family members in the household. NUMBER

CALCULATION

DECODE(RCRAPP2_MODEL_CDE)

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

RCRAPP2

RCRAPP2_C_1_US_INC_TAX

FM_FISAP_TOTAL_INCOME Indicates the person's total FISAP income. NUMBER

RCRAPP4

RCRAPP4_FISAP_INC

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

RCRAPP4

RCRAPP4_FORMULA_FOR_CALC

FM_FORMULA_DESC FM formula description. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP4_FORMULA_FOR_CALC)

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

RCRAPP2

RCRAPP2_C_1_HME_VAL

FM_INAS The student contribution for the primary calculation. NUMBER

RCRAPP2

RCRAPP2_C_1_CTRB_FOR_STDT

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

RCRAPP2

RCRAPP2_C_1_INC_SUPPLEMENT

FM_MARITAL_STATUS Student's computed marital status. VARCHAR2(63)

RCRAPP2

RCRAPP2_C_MRTL_STATUS

FM_MARITAL_STATUS_DESC Student marital status description. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP2_C_MRTL_STATUS)

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

RCRAPP2

RCRAPP2_C_1_MED_DEN_EXP

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

RCRAPP2

RCRAPP2_C_1_NET_WTH

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

RCRAPP2

RCRAPP2_C_PAR_1_AGI_TAX_INC

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

RCRAPP2

RCRAPP2_C_PAR_1_ADJ_AVAIL_INC

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

RCRAPP2

RCRAPP2_C_PAR_1_ADJ_BF_NET_WTH

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

RCRAPP2

RCRAPP2_C_PAR_1_ANLY_TYPE

FM_PARENT_ANALYSIS_TYPE_DESC Analysis type description. VARCHAR2(255)

CALCULATION

RORMVAL

DECODE(RCRAPP2_C_PAR_1_ANLY_TYPE)

RORMVAL_DESC

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

RCRAPP2

RCRAPP2_C_PAR_1_PROT_ALLOW

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

RCRAPP2

RCRAPP2_C_PAR_1_AVAIL_DISC_INC

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

RCRAPP2

RCRAPP2_C_PAR_1_CASH_AMT

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

RCRAPP2

RCRAPP2_C_PAR_1_CTRB_FR_ASSET

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

RCRAPP2

RCRAPP2_C_PAR_1_CTRB_FR_INC

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

RCRAPP2

RCRAPP2_C_PAR_1_CTRB_OFFL_EST

FM_PARENT_CONTRIB_OFFICIAL_AMT Official parent contribution amount. NUMBER

RCRAPP4

RCRAPP4_C_NA_1_P_CTRB_FOR_STDT

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

RCRAPP4

RCRAPP4_C_NA_1_P_CTRB_OFFL_EST

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

RORMVAL

RORMVAL_DESC

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

CALCULATION

RORMVAL

DECODE(RCRAPP4_C_NA_1_P_CTRB_OFFL_EST)

RORMVAL_DESC

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

RCRAPP2

RCRAPP2_C_PAR_1_CONV_PCT

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

RCRAPP4

RCRAPP4_FM_PAR_DATA_AVAIL

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

RCRAPP2

RCRAPP2_C_PAR_1_DISC_NET_WTH

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

RCRAPP2

RCRAPP2_C_PAR_1_EMP_ALLOW

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

RCRAPP2

RCRAPP2_PELL_P_AGI_TAX_INC

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

RCRAPP2

RCRAPP2_PELL_P_ANLY_TYPE

FM_PARENT_EST_ANAL_TYPE_DESC Analysis type description. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP2_PELL_P_ANLY_TYPE)

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

RCRAPP2

RCRAPP2_PELL_P_US_INC_TAX

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

RCRAPP4

RCRAPP4_C_PAR_1_INC_ADJ

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

RCRAPP4

RCRAPP4_C_PAR_1_OTH_ASSET

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

RCRAPP4

RCRAPP4_C_PAR_1_OTH_ALLOW

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

RCRAPP2

RCRAPP2_PELL_P_ST_OTH_TAX

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

RCRAPP2

RCRAPP2_PELL_P_TOT_INC

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

RCRAPP2

RCRAPP2_PELL_P_TOT_UNTAX_INC

FM_PARENT_FAMILY_IN_COLLEGE Number of people in the parents household who will be in college as used in the calculation of the parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_NO_IN_COLL

FM_PARENT_FAMILY_SIZE Parent's computed number of family members in the household. NUMBER

RCRAPP2

RCRAPP2_C_PAR_FAM_MEMB

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

RCRAPP2

RCRAPP2_C_PAR_1_US_INC_TAX

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

RCRAPP2

RCRAPP2_C_PAR_1_HME_VAL

FM_PARENT_INAS Primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_C_PAR_1_CTRB_FOR_STDT

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

RCRAPP2

RCRAPP2_C_PAR_1_INC_SUPPLEMENT

FM_PARENT_MARITAL_STATUS Parent's computed marital status. VARCHAR2(63)

RCRAPP2

RCRAPP2_C_PAR_MRTL_STATUS

FM_PARENT_MARITAL_STATUS_DESC Parent marital status description. VARCHAR2(255)

CALCULATION

DECODE(RCRAPP2_C_PAR_MRTL_STATUS)

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

RCRAPP2

RCRAPP2_C_PAR_1_MED_DEN_EXP

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

RCRAPP2

RCRAPP2_C_PAR_1_NET_WTH

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

RCRAPP2

RCRAPP2_C_PAR_1_RE_INV_VAL

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

RCRAPP2

RCRAPP2_C_PAR_1_SCH_TUIT

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

RCRAPP2

RCRAPP2_C_PAR_1_MNT_ALLOW

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

RCRAPP2

RCRAPP2_C_PAR_1_ST_OTH_TAX

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

RCRAPP2

RCRAPP2_C_PAR_1_TOT_ALLOW

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

RCRAPP2

RCRAPP2_C_PAR_1_TOT_CTRB

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

RCRAPP2

RCRAPP2_C_PAR_1_TOT_INC

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

RCRAPP2

RCRAPP2_C_PAR_1_TOT_UNTAX_INC

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

RCRAPP2

RCRAPP2_C_PAR_1_FICA_TAX

FM_PARENT_WORKSHEET_A_TOTAL Parents' Worksheet A untaxed income total. NUMBER

RCRAPP4

RCRAPP4_PAR_WORKSHEET_A

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

RCRAPP2

RCRAPP2_C_1_RE_INV_VAL

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

RCRAPP2

RCRAPP2_C_1_SCH_TUIT

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

RCRAPP2

RCRAPP2_C_1_MNT_ALLOW

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

RCRAPP2

RCRAPP2_C_1_ST_OTH_TAX

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

RCRAPP2

RCRAPP2_C_1_TAX_INC_CTRB

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

RCRAPP2

RCRAPP2_C_1_TOT_ALLOW

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

RCRAPP2

RCRAPP2_C_1_TOT_CTRB

FM_TOTAL_FAMILY_CONTRIBUTION Total family contribution for the federal methodology calculation. NUMBER

RCRAPP4

RCRAPP4_C_INST_1_TOT_FAM_CTRB

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

RCRAPP2

RCRAPP2_C_1_TOT_INC

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

RCRAPP2

RCRAPP2_C_1_TOT_UNTAX_INC

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

CALCULATION

DECODE(RCRAPP2_C_1_VA_BEN_INCL)

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

RCRAPP2

RCRAPP2_C_1_FICA_TAX

FM_WORKSHEET_A_TOTAL Student's Worksheet A untaxed income total. NUMBER

RCRAPP4

RCRAPP4_WORKSHEET_A

ID Identification number assigned to a person that is used externally for all communication and correspondence with the person. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

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

RCRAPP2

RCRAPP2_INFC_CODE

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

RTVINFC

RTVINFC_DESC

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

NA

NA

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

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PELL_EFC The primary system Pell PGI. NUMBER

RCRAPP2

RCRAPP2_PELL_PGI

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

RCRAPP2

RCRAPP2_PELL_PGI_OFFL_EST

PELL_EFC_OFFICIAL_DESC Pell PGI official description. VARCHAR2(255)

CALCULATION

RORMVAL

DECODE(RCRAPP2_PELL_PGI_OFFL_EST)

RORMVAL_DESC

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

RCRAPP4

RCRAPP4_C_NA_1_PELL_OFFL_EST

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

CALCULATION

RORMVAL

DECODE(RCRAPP4_C_NA_1_PELL_OFFL_EST)

RORMVAL_DESC

PELL_EFFECTIVE_FAMILY_CONT Student Pell effective family contribution. NUMBER

RCRAPP4

RCRAPP4_C_NA_1_PELL_PGI

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

RCRAPP2

RCRAPP2_PIDM

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

NA

NA

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

RCRAPP2

RCRAPP2_USER_ID



Ver: 9.1