Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	Most current date record was created or updated.	DATE	RHRCOMM	RHRCOMM_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)	RHRCOMM	RHRCOMM_AIDY_CODE	NO	NO
AID_YEAR_DESC	Financial aid year name.	VARCHAR2(30)	ROBINST	ROBINST_AIDY_DESC	NO	NO
APPLICANT_COMMENT	Comments associated with the student's record.	VARCHAR2(4000)	RHRCOMM	RHRCOMM_COMMENT	NO	NO
COMMENT_CATEGORY	Category code for applicant comments.	VARCHAR2(7)	RHRCOMM	RHRCOMM_CATEGORY_CODE	NO	NO
COMMENT_CATEGORY_DESC	Comment category description.	VARCHAR2(200)	RTVCCOM	RTVCCOM_DESC	NO	NO
COMMENT_SEQUENCE_NUMBER	System-generated sequence number assigned to the comment in this record.	NUMBER	RHRCOMM	RHRCOMM_SEQNO	NO	NO
COMMENT_USER_ID	User ID of the person who inserted or last updated this record.	VARCHAR2(30)	RHRCOMM	RHRCOMM_USER_ID	NO	NO
CURRENT_DATE	System current date (sysdate) or date the 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
ORIGINAL_COMMENT_DATE	Date that the original comment was entered on the student's record.	DATE	RHRCOMM	RHRCOMM_ORIG_DATE	NO	NO
PERSON_UID	System generated unique internal identification number assigned to this person.	NUMBER	RHRCOMM	RHRCOMM_PIDM	NO	NO
ZONE_VALUE	Zone column for future use, not currently populated.	VARCHAR2(6)	NA	NA	NO	NO

Ver: