Lawson Insight Technical Documentation |
|
JOBAUTH
JOBAUTH FILE
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.
REFERENCED BY
HR06.1 HR506 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 TR21.1 TR22.1 TR26.1
TR500
UPDATED BY
PA120 PA23.1 PA37.1 HR11.1 PA115 PA02.1
PA302 PA502
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
JBA-COMPANY Numeric 4 PA23.1 PA37.1
Element: Company Contains the company number which
represents an established company.
JBA-EMP-APP Numeric 1 HS50.1 HS50.2
Element: Type Indicates whether the person is an HS51.1 HS51.2
external or internal applicant. HS52.1 HS52.2
PA23.1 PA262
An external applicant is a person PA263 PA37.1
applying from outside the company; an PA62.1 PA63.1
internal applicant is an employee PA64.1 PA64.2
applying from inside the company. PA65.1 PA65.2
0 = Employee TR120 TR121
1 = Applicant TR20.1 TR20.2
TR20.3 TR21.1
TR22.1 TR26.1
TR500
JBA-JOB-CODE Alpha 9 PA23.1 PA37.1
Element: Job Code This field contains the job code. It
must be valid in JOBCODE.
JBA-EMPLOYEE Numeric 9 HS50.1 HS50.2
Element: Employee Contains the number of the employee or HS51.1 HS51.2
applicant. 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 TR21.1
TR22.1 TR26.1
TR500
JBA-POSITION Alpha 12 PA23.1 PA37.1
Element: Position Contains the user-defined code that
represents a position in the company.
JOBAUTH FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
JBASET1 COMPANY HR06.1 HR506
EMP-APP HS50.1 HS50.2
JOB-CODE HS51.1 HS51.2
POSITION HS52.1 HS52.2
EMPLOYEE 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 TR21.1
TR22.1 TR26.1
TR500
JBASET2 COMPANY HR11.1 PA115
EMP-APP PA120 PA64.1
EMPLOYEE PA64.2 PA65.1
JOB-CODE PA65.2
POSITION
JBASET3 COMPANY Subset PA02.1 PA302
POSITION Where (POSITION != Spaces ) PA502
EMP-APP
EMPLOYEE
JOB-CODE
JOBAUTH FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME 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 RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Position PAPOSITION Required
When (JBA-POSITION != Spaces )
JBA-COMPANY -> POS-COMPANY
JBA-POSITION -> POS-POSITION
POS-EFFECT-DATE
|