Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             PGSELECT FILE

                      Emp Group Selection Criteria

Contains the selection criteria for defining an employee group. Each
selection criteria has its own record in this file.

REFERENCED BY

HR15.1    HR155     HR511     HR54.1    HR650     HRS1.1
HRSC.1    PA149     PA16.1    PA502     PA513     PA54.1
TR22.1    TR500     PR13.1    PR13.5    PR13.6    PR13.8
TM250     TM255     BN100     BN101     BN102     BN103
BN105     BN145     BN245     BN31.1    BN31.2    BN32.1
BN32.2    BN32.3    BN331     BN45.1    BN531     BN65.1
BN71.1    BN72.1    BS09.1    BS10.1    BS11.1    BS12.1
BS13.1    BS14.1    BS15.1    BS32.1

UPDATED BY

HR55.1    HR55.2    HR55.3

FIELD NAME           DESCRIPTION/VALID VALUES                    UPDATED BY

PGS-COMPANY          Numeric 4                                   HR55.2  HR55.3
Company              Contains the company number.

PGS-GROUP-NAME       Alpha 10                                    HR55.1  HR55.2
Group Name           Contains the user-defined employee          HR55.3
                     group name.

PGS-EMPLOYEE         Numeric 9                                   HR55.2
Employee             Contains employees to be included in
                     the group regardless of criteria.

PGS-SEQ-NBR          Numeric 4                                   HR55.2  HR55.3
Item                 Contains the sequence number that keeps
                     each record unique.

PGS-FLD-NBR          Numeric 4                                   HR55.3
Dictionary Field     Contains the HR data dictionary field
Number               number.

PGS-INC-EXC-FLAG     Alpha 1                                     HR55.3
Include/Exclude      Indicates whether to include or exclude
                     the range of values contained in this
                     record.
                     E = Exclude
                     I = Include

PGS-BEGIN-VALUE      Alpha 30                                    HR55.3
Beginning Value      Contains the value (or beginning value
                     if a range is used) for the data item in
                     this record.

PGS-ENDING-VALUE     Alpha 30                                    HR55.3
Ending Value         Contains the ending value if a range of
                     values is defined. If a range is not
                     defined, this field is blank.

PGS-ITEM-GRP         Alpha 2                                     HR55.3
Item Group           Contains an item group identifier.

PGS-INC-EXC-VAL      Derived
Inc Exc Val

PGS-SHORT-BEG-VAL    Derived
Short Beg Val

PGS-SHORT-END-VAL    Derived
Short End Val

                         PGSELECT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PGSSET1   COMPANY                                                HR15.1  HR155
          GROUP-NAME                                             HR511   HR54.1
          EMPLOYEE                                               HR55.1  HR55.2
          SEQ-NBR                                                HR55.3  HR650
                                                                 HRS1.1  HRSC.1
                                                                 PA149   PA16.1
                                                                 PA502   PA513
                                                                 PA54.1  TR22.1
                                                                 TR500   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  TM250
                                                                 TM255

PGSSET4   COMPANY       KeyChange                                BN100   BN101
          FLD-NBR                                                BN102   BN103
          GROUP-NAME                                             BN105   BN145
          SEQ-NBR                                                BN245   BN31.1
                                                                 BN31.2  BN32.1
                                                                 BN32.2  BN32.3
                                                                 BN331   BN45.1
                                                                 BN531   BN65.1
                                                                 BN71.1  BN72.1
                                                                 BS09.1  BS10.1
                                                                 BS11.1  BS12.1
                                                                 BS13.1  BS14.1
                                                                 BS15.1  BS32.1
                                                                 HR15.1  HR155
                                                                 HR511   HR54.1
                                                                 ...

PGSSET5   COMPANY       KeyChange                                HR15.1  HR155
          FLD-NBR                                                HR511   HR54.1
          BEGIN-VALUE                                            HR55.1  HR55.2
          GROUP-NAME                                             HR55.3  HR650
          SEQ-NBR                                                HRS1.1  HRSC.1
                                                                 PA16.1  PA502
                                                                 PA513   PA54.1
                                                                 TR22.1  TR500
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8

PGSSET6   COMPANY       KeyChange                                HR55.1  HR55.2
          GROUP-NAME                                             HR55.3
          FLD-NBR
          SEQ-NBR

PGSSET7   COMPANY       KeyChange                                HR15.1  HR155
          GROUP-NAME                                             HR511   HR54.1
          ITEM-GRP                                               HR55.2  HR55.3
          FLD-NBR                                                HR650   HRS1.1
          SEQ-NBR                                                HRSC.1  PA16.1
                                                                 PA502   PA513
                                                                 PA54.1  TR22.1
                                                                 TR500   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8

                         PGSELECT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PGS-COMPANY       -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

Emp Group      PERSGROUP    Required

                            PGS-COMPANY       -> PRG-COMPANY
                            PGS-GROUP-NAME    -> PRG-GROUP-NAME

Employee       EMPLOYEE     Required
                            When PGS-EMPLOYEE != Zeroes

                            PGS-COMPANY       -> EMP-COMPANY
                            PGS-EMPLOYEE      -> EMP-EMPLOYEE

Field Nbr      PADICT       Required
                            When PGS-FLD-NBR != Zeroes

                            PGS-FLD-NBR       -> PAD-FLD-NBR

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

                            PGS-FLD-NBR       -> PAD-FLD-NBR