Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD		Academic period associated with information in this record.	VARCHAR2(6)		RPRATRM	RPRATRM_TERM_CODE
ACADEMIC_PERIOD_DESC		Academic period description.	VARCHAR2(30)		STVTERM	STVTERM_DESC
ACADEMIC_YEAR_OVERRIDE	Academic Year Override	Academic year to use for ACG and SMART Grant eligibility.	VARCHAR2(1)		RPRAWRD	RPRAWRD_OVERRIDE_YR_IN_COLL
ACADEMIC_YEAR_OVERRIDE_DESC	Academic Year Override Description	Year in college override description.	VARCHAR2(15)
ACTIVITY_DATE	Activity Date	Date record was inserted or updated.	DATE		RPRATRM	RPRATRM_ACTIVITY_DATE
AID_ENROLLMENT_PERIOD	Financial Aid Enrollment Period		VARCHAR2(15)
AID_PERIOD	Financial Aid Period	Identifies parts of a year that students may be enrolled and receive financial assistance. For example, full year, academic period, etc.	VARCHAR2(6)		RORSTAT	RORSTAT_APRD_CODE
AID_PERIOD_DESC	Financial Aid Period Description	Financial Aid period description.	VARCHAR2(30)		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(4)		RPRATRM	RPRATRM_AIDY_CODE
AID_YEAR_DESC		Financial aid year name.	VARCHAR2(30)		ROBINST	ROBINST_AIDY_DESC
ANNUAL_AWARD_LOCKED	Annual Award Locked	Aid year based lock code.	VARCHAR2(1)		RPRAWRD	RPRAWRD_LOCK_IND
ANNUAL_AWARD_LOCKED_DESC	Annual Award Locked Description	Annual award locked description.	VARCHAR2(55)		CALCULATION	DECODE(RPRAWRD_LOCK_IND)
AWARD_ACCEPT_AMOUNT		Accepted amount for the financial aid fund that was accepted by students.	NUMBER(11, 2)		RPRATRM	RPRATRM_ACCEPT_AMT
AWARD_ACCEPT_DATE	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(1)		RTVAWST	RTVAWST_ACCEPT_IND
AWARD_AUTHORIZE_AMOUNT		Authorized amount for the financial aid fund for the person.	NUMBER(11, 2)		RPRATRM	RPRATRM_AUTHORIZE_AMT
AWARD_AUTHORIZE_DATE	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(11, 2)		RPRATRM	RPRATRM_CANCEL_AMT
AWARD_CANCEL_DATE	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(1)		RTVAWST	RTVAWST_CANCEL_IND
AWARD_DECLINE_AMOUNT		Declined amount for the financial aid award for the person.	NUMBER(11, 2)		RPRATRM	RPRATRM_DECLINE_AMT
AWARD_DECLINE_DATE	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(1)		RTVAWST	RTVAWST_DECLINE_IND
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
AWARD_LOCKED	Award Locked	Academic period based lock code.	VARCHAR2(1)		RPRATRM	RPRATRM_LOCK_IND
AWARD_LOCKED_DESC	Award Locked Description	Award locked description.	VARCHAR2(55)		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(11, 2)		RPRATRM	RPRATRM_MEMO_AMT
AWARD_MEMO_EXPIRATION_DATE	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(11, 2)		RPRATRM	RPRATRM_OFFER_AMT
AWARD_OFFER_DATE	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(1)		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(11,2)		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		Paid or disbursed amount for the financial aid award for the person.	NUMBER(11, 2)		RPRATRM	RPRATRM_PAID_AMT
AWARD_PAID_DATE	Award Paid Date	Date that the award was paid.	DATE		RPRATRM	RPRATRM_PAID_DATE
AWARD_STATUS		Current status for the financial aid award.	VARCHAR2(4)		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(30)		RTVAWST	RTVAWST_DESC
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
CALC_STUDENT_BILLING_HOURS	Calculate Student Billing Hours	Calculates and displays the student's billing hours for the academic period.	NUMBER		FUNCTION	ROKODSF.F_SUM_CALC_STUD_BILL_HRS
CURRENT_DATE		System current date (sysdate) or date the data was extracted.	DATE		NA	SYSDATE
DISBURSEMENT_FINALIZE_IND		Indicates whether all disbursements have been made within the academic period.	VARCHAR2(1)		RPRATRM	RPRATRM_DISB_FINAL_IND
DOMAIN_VALUE		Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)		NA	NA
FEDERAL_LIMIT_OVERRIDE_IND	Federal Limit Override Indicator	Used to override a federal limit on a fund when manually entering the award.	VARCHAR2(1)		RPRAWRD	RPRAWRD_FED_LIMIT_OVRDE_IND
FUND		Financial Aid Fund code to be associated with information in this record.	VARCHAR2(6)		RPRATRM	RPRATRM_FUND_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(1)		RPRAWRD	RPRAWRD_FUND_LIMIT_OVRDE_IND
FUND_TITLE		Full title of the financial aid fund code.	VARCHAR2(30)		RFRBASE	RFRBASE_FUND_TITLE
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
MIF_DESC		Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)		NA	NA
MIF_VALUE		Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)		NA	NA
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(1)		RPRAWRD	RPRAWRD_OVERRIDE_NO_PELL
PELL_AWARD_ENROLLMENT_OPTION	Pell Award Enrollment Option	Source of the enrollment option when calculating a PELL award.	VARCHAR2(1)		RPRATRM	RPRATRM_PELL_AWRD_LOAD_OPT
PELL_AWARD_ENROLLMENT_OPT_DESC	Pell Award Enrollment Option Description	Source of the enrollment option description.	VARCHAR2(25)
PERSON_UID		System generated, unique, internal identification number assigned to this person.	NUMBER(8)		RPRATRM	RPRATRM_PIDM
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(6)		RPRATRM	RPRATRM_CIP_OVERRIDE_CODE
PROGRAM_CLASS_OVR_DESC	Program Classification Over Description	CIP override description.	VARCHAR2(100)		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(1)		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(6)		RORPRDS	RORPRDS_TERM_CODE
STUDENT_ACADEMIC_PERIOD_DESC	Student Academic Period Description	Academic period description.	VARCHAR2(30)		STVTERM	STVTERM_DESC
STUDENT_LOAN_OVERRIDE	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
STUDENT_LOAN_OVERRIDE_DESC	Student Loan Override Description	Student loan override description.	VARCHAR2(25)
SYSTEM	System	Specifies whether the award was system or manually generated.	VARCHAR2(1)		RPRAWRD	RPRAWRD_SYS_IND
SYSTEM_DESC	System Description	System description.	VARCHAR2(6)		CALCULATION	DECODE(RPRAWRD_SYS_IND)
TERM_PERCENT_OF_DISTRIBUTION		Distribution of the award over the academic periods associated with the record.	NUMBER(6, 3)		RPRATRM	RPRATRM_DIST_PCT
TIME_STATUS	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
TIME_STATUS_DESC	Time Status Description	Description of Student's enrollment status at the time of packaging. E.g., three quarter time, half time, full time.	VARCHAR2(20)
TRACKING_REQ_OVERRIDE_IND	Tracking Requirements 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(1)		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(1)		RPRAWRD	RPRAWRD_UNMET_NEED_OVRDE_IND
UNMET_NEED_OVERRIDE_DESC	Unmet Need Override Description	Unmet need override description.	VARCHAR2(4)
USER_ID	User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)		RPRATRM	RPRATRM_USER_ID
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: