PWCOMPUTE

HR Writer Compute Statements

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.

REFERENCED BY
HR170 HR70.1 HR70.2 HR70.3 HR60.1


UPDATED BY
HR65.2 HR67.1

FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
PWC-AUTHOR-NAME
Element: Author
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
Element: Compute 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
Element: 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
Element: Item
Numeric 4
Contains the item number if the first factor of the compute statement is a data dictionary item.
HR67.1
PWC-TOPIC1
Element: Topic1
Alpha 2
Contains the topic with which the first selected item in the compute statement is associated.
HR67.1
PWC-DB-FILE1
Element: 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
Element: Value
Signed 11.4
Contains the value of the constant if the first factor of the compute statement is a constant.
HR67.1
PWC-COLUMN1
Element: Column Heading 1
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
Element: 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
Element: 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
Element: 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
Element: Operator 1
Alpha 1
Contains the mathematical operation performed on factors 1 and 2.
* = Multiply
+ = Add
- = Subtract
/ = Divide
HR67.1
PWC-FLD-NBR2
Element: Item
Numeric 4
Contains the item number if the second factor of the compute statement is a data dictionary item.
HR67.1
PWC-TOPIC2
Element: Topic2
Alpha 2
Contains the topic with which the second selected item in the compute statement is associated.
HR67.1
PWC-DB-FILE2
Element: 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
Element: Value
Signed 11.4
Contains the value of the constant if the second factor of the compute statement is a constant.
HR67.1
PWC-COLUMN2
Element: Column Heading 2
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
Element: 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
Element: 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
Element: 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
Element: Operator 2
Alpha 1
Contains the mathematical operation performed on factors 2 and 3.
* = Multiply
+ = Add
- = Subtract
/ = Divide
HR67.1
PWC-FLD-NBR3
Element: Item
Numeric 4
Contains the item number if the third factor of the compute statement is a data dictionary item.
HR67.1
PWC-TOPIC3
Element: Topic3
Alpha 2
Contains the topic with which the third selected data item for the compute statement is associated.
HR67.1
PWC-DB-FILE3
Element: 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
Element: Value
Signed 11.4
Contains the value of the constant if the third factor of the compute statement is a constant.
HR67.1
PWC-COLUMN3
Element: Column Heading 3
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
Element: 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
Element: 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
Element: 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
Element: 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
Element: Header Size
Numeric 2
Contains the number of characters in the largest header.
HR67.1
PWC-FIRST-OPER
Element: First Operator
Numeric 1
Identifies the mathematical operation that is performed first if the compute statement includes 2 operations.
HR67.1
PWC-MIN-SIZE
Element: 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


PWCOMPUTE FILE INDEX

NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
PWCSET1 AUTHOR-NAME
COLUMN-NAME
HR60.1 HR65.2
HR67.1
PWCSET2 AUTHOR-NAME
COMPUTE-NBR
HR170 HR65.2
HR65.3 HR70.1
HR70.2 HR70.3


PWCOMPUTE FILE RELATIONS


ONE TO ONE RELATIONS

RELATION
NAME
RELATED FILE INTEGRITY RULES / FIELD MATCH
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


File created: Thu Jun 09 11:15:36 2016

Home
Contact Us



All trademarks and registered trademarks are the property of their respective owners.