Target Column |
Business Name |
Business Definition |
Database Data Type |
Source Name |
Source Column |
ADMINISTRATIVE_GROUP
|
Administrative Group
|
Administrative-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
|
Identification number assigned to a person that is used externally for all communication and correspondence with the person.
|
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(255)
|
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(255)
|
NBBPOSN
|
NBBPOSN_TITLE
|