Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PWTITLE


                              PWTITLE FILE

                         HR Report Writer Title

Contains the title definition for each HR Writer report.

REFERENCED BY

HR04.4    HR04.5    HR04.6    HR170     HR60.1    HR67.1
HR70.1    HR70.2    HR70.3    HRS1.1    HRSC.1

UPDATED BY

HR64.1    HR65.1    HR65.2    HR65.3    HR65.4    HR65.5
HR65.6    HR65.7    HR65.8

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PWT-AUTHOR-NAME        Alpha 10                                  HR65.1
Element: Author        Contains the author name under which
                       the selection criteria for the report is
                       defined. This field is validated in the
                       HR Report Writer Author file.

PWT-TITLE              Alpha 30  (Lower Case)                    HR64.1  HR65.1
Element: Title         Contains the user-defined report title.

PWT-TITLE-NBR          Numeric 4                                 HR64.1  HR65.1
Element: Title Number  Contains the automatically assigned
                       title number for authors.

PWT-TYPE               Alpha 2                                   HR65.1
Element: Type          Indicates the type of report defined:
                       A = Applicant
                       E = Employee
                       H = Employee History

PWT-NBR-COPIES         Numeric 2                                 HR65.1
Element: Number Fields Contains the number of report copies.
                       Appears on the first page of the report.

PWT-FREQUENCY          Alpha 1                                   HR65.1
Element: Frequency     Contains the report frequency. Used to
                       identify a group of titles to be
                       generated by HR170 (HR Writer Report
                       Request).
                       A = Annually
                       M = Monthly
                       O = On Demand
                       Q = Quarterly
                       W = Weekly

PWT-FMT-FLD-NBR        Numeric 4 Occurs 15 Times                 HR65.2  HR65.3
HR Writer Format       Contains the field number from the data
Field Number           dictionary. The field number represents
                       the field that prints in this position
                       on the report format.

PWT-FLD-SIZE           Numeric 2 Occurs 15 Times                 HR65.2  HR65.3
Element: Field Size    Contains the size of the field.

PWT-RPT-FLD-NBR        Numeric 4 Occurs 15 Times                 HR65.5
Population Select      Contains the data dictionary number
Field Number           that represents the field used in
                       selecting an employee or applicant
                       population for the report.

PWT-REC-FLD-NBR        Numeric 4 Occurs 15 Times                 HR65.7
Detail Data Select     Contains the data dictionary number
Field Numbe            that represents the field used for
                       selecting detail data for the report.

PWT-SRT-FLD-NBR        Numeric 4 Occurs 9 Times                  HR65.4
Report Sort Order      Contains the data dictionary field
Field Number           number used in the report sort order.

PWT-TOTAL-FLAG         Alpha 1 Occurs 9 Times                    HR170   HR65.4
Element: Total Flag    Contains the total indicator for the
                       sort level.
                       A = Print averages and totals
                       N = Do not print totals
                       R = Print record count only
                       S = Print totals - Suppress detail
                       Y = Print totals

PWT-PG-BREAK           Numeric 1                                 HR65.4
Element: Page Break    Contains the sort level at which a new
                       page is started.

PWT-LAST-ITEM-SEQ      Numeric 4                                 HR65.6  HR65.8
Element: Sequence NumbeContains the sequence number used to
                       store the last item.

PWT-BEG-DATE           Numeric 8  (yyyymmdd)                     HR170   HR65.8
Date Range -           Contains the beginning date used for      HR70.1
Beginning Date         selection of date sensitive detail data.

PWT-END-DATE           Numeric 8  (yyyymmdd)                     HR170   HR65.8
Date Range - Ending    Contains the ending date used for         HR70.1
Date                   selection of date sensitive detail data.

PWT-DTL-TOPIC          Alpha 2                                   HR65.1
Element: Detail Topic  Contains the topic that provides detail
                       data items for selection, sorting, and
                       printing on the report.

PWT-SUMMARY-FLAG       Alpha 1                                   HR65.1
Element: Detail Line   Indicates whether the report prints
                       multiple detail lines for each employee
                       or applicant, or just a summary line of
                       numeric information.
                       M = Print multiple detail lines
                       S = Print one summarized detail

PWT-COMPUTE-NBR        Numeric 4 Occurs 15 Times                 HR65.2  HR65.3
Compute Statement      Contains the sequence number of the
Number                 compute statement. A compute number is
                       automatically assigned in sequential
                       order by author.

PWT-PRINT-TOTAL        Alpha 1 Occurs 15 Times                   HR65.2  HR65.3
Print Total            Contains the total option for each sort
Indicator              level defined.
                       Y = Print Column Totals
                       N = Do Not Print Column Totals
                       R = Repeat Last Item in Clm/Total
                       C = Emp/App Count on Total Line

PWT-SKIP-FLAG          Alpha 1                                   HR170   HR65.8
Element: Suppress IndivIndicates if an employee or applicant     HR70.1
                       should be skipped completely on the
                       report if the system finds no data for
                       the selected detail topic for the
                       employee or applicant.
                       N = Print Emp/App Even If/No Detl
                       Y = Skip Emp/App If/No Qualif. Dtl
                       X = Skip Emp/App If No Detail

PWT-AS-OF-DATE         Numeric 8  (yyyymmdd)                     HR170   HR65.3
Element: As of Date    Contains the "as of" date. Determines     HR70.1
                       if historical employee information is
                       extracted as of a specific date rather
                       than what is currently on the Employee
                       record (if different). If an employee's
                       hire date is after the "as of" date, the
                       employee does not appear on the report.

PWT-PRINT-NAME         Alpha 10                                  HR65.1
Element: Print File NamContains the name of the print file.

PWT-DIST-GROUP         Alpha 10                                  HR65.1
Element: Distribution GContains the distribution group. If you
                       define a distribution group for a
                       report, it is transmitted to all
                       individuals in the distribution group
                       when you run the report.

PWT-PRINTER            Alpha 10                                  HR65.1
Element: Printer       Identifies the printer that prints the
                       report.

PWT-SAVE-REPORT        Alpha 1                                   HR65.1
Element: Save Report   Indicates whether the system saves the
                       report in print manager.

PWT-SPREAD-NAME        Alpha 10                                  HR65.1
Element: Spreadsheet NaContains the name of the spreadsheet to
                       which the report is downloaded and
                       imported.

PWT-FMT-TOPIC          Alpha 2 Occurs 15 Times                   HR65.2  HR65.3
Element: Fmt Topic     Contains the topic that displays
                       associated data items for report format
                       selection.

PWT-RPT-TOPIC          Alpha 2 Occurs 15 Times                   HR65.5
Element: Rpt Topic     Contains the topic that displays
                       associated data items used for
                       population selection on the report.

PWT-REC-TOPIC          Alpha 2 Occurs 15 Times                   HR65.7
Element: Rec Topic     Contains the topic that displays
                       associated data items used for detail
                       data selection on the report.

PWT-SRT-TOPIC          Alpha 2 Occurs 9 Times                    HR65.4
Element: Srt Topic     Contains the topic that displays
                       associated data items used for
                       determining the sort order for the
                       report.

                         PWTITLE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PWTSET1   AUTHOR-NAME                                            HR04.4  HR04.5
          TITLE                                                  HR04.6  HR170
                                                                 HR60.1  HR64.1
                                                                 HR65.1  HR65.2
                                                                 HR65.3  HR65.4
                                                                 HR65.5  HR65.6
                                                                 HR65.7  HR65.8
                                                                 HR67.1  HR70.1
                                                                 HR70.2  HR70.3
                                                                 HRS1.1  HRSC.1

PWTSET2   AUTHOR-NAME   KeyChange                                HR170   HR70.1
          FREQUENCY
          TITLE-NBR

                         PWTITLE FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Author         PWAUTHOR     Required

                            PWT-AUTHOR-NAME    -> PWA-AUTHOR-NAME

Compute Field  PWCOMPUTE    Required
                            When PWT-COMPUTE-NBR != Zeroes

                            PWT-AUTHOR-NAME    -> PWC-AUTHOR-NAME
                            PWT-COMPUTE-NBR    -> PWC-COMPUTE-NBR

Format Field   PADICT       Required
                            When PWT-FMT-FLD-NBR != Zeroes
                            And  PWT-FMT-FLD-NBR != 9999

                            PWT-FMT-FLD-NBR    -> PAD-FLD-NBR

Report Field   PADICT       Required
                            When PWT-RPT-FLD-NBR != Zeroes

                            PWT-RPT-FLD-NBR    -> PAD-FLD-NBR

Sort Field     PADICT       Required
                            When PWT-SRT-FLD-NBR != Zeroes

                            PWT-SRT-FLD-NBR    -> PAD-FLD-NBR

                         PWTITLE FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Pop Select     PWSELECT     Delete Cascades

                            PWT-AUTHOR-NAME    -> PWS-AUTHOR-NAME
                            PWT-TITLE-NBR      -> PWS-TITLE-NBR
                            "P"                -> PWS-SELECT-TYPE
                                                  PWS-SEQ-NBR

Rec Select     PWSELECT     Delete Cascades

                            PWT-AUTHOR-NAME    -> PWS-AUTHOR-NAME
                            PWT-TITLE-NBR      -> PWS-TITLE-NBR
                            "R"                -> PWS-SELECT-TYPE
                                                  PWS-SEQ-NBR

Topics         PWTITLETOP   Delete Cascades

                            PWT-AUTHOR-NAME    -> PTT-AUTHOR-NAME
                            PWT-TITLE          -> PTT-TITLE
                                                  PTT-TOPIC