Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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    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

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