| Target Column | 
Business Name | 
Business Definition | 
Database Data Type | 
Source Name | 
Source Column | 
| 
ADMINISTRATIVE_GROUP
 | 
Administrative Group 
 | 
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
 | 
VARCHAR2(255)
 | 
 NA
 
 | 
 NA
 
 | 
| 
CERTIFICATION
 | 
Certification 
 | 
4 character code identifying the certification.
 | 
VARCHAR2(63)
 | 
 PPRCERT
 
 | 
 PPRCERT_CERT_CODE
 
 | 
| 
CERTIFICATION_DATE
 | 
Certification Date 
 | 
Date the certification was obtained.
 | 
DATE
 | 
 PPRCERT
 
 | 
 PPRCERT_CERT_DATE
 
 | 
| 
CERTIFICATION_DESC
 | 
Certification Description 
 | 
Certification description.
 | 
VARCHAR2(255)
 | 
 FUNCTION
 
 | 
 GOKODSF.F_GET_DESC
 
 | 
| 
CERTIFICATION_EXPIRE_DATE
 | 
Certification Expire Date 
 | 
Date the certification expires.
 | 
DATE
 | 
 PPRCERT
 
 | 
 PPRCERT_EXPIRE_DATE
 
 | 
| 
CERTIFICATION_NUMBER
 | 
Certification Number 
 | 
Number of the certification if applicable.
 | 
VARCHAR2(20)
 | 
 PPRCERT
 
 | 
 PPRCERT_CERT_NO
 
 | 
| 
COMMENTS
 | 
Comments 
 | 
Free form comment on the certificates recorded for a person.
 | 
VARCHAR2(2000)
 | 
 PPRCERT
 
 | 
 PPRCERT_COMMENTS
 
 | 
| 
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 
 | 
Institution value for the record when the optional multi-institution facility feature has been applied.
 | 
VARCHAR2(63)
 | 
 NA
 
 | 
 NA
 
 | 
| 
MULTI_SOURCE_DESC
 | 
Multi Source Description 
 | 
Institution description when the optional multi-institution facility feature has been applied.
 | 
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
 
 | 
| 
NEXT_CERTIFICATION_DATE
 | 
Next Certification Date 
 | 
Date on which the employee is scheduled to be re-certified.
 | 
DATE
 | 
 PPRCERT
 
 | 
 PPRCERT_NEXT_CERT_DATE
 
 | 
| 
PERSON_UID
 | 
Person UID 
 | 
System generated, unique, internal identification number assigned to this person.
 | 
NUMBER
 | 
 PPRCERT
 
 | 
 PPRCERT_PIDM
 
 | 
| 
PROCESS_GROUP
 | 
Process Group 
 | 
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
 | 
VARCHAR2(255)
 | 
 NA
 
 | 
 NA
 
 |