Target Column	Business Definition	Database Data Type	Source Name	Source Column
ACADEMIC_PERIOD	Academic period associated with the applicant's resources.	VARCHAR2(63)	RPRARSC	RPRARSC_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic period description.	VARCHAR2(255)	STVTERM	STVTERM_DESC
ACTIVITY_DATE	Date record was inserted or updated	DATE	RPRARSC	RPRARSC_ACTIVITY_DATE
ADMINISTRATIVE_GROUP	The institution value of the organization-oriented identifier for the record used to determine access authorization to this record.	VARCHAR2(255)	NA	NA
AID_YEAR	Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).	VARCHAR2(63)	RPRARSC	RPRARSC_AIDY_CODE
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(255)	ROBINST	ROBINST_AIDY_DESC
APPLICANT_RESOURCE	Code defining a financial aid resource.	VARCHAR2(63)	RPRARSC	RPRARSC_ARSC_CODE
APPLICANT_RESOURCE_DESC	Description of the financial aid resource in this record.	VARCHAR2(255)	RPRARSC RTVARSC	RPRARSC_RESOURCE_DESC RTVARSC_ARSC_DESC
ID	Person's or organization's current identification number.	VARCHAR2(63)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
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	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 of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)	FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	RPRARSC	RPRARSC_PIDM
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	Actual amount of the resource for the student in this record.	NUMBER	RPRARSC	RPRARSC_ACTUAL_AMT
RESOURCE_ESTIMATED_AMOUNT	Estimated amount of the resource if the actual amount is not available.	NUMBER	RPRARSC	RPRARSC_EST_AMT
RESOURCE_NUMBER	System generated number.	NUMBER	RPRARSC	RPRARSC_RESOURCE_NUMBER
RESOURCE_TYPE	Type code associated with the resource code in this record.	VARCHAR2(63)	RPRARSC	RPRARSC_TYPE_CODE
RESOURCE_TYPE_DESC	Resource type description.	VARCHAR2(255)	CALCULATION	DECODE(RPRARSC_TYPE_CODE)
USER_ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(63)	RPRARSC	RPRARSC_USER_ID

Ver: 8.1