PATHFIND – Employee Report Writer Paths

System
Human Resources (HR)
Prefix
PTF
Primary key
COMPANY, EMPLOYEE, FLD-NBR, POS-LEVEL
Fields
10
Updated by
34 programs
Referenced by
193 programs

PATHFIND is the Employee Report Writer Paths table in Lawson Human Resources (prefix PTF). It is indexed by COMPANY, EMPLOYEE, FLD-NBR, POS-LEVEL (PTFSET1); alternate indexes: PTFSET2, PTFSET3, PTFSET4 and PTFSET5. It is related 1:1 to PCODES, PRSYSTEM, DEPTCODE, EMPLOYEE, EMSTATUS, JOBCODE and PAEMPLOYEE and 1:M to HRSUPER, PAEMPPOS, PAPOSITION and HRWRKSCHD. It is updated by BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 and 26 more and referenced by BN320, HAP3.1, HC01.2, HCDL.1, HCEM.1, HCRE.1, HEP4.1, HPOS.1 and 185 more. The table has 10 fields, 5 indexes and 15 documented relations.

About PATHFIND

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.

Fields (10)

Column = COBOL field name without the PTF- 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
#PTF-COMPANY PK
COMPANY		Numeric 4Contains the company number.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PTF-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number. An employee number is assigned to each person employed by the company. The system uses the employee number to correlate all information related to the employee.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PTF-FLD-NBR PK
FLD_NBR		Numeric 4Contains the field number from the HR Systems Data Dictionary file for the data item represented by this record.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PTF-FLD-VALUE SET2 SET3 SET4 SET5
FLD_VALUE		Alpha 12Contains the field value for the record.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PTF-LAST-NAME SET3 SET5
LAST_NAME		Alpha 30 (Lower Case)Contains the employee's last name.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PTF-FIRST-NAME SET3 SET5
FIRST_NAME		Alpha 15 (Lower Case)Contains the employee's first name.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PTF-MIDDLE-INIT SET3 SET5
MIDDLE_INIT		Alpha 1Contains the employee's middle initial.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PTF-POS-LEVEL PK
POS_LEVEL		Numeric 2Contains the position level.BN305, HR11.1, HR11.2, HR11.4, HR28.1, HR511, LT101, LT111 +24 more
#PTF-FULL-NAME
FULL_NAME		Derived——
#PTF-LABEL-NAME-1
LABEL_NAME_1		Derived——

Indexes (5)

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
PTFSET1
  1. COMPANY
  2. EMPLOYEE
  3. FLD-NBR
  4. POS-LEVEL
PrimaryBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
PTFSET2
  1. COMPANY
  2. FLD-NBR
  3. FLD-VALUE
  4. EMPLOYEE
  5. POS-LEVEL
KeyChangeBN320, HC01.2, HCDL.1, HCEM.1, HR00.1, HR00.2, HR00.3, HR01.1 +22 more (list truncated in source)
PTFSET3
  1. COMPANY
  2. FLD-NBR
  3. FLD-VALUE
  4. LAST-NAME
  5. FIRST-NAME
  6. MIDDLE-INIT
  7. EMPLOYEE
  8. POS-LEVEL
KeyChange, SubsetWhere (FLD-NBR = 14) Or (FLD-NBR = 15) Or (FLD-NBR = 16)HR02.1, PR33.3
PTFSET4
  1. FLD-NBR
  2. FLD-VALUE
  3. COMPANY
  4. EMPLOYEE
  5. POS-LEVEL
KeyChange, SubsetWhere (FLD-NBR = 16) Or (FLD-NBR = 17) Or (FLD-NBR = 21)HR04.2, HR04.3, HR04.7, HR04.8, HR04.9, HR80.1, HR80.2, HR80.3 +22 more (list truncated in source)
PTFSET5
  1. COMPANY
  2. FLD-NBR
  3. FLD-VALUE
  4. LAST-NAME
  5. FIRST-NAME
  6. MIDDLE-INIT
  7. EMPLOYEE
KeyChange, SubsetWhere POS-LEVEL = 1HS10.1, HS10.2, HS12.1, HS12.2, HS13.1, HS13.2, HS15.1, HS52.1 +5 more

Relations

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

One to one (10) — lookups and parents

RelationTableRulesConditionField map
Bargain UnitPCODESRequired
"BU"→PCO-TYPE
PEM-BARGAIN-UNIT→PCO-CODE
CompanyPRSYSTEMRequired
PTF-COMPANY→PRS-COMPANY
Spaces→PRS-PROCESS-LEVEL
DepartmentDEPTCODENot Required
PTF-COMPANY→DPT-COMPANY
EMP-PROCESS-LEVEL→DPT-PROCESS-LEVEL
EMP-DEPARTMENT→DPT-DEPARTMENT
EmployeeEMPLOYEERequired
PTF-COMPANY→EMP-COMPANY
PTF-EMPLOYEE→EMP-EMPLOYEE
EmstatusEMSTATUSNot Required
PTF-COMPANY→EMS-COMPANY
EMP-EMP-STATUS→EMS-EMP-STATUS
JobcodeJOBCODENot Required
PTF-COMPANY→JBC-COMPANY
EMP-JOB-CODE→JBC-JOB-CODE
LocationPCODESNot Required
"LO"→PCO-TYPE
PEM-LOCAT-CODE→PCO-CODE
Pa EmployeePAEMPLOYEERequired
PTF-COMPANY→PEM-COMPANY
PTF-EMPLOYEE→PEM-EMPLOYEE
PtfjobcodeJOBCODERequiredWhen PTF-FLD-NBR = 19
PTF-COMPANY→JBC-COMPANY
PTF-FLD-VALUE→JBC-JOB-CODE
UnionPCODESRequired
"UN"→PCO-TYPE
EMP-UNION-CODE→PCO-CODE

One to many (5) — child tables

RelationTableRulesConditionField map
HrsuperHRSUPER
PTF-COMPANY→HSU-COMPANY
PTF-EMPLOYEE→HSU-EMPLOYEE
—→HSU-CODE
PaempposPAEMPPOS
PTF-COMPANY→PEP-COMPANY
PTF-EMPLOYEE→PEP-EMPLOYEE
PTF-POS-LEVEL→PEP-POS-LEVEL
—→PEP-EFFECT-DATE
PositionPAPOSITION
PTF-COMPANY→POS-COMPANY
EMP-POSITION→POS-POSITION
—→POS-EFFECT-DATE
PtfpositionPAPOSITIONValid When PTF-FLD-NBR = 126
PTF-COMPANY→POS-COMPANY
PTF-FLD-VALUE→POS-POSITION
—→POS-EFFECT-DATE
Work SchedHRWRKSCHD
PTF-COMPANY→WSC-COMPANY
EMP-WORK-SCHED→WSC-WORK-SCHED
—→WSC-CONTRACT-YEAR
—→WSC-EFFECT-DATE

Programs

Updated by (34)

Referenced by (193)