Go To View:  RETURN TO BANNER COMP META DATA REPORTS LIST
Financial Aid Composite View Reports

Banner Operational Data Store
Composite View Target: AR_FINAID_APPLICANT_STATUS

Description Source composite view contains each financial aid applicant with the latest application information for each aid year identified by the persons who have a financial aid status or RORSTAT record for the aid year.

Target Column Business Definition Database Data Type Source Name Source Column
ADDITIONAL_PELL_AWARDS   VARCHAR2(1)    
ADDITIONAL_PELL_AWARDS_DESC   VARCHAR2(30)    
ADDITIONAL_STAFFORD_AWARDS   VARCHAR2(1)    
ADDITIONAL_STAFFORD_AWRDS_DESC   VARCHAR2(30)    
AID_PERIOD Represents a financial aid period or portion of an aid year associated. Aid periods can be a single academic period or set of them as appropriate for tracking the aid awarded, accepted, paid, etc. VARCHAR2(6)

RORSTAT

RORSTAT_APRD_CODE

AID_PERIOD_DESC Financial Aid period description. VARCHAR2(30)

RTVAPRD

RTVAPRD_DESC

AID_YEAR Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation. VARCHAR2(4)

RORSTAT

RORSTAT_AIDY_CODE

AID_YEAR_DESC Financial aid year name. VARCHAR2(30)

ROBINST

ROBINST_AIDY_DESC

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 Indicates whether the student's financial aid application record is locked. VARCHAR2(1)

RORSTAT

RORSTAT_LOCK_IND

APPLICATION_RECEIVED_DATE   DATE    
BUDGET_GROUP Student's assigned budget group. VARCHAR2(6)

RORSTAT

RORSTAT_BGRP_CODE

BUDGET_GROUP_DESC Budget group code description. Identifies what it represents. VARCHAR2(30)

RTVBGRP

RTVBGRP_DESC

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

NA

SYSDATE

DEPENDENT_NO_PARENT_DATA   VARCHAR2(1)    
DEPENDENT_NO_PARENT_DATA_DESC   VARCHAR2(30)    
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

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

NA

NA

FINAID_APPLICANT_IND 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   VARCHAR2(1)    
FM_APPLICATION_IND   CHAR(1)    
FM_BATCH_LOCK_IND Determines if the FM data for this person is locked from any updating by the batch tape load process. (Y)es, it is locked, (N)o it is not locked. VARCHAR2(1)

RORSTAT

RORSTAT_FM_BATCH_LOCK

IM_APPLICATION_IND   CHAR(1)    
IM_BATCH_LOCK_IND Determines if the IM data for this person is locked from any updating by the batch tape load process. (Y)es it is locked for update, (N)o it is not locked for update. VARCHAR2(1)

RORSTAT

RORSTAT_IM_BATCH_LOCK

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

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

RORSTAT

RORSTAT_PCKG_COMP_DATE

PACKAGE_REQUIRE_COMPLETE_DATE Date that tracking requirements were satisfied for packaging. DATE

RORSTAT

RORSTAT_PCKG_REQ_COMP_DATE

PACKAGING_GROUP Assigned packaging group for this financial aid applicant. VARCHAR2(6)

RORSTAT

RORSTAT_PGRP_CODE

PACKAGING_GROUP_DESC Code description assigned to the packaging group. VARCHAR2(30)

RTVPGRP

RTVPGRP_DESC

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

RORSTAT

RORSTAT_PIDM

TRACKING_GROUP Assigned tracking group for this financial aid applicant. VARCHAR2(6)

RORSTAT

RORSTAT_TGRP_CODE

TRACKING_GROUP_DESC Tracking group code description. VARCHAR2(30)

RTVTGRP

RTVTGRP_DESC

VERIFICATION_COMPLETE_DATE Date the verification has been completed. DATE

NA

NA

VERIFICATION_COMPLETE_IND Specifies whether the verification has been completed. VARCHAR2(1)

RORSTAT

RORSTAT_VER_COMPLETE

VERIFICATION_REQUIRED_IND Specifies whether verification is required. VARCHAR2(1)

RCRAPP1

RCRAPP1_VERIFICATION_MSG

VERIFICATION_TRANSACTION_NO Transaction number of the verification. VARCHAR2(2)

RORSTAT

RORSTAT_SAR_TRAN_NO

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

NA

NA



Ver: