Reporting View Target: FINAID_APPLICANT

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

SGHE Banner Operational Data Store
Reporting View Target: FINAID_APPLICANT_STATUS

Description Contains data for the aid year and the person who has applied for financial aid for the aid year. The person may have submitted either or both a federal and institutional application for financial aid. Optionally the person may have the financial aid status record created without an application because of some other institutional process that required it to be created. Details may include application locked indicator, budget group, administrative group, packaging group, tracking group, financial aid application status data, and budget type.
Key & Frequency One row per aid year and person.
Recommended Search Columns AID_YEAR, PERSON_UID
PERSON_UID

Target Column Business Name Business Definition Database Data Type Domain Value Source Name Source Column

ADDITIONAL_PELL_AWARDS Additional Pell Awards Indicates whether student is receiving a second Pell award for the aid year. VARCHAR2(1)
RORSTAT

RORSTAT_ADDL_PELL_ELIG_IND

ADDITIONAL_PELL_AWARDS_DESC Additional Pell Award Additional Pell award description. VARCHAR2(255)
CALCULATION

CASE WHEN RORSTAT_ADDL_PELL_ELIB_IND

ADDITIONAL_STAFFORD_AWARDS Additional Stafford Awards Indicates if the applicant is eligible for additional Stafford awards. VARCHAR2(1)
RORSTAT

RORSTAT_ADDL_STFD_ELIG_IND

ADDITIONAL_STAFFORD_AWRDS_DESC Additional Stafford Awards Description. Additional Stafford awards description. VARCHAR2(255)
CALCULATION

CASE WHEN RORSTAT_ADDL_STFD_ELIG_IND

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

NA

AID_PERIOD Aid Period Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, etc. VARCHAR2(63)
RORSTAT

RORSTAT_APRD_CODE

AID_PERIOD_DESC Aid Period Description Financial Aid period description. VARCHAR2(255)
RTVAPRD

RTVAPRD_DESC

AID_YEAR 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)
RORSTAT

RORSTAT_AIDY_CODE

AID_YEAR_DESC Aid Year Description Financial aid year name. VARCHAR2(255)
ROBINST

ROBINST_AIDY_DESC

ALL_REQUIRE_COMPLETE_DATE All Require Complete Date Date on which all tracking requirements for this applicant were satisfied. DATE
RORSTAT

RORSTAT_ALL_REQ_COMP_DATE

APPLICATION_LOCKED_IND Application Locked Indicator Indicates whether the student's financial aid application record is locked. VARCHAR2(1)
RORSTAT

RORSTAT_LOCK_IND

APPLICATION_RECEIVED_DATE Application Received Date Date this financial aid status record for this person recorded because either a financial aid application was received, processed or created or at least one tracking requirement was satisfied as defined by institution options. DATE
RORSTAT

RORSTAT_APPL_RCVD_DATE

BUDGET_GROUP Budget Group Student's assigned budget group. VARCHAR2(63)
RORSTAT

RORSTAT_BGRP_CODE

BUDGET_GROUP_DESC Budget Group Description Budget group code description. Identifies what it represents. VARCHAR2(255)
RTVBGRP

RTVBGRP_DESC

DEPENDENT_NO_PARENT_DATA Dependent No Parent Data Indicates whether the dependent student is eligible for unsubsidized Stafford even though parent data has not been submitted on the FAFSA. VARCHAR2(1)
RORSTAT

RORSTAT_DEP_NO_PAR_DATA

DEPENDENT_NO_PARENT_DATA_DESC Dependent No Parent Data Description. Dependent no parent data description. VARCHAR2(255)
CALCULATION

CASE WHEN RORSTAT_DEP_NO_PAR_DATA

DISBURSE_REQUIRE_COMPLETE_DATE Disburse Require Complete Date Date that all tracking requirements mandatory for disbursement were satisfied for the particular student. DATE
RORSTAT

RORSTAT_DISB_REQ_COMP_DATE

EXPECTED_ENROLL_STATUS Expected Enrollment Status Student's expected enrollment status for the school's aid year. VARCHAR2(63)
RORSTAT

