RETURN TO REPORTING VIEW REPORTS LIST
(EDW Source Report)
Financial Aid Reporting View Reports

SGHE Operational Data Store
Reporting View Target: NEED_ANALYSIS

Description Contains data usually loaded from a federally supplied electronic media. Detail data will include all data collected regarding student need for the aid year and student. Data may include parental contribution, student contribution, interface tape code, application number, state/province of residence, and other need based data for doing needs analysis either using a federal or institution method of calculation.
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
AID_YEAR, PERSON_UID, CURRENT_RECORD_IND
PERSON_UID

Target Column Business Definition Database Data Type Source Name Source Column
ADJ_GROSS_INCOME Amount of AGI in the base year reported by the student on his/her federal tax return. NUMBER

RCRAPP1

RCRAPP1_US_INC

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

NA

NA

AID_YEAR Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005). VARCHAR2(63)

RCRAPP1

RCRAPP1_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

RCRAPP1

RCRAPP1_SEQ_NO

APPLICATION_TAX_ID Tax file number of the person on the application. VARCHAR2(63)

NA

NA

APPL_IM_PARENT_CONTRIB Institutional methodology calculated value for the primary parent contribution. NUMBER

RCRAPP2

RCRAPP2_IM_1_PC

APPL_IM_STUDENT_CONTRIB Institutional methodology calculated value for the student contribution. NUMBER

RCRAPP2

RCRAPP2_IM_1_SC

BUSINESS_DEBT Amount of the student's outstanding debts against business and farm assets. NUMBER

RCRAPP1

RCRAPP1_BUS_FARM_DBT

BUSINESS_VALUE Current market value of the student's business and farm assets. NUMBER

RCRAPP1

RCRAPP1_BUS_FARM_VAL

CASH_SAVINGS Amount the student currently has in cash on hand and in savings and checking accounts. NUMBER

RCRAPP1

RCRAPP1_CASH_AMT

COLLEGE College code identifying the school to which this financial aid applicant record has applied. VARCHAR2(63)

RCRAPP1

RCRAPP1_COLL_CDE

COLLEGE_DESC College, faculty or school name. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

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

RCRAPP1

RCRAPP1_CURR_REC_IND

DEPENDENCY_STATUS Identifies the student's dependency status as computed by INAS or loaded from the tape record. VARCHAR2(63)

RCRAPP2

RCRAPP2_C_DEPEND_STATUS

DEPEND_INDEPEND_IND Indicates if the student is independent or dependent. VARCHAR2(63)

RCRAPP2

RCRAPP2_MODEL_CDE

ENRL_PLANNING_SERVICE Enrollment planning service code based on the student's postal code. Used to provide a standard geographic region code for use in planning and research. VARCHAR2(63)

RCRAPP2

RCRAPP2_EPS_CDE

ENRL_PLANNING_SERVICE_DESC Enrollment planning service description. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

EXPECTED_ENROLL_STATUS Student's expected enrollment status for the school year. VARCHAR2(63)

RCRAPP1

RCRAPP1_EXP_ENROLL_STATUS

FAMILY_IN_COLLEGE Total number of family members in the student's household that attend college at least half time. NUMBER

RCRAPP1

RCRAPP1_NO_IN_COLL

FAMILY_SIZE Number of people in the student's household during the school year. NUMBER

RCRAPP1

RCRAPP1_FAM_MEMB

FM_PARENT_CONTRIB_ASSET Portion of the primary parents contribution that came from assets. (Federal Method). NUMBER

RCRAPP2

RCRAPP2_C_PAR_1_CTRB_FR_ASSET

FM_PARENT_CONTRIB_INCOME Portion of the primary parent contribution that came from income. (FM). NUMBER

RCRAPP2

RCRAPP2_C_PAR_1_CTRB_FR_INC

FM_STUDENT_CONTRIB_ASSET Student's contribution from assets for the primary calculation. (FM). NUMBER

RCRAPP2

RCRAPP2_C_1_CTRB_FR_ASSET

FM_STUDENT_CONTRIB_INCOME Student's contribution from income for the primary calculation. (FM). NUMBER

RCRAPP2

RCRAPP2_C_1_CTRB_FR_INC

FM_TOTAL_INCOME Total income used in the student's primary calculation. (FM). NUMBER

RCRAPP2

RCRAPP2_C_1_TOT_INC

HOME_DEBT Student's current outstanding debts against the home. NUMBER

RCRAPP1

RCRAPP1_HME_DBT

HOME_VALUE Current market value of the student's home. NUMBER

RCRAPP1

RCRAPP1_HME_VAL

HOUSING_CODE Housing code reported by the student applicant for the school that is receiving this application record. VARCHAR2(63)

RCRAPP1

RCRAPP1_INST_HOUS_CDE

ID Person's or organization's current identification number. VARCHAR2(63)

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

IM_PARENT_CONTRIB_ASSET Portion of the primary parent contribution that came from income. (FM). NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_CTRB_FR_ASSET

