Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
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)
|
RPRARSC
|
RPRARSC_TERM_CODE
|
NO
|
NO
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(30)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
ACTIVITY_DATE
|
Date record was inserted or updated.
|
DATE
|
RPRARSC
|
RPRARSC_ACTIVITY_DATE
|
NO
|
NO
|
AID_YEAR
|
Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.
|
VARCHAR2(4)
|
RPRARSC
|
RPRARSC_AIDY_CODE
|
NO
|
NO
|
AID_YEAR_DESC
|
Financial aid year name.
|
VARCHAR2(30)
|
ROBINST
|
ROBINST_AIDY_DESC
|
NO
|
NO
|
APPLICANT_RESOURCE
|
Code defining a financial aid resource.
|
VARCHAR2(6)
|
RPRARSC
|
RPRARSC_ARSC_CODE
|
NO
|
NO
|
APPLICANT_RESOURCE_DESC
|
Description of the financial aid resource in this record.
|
VARCHAR2(50)
|
RPRARSC RTVARSC
|
RPRARSC_RESOURCE_DESC RTVARSC_ARSC_DESC
|
NO NO
|
NO
|
CURRENT_DATE
|
The current date for which this data was extracted.
|
DATE
|
NA
|
SYSDATE
|
NO
|
NO
|
DOMAIN_VALUE
|
Domain column for future use, not currently populated.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
MIF_DESC
|
The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(30)
|
NA
|
NA
|
NO
|
NO
|
MIF_VALUE
|
The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
RPRARSC
|
RPRARSC_PIDM
|
NO
|
NO
|
RESOURCE_ACTUAL_AMOUNT
|
Actual amount of the resource for the student in this record.
|
NUMBER
|
RPRARSC
|
RPRARSC_ACTUAL_AMT
|
NO
|
NO
|
RESOURCE_ESTIMATED_AMOUNT
|
Estimated amount of the resource if the actual amount is not available.
|
NUMBER
|
RPRARSC
|
RPRARSC_EST_AMT
|
NO
|
NO
|
RESOURCE_NUMBER
|
System generated number.
|
NUMBER
|
RPRARSC
|
RPRARSC_RESOURCE_NUMBER
|
NO
|
NO
|
RESOURCE_TYPE
|
Type code associated with the resource code in this record.
|
VARCHAR2(1)
|
RPRARSC
|
RPRARSC_TYPE_CODE
|
NO
|
NO
|
RESOURCE_TYPE_DESC
|
Resource type description.
|
VARCHAR2(10)
|
CALCULATION
|
DECODE(RPRARSC_TYPE_CODE)
|
NO
|
NO
|
USER_ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(30)
|
RPRARSC
|
RPRARSC_USER_ID
|
NO
|
NO
|
ZONE_VALUE
|
Zone column for future use, not currently populated.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|