Go To View:  RETURN TO BANNER ODS META DATA REPORTS LIST
Financial Aid Reporting View Reports

Banner Operational Data Store
Reporting View Target: NEED_ANALYSIS_ISIR_SPECIFIC

Description Contains 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.
Recommended Search Columns AID_YEAR, PERSON_UID, INTERFACE_TAPE_CODE, APPLICATION_NUMBER, CURRENT_RECORD_IND

Target Column Business Definition Database Data Type Source Name Source Column
ACTIVITY_DATE Date record was inserted or updated. DATE

RCRESAR

RCRESAR_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)

RCRESAR

RCRESAR_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

RCRESAR

RCRESAR_SEQ_NO

APPLICATION_SOURCE_SITE Indicates the origin of the initial application and the site of the location. VARCHAR2(63)

RCRESAR

RCRESAR_AGENCY_IND

ASSUMED_AGI Student's assumed adjusted gross income. NUMBER

RCRESAR

RCRESAR_A_US_INC

ASSUMED_CITIZENSHIP Code to determine assumptions about the student's citizenship. VARCHAR2(63)

RCRESAR

RCRESAR_A_CITZ_IND

ASSUMED_CITIZENSHIP_DESC Assumed citizen description. VARCHAR2(255)

CALCULATION

DECODE(RCRESAR_A_CITZ_IND)

ASSUMED_DEPENDENT_IND Assumed number of student dependents. VARCHAR2(63)

CALCULATION

DECODE(RCRESAR_A_S_DEPENDANTS)

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(63)

CALCULATION

DECODE(RCRESAR_A_MARRIED)

ASSUMED_SUPPORT_CHILD Assumed student has children who receive more than half of their support from him/her. VARCHAR2(63)

RCRESAR

RCRESAR_A_HAVE_CHILDREN

ASSUMED_VETERAN_IND Assumed veteran status of the student. VARCHAR2(63)

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(63)

CALCULATION

DECODE(RCRESAR_AUTO_ZERO_EFC_FLAG)

BATCH_ID ID of the batch, assigned by the processor, from which this ISIR data was loaded into the system. VARCHAR2(63)

RCRESAR

RCRESAR_BATCH_ID

COLLEGE_CHOICE1 Student's first choice of college planning to attend. VARCHAR2(63)

RCRAPP1

RCRAPP1_FED_COLL_CHOICE_1

COLLEGE_CHOICE10 Student's tenth choice of college planning to attend. VARCHAR2(63)

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_10

COLLEGE_CHOICE2 Student's second choice of college planning to attend. VARCHAR2(63)

RCRAPP1

RCRAPP1_FED_COLL_CHOICE_2

COLLEGE_CHOICE3 Student's third choice of college planning to attend. VARCHAR2(63)

RCRAPP1

RCRAPP1_FED_COLL_CHOICE_3

COLLEGE_CHOICE4 Student's fourth choice of college planning to attend. VARCHAR2(63)

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_4

COLLEGE_CHOICE5 Student's fifth choice of college planning to attend. VARCHAR2(63)

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_5

COLLEGE_CHOICE6 Student's sixth choice of college planning to attend. VARCHAR2(63)

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_6

COLLEGE_CHOICE7 Student's seventh choice of college planning to attend. VARCHAR2(63)

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_7

COLLEGE_CHOICE8 Student's eighth choice of college planning to attend. VARCHAR2(63)

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_8

COLLEGE_CHOICE9 Student's ninth choice of college planning to attend. VARCHAR2(63)

RCRAPP3

RCRAPP3_FED_COLL_CHOICE_9

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(63)

RCRESAR

RCRESAR_CORR_APPL

CURRENT_RECORD_IND Specifies that this is the current need analysis record. VARCHAR2(63)

RCRAPP1

RCRAPP1_CURR_REC_IND

DESTINATION_NUMBER The TGXXXXX number for the destination code of the transaction. VARCHAR2(63)

RCRESAR

RCRESAR_ETI_DEST_CODE

DUPLICATE_REQUEST_IND Indicates that the record was sent to the institution as a result of a request for a duplicate ISIR. VARCHAR2(63)

CALCULATION

DECODE(RCRESAR_DUP_REQ_IND)

ELECT_APPL_ENTRY_SOURCE_IND The origin of the electronic application. VARCHAR2(63)

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/Mother's/Stepparent's assumed income from work. NUMBER

RCRESAR

RCRESAR_A_FATH_INC_FR_WRK

FATHER_ASSUMED_TAX_ID Assumed Father's/Mother's/Stepparent's tax ID number. VARCHAR2(63)

RCRESAR

RCRESAR_A_FATH_SSN

FEDERAL_HOUSING1 Federal housing code associated with the student's first federal college choice. VARCHAR2(63)

RCRESAR

RCRESAR_FED_HOUS_CDE_1

FEDERAL_HOUSING1_DESC Federal housing code description. VARCHAR2(255)

CALCULATION

DECODE(RCRESAR_FED_HOUS_CDE_1)

FEDERAL_HOUSING2 Federal housing code associated with the student's second federal college choice. VARCHAR2(63)

RCRESAR

RCRESAR_FED_HOUS_CDE_2

FEDERAL_HOUSING2_DESC Federal housing code description. VARCHAR2(255)

CALCULATION

DECODE(RCRESAR_FED_HOUS_CDE_2)

FEDERAL_HOUSING3 Federal housing code associated with the student's third federal college choice. VARCHAR2(63)

RCRESAR

RCRESAR_FED_HOUS_CDE_3

FEDERAL_HOUSING3_DESC Federal housing code description. VARCHAR2(255)

CALCULATION

DECODE(RCRESAR_FED_HOUS_CDE_3)

FEDERAL_HOUSING4 Federal housing code associated with the student's fourth federal college choice. VARCHAR2(63)

RCRESAR

RCRESAR_FED_HOUS_CDE_4

FEDERAL_HOUSING4_DESC Federal housing code description. VARCHAR2(255)

CALCULATION

DECODE(RCRESAR_FED_HOUS_CDE_4)

FEDERAL_HOUSING5 Federal housing code associated with the student's fifth federal college choice. VARCHAR2(63)

RCRESAR

RCRESAR_FED_HOUS_CDE_5

FEDERAL_HOUSING5_DESC Federal housing code description. VARCHAR2(255)

CALCULATION

DECODE(RCRESAR_FED_HOUS_CDE_5)

FEDERAL_HOUSING6 Federal housing code associated with the student's sixth federal college choice. VARCHAR2(63)

RCRESAR

RCRESAR_FED_HOUS_CDE_6

FEDERAL_HOUSING6_DESC Federal housing code description. VARCHAR2(255)

CALCULATION

DECODE(RCRESAR_FED_HOUS_CDE_6)

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

INPUT_RECORD_TYPE Type of Input Record. VARCHAR2(63)

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(63)

RCRESAR

RCRESAR_INFC_CODE

INTERFACE_TAPE_DESC Description of the interface tape code. VARCHAR2(255)

RTVINFC

RTVINFC_DESC

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(63)

RCRESAR

RCRESAR_EDE_ETI_IND

ISIR_ELECT_TRANSACTION_DESC ISIR electronic transaction description. VARCHAR2(255)

CALCULATION

DECODE(RCRESAR_EDE_ETI_IND)

MARITAL_STATUS_IND Indicates the marital status of the student. VARCHAR2(63)

CALCULATION

DECODE(RCRESAR_A_MRTL_STATUS_IND)

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

MOTHER_ASSUMED_INCOME_WORK Father's/Mother's/Stepparent's assumed income from work. NUMBER

RCRESAR

RCRESAR_A_MOTH_INC_FR_WRK

MOTHER_ASSUMED_TAX_ID Assumed Father's/Mother's/Stepparent's tax ID number. VARCHAR2(63)

RCRESAR

RCRESAR_A_MOTH_SSN

MULTI_SCHOOL_FLAG1 Multi School Code Flag 1. VARCHAR2(63)

RCRESAR

RCRESAR_M_SCHOOL_FLAG_1

MULTI_SCHOOL_FLAG1_DESC Multi School Code Flag 1 description. VARCHAR2(255)

CALCULATION

DECODE(RCRESAR_M_SCHOOL_FLAG_1)

MULTI_SCHOOL_FLAG2 Multi School Code Flag 2. VARCHAR2(63)

RCRESAR

RCRESAR_M_SCHOOL_FLAG_2

