Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ACCEPTING_APPLICANTS_IND		Indicates whether applicants may be added or no new applicants can be added to the requisition.	VARCHAR2(1)		PTRREQS	PTRREQS_ACCEPT_APPL_IND
APPLICATION_DATE		Application submission date.	DATE		PABREQU	PABREQU_APPL_DATE
APPROVAL_DATE		Date the position requisition was approved.	DATE		PABREQU	PABREQU_APPR_DATE
CLOSE_DATE		Date the application for the position is closed.	DATE		PABREQU	PABREQU_CLOSE_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
FULL_OR_PART_TIME		Identifies if the requisition is for a full-time or part-time employment.	VARCHAR2(0)		PTRECLS	PTRECLS_INTERNAL_FT_PT_IND
FULL_OR_PART_TIME_DESC		Employment status description.	VARCHAR2(0)		NA	NA
HIRE_DATE		Projected date of hire for this position.	DATE		PABREQU	PABREQU_HIRE_DATE
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
MINIMUM_DEGREE_LEVEL		Minimum degree level required by the requisition.	VARCHAR2(0)		PARPDEG	PARPDEG_DEGC_CODE
MINIMUM_DEGREE_LEVEL_DESC		Minimum degree level description.	VARCHAR2(0)		NA	NA
OPEN_DATE		Date the application for the position opens.	DATE		PABREQU	PABREQU_OPEN_DATE
POSITION		Position number associated with this requisition.	VARCHAR2(6)		PABREQU	PABREQU_POSN
POSTING_DATE		Date the position is posted.	DATE		PABREQU	PABREQU_POST_DATE
REQUISITION_NUMBER		Requisition number of the position.	VARCHAR2(10)		PABREQU	PABREQU_REQ_NO
REQUISITION_STATUS		Status of the requisition (open, filled, etc.).	VARCHAR2(2)		PABREQU	PABREQU_REQS_CODE
REQUISITION_STATUS_DESC		Status description of the requisition.	VARCHAR2(30)		PTRREQS	PTRREQS_DESC
VACANCY_DATE		Date the position vacates.	DATE		PABREQU	PABREQU_VACY_DATE
ZONE_VALUE		Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(6)		NA	NA

Ver: