Target Column	Business Name	Business Definition	Database Data Type	Domain Value	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(8)		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(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)		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(30)		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: