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