Target Column |
Business Definition |
Database Data Type |
Source Name |
Source Column |
Local Source |
Local Target |
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
|
CONTRACT_GROUP
|
Specifies the EEO Contract Group to which the employees in this employee class belong. Used for EEO reporting.
|
VARCHAR2(2)
|
PTRECLS
|
PTRECLS_EEOG_CODE
|
NO
|
NO
|
CONTRACT_GROUP_DESC
|
Contract group description.
|
VARCHAR2(30)
|
PTVEEOG
|
PTVEEOG_DESC
|
NO
|
NO
|
CURRENT_DATE
|
System current date (sysdate) or date the data was extracted.
|
DATE
|
NA
|
SYSDATE
|
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
|
DOMAIN_VALUE
|
Organization-oriented identifier for the record used to determine access authorization. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
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(2)
|
NBBPOSN
|
NBBPOSN_ECLS_CODE
|
NO
|
NO
|
EMPLOYEE_CLASS_LONG_DESC
|
Employee class long description.
|
VARCHAR2(30)
|
PTRECLS
|
PTRECLS_LONG_DESC
|
NO
|
NO
|
EMPLOYEE_CLASS_SHORT_DESC
|
Employee class short description.
|
VARCHAR2(8)
|
PTRECLS
|
PTRECLS_SHORT_DESC
|
NO
|
NO
|
EMPLOYEE_SKILL
|
EEO skill code associated with this applicant.
|
VARCHAR2(2)
|
PABAPPL
|
PABAPPL_ESKL_CODE
|
NO
|
NO
|
EMPLOYEE_SKILL_DESC
|
EEO skill code description.
|
VARCHAR2(30)
|
PTVESKL
|
PTVESKL_DESC
|
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
|
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
|
PAID_RELOCATION_IND
|
Indicates if relocation assistance is available for this position.
|
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 the requisition to which this applicant has applied. 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(5)
|
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(30)
|
NTRPCLS
|
NTRPCLS_DESC
|
NO
|
NO
|
POSITION_CLOSE_DATE
|
Date the application for the position will be 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 opens.
|
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 vacates.
|
DATE
|
PABREQU
|
PABREQU_VACY_DATE
|
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
|
SOURCE
|
Source where applicant found out about job opening.
|
VARCHAR2(2)
|
PABAPPL
|
PABAPPL_ASRC_CODE
|
NO
|
NO
|
SOURCE_DESC
|
Description of the source where applicant found out about job opening.
|
VARCHAR2(30)
|
PTVASRC
|
PTVASRC_DESC
|
NO
|
NO
|
STATUS_DISPOSITION
|
Applicant status disposition.
|
VARCHAR2(1)
|
FUNCTION
|
F_DISPOSITION_IND
|
NO
|
NO
|
STATUS_DISPOSITION_DESC
|
Status disposition description.
|
VARCHAR2(30)
|
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
|
ZONE_VALUE
|
Process-oriented identifier for the record used to determine access authorization to this record. Institution defined.
|
VARCHAR2(6)
|
NA
|
NA
|
NO
|
NO
|