PWEMPLY FILE
UPDATED BY
BN305 ET700 HR07.1 HR11.1 HR11.2 HR507
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
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PW4-COMPANY Numeric 4 BN305 ET700
Element: Company HR07.1 HR11.1
HR11.2 HR507
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
PW4-PROCESS-LEVEL Alpha 5 BN305 ET700
Element: Process Level HR07.1 HR11.1
HR11.2 HR507
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
PW4-DEPARTMENT Alpha 5 BN305 ET700
Element: Department HR07.1 HR11.1
HR11.2 HR507
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
PW4-EMPLOYEE Numeric 9 BN305 ET700
Element: Employee HR07.1 HR11.1
HR11.2 HR507
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
PW4-EMPLOYEE-NAME Alpha 49 BN305 ET700
Element: Employee Name HR07.1 HR11.1
HR11.2 HR507
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
PW4-LOC-CODE-DESC Alpha 40 BN305 ET700
Element: Loc Code Desc HR07.1 HR11.1
HR11.2 HR507
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
PW4-WK-PHONE-EXT Alpha 5 BN305 ET700
Element: Wk Phone Ext HR07.1 HR11.1
HR11.2 HR507
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
PW4-EMAIL-ADDRESS Alpha 60 (Lower Case) BN305 ET700
Element: Email Address HR07.1 HR11.1
HR11.2 HR507
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
PW4-DATE-HIRED Numeric 8 (yyyymmdd) BN305 ET700
Element: Date Hired HR07.1 HR11.1
HR11.2 HR507
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
PW4-TERM-DATE Numeric 8 (yyyymmdd) BN305 ET700
Element: Term Date HR07.1 HR11.1
HR11.2 HR507
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
PW4-CONCAT-CMP-AU Alpha 20 BN305 ET700
Element: Concat Cmp Au HR07.1 HR11.1
HR11.2 HR507
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
PW4-JOB-CODE Alpha 9 BN305 ET700
Element: Job Code HR07.1 HR11.1
HR11.2 HR507
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
PW4-JOB-CODE-DESC Alpha 30 (Lower Case) BN305 ET700
Element: Job Code Desc HR07.1 HR11.1
HR11.2 HR507
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
PW4-SUPERVISOR Alpha 10 BN305 ET700
Element: Supervisor HR07.1 HR11.1
HR11.2 HR507
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
PW4-SUPERVISOR-EMP Numeric 9 BN305 ET700
Element: Supervisor Emp HR07.1 HR11.1
HR11.2 HR507
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
PW4-STAND-HOURS Signed 7.2 HR11.1 HR11.2
Element: Stand Hours PA02.1 PA13.1
PA13.2 PA52.1
PA52.3 PA52.4
PA52.5 PR13.1
PR13.5 PR13.6
PR13.8
PW4-PAY-RATE Signed 13.4 BN305 HR07.1
Element: Pay Rate HR11.1 HR11.2
HR507 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
PW4-NBR-FTE Signed 7.6 BN305 ET700
Element: Nbr Fte HR07.1 HR11.1
HR11.2 HR507
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
PW4-ANNUAL-HOURS Numeric 4 BN305 ET700
Element: Annual Hours HR07.1 HR11.1
HR11.2 HR507
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
PW4-SALARY-CLASS Alpha 1 BN305 HR07.1
Element: Salary Class H = Hourly HR11.1 HR11.2
S = Salary HR507 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
PW4-GROUP-ID Numeric 10 BN305 ET700
Element: Numeric 1 HR07.1 HR11.1
HR11.2 HR507
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
PW4-LOCATION Alpha 10 BN305 ET700
Element: Supervisor HR07.1 HR11.1
HR11.2 HR507
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
PW4-SHIFT Numeric 1 BN305 ET700
Element: Shift HR07.1 HR11.1
HR11.2 HR507
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
PW4-POSITION Alpha 12 BN305 ET700
Element: Position HR07.1 HR11.1
HR11.2 HR507
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
PW4-PAY-GRADE Alpha 3 BN305 ET700
Element: Pay Grade HR07.1 HR11.1
HR11.2 HR507
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
PW4-AUTO-TIME-REC Alpha 1 BN305 ET700
Element: Auto Time Rec HR07.1 HR11.1
HR11.2 HR507
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
PW4-BARGAIN-UNIT Alpha 10 BN305 ET700
Element: Bargain Unit HR07.1 HR11.1
HR11.2 HR507
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
PW4-UNION-CODE Alpha 10 BN305 ET700
Element: Union Code HR07.1 HR11.1
HR11.2 HR507
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
PW4-PAY-STEP Numeric 2 BN305 ET700
Element: Pay Step HR07.1 HR11.1
HR11.2 HR507
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
PW4-CURRENCY-CODE Alpha 5 BN305 ET700
Element: Currency Code HR07.1 HR11.1
HR11.2 HR507
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
PW4-FIRST-NAME Alpha 15 (Lower Case) BN305 ET700
Element: First Name HR07.1 HR11.1
HR11.2 HR507
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
PW4-LAST-NAME Alpha 30 (Lower Case) BN305 ET700
Element: Name HR07.1 HR11.1
HR11.2 HR507
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
PW4-MIDDLE-INIT Alpha 1 BN305 ET700
Element: Middle Init HR07.1 HR11.1
HR11.2 HR507
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
PW4-COUNTRY-CODE Alpha 2 BN305 ET700
Element: Country Code HR07.1 HR11.1
HR11.2 HR507
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
PW4-ACTIVE-FLAG Alpha 1 BN305 HR07.1
Element: Active Flag HR11.1 HR11.2
HR507 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
PW4-ADJ-HIRE-DATE Numeric 8 (yyyymmdd) BN305 ET700
Element: Date HR07.1 HR11.1
HR11.2 HR507
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
PW4-SCHEDULE Alpha 9 BN305 ET700
Element: Schedule HR07.1 HR11.1
HR11.2 HR507
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
PW4-STATUS Alpha 2 BN305 ET700
Element: Emp Status HR07.1 HR11.1
HR11.2 HR507
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
PWEMPLY FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PW4SET1 COMPANY BN305 ET700
EMPLOYEE HR07.1 HR11.1
HR11.2 HR507
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
|