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. 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

ODS Column ODS Business Definition ODS Calculation Formula ODS Data Type Banner Source Name Banner Source Column Banner Form Name
ADMINISTRATIVE_GROUP Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.    

NA

NA

 
AID_PERIOD Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, etc.    

RORSTAT

RORSTAT_APRD_CODE

 
AID_PERIOD_DESC Financial Aid period description.    

RTVAPRD

RTVAPRD_DESC

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

RORSTAT

RORSTAT_AIDY_CODE

 
AID_YEAR_DESC Financial aid year name.    

ROBINST

ROBINST_AIDY_DESC

 
ALL_REQUIRE_COMPLETE_DATE Date on which all tracking requirements for this applicant were satisfied.    

RORSTAT

RORSTAT_ALL_REQ_COMP_DATE

 
APPLICATION_LOCKED_IND Indicates whether the student's financial aid application record is locked.    

RORSTAT

RORSTAT_LOCK_IND

 
BUDGET_GROUP Student's assigned budget group.    

RORSTAT

RORSTAT_BGRP_CODE

 
BUDGET_GROUP_DESC Budget group code description. Identifies what it represents.    

RTVBGRP

RTVBGRP_DESC

 
DISBURSE_REQUIRE_COMPLETE_DATE Date that all tracking requirements mandatory for disbursement were satisfied for the particular student.    

RORSTAT

RORSTAT_DISB_REQ_COMP_DATE

 
FINAID_APPLICANT_IND Indicates if the data associated with this person qualifies as a financial aid applicant for the associated aid year.    

FUNCTION

F_FINAID_APPLICANT_IND

 
FM_BATCH_LOCK_IND Indicates whether the FM data for this person is locked from any updating by the batch tape load process.    

RORSTAT

RORSTAT_FM_BATCH_LOCK

 
ID Person's or organization's current identification number.    

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
IM_BATCH_LOCK_IND Indicates whether the IM data for this person is locked from any updating by the batch tape load process.    

RORSTAT

RORSTAT_IM_BATCH_LOCK

 
MULTI_SOURCE Institution value for the record when the optional multi-institution facility feature has been applied.    

NA

NA

 
MULTI_SOURCE_DESC Institution description when the optional multi-institution facility feature has been applied.    

NA

NA

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

FUNCTION

MGKFUNC.F_GET_PERSON_INFO

 
PACKAGE_COMPLETE_DATE Date the student's financial aid package was complete.    

RORSTAT

RORSTAT_PCKG_COMP_DATE

 
PACKAGE_REQUIRE_COMPLETE_DATE Date that tracking requirements were satisfied for packaging.    

RORSTAT

RORSTAT_PCKG_REQ_COMP_DATE

 
PACKAGING_GROUP Assigned packaging group for this financial aid applicant.    

RORSTAT

RORSTAT_PGRP_CODE

 
PACKAGING_GROUP_DESC Code description assigned to the packaging group.    

RTVPGRP

RTVPGRP_DESC

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

RORSTAT

RORSTAT_PIDM

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

NA

NA

 
TRACKING_GROUP Assigned tracking group for this financial aid applicant.    

RORSTAT

RORSTAT_TGRP_CODE

 
TRACKING_GROUP_DESC Tracking group code description.    

RTVTGRP

RTVTGRP_DESC

 
VERIFICATION_COMPLETE_DATE Specifies the date the verification has been completed.    

RORSTAT

RORSTAT_VER_DATE

 
VERIFICATION_COMPLETE_IND Specifies whether the verification has been completed.    

RORSTAT

RORSTAT_VER_COMPLETE

 
VERIFICATION_REQUIRED_IND Specifies whether verification is required.    

RCRAPP1

RCRAPP1_VERIFICATION_MSG

 
VERIFICATION_TRANSACTION_NO Transaction number of the verification.    

RORSTAT

RORSTAT_SAR_TRAN_NO

 


Ver: 8.3