Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ACTIVITY_DATE
|
Date record was inserted or updated.
|
DATE
|
RCRAPP2
|
RCRAPP2_ACTIVITY_DATE
|
NO
|
NO
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
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
|
NO
|
NO
|
AID_YEAR_DESC
|
Financial aid year name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
NO
|
NO
|
APPLICATION_NUMBER
|
Financial aid application unique sequence number.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_SEQ_NO
|
NO
|
NO
|
CURRENT_RECORD_IND
|
Specifies that this is the current need analysis record.
|
VARCHAR2(63)
|
RCRAPP1
|
RCRAPP1_CURR_REC_IND
|
NO
|
NO
|
EFM_DEPENDENCY_STATUS
|
Calculated Estimated Federal Method dependency status.
|
VARCHAR2(63)
|
RCRAPP4
|
RCRAPP4_EFM_FORMULA_FOR_CALC
|
NO
|
NO
|
EFM_DEPENDENCY_STATUS_DESC
|
Estimated Federal Method calculated dependency status description.
|
VARCHAR2(255)
|
RORMVAL
|
RORMVAL_DESC
|
NO
|
NO
|
FM_ADJUSTED_AVAIL_INCOME
|
Student's calculated adjusted available income for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_ADJ_AVAIL_INC
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_ADJUSTED_GROSS_INCOME
|
Student's adjusted gross taxable income for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_AGI_TAX_INC
|
NO
|
NO
|
FM_ANALYSIS_TYPE
|
Analysis type used to determine the primary Student Calculation.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_C_1_ANLY_TYPE
|
NO
|
NO
|
FM_ANALYSIS_TYPE_DESC
|
Analysis type description.
|
VARCHAR2(255)
|
CALCULATION RORMVAL
|
DECODE(RCRAPP2_C_1_ANLY_TYPE) RORMVAL_DESC
|
NO NO
|
NO
|
FM_ASSET_PROTECT_ALLOWANCE
|
Amount of the student's asset protection allowance in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_PROT_ALLOW
|
NO
|
NO
|
FM_AVAILABLE_INCOME
|
Student's available discretionary income for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_AVAIL_DISC_INC
|
NO
|
NO
|
FM_AVAILABLE_TAX_INCOME
|
Student's available taxable income for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_AVAIL_TAX_INC
|
NO
|
NO
|
FM_CALC_AVAILABLE_INCOME
|
Student's calculated available income for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_CALC_AVAIL_INC
|
NO
|
NO
|
FM_CASH_AMOUNT
|
Student's amounts in cash, savings and checking accounts used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_CASH_AMT
|
NO
|
NO
|
FM_CONTRIBUTION_ASSET
|
Student's contribution from assets for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_CTRB_FR_ASSET
|
NO
|
NO
|
FM_CONTRIBUTION_INCOME
|
Student's contribution from income for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_CTRB_FR_INC
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_CONTRIBUTION_OFFICIAL_AMT
|
Official student contribution amount.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_C_NA_1_CTRB_FOR_STDT
|
NO
|
NO
|
FM_CONTRIBUTION_OFFICIAL_DESC
|
Contribution official description.
|
VARCHAR2(255)
|
CALCULATION RORMVAL
|
DECODE(RCRAPP2_C_1_CTRB_OFFL_EST) RORMVAL_DESC
|
NO NO
|
NO
|
FM_CONVERSION_PERCENT
|
Conversion percent used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_CONV_PCT
|
NO
|
NO
|
FM_DEPENDENCY_STATUS
|
Calculated Federal Method dependency status.
|
VARCHAR2(63)
|
RCRAPP4
|
RCRAPP4_FM_FORMULA_FOR_CALC
|
NO
|
NO
|
FM_DEPENDENCY_STATUS_DESC
|
Estimated Federal Method calculated dependency status description.
|
VARCHAR2(255)
|
RORMVAL
|
RORMVAL_DESC
|
NO
|
NO
|
FM_DISCRET_NET_WORTH
|
Student's discretionary net worth used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_DISC_NET_WTH
|
NO
|
NO
|
FM_EMPLOYMENT_ALLOWANCE
|
Student's employment allowance used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_EMP_ALLOW
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_EST_AGI
|
Total estimated adjusted gross income used in the calculation of the primary student contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_AGI_TAX_INC
|
NO
|
NO
|
FM_EST_ASSET_PROT_ALLOWANCE
|
Student's estimated asset protection allowance used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_PROT_ALLOW
|
NO
|
NO
|
FM_EST_AVAILABLE_INCOME
|
Student's estimated available discretionary income used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_AVAIL_DISC_INC
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_EST_CONTRIBUTION_ASSET
|
Portion of the estimated primary parent contribution that came from assets.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_CTRB_FR_ASSET
|
NO
|
NO
|
FM_EST_CONTRIBUTION_INCOME
|
Portion of the estimated primary parent contribution that came from income.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_CTRB_FR_INC
|
NO
|
NO
|
FM_EST_CONTRIBUTION_OFFICIAL
|
Indicates if the estimated primary parent contribution is official or estimated.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_PELL_CTRB_OFFL_EST
|
NO
|
NO
|
FM_EST_CONTRIB_OFFICIAL_DESC
|
Description of the estimated primary parent contribution.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRAPP2_PELL_CTRB_OFFL_EST)
|
NO
|
NO
|
FM_EST_CONVERSION_PERCENT
|
Student's estimated conversion percentage used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_CONV_PCT
|
NO
|
NO
|
FM_EST_DISCRET_NET_WORTH
|
Student's estimated discretionary net worth used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_DISC_NET_WTH
|
NO
|
NO
|
FM_EST_EMPLOYMENT_ALLOWANCE
|
Total estimated employment allowance used in the calculation of the primary student contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_EMP_ALLOW
|
NO
|
NO
|
FM_EST_FAMILY_IN_COLLEGE
|
Student's estimated family members in college.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_NO_IN_COLL
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_EST_INAS
|
The student estimated contribution for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_CTRB_FOR_STDT
|
NO
|
NO
|
FM_EST_NET_WORTH
|
Student's estimated net worth used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_NET_WTH
|
NO
|
NO
|
FM_EST_OTHER_ASSET
|
Amount of the other asset (override) used in the student FM calculation.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_C_1_OTH_ASSET
|
NO
|
NO
|
FM_EST_REAL_ESTATE_EQ
|
Student's estimated real estate equity used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_RE_INV_VAL
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_EST_TOTAL_ALLOWANCE
|
Estimated amount of total allowances used in the student's FM calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_TOT_ALLOW
|
NO
|
NO
|
FM_EST_TOTAL_CONTRIBUTION
|
Student's estimated total contribution used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_TOT_CTRB
|
NO
|
NO
|
FM_EST_TOTAL_INCOME
|
Total estimated income used in the calculation of the primary student contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_TOT_INC
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_FAMILY_SIZE
|
Independent student's computed number of family members in the household.
|
NUMBER
|
CALCULATION
|
DECODE(RCRAPP2_MODEL_CDE)
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_FISAP_TOTAL_INCOME
|
Indicates the person's total FISAP income.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_FISAP_INC
|
NO
|
NO
|
FM_FORMULA
|
Formula used for the FM calculation.
|
VARCHAR2(63)
|
RCRAPP4
|
RCRAPP4_FORMULA_FOR_CALC
|
NO
|
NO
|
FM_FORMULA_DESC
|
FM formula description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRAPP4_FORMULA_FOR_CALC)
|
NO
|
NO
|
FM_HOME_EQUITY
|
Home equity used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_HME_VAL
|
NO
|
NO
|
FM_INAS
|
The student contribution for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_CTRB_FOR_STDT
|
NO
|
NO
|
FM_INCOME_SUPPLEMENT
|
Amount of the income supplement used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_INC_SUPPLEMENT
|
NO
|
NO
|
FM_MARITAL_STATUS
|
Student's computed marital status.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_C_MRTL_STATUS
|
NO
|
NO
|
FM_MARITAL_STATUS_DESC
|
Student marital status description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRAPP2_C_MRTL_STATUS)
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_NET_WORTH
|
Amount of the student's net worth used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_NET_WTH
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_PARENT_ANALYSIS_TYPE
|
Analysis type used to determine the primary Parent Calculation.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_C_PAR_1_ANLY_TYPE
|
NO
|
NO
|
FM_PARENT_ANALYSIS_TYPE_DESC
|
Analysis type description.
|
VARCHAR2(255)
|
CALCULATION RORMVAL
|
DECODE(RCRAPP2_C_PAR_1_ANLY_TYPE) RORMVAL_DESC
|
NO NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_PARENT_CONTRIBUTION_ASSET
|
Portion of the primary parent contribution that came from assets.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_CTRB_FR_ASSET
|
NO
|
NO
|
FM_PARENT_CONTRIBUTION_INCOME
|
Portion of the primary parent contribution that came from income.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_CTRB_FR_INC
|
NO
|
NO
|
FM_PARENT_CONTRIB_OFFICIAL
|
Indicates if the primary parent contribution is official or estimated.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_C_PAR_1_CTRB_OFFL_EST
|
NO
|
NO
|
FM_PARENT_CONTRIB_OFFICIAL_AMT
|
Official parent contribution amount.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_C_NA_1_P_CTRB_FOR_STDT
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_PARENT_CONTRIB_OFF_DESC
|
Description of the primary parent contribution.
|
VARCHAR2(255)
|
RORMVAL
|
RORMVAL_DESC
|
NO
|
NO
|
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
|
NO NO
|
NO
|
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
|
NO
|
NO
|
FM_PARENT_DATA_AVAILABLE_IND
|
Indicates whether parent data was available for the FM calculation.
|
VARCHAR2(63)
|
RCRAPP4
|
RCRAPP4_FM_PAR_DATA_AVAIL
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_PARENT_EMPLOYMENT_ALLOWANCE
|
Employment allowance used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_EMP_ALLOW
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_PARENT_EST_ANALYSIS_TYPE
|
Analysis type for the primary system PGI.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_PELL_P_ANLY_TYPE
|
NO
|
NO
|
FM_PARENT_EST_ANAL_TYPE_DESC
|
Analysis type description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRAPP2_PELL_P_ANLY_TYPE)
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_PARENT_EST_INCOME_ADJUST
|
Amount of the income adjustment used in the parent FM calculation.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_C_PAR_1_INC_ADJ
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_PARENT_EST_TOTAL_INCOME
|
Total estimated income used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_P_TOT_INC
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_PARENT_FAMILY_SIZE
|
Parent's computed number of family members in the household.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_FAM_MEMB
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_PARENT_HOME_EQUITY
|
Home equity used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_HME_VAL
|
NO
|
NO
|
FM_PARENT_INAS
|
Primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_CTRB_FOR_STDT
|
NO
|
NO
|
FM_PARENT_INCOME_SUPPLEMENT
|
Income supplement used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_INC_SUPPLEMENT
|
NO
|
NO
|
FM_PARENT_MARITAL_STATUS
|
Parent's computed marital status.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_C_PAR_MRTL_STATUS
|
NO
|
NO
|
FM_PARENT_MARITAL_STATUS_DESC
|
Parent marital status description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRAPP2_C_PAR_MRTL_STATUS)
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_PARENT_NET_WORTH
|
Net worth used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_NET_WTH
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_PARENT_TOTAL_ALLOWANCES
|
Total allowances used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_TOT_ALLOW
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_PARENT_TOTAL_INCOME
|
Total income used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_1_TOT_INC
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_PARENT_WORKSHEET_A_TOTAL
|
Parents' Worksheet A untaxed income total.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_PAR_WORKSHEET_A
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_STAND_MAINT_ALLOWANCE
|
Standard maintenance allowance used in the calculation of the student's contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_MNT_ALLOW
|
NO
|
NO
|
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
|
NO
|
NO
|
FM_TAXABLE_INCOME_CONTRIBUTION
|
Taxable income contribution for single independent students for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_TAX_INC_CTRB
|
NO
|
NO
|
FM_TOTAL_ALLOWANCES
|
Amount of total allowances used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_TOT_ALLOW
|
NO
|
NO
|
FM_TOTAL_CONTRIBUTION
|
Total student contribution before the number in college adjustment for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_TOT_CTRB
|
NO
|
NO
|
FM_TOTAL_FAMILY_CONTRIBUTION
|
Total family contribution for the federal methodology calculation.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_C_INST_1_TOT_FAM_CTRB
|
NO
|
NO
|
FM_TOTAL_INCOME
|
The total income used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_TOT_INC
|
NO
|
NO
|
FM_TOTAL_UNTAX_INCOME
|
Amount of total untaxed income used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_TOT_UNTAX_INC
|
NO
|
NO
|
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)
|
NO
|
NO
|
FM_WAGE_TAX_PAID
|
Amount of wage taxes used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_1_FICA_TAX
|
NO
|
NO
|
FM_WORKSHEET_A_TOTAL
|
Student's Worksheet A untaxed income total.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_WORKSHEET_A
|
NO
|
NO
|
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
|
NO
|
NO
|
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
|
NO
|
NO
|
INTERFACE_TAPE_DESC
|
Description of the interface tape code.
|
VARCHAR2(255)
|
RTVINFC
|
RTVINFC_DESC
|
NO
|
NO
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
NAME
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
PELL_EFC
|
The primary system Pell PGI.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PELL_PGI
|
NO
|
NO
|
PELL_EFC_OFFICIAL
|
Indicates if the primary system Pell PGI is official or estimated.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_PELL_PGI_OFFL_EST
|
NO
|
NO
|
PELL_EFC_OFFICIAL_DESC
|
Pell PGI official description.
|
VARCHAR2(255)
|
CALCULATION RORMVAL
|
DECODE(RCRAPP2_PELL_PGI_OFFL_EST) RORMVAL_DESC
|
NO NO
|
NO
|
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
|
NO
|
NO
|
PELL_EFC_OFFICIAL_EST_DESC
|
Pell EFC official/estimate description.
|
VARCHAR2(255)
|
CALCULATION RORMVAL
|
DECODE(RCRAPP4_C_NA_1_PELL_OFFL_EST) RORMVAL_DESC
|
NO NO
|
NO
|
PELL_EFFECTIVE_FAMILY_CONT
|
Student Pell effective family contribution.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_C_NA_1_PELL_PGI
|
NO
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PIDM
|
NO
|
NO
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
USER_ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_USER_ID
|
NO
|
NO
|