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
PA120 PA23.1 PA37.1 HR06.1 HR506 HS11.1
HS11.2 HS12.1 HS12.2 HS13.1 HS13.2 HS50.1
HS50.2 HS51.1 HS51.2 HS52.1 HS52.2 PA262
PA263 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 HR11.1
PA115 PA02.1 PA302 PA502

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
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
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)
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: Wed Jun 08 20:50:21 2016

Home
Contact Us



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