| Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ACTIVITY_DATE
|
Date record was inserted or updated.
|
DATE
|
RCRESAR
|
RCRESAR_ACTIVITY_DATE
|
|
AID_YEAR
|
Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).
|
VARCHAR2(4)
|
RCRESAR
|
RCRESAR_AIDY_CODE
|
|
APPLICATION_NUMBER
|
Financial aid application unique sequence number.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_SEQ_NO
|
|
APPLICATION_SOURCE_SITE
|
Indicates the origin of the initial application and the site of the location.
|
VARCHAR2(2)
|
RCRESAR
|
RCRESAR_AGENCY_IND
|
|
ASSUMED_AGI
|
Student's assumed adjusted gross income.
|
NUMBER(6)
|
RCRESAR
|
RCRESAR_A_US_INC
|
|
ASSUMED_CITIZENSHIP
|
Code to determine assumptions about the student's citizenship.
|
VARCHAR2(1)
|
RCRESAR
|
RCRESAR_A_CITZ_IND
|
|
ASSUMED_CITIZENSHIP_DESC
|
Assumed citizen description.
|
VARCHAR2(15)
|
CALCULATION
|
DECODE(RCRESAR_A_CITZ_IND)
|
|
ASSUMED_DEPENDENT_IND
|
Assumed number of student dependents.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(RCRESAR_A_S_DEPENDANTS)
|
|
ASSUMED_INCOME_TAX_PAID
|
Assumed amount of Federal Tax paid by the student.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_A_S_FIT
|
|
ASSUMED_INCOME_WORK
|
Student's assumed income from work.
|
NUMBER(6)
|
RCRESAR
|
RCRESAR_A_INC_FR_WRK
|
|
ASSUMED_MARRIED_IND
|
Indicates that an assumption is used to determine that a student is married.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(RCRESAR_A_MARRIED)
|
|
ASSUMED_SUPPORT_CHILD
|
Assumed student has children who receive more than half of their support from him/her.
|
VARCHAR2(1)
|
RCRESAR
|
RCRESAR_A_HAVE_CHILDREN
|
|
ASSUMED_VETERAN_IND
|
Assumed veteran status of the student.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(RCRESAR_A_VA_STATUS)
|
|
ASSUMED_WORKSHEET_C_TOT
|
Assumed student's worksheet C Title IV income exclusions total.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_A_S_WORKSHEET_C
|
|
AUTOMATIC_ZERO_EFC_IND
|
Expected family contribution automatically set to zero based on income criteria.
|
VARCHAR2(1)
|
CALCULATION
|
NVL(RCRESAR_AUTO_ZERO_EFC_FLAG)
|
|
BATCH_ID
|
ID of the batch, assigned by the processor, from which this ESAR data was loaded into the system.
|
VARCHAR2(23)
|
RCRESAR
|
RCRESAR_BATCH_ID
|
|
COMMENT1
|
ISIR comment code 1.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_COMM_CODE_01
|
|
COMMENT10
|
ISIR comment code 10.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_COMM_CODE_10
|
|
COMMENT10_DESC
|
ISIR comment code 10 description.
|
VARCHAR2(1000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT11
|
ISIR comment code 11.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_COMM_CODE_11
|
|
COMMENT11_DESC
|
ISIR comment code 11 description.
|
VARCHAR2(1000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT12
|
ISIR comment code 12.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_COMM_CODE_12
|
|
COMMENT12_DESC
|
ISIR comment code 12 description.
|
VARCHAR2(1000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT13
|
ISIR comment code 13.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_COMM_CODE_13
|
|
COMMENT13_DESC
|
ISIR comment code 13 description.
|
VARCHAR2(1000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT14
|
ISIR comment code 14.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_COMM_CODE_14
|
|
COMMENT14_DESC
|
ISIR comment code 14 description.
|
VARCHAR2(1000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT15
|
ISIR comment code 15.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_COMM_CODE_15
|
|
COMMENT15_DESC
|
ISIR comment code 15 description.
|
VARCHAR2(1000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT16
|
ISIR comment code 16.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_COMM_CODE_16
|
|
COMMENT16_DESC
|
ISIR comment code 16 description.
|
VARCHAR2(1000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT17
|
ISIR comment code 17.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_COMM_CODE_17
|
|
COMMENT17_DESC
|
ISIR comment code 17 description.
|
VARCHAR2(1000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT18
|
ISIR comment code 18.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_COMM_CODE_18
|
|
COMMENT18_DESC
|
ISIR comment code 18 description.
|
VARCHAR2(1000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT19
|
ISIR comment code 19.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_COMM_CODE_19
|
|
COMMENT19_DESC
|
ISIR comment code 19 description.
|
VARCHAR2(1000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT1_DESC
|
ISIR comment code 1 description.
|
VARCHAR2(1000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT2
|
ISIR comment code 2.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_COMM_CODE_02
|
|
COMMENT20
|
ISIR comment code 20.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_COMM_CODE_20
|
|
COMMENT20_DESC
|
ISIR comment code 20 description.
|
VARCHAR2(1000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT2_DESC
|
ISIR comment code 2 description.
|
VARCHAR2(1000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT3
|
ISIR comment code 3.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_COMM_CODE_03
|
|
COMMENT3_DESC
|
ISIR comment code 3 description.
|
VARCHAR2(1000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT4
|
ISIR comment code 4.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_COMM_CODE_04
|
|
COMMENT4_DESC
|
ISIR comment code 4 description.
|
VARCHAR2(1000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT5
|
ISIR comment code 5.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_COMM_CODE_05
|
|
COMMENT5_DESC
|
ISIR comment code 5 description.
|
VARCHAR2(1000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT6
|
ISIR comment code 6.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_COMM_CODE_06
|
|
COMMENT6_DESC
|
ISIR comment code 6 description.
|
VARCHAR2(1000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT7
|
ISIR comment code 7.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_COMM_CODE_07
|
|
COMMENT7_DESC
|
ISIR comment code 7 description.
|
VARCHAR2(1000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT8
|
ISIR comment code 8.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_COMM_CODE_08
|
|
COMMENT8_DESC
|
ISIR comment code 8 description.
|
VARCHAR2(1000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMMENT9
|
ISIR comment code 9.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_COMM_CODE_09
|
|
COMMENT9_DESC
|
ISIR comment code 9 description.
|
VARCHAR2(1000)
|
FUNCTION
|
ROKODSF.F_GET_COMMENT_DESC
|
|
COMPUTED_BATCH_NUMBER
|
Computed batch number assigned by the Central Processor to this ISIR.
|
NUMBER(3)
|
RCRESAR
|
RCRESAR_COMPUTE_BATCH_NO
|
|
CORRECTION_APPLIED_TRANS_NO
|
Indicates the transaction number to which the history correction was applied
|
VARCHAR2(2)
|
RCRESAR
|
RCRESAR_CORR_APPL
|
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
|
DESTINATION_NUMBER
|
The TGXXXXX number for the destination code of the transaction.
|
VARCHAR2(7)
|
RCRESAR
|
RCRESAR_ETI_DEST_CODE
|
|
DOMAIN_VALUE
|
Domain column for future use, not currently populated.
|
VARCHAR2(6)
|
NA
|
NA
|
|
DUPLICATE_REQUEST_IND
|
Indicates that the record was sent to the institution as a result of a request for a duplicate ISIR.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(RCRESAR_DUP_REQ_IND)
|
|
ELECT_APPL_ENTRY_SOURCE_IND
|
The origin of the electronic application.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(RCRESAR_EDE_INST_IND)
|
|
FAMILY_IN_COLLEGE
|
Number of student's family members in college.
|
NUMBER(1)
|
RCRESAR
|
RCRESAR_A_NO_IN_COLL
|
|
FAMILY_SIZE
|
Size of the student's family.
|
NUMBER(2)
|
RCRESAR
|
RCRESAR_A_FAM_MEMB
|
|
FATHER_ASSUMED_INCOME_WORK
|
Father's assumed income from work.
|
NUMBER(6)
|
RCRESAR
|
RCRESAR_A_FATH_INC_FR_WRK
|
|
FATHER_ASSUMED_TAX_ID
|
Assumed Father's tax ID number.
|
VARCHAR2(9)
|
RCRESAR
|
RCRESAR_A_FATH_SSN
|
|
FEDERAL_HOUSING1
|
Federal housing code associated with the student's first federal college choice.
|
VARCHAR2(1)
|
RCRESAR
|
RCRESAR_FED_HOUS_CDE_1
|
|
FEDERAL_HOUSING1_DESC
|
Federal housing code description.
|
VARCHAR2(15)
|
CALCULATION
|
DECODE(RCRESAR_FED_HOUS_CDE_1)
|
|
FEDERAL_HOUSING2
|
Federal housing code associated with the student's second federal college choice.
|
VARCHAR2(1)
|
RCRESAR
|
RCRESAR_FED_HOUS_CDE_2
|
|
FEDERAL_HOUSING2_DESC
|
Federal housing code description.
|
VARCHAR2(15)
|
CALCULATION
|
DECODE(RCRESAR_FED_HOUS_CDE_2)
|
|
FEDERAL_HOUSING3
|
Federal housing code associated with the student's third federal college choice.
|
VARCHAR2(1)
|
RCRESAR
|
RCRESAR_FED_HOUS_CDE_3
|
|
FEDERAL_HOUSING3_DESC
|
Federal housing code description.
|
VARCHAR2(15)
|
CALCULATION
|
DECODE(RCRESAR_FED_HOUS_CDE_3)
|
|
FEDERAL_HOUSING4
|
Federal housing code associated with the student's fourth federal college choice.
|
VARCHAR2(1)
|
RCRESAR
|
RCRESAR_FED_HOUS_CDE_4
|
|
FEDERAL_HOUSING4_DESC
|
Federal housing code description.
|
VARCHAR2(15)
|
CALCULATION
|
DECODE(RCRESAR_FED_HOUS_CDE_4)
|
|
FEDERAL_HOUSING5
|
Federal housing code associated with the student's fifth federal college choice.
|
VARCHAR2(1)
|
RCRESAR
|
RCRESAR_FED_HOUS_CDE_5
|
|
FEDERAL_HOUSING5_DESC
|
Federal housing code description.
|
VARCHAR2(15)
|
CALCULATION
|
DECODE(RCRESAR_FED_HOUS_CDE_5)
|
|
FEDERAL_HOUSING6
|
Federal housing code associated with the student's sixth federal college choice.
|
VARCHAR2(1)
|
RCRESAR
|
RCRESAR_FED_HOUS_CDE_6
|
|
FEDERAL_HOUSING6_DESC
|
Federal housing code description.
|
VARCHAR2(15)
|
CALCULATION
|
DECODE(RCRESAR_FED_HOUS_CDE_6)
|
|
INPUT_RECORD_TYPE
|
Type of Input Record.
|
VARCHAR2(1)
|
RCRESAR
|
RCRESAR_INPUT_REC_TYPE
|
|
INTERFACE_TAPE_CODE
|
Interface tape table indicating the source and format of the application record. (e.g., ACT, CSS, SAT, etc.).
|
VARCHAR2(7)
|
RCRESAR
|
RCRESAR_INFC_CODE
|
|
ISIR_ELECT_TRANSACTION
|
One character code that Indicates whether the school receiving the ISIR submitted input to generate the ISIR transaction or did not generate the transaction, but was listed on the record. Also indicates whether the type of ISIR is a daily, requested, or pushed ISIR.
|
VARCHAR2(1)
|
RCRESAR
|
RCRESAR_EDE_ETI_IND
|
|
ISIR_ELECT_TRANSACTION_DESC
|
ISIR electronic transaction description.
|
VARCHAR2(125)
|
CALCULATION
|
DECODE(RCRESAR_EDE_ETI_IND)
|
|
MARITAL_STATUS_IND
|
Indicates the marital status of the student.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(RCRESAR_A_MRTL_STATUS_IND)
|
|
MIF_DESC
|
The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(30)
|
NA
|
NA
|
|
MIF_VALUE
|
The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(6)
|
NA
|
NA
|
|
MONTH10_FAMILY_CONTRIB_PRIMARY
|
Month 10, primary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_1_FC_10_MTH_CALC
|
|
MONTH10_FAMILY_CONTRIB_SECOND
|
Month 10, secondary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_2_FC_10_MTH_CALC
|
|
MONTH11_FAMILY_CONTRIB_PRIMARY
|
Month 11, primary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_1_FC_11_MTH_CALC
|
|
MONTH11_FAMILY_CONTRIB_SECOND
|
Month 11, secondary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_2_FC_11_MTH_CALC
|
|
MONTH12_FAMILY_CONTRIB_PRIMARY
|
Month 12, primary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_1_FC_12_MTH_CALC
|
|
MONTH12_FAMILY_CONTRIB_SECOND
|
Month 12, secondary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_2_FC_12_MTH_CALC
|
|
MONTH1_FAMILY_CONTRIB_PRIMARY
|
Month 1, primary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_1_FC_01_MTH_CALC
|
|
MONTH1_FAMILY_CONTRIB_SECOND
|
Month 1, secondary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_2_FC_01_MTH_CALC
|
|
MONTH2_FAMILY_CONTRIB_PRIMARY
|
Month 2, primary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_1_FC_02_MTH_CALC
|
|
MONTH2_FAMILY_CONTRIB_SECOND
|
Month 2, secondary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_2_FC_02_MTH_CALC
|
|
MONTH3_FAMILY_CONTRIB_PRIMARY
|
Month 3, primary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_1_FC_03_MTH_CALC
|
|
MONTH3_FAMILY_CONTRIB_SECOND
|
Month 3, secondary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_2_FC_03_MTH_CALC
|
|
MONTH4_FAMILY_CONTRIB_PRIMARY
|
Month 4, primary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_1_FC_04_MTH_CALC
|
|
MONTH4_FAMILY_CONTRIB_SECOND
|
Month 4, secondary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_2_FC_04_MTH_CALC
|
|
MONTH5_FAMILY_CONTRIB_PRIMARY
|
Month 5, primary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_1_FC_05_MTH_CALC
|
|
MONTH5_FAMILY_CONTRIB_SECOND
|
Month 5, secondary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_2_FC_05_MTH_CALC
|
|
MONTH6_FAMILY_CONTRIB_PRIMARY
|
Month 6, primary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_1_FC_06_MTH_CALC
|
|
MONTH6_FAMILY_CONTRIB_SECOND
|
Month 6, secondary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_2_FC_06_MTH_CALC
|
|
MONTH7_FAMILY_CONTRIB_PRIMARY
|
Month 7, primary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_1_FC_07_MTH_CALC
|
|
MONTH7_FAMILY_CONTRIB_SECOND
|
Month 7, secondary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_2_FC_07_MTH_CALC
|
|
MONTH8_FAMILY_CONTRIB_PRIMARY
|
Month 8, primary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_1_FC_08_MTH_CALC
|
|
MONTH8_FAMILY_CONTRIB_SECOND
|
Month 8, secondary family contribution.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_ALT_2_FC_08_MTH_CALC
|
|
MOTHER_ASSUMED_INCOME_WORK
|
Mother's assumed income from work.
|
NUMBER(6)
|
RCRESAR
|
RCRESAR_A_MOTH_INC_FR_WRK
|
|
MOTHER_ASSUMED_TAX_ID
|
Assumed Mother's tax ID number.
|
VARCHAR2(9)
|
RCRESAR
|
RCRESAR_A_MOTH_SSN
|
|
MULTI_SCHOOL_FLAG1
|
Multi School Code Flag 1
|
VARCHAR2(1)
|
RCRESAR
|
RCRESAR_M_SCHOOL_FLAG_1
|
|
MULTI_SCHOOL_FLAG1_DESC
|
Multi School Code Flag 1 description.
|
VARCHAR2(125)
|
CALCULATION
|
DECODE(RCRESAR_M_SCHOOL_FLAG_1)
|
|
MULTI_SCHOOL_FLAG2
|
Multi School Code Flag 2.
|
VARCHAR2(1)
|
RCRESAR
|
RCRESAR_M_SCHOOL_FLAG_2
|
|
MULTI_SCHOOL_FLAG2_DESC
|
Multi School Code Flag 2 description.
|
VARCHAR2(125)
|
CALCULATION
|
DECODE(RCRESAR_M_SCHOOL_FLAG_2)
|
|
MULTI_SCHOOL_FLAG3
|
Multi School Code Flag 3.
|
VARCHAR2(1)
|
RCRESAR
|
RCRESAR_M_SCHOOL_FLAG_3
|
|
MULTI_SCHOOL_FLAG3_DESC
|
Multi School Code Flag 3 description.
|
VARCHAR2(125)
|
CALCULATION
|
DECODE(RCRESAR_M_SCHOOL_FLAG_3)
|
|
MULTI_SCHOOL_FLAG4
|
Multi School Code Flag 4.
|
VARCHAR2(1)
|
RCRESAR
|
RCRESAR_M_SCHOOL_FLAG_4
|
|
MULTI_SCHOOL_FLAG4_DESC
|
Multi School Code Flag 4 description.
|
VARCHAR2(125)
|
CALCULATION
|
DECODE(RCRESAR_M_SCHOOL_FLAG_4)
|
|
MULTI_SCHOOL_FLAG5
|
Multi School Code Flag 5.
|
VARCHAR2(1)
|
RCRESAR
|
RCRESAR_M_SCHOOL_FLAG_5
|
|
MULTI_SCHOOL_FLAG5_DESC
|
Multi School Code Flag 5 description.
|
VARCHAR2(125)
|
CALCULATION
|
DECODE(RCRESAR_M_SCHOOL_FLAG_5)
|
|
MULTI_SCHOOL_FLAG6
|
Multi School Code Flag 6.
|
VARCHAR2(1)
|
RCRESAR
|
RCRESAR_M_SCHOOL_FLAG_6
|
|
MULTI_SCHOOL_FLAG6_DESC
|
Multi School Code Flag 6 description.
|
VARCHAR2(125)
|
CALCULATION
|
DECODE(RCRESAR_M_SCHOOL_FLAG_6)
|
|
OLDER_THAN_24_IND
|
Indicates that the student is older than 24.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(RCRESAR_A_BORN_BEFORE_IND)
|
|
PARENT_ASSUMED_AGI
|
Parent's assumed adjusted gross income.
|
NUMBER(6)
|
RCRESAR
|
RCRESAR_A_PAR_US_INC
|
|
PARENT_ASSUMED_INCOME_TAX_PAID
|
Parent's assumed income tax paid.
|
VARCHAR2(1)
|
RCRESAR
|
RCRESAR_A_PAR_INC_TAX_PD_IND
|
|
PARENT_ASSUMED_WORKSHEET_C_TOT
|
Assumed Parents' Worksheet C Title IV income exclusions total.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_A_P_WORKSHEET_C
|
|
PARENT_FAMILY_IN_COLLEGE
|
Number of parent's family members in college.
|
NUMBER(1)
|
RCRESAR
|
RCRESAR_A_PAR_NO_IN_COLL
|
|
PARENT_FAMILY_SIZE
|
Size of the parent's family.
|
NUMBER(2)
|
RCRESAR
|
RCRESAR_A_PAR_FAM_MEMB
|
|
PARENT_MARITAL_STATUS_IND
|
Indicates the marital status of the parents.
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(RCRESAR_A_PAR_MRTL_STATUS_IND)
|
|
PARENT_TAX_FILER_IND
|
CPS Determination of Parent's Tax Filing Status
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(RCRESAR_A_PAR_TAX_FILED_IND)
|
|
PELL_ELIGIBLE_IND
|
Indicates applicants eligibility as of this transaction for a Federal Pell Grant.
|
VARCHAR2(1)
|
RCRESAR
|
RCRESAR_PELL_ELGBL
|
|
PELL_PAID_EFC
|
Expected family contribution upon which the school based its payment, as reported to the Central Processor.
|
NUMBER(5)
|
RCRESAR
|
RCRESAR_PAID_EFC
|
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER(8)
|
RCRESAR
|
RCRESAR_PIDM
|
|
PROCESSED_RECORD_TYPE
|
Type of processed application.
|
VARCHAR2(1)
|
RCRESAR
|
RCRESAR_REC_TYPE
|
|
PROCESSED_RECORD_TYPE_DESC
|
Processed record type description.
|
VARCHAR2(30)
|
CALCULATION
|
DECODE(RCRESAR_REC_TYPE)
|
|
REPROCESSED_REASON
|
Code for the reason the application was reprocessed.
|
VARCHAR2(2)
|
RCRESAR
|
RCRESAR_RE_PROC_REA_CD
|
|
SECONDARY_EFC_TYPE
|
Type of the secondary Expected Family Contribution.
|
VARCHAR2(1)
|
RCRESAR
|
RCRESAR_SEC_EFC_TYPE
|
|
SECONDARY_EFC_TYPE_DESC
|
Secondary expected family contribution description.
|
VARCHAR2(60)
|
CALCULATION
|
DECODE(RCRESAR_SEC_EFC_TYPE)
|
|
SPOUSE_ASSUMED_INCOME_WORK
|
Student's spouse's assumed income from work.
|
NUMBER(6)
|
RCRESAR
|
RCRESAR_A_SPS_INC_FR_WRK
|
|
SUBSEQUENT_APPLICATION_IND
|
Indicates if a subsequent application from applicant exists.
|
VARCHAR2(1)
|
CALCULATION
|
NVL(RCRESAR_SUB_APP)
|
|
TAX_FILER_IND
|
CPS Determination of Student's Tax Filing Status
|
VARCHAR2(1)
|
CALCULATION
|
DECODE(RCRESAR_A_TAX_FILED_IND)
|
|
TRANSACTION_RECEIPT_DATE
|
Date the FAFSA ISIR information was received.
|
DATE
|
RCRESAR
|
RCRESAR_TRAN_RECEIPT_DATE
|
|
TRANSACTION_SITE_SOURCE
|
Origin and site code for the transaction.
|
VARCHAR2(2)
|
RCRESAR
|
RCRESAR_MDE_SITE_CD
|
|
TRANSACTION_TYPE
|
From where the transaction was generated.
|
VARCHAR2(1)
|
RCRESAR
|
RCRESAR_TRAN_TYPE
|
|
USER_ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(30)
|
RCRESAR
|
RCRESAR_USER_ID
|
|
VERIFICATION_SELECT_CHANGE_IND
|
Verification selection flag.
|
VARCHAR2(1)
|
CALCULATION
|
NVL(RCRESAR_VERIF_CHANGE_IND)
|
|
VERIFICATION_TYPE
|
Indicates the results of the verification edits on this transaction number. May be different from Verification Message on transactions above number 1.
|
VARCHAR2(2)
|
RCRESAR
|
RCRESAR_VERIF_TYPE
|
|
ZONE_VALUE
|
Zone column for future use, not currently populated.
|
VARCHAR2(6)
|
NA
|
NA
|