Target Column	Business Name	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic Period	Academic period representing the accounts receivable term for disbursement.	VARCHAR2(63)	RPRATRM	RPRATRM_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic Period Description	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACADEMIC_YEAR_OVERRIDE	Academic Year Override	Academic year to use for ACG and SMART Grant eligibility.	VARCHAR2(63)	RPRAWRD	RPRAWRD_OVERRIDE_YR_IN_COLL
ACADEMIC_YEAR_OVERRIDE_DESC	Academic Year Override Description	Year in college override description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
ACTIVITY_DATE	Activity Date	Date record was inserted or updated.	DATE	RPRATRM	RPRATRM_ACTIVITY_DATE
ADMINISTRATIVE_GROUP	Administrative Group	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AID_ENROLLMENT_PERIOD	Aid Enrollment Period	Aid enrollment period associated with the award schedule. This period can span multiple student terms.	VARCHAR2(63)	RPRATRM	RPRATRM_PERIOD
AID_ENROLLMENT_PERIOD_DESC	Aid Enrollment Period Description	Aid enrollment period description.	VARCHAR2(255)	ROBPRDS	ROBPRDS_DESC
AID_PERIOD	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
AID_PERIOD_DESC	Aid Period Description	Financial Aid period description.	VARCHAR2(255)	RTVAPRD	RTVAPRD_DESC
AID_YEAR	Financial 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
AID_YEAR_DESC	Aid Year Description	Financial aid year name.	VARCHAR2(255)	ROBINST	ROBINST_AIDY_DESC
ANNUAL_AWARD_LOCKED	Annual Award Locked	Aid year based lock code.	VARCHAR2(63)	RPRAWRD	RPRAWRD_LOCK_IND
ANNUAL_AWARD_LOCKED_DESC	Annual Award Locked Description	Annual award locked description.	VARCHAR2(255)	CALCULATION	DECODE(RPRAWRD_LOCK_IND)
AWARD_ACCEPT_AMOUNT	Award Accept Amount	Accepted amount for the financial aid fund that was accepted by students.	NUMBER	RPRATRM	RPRATRM_ACCEPT_AMT
AWARD_ACCEPT_DATE	Award Accept Date	Date that the award was accepted.	DATE	RPRATRM	RPRATRM_ACCEPT_DATE
AWARD_ACCEPT_IND	Award Accept Indicator	Indicates whether the person accepted this financial aid award.	VARCHAR2(63)	RTVAWST	RTVAWST_ACCEPT_IND
AWARD_AUTHORIZE_AMOUNT	Award Authorize Amount	Authorized amount for the financial aid fund for the person.	NUMBER	RPRATRM	RPRATRM_AUTHORIZE_AMT
AWARD_AUTHORIZE_DATE	Award Authorize Date	Date of the award authorization.	DATE	RPRATRM	RPRATRM_AUTHORIZE_DATE
AWARD_BY_PERSON_DATA_ORIGIN	Award By Person Data Origin	Source system that created or updated the data.	VARCHAR2(63)	RPRATRM	RPRATRM_DATA_ORIGIN
AWARD_CANCEL_AMOUNT	Award Cancel Amount	Canceled amount for the financial aid fund for the person.	NUMBER	RPRATRM	RPRATRM_CANCEL_AMT
AWARD_CANCEL_DATE	Award Cancel Date	Date that the award was cancelled.	DATE	RPRATRM	RPRATRM_CANCEL_DATE
AWARD_CANCEL_IND	Award Cancel Indicator	Indicates whether this financial aid award was canceled.	VARCHAR2(63)	RTVAWST	RTVAWST_CANCEL_IND
AWARD_DECLINE_AMOUNT	Award Decline Amount	Declined amount for the financial aid award for the person.	NUMBER	RPRATRM	RPRATRM_DECLINE_AMT
AWARD_DECLINE_DATE	Award Decline Date	Date that the award was declined.	DATE	RPRATRM	RPRATRM_DECLINE_DATE
AWARD_DECLINE_IND	Award Decline Indicator	Indicates whether this financial aid award was declined.	VARCHAR2(63)	RTVAWST	RTVAWST_DECLINE_IND
AWARD_LOAD_MISMATCH_IND	Award Load Mismatch Indicator	Indicates that the package load does not match any of the disbursement load indicators.	VARCHAR2(63)	FUNCTION	ROKODSF.F_GET_PCKG_LOAD_IND
AWARD_LOCKED	Award Locked	Academic period based lock code.	VARCHAR2(63)	RPRATRM	RPRATRM_LOCK_IND
AWARD_LOCKED_DESC	Award Locked Description	Award locked description.	VARCHAR2(255)	CALCULATION	DECODE(RPRATRM_LOCK_IND)
AWARD_MEMO_AMOUNT	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
AWARD_MEMO_DATE	Award Memo Date	Date that the award was memoed.	DATE	RPRATRM	RPRATRM_MEMO_DATE
AWARD_MEMO_EXPIRATION_DATE	Award Memo Expiration Date	Date that the memo will be cancelled.	DATE	RPRATRM RPRATRM	RPRATRM_MEMO_DATE RPRATRM_MEMO_EXP_DATE
AWARD_OFFER_AMOUNT	Award Offer Amount	Current offered amount for the financial aid award for the person.	NUMBER	RPRATRM	RPRATRM_OFFER_AMT
AWARD_OFFER_DATE	Award Offer Date	Date that the current award was offered.	DATE	RPRATRM	RPRATRM_OFFER_DATE
AWARD_OFFER_EXPIRATION_DATE	Award Offer Expiration Date	Expiration date of the award offered.	DATE	RPRATRM	RPRATRM_OFFER_EXP_DATE
AWARD_OFFER_IND	Award Offer Indicator	Indicates whether this financial aid award was offered.	VARCHAR2(63)	RTVAWST	RTVAWST_OFFER_IND
AWARD_ORIGINAL_OFFER_AMOUNT	Award Original Offer Amount	Dollar amount of the original offer of this fund code for this academic period.	NUMBER	RPRATRM	RPRATRM_ORIG_OFFER_AMT
AWARD_ORIGINAL_OFFER_DATE	Award Original Offer Date	Date that the original offer of the award was made.	DATE	RPRATRM	RPRATRM_ORIG_OFFER_DATE
AWARD_PAID_AMOUNT	Award Paid Amount	Paid or disbursed amount for the financial aid award for the person.	NUMBER	RPRATRM	RPRATRM_PAID_AMT
AWARD_PAID_DATE	Award Paid Date	Date that the award was paid.	DATE	RPRATRM	RPRATRM_PAID_DATE
AWARD_STATUS	Award Status	Current status for the financial aid award.	VARCHAR2(63)	RPRATRM	RPRATRM_AWST_CODE
AWARD_STATUS_DATE	Award Status Date	Date that the financial aid award status was changed.	DATE	RPRATRM	RPRATRM_AWST_DATE
AWARD_STATUS_DESC	Award Status Description	Description for the financial aid status.	VARCHAR2(255)	RTVAWST	RTVAWST_DESC
BBAY_TYPE	Bbay Type	Borrower-Based Academic Year type.	VARCHAR2(63)	ROBBBAY	ROBBBAY_BBTP_CODE
BBAY_TYPE_DESC	Bbay Type Description	Borrower-Based Academic Year type description.	VARCHAR2(255)	RTVBBTP	RTVBBTP_DESC
BORROWER_BASED_ACADEMIC_YEAR	Borrower Based Academic Year	Borrower-Based Academic Year.	VARCHAR2(63)	RPRATRM	RPRATRM_BBAY_CODE
BORROWER_BASED_ACAD_YEAR_DESC	Borrower Based Academic Year Description	Borrower-Based Academic Year description.	VARCHAR2(255)	ROBBBAY	ROBBBAY_DESC
CALC_STUDENT_ADJ_CREDITS	Calc Student Adjustment Credits	Calculates and displays the student's adjusted credits for the aid enrollment period.	NUMBER	FUNCTION	ROKODSF.F_SUM_CALC_STUD_ADJ_HRS
CALC_STUDENT_BILLING_HOURS	Calculate 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
DISBURSEMENT_FINALIZE_IND	Disbursement Finalize Indicator	Indicates whether all disbursements have been made within the academic period.	VARCHAR2(63)	RPRATRM	RPRATRM_DISB_FINAL_IND
DISBURSEMENT_RULE_OVERRIDE_IND	Disbursement Rule Override Indicator	Indicates whether the fund disbursement rule will be overridden when disbursing a fund to the student.	VARCHAR2(63)	RPRATRM	RPRATRM_OVERRIDE_DISB_RULE
FEDERAL_FUND_ID	Federal Fund ID	Federal fund associated with the fund code.	VARCHAR2(63)	RFRBASE	RFRBASE_FED_FUND_ID
FEDERAL_LIMIT_OVERRIDE_IND	Federal Limit Override Indicator	Used to override a federal limit on a fund when manually entering the award.	VARCHAR2(63)	RPRAWRD	RPRAWRD_FED_LIMIT_OVRDE_IND
FUND	Fund	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	RPRATRM	RPRATRM_FUND_CODE
FUND_AID_YEAR	Fund Financial Aid Year	Aid year associated with the Borrower-Based Academic_Year for origination and funding.	VARCHAR2(63)	RPRATRM	RPRATRM_AIDY_CODE_FUNDS
FUND_AID_YEAR_DESC	Fund Financial Aid Year Description	Fund's aid year name.	VARCHAR2(255)	ROBINST	ROBINST_AIDY_DESC
FUND_DETAIL_CODE	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
FUND_LIMIT_OVERRIDE_IND	Fund Limit Override Indicator	Used to override the fund limit when manually entering the fund on the students' award record.	VARCHAR2(63)	RPRAWRD	RPRAWRD_FUND_LIMIT_OVRDE_IND
FUND_PERIOD_ENABLED_IND	Fund Period Enabled Indicator	Determines whether the fund is enabled for aid enrollment period awarding.	VARCHAR2(1)	RFRASPC	RFRASPC_ENABLE_PERIOD_AWARDING
FUND_SOURCE	Fund Source	Fund source code to be associated with the fund as defined by the institution.	VARCHAR2(63)	RFRBASE	RFRBASE_FSRC_CODE
FUND_SOURCE_DESC	Fund Source Description	Describes the fund source code and identifies what it represents.	VARCHAR2(255)	RTVFSRC	RTVFSRC_DESC
FUND_TITLE	Fund Title	Full title of the financial aid fund code.	VARCHAR2(255)	RFRBASE	RFRBASE_FUND_TITLE
FUND_TYPE	Fund Type	Fund type code to be associated with the fund as defined by the institution.	VARCHAR2(63)	RFRBASE	RFRBASE_FTYP_CODE
FUND_TYPE_DESC	Fund Type Description	Fund type code description or title.	VARCHAR2(255)	RTVFTYP	RTVFTYP_DESC
GIFT_OR_SELF_HELP_AID	Gift or Self Help Aid Indicator	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)
GIFT_OR_SELF_HELP_AID_DESC	Gift or Self Help Aid Indicator Description	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)
ID	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
INSTITUTION_AID_IND	Institution Aid Indicator	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
MAJOR_OVERRIDE	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
MAJOR_OVERRIDE_DESC	Major Override Description.	Major override description.	VARCHAR2(255)	STVMAJR	STVMAJR_DESC
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
NO_PELL_OVERRIDE_IND	No Pell Override Indicator	Indicates if the Pell award validation rule has been overridden for the ACG or SMART grant award.	VARCHAR2(63)	RPRAWRD	RPRAWRD_OVERRIDE_NO_PELL
ORIGINAL_AID_YEAR	Original Financial Aid Year	Original aid year in the event the fund's aid year is used.	VARCHAR2(63)	RPRATRM	RPRATRM_AIDY_CODE
ORIGINAL_AID_YEAR_DESC	Original Financial Aid Year Description	Original financial aid year name.	VARCHAR2(255)	ROBINST	ROBINST_AIDY_DESC
PELL_AWARD_ENROLLMENT_OPTION	Pell Award Enrollment Option	Source of the enrollment option when calculating a PELL award.	VARCHAR2(63)	RPRATRM	RPRATRM_PELL_AWRD_LOAD_OPT
PELL_AWARD_ENROLLMENT_OPT_DESC	Pell Award Enrollment Option Description	Source of the enrollment option description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
PERCENT_DISTRIBUTION_ACAD_PER	Percent Distribution Acad Period	Distribution of the award over the academic periods associated with the record.	NUMBER	RPRATRM	RPRATRM_DIST_PCT
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RPRATRM	RPRATRM_PIDM
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
PROGRAM_CLASSIFICATION_OVR	Program Classification Override	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
PROGRAM_CLASS_OVR_DESC	Program Classification Override Description	CIP override description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_CIPC_DESC
REPLACE_TFC_OVERRIDE_IND	Replace TFC Override Indicator	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
STUDENT_ACADEMIC_PERIOD	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
STUDENT_ACADEMIC_PERIOD_DESC	Student Academic Period Description.	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
STUDENT_LOAN_OVERRIDE	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
STUDENT_LOAN_OVERRIDE_DESC	Student Loan Override Description	Student loan override description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
SYSTEM	System	Specifies whether the award was system or manually generated.	VARCHAR2(63)	RPRAWRD	RPRAWRD_SYS_IND
SYSTEM_DESC	System Description	System description.	VARCHAR2(255)	CALCULATION	DECODE(RPRAWRD_SYS_IND)
TIME_STATUS	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
TIME_STATUS_DESC	Time Status Description	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
TRACKING_REQ_OVERRIDE_IND	Tracking Requirement Override Indicator	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
UNMET_NEED_OVERRIDE	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
UNMET_NEED_OVERRIDE_DESC	Unmet Need Override Description	Unmet need override description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_RORMVAL_DESC
USER_ID	User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	RPRATRM	RPRATRM_USER_ID

Ver: 9.2