Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PWSELECT


                             PWSELECT FILE

                      HR Writer Selection Criteria

Contains the detail and population selection criteria used by HR170 (HR
Writer Report Request) and HR70 (HR Writer Inquiry).

REFERENCED BY

HR170     HR70.1

UPDATED BY

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

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PWS-AUTHOR-NAME        Alpha 10                                  HR65.6  HR65.8
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.

PWS-TITLE-NBR          Numeric 4                                 HR64.1  HR65.6
Element: Title Number  Contains the sequentially assigned        HR65.8
                       title number, by author, for the
                       selection criteria. The title number is
                       stored in the HR Report Writer Title
                       file.

PWS-SELECT-TYPE        Alpha 1                                   HR65.6  HR65.8
Selection Criteria     Indicates the type of selection
Type                   criteria, detail or population.
                       D = Detail Data
                       P = Population

PWS-SEQ-NBR            Numeric 4                                 HR65.6  HR65.8
Element: Sequence NumbeContains the sequence number that keeps
                       each record unique in the file.

PWS-FLD-NBR            Numeric 4                                 HR65.6  HR65.8
Dictionary Field       Contains the data dictionary field
Number                 number.

PWS-INC-EXC-FLAG       Alpha 1                                   HR65.6  HR65.8
Element: Include ExcludDetermines if the system includes or
                       excludes the records that meet the
                       defined criteria.
                       E = Exclude
                       I = Include

PWS-BEG-VALUE          Alpha 25                                  HR170   HR65.6
Element: Beginning ValuContains the beginning value of the       HR65.8  HR70.1
                       selection range.

PWS-THRU-VALUE         Alpha 25                                  HR170   HR65.6
Element: Thru Value    Contains the ending value of the          HR65.8  HR70.1
                       selection range.

PWS-ITEM-GRP           Alpha 2                                   HR65.6  HR65.8
Element: Item Group    Contains the item group. All selection
                       lines that have a common item group are
                       treated as an "and" condition. That is,
                       the employee or applicant must meet the
                       criteria of all the selection lines that
                       have a common item group identifier in
                       order to appear on the report. Different
                       item groups are treated as an "or"
                       condition. That is, an employee or
                       applicant needs to meet all of the
                       criteria in only one of the item groups
                       to appear on the report.

PWS-BEG-NEG            Alpha 1
Element: Beg Neg       Indicates whether the beginning value
                       is a negative number.

PWS-END-NEG            Alpha 1
End Value Negative     Indicates whether the ending value is a
Flag                   negative number.

                         PWSELECT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PWSSET1   AUTHOR-NAME                                            HR170   HR64.1
          TITLE-NBR                                              HR65.1  HR65.2
          SELECT-TYPE                                            HR65.6  HR65.8
          SEQ-NBR

PWSSET2   AUTHOR-NAME   KeyChange                                HR65.5  HR65.6
          TITLE-NBR                                              HR65.7  HR65.8
          SELECT-TYPE                                            HR70.1
          FLD-NBR
          SEQ-NBR

PWSSET3   AUTHOR-NAME   KeyChange                                HR170   HR65.6
          TITLE-NBR                                              HR65.8  HR70.1
          SELECT-TYPE
          ITEM-GRP
          FLD-NBR
          SEQ-NBR

                         PWSELECT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Author         PWAUTHOR     Required

                            PWS-AUTHOR-NAME    -> PWA-AUTHOR-NAME

Fld Nbr        PADICT       Required
                            When PWS-FLD-NBR != Zeroes

                            PWS-FLD-NBR        -> PAD-FLD-NBR