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 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 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 HS11.1 HS11.2
Element: Type Indicates whether the person is an HS12.1 HS12.2
external or internal applicant. HS13.1 HS13.2
HS50.1 HS50.2
An external applicant is a person HS51.1 HS51.2
applying from outside the company; an HS52.1 HS52.2
internal applicant is an employee PA23.1 PA262
applying from inside the company. PA263 PA37.1
0 = Employee PA62.1 PA63.1
1 = Applicant PA64.1 PA64.2
PA65.1 PA65.2
TR120 TR121
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 HS11.1 HS11.2
Element: Employee Contains the number of the employee or HS12.1 HS12.2
applicant. 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 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 HS11.1 HS11.2
JOB-CODE HS12.1 HS12.2
POSITION HS13.1 HS13.2
EMPLOYEE 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 TR21.1
...
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
|