Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

JOBRELATE


                             JOBRELATE FILE

                         Job Code Relationship

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.

REFERENCED BY

HR06.1    HR506     HS11.1    HS12.1    HS13.1    HS14.1
HS50.1    HS50.2    HS51.1    HS51.2    HS52.1    HS52.2
PA208     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
HR04.2    HR04.3    HR04.7    HR04.8    HR80.1    HR80.2
HR80.3    HR80.4    HR80.5    HR80.6    HR80.7    HR80.8
HR80.9    HR81.1    HR81.2    HR81.3    HR81.4    HR81.5
HR81.6    HR81.7    HR81.8    HR81.9    HR82.1    HR82.2
HR82.3    HR82.4    HR82.5    HR82.6    HR82.7    HR82.8
HR82.9    HR83.1    HR83.2    HR83.3    HR83.4    HR83.5
HR83.6    HR83.7    HR83.8    HR83.9    HR84.1    HR84.2
HR84.3    HR84.4    HR84.5    HR84.6    HR84.7    HR84.8
HR84.9    HR85.1    HR85.2    HR85.3    HR85.4    HR85.5
HR85.6    HR85.7    HR85.8    HR86.1    HR86.2    HR86.3
HR86.4    HR86.5    HR86.6    HR86.7    HR86.8    HR86.9
HR87.1    HR87.2    HR87.3    HR87.4    HR87.5    HR87.6
HR87.7    HR87.8    HR87.9    HR88.1    HR88.2    HR88.3
HR88.4    HR88.5    HR88.6    HR88.7    HR89.1    HR89.2
HR89.3    HR89.4    HR89.5    HR89.6    HR89.7    HR89.8
HR89.9    PA149     PA248     PA249     PA49.1    PA49.3
PA549

UPDATED BY

PA08.1    PA08.2    PA08.3    PA48.3    PA48.4    PA48.1
HR00.1    HR01.1    PA02.1    PA302     PA502     PBIP.1
PR197

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

JBR-COMPANY            Numeric 4                                 PA08.1  PA08.2
Element: Company       Contains the company number which         PA08.3  PA48.3
                       represents an established company.        PA48.4

JBR-JOB-CODE           Alpha 9                                   PA08.1  PA08.2
Element: Job Code      Contains the job code.                    PA08.3  PA48.3
                                                                 PA48.4

JBR-TYPE               Alpha 2                                   PA08.1  PA08.2
Element: Type          Contains the relationship type.           PA08.3  PA48.3
                       CE = Certification                        PA48.4
                       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

JBR-PERS-CODE          Alpha 10                                  PA08.1  PA08.2
Element: Personnel CodeContains certification, education and     PA08.3  PA48.3
                       skill codes.                              PA48.4

JBR-SUBJECT-CODE       Alpha 10                                  PA08.1  PA48.3
Element: Subject       Contains subject codes for ED             PA48.4
                       (education) records.

JBR-REQUIRED-FLAG      Alpha 1                                   PA08.1  PA08.2
Element: Essential     Indicates whether certain                 PA08.3  PA48.3
                       qualifications are required for a job or  PA48.4
                       position.
                       Y = Yes
                       N = No

JBR-PCT-OF-TIME        Signed 5.2                                PA08.1  PA08.2
Element: Percent of TimContains the percent of the time the      PA08.3  PA48.3
                       employee will spend on this essential     PA48.4
                       function.

JBR-POSITION           Alpha 12                                  PA08.1  PA08.2
Element: Position      Contains the user-defined code that       PA08.3  PA48.3
                       represents a position in the company.     PA48.4

JBR-PROCESS-LEVEL      Alpha 5                                   PA08.1
Element: Process Lev HrThis field contains the process level,
                       which is the reporting hierarchy below
                       company.

JBR-PROFIC-LEVEL       Alpha 10                                  PA08.1
Element: Profic Level

JBR-WGHT               Signed 5.2                                PA08.1
Element: Weight

                         JOBRELATE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

JBRSET1   COMPANY                                                HR00.1  HR01.1
          PROCESS-LEVEL                                          HR06.1  HR506
          JOB-CODE                                               HS11.1  HS12.1
          POSITION                                               HS13.1  HS14.1
          TYPE                                                   HS50.1  HS50.2
          PERS-CODE                                              HS51.1  HS51.2
          SUBJECT-CODE                                           HS52.1  HS52.2
                                                                 PA02.1  PA08.1
                                                                 PA08.2  PA08.3
                                                                 PA208   PA262
                                                                 PA263   PA302
                                                                 PA48.4  PA502
                                                                 PA62.1  PA63.1
                                                                 PA64.1  PA64.2
                                                                 PA65.1  PA65.2
                                                                 ...

JBRSET2   COMPANY                                                HR04.2  HR04.3
          PROCESS-LEVEL                                          HR04.7  HR04.8
          TYPE                                                   HR80.1  HR80.2
          PERS-CODE                                              HR80.3  HR80.4
          SUBJECT-CODE                                           HR80.5  HR80.6
          JOB-CODE                                               HR80.7  HR80.8
          POSITION                                               HR80.9  HR81.1
                                                                 HR81.2  HR81.3
                                                                 HR81.4  HR81.5
                                                                 HR81.6  HR81.7
                                                                 HR81.8  HR81.9
                                                                 HR82.1  HR82.2
                                                                 HR82.3  HR82.4
                                                                 HR82.5  HR82.6
                                                                 HR82.7  HR82.8
                                                                 ...

                         JOBRELATE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            JBR-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Compet Profic  PACOMPPROF   Not Required
                            Valid 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 Code       JOBCODE      Required
                            When (JBR-JOB-CODE != Spaces )

                            JBR-COMPANY          -> JBC-COMPANY
                            JBR-JOB-CODE         -> JBC-JOB-CODE

Pers Code      PCODES       Required

                            JBR-TYPE             -> PCO-TYPE
                            JBR-PERS-CODE        -> PCO-CODE

Process Level  PRSYSTEM     Required
                            When (JBR-PROCESS-LEVEL != Spaces )

                            JBR-COMPANY          -> PRS-COMPANY
                            JBR-PROCESS-LEVEL    -> PRS-PROCESS-LEVEL

Profic Level   PCODES       Required
                            When (JBR-PROFIC-LEVEL != Spaces )

                            "PF"                 -> PCO-TYPE
                            JBR-PROFIC-LEVEL     -> PCO-CODE

Subject        PCODES       Required
                            When JBR-SUBJECT-CODE != Spaces

                            "ES"                 -> PCO-TYPE
                            JBR-SUBJECT-CODE     -> PCO-CODE

Test Require   PATSTSETUP   Required
                            When (JBR-TYPE = "TS" )

                            JBR-COMPANY          -> PAP-COMPANY
                            JBR-PERS-CODE        -> PAP-TEST

                         JOBRELATE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Empcodes Apps  EMPCODES
                            Valid 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 Emps  EMPCODES
                            Valid 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

Position       PAPOSITION   Required
                            When (JBR-POSITION != Spaces )

                            JBR-COMPANY          -> POS-COMPANY
                            JBR-POSITION         -> POS-POSITION
                                                    POS-EFFECT-DATE

Proficiency    PACOMPPROF
                            Valid 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