| Target Column | 
Business Name | 
Business Definition | 
Database Data Type | 
Source Name | 
Source Column | 
| 
ACTIVITY_DATE
 | 
Activity Date 
 | 
Date record was inserted or updated.
 | 
DATE
 | 
 NA
 
 | 
 SYSDATE
 
 | 
| 
ADMINISTRATIVE_GROUP
 | 
Administrative Group 
 | 
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
 | 
VARCHAR2(255)
 | 
 NA
 
 | 
 NA
 
 | 
| 
CERTIFICATION1
 | 
Certification 1 
 | 
4 character code identifying the certification.
 | 
VARCHAR2(63)
 | 
 PPRCERT
 
 | 
 PPRCERT_CERT_CODE
 
 | 
| 
CERTIFICATION2
 | 
Certification 2 
 | 
4 character code identifying the certification.
 | 
VARCHAR2(63)
 | 
 PPRCERT
 
 | 
 PPRCERT_CERT_CODE
 
 | 
| 
CERTIFICATION3
 | 
Certification 3 
 | 
4 character code identifying the certification.
 | 
VARCHAR2(63)
 | 
 PPRCERT
 
 | 
 PPRCERT_CERT_CODE
 
 | 
| 
CERTIFICATION_DATE1
 | 
Certification Date 1 
 | 
Date the certification was obtained.
 | 
DATE
 | 
 PPRCERT
 
 | 
 PPRCERT_CERT_DATE
 
 | 
| 
CERTIFICATION_DATE2
 | 
Certification Date 2 
 | 
Date the certification was obtained.
 | 
DATE
 | 
 PPRCERT
 
 | 
 PPRCERT_CERT_DATE
 
 | 
| 
CERTIFICATION_DATE3
 | 
Certification Date 3 
 | 
Date the certification was obtained.
 | 
DATE
 | 
 PPRCERT
 
 | 
 PPRCERT_CERT_DATE
 
 | 
| 
CERTIFICATION_DESC1
 | 
Certification Description 1 
 | 
Certification description.
 | 
VARCHAR2(255)
 | 
 FUNCTION
 
 | 
 GOKODSF.F_GET_DESC
 
 | 
| 
CERTIFICATION_DESC2
 | 
Certification Description 2 
 | 
Certification description.
 | 
VARCHAR2(255)
 | 
 FUNCTION
 
 | 
 GOKODSF.F_GET_DESC
 
 | 
| 
CERTIFICATION_DESC3
 | 
Certification Description 3 
 | 
Certification description.
 | 
VARCHAR2(255)
 | 
 FUNCTION
 
 | 
 GOKODSF.F_GET_DESC
 
 | 
| 
CERTIFICATION_EXPIRE_DATE1
 | 
Certification Expire Date 1 
 | 
Date the certification expires.
 | 
DATE
 | 
 PPRCERT
 
 | 
 PPRCERT_EXPIRE_DATE
 
 | 
| 
CERTIFICATION_EXPIRE_DATE2
 | 
Certification Expire Date 2 
 | 
Date the certification expires.
 | 
DATE
 | 
 PPRCERT
 
 | 
 PPRCERT_EXPIRE_DATE
 
 | 
| 
CERTIFICATION_EXPIRE_DATE3
 | 
Certification Expire Date 3 
 | 
Date the certification expires.
 | 
DATE
 | 
 PPRCERT
 
 | 
 PPRCERT_EXPIRE_DATE
 
 | 
| 
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
 
 | 
| 
NEXT_CERTIFICATION_DATE1
 | 
Next Certification Date 1 
 | 
Date on which the employee is scheduled to be re-certified.
 | 
DATE
 | 
 PPRCERT
 
 | 
 PPRCERT_NEXT_CERT_DATE
 
 | 
| 
NEXT_CERTIFICATION_DATE2
 | 
Next Certification Date 2 
 | 
Date on which the employee is scheduled to be re-certified.
 | 
DATE
 | 
 PPRCERT
 
 | 
 PPRCERT_NEXT_CERT_DATE
 
 | 
| 
NEXT_CERTIFICATION_DATE3
 | 
Next Certification Date 3 
 | 
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
 
 |