Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ADDITIONAL_PELL_AWARDS
|
|
VARCHAR2(1)
|
|
|
|
NO
|
ADDITIONAL_PELL_AWARDS_DESC
|
|
VARCHAR2(30)
|
|
|
|
NO
|
ADDITIONAL_STAFFORD_AWARDS
|
|
VARCHAR2(1)
|
|
|
|
NO
|
ADDITIONAL_STAFFORD_AWRDS_DESC
|
|
VARCHAR2(30)
|
|
|
|
NO
|
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
|
NO
|
NO
|
AID_PERIOD_DESC
|
Financial Aid period description.
|
VARCHAR2(30)
|
RTVAPRD
|
RTVAPRD_DESC
|
NO
|
NO
|
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
|
NO
|
NO
|
AID_YEAR_DESC
|
Financial aid year name.
|
VARCHAR2(30)
|
ROBINST
|
ROBINST_AIDY_DESC
|
NO
|
NO
|
ALL_REQUIRE_COMPLETE_DATE
|
Date on which all tracking requirements for this applicant were satisfied.
|
DATE
|
RORSTAT
|
RORSTAT_ALL_REQ_COMP_DATE
|
NO
|
NO
|
APPLICATION_LOCKED_IND
|
Indicates whether the student's financial aid application record is locked.
|
VARCHAR2(1)
|
RORSTAT
|
RORSTAT_LOCK_IND
|
NO
|
NO
|
APPLICATION_RECEIVED_DATE
|
|
DATE
|
|
|
|
NO
|
BUDGET_GROUP
|
Student's assigned budget group.
|
VARCHAR2(6)
|
RORSTAT
|
RORSTAT_BGRP_CODE
|
NO
|
NO
|
BUDGET_GROUP_DESC
|
Budget group code description. Identifies what it represents.
|
VARCHAR2(30)
|
RTVBGRP
|
RTVBGRP_DESC
|
NO
|
NO
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
NO
|
NO
|
DEPENDENT_NO_PARENT_DATA
|
|
VARCHAR2(1)
|
|
|
|
NO
|
DEPENDENT_NO_PARENT_DATA_DESC
|
|
VARCHAR2(30)
|
|
|
|
NO
|
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
|
NO
|
NO
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
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
|
NO
|
NO
|
FINANCIAL_AID_APPLICATION_IND
|
|
VARCHAR2(1)
|
|
|
|
NO
|
FM_APPLICATION_IND
|
|
CHAR(1)
|
|
|
|
NO
|
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
|
NO
|
NO
|
IM_APPLICATION_IND
|
|
CHAR(1)
|
|
|
|
NO
|
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
|
NO
|
NO
|
MIF_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
MIF_VALUE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
PACKAGE_COMPLETE_DATE
|
Date the student's financial aid package was complete.
|
DATE
|
RORSTAT
|
RORSTAT_PCKG_COMP_DATE
|
NO
|
NO
|
PACKAGE_REQUIRE_COMPLETE_DATE
|
Date that tracking requirements were satisfied for packaging.
|
DATE
|
RORSTAT
|
RORSTAT_PCKG_REQ_COMP_DATE
|
NO
|
NO
|
PACKAGING_GROUP
|
Assigned packaging group for this financial aid applicant.
|
VARCHAR2(6)
|
RORSTAT
|
RORSTAT_PGRP_CODE
|
NO
|
NO
|
PACKAGING_GROUP_DESC
|
Code description assigned to the packaging group.
|
VARCHAR2(30)
|
RTVPGRP
|
RTVPGRP_DESC
|
NO
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
RORSTAT
|
RORSTAT_PIDM
|
NO
|
NO
|
TRACKING_GROUP
|
Assigned tracking group for this financial aid applicant.
|
VARCHAR2(6)
|
RORSTAT
|
RORSTAT_TGRP_CODE
|
NO
|
NO
|
TRACKING_GROUP_DESC
|
Tracking group code description.
|
VARCHAR2(30)
|
RTVTGRP
|
RTVTGRP_DESC
|
NO
|
NO
|
VERIFICATION_COMPLETE_DATE
|
Date the verification has been completed.
|
DATE
|
NA
|
NA
|
NO
|
NO
|
VERIFICATION_COMPLETE_IND
|
Specifies whether the verification has been completed.
|
VARCHAR2(1)
|
RORSTAT
|
RORSTAT_VER_COMPLETE
|
NO
|
NO
|
VERIFICATION_REQUIRED_IND
|
Specifies whether verification is required.
|
VARCHAR2(1)
|
RCRAPP1
|
RCRAPP1_VERIFICATION_MSG
|
NO
|
NO
|
VERIFICATION_TRANSACTION_NO
|
Transaction number of the verification.
|
VARCHAR2(2)
|
RORSTAT
|
RORSTAT_SAR_TRAN_NO
|
NO
|
NO
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|