Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
ADMINISTRATIVE_GROUP
|
Administrative-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
APPLICATION_DATE
|
Application submission date.
|
DATE
|
PABAPPL
|
PABAPPL_DATE
|
NO
|
NO
|
APPROVAL_DATE
|
Date the position requisition was approved.
|
DATE
|
PABREQU
|
PABREQU_APPR_DATE
|
NO
|
NO
|
CERTIFICATION_COUNT
|
Count of applicant certifications.
|
NUMBER
|
FUNCTION
|
MPKFUNC.F_COUNT_CERTIFICATION
|
NO
|
NO
|
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
|
NO
|
NO
|
CONTRACT_GROUP_DESC
|
Contract group description.
|
VARCHAR2(255)
|
PTVEEOG
|
PTVEEOG_DESC
|
NO
|
NO
|
DESIRED_HOURLY
|
Hourly rate applicant desires.
|
NUMBER
|
PABAPPL
|
PABAPPL_DESIRED_HOURLY
|
NO
|
NO
|
DESIRED_SALARY
|
Annual salary applicant desires.
|
NUMBER
|
PABAPPL
|
PABAPPL_DESIRED_SALARY
|
NO
|
NO
|
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
|
NO
|
NO
|
EMPLOYEE_CLASS_LONG_DESC
|
Employee class long description.
|
VARCHAR2(255)
|
PTRECLS
|
PTRECLS_LONG_DESC
|
NO
|
NO
|
EMPLOYEE_CLASS_SHORT_DESC
|
Employee class short description.
|
VARCHAR2(255)
|
PTRECLS
|
PTRECLS_SHORT_DESC
|
NO
|
NO
|
EMPLOYEE_SKILL
|
EEO skill code associated with this applicant.
|
VARCHAR2(63)
|
PABAPPL
|
PABAPPL_ESKL_CODE
|
NO
|
NO
|
EMPLOYEE_SKILL_DESC
|
EEO skill code description.
|
VARCHAR2(255)
|
PTVESKL
|
PTVESKL_DESC
|
NO
|
NO
|
EMPLOYMENT_HISTORY_COUNT
|
Employment count.
|
NUMBER
|
FUNCTION
|
MPKFUNC.F_COUNT_PAST_EMPL
|
NO
|
NO
|
FULLTIME_PARTTIME_IND
|
Indicates whether the applicant wishes to work part time of full-time.
|
VARCHAR2(1)
|
PABAPPL
|
PABAPPL_FULL_PART_IND
|
NO
|
NO
|
HR_APPLICATION_STATUS_COUNT
|
Count of HR applicant statuses.
|
NUMBER
|
FUNCTION
|
MPKFUNC.F_COUNT_HR_APPL_STAT
|
NO
|
NO
|
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
|
NO
|
NO
|
INTERVIEW_COUNT
|
Count of the number of people interviewing this applicant.
|
NUMBER
|
FUNCTION
|
MPKFUNC.F_COUNT_INTERVIEW
|
NO
|
NO
|
MULTI_SOURCE
|
Institution value for the record when the optional multi-institution facility feature has been applied.
|
VARCHAR2(63)
|
NA
|
NA
|
NO
|
NO
|
MULTI_SOURCE_DESC
|
Institution description when the optional multi-institution facility feature has been applied.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
NAME
|
Name of the person (last name, first name, middle initial) or organization.
|
VARCHAR2(255)
|
FUNCTION
|
MGKFUNC.F_GET_PERSON_INFO
|
NO
|
NO
|
PAID_RELOCATION_IND
|
Indicates if relocation assistance is available.
|
VARCHAR2(1)
|
PABREQU
|
PABREQU_RELOC_IND
|
NO
|
NO
|
PERSON_UID
|
System generated, unique, internal identification number assigned to this person.
|
NUMBER
|
PABAPPL
|
PABAPPL_PIDM
|
NO
|
NO
|
POSITION_APPLIED_FOR
|
Position number associated with the requisition to which this applicant has applied.
|
VARCHAR2(6)
|
PABAPPL
|
PABAPPL_POSN
|
NO
|
NO
|
POSITION_APPLIED_FOR_TITLE
|
Title or description of a position to which a candidate has applied.
|
VARCHAR2(30)
|
NBBPOSN
|
NBBPOSN_TITLE
|
NO
|
NO
|
POSITION_CLASS
|
Position class associated with this applicant entry.
|
VARCHAR2(63)
|
PABAPPL
|
PABAPPL_PCLS_CODE
|
NO
|
NO
|
POSITION_CLASS_DESC
|
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
|
NO
|
NO
|
POSITION_CLOSE_DATE
|
Date the application for the position is closed.
|
DATE
|
PABREQU
|
PABREQU_CLOSE_DATE
|
NO
|
NO
|
POSITION_HIRE_DATE
|
Projected date of hire for this position.
|
DATE
|
PABREQU
|
PABREQU_HIRE_DATE
|
NO
|
NO
|
POSITION_OPEN_DATE
|
Date the application for the position is opened.
|
DATE
|
PABREQU
|
PABREQU_OPEN_DATE
|
NO
|
NO
|
POSITION_POSTING_DATE
|
Date the position is posted.
|
DATE
|
PABREQU
|
PABREQU_POST_DATE
|
NO
|
NO
|
POSITION_VACANCY_DATE
|
Date the position is vacated.
|
DATE
|
PABREQU
|
PABREQU_VACY_DATE
|
NO
|
NO
|
PROCESS_GROUP
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(255)
|
NA
|
NA
|
NO
|
NO
|
REFERENCE_COUNT
|
Count of the references given for this HR application by this person.
|
NUMBER
|
FUNCTION
|
MPKFUNC.F_COUNT_REFERENCE
|
NO
|
NO
|
REQUISITION_NUMBER
|
Requisition number to which the applicant has applied.
|
VARCHAR2(10)
|
PABAPPL
|
PABAPPL_REQ_NO
|
NO
|
NO
|
REQUISITION_STATUS
|
Status of the requisition (open, filled, etc.).
|
VARCHAR2(2)
|
PABREQU
|
PABREQU_REQS_CODE
|
NO
|
NO
|
SKILL_COUNT
|
Count of applicant skills.
|
NUMBER
|
FUNCTION
|
MPKFUNC.F_COUNT_SKILL
|
NO
|
NO
|
SOURCE
|
Source where applicant found out about job opening.
|
VARCHAR2(63)
|
PABAPPL
|
PABAPPL_ASRC_CODE
|
NO
|
NO
|
SOURCE_DESC
|
Job opening source description.
|
VARCHAR2(255)
|
PTVASRC
|
PTVASRC_DESC
|
NO
|
NO
|
STATUS_DISPOSITION
|
Status disposition.
|
VARCHAR2(63)
|
FUNCTION
|
F_DISPOSITION_IND
|
NO
|
NO
|
STATUS_DISPOSITION_DESC
|
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')
|
NO
|
NO
|
TITLE
|
Position title.
|
VARCHAR2(30)
|
NBBPOSN
|
NBBPOSN_TITLE
|
NO
|
NO
|