Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic period associated with information in this record.	VARCHAR2(63)	RPRATRM	RPRATRM_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
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	Year in college override description.	VARCHAR2(255)	CALCULATION	DECODE(RPRAWRD_OVERRIDE_YR_IN_COLL)
ACTIVITY_DATE	Date record was inserted or updated.	DATE	RPRATRM	RPRATRM_ACTIVITY_DATE
ADMINISTRATIVE_GROUP	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA
AID_PERIOD	Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, etc.	VARCHAR2(63)	RORSTAT	RORSTAT_APRD_CODE
AID_PERIOD_DESC	Financial Aid period description.	VARCHAR2(255)	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).	VARCHAR2(63)	RPRATRM	RPRATRM_AIDY_CODE
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(255)	ROBINST	ROBINST_AIDY_DESC
ANNUAL_AWARD_LOCKED	Aid year based lock code.	VARCHAR2(63)	RPRAWRD	RPRAWRD_LOCK_IND
ANNUAL_AWARD_LOCKED_DESC	Annual award locked description.	VARCHAR2(255)	CALCULATION	DECODE(RPRAWRD_LOCK_IND)
AWARD_ACCEPT_AMOUNT	Accepted amount for the financial aid fund that was accepted by students.	NUMBER	RPRATRM	RPRATRM_ACCEPT_AMT
AWARD_ACCEPT_DATE	Date that the award was accepted.	DATE	RPRATRM	RPRATRM_ACCEPT_DATE
AWARD_ACCEPT_IND	Indicates whether the person accepted this financial aid award.	VARCHAR2(63)	RTVAWST	RTVAWST_ACCEPT_IND
AWARD_AUTHORIZE_AMOUNT	Authorized amount for the financial aid fund for the person.	NUMBER	RPRATRM	RPRATRM_AUTHORIZE_AMT
AWARD_AUTHORIZE_DATE	Date of the award authorization.	DATE	RPRATRM	RPRATRM_AUTHORIZE_DATE
AWARD_CANCEL_AMOUNT	Canceled amount for the financial aid fund for the person.	NUMBER	RPRATRM	RPRATRM_CANCEL_AMT
AWARD_CANCEL_DATE	Date that the award was cancelled.	DATE	RPRATRM	RPRATRM_CANCEL_DATE
AWARD_CANCEL_IND	Indicates whether this financial aid award was canceled.	VARCHAR2(63)	RTVAWST	RTVAWST_CANCEL_IND
AWARD_DECLINE_AMOUNT	Declined amount for the financial aid award for the person.	NUMBER	RPRATRM	RPRATRM_DECLINE_AMT
AWARD_DECLINE_DATE	Date that the award was declined.	DATE	RPRATRM	RPRATRM_DECLINE_DATE
AWARD_DECLINE_IND	Indicates whether this financial aid award was declined.	VARCHAR2(63)	RTVAWST	RTVAWST_DECLINE_IND
AWARD_LOAD_MISMATCH_IND	Indicates that the package load does not match any of the disbursement load indicators.	VARCHAR2(63)	FUNCTION	F_GET_PCKG_LOAD_IND
AWARD_LOCKED	Academic period based lock code.	VARCHAR2(63)	RPRATRM	RPRATRM_LOCK_IND
AWARD_LOCKED_DESC	Award locked description.	VARCHAR2(255)	CALCULATION	DECODE(RPRATRM_LOCK_IND)
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_EXPIRATION_DATE	Date that the memo will be cancelled.	DATE	RPRATRM	RPRATRM_MEMO_DATE
AWARD_OFFER_AMOUNT	Current offered amount for the financial aid award for the person.	NUMBER	RPRATRM	RPRATRM_OFFER_AMT
AWARD_OFFER_DATE	Date that the current award was offered.	DATE	RPRATRM	RPRATRM_OFFER_DATE
AWARD_OFFER_IND	Indicates whether this financial aid award was offered.	VARCHAR2(63)	RTVAWST	RTVAWST_OFFER_IND
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	Date that the original offer of the award was made.	DATE	RPRATRM	RPRATRM_ORIG_OFFER_DATE
AWARD_PAID_AMOUNT	Paid or disbursed amount for the financial aid award for the person.	NUMBER	RPRATRM	RPRATRM_PAID_AMT
AWARD_PAID_DATE	Date that the award was paid.	DATE	RPRATRM	RPRATRM_PAID_DATE
AWARD_STATUS	Current status for the financial aid award.	VARCHAR2(63)	RPRAWRD	RPRAWRD_AWST_CODE
AWARD_STATUS_DATE	Date that the financial aid award status was changed.	DATE	RPRAWRD	RPRAWRD_AWST_DATE
AWARD_STATUS_DESC	Description for the financial aid status.	VARCHAR2(255)	RTVAWST	RTVAWST_DESC
CALC_STUDENT_ADJ_CREDITS	Calculates and displays the student's adjusted credits for the academic period.	NUMBER	FUNCTION	ROKMISC.F_CALC_STUD_ADJ_HRS
CALC_STUDENT_BILLING_HOURS	Calculates and displays the student's billing hours for the academic period.	NUMBER	FUNCTION	ROKMISC.F_CALC_STUD_BILL_HRS
DISBURSEMENT_FINALIZE_IND	Indicates whether all disbursements have been made within the academic period.	VARCHAR2(63)	RPRATRM	RPRATRM_DISB_FINAL_IND
FEDERAL_FUND_ID	Federal fund associated with the fund code.	VARCHAR2(63)	RFRBASE	RFRBASE_FED_FUND_ID
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
FUND	Financial Aid Fund code to be associated with information in this record.	VARCHAR2(63)	RPRATRM	RPRATRM_FUND_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	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_SOURCE	Fund source code to be associated with the fund code.	VARCHAR2(63)	RFRBASE	RFRBASE_FSRC_CODE
FUND_SOURCE_DESC	Describes the fund source code and identifies what it represents.	VARCHAR2(255)	RTVFSRC	RTVFSRC_DESC
FUND_TITLE	Full title of the financial aid fund code.	VARCHAR2(255)	RFRBASE	RFRBASE_FUND_TITLE
FUND_TYPE	Code that classifies a fiscal entity.	VARCHAR2(63)	RFRBASE	RFRBASE_FTYP_CODE
FUND_TYPE_DESC	Fund type code description or title.	VARCHAR2(255)	RTVFTYP	RTVFTYP_DESC
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)
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)
ID	Person's or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA
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	Indicates if the Pell award validation rule has been overridden for the ACG or SMART grant award.	VARCHAR2(63)	RPRAWRD	RPRAWRD_OVERRIDE_NO_PELL
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	Source of the enrollment option description.	VARCHAR2(255)	CALCULATION	DECODE(RPRATRM_PELL_AWRD_LOAD_OPT)
PERCENT_DISTRIBUTION_ACAD_PER	Distribution of the award over the academic periods associated with the record.	NUMBER	RPRATRM	RPRATRM_DIST_PCT
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RPRATRM	RPRATRM_PIDM
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	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	CIP override description.	VARCHAR2(255)	FUNCTION	ROKODSF.F_GET_CIPC_DESC
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
STUDENT_LOAN_OVERRIDE	Indicates which validation tests Packaging/Disbursment 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.	VARCHAR2(255)	CALCULATION	DECODE(RPRATRM_NSLDS_OVRD_IND)
SYSTEM	Specifies whether the award was system or manually generated.	VARCHAR2(63)	RPRAWRD	RPRAWRD_SYS_IND
SYSTEM_DESC	System description.	VARCHAR2(255)	CALCULATION	DECODE(RPRAWRD_SYS_IND)
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	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)	CALCULATION	DECODE(RPRATRM_PCKG_LOAD_IND)
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
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.	VARCHAR2(255)	CALCULATION	DECODE(RPRAWRD_UNMET_NEED_OVRDE_IND)
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	RPRATRM	RPRATRM_USER_ID

Ver: 8.1