Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Financial Aid Composite View Reports

Banner Operational Data Store
Composite View Target: AR_NEED_ANALYSIS_ISIR_SPEC

Description Need analysis data specific to the Institutional Student Information Report.
Key & Frequency One row per Aid Year per Person per Interface Tape Code per Application Number

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 Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation. VARCHAR2(4)

RCRESAR

RCRESAR_AIDY_CODE

APPLICATION_NUMBER Financial aid application unique sequence number. NUMBER

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_ADDL_FIN_INFO Student's assumed additional financial information total. NUMBER

RCRESAR

RCRESAR_A_S_ADDL_FINANCIAL

ASSUMED_AGI Student's assumed adjusted gross income. NUMBER

RCRESAR

RCRESAR_A_US_INC

ASSUMED_ASSET_TH_EXCD Indicates that an assumption is used to determine whether the student's asset threshold has been exceeded. VARCHAR2(63)

RCRESAR

RCRESAR_A_S_ASSET_THRESH_EXCD

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_HOMELESS_HUD Month 9, primary family contribution. VARCHAR2(63)

RCRESAR

RCRESAR_A_HOMELESS_HUD

ASSUMED_HOMELESS_SCHOOL The student is assumed to be homeless by the school. VARCHAR2(63)

RCRESAR

RCRESAR_A_HOMELESS_SCHOOL

ASSUMED_INCOME_TAX_PAID Assumed amount of Federal Tax paid by the student. NUMBER

RCRESAR

RCRESAR_A_S_FIT

ASSUMED_INCOME_WORK Student's assumed income from work. NUMBER

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_RISK_OF_HOMELESSNESS The student is assumed to be at risk of homelessness. VARCHAR2(63)

RCRESAR

RCRESAR_A_AT_RISK_HOMELESS

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

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

RCRESAR

RCRESAR_COMM_CODE_01

COMMENT10 ISIR comment code 10. NUMBER

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

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

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

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

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

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

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

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

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

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

RCRESAR

RCRESAR_COMM_CODE_02

COMMENT20 ISIR comment code 20. NUMBER

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

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

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

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

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

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

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

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

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

RCRESAR

RCRESAR_A_NO_IN_COLL

FAMILY_SIZE Size of the student's family. NUMBER

RCRESAR

RCRESAR_A_FAM_MEMB

FATHER_ASSUMED_INCOME_WORK Father's assumed income from work. NUMBER

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_HOUSING10 Indicates the federal housing code associated with the student's tenth federal college choice. VARCHAR2(1)

RCRESAR

RCRESAR_FED_HOUS_CDE_10

FEDERAL_HOUSING10_DESC Federal housing code description. VARCHAR2(15)

CALCULATION

DECODE(RCRESAR_FED_HOUS_CDE_10)

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)

FEDERAL_HOUSING7 Indicates the federal housing code associated with the student's seventh federal college choice. VARCHAR2(1)

RCRESAR

RCRESAR_FED_HOUS_CDE_7

FEDERAL_HOUSING7_DESC Federal housing code description. VARCHAR2(15)

CALCULATION

DECODE(RCRESAR_FED_HOUS_CDE_7)

FEDERAL_HOUSING8 Indicates the federal housing code associated with the student's eighth federal college choice. VARCHAR2(1)

RCRESAR

RCRESAR_FED_HOUS_CDE_8

FEDERAL_HOUSING8_DESC Federal housing code description. VARCHAR2(15)

CALCULATION

DECODE(RCRESAR_FED_HOUS_CDE_8)

FEDERAL_HOUSING9 Indicates the federal housing code associated with the student's ninth federal college choice. VARCHAR2(1)

RCRESAR

RCRESAR_FED_HOUS_CDE_9

FEDERAL_HOUSING9_DESC Federal housing code description. VARCHAR2(15)

CALCULATION

DECODE(RCRESAR_FED_HOUS_CDE_9)

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

RCRESAR

RCRESAR_ALT_1_FC_10_MTH_CALC

MONTH10_FAMILY_CONTRIB_SECOND Month 10, secondary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_2_FC_10_MTH_CALC

MONTH11_FAMILY_CONTRIB_PRIMARY Month 11, primary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_1_FC_11_MTH_CALC

MONTH11_FAMILY_CONTRIB_SECOND Month 11, secondary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_2_FC_11_MTH_CALC

MONTH12_FAMILY_CONTRIB_PRIMARY Month 12, primary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_1_FC_12_MTH_CALC

MONTH12_FAMILY_CONTRIB_SECOND Month 12, secondary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_2_FC_12_MTH_CALC

MONTH1_FAMILY_CONTRIB_PRIMARY Month 1, primary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_1_FC_01_MTH_CALC

MONTH1_FAMILY_CONTRIB_SECOND Month 1, secondary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_2_FC_01_MTH_CALC

MONTH2_FAMILY_CONTRIB_PRIMARY Month 2, primary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_1_FC_02_MTH_CALC

MONTH2_FAMILY_CONTRIB_SECOND Month 2, secondary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_2_FC_02_MTH_CALC

MONTH3_FAMILY_CONTRIB_PRIMARY Month 3, primary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_1_FC_03_MTH_CALC

MONTH3_FAMILY_CONTRIB_SECOND Month 3, secondary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_2_FC_03_MTH_CALC

MONTH4_FAMILY_CONTRIB_PRIMARY Month 4, primary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_1_FC_04_MTH_CALC

MONTH4_FAMILY_CONTRIB_SECOND Month 4, secondary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_2_FC_04_MTH_CALC

MONTH5_FAMILY_CONTRIB_PRIMARY Month 5, primary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_1_FC_05_MTH_CALC

MONTH5_FAMILY_CONTRIB_SECOND Month 5, secondary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_2_FC_05_MTH_CALC

MONTH6_FAMILY_CONTRIB_PRIMARY Month 6, primary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_1_FC_06_MTH_CALC

MONTH6_FAMILY_CONTRIB_SECOND Month 6, secondary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_2_FC_06_MTH_CALC

MONTH7_FAMILY_CONTRIB_PRIMARY Month 7, primary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_1_FC_07_MTH_CALC

MONTH7_FAMILY_CONTRIB_SECOND Month 7, secondary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_2_FC_07_MTH_CALC

MONTH8_FAMILY_CONTRIB_PRIMARY Month 8, primary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_1_FC_08_MTH_CALC

MONTH8_FAMILY_CONTRIB_SECOND Month 8, secondary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_2_FC_08_MTH_CALC

MONTH9_FAMILY_CONTRIB_PRIMARY Month 9, primary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_1_FC_09_MTH_CALC

MONTH9_FAMILY_CONTRIB_SECOND Month 9, secondary family contribution. NUMBER

RCRESAR

RCRESAR_ALT_2_FC_09_MTH_CALC

MOTHER_ASSUMED_INCOME_WORK Mother's assumed income from work. NUMBER

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_FLAG10 Multi School Code Flag 10 VARCHAR2(1)

RCRESAR

RCRESAR_M_SCHOOL_FLAG_10

MULTI_SCHOOL_FLAG10_DESC Multi School Code Flag 10 description. VARCHAR2(125)

CALCULATION

DECODE(RCRESAR_M_SCHOOL_FLAG_10)

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)

MULTI_SCHOOL_FLAG7 Multi School Code Flag 7 VARCHAR2(1)

RCRESAR

RCRESAR_M_SCHOOL_FLAG_7

MULTI_SCHOOL_FLAG7_DESC Multi School Code Flag 7 description. VARCHAR2(125)

CALCULATION

DECODE(RCRESAR_M_SCHOOL_FLAG_7)

MULTI_SCHOOL_FLAG8 Multi School Code Flag 8 VARCHAR2(1)

RCRESAR

RCRESAR_M_SCHOOL_FLAG_8

MULTI_SCHOOL_FLAG8_DESC Multi School Code Flag 8 description. VARCHAR2(125)

CALCULATION

DECODE(RCRESAR_M_SCHOOL_FLAG_8)

MULTI_SCHOOL_FLAG9 Multi School Code Flag 9 VARCHAR2(1)

RCRESAR

RCRESAR_M_SCHOOL_FLAG_9

MULTI_SCHOOL_FLAG9_DESC Multi School Code Flag 9 description. VARCHAR2(125)

CALCULATION

DECODE(RCRESAR_M_SCHOOL_FLAG_9)

OLDER_THAN_24_IND Indicates that the student is older than 24. VARCHAR2(1)

CALCULATION

DECODE(RCRESAR_A_BORN_BEFORE_IND)

PARENT_ASSUMED_ADDL_FIN_INFO Parent's assumed additional financial information total. NUMBER

RCRESAR

RCRESAR_A_P_ADDL_FINANCIAL

PARENT_ASSUMED_AGI Parent's assumed adjusted gross income. NUMBER

RCRESAR

RCRESAR_A_PAR_US_INC

PARENT_ASSUMED_ASSET_TH_EXCD Indicates that an assumption is used to determine whether the parents' asset threshold has been exceeded. VARCHAR2(63)

RCRESAR

RCRESAR_A_P_ASSET_THRESH_EXCD

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

RCRESAR

RCRESAR_A_P_WORKSHEET_C

PARENT_FAMILY_IN_COLLEGE Number of parent's family members in college. NUMBER

RCRESAR

RCRESAR_A_PAR_NO_IN_COLL

PARENT_FAMILY_SIZE Size of the parent's family. NUMBER

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

RCRESAR

RCRESAR_PAID_EFC

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

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)

SIGNATURE_REJECT_EFC Calculated EFC for record rejected due to missing signatures only. This is an unofficial EFC. NUMBER

RCRESAR

RCRESAR_SIGNATURE_REJ_EFC

SPECIAL_CIRCUMSTANCES_FLAG Indicates type of special circumstance performed. VARCHAR2(63)

RCRESAR

RCRESAR_SPEC_CIRCUM_FLG

SPOUSE_ASSUMED_INCOME_WORK Student's spouse's assumed income from work. NUMBER

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



Ver: