PWEMPLY – No description in the Lawson data dictionary

System
PW (PW)
Prefix
PW4
Primary key
COMPANY, EMPLOYEE
Fields
20
Updated by
34 programs
Referenced by
0 programs

PWEMPLY is a Lawson PW table (prefix PW4); no description in the lawson data dictionary. It is indexed by COMPANY, EMPLOYEE (PW4SET1). It is updated by BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 and 26 more. The table has 20 fields, 1 index and 0 documented relations.

About PWEMPLY

No description in the Lawson data dictionary.

Fields (20)

Column = COBOL field name without the PW4- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored. PK = primary key (present in every index); SETn = leading/alternate key of that index.

Field / columnTypeDescription & valuesUpdated by
#PW4-COMPANY PK
COMPANY		Numeric 4Identifies the AP company if the resource type = V. Identifies the HR company if the resource type = E. It is blank for type A, P or Q resources.BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 +26 more
#PW4-PROCESS-LEVEL
PROCESS_LEVEL		Alpha 5This field contains the process level, which is the reporting hierarchy below company.BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 +26 more
#PW4-DEPARTMENT
DEPARTMENT		Alpha 5Contains the department.BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 +26 more
#PW4-EMPLOYEE PK
EMPLOYEE		Numeric 9Contains the employee number. Each person employed by the company is assigned a unique number. The system uses the employee number to correlate all of the information related to that person.BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 +26 more
#PW4-EMPLOYEE-NAME
EMPLOYEE_NAME		Alpha 49—BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 +26 more
#PW4-LOC-CODE-DESC
LOC_CODE_DESC		Alpha 40—BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 +26 more
#PW4-WK-PHONE-EXT
WK_PHONE_EXT		Alpha 5—BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 +26 more
#PW4-EMAIL-ADDRESS
EMAIL_ADDRESS		Alpha 60 (Lower Case)e-mail address.BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 +26 more
#PW4-DATE-HIRED
DATE_HIRED		Numeric 8 (yyyymmdd)—BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 +26 more
#PW4-TERM-DATE
TERM_DATE		Numeric 8 (yyyymmdd)—BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 +26 more
#PW4-CONCAT-CMP-AU
CONCAT_CMP_AU		Alpha 20—BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 +26 more
#PW4-JOB-CODE
JOB_CODE		Alpha 9Contains a user-defined code that represents a type of job.BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 +26 more
#PW4-JOB-CODE-DESC
JOB_CODE_DESC		Alpha 30 (Lower Case)—BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 +26 more
#PW4-SUPERVISOR
SUPERVISOR		Alpha 10—BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 +26 more
#PW4-SUPERVISOR-EMP
SUPERVISOR_EMP		Numeric 9—BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 +26 more
#PW4-STAND-HOURS
STAND_HOURS		Signed 7.2—HR11.1, HR11.2, HR11.4, PA02.1, PA13.1, PA13.2, PA52.1, PA52.3 +9 more
#PW4-PAY-RATE
PAY_RATE		Signed 13.4—BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 +26 more
#PW4-NBR-FTE
NBR_FTE		Signed 7.6—BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 +26 more
#PW4-ANNUAL-HOURS
ANNUAL_HOURS		Signed 8.4—BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 +26 more
#PW4-SALARY-CLASS
SALARY_CLASS		Alpha 1—BN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 +26 more

Indexes (1)

Keys are listed in index order; ↓ marks a descending key. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

IndexKeysFlagsConditionUsed in
PW4SET1
  1. COMPANY
  2. EMPLOYEE
PrimaryBN305, HR07.1, HR11.1, HR11.2, HR11.4, HR28.1, HR507, HR511 +22 more (list truncated in source)

Programs

Updated by (34)