Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
APPLICATION_DATE		Application submission date.	DATE		PARAPIN	PARAPIN_APPL_DATE
COMMENTS		Free form comment regarding this applicant.	VARCHAR2(4000)		PARAPIN	PARAPIN_COMMENT
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
INTERVIEWER_NAME		Current name of interviewer in the format of last, first middle name.	VARCHAR2(255)		FUNCTION	F_FORMAT_NAME
INTERVIEWER_UID		Employee identification number of the individual who conducted the interview.	NUMBER(8)		PARAPIN	PARAPIN_INTERVIEW_PIDM
INTERVIEW_DATE		Date of interview.	DATE		PARAPIN	PARAPIN_INTERVIEW_DATE
INTERVIEW_TIME		Time of interview.	VARCHAR2(8)		PARAPIN	PARAPIN_INTERVIEW_TIME
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(8)		PARAPIN	PARAPIN_PIDM
POSITION_APPLIED_FOR		Position number associated with this applicant entry.	VARCHAR2(6)		PARAPIN	PARAPIN_POSN
POSITION_APPLIED_FOR_TITLE		Title or description of a position to which a candidate has applied.	VARCHAR2(30)		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)		PARAPIN	PARAPIN_PCLS_CODE
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
REQUISITION_NUMBER		Requisition number of the position associated with this applicant entry.	VARCHAR2(10)		PARAPIN	PARAPIN_REQ_NO
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: