Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
ACTIVITY_DATE	Date record was inserted or updated.	DATE	NA	SYSDATE	NO	NO
ADMINISTRATIVE_GROUP	Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
MULTI_SOURCE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)	NA	NA	NO	NO
MULTI_SOURCE_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)	NA	NA	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PARAPST	PARAPST_PIDM	NO	NO
PROCESS_GROUP	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)	NA	NA	NO	NO
REQUISITION_NUMBER	Requisition number to which this candidate has applied.	VARCHAR2(10)	PARAPST	PARAPST_REQ_NO	NO	NO
SEQUENCE_NUMBER1	Sequence number given to each application.	VARCHAR2(3)	PARAPST	PARAPST_SEQ_NO	NO	NO
SEQUENCE_NUMBER2	Sequence number given to each application.	VARCHAR2(3)	PARAPST	PARAPST_SEQ_NO	NO	NO
SEQUENCE_NUMBER3	Sequence number given to each application.	VARCHAR2(3)	PARAPST	PARAPST_SEQ_NO	NO	NO
SEQUENCE_NUMBER4	Sequence number given to each application.	VARCHAR2(3)	PARAPST	PARAPST_SEQ_NO	NO	NO
SEQUENCE_NUMBER5	Sequence number given to each application.	VARCHAR2(3)	PARAPST	PARAPST_SEQ_NO	NO	NO
STATUS1	Status of applicant.	VARCHAR2(63)	PARAPST	PARAPST_APPS_CODE	NO	NO
STATUS2	Status of applicant.	VARCHAR2(63)	PARAPST	PARAPST_APPS_CODE	NO	NO
STATUS3	Status of applicant.	VARCHAR2(63)	PARAPST	PARAPST_APPS_CODE	NO	NO
STATUS4	Status of applicant.	VARCHAR2(63)	PARAPST	PARAPST_APPS_CODE	NO	NO
STATUS5	Status of applicant.	VARCHAR2(63)	PARAPST	PARAPST_APPS_CODE	NO	NO
STATUS_COMMENT1	Free form comment regarding this applicant status entry.	VARCHAR2(4000)	PARAPST	PARAPST_COMMENT	NO	NO
STATUS_COMMENT2	Free form comment regarding this applicant status entry.	VARCHAR2(4000)	PARAPST	PARAPST_COMMENT	NO	NO
STATUS_COMMENT3	Free form comment regarding this applicant status entry.	VARCHAR2(4000)	PARAPST	PARAPST_COMMENT	NO	NO
STATUS_COMMENT4	Free form comment regarding this applicant status entry.	VARCHAR2(4000)	PARAPST	PARAPST_COMMENT	NO	NO
STATUS_COMMENT5	Free form comment regarding this applicant status entry.	VARCHAR2(4000)	PARAPST	PARAPST_COMMENT	NO	NO
STATUS_DATE1	Date the applicant status was entered.	DATE	PARAPST	PARAPST_APPS_DATE	NO	NO
STATUS_DATE2	Date the applicant status was entered.	DATE	PARAPST	PARAPST_APPS_DATE	NO	NO
STATUS_DATE3	Date the applicant status was entered.	DATE	PARAPST	PARAPST_APPS_DATE	NO	NO
STATUS_DATE4	Date the applicant status was entered.	DATE	PARAPST	PARAPST_APPS_DATE	NO	NO
STATUS_DATE5	Date the applicant status was entered.	DATE	PARAPST	PARAPST_APPS_DATE	NO	NO
STATUS_DESC1	Status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
STATUS_DESC2	Status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
STATUS_DESC3	Status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
STATUS_DESC4	Status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
STATUS_DESC5	Status description.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO

Ver: 9.2