RORSTAT_XES

EXPECTED_ENROLL_STATUS_DESC Expected Enrollment Status Description Expected enrollment status description. VARCHAR2(255)
RORMVAL

RORMVAL_DESC

FINAID_APPLICANT_IND Finaid Applicant Indicator Indicates if this person has a financial aid status or RORSTAT record identifying them as a financial aid applicant for the aid year. VARCHAR2(1)
FUNCTION

F_FINAID_APPLICANT_IND

FINANCIAL_AID_APPLICATION_IND Financial Aid Application Ind Indicates whether this person is an applicant for financial aid in this aid year. VARCHAR2(1)
CALCULATION

CASE WHEN (RCRAPP1_SEQ_NO

FM_APPLICATION_IND FM Application Ind Indicates whether Banner has data from a federal application (FASFA-EDE) and should be identified as an FM applicant for financial aid in this aid year. VARCHAR2(1)
CALCULATION

CASE WHEN (RCRAPP1_SEQ_NO

FM_BATCH_LOCK_IND FM Batch Lock Indicator Indicates whether the FM data for this person is locked from any updating by the batch tape load process. VARCHAR2(1)
RORSTAT

RORSTAT_FM_BATCH_LOCK

ID ID Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent. VARCHAR2(63)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

IM_APPLICATION_IND IM Application Ind Indicates whether Banner has data from an institution application (CSS profile) and should be identified as an IM applicant for financial aid in this aid year. VARCHAR2(1)
CALCULATION

CASE WHEN (RCRAPP1_SEQ_NO

IM_BATCH_LOCK_IND IM Batch Lock Indicator Indicates whether the IM data for this person is locked from any updating by the batch tape load process. VARCHAR2(1)
RORSTAT

RORSTAT_IM_BATCH_LOCK

MULTI_SOURCE Multi Source Institution value for the record when the optional multi-institution facility feature has been applied. VARCHAR2(63)
NA

NA

MULTI_SOURCE_DESC Multi Source Description Institution description when the optional multi-institution facility feature has been applied. VARCHAR2(255)
NA

NA

NAME Name Name of the person (last name, first name, middle initial) or organization. VARCHAR2(255)
FUNCTION

MGKFUNC.F_GET_PERSON_INFO

PACKAGE_COMPLETE_DATE Package Complete Date Date the student's financial aid package was complete. DATE
RORSTAT

RORSTAT_PCKG_COMP_DATE

PACKAGE_REQUIRE_COMPLETE_DATE Package Require Complete Date Date that tracking requirements were satisfied for packaging. DATE
RORSTAT

RORSTAT_PCKG_REQ_COMP_DATE

PACKAGING_GROUP Packaging Group Assigned packaging group for this financial aid applicant. VARCHAR2(63)
RORSTAT

RORSTAT_PGRP_CODE

PACKAGING_GROUP_DESC Packaging Group Description Code description assigned to the packaging group. VARCHAR2(255)
RTVPGRP

RTVPGRP_DESC

PERSON_UID Person UID System generated Banner unique ID which gets assigned to all person and non-person records within Banner. NUMBER
RORSTAT

RORSTAT_PIDM

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

NA

TRACKING_GROUP Tracking Group Assigned tracking group for this financial aid applicant. VARCHAR2(63)
RORSTAT

RORSTAT_TGRP_CODE

TRACKING_GROUP_DESC Tracking Group Description Tracking group code description. VARCHAR2(255)
RTVTGRP

RTVTGRP_DESC

VERIFICATION_COMPLETE_DATE Verification Complete Date Specifies the date the verification has been completed. DATE
RORSTAT

RORSTAT_VER_DATE

VERIFICATION_COMPLETE_IND Verification Complete Indicator Specifies whether the verification has been completed. VARCHAR2(1)
RORSTAT

RORSTAT_VER_COMPLETE

VERIFICATION_REQUIRED_IND Verification Required Indicator Specifies whether verification is required. VARCHAR2(1)
RCRAPP1

RCRAPP1_VERIFICATION_MSG

VERIFICATION_TRANSACTION_NO Verification Transaction Number Transaction number of the verification. VARCHAR2(63)
RORSTAT

RORSTAT_SAR_TRAN_NO

Ver: 9.0

Description	Contains data for the aid year and the person who has applied for financial aid for the aid year. The person may have submitted either or both a federal and institutional application for financial aid. Optionally the person may have the financial aid status record created without an application because of some other institutional process that required it to be created. Details may include application locked indicator, budget group, administrative group, packaging group, tracking group, financial aid application status data, and budget type.
Key & Frequency	One row per aid year and person.
Recommended Search Columns	AID_YEAR, PERSON_UID PERSON_UID

Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ADDITIONAL_PELL_AWARDS	Additional Pell Awards	Indicates whether student is receiving a second Pell award for the aid year.	VARCHAR2(1)	RORSTAT	RORSTAT_ADDL_PELL_ELIG_IND
ADDITIONAL_PELL_AWARDS_DESC	Additional Pell Award	Additional Pell award description.	VARCHAR2(255)	CALCULATION	CASE WHEN RORSTAT_ADDL_PELL_ELIB_IND
ADDITIONAL_STAFFORD_AWARDS	Additional Stafford Awards	Indicates if the applicant is eligible for additional Stafford awards.	VARCHAR2(1)	RORSTAT	RORSTAT_ADDL_STFD_ELIG_IND
ADDITIONAL_STAFFORD_AWRDS_DESC	Additional Stafford Awards Description.	Additional Stafford awards description.	VARCHAR2(255)	CALCULATION	CASE WHEN RORSTAT_ADDL_STFD_ELIG_IND
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AID_PERIOD	Aid Period	Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, etc.	VARCHAR2(63)	RORSTAT	RORSTAT_APRD_CODE
AID_PERIOD_DESC	Aid Period Description	Financial Aid period description.	VARCHAR2(255)	RTVAPRD	RTVAPRD_DESC
AID_YEAR	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)	RORSTAT	RORSTAT_AIDY_CODE
AID_YEAR_DESC	Aid Year Description	Financial aid year name.	VARCHAR2(255)	ROBINST	ROBINST_AIDY_DESC
ALL_REQUIRE_COMPLETE_DATE	All Require Complete Date	Date on which all tracking requirements for this applicant were satisfied.	DATE	RORSTAT	RORSTAT_ALL_REQ_COMP_DATE
APPLICATION_LOCKED_IND	Application Locked Indicator	Indicates whether the student's financial aid application record is locked.	VARCHAR2(1)	RORSTAT	RORSTAT_LOCK_IND
APPLICATION_RECEIVED_DATE	Application Received Date	Date this financial aid status record for this person recorded because either a financial aid application was received, processed or created or at least one tracking requirement was satisfied as defined by institution options.	DATE	RORSTAT	RORSTAT_APPL_RCVD_DATE
BUDGET_GROUP	Budget Group	Student's assigned budget group.	VARCHAR2(63)	RORSTAT	RORSTAT_BGRP_CODE
BUDGET_GROUP_DESC	Budget Group Description	Budget group code description. Identifies what it represents.	VARCHAR2(255)	RTVBGRP	RTVBGRP_DESC
DEPENDENT_NO_PARENT_DATA	Dependent No Parent Data	Indicates whether the dependent student is eligible for unsubsidized Stafford even though parent data has not been submitted on the FAFSA.	VARCHAR2(1)	RORSTAT	RORSTAT_DEP_NO_PAR_DATA
DEPENDENT_NO_PARENT_DATA_DESC	Dependent No Parent Data Description.	Dependent no parent data description.	VARCHAR2(255)	CALCULATION	CASE WHEN RORSTAT_DEP_NO_PAR_DATA
DISBURSE_REQUIRE_COMPLETE_DATE	Disburse Require Complete Date	Date that all tracking requirements mandatory for disbursement were satisfied for the particular student.	DATE	RORSTAT	RORSTAT_DISB_REQ_COMP_DATE
EXPECTED_ENROLL_STATUS	Expected Enrollment Status	Student's expected enrollment status for the school's aid year.	VARCHAR2(63)	RORSTAT	RORSTAT_XES
EXPECTED_ENROLL_STATUS_DESC	Expected Enrollment Status Description	Expected enrollment status description.	VARCHAR2(255)	RORMVAL	RORMVAL_DESC
FINAID_APPLICANT_IND	Finaid Applicant Indicator	Indicates if this person has a financial aid status or RORSTAT record identifying them as a financial aid applicant for the aid year.	VARCHAR2(1)	FUNCTION	F_FINAID_APPLICANT_IND
FINANCIAL_AID_APPLICATION_IND	Financial Aid Application Ind	Indicates whether this person is an applicant for financial aid in this aid year.	VARCHAR2(1)	CALCULATION	CASE WHEN (RCRAPP1_SEQ_NO
FM_APPLICATION_IND	FM Application Ind	Indicates whether Banner has data from a federal application (FASFA-EDE) and should be identified as an FM applicant for financial aid in this aid year.	VARCHAR2(1)	CALCULATION	CASE WHEN (RCRAPP1_SEQ_NO
FM_BATCH_LOCK_IND	FM Batch Lock Indicator	Indicates whether the FM data for this person is locked from any updating by the batch tape load process.	VARCHAR2(1)	RORSTAT	RORSTAT_FM_BATCH_LOCK
ID	ID	Northeastern University ID (NUID) is the unique primary person identifier, publicly distributable and permanently assigned to each university constituent.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
IM_APPLICATION_IND	IM Application Ind	Indicates whether Banner has data from an institution application (CSS profile) and should be identified as an IM applicant for financial aid in this aid year.	VARCHAR2(1)	CALCULATION	CASE WHEN (RCRAPP1_SEQ_NO
IM_BATCH_LOCK_IND	IM Batch Lock Indicator	Indicates whether the IM data for this person is locked from any updating by the batch tape load process.	VARCHAR2(1)	RORSTAT	RORSTAT_IM_BATCH_LOCK
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PACKAGE_COMPLETE_DATE	Package Complete Date	Date the student's financial aid package was complete.	DATE	RORSTAT	RORSTAT_PCKG_COMP_DATE
PACKAGE_REQUIRE_COMPLETE_DATE	Package Require Complete Date	Date that tracking requirements were satisfied for packaging.	DATE	RORSTAT	RORSTAT_PCKG_REQ_COMP_DATE
PACKAGING_GROUP	Packaging Group	Assigned packaging group for this financial aid applicant.	VARCHAR2(63)	RORSTAT	RORSTAT_PGRP_CODE
PACKAGING_GROUP_DESC	Packaging Group Description	Code description assigned to the packaging group.	VARCHAR2(255)	RTVPGRP	RTVPGRP_DESC
PERSON_UID	Person UID	System generated Banner unique ID which gets assigned to all person and non-person records within Banner.	NUMBER	RORSTAT	RORSTAT_PIDM
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
TRACKING_GROUP	Tracking Group	Assigned tracking group for this financial aid applicant.	VARCHAR2(63)	RORSTAT	RORSTAT_TGRP_CODE
TRACKING_GROUP_DESC	Tracking Group Description	Tracking group code description.	VARCHAR2(255)	RTVTGRP	RTVTGRP_DESC
VERIFICATION_COMPLETE_DATE	Verification Complete Date	Specifies the date the verification has been completed.	DATE	RORSTAT	RORSTAT_VER_DATE
VERIFICATION_COMPLETE_IND	Verification Complete Indicator	Specifies whether the verification has been completed.	VARCHAR2(1)	RORSTAT	RORSTAT_VER_COMPLETE
VERIFICATION_REQUIRED_IND	Verification Required Indicator	Specifies whether verification is required.	VARCHAR2(1)	RCRAPP1	RCRAPP1_VERIFICATION_MSG
VERIFICATION_TRANSACTION_NO	Verification Transaction Number	Transaction number of the verification.	VARCHAR2(63)	RORSTAT	RORSTAT_SAR_TRAN_NO