Lawson Insight Technical Documentation |
|
PWEMPLY
PWEMPLY FILE
UPDATED BY
HR07.1 HR11.1 HR11.2 HR507 HR511 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 Identifies the AP company if the HR11.2 HR507
resource type = V. Identifies the HR HR511 PA02.1
company if the resource type = E. It is PA100 PA102
blank for type A, P or Q resources. 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 PA02.1
company. 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 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 PA02.1
assigned a unique number. The system PA100 PA102
uses the employee number to correlate PA13.1 PA13.2
all of the information related to that PA502 PA513
person. 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 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 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 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 e-mail address. HR11.2 HR507
HR511 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 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 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 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 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 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 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 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 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 7.6 HR07.1 HR11.1
Full Time HR11.2 HR507
Equivalent Number HR511 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 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 HR11.2 HR507
HR511 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 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
|