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

Ver: 8.1