Target Column	Business Definition	Database Data Type	Source Name	Source Column	Local Source	Local Target
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	NO	NO
APPLICATION_DATE	Application submission date.	DATE	PABREQU	PABREQU_APPL_DATE	NO	NO
APPROVAL_DATE	Date the position requisition was approved.	DATE	PABREQU	PABREQU_APPR_DATE	NO	NO
CLOSE_DATE	Date the application for the position is closed.	DATE	PABREQU	PABREQU_CLOSE_DATE	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
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	NO	NO
FULL_OR_PART_TIME_DESC	Employment status description.	VARCHAR2(0)	NA	NA	NO	NO
HIRE_DATE	Projected date of hire for this position.	DATE	PABREQU	PABREQU_HIRE_DATE	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
MINIMUM_DEGREE_LEVEL	Minimum degree level required by the requisition.	VARCHAR2(0)	PARPDEG	PARPDEG_DEGC_CODE	NO	NO
MINIMUM_DEGREE_LEVEL_DESC	Minimum degree level description.	VARCHAR2(0)	NA	NA	NO	NO
OPEN_DATE	Date the application for the position opens.	DATE	PABREQU	PABREQU_OPEN_DATE	NO	NO
POSITION	Position number associated with this requisition.	VARCHAR2(6)	PABREQU	PABREQU_POSN	NO	NO
POSTING_DATE	Date the position is posted.	DATE	PABREQU	PABREQU_POST_DATE	NO	NO
REQUISITION_NUMBER	Requisition number of the position.	VARCHAR2(10)	PABREQU	PABREQU_REQ_NO	NO	NO
REQUISITION_STATUS	Status of the requisition (open, filled, etc.).	VARCHAR2(2)	PABREQU	PABREQU_REQS_CODE	NO	NO
REQUISITION_STATUS_DESC	Status description of the requisition.	VARCHAR2(30)	PTRREQS	PTRREQS_DESC	NO	NO
VACANCY_DATE	Date the position vacates.	DATE	PABREQU	PABREQU_VACY_DATE	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: