Lawson Insight Technical Documentation |
|
PWEMPLY
PWEMPLY FILE
UPDATED BY
HR07.1 HR11.1 HR11.2 HR507 HR511 HR650
PA02.1 PA100 PA102 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 HR07.1 HR11.1
Element: Company The company number represents an HR11.2 HR507
established company and is entered on HR511 HR650
all function codes. PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Process Level This field contains the process level, HR11.2 HR507
which is the reporting hierarchy below HR511 HR650
company. PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Department Contains the department. HR11.2 HR507
HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Employee Contains the employee number. Each HR11.2 HR507
person employed by the company is HR511 HR650
assigned a unique number. The system PA02.1 PA100
uses the employee number to correlate PA102 PA13.1
all of the information related to that PA13.2 PA502
person. 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 HR07.1 HR11.1
Element: Employee Name HR11.2 HR507
HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Loc Code Desc HR11.2 HR507
HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Work Telephone HR11.2 HR507
Extension HR511 HR650
PA02.1 PA100
PA102 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) HR07.1 HR11.1
Element: Email Address HR11.2 HR507
HR511 HR650
PA02.1 PA100
PA102 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) HR07.1 HR11.1
Element: Hire Date HR11.2 HR507
HR511 HR650
PA02.1 PA100
PA102 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) HR07.1 HR11.1
Element: Termination Date HR11.2 HR507
HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Concat Cmp Au HR11.2 HR507
HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Job Code Contains a user-defined code that HR11.2 HR507
represents a type of job. HR511 HR650
PA02.1 PA100
PA102 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) HR07.1 HR11.1
Element: Job Code Desc HR11.2 HR507
HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Supervisor HR11.2 HR507
HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Supervisor Emp HR11.2 HR507
HR511 HR650
PA02.1 PA100
PA102 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: Standard 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 HR07.1 HR11.1
Element: Rate of Pay HR11.2 HR507
HR511 HR650
PA02.1 PA100
PA102 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 4.3 HR07.1 HR11.1
Full Time HR11.2 HR507
Equivalent Number HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Annual Hours HR11.2 HR507
HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Salary Class H = Hourly HR11.2 HR507
S = Salary HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Numeric 1 HR11.2 HR507
HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Supervisor This field contains a valid stocking HR11.2 HR507
location within the company inventory. HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Shift Contains the shift number associated HR11.2 HR507
with the pay. HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Position Contains the user-defined code that HR11.2 HR507
represents a position in the company. HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Grade HR11.2 HR507
HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Automatic Time HR11.2 HR507
Record HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Bargaining Unit HR11.2 HR507
HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Union Code HR11.2 HR507
HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Step HR11.2 HR507
HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Currency Code This field contains the company base HR11.2 HR507
currency code established in Company HR511 HR650
(GL10.1 ). PA02.1 PA100
PA102 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) HR07.1 HR11.1
Element: First Name Contains the first name of the manager HR11.2 HR507
in charge. HR511 HR650
PA02.1 PA100
PA102 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) HR07.1 HR11.1
Element: Name HR11.2 HR507
HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Middle InitialContains the middle initial of the HR11.2 HR507
manager in charge. HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Country Code The country code. Required for VAT and HR11.2 HR507
intrastat reporting. Must be defined in HR511 HR650
IN01.1 (Country Maintenance). PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Status The Active flag of the credit card HR11.2 HR507
type. HR511 HR650
PA02.1 PA100
PA102 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) HR07.1 HR11.1
Element: Date HR11.2 HR507
HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Schedule HR11.2 HR507
HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
Element: Employee StatuThis field displays the status of the HR11.2 HR507
transaction. HR511 HR650
PA02.1 PA100
PA102 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 HR07.1 HR11.1
EMPLOYEE HR11.2 HR507
HR511 HR650
PA02.1 PA100
PA102 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
|