Lawson Insight Technical Documentation |
|
PATHFIND
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
HAP3.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1 HR15.1
HR155 HR170 HR211 HR515 HR54.1 HR55.2
HR70.1 HRS1.1 HRSC.1 LP100 LP101 PA103
PA113 PA16.1 PA20.1 PA21.1 PA22.1 PA24.1
PA248 PA249 PA27.1 PA272 PA311 PA34.1
PA35.1 PA36.1 PA370 PA38.1 PA42.1 PA520
PA53.1 PA54.1 PA66.3 TR21.1 TR22.1 TR26.1
TR500 HS36.1 BN320 HC01.2 HCDL.1 HCEM.1
HR00.1 HR00.2 HR00.3 HR01.1 HR02.1 HR06.1
HR06.2 HR07.1 HR207 HR21.1 HR217 HR221
HR506 HR507 HS10.1 HS10.2 PR21.1 LP260
LP262 HS12.1 HS12.2 HS13.1 HS13.2 HS15.1
HS52.1 HS52.2 PA149 PA213 PA218 PA219
PA95.1 TR114 TR121 HS22.1 HS22.2 HS22.3
PR128 PR136 PR16.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
HR89.8 HR89.9 HR91.7
UPDATED BY
BN305 HR11.1 HR11.2 HR511 PA02.1 PA100
PA102 PA115 PA120 PA13.1 PA13.2 PA502
PA513 PA52.1 PA52.3 PA52.4 PA52.5 PR110
PR113 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PA302
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PTF-COMPANY Numeric 4 BN305 HR11.1
Element: Company Hr Contains the company number. HR11.2 HR511
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PTF-EMPLOYEE Numeric 9 BN305 HR11.1
Element: Employee Contains the employee number. An HR11.2 HR511
employee number is assigned to each PA02.1 PA100
person employed by the company. The PA102 PA115
system uses the employee number to PA13.1 PA13.2
correlate all information related to the PA502 PA513
employee. PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PTF-FLD-NBR Numeric 4 BN305 HR11.1
Element: Fld Nbr Contains the field number from the HR HR11.2 HR511
Systems Data Dictionary file for the PA02.1 PA100
data item represented by this record. PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PTF-FLD-VALUE Alpha 12 BN305 HR11.1
Element: Fld Value Contains the field value for the record. HR11.2 HR511
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PTF-LAST-NAME Alpha 30 (Lower Case) BN305 HR11.1
Element: Last Name Contains the employee's last name. HR11.2 HR511
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PTF-FIRST-NAME Alpha 15 (Lower Case) BN305 HR11.1
Element: First Name Contains the employee's first name. HR11.2 HR511
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PTF-MIDDLE-INIT Alpha 1 BN305 HR11.1
Element: Middle Init Contains the employee's middle initial. HR11.2 HR511
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PTF-POS-LEVEL Numeric 2 BN305 HR11.1
Element: Pos Level Contains the position level. HR11.2 HR511
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR120 PR13.1
PR13.5 PR13.6
PR13.8
PTF-FULL-NAME Derived
Element: Full Name
PTF-WORK-DESC Derived
Element: Work Desc
PTF-LABEL-NAME-1 Derived
Element: Label Name 1
PATHFIND FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PTFSET1 COMPANY BN305 HAP3.1
EMPLOYEE HEP4.1 HPOS.1
FLD-NBR HPQC.1 HPRS.1
POS-LEVEL HR11.1 HR11.2
HR15.1 HR155
HR170 HR211
HR511 HR515
HR54.1 HR55.2
HR70.1 HRS1.1
HRSC.1 LP100
LP101 PA02.1
PA100 PA102
PA103 PA113
PA115 PA120
PA13.1 PA13.2
...
PTFSET2 COMPANY KeyChange BN320 HC01.2
FLD-NBR HCDL.1 HCEM.1
FLD-VALUE HR00.1 HR00.2
EMPLOYEE HR00.3 HR01.1
POS-LEVEL HR02.1 HR06.1
HR06.2 HR07.1
HR11.2 HR170
HR207 HR21.1
HR217 HR221
HR506 HR507
HR511 HR70.1
HS10.1 HS10.2
PR21.1 LP260
LP262 HS12.1
HS12.2 HS13.1
...
PTFSET3 COMPANY KeyChange, Subset HR02.1 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 HS12.2
FLD-VALUE HS13.1 HS13.2
LAST-NAME HS15.1 HS52.1
FIRST-NAME HS52.2 HS22.1
MIDDLE-INIT HS22.2 HS22.3
EMPLOYEE PR113
PATHFIND FILE RELATIONS
ONE TO ONE RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bargain Unit PCODES Required
"BU" -> PCO-TYPE
PEM-BARGAIN-UNIT -> PCO-CODE
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
Ptfjobcode JOBCODE Required
When PTF-FLD-NBR = 19
PTF-COMPANY -> JBC-COMPANY
PTF-FLD-VALUE -> JBC-JOB-CODE
Union PCODES Required
"UN" -> PCO-TYPE
EMP-UNION-CODE -> PCO-CODE
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
Ptfposition PAPOSITION
Valid When PTF-FLD-NBR = 126
PTF-COMPANY -> POS-COMPANY
PTF-FLD-VALUE -> POS-POSITION
POS-EFFECT-DATE
Work Sched HRWRKSCHD
PTF-COMPANY -> WSC-COMPANY
EMP-WORK-SCHED -> WSC-WORK-SCHED
WSC-EFFECT-DATE
|