JOBAUTH

Employee Job Authorization

The Employee Qualification Override file contains job and position codes which employees are authorized to hold. This information is used by the employee job and position qualification searches and by reporting features of the system.
UPDATED BY
HR06.1 HR11.1 HR506 LT101 HS11.1 HS11.2
HS12.1 HS12.2 HS13.1 HS13.2 HS50.1 HS50.2
HS51.1 HS51.2 HS52.1 HS52.2 PA02.1 PA115
PA120 PA23.1 PA262 PA263 PA302 PA37.1
PA502 PA62.1 PA63.1 PA64.1 PA64.2 PA65.1
PA65.2 TR120 TR121 TR20.1 TR20.2 TR20.3
TR20.4 TR21.1 TR22.1 TR26.1 TR500

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
JBA-COMPANY
Element: Company
Numeric 4
Contains the company number which represents an established company.
PA23.1 PA37.1
JBA-EMP-APP
Element: Type
Numeric 1
Indicates whether the person is an external or internal applicant. An external applicant is a person applying from outside the company; an internal applicant is an employee applying from inside the company.
0 = Employee
1 = Applicant
HS11.1 HS11.2
HS12.1 HS12.2
HS13.1 HS13.2
HS50.1 HS50.2
HS51.1 HS51.2
HS52.1 HS52.2
PA23.1 PA262
PA263 PA37.1
PA62.1 PA63.1
PA64.1 PA64.2
PA65.1 PA65.2
TR120 TR121
TR20.1 TR20.2
TR20.3 TR20.4
TR21.1 TR22.1
TR26.1 TR500
JBA-JOB-CODE
Element: Job Code
Alpha 9
This field contains the job code. It must be valid in JOBCODE.
PA23.1 PA37.1
JBA-EMPLOYEE
Element: Employee
Numeric 9
Contains the number of the employee or applicant.
HS11.1 HS11.2
HS12.1 HS12.2
HS13.1 HS13.2
HS50.1 HS50.2
HS51.1 HS51.2
HS52.1 HS52.2
PA23.1 PA262
PA263 PA37.1
PA62.1 PA63.1
PA64.1 PA64.2
PA65.1 PA65.2
TR120 TR121
TR20.1 TR20.2
TR20.3 TR20.4
TR21.1 TR22.1
TR26.1 TR500
JBA-POSITION
Element: Position
Alpha 12
Contains the user-defined code that represents a position in the company.
PA23.1 PA37.1


JOBAUTH FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
JBASET1 COMPANY
EMP-APP
JOB-CODE
POSITION
EMPLOYEE
...
HR06.1 HR506
LT101 HS11.1
HS11.2 HS12.1
HS12.2 HS13.1
HS13.2 HS50.1
HS50.2 HS51.1
HS51.2 HS52.1
HS52.2 PA23.1
PA262 PA263
PA37.1 PA62.1
PA63.1 PA64.1
PA64.2 PA65.1
PA65.2 TR120
TR121 TR20.1
TR20.2 TR20.3
JBASET2 COMPANY
EMP-APP
EMPLOYEE
JOB-CODE
POSITION
HR11.1 PA115
PA120 PA64.1
PA64.2 PA65.1
PA65.2
JBASET3 COMPANY
POSITION
EMP-APP
EMPLOYEE
JOB-CODE
Subset
Where(POSITION !=Spaces)
LT101 PA02.1
PA302 PA502


JOBAUTH FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Applicant APPLICANT Required
When JBA-EMP-APP =1
JBA-COMPANY->APL-COMPANY
JBA-EMPLOYEE->APL-APPLICANT
Company PRSYSTEM Required
JBA-COMPANY->PRS-COMPANY
Spaces->PRS-PROCESS-LEVEL
Employee EMPLOYEE Required
When JBA-EMP-APP =Zeroes
JBA-COMPANY->EMP-COMPANY
JBA-EMPLOYEE->EMP-EMPLOYEE
Job Code JOBCODE Required
When (JBA-JOB-CODE !=Spaces )
JBA-COMPANY->JBC-COMPANY
JBA-JOB-CODE->JBC-JOB-CODE
Paemployee PAEMPLOYEE Required
When JBA-EMP-APP =Zeroes
JBA-COMPANY->PEM-COMPANY
JBA-EMPLOYEE->PEM-EMPLOYEE


JOBAUTH FILE RELATIONS


ONE TO MANY RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
Position PAPOSITION Required
When (JBA-POSITION !=Spaces )
JBA-COMPANY->POS-COMPANY
JBA-POSITION->POS-POSITION
  POS-EFFECT-DATE


File created: Thu Jun 09 11:22:03 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.