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 HR700 HRS1.1 HRSC.1 PA16.1 PA20.1
PA21.1 PA22.1 PA24.1 PA248 PA249 PA272
PA34.1 PA35.1 PA36.1 PA370 PA38.1 PA42.1
PA520 PA53.1 PA54.1 PA66.3 TR21.1 TR22.1
TR500 HC01.1 HC02.1 HCEM.1 HCOP.1 HR00.1
HR01.1 HR06.1 HR06.2 HR07.1 HR207 HR507
PA149 PA213 PA219 PA95.1 TR114 TR121
PBIP.1 PR110 PR128 PR16.1 PR21.1 PR216
PR33.2 PR33.3 HR04.2 HR04.3 HR04.7 HR04.8
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.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 HS10.1 HS12.1 HS13.1
HS15.1 HS22.1 HS22.2
UPDATED BY
HR11.1 HR511 PA02.1 PA100 PA102 PA120
PA13.1 PA13.2 PA502 PA513 PA52.1 PA52.3
PA52.4 PA52.5 PR13.1 PA115 PA302
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PTF-COMPANY Numeric 4 HR11.1 HR511
Company Contains the company number. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PTF-EMPLOYEE Numeric 9 HR11.1 HR511
Employee Contains the employee number. An PA02.1 PA100
employee number is assigned to each PA102 PA13.1
person employed by the company. The PA13.2 PA502
system uses the employee number to PA513 PA52.1
correlate all information related to the PA52.3 PA52.4
employee. PA52.5 PR13.1
PTF-FLD-NBR Numeric 4 HR11.1 HR511
Dictionary Field Contains the field number from the HR PA02.1 PA100
Number Systems Data Dictionary file for the PA102 PA13.1
data item represented by this record. PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PTF-FLD-VALUE Alpha 12 HR11.1 HR511
Field Value Contains the field value for the record. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PTF-LAST-NAME Alpha 30 (Lower Case) HR11.1 HR511
Last Name Contains the employee's last name. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PTF-FIRST-NAME Alpha 15 (Lower Case) HR11.1 HR511
First Name Contains the employee's first name. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PTF-MIDDLE-INIT Alpha 1 HR11.1 HR511
Middle Initial Contains the employee's middle initial. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PTF-POS-LEVEL Numeric 2 HR11.1 HR511
Pos Level Contains the position level. PA02.1 PA100
PA102 PA13.1
PA13.2 PA502
PA513 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PTF-FULL-NAME Derived
Full Name
PTF-WORK-DESC Derived
Work Desc
PATHFIND FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PTFSET1 COMPANY HR11.1 HR15.1
EMPLOYEE HR155 HR170
FLD-NBR HR211 HR511
POS-LEVEL HR54.1 HR55.2
HR70.1 HR700
HRS1.1 HRSC.1
PA02.1 PA100
PA102 PA115
PA120 PA13.1
PA13.2 PA16.1
PA20.1 PA21.1
PA22.1 PA24.1
PA248 PA249
PA272 PA34.1
PA35.1 PA36.1
...
PTFSET2 COMPANY KeyChange HC01.1 HC02.1
FLD-NBR HCEM.1 HCOP.1
FLD-VALUE HR00.1 HR01.1
EMPLOYEE HR06.1 HR06.2
POS-LEVEL HR07.1 HR170
HR207 HR507
HR70.1 PA100
PA149 PA213
PA219 PA249
PA302 PA95.1
TR114 TR121
PBIP.1 PR110
PR128 PR16.1
PR21.1 PR216
PR33.2
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 ) HR80.1 HR80.2
EMPLOYEE Or (FLD-NBR = 21 ) HR80.3 HR80.4
POS-LEVEL 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.8 HR82.9
...
PTFSET5 COMPANY KeyChange, Subset HS10.1 HS12.1
FLD-NBR Where POS-LEVEL = 1 HS13.1 HS15.1
FLD-VALUE HS22.1 HS22.2
LAST-NAME
FIRST-NAME
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
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
Pa Employee PAEMPLOYEE Required
PTF-COMPANY -> PEM-COMPANY
PTF-EMPLOYEE -> PEM-EMPLOYEE
Position PAPOSITION Not Required
PTF-COMPANY -> POS-COMPANY
EMP-POSITION -> POS-POSITION
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
|