PATHFIND

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 HCRE.1 HEP4.1 HPOS.1 HPQC.1 HPRS.1
HR15.1 HR155 HR156 HR170 HR211 HR515
HR54.1 HR55.2 HR70.1 HRS1.1 HRSC.1 LT11.5
LT13.5 ZH156 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 PR21.4 PR521
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 HR92.1 HR92.2
HR92.3


UPDATED BY
BN305 HR11.1 HR11.2 HR11.4 HR28.1 HR511
LT101 LT111 ZH510 PA02.1 PA100 PA102
PA115 PA120 PA13.1 PA13.2 PA502 PA513
PA52.1 PA52.3 PA52.4 PA52.5 PR110 PR113
PR12.6 PR120 PR13.1 PR13.5 PR13.6 PR13.8
PR13.9 PR30.2 PR512 PA302

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PTF-COMPANY
Element: Company Hr		Numeric 4
Contains the company number.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
PTF-EMPLOYEE
Element: Employee		Numeric 9
Contains 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
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
PTF-FLD-NBR
Element: Fld Nbr		Numeric 4
Contains 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
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
PTF-FLD-VALUE
Element: Fld Value		Alpha 12
Contains the field value for the record.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
PTF-LAST-NAME
Element: Last Name		Alpha 30 (Lower Case)
Contains the employee's last name.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
PTF-FIRST-NAME
Element: First Name		Alpha 15 (Lower Case)
Contains the employee's first name.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
PTF-MIDDLE-INIT
Element: Middle Init		Alpha 1
Contains the employee's middle initial.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
PTF-POS-LEVEL
Element: Pos Level		Numeric 2
Contains the position level.
BN305 HR11.1
HR11.2 HR11.4
HR28.1 HR511
LT101 LT111
PA02.1 PA100
PA102 PA115
PA13.1 PA13.2
PA502 PA513
PA52.1 PA52.3
PA52.4 PA52.5
PR110 PR113
PR12.6 PR120
PR13.1 PR13.5
PR13.6 PR13.8
PR13.9 PR30.2
PR512 ZH510
PTF-FULL-NAME
Element: Full Name		Derived
PTF-LABEL-NAME-1
Element: Label Name 1		Derived


PATHFIND FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PTFSET1 COMPANY
EMPLOYEE
FLD-NBR
POS-LEVEL
...
BN305 HAP3.1
HCRE.1 HEP4.1
HPOS.1 HPQC.1
HPRS.1 HR11.1
HR11.2 HR11.3
HR11.4 HR15.1
HR155 HR156
HR170 HR211
HR28.1 HR511
HR515 HR54.1
HR55.2 HR70.1
HRS1.1 HRSC.1
LT101 LT11.5
LT111 LT13.5
ZH156 ZH510
PTFSET2 COMPANY
FLD-NBR
FLD-VALUE
EMPLOYEE
POS-LEVEL
KeyChange
...
BN320 HC01.2
HCDL.1 HCEM.1
HR00.1 HR00.2
HR00.3 HR01.1
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
LT101 LT111
PR21.1 PR21.4
PR521 LP260
PTFSET3 COMPANY
FLD-NBR
FLD-VALUE
LAST-NAME
FIRST-NAME
MIDDLE-INIT
EMPLOYEE
POS-LEVEL
KeyChange, Subset
Where(FLD-NBR =14)
Or(FLD-NBR =15)
Or(FLD-NBR =16)
HR02.1 PR33.3
PTFSET4 FLD-NBR
FLD-VALUE
COMPANY
EMPLOYEE
POS-LEVEL
KeyChange, Subset
Where(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
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
FLD-NBR
FLD-VALUE
LAST-NAME
FIRST-NAME
MIDDLE-INIT
EMPLOYEE
KeyChange, Subset
WherePOS-LEVEL =1
HS10.1 HS10.2
HS12.1 HS12.2
HS13.1 HS13.2
HS15.1 HS52.1
HS52.2 HS22.1
HS22.2 HS22.3
PR113


PATHFIND FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME		 RELATED 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
NAME		 RELATED FILE INTEGRITY RULES / FIELD MATCH
Hrsuper HRSUPER
PTF-COMPANY->HSU-COMPANY
PTF-EMPLOYEE->HSU-EMPLOYEE
  HSU-CODE
Paemppos PAEMPPOS
PTF-COMPANY->PEP-COMPANY
PTF-EMPLOYEE->PEP-EMPLOYEE
PTF-POS-LEVEL->PEP-POS-LEVEL
  PEP-EFFECT-DATE
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-CONTRACT-YEAR
  WSC-EFFECT-DATE

File created: Thu Jun 09 02:16:49 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.