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