Target Column	Business Name	Business Definition	Database Data Type	Domain Value	Source Name	Source Column
ADMINISTRATIVE_GROUP	Administrative Group	Organization-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
APPLICATION_DATE	Application Date	Application submission date.	DATE		PABAPPL	PABAPPL_DATE
APPROVAL_DATE	Approval Date	Date the position requisition was approved.	DATE		PABREQU	PABREQU_APPR_DATE
CERTIFICATION_COUNT	Certification Count	Count of applicant certifications.	NUMBER		FUNCTION	MPKFUNC.F_COUNT_CERTIFICATION
CONTRACT_GROUP	Contract Group	Specifies the EEO Contract Group to which the employees in this employee class belong. Used for EEO reporting.	VARCHAR2(63)		PTRECLS	PTRECLS_EEOG_CODE
CONTRACT_GROUP_DESC	Contract Group Description	Contract group description.	VARCHAR2(255)		PTVEEOG	PTVEEOG_DESC
DESIRED_HOURLY	Desired Hourly	Hourly rate applicant desires.	NUMBER		PABAPPL	PABAPPL_DESIRED_HOURLY
DESIRED_SALARY	Desired Salary	Annual salary applicant desires.	NUMBER		PABAPPL	PABAPPL_DESIRED_SALARY
EMPLOYEE_CLASS	Employee Class	Employee class code. Organizes position information consistent with employee groupings. At the employee level, used to help determine controls for benefits, leave, payroll and self-service rules.	VARCHAR2(63)		NBBPOSN	NBBPOSN_ECLS_CODE
EMPLOYEE_CLASS_LONG_DESC	Employee Class Long Description	Employee class long description.	VARCHAR2(255)		PTRECLS	PTRECLS_LONG_DESC
EMPLOYEE_CLASS_SHORT_DESC	Employee Class Short Description	Employee class short description.	VARCHAR2(255)		PTRECLS	PTRECLS_SHORT_DESC
EMPLOYEE_SKILL	Employee Skill	EEO skill code associated with this applicant.	VARCHAR2(63)		PABAPPL	PABAPPL_ESKL_CODE
EMPLOYEE_SKILL_DESC	Employee Skill Description	EEO skill code description.	VARCHAR2(255)		PTVESKL	PTVESKL_DESC
EMPLOYMENT_HISTORY_COUNT	Employment History Count	Employment count.	NUMBER		FUNCTION	MPKFUNC.F_COUNT_PAST_EMPL
FULLTIME_PARTTIME_IND	Fulltime Parttime Indicator	Indicates whether the applicant wishes to work part time of full-time.	VARCHAR2(1)		PABAPPL	PABAPPL_FULL_PART_IND
HR_APPLICATION_STATUS_COUNT	Hr Application Status Count	Count of HR applicant statuses.	NUMBER		FUNCTION	MPKFUNC.F_COUNT_HR_APPL_STAT
ID	ID	Person's current identification number.	VARCHAR2(63)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
INTERVIEW_COUNT	Interview Count	Count of the number of people interviewing this applicant.	NUMBER		FUNCTION	MPKFUNC.F_COUNT_INTERVIEW
MULTI_SOURCE	Multi Source	Institution value for the record when the optional multi-institution facility feature has been applied.	VARCHAR2(63)		NA	NA
MULTI_SOURCE_DESC	Multi Source Description	Institution description when the optional multi-institution facility feature has been applied.	VARCHAR2(255)		NA	NA
NAME	Name	Name of the person (last name, first name, middle initial) or organization.	VARCHAR2(255)		FUNCTION	MGKFUNC.F_GET_PERSON_INFO
PAID_RELOCATION_IND	Paid Relocation Indicator	Indicates if relocation assistance is available.	VARCHAR2(1)		PABREQU	PABREQU_RELOC_IND
PERSON_UID	Person UID	System generated, unique, internal identification number assigned to this person.	NUMBER		PABAPPL	PABAPPL_PIDM
POSITION_APPLIED_FOR	Position Applied For	Position number associated with the requisition to which this applicant has applied.	VARCHAR2(6)		PABAPPL	PABAPPL_POSN
POSITION_APPLIED_FOR_TITLE	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	Position class associated with this applicant entry.	VARCHAR2(63)		PABAPPL	PABAPPL_PCLS_CODE
POSITION_CLASS_DESC	Position Class Description	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(255)		NTRPCLS	NTRPCLS_DESC
POSITION_CLOSE_DATE	Position Close Date	Date the application for the position is closed.	DATE		PABREQU	PABREQU_CLOSE_DATE
POSITION_HIRE_DATE	Position Hire Date	Projected date of hire for this position.	DATE		PABREQU	PABREQU_HIRE_DATE
POSITION_OPEN_DATE	Position Open Date	Date the application for the position is opened.	DATE		PABREQU	PABREQU_OPEN_DATE
POSITION_POSTING_DATE	Position Posting Date	Date the position is posted.	DATE		PABREQU	PABREQU_POST_DATE
POSITION_VACANCY_DATE	Position Vacancy Date	Date the position is vacated.	DATE		PABREQU	PABREQU_VACY_DATE
PROCESS_GROUP	Process Group	Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.	VARCHAR2(255)		NA	NA
REFERENCE_COUNT	Reference Count	Count of the references given for this HR application by this person.	NUMBER		FUNCTION	MPKFUNC.F_COUNT_REFERENCE
REQUISITION_NUMBER	Requisition Number	Requisition number to which the applicant has applied.	VARCHAR2(10)		PABAPPL	PABAPPL_REQ_NO
REQUISITION_STATUS	Requisition Status	Status of the requisition (open, filled, etc.).	VARCHAR2(2)		PABREQU	PABREQU_REQS_CODE
SKILL_COUNT	Skill Count	Count of applicant skills.	NUMBER		FUNCTION	MPKFUNC.F_COUNT_SKILL
SOURCE	Source	Source where applicant found out about job opening.	VARCHAR2(63)		PABAPPL	PABAPPL_ASRC_CODE
SOURCE_DESC	Source Description	Job opening source description.	VARCHAR2(255)		PTVASRC	PTVASRC_DESC
STATUS_DISPOSITION	Status Disposition	Status disposition.	VARCHAR2(63)		FUNCTION	F_DISPOSITION_IND
STATUS_DISPOSITION_DESC	Status Disposition Description	Deciphers applicant status disposition as hired, under consideration, no longer under consideration.	VARCHAR2(255)		CALCULATION	DECODE(F_DISPOSITION_IND,'H','HIRED','N','NO LONGER CONSIDERED','U','UNDER CONSIDERATION')
TITLE	Title	Position title.	VARCHAR2(30)		NBBPOSN	NBBPOSN_TITLE

Ver: 9.0