PWCOMPUTE – HR Writer Compute Statements

System: Human Resources (HR)
Prefix: PWC
Primary key: AUTHOR-NAME, COLUMN-NAME
Fields: 33
Updated by: 1 program
Referenced by: 7 programs

PWCOMPUTE is the HR Writer Compute Statements table in Lawson Human Resources (prefix PWC). It is indexed by AUTHOR-NAME, COLUMN-NAME (PWCSET1); alternate indexes: PWCSET2. It is related 1:1 to PWAUTHOR and PADICT. It is updated by HR67.1 and referenced by HR170, HR60.1, HR65.2, HR65.3, HR70.1, HR70.2 and HR70.3. The table has 33 fields, 2 indexes and 4 documented relations.

About PWCOMPUTE

Contains the compute statements used with the HR Writer Report Request. HR67.1 (HR Writer Compute Statements) is the primary program that updates this file.

Fields (33)

Column = COBOL field name without the PWC- prefix, hyphens → underscores. Derived fields are computed by the application and are not stored.

Field / column	Type	Description & values	Updated by
`PWC-AUTHOR-NAME` PK AUTHOR_NAME	Alpha 10	Contains the author responsible for this compute statement. The author name must be defined in the Author file.	HR67.1
`PWC-COLUMN-NAME` PK COLUMN_NAME	Alpha 20 (Lower Case)	Contains the compute statement name that is listed under the topic CM in HR65.2 (HR Writer Format Item Selection).	HR67.1
`PWC-COMPUTE-NBR` COMPUTE_NBR	Numeric 4	Contains the sequence number of the compute statement. A compute number is automatically assigned in sequential order by author.	HR67.1
`PWC-FLD-NBR1` FLD_NBR1	Numeric 4	Contains the item number if the first factor of the compute statement is a data dictionary item.	HR67.1
`PWC-TOPIC1` TOPIC1	Alpha 2	Contains the topic with which the first selected item in the compute statement is associated.	HR67.1
`PWC-DB-FILE1` DB_FILE1	Alpha 3	Contains the file prefix of the item if the first factor of the compute statement is a data dictionary item.	HR67.1
`PWC-CONSTANT1` CONSTANT1	Signed 11.4	Contains the value of the constant if the first factor of the compute statement is a constant.	HR67.1
`PWC-COLUMN1` COLUMN1	Numeric 2	Contains the column used if the first factor of the compute statement is one of the columns defined in the report. 01 15	HR67.1
`PWC-SIZE1` SIZE1	Numeric 2	Contains the size of the item if the first factor of the compute statement is a data dictionary item.	HR67.1
`PWC-DECIMALS1` DECIMALS1	Numeric 1	Contains the number of decimal places for the item if the first factor of the compute statement is a data dictionary item.	HR67.1
`PWC-PRT-TYPE1` PRT_TYPE1	Alpha 1	Contains the item's print type if the first factor of the compute statement is a data dictionary item.	HR67.1
`PWC-OPER1` OPER1	Alpha 1	Contains the mathematical operation performed on factors 1 and 2. + = Add `*` Multiply `-` Subtract `/` Divide	HR67.1
`PWC-FLD-NBR2` FLD_NBR2	Numeric 4	Contains the item number if the second factor of the compute statement is a data dictionary item.	HR67.1
`PWC-TOPIC2` TOPIC2	Alpha 2	Contains the topic with which the second selected item in the compute statement is associated.	HR67.1
`PWC-DB-FILE2` DB_FILE2	Alpha 3	Contains the file prefix of the item if the second factor of the compute statement is a data dictionary item.	HR67.1
`PWC-CONSTANT2` CONSTANT2	Signed 11.4	Contains the value of the constant if the second factor of the compute statement is a constant.	HR67.1
`PWC-COLUMN2` COLUMN2	Numeric 2	Contains the column used if the second factor of the compute statement is one of the columns defined in the report. 01 15	HR67.1
`PWC-SIZE2` SIZE2	Numeric 2	Contains the size of the item if the second factor of the compute statement is a data dictionary item.	HR67.1
`PWC-DECIMALS2` DECIMALS2	Numeric 1	Contains the number of decimal places for the item if the second factor of the compute statement is a data dictionary item.	HR67.1
`PWC-PRT-TYPE2` PRT_TYPE2	Alpha 1	Contains the item's print type if the second factor of the compute statement is a data dictionary item. (See the description of the HR Systems Data Dictionary file for information regarding print type.)	HR67.1
`PWC-OPER2` OPER2	Alpha 1	Contains the mathematical operation performed on factors 2 and 3. + = Add `*` Multiply `-` Subtract `/` Divide	HR67.1
`PWC-FLD-NBR3` FLD_NBR3	Numeric 4	Contains the item number if the third factor of the compute statement is a data dictionary item.	HR67.1
`PWC-TOPIC3` TOPIC3	Alpha 2	Contains the topic with which the third selected data item for the compute statement is associated.	HR67.1
`PWC-DB-FILE3` DB_FILE3	Alpha 3	Contains the file prefix of the item if the third factor of the compute statement is a dictionary item.	HR67.1
`PWC-CONSTANT3` CONSTANT3	Signed 11.4	Contains the value of the constant if the third factor of the compute statement is a constant.	HR67.1
`PWC-COLUMN3` COLUMN3	Numeric 2	Contains the column used if the third factor of the compute statement is one of the columns defined in the report. 01 15	HR67.1
`PWC-SIZE3` SIZE3	Numeric 2	Contains the size of the item if the third factor of the compute statement is a dictionary item.	HR67.1
`PWC-DECIMALS3` DECIMALS3	Numeric 1	Contains the number of decimal places for the item if the third factor of the compute statement is a data dictionary item.	HR67.1
`PWC-PRT-TYPE3` PRT_TYPE3	Alpha 1	Contains the item's print type if the third factor of the compute statement is a data dictionary item. (See the description of the HR Systems Data Dictionary file for information regarding print type.)	HR67.1
`PWC-HEADING` HEADING	Alpha 15 (Lower Case)	Occurs 2 Times Contains the user-defined column heading for the compute statement. You can enter up to two lines of text.	HR67.1
`PWC-HEADER-SIZE` HEADER_SIZE	Numeric 2	Contains the number of characters in the largest header.	HR67.1
`PWC-FIRST-OPER` FIRST_OPER	Numeric 1	Identifies the mathematical operation that is performed first if the compute statement includes 2 operations.	HR67.1
`PWC-MIN-SIZE` MIN_SIZE	Numeric 2	Contains the minimum field size. The column header defined for the field determines the minimum field size which is used to edit the minimum field sizes in HR65.3 (HR Writer Format Item Order).	HR67.1

Indexes (2)

Keys marked * are descending. Every documented Lawson index is unique unless flagged Duplicates; Subset indexes carry a Where condition.

Index	Keys	Flags	Condition	Used in
`PWCSET1`	`AUTHOR-NAME`, `COLUMN-NAME`	Primary		HR60.1, HR65.2, HR67.1
`PWCSET2`	`AUTHOR-NAME`, `COMPUTE-NBR`			HR170, HR65.2, HR65.3, HR70.1, HR70.2, HR70.3

Relations

One to one (4) — lookups and parents

Relation	Table	Rules	Condition	Field map
Author	PWAUTHOR	Required		`PWC-AUTHOR-NAME` → `PWA-AUTHOR-NAME`
Item Nbr1	PADICT	Required	When PWC-FLD-NBR1 != Zeroes	`PWC-FLD-NBR1` → `PAD-FLD-NBR`
Item Nbr2	PADICT	Required	When PWC-FLD-NBR2 != Zeroes	`PWC-FLD-NBR2` → `PAD-FLD-NBR`
Item Nbr3	PADICT	Required	When PWC-FLD-NBR3 != Zeroes	`PWC-FLD-NBR3` → `PAD-FLD-NBR`

Programs

Updated by (1)

HR67.1 Human Resource Writer Compute Statement

Referenced by (7)

HR170 Human Resource Writer Report Request
HR60.1 Human Resource Writer Authors
HR65.2 Human Resource Writer Format Item Selection
HR65.3 Human Resource Writer Format Item Order
HR70.1 Human Resource Writer Inquiry
HR70.2 Human Resource Writer Inquiry Window
HR70.3 Human Resource Writer Inquiry Window