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

Ver: 8.1