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(63)
|
RPRARSC
|
RPRARSC_TERM_CODE
|
NO
|
NO
|
ACADEMIC_PERIOD_DESC
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
NO
|
NO
|
ACTIVITY_DATE
|
Date record was inserted or updated.
|
DATE
|
RPRARSC
|
RPRARSC_ACTIVITY_DATE
|
NO
|
NO
|
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
AID_YEAR
|
Represents a financial aid year. Aid years may follow the academic year or the fiscal year or another variation.
|
VARCHAR2(63)
|
RPRARSC
|
RPRARSC_AIDY_CODE
|
NO
|
NO
|
AID_YEAR_DESC
|
Financial aid year name.
|
VARCHAR2(255)
|
ROBINST
|
ROBINST_AIDY_DESC
|
NO
|
NO
|
APPLICANT_RESOURCE
|
Code defining a financial aid resource.
|
VARCHAR2(63)
|
RPRARSC
|
RPRARSC_ARSC_CODE
|
NO
|
NO
|
APPLICANT_RESOURCE_DESC
|
Description of the financial aid resource in this record.
|
VARCHAR2(255)
|
RPRARSC RTVARSC
|
RPRARSC_RESOURCE_DESC RTVARSC_ARSC_DESC
|
NO NO
|
NO
|
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
|
NO
|
NO
|
MULTI_SOURCE
|
The institution value for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
The institution description for the record when the optional multi-institution facility feature has been installed and applied for this table/column.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
NAME
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
RPRARSC
|
RPRARSC_PIDM
|
NO
|
NO
|
PROCESS_GROUP
|
The institution value of the process-oriented identifier for the record used to determine access authorization to this record.
|
VARCHAR2(255)
|
NA
|
NA
|
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(63)
|
RPRARSC
|
RPRARSC_TYPE_CODE
|
NO
|
NO
|
RESOURCE_TYPE_DESC
|
Resource type description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RPRARSC_TYPE_CODE)
|
NO
|
NO
|
USER_ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(63)
|
RPRARSC
|
RPRARSC_USER_ID
|
NO
|
NO
|