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.

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 marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
JBRSET1COMPANY, PROCESS-LEVEL, JOB-CODE, POSITION, TYPE, PERS-CODE, SUBJECT-CODEPrimaryHR00.1, HR01.1, HR06.1, HR506, LT101, LT111, ZH230, ZH500 +22 more (list truncated in source)
JBRSET2COMPANY, PROCESS-LEVEL, TYPE, PERS-CODE, SUBJECT-CODE, JOB-CODE, POSITIONHR04.2, HR04.3, HR04.7, HR04.8, HR80.1, HR80.2, HR80.3, HR80.4 +22 more (list truncated in source)

Relations

One to one (8) — lookups and parents

RelationTableRulesConditionField map
CompanyPRSYSTEMRequiredJBR-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 CodePCODESRequiredJBR-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)