Target Column	Business Definition	Database Data Type	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: