| Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
|
ACADEMIC_PERIOD
|
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
|
|
ACADEMIC_PERIOD_DESC
|
Academic Period Description
|
Academic period description.
|
VARCHAR2(255)
|
STVTERM
|
STVTERM_DESC
|
|
ACTIVITY_DATE
|
Activity Date
|
Date record was inserted or updated.
|
DATE
|
RPRARSC
|
RPRARSC_ACTIVITY_DATE
|
|
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
|
AID_YEAR
|
Financial 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
|
|
AID_YEAR_DESC
|
Financial Aid Year Description
|
Financial aid year name.
|
VARCHAR2(255)
|
ROBINST
|
ROBINST_AIDY_DESC
|
|
APPLICANT_RESOURCE
|
Applicant Resource
|
Code defining a financial aid resource.
|
VARCHAR2(63)
|
RPRARSC
|
RPRARSC_ARSC_CODE
|
|
APPLICANT_RESOURCE_DESC
|
Applicant Resource Description
|
Description of the financial aid resource in this record.
|
VARCHAR2(255)
|
RPRARSC RTVARSC
|
RPRARSC_RESOURCE_DESC RTVARSC_ARSC_DESC
|
|
ID
|
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
|
|
MULTI_SOURCE
|
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
|
|
MULTI_SOURCE_DESC
|
Multi Source Description
|
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
|
|
NAME
|
NAME
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
|
PERSON_UID
|
Person UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
RPRARSC
|
RPRARSC_PIDM
|
|
PROCESS_GROUP
|
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
|
|
RESOURCE_ACTUAL_AMOUNT
|
Resource Actual Amount
|
Actual amount of the resource for the student in this record.
|
NUMBER
|
RPRARSC
|
RPRARSC_ACTUAL_AMT
|
|
RESOURCE_ESTIMATED_AMOUNT
|
Resource Estimated Amount
|
Estimated amount of the resource if the actual amount is not available.
|
NUMBER
|
RPRARSC
|
RPRARSC_EST_AMT
|
|
RESOURCE_NUMBER
|
Resource Number
|
System generated number.
|
NUMBER
|
RPRARSC
|
RPRARSC_RESOURCE_NUMBER
|
|
RESOURCE_TYPE
|
Resource Type
|
Type code associated with the resource code in this record.
|
VARCHAR2(63)
|
RPRARSC
|
RPRARSC_TYPE_CODE
|
|
RESOURCE_TYPE_DESC
|
Resource Type Description
|
Resource type description.
|
VARCHAR2(255)
|
CALCULATION
|
DECODE(RPRARSC_TYPE_CODE)
|
|
USER_ID
|
User ID
|
Unique identification code of the user who entered or last touched the transaction.
|
VARCHAR2(63)
|
RPRARSC
|
RPRARSC_USER_ID
|