Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACADEMIC_PERIOD	Academic period representing the accounts receivable term for disbursement.	VARCHAR2(63)	RPRATRM	RPRATRM_TERM_CODE	NO	NO
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC	NO	NO
ACADEMIC_YEAR_OVERRIDE	Academic year to use for ACG and SMART Grant eligibility.	VARCHAR2(63)	RPRAWRD	RPRAWRD_OVERRIDE_YR_IN_COLL	NO	NO
ACADEMIC_YEAR_OVERRIDE_DESC	Year in college override description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC	NO	NO
ACTIVITY_DATE	Date record was inserted or updated.	DATE	RPRATRM	RPRATRM_ACTIVITY_DATE	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
AID_ENROLLMENT_PERIOD	Aid enrollment period associated with the award schedule. This period can span multiple student terms.	VARCHAR2(63)	RPRATRM	RPRATRM_PERIOD	NO	NO
AID_ENROLLMENT_PERIOD_DESC	Aid enrollment period description.	VARCHAR2(255)	ROBPRDS	ROBPRDS_DESC	NO	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(63)	RORSTAT	RORSTAT_APRD_CODE	NO	NO
AID_PERIOD_DESC	Financial Aid period description.	VARCHAR2(255)	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(63)	CALCULATION RPRATRM	NVL(RPRATRM_AIDY_CODE_FUNDS, RPRATRM_AIDY_CODE) RPRATRM_AIDY_CODE	NO NO	NO
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(255)	ROBINST	ROBINST_AIDY_DESC	NO	NO
ANNUAL_AWARD_LOCKED	Aid year based lock code.	VARCHAR2(63)	RPRAWRD	RPRAWRD_LOCK_IND	NO	NO
ANNUAL_AWARD_LOCKED_DESC	Annual award locked description.	VARCHAR2(255)	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(63)	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_BY_PERSON_DATA_ORIGIN	Source system that created or updated the data.	VARCHAR2(63)	RPRATRM	RPRATRM_DATA_ORIGIN	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(63)	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(63)	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(63)	FUNCTION	ROKODSF.F_GET_PCKG_LOAD_IND	NO	NO
AWARD_LOCKED	Academic period based lock code.	VARCHAR2(63)	RPRATRM	RPRATRM_LOCK_IND	NO	NO
AWARD_LOCKED_DESC	Award locked description.	VARCHAR2(255)	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_DATE	Date that the award was memoed.	DATE	RPRATRM	RPRATRM_MEMO_DATE	NO	NO
AWARD_MEMO_EXPIRATION_DATE	Date that the memo will be cancelled.	DATE	RPRATRM RPRATRM	RPRATRM_MEMO_DATE RPRATRM_MEMO_EXP_DATE	NO 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_EXPIRATION_DATE	Expiration date of the award offered.	DATE	RPRATRM	RPRATRM_OFFER_EXP_DATE	NO	NO
AWARD_OFFER_IND	Indicates whether this financial aid award was offered.	VARCHAR2(63)	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(63)	RPRATRM	RPRATRM_AWST_CODE	NO	NO
AWARD_STATUS_DATE	Date that the financial aid award status was changed.	DATE	RPRATRM	RPRATRM_AWST_DATE	NO	NO
AWARD_STATUS_DESC	Description for the financial aid status.	VARCHAR2(255)	RTVAWST	RTVAWST_DESC	NO	NO
BBAY_TYPE	Borrower-Based Academic Year type.	VARCHAR2(63)	ROBBBAY	ROBBBAY_BBTP_CODE	NO	NO
BBAY_TYPE_DESC	Borrower-Based Academic Year type description.	VARCHAR2(255)	RTVBBTP	RTVBBTP_DESC	NO	NO
BORROWER_BASED_ACADEMIC_YEAR	Borrower-Based Academic Year.	VARCHAR2(63)	RPRATRM	RPRATRM_BBAY_CODE	NO	NO
BORROWER_BASED_ACAD_YEAR_DESC	Borrower-Based Academic Year description.	VARCHAR2(255)	ROBBBAY	ROBBBAY_DESC	NO	NO
CALC_STUDENT_ADJ_CREDITS	Calculates and displays the student's adjusted credits for the aid enrollment 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 aid enrollment period.	NUMBER	FUNCTION	ROKODSF.F_SUM_CALC_STUD_BILL_HRS	NO	NO
DISBURSEMENT_FINALIZE_IND	Indicates whether all disbursements have been made within the academic period.	VARCHAR2(63)	RPRATRM	RPRATRM_DISB_FINAL_IND	NO	NO
DISBURSEMENT_RULE_OVERRIDE_IND	Indicates whether the fund disbursement rule will be overridden when disbursing a fund to the student.	VARCHAR2(63)	RPRATRM	RPRATRM_OVERRIDE_DISB_RULE	NO	NO
FEDERAL_FUND_ID	Federal fund associated with the fund code.	VARCHAR2(63)	RFRBASE	RFRBASE_FED_FUND_ID	NO	NO
FEDERAL_LIMIT_OVERRIDE_IND	Used to override a federal limit on a fund when manually entering the award.	VARCHAR2(63)	RPRAWRD	RPRAWRD_FED_LIMIT_OVRDE_IND	NO	NO
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	RPRATRM	RPRATRM_FUND_CODE	NO	NO
FUND_AID_YEAR	Aid year associated with the Borrower-Based Academic_Year for origination and funding.	VARCHAR2(63)	RPRATRM	RPRATRM_AIDY_CODE_FUNDS	NO	NO
FUND_AID_YEAR_DESC	Fund's aid year name.	VARCHAR2(255)	ROBINST	ROBINST_AIDY_DESC	NO	NO
FUND_DETAIL_CODE	Links a financial aid fund code to an AR detail code for crediting funds to student accounts.	VARCHAR2(63)	RFRBASE	RFRBASE_DETAIL_CODE	NO	NO
FUND_LIMIT_OVERRIDE_IND	Used to override the fund limit when manually entering the fund on the students' award record.	VARCHAR2(63)	RPRAWRD	RPRAWRD_FUND_LIMIT_OVRDE_IND	NO	NO
FUND_PERIOD_ENABLED_IND	Determines whether the fund is enabled for aid enrollment period awarding.	VARCHAR2(1)	RFRASPC	RFRASPC_ENABLE_PERIOD_AWARDING	NO	NO
FUND_SOURCE	Fund source code to be associated with the fund as defined by the institution.	VARCHAR2(63)	RFRBASE	RFRBASE_FSRC_CODE	NO	NO
FUND_SOURCE_DESC	Describes the fund source code and identifies what it represents.	VARCHAR2(255)	RTVFSRC	RTVFSRC_DESC	NO	NO
FUND_TITLE	Full title of the financial aid fund code.	VARCHAR2(255)	RFRBASE	RFRBASE_FUND_TITLE	NO	NO
FUND_TYPE	Fund type code to be associated with the fund as defined by the institution.	VARCHAR2(63)	RFRBASE	RFRBASE_FTYP_CODE	NO	NO
FUND_TYPE_DESC	Fund type code description or title.	VARCHAR2(255)	RTVFTYP	RTVFTYP_DESC	NO	NO
GIFT_OR_SELF_HELP_AID	Classification of an award (or fund) based on the financial aid type associated with the fund, with Gift Aid having an aid type of grant or scholarship and Self Help Aid having an aid type of loan or work.	VARCHAR2(63)	CALCULATION	DECODE(RTVFTYP_ATYP_IND)	NO	NO
GIFT_OR_SELF_HELP_AID_DESC	Description of the Gift or Self Help Aid code, where G = Gift Aid and S = Self Help Aid.	VARCHAR2(255)	CALCULATION	DECODE(RTVFTYP_ATYP_IND)	NO	NO
ID	Identification number assigned to a person that is used externally for all communication and correspondence with the person.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	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(63)	FUNCTION	F_INST_AID_FNC	NO	NO
MAJOR_OVERRIDE	Major the student intends to major in if the school does not require students to declare a major by their junior year.	VARCHAR2(63)	RPRATRM	RPRATRM_MAJR_OVERRIDE_CODE	NO	NO
MAJOR_OVERRIDE_DESC	Major override description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
NAME	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO	NO	NO
NO_PELL_OVERRIDE_IND	Indicates if the Pell award validation rule has been overridden for the ACG or SMART grant award.	VARCHAR2(63)	RPRAWRD	RPRAWRD_OVERRIDE_NO_PELL	NO	NO
ORIGINAL_AID_YEAR	Original aid year in the event the fund's aid year is used.	VARCHAR2(63)	RPRATRM	RPRATRM_AIDY_CODE	NO	NO
ORIGINAL_AID_YEAR_DESC	Original financial aid year name.	VARCHAR2(255)	ROBINST	ROBINST_AIDY_DESC	NO	NO
PELL_AWARD_ENROLLMENT_OPTION	Source of the enrollment option when calculating a PELL award.	VARCHAR2(63)	RPRATRM	RPRATRM_PELL_AWRD_LOAD_OPT	NO	NO
PELL_AWARD_ENROLLMENT_OPT_DESC	Source of the enrollment option description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC	NO	NO
PERCENT_DISTRIBUTION_ACAD_PER	Distribution of the award over the academic periods associated with the record.	NUMBER	RPRATRM	RPRATRM_DIST_PCT	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RPRATRM	RPRATRM_PIDM	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	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(63)	RPRATRM	RPRATRM_CIP_OVERRIDE_CODE	NO	NO
PROGRAM_CLASS_OVR_DESC	CIP override description.	VARCHAR2(255)	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(63)	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(63)	RORPRDS	RORPRDS_TERM_CODE	NO	NO
STUDENT_ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC	NO	NO
STUDENT_LOAN_OVERRIDE	Indicates which validation tests Packaging/Disbursement processes should override for a specific Year/Student/Fund/Academic Period.	VARCHAR2(63)	RPRATRM	RPRATRM_NSLDS_OVRD_IND	NO	NO
STUDENT_LOAN_OVERRIDE_DESC	Student loan override description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC	NO	NO
SYSTEM	Specifies whether the award was system or manually generated.	VARCHAR2(63)	RPRAWRD	RPRAWRD_SYS_IND	NO	NO
SYSTEM_DESC	System description.	VARCHAR2(255)	CALCULATION	DECODE(RPRAWRD_SYS_IND)	NO	NO
TIME_STATUS	Identifies the student enrollment load at the time of packaging as either full time, three-quarter time, half time or less than half time.	VARCHAR2(63)	RPRATRM	RPRATRM_PCKG_LOAD_IND	NO	NO
TIME_STATUS_DESC	Description of the student enrollment load at the time of packaging as either full time, three-quarter time, half time or less than half time.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC	NO	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(63)	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(63)	RPRAWRD	RPRAWRD_UNMET_NEED_OVRDE_IND	NO	NO
UNMET_NEED_OVERRIDE_DESC	Unmet need override description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC	NO	NO
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	RPRATRM	RPRATRM_USER_ID	NO	NO

Ver: 9.2