| Target Column | 
Business Name | 
Business Definition | 
Database Data Type | 
Domain Value | 
Source Name | 
Source Column | 
| 
ACTIVITY_DATE
 | 
Activity Date 
 | 
Date record was inserted or updated
 | 
DATE
 | 
 
 | 
 NA
 
 | 
 SYSDATE
 
 | 
| 
ADMINISTRATIVE_GROUP
 | 
Administrative Group 
 | 
Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.
 | 
VARCHAR2(255)
 | 
 
 | 
 NA
 
 | 
 NA
 
 | 
| 
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
 
 | 
| 
PERSON_UID
 | 
Person UID 
 | 
System generated, unique, internal identification number assigned to this person.
 | 
NUMBER
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_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
 
 | 
| 
REQUISITION_NUMBER
 | 
Requisition Number 
 | 
Requisition number to which this candidate has applied.
 | 
VARCHAR2(10)
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_REQ_NO
 
 | 
| 
SEQUENCE_NUMBER1
 | 
Sequence Number 1 
 | 
Sequence number given to each application.
 | 
VARCHAR2(3)
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_SEQ_NO
 
 | 
| 
SEQUENCE_NUMBER2
 | 
Sequence Number 2 
 | 
Sequence number given to each application.
 | 
VARCHAR2(3)
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_SEQ_NO
 
 | 
| 
SEQUENCE_NUMBER3
 | 
Sequence Number 3 
 | 
Sequence number given to each application.
 | 
VARCHAR2(3)
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_SEQ_NO
 
 | 
| 
SEQUENCE_NUMBER4
 | 
Sequence Number 4 
 | 
Sequence number given to each application.
 | 
VARCHAR2(3)
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_SEQ_NO
 
 | 
| 
SEQUENCE_NUMBER5
 | 
Sequence Number 5 
 | 
Sequence number given to each application.
 | 
VARCHAR2(3)
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_SEQ_NO
 
 | 
| 
STATUS1
 | 
Status 1 
 | 
Status of applicant.
 | 
VARCHAR2(63)
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_APPS_CODE
 
 | 
| 
STATUS2
 | 
Status 2 
 | 
Status of applicant.
 | 
VARCHAR2(63)
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_APPS_CODE
 
 | 
| 
STATUS3
 | 
Status 3 
 | 
Status of applicant.
 | 
VARCHAR2(63)
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_APPS_CODE
 
 | 
| 
STATUS4
 | 
Status 4 
 | 
Status of applicant.
 | 
VARCHAR2(63)
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_APPS_CODE
 
 | 
| 
STATUS5
 | 
Status 5 
 | 
Status of applicant.
 | 
VARCHAR2(63)
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_APPS_CODE
 
 | 
| 
STATUS_COMMENT1
 | 
Status Comment 1 
 | 
Free form comment regarding this applicant status entry.
 | 
VARCHAR2(4000)
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_COMMENT
 
 | 
| 
STATUS_COMMENT2
 | 
Status Comment 2 
 | 
Free form comment regarding this applicant status entry.
 | 
VARCHAR2(4000)
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_COMMENT
 
 | 
| 
STATUS_COMMENT3
 | 
Status Comment 3 
 | 
Free form comment regarding this applicant status entry.
 | 
VARCHAR2(4000)
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_COMMENT
 
 | 
| 
STATUS_COMMENT4
 | 
Status Comment 4 
 | 
Free form comment regarding this applicant status entry.
 | 
VARCHAR2(4000)
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_COMMENT
 
 | 
| 
STATUS_COMMENT5
 | 
Status Comment 5 
 | 
Free form comment regarding this applicant status entry.
 | 
VARCHAR2(4000)
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_COMMENT
 
 | 
| 
STATUS_DATE1
 | 
Status Date 1 
 | 
Date the applicant status was entered.
 | 
DATE
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_APPS_DATE
 
 | 
| 
STATUS_DATE2
 | 
Status Date 2 
 | 
Date the applicant status was entered.
 | 
DATE
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_APPS_DATE
 
 | 
| 
STATUS_DATE3
 | 
Status Date 3 
 | 
Date the applicant status was entered.
 | 
DATE
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_APPS_DATE
 
 | 
| 
STATUS_DATE4
 | 
Status Date 4 
 | 
Date the applicant status was entered.
 | 
DATE
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_APPS_DATE
 
 | 
| 
STATUS_DATE5
 | 
Status Date 5 
 | 
Date the applicant status was entered.
 | 
DATE
 | 
 
 | 
 PARAPST
 
 | 
 PARAPST_APPS_DATE
 
 | 
| 
STATUS_DESC1
 | 
Status Description 1 
 | 
Status description.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 GOKODSF.F_GET_DESC
 
 | 
| 
STATUS_DESC2
 | 
Status Description 2 
 | 
Status description.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 GOKODSF.F_GET_DESC
 
 | 
| 
STATUS_DESC3
 | 
Status Description 3 
 | 
Status description.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 GOKODSF.F_GET_DESC
 
 | 
| 
STATUS_DESC4
 | 
Status Description 4 
 | 
Status description.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 GOKODSF.F_GET_DESC
 
 | 
| 
STATUS_DESC5
 | 
Status Description 5 
 | 
Status description.
 | 
VARCHAR2(255)
 | 
 
 | 
 FUNCTION
 
 | 
 GOKODSF.F_GET_DESC
 
 |