IM_PARENT_CONTRIB_INCOME Portion of the primary parent contribution that came from income. (FM). NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_CTRB_FR_INC

IM_STUDENT_CONTRIB_ASSET Student's contribution from assets for the primary calculation. (IM). NUMBER

RCRAPP2

RCRAPP2_C_2_CTRB_FR_ASSET

IM_STUDENT_CONTRIB_INCOME Student's contribution from income for the primary calculation. (IM). NUMBER

RCRAPP2

RCRAPP2_C_2_CTRB_FR_INC

IM_TOTAL_INCOME Total income used in the student's primary calculation. (IM). NUMBER

RCRAPP2

RCRAPP2_C_2_TOT_INC

INAS_PC Primary parent contribution. (CM). NUMBER

RCRAPP2

RCRAPP2_C_PAR_1_CTRB_FOR_STDT

INAS_SC Congressional methodology student contribution for the primary calculation. (CM). NUMBER

RCRAPP2

RCRAPP2_C_1_CTRB_FOR_STDT

INAS_TFC Total family contribution. NUMBER

CALCULATION

LEAST(99999,RCRAPP2_C_1_CTRB_FOR_STDT+RCRAPP2_C_PAR_1_CTRB_FOR_STDT)

INTERFACE_TAPE_CODE Interface tape table indicating the source and format of the application record. (e.g., ACT, CSS, SAT, etc.). VARCHAR2(63)

RCRAPP1

RCRAPP1_INFC_CODE

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PARENTAL_CONTRIBUTION Parents contribution toward educational expenses. It is the primary parental contribution from the student's current record. NUMBER

RORSTAT

RORSTAT_PC

PARENTS_TOTAL_INCOME Total income used in the calculation of the primary parent contribution. (FM). NUMBER

RCRAPP2

RCRAPP2_C_PAR_1_TOT_INC

PARENT_2_TOT_INCOME Total income used in the calculation of the primary parent contribution. (IM). NUMBER

RCRAPP2

RCRAPP2_C_PAR_2_TOT_INC

PARENT_ADJ_GROSS_INCOME Amount of the AGI in the base year reported by the student's parents on their federal tax return. NUMBER

RCRAPP1

RCRAPP1_PAR_US_INC

PARENT_CONTRIB_OFFICIAL_IND Indicates if the primary parent contribution is official or estimated. VARCHAR2(1)

RCRAPP2

RCRAPP2_C_PAR_1_CTRB_OFFL_EST

PELL_PGI Primary system Pell PGI. NUMBER

RCRAPP2

RCRAPP2_PELL_PGI

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

RCRAPP1

RCRAPP1_PIDM

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

NA

NA

REAL_ESTATE_DEBT Student's current outstanding debts against other real estate and investment assets. NUMBER

RCRAPP1

RCRAPP1_RE_INV_DBT

REAL_ESTATE_VALUE Student's current market value of other real estate and investment assets. NUMBER

RCRAPP1

RCRAPP1_RE_INV_VAL

SAR_EFC Identifies what the SAR EFC was for a person when they were added in data load. NUMBER

RCRAPP4

RCRAPP4_SAR_EFC

SELECTED_FOR_VERIFICATION Indicates whether the student has been selected for verification by the department of education edits or by the institution. VARCHAR2(63)

RCRAPP1

RCRAPP1_VERIFICATION_MSG

STATE_OF_RESIDENCE Student's state of legal residence. VARCHAR2(63)

RCRAPP1

RCRAPP1_STAT_CODE_RES

STATE_OF_RESIDENCE_DESC Name of the student's state, province of legal residence. VARCHAR2(255)

FUNCTION

GOKODSF.F_GET_DESC

STUDENT_CONTRIBUTION Student contribution toward educational expenses from the student's current need analysis record. NUMBER

RORSTAT

RORSTAT_SC

STUDENT_CONTRIB_OFFICIAL_IND Indicates if the student contribution for the primary calculation is official or estimated. (FM). VARCHAR2(1)

RCRAPP2

RCRAPP2_C_1_CTRB_OFFL_EST

TAX_ID Person's tax identification number assigned by their home federal government. VARCHAR2(63)

RCRAPP1

RCRAPP1_SSN

TOTAL_FAMILY_CONTRIBUTION_FED Primary congressional methodology total family contribution. NUMBER

RCRAPP4

RCRAPP4_C_INST_1_TOT_FAM_CTRB

TOTAL_FAMILY_CONTRIBUTION_INST Primary institutional methodology for calculation of total family contribution (TFC). NUMBER

RCRAPP2

RCRAPP2_IM_1_TFC

VERIFICATION_PRIORITY Indicates the priority of the edits used to select the student for data verification. VARCHAR2(63)

RCRAPP1

RCRAPP1_VERIFICATION_PRTY

YEAR_IN_COLLEGE Year of study (first, second, etc.) that the student enrolls in this year. VARCHAR2(63)

RCRAPP1

RCRAPP1_YR_IN_COLL



Ver: 3.1