| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ACTIVITY_DATE
|
Activity Date
|
Date record was inserted or updated.
|
DATE
|
RCRAPP2
|
RCRAPP2_ACTIVITY_DATE
|
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
AID_YEAR
|
Financial 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 Description
|
Financial aid year name.
|
VARCHAR2(255)
|
FUNCTION
|
GOKODSF.F_GET_DESC
|
|
APPLICATION_NUMBER
|
Application Number
|
Financial aid application unique sequence number.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_SEQ_NO
|
|
CURRENT_RECORD_IND
|
Current Record Indicator
|
Specifies that this is the current need analysis record.
|
VARCHAR2(63)
|
RCRAPP1
|
RCRAPP1_CURR_REC_IND
|
|
ID
|
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
|
|
IM_ADJUSTED_AVAILABLE_INCOME
|
Institution Method Adjusted Available Income
|
Amount of the adjusted available income that was used in the Institutional Method calculation of the student contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_ADJ_AVAIL_INC
|
|
IM_ADJUSTED_BUS_NET_WORTH
|
Institution Method Adjusted Bus Net Worth
|
Amount of business and farm net worth used in the calculation of the Institutional Method student contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_ADJ_BF_NET_WTH
|
|
IM_ADJUSTED_GROSS_INCOME
|
Institution Method Adjusted Gross Income
|
Adjusted gross taxable income used in the calculation of the Institutional Method student contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_AGI_TAX_INC
|
|
IM_ANALYSIS_TYPE
|
Institution Method Analysis Type
|
Analysis type used for the Institutional Method student contribution.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_IM_1_ANLY_TYPE
|
|
IM_ANALYSIS_TYPE_DESC
|
Institution Method Analysis Type Description
|
Analysis type description.
|
VARCHAR2(255)
|
RORMVAL
|
RORMVAL_DESC
|
|
IM_ASSET_PROTECT_ALLOWANCE
|
Institution Method Asset Protect Allowance
|
Asset protection allowance used in the calculation of the student Institutional Method contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_PROT_ALLOW
|
|
IM_AVAILABLE_INCOME
|
Institution Method Available Income
|
Student's available discretionary income for the Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_AVAIL_DISC_INC
|
|
IM_AVAILABLE_TAX_INCOME
|
Institution Method Available Tax Income
|
Student's available taxable income for the Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_AVAIL_TAX_INC
|
|
IM_BUDGET_DURATION
|
Institution Method Budget Duration
|
Budget duration used for the Institutional Method calculation.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_IM_BUDG_DUR_FOR_CALC
|
|
IM_CALC_AVAILABLE_INCOME
|
Institution Method Calculated Available Income
|
Student's calculated available income for the Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_CALC_AVAIL_INC
|
|
IM_CASH_AMOUNT
|
Institution Method Cash Amount
|
Student's amounts in cash, savings and checking accounts used in the Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_CASH_AMT
|
|
IM_CONTRIBUTION
|
Institution Method Contribution
|
Primary institutional methodology student contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_IM_1_SC
|
|
IM_CONTRIBUTION_AMOUNT
|
Institution Method Contribution Amount
|
Student Institutional Method contribution amount.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_C_NA_1_IM_CTRB_STDT
|
|
IM_CONTRIBUTION_ASSET
|
Institution Method Contribution Asset
|
Student's contribution from assets for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_CTRB_FR_ASSET
|
|
IM_CONTRIBUTION_INCOME
|
Institution Method Contribution Income
|
Student's contribution from income for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_CTRB_FR_INC
|
|
IM_CONTRIBUTION_OFFICIAL
|
Institution Method Contribution Official
|
Indicates if the Institutional Method student contribution is official or estimated.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_C_2_CTRB_OFFL_EST
|
|
IM_CONTRIBUTION_OFFICIAL_DESC
|
Institution Method Contribution Official Description
|
Description of the Institutional Method student contribution.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRAPP2_C_2_CTRB_OFFL_EST)
|
|
IM_CONVERSION_PERCENT
|
Institution Method Conversion Percent
|
Conversion percent used in the student's Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_CONV_PCT
|
|
IM_CUSTODIAL_PARENT
|
Institution Method Custodial Parent
|
Custodial parent used for Institutional Method only calculation of custodial parent's adjustment contribution.
|
VARCHAR2(63)
|
RCRAPP4
|
RCRAPP4_CUSTODIAL_PARENT
|
|
IM_CUSTODIAL_PARENT_DESC
|
Institution Method Custodial Parent Description
|
Institutional Method custodial parent description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRAPP4_CUSTODIAL_PARENT)
|
|
IM_DEPENDENCY_STATUS
|
Institution Method Dependency Status
|
Calculated Institutional Method dependency status. This may be different than the EFM or Federal Method values.
|
VARCHAR2(63)
|
RCRAPP4
|
RCRAPP4_IM_FORMULA_FOR_CALC
|
|
IM_DEPENDENCY_STATUS_DESC
|
Institution Method Dependency Status Description
|
Institutional Method calculated dependency status description.
|
VARCHAR2(255)
|
RORMVAL
|
RORMVAL_DESC
|
|
IM_DISCRET_NET_WORTH
|
Institution Method Discret Net Worth
|
Student's discretionary net worth used in the Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_DISC_NET_WTH
|
|
IM_EMPLOYMENT_ALLOWANCE
|
Institution Method Employment Allowance
|
Employment allowance used in the calculation of the student Institutional Method contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_EMP_ALLOW
|
|
IM_FEDERAL_TAX_PAID
|
Institution Method Federal Tax Paid
|
Amount of federal income taxes paid used in the calculation of the Institutional Method student contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_US_INC_TAX
|
|
IM_HOME_EQUITY
|
Institution Method Home Equity
|
Home equity used in the student's Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_HME_VAL
|
|
IM_INAS
|
Institution Method INAS
|
The student contribution for the Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_CTRB_FOR_STDT
|
|
IM_INCOME_SUPPLEMENT
|
Institution Method Income Supplement
|
Amount of the income supplement used in the student's Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_INC_SUPPLEMENT
|
|
IM_MEDICAL_DENTAL_EXPENSE
|
Institution Method Medical Dental Expense
|
Amount of medical or dental expenses used in the student's Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_MED_DEN_EXP
|
|
IM_MONTHLY_OTHER_VET_AMOUNT
|
Institution Method Monthly Other Vet Amount
|
Amount per month from other veteran educational benefit programs.
|
NUMBER
|
RCRAPP1
|
RCRAPP1_OTH_VA_AMT
|
|
IM_MULTI_ENROLL_ADJUSTED
|
Institution Method Multi Enrollment 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
|
RCRAPP2
|
RCRAPP2_C_2_NO_IN_COLL
|
|
IM_NET_WORTH
|
Institution Method Net Worth
|
Amount of the student's net worth used in the Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_NET_WTH
|
|
IM_OTHER_ASSET_ALLOW_OVR
|
Institution Method Other Asset Allow Ovr
|
Amount of the other asset allowance (override) used in the student Institutional Method calculation.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_C_2_OTH_ASSET_ALLOW
|
|
IM_OTHER_ASSET_OVR
|
Institution Method Other Asset Ovr
|
Amount of the other asset (override) used in the student Institutional Method calculation.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_C_2_OTH_ASSET
|
|
IM_OTHER_VET_NUMBER_OF_MONTHS
|
Institution Method Other Vet Number Of Months
|
Number of months that the other veteran educational benefits will be received during the award year.
|
NUMBER
|
RCRAPP1
|
RCRAPP1_OTH_VA_MTH
|
|
IM_PARENT_ADJUST_GROSS_INCOME
|
Institution Method Parent Adjustment Gross Income
|
Adjusted gross taxable income used in the calculation of the secondary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_AGI_TAX_INC
|
|
IM_PARENT_ADJ_AVAILABLE_INCOME
|
Institution Method Parent Adjustment Available Income
|
Adjusted available income used in the calculation of the Institutional Method parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_ADJ_AVAIL_INC
|
|
IM_PARENT_ADJ_BUS_NET_WORTH
|
Institution Method Parent Adjustment Bus Net Worth
|
Amount of business and farm net worth used in the calculation of the secondary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_ADJ_BF_NET_WTH
|
|
IM_PARENT_ANALYSIS_TYPE
|
Institution Method Parent Analysis Type
|
Analysis type used for the Institutional Method parent contribution.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_IM_1_PAR_ANLY_TYPE
|
|
IM_PARENT_ANALYSIS_TYPE_DESC
|
Institution Method Parent Analysis Type Description
|
Analysis type description.
|
VARCHAR2(255)
|
RORMVAL
|
RORMVAL_DESC
|
|
IM_PARENT_ASSET_PROT_ALLOWANCE
|
Institution Method Parent Asset Prot Allowance
|
Amount of the parent's asset protection allowance used in the calculation of the primary parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_PROT_ALLOW
|
|
IM_PARENT_AVAILABLE_INCOME
|
Institution Method Parent Available Income
|
Parent's available discretionary income for the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_AVAIL_DISC_INC
|
|
IM_PARENT_CASH_AMOUNT
|
Institution Method Parent Cash Amount
|
Parent's estimated amounts in cash, savings and checking accounts used in the Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_CASH_AMT
|
|
IM_PARENT_CONTRIBUTION
|
Institution Method Parent Contribution
|
Primary institutional methodology parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_IM_1_PC
|
|
IM_PARENT_CONTRIBUTION_AMOUNT
|
Institution Method Parent Contribution Amount
|
Parent Institutional Method contribution amount.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_C_NA_1_P_IM_CTRB_STDT
|
|
IM_PARENT_CONTRIBUTION_ASSET
|
Institution Method Parent Contribution Asset
|
Portion of the primary parent contribution that came from income.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_CTRB_FR_ASSET
|
|
IM_PARENT_CONTRIBUTION_INCOME
|
Institution Method Parent Contribution Income
|
Portion of the primary parent contribution that came from income.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_CTRB_FR_INC
|
|
IM_PARENT_CONTRIB_OFFICIAL
|
Institution Method Parent Contribution Official
|
Indicates if the Institutional Method parent contribution is official or estimated.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_C_PAR_2_CTRB_OFFL_EST
|
|
IM_PARENT_CONTRIB_OFF_DESC
|
Institution Method Parent Contribution Off Description
|
Description of the Institutional Method parent contribution.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RCRAPP2_C_PAR_2_CTRB_OFFL_EST)
|
|
IM_PARENT_CONVERSION_PERCENT
|
Institution Method Parent Conversion Percent
|
Conversion percent used in the parent's Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_CONV_PCT
|
|
IM_PARENT_DATA_AVAILABLE_IND
|
Institution Method Parent Data Available Indicator
|
Indicates whether parent data was available for the Institutional Method calculation.
|
VARCHAR2(63)
|
RCRAPP4
|
RCRAPP4_IM_PAR_DATA_AVAIL
|
|
IM_PARENT_DISCRET_NET_WORTH
|
Institution Method Parent Discret Net Worth
|
Parent's discretionary net worth used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_DISC_NET_WTH
|
|
IM_PARENT_EMPLOYMENT_ALLOWANCE
|
Institution Method Parent Employment Allowance
|
Employment allowance used in the Institutional Method calculation of the parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_EMP_ALLOW
|
|
IM_PARENT_FEDERAL_INCOME_TAX
|
Institution Method Parent Federal Income Tax
|
Amount of federal income tax paid by the parent.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_US_INC_TAX
|
|
IM_PARENT_HOME_EQUITY
|
Institution Method Parent Home Equity
|
Home equity used in the parent's Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_HME_VAL
|
|
IM_PARENT_INAS
|
Institution Method Parent INAS
|
The parent contribution for the Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_CTRB_FOR_STDT
|
|
IM_PARENT_INCOME_SUPPLEMENT
|
Institution Method Parent Income Supplement
|
Amount of the income supplement used in the parent's Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_INC_SUPPLEMENT
|
|
IM_PARENT_MEDICAL_DENTAL_EXP
|
Institution Method Parent Medical Dental Expiration
|
Amount of medical and dental expenses used in the Institutional Method calculation of the parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_MED_DEN_EXP
|
|
IM_PARENT_MULTI_ENROLLMENT_ADJ
|
Institution Method Parent Multi Enrollment Adjustment
|
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
|
RCRAPP2
|
RCRAPP2_C_PAR_2_NO_IN_COLL
|
|
IM_PARENT_NET_WORTH
|
Institution Method Parent Net Worth
|
Amount of the parent's net worth used in the primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_NET_WTH
|
|
IM_PARENT_OTH_ASSET_ALLOW_OVR
|
Institution Method Parent Oth Asset Allow Ovr
|
Amount of the other asset allowance (override) used in the parent Institutional Method calculation.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_C_PAR_2_OTH_ASSET_ALLW
|
|
IM_PARENT_REAL_ESTATE_EQUITY
|
Institution Method Parent Real Estate Equity
|
Amount of other real estate/investment equity used in the parent's Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_RE_INV_VAL
|
|
IM_PARENT_SECONDARY_TUITION_PD
|
Institution Method 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
|
RCRAPP2
|
RCRAPP2_C_PAR_2_SCH_TUIT
|
|
IM_PARENT_STAND_MAINT_ALLOW
|
Institution Method Parent Stand Maint Allow
|
Standard maintenance allownace used in the Institutional Method calculation of the parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_MNT_ALLOW
|
|
IM_PARENT_STATE_PROV_TAX_PAID
|
Institution Method Parent State Province Tax Paid
|
Amount of state and other taxes paid used in the Institutional Method calculation of the parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_ST_OTH_TAX
|
|
IM_PARENT_TOTAL_ALLOWANCE
|
Institution Method Parent Total Allowance
|
Estimated amount of total allowances used in the parent's Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_TOT_ALLOW
|
|
IM_PARENT_TOTAL_CONTRIBUTION
|
Institution Method Parent Total Contribution
|
Total parent contribution before the number in college adjustment for the Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_TOT_CTRB
|
|
IM_PARENT_TOTAL_INCOME
|
Institution Method Parent Total Income
|
Total income used in the calculation of the parent Institutional Method contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_TOT_INC
|
|
IM_PARENT_TOTAL_UNTAX_INCOME
|
Institution Method Parent Total Untax Income
|
Amount of total untaxed income used in the parent's Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_TOT_UNTAX_INC
|
|
IM_PARENT_WAGE_TAX_PAID
|
Institution Method Parent Wage Tax Paid
|
Amount of wage taxes used in the Institutional Method calculation of the parent contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_PAR_2_FICA_TAX
|
|
IM_REAL_ESTATE_EQUITY
|
Institution Method Real Estate Equity
|
Amount of other real estate/investment equity used in the student's Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_RE_INV_VAL
|
|
IM_SECOND_TUITION_PAID
|
Institution Method Second Tuition Paid
|
Amount of elementary/secondary school tuition paid that was used in the student's Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_SCH_TUIT
|
|
IM_STAND_MAINT_ALLOWANCE
|
Institution Method Stand Maint Allowance
|
Standard maintenance allowance used in the Institutional Method calculation of the student's contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_MNT_ALLOW
|
|
IM_STATE_PROVINCE_TAX_PAID
|
Institution Method State Province Tax Paid
|
Amount of state or province and other taxes used in the student's Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_ST_OTH_TAX
|
|
IM_TAXABLE_INCOME_CONTRIBUTION
|
Institution Method Taxable Income Contribution
|
Taxable income contribution for single independent students for the Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_TAX_INC_CTRB
|
|
IM_TOTAL_ALLOWANCES
|
Institution Method Total Allowances
|
Amount of total allowances used in the student's Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_TOT_ALLOW
|
|
IM_TOTAL_CONTRIBUTION
|
Institution Method Total Contribution
|
Total student contribution before the number in college adjustment for the Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_TOT_CTRB
|
|
IM_TOTAL_FAMILY_CONTRIBUTION
|
Institution Method Total Family Contribution
|
Primary institutional methodology total family contribution.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_IM_1_TFC
|
|
IM_TOTAL_INCOME
|
Institution Method Total Income
|
The total income used in the student's Institutional Method calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_TOT_INC
|
|
IM_TOTAL_UNTAX_INCOME
|
Institution Method Total Untax Income
|
Amount of total untaxed income used in the student's primary calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_TOT_UNTAX_INC
|
|
IM_TRUST_AMOUNT
|
Institution Method Trust Amount
|
Amount of the student trust account used in the student Institutional Method calculation.
|
NUMBER
|
RCRAPP4
|
RCRAPP4_C_2_TRUST_VAL
|
|
IM_UNASSESSED_VETERAN_BENEFITS
|
Institution Method Unassessed Veteran Benefits
|
Unassessed VA benefits used in the primary Institutional Method student contribution calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_IM_1_UNASSESSED_VA
|
|
IM_VETERAN_BENEFITS_IND
|
Institution Method Veteran Benefits Indicator
|
Indicates if VA benefits have been included in the calculation of the student's Institutional Method contribution.
|
VARCHAR2(63)
|
CALCULATION
|
DECODE(RCRAPP2_C_2_VA_BEN_INCL)
|
|
IM_WAGE_TAX_PAID
|
Institution Method Wage Tax Paid
|
Amount of wage taxes used in the student's IM calculation.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_C_2_FICA_TAX
|
|
INTERFACE_TAPE_CODE
|
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
|
Interface Tape Description
|
Description of the interface tape code.
|
VARCHAR2(255)
|
RTVINFC
|
RTVINFC_DESC
|
|
MULTI_SOURCE
|
Multi Source
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
|
NAME
|
Name
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
RCRAPP2
|
RCRAPP2_PIDM
|
|
PROCESS_GROUP
|
Process Group
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
USER_ID
|
User ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(63)
|
RCRAPP2
|
RCRAPP2_USER_ID
|