RETURN TO COMPOSITE VIEW REPORTS LIST
Financial Aid Composite View Reports

SGHE Operational Data Store
Composite View Target: AR_NEED_ANALYSIS

Description Source composite view contains financial aid need analysis information.

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

RCRAPP1

RCRAPP1_US_INC

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)

RCRAPP1

RCRAPP1_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

APPLICATION_NUMBER Financial aid application unique sequence number. NUMBER(3)

RCRAPP1

RCRAPP1_SEQ_NO

APPLICATION_SSN Financial aid applicant's tax identification or social security number on the application. VARCHAR2(9)

RCRAPP1

RCRAPP1_SSN

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

RCRAPP2

RCRAPP2_IM_1_PC

APPL_IM_STUDENT_CONTRIB Institutional methodology calculated value for the student contribution. NUMBER(5)

RCRAPP2

RCRAPP2_IM_1_SC

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

RCRAPP1

RCRAPP1_BUS_FARM_DBT

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

RCRAPP1

RCRAPP1_BUS_FARM_VAL

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

RCRAPP1

RCRAPP1_CASH_AMT

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

RCRAPP1

RCRAPP1_COLL_CDE

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

FUNCTION

GOKODSF.F_GET_DESC

CURRENT_DATE System current date (sysdate) or date the data was extracted. DATE

NA

SYSDATE

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

RCRAPP2

RCRAPP2_C_DEPEND_STATUS

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

RCRAPP2

RCRAPP2_MODEL_CDE

DOMAIN_VALUE Organization-oriented identifier for the record used to determine access authorization. Institution defined. VARCHAR2(6)

NA

NA

EPS_REGION Enrollment planning service (EPS) marketing code based on the student's postal code. Used to provide a standard geographic region code for use in planning and research. (CSS formats only). VARCHAR2(4)

RCRAPP2

RCRAPP2_EPS_CDE

EPS_REGION_DESC Enrollment planning service description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

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

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

RCRAPP1

RCRAPP1_NO_IN_COLL

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

RCRAPP1

RCRAPP1_FAM_MEMB

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

RCRAPP2

RCRAPP2_C_PAR_1_CTRB_FR_ASSET

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

RCRAPP2

RCRAPP2_C_PAR_1_CTRB_FR_INC

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

RCRAPP2

RCRAPP2_C_1_CTRB_FR_ASSET

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

RCRAPP2

RCRAPP2_C_1_CTRB_FR_INC

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

RCRAPP2

RCRAPP2_C_1_TOT_INC

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

RCRAPP1

RCRAPP1_HME_DBT

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

RCRAPP1

RCRAPP1_HME_VAL

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

RCRAPP1

RCRAPP1_INST_HOUS_CDE

IM_PARENT_CONTRIB_ASSET Portion of the primary parent contribution that came from assets. (IM). NUMBER(5)

RCRAPP2

RCRAPP2_C_PAR_2_CTRB_FR_ASSET

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

RCRAPP2

RCRAPP2_C_PAR_2_CTRB_FR_INC

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

RCRAPP2

RCRAPP2_C_2_CTRB_FR_ASSET

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

RCRAPP2

RCRAPP2_C_2_CTRB_FR_INC

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

RCRAPP2

RCRAPP2_C_2_TOT_INC

INAS_PC Primary parent contribution. (CM). NUMBER(7)

RCRAPP2

RCRAPP2_C_PAR_1_CTRB_FOR_STDT

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

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

RCRAPP1

RCRAPP1_INFC_CODE

INTERFACE_TAPE_DESC Interface tape table code description. VARCHAR2(30)

FUNCTION

GOKODSF.F_GET_DESC

MIF_DESC Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(30)

NA

NA

MIF_VALUE Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(6)

NA

NA

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

RORSTAT

RORSTAT_PC

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

RCRAPP2

RCRAPP2_C_PAR_1_TOT_INC

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

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

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

RCRAPP2

RCRAPP2_PELL_PGI

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

RCRAPP1

RCRAPP1_PIDM

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

RCRAPP1

RCRAPP1_RE_INV_DBT

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

RCRAPP1

RCRAPP1_RE_INV_VAL

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

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

RCRAPP1

RCRAPP1_VERIFICATION_MSG

SSN Financial aid applicant's tax identification or social security number on the application. VARCHAR2(9)

RCRAPP1

RCRAPP1_SSN

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

RCRAPP1

RCRAPP1_STAT_CODE_RES

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

FUNCTION

GOKODSF.F_GET_DESC

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

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

TOTAL_FAMILY_CONTRIBUTION_FED Primary congressional methodology total family contribution. NUMBER(6)

RCRAPP4

RCRAPP4_C_INST_1_TOT_FAM_CTRB

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

RCRAPP2

RCRAPP2_IM_1_TFC

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

RCRAPP1

RCRAPP1_VERIFICATION_PRTY

YEAR_IN_COLLEGE Year of study (first, second, etc.), in which the student will enroll this year. VARCHAR2(1)

RCRAPP1

RCRAPP1_YR_IN_COLL

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

NA

NA



Ver: 3.1