Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PATHFIND FILE

                      Employee Report Writer Paths

Contains process level, department, user level, supervisor, union code, job
code, location code, schedule, mail group, badge code, hire source, bargaining
unit, emergency medical, and work restriction code records if data exists
within the field in either the Employee or Employee PA Information file.

This information is used to group employees according to key fields that are
not part of existing employee master paths.

HR170 (HR Writer Report Request) and HR70 (HR Writer Inquiry) are the primary
users of this file.

REFERENCED BY

HR15.1    HR155     HR170     HR211     HR54.1    HR55.2
HR70.1    HRS1.1    HRSC.1    PA16.1    PA248     PA249
PA272     PA370     PA42.1    PA53.1    PA54.1    PA66.3
TR22.1    TR500     HS36.1    HC01.1    HC02.1    HCEM.1
HCOP.1    HR00.1    HR00.2    HR00.3    HR01.1    HR02.1
HR07.1    HR207     HR217     HR507     HS10.1    HS10.2
HS12.1    HS13.1    HS15.1    HS52.1    HS52.2    PA113
PA149     PA213     PA218     PA219     PA95.1    TR114
TR121     HS22.1    HS22.2    PR128     PR16.1    PR197
PR21.1    PR216     PR33.2    PR33.3    HR04.2    HR04.3
HR04.7    HR04.8    HR04.9    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

UPDATED BY

HR511     HR650     PA120     PA502     PA513     PR13.1
PR13.5    PR13.6    PR13.8    PA302

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PTF-COMPANY          Numeric 4                                   HR511   HR650
Company              Contains the company number.                PA502   PA513
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PTF-EMPLOYEE         Numeric 9                                   HR511   HR650
Employee             Contains the employee number. An            PA502   PA513
                     employee number is assigned to each         PR13.1  PR13.5
                     person employed by the company. The         PR13.6  PR13.8
                     system uses the employee number to
                     correlate all information related to the
                     employee.

PTF-FLD-NBR          Numeric 4                                   HR511   HR650
Dictionary Field     Contains the field number from the HR       PA502   PA513
Number               Systems Data Dictionary file for the        PR13.1  PR13.5
                     data item represented by this record.       PR13.6  PR13.8

PTF-FLD-VALUE        Alpha 12                                    HR511   HR650
Field Value          Contains the field value for the record.    PA502   PA513
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PTF-LAST-NAME        Alpha 30  (Lower Case)                      HR511   HR650
Last Name            Contains the employee's last name.          PA502   PA513
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PTF-FIRST-NAME       Alpha 15  (Lower Case)                      HR511   HR650
First Name           Contains the employee's first name.         PA502   PA513
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PTF-MIDDLE-INIT      Alpha 1                                     HR511   HR650
Middle Initial       Contains the employee's middle initial.     PA502   PA513
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PTF-POS-LEVEL        Numeric 2                                   HR511   HR650
Pos Level            Contains the position level.                PA502   PA513
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PTF-FULL-NAME        Derived
Full Name

PTF-WORK-DESC        Derived
Work Desc

PTF-LABEL-NAME-1     Derived
Label Name 1

                         PATHFIND FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PTFSET1   COMPANY                                                HR15.1  HR155
          EMPLOYEE                                               HR170   HR211
          FLD-NBR                                                HR511   HR54.1
          POS-LEVEL                                              HR55.2  HR650
                                                                 HR70.1  HRS1.1
                                                                 HRSC.1  PA120
                                                                 PA16.1  PA248
                                                                 PA249   PA272
                                                                 PA370   PA42.1
                                                                 PA502   PA513
                                                                 PA53.1  PA54.1
                                                                 PA66.3  TR22.1
                                                                 TR500   HS36.1
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PTFSET2   COMPANY       KeyChange                                HC01.1  HC02.1
          FLD-NBR                                                HCEM.1  HCOP.1
          FLD-VALUE                                              HR00.1  HR00.2
          EMPLOYEE                                               HR00.3  HR01.1
          POS-LEVEL                                              HR02.1  HR07.1
                                                                 HR170   HR207
                                                                 HR217   HR507
                                                                 HR70.1  HS10.1
                                                                 HS10.2  HS12.1
                                                                 HS13.1  HS15.1
                                                                 HS52.1  HS52.2
                                                                 PA113   PA149
                                                                 PA213   PA218
                                                                 PA219   PA249
                                                                 PA302   PA95.1
                                                                 ...

PTFSET3   COMPANY       KeyChange, Subset                        PR33.3
          FLD-NBR       Where (FLD-NBR = 14 )
          FLD-VALUE     Or    (FLD-NBR = 15 )
          LAST-NAME     Or    (FLD-NBR = 16 )
          FIRST-NAME
          MIDDLE-INIT
          EMPLOYEE
          POS-LEVEL

PTFSET4   FLD-NBR       KeyChange, Subset                        HR04.2  HR04.3
          FLD-VALUE     Where (FLD-NBR = 16 )                    HR04.7  HR04.8
          COMPANY       Or    (FLD-NBR = 17 )                    HR04.9  HR80.1
          EMPLOYEE      Or    (FLD-NBR = 21 )                    HR80.2  HR80.3
          POS-LEVEL                                              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
                                                                 ...

PTFSET5   COMPANY       KeyChange, Subset                        HS10.1  HS10.2
          FLD-NBR       Where POS-LEVEL = 1                      HS12.1  HS13.1
          FLD-VALUE                                              HS15.1  HS52.1
          LAST-NAME                                              HS52.2  HS22.1
          FIRST-NAME                                             HS22.2
          MIDDLE-INIT
          EMPLOYEE

                         PATHFIND FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PTF-COMPANY          -> PRS-COMPANY
                            Spaces               -> PRS-PROCESS-LEVEL

Department     DEPTCODE     Not Required

                            PTF-COMPANY          -> DPT-COMPANY
                            EMP-PROCESS-LEVEL    -> DPT-PROCESS-LEVEL
                            EMP-DEPARTMENT       -> DPT-DEPARTMENT

Employee       EMPLOYEE     Required

                            PTF-COMPANY          -> EMP-COMPANY
                            PTF-EMPLOYEE         -> EMP-EMPLOYEE

Emstatus       EMSTATUS     Not Required

                            PTF-COMPANY          -> EMS-COMPANY
                            EMP-EMP-STATUS       -> EMS-EMP-STATUS

Jobcode        JOBCODE      Not Required

                            PTF-COMPANY          -> JBC-COMPANY
                            EMP-JOB-CODE         -> JBC-JOB-CODE

Location       PCODES       Not Required

                            "LO"                 -> PCO-TYPE
                            PEM-LOCAT-CODE       -> PCO-CODE

Pa Employee    PAEMPLOYEE   Required

                            PTF-COMPANY          -> PEM-COMPANY
                            PTF-EMPLOYEE         -> PEM-EMPLOYEE

                         PATHFIND FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Hrsuper        HRSUPER

                            PTF-COMPANY          -> HSU-COMPANY
                            PTF-EMPLOYEE         -> HSU-EMPLOYEE
                                                    HSU-CODE

Position       PAPOSITION

                            PTF-COMPANY          -> POS-COMPANY
                            EMP-POSITION         -> POS-POSITION
                                                    POS-EFFECT-DATE