Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
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
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(30)
|
STVTERM
|
STVTERM_DESC
|
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
|
Year in college override description.
|
VARCHAR2(15)
|
|
|
ACTIVITY_DATE
|
Date record was inserted or updated.
|
DATE
|
RPRATRM
|
RPRATRM_ACTIVITY_DATE
|
AID_ENROLLMENT_PERIOD
|
|
VARCHAR2(15)
|
|
|
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
|
AID_PERIOD_DESC
|
Financial Aid period description.
|
VARCHAR2(30)
|
RTVAPRD
|
RTVAPRD_DESC
|
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
|
AID_YEAR_DESC
|
Financial aid year name.
|
VARCHAR2(30)
|
ROBINST
|
ROBINST_AIDY_DESC
|
ANNUAL_AWARD_LOCKED
|
Aid year based lock code.
|
VARCHAR2(1)
|
RPRAWRD
|
RPRAWRD_LOCK_IND
|
ANNUAL_AWARD_LOCKED_DESC
|
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
|
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(1)
|
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(1)
|
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(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
|
Academic period based lock code.
|
VARCHAR2(1)
|
RPRATRM
|
RPRATRM_LOCK_IND
|
AWARD_LOCKED_DESC
|
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
|
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(1)
|
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(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
|
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
|
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
|
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
|
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
|
Source of the enrollment option when calculating a PELL award.
|
VARCHAR2(1)
|
RPRATRM
|
RPRATRM_PELL_AWRD_LOAD_OPT
|
PELL_AWARD_ENROLLMENT_OPT_DESC
|
Source of the enrollment option description.
|
VARCHAR2(25)
|
|
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
RPRATRM
|
RPRATRM_PIDM
|
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
|
PROGRAM_CLASS_OVR_DESC
|
CIP override description.
|
VARCHAR2(100)
|
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(1)
|
RPRAWRD
|
RPRAWRD_REPLACE_TFC_OVRDE_IND
|
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
|
Academic period description.
|
VARCHAR2(30)
|
STVTERM
|
STVTERM_DESC
|
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.
|
VARCHAR2(25)
|
|
|
SYSTEM
|
Specifies whether the award was system or manually generated.
|
VARCHAR2(1)
|
RPRAWRD
|
RPRAWRD_SYS_IND
|
SYSTEM_DESC
|
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
|
RPRATRM
|
RPRATRM_DIST_PCT
|
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
|
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
|
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
|
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.
|
VARCHAR2(4)
|
|
|
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
|