 |
Lawson Insight Technical Documentation |
|
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
|