PWSELECT – HR Writer Selection Criteria

System
Human Resources (HR)
Prefix
PWS
Primary key
AUTHOR-NAME, TITLE-NBR, SELECT-TYPE, SEQ-NBR
Fields
11
Updated by
7 programs
Referenced by
3 programs

PWSELECT is the HR Writer Selection Criteria table in Lawson Human Resources (prefix PWS). It is indexed by AUTHOR-NAME, TITLE-NBR, SELECT-TYPE, SEQ-NBR (PWSSET1); alternate indexes: PWSSET2 and PWSSET3. It is related 1:1 to PWAUTHOR and PADICT. It is updated by HR64.1, HR65.1, HR65.2, HR65.5, HR65.6, HR65.7 and HR65.8 and referenced by HR170, HR70.1 and HR710. The table has 11 fields, 3 indexes and 2 documented relations.

About PWSELECT

Contains the detail and population selection criteria used by HR170 (HR Writer Report Request) and HR70 (HR Writer Inquiry).

Fields (11)

Column = COBOL field name without the PWS- 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
#PWS-AUTHOR-NAME PK
AUTHOR_NAME		Alpha 10Contains the author name under which the selection criteria for the report is defined. This field is validated in the HR Report Writer Author file.HR65.6, HR65.8
#PWS-TITLE-NBR PK
TITLE_NBR		Numeric 4Contains the sequentially assigned title number, by author, for the selection criteria. The title number is stored in the HR Report Writer Title file.HR64.1, HR65.6, HR65.8
#PWS-SELECT-TYPE PK
SELECT_TYPE		Alpha 1Indicates the type of selection criteria, detail or population.
  • D Detail Data
  • P Population
HR65.6, HR65.8
#PWS-SEQ-NBR PK
SEQ_NBR		Numeric 4Contains the sequence number that keeps each record unique in the file.HR65.6, HR65.8
#PWS-FLD-NBR SET2 SET3
FLD_NBR		Numeric 4Contains the data dictionary field number.HR65.6, HR65.8
#PWS-INC-EXC-FLAG
INC_EXC_FLAG		Alpha 1Determines if the application includes or excludes the records that meet the defined criteria.
  • E Exclude
  • I Include
HR65.6, HR65.8
#PWS-BEG-VALUE
BEG_VALUE		Alpha 25Contains the beginning value of the selection range.HR170, HR65.6, HR65.8, HR70.1
#PWS-THRU-VALUE
THRU_VALUE		Alpha 25Contains the ending value of the selection range.HR170, HR65.6, HR65.8, HR70.1
#PWS-ITEM-GRP SET3
ITEM_GRP		Alpha 2Contains the item group. All selection lines that have a common item group are treated as an "and" condition. That is, the employee or applicant must meet the criteria of all the selection lines that have a common item group identifier in order to appear on the report. Different item groups are treated as an "or" condition. That is, an employee or applicant needs to meet all of the criteria in only one of the item groups to appear on the report.HR65.6, HR65.8
#PWS-BEG-NEG
BEG_NEG		Alpha 1Indicates whether the beginning value is a negative number.—
#PWS-END-NEG
END_NEG		Alpha 1Indicates whether the ending value is a negative number.—

Indexes (3)

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
PWSSET1
  1. AUTHOR-NAME
  2. TITLE-NBR
  3. SELECT-TYPE
  4. SEQ-NBR
PrimaryHR170, HR64.1, HR65.1, HR65.2, HR65.6, HR65.8, HR710
PWSSET2
  1. AUTHOR-NAME
  2. TITLE-NBR
  3. SELECT-TYPE
  4. FLD-NBR
  5. SEQ-NBR
KeyChangeHR65.5, HR65.6, HR65.7, HR65.8, HR70.1
PWSSET3
  1. AUTHOR-NAME
  2. TITLE-NBR
  3. SELECT-TYPE
  4. ITEM-GRP
  5. FLD-NBR
  6. SEQ-NBR
KeyChangeHR170, HR65.6, HR65.8, HR70.1

Relations

Relationship map — 1:1 lookups/parents on the left, 1:M children on the right (up to 14 each)
PWAUTHORPADICTPWSELECT

One to one (2) — lookups and parents

RelationTableRulesConditionField map
AuthorPWAUTHORRequired
PWS-AUTHOR-NAME→PWA-AUTHOR-NAME
Fld NbrPADICTRequiredWhen PWS-FLD-NBR != Zeroes
PWS-FLD-NBR→PAD-FLD-NBR

Programs

Updated by (7)

Referenced by (3)