Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
APPLICATION_DATE	Application submission date.	DATE	PARAPIN	PARAPIN_APPL_DATE	NO	NO
COMMENTS	Free form comment regarding this applicant.	VARCHAR2(4000)	PARAPIN	PARAPIN_COMMENT	NO	NO
CURRENT_DATE	System current date (sysdate) or date the data was extracted.	DATE	NA	SYSDATE	NO	NO
DOMAIN_VALUE	Organization-oriented identifier for the record used to determine access authorization. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO
INTERVIEWER_NAME	Current name of interviewer in the format of last, first middle name.	VARCHAR2(255)	FUNCTION	F_FORMAT_NAME	NO	NO
INTERVIEWER_UID	Employee identification number of the individual who conducted the interview.	NUMBER	PARAPIN	PARAPIN_INTERVIEW_PIDM	NO	NO
INTERVIEW_DATE	Date of interview.	DATE	PARAPIN	PARAPIN_INTERVIEW_DATE	NO	NO
INTERVIEW_TIME	Time of interview.	VARCHAR2(8)	PARAPIN	PARAPIN_INTERVIEW_TIME	NO	NO
MIF_DESC	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(30)	NA	NA	NO	NO
MIF_VALUE	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(6)	NA	NA	NO	NO
PERSON_UID	System generated, unique, internal identification number assigned to this person.	NUMBER	PARAPIN	PARAPIN_PIDM	NO	NO
POSITION_APPLIED_FOR	Position number associated with this applicant entry.	VARCHAR2(6)	PARAPIN	PARAPIN_POSN	NO	NO
POSITION_APPLIED_FOR_TITLE	Title or description of a position to which a candidate has applied.	VARCHAR2(30)	NBBPOSN	NBBPOSN_TITLE	NO	NO
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)	PARAPIN	PARAPIN_PCLS_CODE	NO	NO
POSITION_CLASS_DESC	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(30)	FUNCTION	GOKODSF.F_GET_DESC	NO	NO
REQUISITION_NUMBER	Requisition number of the position associated with this applicant entry.	VARCHAR2(10)	PARAPIN	PARAPIN_REQ_NO	NO	NO
ZONE_VALUE	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)	NA	NA	NO	NO

Ver: