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
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

Ver: 9.2