Target Column	Business Definition	Database Data Type	Source Name	Source Column
APPLICATION_DATE	Application submission date.	DATE	PARAPST	PARAPST_APPL_DATE
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PARAPST	PARAPST_PIDM
POSITION_APPLIED_FOR	Position number associated with this applicant entry.	VARCHAR2(6)	PARAPST	PARAPST_POSN
POSITION_APPLIED_FOR_TITLE	Title or description of a position to which a candidate has applied.	VARCHAR2(255)	NBBPOSN	NBBPOSN_TITLE
POSITION_CLASS	Position class associated with the requisition to which this applicant has applied. Organizes the job classifications for the institution and holds attributes that control title, employee class, eel code and wage and salary data. Also, the primary organizer for the design and maintenance of the position definition. These attributes are inherited when the employee is assigned to the position.	VARCHAR2(5)	PARAPST	PARAPST_PCLS_CODE
POSITION_CLASS_DESC	Position class description or title. Organizes the job classifications for the institution and holds attributes that control title, employee class, eel code and wage and salary data. Also, the primary organizer for the design and maintenance of the position definition. These attributes are inherited when the employee is assigned to the position.	VARCHAR2(255)	FUNCTION	GOKODSF.F_GET_DESC
REQUISITION_NUMBER	Requisition number to which this candidate has applied.	VARCHAR2(10)	PARAPST	PARAPST_REQ_NO
SEQUENCE_NUMBER	Sequence number given to each application.	VARCHAR2(3)	PARAPST	PARAPST_SEQ_NO
STATUS	Status of applicant.	VARCHAR2(2)	PARAPST	PARAPST_APPS_CODE
STATUS_COMMENT	Free form comment regarding this applicant status entry.	VARCHAR2(4000)	PARAPST	PARAPST_COMMENT
STATUS_DATE	Date the applicant status was entered.	DATE	PARAPST	PARAPST_APPS_DATE
STATUS_DESC	Status description.	VARCHAR2(30)	FUNCTION	GOKODSF.F_GET_DESC
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA

Ver: