| ODS Column |
ODS Business Definition |
ODS Calculation Formula |
ODS Data Type |
Banner Source Name |
Banner Source Column |
Banner Form Name |
|
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
|
|
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
|
|
NA
|
SYSDATE
|
|
|
DISBURSE_REQUIRE_COMPLETE_DATE
|
Date that all tracking requirements mandatory for disbursement were satisfied for the particular student.
|
|
|
RORSTAT
|
RORSTAT_DISB_REQ_COMP_DATE
|
|
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
|
|
NA
|
NA
|
|
|
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
|
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.
|
|
|
RORSTAT
|
RORSTAT_FM_BATCH_LOCK
|
|
|
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.
|
|
|
RORSTAT
|
RORSTAT_IM_BATCH_LOCK
|
|
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
|
|
NA
|
NA
|
|
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
|
|
NA
|
NA
|
|
|
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
|
|
|
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
|
Date the verification has been completed.
|
|
|
NA
|
NA
|
|
|
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
|
|
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
|
|
NA
|
NA
|
|