MULTI_SCHOOL_FLAG2_DESC Multi School Code Flag 2 description. VARCHAR2(255)

CALCULATION

DECODE(RCRESAR_M_SCHOOL_FLAG_2)

MULTI_SCHOOL_FLAG3 Multi School Code Flag 3. VARCHAR2(63)

RCRESAR

RCRESAR_M_SCHOOL_FLAG_3

MULTI_SCHOOL_FLAG3_DESC Multi School Code Flag 3 description. VARCHAR2(255)

CALCULATION

DECODE(RCRESAR_M_SCHOOL_FLAG_3)

MULTI_SCHOOL_FLAG4 Multi School Code Flag 4. VARCHAR2(63)

RCRESAR

RCRESAR_M_SCHOOL_FLAG_4

MULTI_SCHOOL_FLAG4_DESC Multi School Code Flag 4 description. VARCHAR2(255)

CALCULATION

DECODE(RCRESAR_M_SCHOOL_FLAG_4)

MULTI_SCHOOL_FLAG5 Multi School Code Flag 5. VARCHAR2(63)

RCRESAR

RCRESAR_M_SCHOOL_FLAG_5

MULTI_SCHOOL_FLAG5_DESC Multi School Code Flag 5 description. VARCHAR2(255)

CALCULATION

DECODE(RCRESAR_M_SCHOOL_FLAG_5)

MULTI_SCHOOL_FLAG6 Multi School Code Flag 6. VARCHAR2(63)

RCRESAR

RCRESAR_M_SCHOOL_FLAG_6

MULTI_SCHOOL_FLAG6_DESC Multi School Code Flag 6 description. VARCHAR2(255)

CALCULATION

DECODE(RCRESAR_M_SCHOOL_FLAG_6)

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

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

CALCULATION

DECODE(RCRESAR_A_BORN_BEFORE_IND)

PARENT_ASSUMED_AGI Parent's assumed adjusted gross income. NUMBER

RCRESAR

RCRESAR_A_PAR_US_INC

PARENT_ASSUMED_INCOME_TAX_PAID Parent's assumed income tax paid. VARCHAR2(63)

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(63)

CALCULATION

DECODE(RCRESAR_A_PAR_MRTL_STATUS_IND)

PARENT_TAX_FILER_IND CPS Determination of Parent's Tax Filing Status. VARCHAR2(63)

CALCULATION

DECODE(RCRESAR_A_PAR_TAX_FILED_IND)

PELL_ELIGIBLE_IND Indicates applicants eligibility as of this transaction for a Federal Pell Grant. VARCHAR2(63)

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(63)

RCRESAR

RCRESAR_REC_TYPE

PROCESSED_RECORD_TYPE_DESC Processed record type description. VARCHAR2(255)

CALCULATION

DECODE(RCRESAR_REC_TYPE)

PROCESS_GROUP Process-oriented identifier for the record used to determine access authorization to this record. Institution defined. VARCHAR2(255)

NA

NA

REPROCESSED_REASON Code for the reason the application was reprocessed. VARCHAR2(63)

RCRESAR

RCRESAR_RE_PROC_REA_CD

SECONDARY_EFC_TYPE Type of the secondary Expected Family Contribution. VARCHAR2(63)

RCRESAR

RCRESAR_SEC_EFC_TYPE

SECONDARY_EFC_TYPE_DESC Secondary expected family contribution description. VARCHAR2(255)

CALCULATION

DECODE(RCRESAR_SEC_EFC_TYPE)

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(63)

CALCULATION

DECODE(RCRESAR_SUB_APP)

TAX_FILER_IND CPS Determination of Student's Tax Filing Status. VARCHAR2(63)

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(63)

RCRESAR

RCRESAR_MDE_SITE_CD

TRANSACTION_TYPE From where the transaction was generated. VARCHAR2(63)

RCRESAR

RCRESAR_TRAN_TYPE

USER_ID Unique identification code of the user who entered or last touched the transaction. VARCHAR2(63)

RCRESAR

RCRESAR_USER_ID

VERIFICATION_SELECT_CHANGE_IND Verification selection flag. VARCHAR2(63)

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(63)

RCRESAR

RCRESAR_VERIF_TYPE



Ver: 9.1