PWCOMPUTE FILE 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 HR60.1 HR65.2 HR65.3 HR704 HR170 HR70.1 HR70.2 HR70.3 UPDATED BY HR67.1 FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY PWC-AUTHOR-NAME Alpha 10 HR67.1 Author Contains the author responsible for this compute statement. The author name must be defined in the Author file. PWC-COLUMN-NAME Alpha 20 (Lower Case) HR67.1 Compute Name Contains the compute statement name that is listed under the topic CM in HR65.2 (HR Writer Format Item Selection). PWC-COMPUTE-NBR Numeric 4 HR67.1 Compute Statement Contains the sequence number of the Number compute statement. A compute number is automatically assigned in sequential order by author. PWC-FLD-NBR1 Numeric 4 HR67.1 Item Contains the item number if the first factor of the compute statement is a data dictionary item. PWC-TOPIC1 Alpha 2 HR67.1 Topic1 Contains the topic with which the first selected item in the compute statement is associated. PWC-DB-FILE1 Alpha 3 HR67.1 Data Base File Contains the file prefix of the item if Prefix (1) the first factor of the compute statement is a data dictionary item. PWC-CONSTANT1 Signed 11.4 HR67.1 Value Contains the value of the constant if the first factor of the compute statement is a constant. PWC-COLUMN1 Numeric 2 HR67.1 Column Heading 1 Contains the column used if the first factor of the compute statement is one of the columns defined in the report. 01 15 PWC-SIZE1 Numeric 2 HR67.1 Size1 Contains the size of the item if the first factor of the compute statement is a data dictionary item. PWC-DECIMALS1 Numeric 1 HR67.1 Decimals1 Contains the number of decimal places for the item if the first factor of the compute statement is a data dictionary item. PWC-PRT-TYPE1 Alpha 1 HR67.1 Prt Type1 Contains the item's print type if the first factor of the compute statement is a data dictionary item. PWC-OPER1 Alpha 1 HR67.1 Operator 1 Contains the mathematical operation performed on factors 1 and 2. * = Multiply + = Add - = Subtract / = Divide PWC-FLD-NBR2 Numeric 4 HR67.1 Item Contains the item number if the second factor of the compute statement is a data dictionary item. PWC-TOPIC2 Alpha 2 HR67.1 Topic2 Contains the topic with which the second selected item in the compute statement is associated. PWC-DB-FILE2 Alpha 3 HR67.1 Data Base File Contains the file prefix of the item if Prefix (2) the second factor of the compute statement is a data dictionary item. PWC-CONSTANT2 Signed 11.4 HR67.1 Value Contains the value of the constant if the second factor of the compute statement is a constant. PWC-COLUMN2 Numeric 2 HR67.1 Column Heading 2 Contains the column used if the second factor of the compute statement is one of the columns defined in the report. 01 15 PWC-SIZE2 Numeric 2 HR67.1 Size2 Contains the size of the item if the second factor of the compute statement is a data dictionary item. PWC-DECIMALS2 Numeric 1 HR67.1 Decimals2 Contains the number of decimal places for the item if the second factor of the compute statement is a data dictionary item. PWC-PRT-TYPE2 Alpha 1 HR67.1 Prt Type2 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.) PWC-OPER2 Alpha 1 HR67.1 Operator 2 Contains the mathematical operation performed on factors 2 and 3. * = Multiply + = Add - = Subtract / = Divide PWC-FLD-NBR3 Numeric 4 HR67.1 Item Contains the item number if the third factor of the compute statement is a data dictionary item. PWC-TOPIC3 Alpha 2 HR67.1 Topic3 Contains the topic with which the third selected data item for the compute statement is associated. PWC-DB-FILE3 Alpha 3 HR67.1 Data Base File Contains the file prefix of the item if Prefix (3) the third factor of the compute statement is a dictionary item. PWC-CONSTANT3 Signed 11.4 HR67.1 Value Contains the value of the constant if the third factor of the compute statement is a constant. PWC-COLUMN3 Numeric 2 HR67.1 Column Heading 3 Contains the column used if the third factor of the compute statement is one of the columns defined in the report. 01 15 PWC-SIZE3 Numeric 2 HR67.1 Size3 Contains the size of the item if the third factor of the compute statement is a dictionary item. PWC-DECIMALS3 Numeric 1 HR67.1 Decimals3 Contains the number of decimal places for the item if the third factor of the compute statement is a data dictionary item. PWC-PRT-TYPE3 Alpha 1 HR67.1 Prt Type3 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.) PWC-HEADING Alpha 15 (Lower Case) HR67.1 Data Item Heading Occurs 2 Times Contains the user-defined column heading for the compute statement. You can enter up to two lines of text. PWC-HEADER-SIZE Numeric 2 HR67.1 HR Writer Column Contains the number of characters in Header Size the largest header. PWC-FIRST-OPER Numeric 1 HR67.1 First Operator Identifies the mathematical operation that is performed first if the compute statement includes 2 operations. PWC-MIN-SIZE Numeric 2 HR67.1 Minimum Size 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). PWCOMPUTE FILE INDEX NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN PWCSET1 AUTHOR-NAME HR60.1 HR65.2 COLUMN-NAME HR67.1 HR704 PWCSET2 AUTHOR-NAME HR170 HR65.2 COMPUTE-NBR HR65.3 HR70.1 HR70.2 HR70.3 PWCOMPUTE FILE RELATIONS ONE TO ONE RELATIONS RELATION RELATED NAME 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 |