Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACADEMIC_PERIOD	Represents an academic period or a portion of the academic year. Academic periods may divide the year into terms, quarters or some other portion of time. This is usually set up to track the academic data like enrollment to a more finite level than the academic year.	VARCHAR2(6)	RPRATRM	RPRATRM_TERM_CODE	NO	NO
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(30)	STVTERM	STVTERM_DESC	NO	NO
ACADEMIC_YEAR_OVERRIDE	Academic year to use for ACG and SMART Grant eligibility.	VARCHAR2(1)	RPRAWRD	RPRAWRD_OVERRIDE_YR_IN_COLL	NO	NO
ACADEMIC_YEAR_OVERRIDE_DESC	Year in college override description.	VARCHAR2(15)				NO
ACTIVITY_DATE	Date record was inserted or updated.	DATE	RPRATRM	RPRATRM_ACTIVITY_DATE	NO	NO
AID_ENROLLMENT_PERIOD		VARCHAR2(15)				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)	RPRATRM	RPRATRM_AIDY_CODE	NO	NO
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(30)	ROBINST	ROBINST_AIDY_DESC	NO	NO
ANNUAL_AWARD_LOCKED	Aid year based lock code.	VARCHAR2(1)	RPRAWRD	RPRAWRD_LOCK_IND	NO	NO
ANNUAL_AWARD_LOCKED_DESC	Annual award locked description.	VARCHAR2(55)	CALCULATION	DECODE(RPRAWRD_LOCK_IND)	NO	NO
AWARD_ACCEPT_AMOUNT	Accepted amount for the financial aid fund that was accepted by students.	NUMBER	RPRATRM	RPRATRM_ACCEPT_AMT	NO	NO
AWARD_ACCEPT_DATE	Date that the award was accepted.	DATE	RPRATRM	RPRATRM_ACCEPT_DATE	NO	NO
AWARD_ACCEPT_IND	Indicates whether the person accepted this financial aid award.	VARCHAR2(1)	RTVAWST	RTVAWST_ACCEPT_IND	NO	NO
AWARD_AUTHORIZE_AMOUNT	Authorized amount for the financial aid fund for the person.	NUMBER	RPRATRM	RPRATRM_AUTHORIZE_AMT	NO	NO
AWARD_AUTHORIZE_DATE	Date of the award authorization.	DATE	RPRATRM	RPRATRM_AUTHORIZE_DATE	NO	NO
AWARD_CANCEL_AMOUNT	Canceled amount for the financial aid fund for the person.	NUMBER	RPRATRM	RPRATRM_CANCEL_AMT	NO	NO
AWARD_CANCEL_DATE	Date that the award was cancelled.	DATE	RPRATRM	RPRATRM_CANCEL_DATE	NO	NO
AWARD_CANCEL_IND	Indicates whether this financial aid award was canceled.	VARCHAR2(1)	RTVAWST	RTVAWST_CANCEL_IND	NO	NO
AWARD_DECLINE_AMOUNT	Declined amount for the financial aid award for the person.	NUMBER	RPRATRM	RPRATRM_DECLINE_AMT	NO	NO
AWARD_DECLINE_DATE	Date that the award was declined.	DATE	RPRATRM	RPRATRM_DECLINE_DATE	NO	NO
AWARD_DECLINE_IND	Indicates whether this financial aid award was declined.	VARCHAR2(1)	RTVAWST	RTVAWST_DECLINE_IND	NO	NO
AWARD_LOAD_MISMATCH_IND	Indicates that the package load does not match any of the disbursement load indicators.	VARCHAR2(1)	FUNCTION	ROKODSF.F_GET_PCKG_LOAD_IND	NO	NO
AWARD_LOCKED	Academic period based lock code.	VARCHAR2(1)	RPRATRM	RPRATRM_LOCK_IND	NO	NO
AWARD_LOCKED_DESC	Award locked description.	VARCHAR2(55)	CALCULATION	DECODE(RPRATRM_LOCK_IND)	NO	NO
AWARD_MEMO_AMOUNT	Memo amount for the financial aid award for the person. This amount is intended but does not yet fit into any of the other financial aid amount groupings.	NUMBER	RPRATRM	RPRATRM_MEMO_AMT	NO	NO
AWARD_MEMO_EXPIRATION_DATE	Date that the memo will be cancelled.	DATE	RPRATRM	RPRATRM_MEMO_DATE	NO	NO
AWARD_OFFER_AMOUNT	Current offered amount for the financial aid award for the person.	NUMBER	RPRATRM	RPRATRM_OFFER_AMT	NO	NO
AWARD_OFFER_DATE	Date that the current award was offered.	DATE	RPRATRM	RPRATRM_OFFER_DATE	NO	NO
AWARD_OFFER_IND	Indicates whether this financial aid award was offered.	VARCHAR2(1)	RTVAWST	RTVAWST_OFFER_IND	NO	NO
AWARD_ORIGINAL_OFFER_AMOUNT	Dollar amount of the original offer of this fund code for this academic period.	NUMBER	RPRATRM	RPRATRM_ORIG_OFFER_AMT	NO	NO
AWARD_ORIGINAL_OFFER_DATE	Date that the original offer of the award was made.	DATE	RPRATRM	RPRATRM_ORIG_OFFER_DATE	NO	NO
AWARD_PAID_AMOUNT	Paid or disbursed amount for the financial aid award for the person.	NUMBER	RPRATRM	RPRATRM_PAID_AMT	NO	NO
AWARD_PAID_DATE	Date that the award was paid.	DATE	RPRATRM	RPRATRM_PAID_DATE	NO	NO
AWARD_STATUS	Current status for the financial aid award.	VARCHAR2(4)	RPRAWRD	RPRAWRD_AWST_CODE	NO	NO
AWARD_STATUS_DATE	Date that the financial aid award status was changed.	DATE	RPRAWRD	RPRAWRD_AWST_DATE	NO	NO
AWARD_STATUS_DESC	Description for the financial aid status.	VARCHAR2(30)	RTVAWST	RTVAWST_DESC	NO	NO
CALC_STUDENT_ADJ_CREDITS	Calculates and displays the student's adjusted credits for the academic period.	NUMBER	FUNCTION	ROKODSF.F_SUM_CALC_STUD_ADJ_HRS	NO	NO
CALC_STUDENT_BILLING_HOURS	Calculates and displays the student's billing hours for the academic period.	NUMBER	FUNCTION	ROKODSF.F_SUM_CALC_STUD_BILL_HRS	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DISBURSEMENT_FINALIZE_IND	Indicates whether all disbursements have been made within the academic period.	VARCHAR2(1)	RPRATRM	RPRATRM_DISB_FINAL_IND	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
FEDERAL_LIMIT_OVERRIDE_IND	Used to override a federal limit on a fund when manually entering the award.	VARCHAR2(1)	RPRAWRD	RPRAWRD_FED_LIMIT_OVRDE_IND	NO	NO
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(6)	RPRATRM	RPRATRM_FUND_CODE	NO	NO
FUND_LIMIT_OVERRIDE_IND	Used to override the fund limit when manually entering the fund on the students' award record.	VARCHAR2(1)	RPRAWRD	RPRAWRD_FUND_LIMIT_OVRDE_IND	NO	NO
FUND_TITLE	Full title of the financial aid fund code.	VARCHAR2(30)	RFRBASE	RFRBASE_FUND_TITLE	NO	NO
INSTITUTION_AID_IND	Indicates whether the person is receiving a financial aid award that is identified with a financial aid fund type of as institution aid.	VARCHAR2(1)	FUNCTION	F_INST_AID_FNC	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
NO_PELL_OVERRIDE_IND	Indicates if the Pell award validation rule has been overridden for the ACG or SMART grant award.	VARCHAR2(1)	RPRAWRD	RPRAWRD_OVERRIDE_NO_PELL	NO	NO
PELL_AWARD_ENROLLMENT_OPTION	Source of the enrollment option when calculating a PELL award.	VARCHAR2(1)	RPRATRM	RPRATRM_PELL_AWRD_LOAD_OPT	NO	NO
PELL_AWARD_ENROLLMENT_OPT_DESC	Source of the enrollment option description.	VARCHAR2(25)				NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RPRATRM	RPRATRM_PIDM	NO	NO
PROGRAM_CLASSIFICATION_OVR	Used to override the CIP code associated with the student's current major to enable a SMART grant to disburse.	VARCHAR2(6)	RPRATRM	RPRATRM_CIP_OVERRIDE_CODE	NO	NO
PROGRAM_CLASS_OVR_DESC	CIP override description.	VARCHAR2(100)	FUNCTION	ROKODSF.F_GET_CIPC_DESC	NO	NO
REPLACE_TFC_OVERRIDE_IND	Used to override the rule to replace Total Family Contribution when manually adding the award to the students' record.	VARCHAR2(1)	RPRAWRD	RPRAWRD_REPLACE_TFC_OVRDE_IND	NO	NO
STUDENT_ACADEMIC_PERIOD	Academic period representing the term to pull the student data used for the aid enrollment period. As an example, student classification, or student.	VARCHAR2(6)	RORPRDS	RORPRDS_TERM_CODE	NO	NO
STUDENT_ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(30)	STVTERM	STVTERM_DESC	NO	NO
STUDENT_LOAN_OVERRIDE	Indicates which validation tests Packaging/Disbursment processes should override for a specific Year/Student/Fund/Academic Period.	VARCHAR2(1)	RPRATRM	RPRATRM_NSLDS_OVRD_IND	NO	NO
STUDENT_LOAN_OVERRIDE_DESC	Student loan override description.	VARCHAR2(25)				NO
SYSTEM	Specifies whether the award was system or manually generated.	VARCHAR2(1)	RPRAWRD	RPRAWRD_SYS_IND	NO	NO
SYSTEM_DESC	System description.	VARCHAR2(6)	CALCULATION	DECODE(RPRAWRD_SYS_IND)	NO	NO
TERM_PERCENT_OF_DISTRIBUTION	Distribution of the award over the academic periods associated with the record.	NUMBER	RPRATRM	RPRATRM_DIST_PCT	NO	NO
TIME_STATUS	Student's enrollment status at the time of packaging. E.g., three quarter time, half time, full time.	VARCHAR2(1)	RPRATRM	RPRATRM_PCKG_LOAD_IND	NO	NO
TIME_STATUS_DESC	Description of Student's enrollment status at the time of packaging. E.g., three quarter time, half time, full time.	VARCHAR2(20)				NO
TRACKING_REQ_OVERRIDE_IND	Used to override the rule that all tracking requirements must be satisfied when manually adding the fund to the students' award record.	VARCHAR2(1)	RPRAWRD	RPRAWRD_TREQ_OVRDE_IND	NO	NO
UNMET_NEED_OVERRIDE	Used to override the unmet need rule when manually adding an award to the students' record.	VARCHAR2(1)	RPRAWRD	RPRAWRD_UNMET_NEED_OVRDE_IND	NO	NO
UNMET_NEED_OVERRIDE_DESC	Unmet need override description.	VARCHAR2(4)				NO
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)	RPRATRM	RPRATRM_USER_ID	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

Ver: