Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACADEMIC_PERIOD	Academic Period	Academic period associated with the applicant's resources.	VARCHAR2(6)		RPRARSC	RPRARSC_TERM_CODE
ACADEMIC_PERIOD_DESC	Academic Period Description	Academic period description.	VARCHAR2(30)		STVTERM	STVTERM_DESC
ACTIVITY_DATE	Activity Date	Date record was inserted or updated	DATE		RPRARSC	RPRARSC_ACTIVITY_DATE
AID_YEAR	Financial Aid Year	Aid year associated with this record. For example, aid year 0304 (2003 to 2004) or aid year 0405 (2004 to 2005).	VARCHAR2(4)		RPRARSC	RPRARSC_AIDY_CODE
AID_YEAR_DESC	Financial Aid Year Description	Financial aid year name.	VARCHAR2(30)		ROBINST	ROBINST_AIDY_DESC
APPLICANT_RESOURCE	Applicant Resource	Code defining a financial aid resource.	VARCHAR2(6)		RPRARSC	RPRARSC_ARSC_CODE
APPLICANT_RESOURCE_DESC	Applicant Resource Description	Description of the financial aid resource in this record.	VARCHAR2(50)		RPRARSC RTVARSC	RPRARSC_RESOURCE_DESC RTVARSC_ARSC_DESC
CURRENT_DATE	Current Date	The current date for which this data was extracted.	DATE		NA	SYSDATE
DOMAIN_VALUE	Domain Value	Domain column for future use, not currently populated.	VARCHAR2(6)		NA	NA
MIF_DESC	MIF Description	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
MIF_VALUE	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
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER(8)		RPRARSC	RPRARSC_PIDM
RESOURCE_ACTUAL_AMOUNT	Resource Actual Amount	Actual amount of the resource for the student in this record.	NUMBER(11,2)		RPRARSC	RPRARSC_ACTUAL_AMT
RESOURCE_ESTIMATED_AMOUNT	Resource Estimated Amount	Estimated amount of the resource if the actual amount is not available.	NUMBER(11,2)		RPRARSC	RPRARSC_EST_AMT
RESOURCE_NUMBER	Resource Number	System generated number.	NUMBER(2)		RPRARSC	RPRARSC_RESOURCE_NUMBER
RESOURCE_TYPE	Resource Type	Type code associated with the resource code in this record.	VARCHAR2(1)		RPRARSC	RPRARSC_TYPE_CODE
RESOURCE_TYPE_DESC	Resource Type Description	Resource type description.	VARCHAR2(10)		CALCULATION	DECODE(RPRARSC_TYPE_CODE)
USER_ID	User ID	Unique identification code of the user who entered or last touched the transaction.	VARCHAR2(30)		RPRARSC	RPRARSC_USER_ID
ZONE_VALUE	Zone Value	Zone column for future use, not currently populated.	VARCHAR2(6)		NA	NA

Ver: