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.

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

IndexKeysFlagsConditionUsed in
PTFSET1COMPANY, EMPLOYEE, FLD-NBR, POS-LEVELPrimaryBN305, HAP3.1, HCRE.1, HEP4.1, HPOS.1, HPQC.1, HPRS.1, HR11.1 +22 more (list truncated in source)
PTFSET2COMPANY, FLD-NBR, FLD-VALUE, EMPLOYEE, POS-LEVELKeyChangeBN320, HC01.2, HCDL.1, HCEM.1, HR00.1, HR00.2, HR00.3, HR01.1 +22 more (list truncated in source)
PTFSET3COMPANY, FLD-NBR, FLD-VALUE, LAST-NAME, FIRST-NAME, MIDDLE-INIT, EMPLOYEE, POS-LEVELKeyChange, SubsetWhere (FLD-NBR = 14) Or (FLD-NBR = 15) Or (FLD-NBR = 16)HR02.1, PR33.3
PTFSET4FLD-NBR, FLD-VALUE, COMPANY, EMPLOYEE, POS-LEVELKeyChange, 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)
PTFSET5COMPANY, FLD-NBR, FLD-VALUE, LAST-NAME, FIRST-NAME, MIDDLE-INIT, EMPLOYEEKeyChange, SubsetWhere POS-LEVEL = 1HS10.1, HS10.2, HS12.1, HS12.2, HS13.1, HS13.2, HS15.1, HS52.1 +5 more

Relations

One to one (10) — lookups and parents

RelationTableRulesConditionField map
Bargain UnitPCODESRequired"BU" → PCO-TYPE, PEM-BARGAIN-UNIT → PCO-CODE
CompanyPRSYSTEMRequiredPTF-COMPANY → PRS-COMPANY, Spaces → PRS-PROCESS-LEVEL
DepartmentDEPTCODENot RequiredPTF-COMPANY → DPT-COMPANY, EMP-PROCESS-LEVEL → DPT-PROCESS-LEVEL, EMP-DEPARTMENT → DPT-DEPARTMENT
EmployeeEMPLOYEERequiredPTF-COMPANY → EMP-COMPANY, PTF-EMPLOYEE → EMP-EMPLOYEE
EmstatusEMSTATUSNot RequiredPTF-COMPANY → EMS-COMPANY, EMP-EMP-STATUS → EMS-EMP-STATUS
JobcodeJOBCODENot RequiredPTF-COMPANY → JBC-COMPANY, EMP-JOB-CODE → JBC-JOB-CODE
LocationPCODESNot Required"LO" → PCO-TYPE, PEM-LOCAT-CODE → PCO-CODE
Pa EmployeePAEMPLOYEERequiredPTF-COMPANY → PEM-COMPANY, PTF-EMPLOYEE → PEM-EMPLOYEE
PtfjobcodeJOBCODERequiredWhen PTF-FLD-NBR = 19PTF-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
HrsuperHRSUPERPTF-COMPANY → HSU-COMPANY, PTF-EMPLOYEE → HSU-EMPLOYEE, → HSU-CODE
PaempposPAEMPPOSPTF-COMPANY → PEP-COMPANY, PTF-EMPLOYEE → PEP-EMPLOYEE, PTF-POS-LEVEL → PEP-POS-LEVEL, → PEP-EFFECT-DATE
PositionPAPOSITIONPTF-COMPANY → POS-COMPANY, EMP-POSITION → POS-POSITION, → POS-EFFECT-DATE
PtfpositionPAPOSITIONValid When PTF-FLD-NBR = 126PTF-COMPANY → POS-COMPANY, PTF-FLD-VALUE → POS-POSITION, → POS-EFFECT-DATE
Work SchedHRWRKSCHDPTF-COMPANY → WSC-COMPANY, EMP-WORK-SCHED → WSC-WORK-SCHED, → WSC-CONTRACT-YEAR, → WSC-EFFECT-DATE

Programs

Updated by (34)

Referenced by (193)