JOBRELATE – Job Code Relationship

System
Personnel (PA)
Prefix
JBR
Primary key
COMPANY, PROCESS-LEVEL, JOB-CODE, POSITION, TYPE, PERS-CODE, SUBJECT-CODE
Fields
11
Updated by
16 programs
Referenced by
135 programs

JOBRELATE is the Job Code Relationship table in Lawson Personnel (prefix JBR). It is indexed by COMPANY, PROCESS-LEVEL, JOB-CODE, POSITION, TYPE, PERS-CODE, SUBJECT-CODE (JBRSET1); alternate indexes: JBRSET2. It is related 1:1 to PRSYSTEM, PACOMPPROF, JOBCODE, PCODES and PATSTSETUP and 1:M to EMPCODES, PAPOSITION and PACOMPPROF. It is updated by HR00.1, HR01.1, LT101, LT111, PA02.1, PA08.1, PA08.2, PA08.3 and 8 more and referenced by HR04.2, HR04.3, HR04.7, HR04.8, HR06.1, HR506, HR80.1, HR80.2 and 127 more. The table has 11 fields, 2 indexes and 12 documented relations.

About JOBRELATE

The Job Code Relationship file contains information about the certification, education, and skills which are desired or required qualifications for a job or a position.

Fields (11)

Column = COBOL field name without the JBR- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#JBR-COMPANY PK
COMPANY		Numeric 4Contains the company number which represents an established company.PA08.1, PA08.2, PA08.3, PA48.3, PA48.4, ZE533, ZE534
#JBR-JOB-CODE PK
JOB_CODE		Alpha 9Contains the job code.PA08.1, PA08.2, PA08.3, PA48.3, PA48.4, ZE533, ZE534
#JBR-TYPE PK
TYPE		Alpha 2Contains the relationship type.
  • CE Certification
  • ED Education Degree
  • SK Skill
  • SR Supervision Received
  • EO Equipment Operated
  • TR Travel
  • EC Environmental Conditions
  • PH Physical Requirements
  • MR Mental Requirements
  • TS Test
  • PF Proficiency
  • AB Ability
  • KN Knowledge
  • OA Other Attributes
PA08.1, PA08.2, PA08.3, PA48.3, PA48.4, ZE533, ZE534
#JBR-PERS-CODE PK
PERS_CODE		Alpha 10Contains certification, education and skill codes.PA08.1, PA08.2, PA08.3, PA48.3, PA48.4, ZE533, ZE534
#JBR-SUBJECT-CODE PK
SUBJECT_CODE		Alpha 10Contains subject codes for ED (education) records.PA08.1, PA48.3, PA48.4, ZE533, ZE534
#JBR-REQUIRED-FLAG
REQUIRED_FLAG		Alpha 1Indicates whether certain qualifications are required for a job or position.
  • Y Yes
  • N No
PA08.1, PA08.2, PA08.3, PA48.3, PA48.4, ZE533, ZE534
#JBR-PCT-OF-TIME
PCT_OF_TIME		Signed 5.2Contains the percent of the time the employee will spend on this essential function.PA08.1, PA08.2, PA08.3, PA48.3, PA48.4, ZE533, ZE534
#JBR-POSITION PK
POSITION		Alpha 12Contains the user-defined code that represents a position in the company.PA08.1, PA08.2, PA08.3, PA48.3, PA48.4, ZE533, ZE534
#JBR-PROCESS-LEVEL PK
PROCESS_LEVEL		Alpha 5—PA08.1, ZE533, ZE534
#JBR-PROFIC-LEVEL
PROFIC_LEVEL		Alpha 10—PA08.1, ZE533, ZE534
#JBR-WGHT
WGHT		Signed 5.2—PA08.1, ZE533, ZE534

Indexes (2)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
JBRSET1
  1. COMPANY
  2. PROCESS-LEVEL
  3. JOB-CODE
  4. POSITION
  5. TYPE
  6. PERS-CODE
  7. SUBJECT-CODE
PrimaryHR00.1, HR01.1, HR06.1, HR506, LT101, LT111, ZH230, ZH500 +22 more (list truncated in source)
JBRSET2
  1. COMPANY
  2. PROCESS-LEVEL
  3. TYPE
  4. PERS-CODE
  5. SUBJECT-CODE
  6. JOB-CODE
  7. POSITION
HR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +22 more (list truncated in source)

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PRSYSTEMPACOMPPROFJOBCODEPCODESPATSTSETUPEMPCODESPAPOSITIONPACOMPPROFJOBRELATE

One to one (8) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequired
JBR-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
Compet ProficPACOMPPROFNot RequiredValid When ((JBR-TYPE = "AB") Or (JBR-TYPE = "KN") Or (JBR-TYPE = "OA") Or (JBR-TYPE = "SK")) And (JBR-PROFIC-LEVEL != Spaces)
JBR-COMPANY→PCM-COMPANY
Spaces→PCM-PROCESS-LEVEL
JBR-TYPE→PCM-TYPE
JBR-PERS-CODE→PCM-CODE
JBR-PROFIC-LEVEL→PCM-PROFIC-LEVEL
Job CodeJOBCODERequiredWhen (JBR-JOB-CODE != Spaces)
JBR-COMPANY→JBC-COMPANY
JBR-JOB-CODE→JBC-JOB-CODE
Pers CodePCODESRequired
JBR-TYPE→PCO-TYPE
JBR-PERS-CODE→PCO-CODE
Process LevelPRSYSTEMRequiredWhen (JBR-PROCESS-LEVEL != Spaces)
JBR-COMPANY→PRS-COMPANY
JBR-PROCESS-LEVEL→PRS-PROCESS-LEVEL
Profic LevelPCODESRequiredWhen (JBR-PROFIC-LEVEL != Spaces)
"PF"→PCO-TYPE
JBR-PROFIC-LEVEL→PCO-CODE
SubjectPCODESRequiredWhen JBR-SUBJECT-CODE != Spaces
"ES"→PCO-TYPE
JBR-SUBJECT-CODE→PCO-CODE
Test RequirePATSTSETUPRequiredWhen (JBR-TYPE = "TS")
JBR-COMPANY→PAP-COMPANY
JBR-PERS-CODE→PAP-TEST

One to many (4) — child tables

RelationTableRulesConditionField map
Empcodes AppsEMPCODESValid When (JBR-TYPE = "CE") Or (JBR-TYPE = "ED") Or (JBR-TYPE = "SK") Or (JBR-TYPE = "AB") Or (JBR-TYPE = "KN") Or (JBR-TYPE = "OA")
JBR-COMPANY→EPC-COMPANY
JBR-TYPE→EPC-TYPE
1→EPC-EMP-APP
JBR-PERS-CODE→EPC-CODE
—→EPC-EMPLOYEE
—→EPC-SUBJECT
—→EPC-SEQ-NBR
Empcodes EmpsEMPCODESValid When (JBR-TYPE = "CE") Or (JBR-TYPE = "ED") Or (JBR-TYPE = "SK") Or (JBR-TYPE = "AB") Or (JBR-TYPE = "KN") Or (JBR-TYPE = "OA")
JBR-COMPANY→EPC-COMPANY
JBR-TYPE→EPC-TYPE
Zeroes→EPC-EMP-APP
JBR-PERS-CODE→EPC-CODE
—→EPC-EMPLOYEE
—→EPC-SUBJECT
—→EPC-SEQ-NBR
PositionPAPOSITIONRequiredWhen (JBR-POSITION != Spaces)
JBR-COMPANY→POS-COMPANY
JBR-POSITION→POS-POSITION
—→POS-EFFECT-DATE
ProficiencyPACOMPPROFValid When (JBR-TYPE = "AB") Or (JBR-TYPE = "KN") Or (JBR-TYPE = "OA") Or (JBR-TYPE = "SK")
JBR-COMPANY→PCM-COMPANY
Spaces→PCM-PROCESS-LEVEL
JBR-TYPE→PCM-TYPE
JBR-PERS-CODE→PCM-CODE
—→PCM-PROFIC-LEVEL

Programs

Updated by (16)

Referenced by (135)