Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PGSELECT


                             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

HGLM.1    HPOS.1    HPQC.1    HPRS.1    HR15.1    HR155
HR511     HR515     HR54.1    HR650     HRS1.1    HRSC.1
PA02.1    PA100     PA102     PA13.1    PA13.2    PA149
PA16.1    PA20.1    PA21.1    PA22.1    PA24.1    PA27.1
PA34.1    PA35.1    PA36.1    PA38.1    PA502     PA513
PA52.1    PA52.3    PA52.4    PA52.5    PA520     PA54.1
TR21.1    TR22.1    TR26.1    TR500     PR110     PR113
PR120     PR13.1    PR13.5    PR13.6    PR13.8    PRSC.1
TM250     TM255     BN100     BN101     BN102     BN103
BN105     BN145     BN245     BN31.1    BN31.2    BN32.1
BN32.2    BN32.3    BN320     BN331     BN340     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
HR06.1    HR506

UPDATED BY

HR11.1    HR55.1    HR55.2    HR55.3    PA115

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

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

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

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

PGS-SEQ-NBR            Numeric 4                                 HR55.2  HR55.3
Element: 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
Element: Include/ExcludIndicates whether to include or exclude
                       the range of values contained in this
                       record.
                       E = Exclude
                       I = Include

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

PGS-ENDING-VALUE       Alpha 30                                  HR55.3
Element: 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
Element: Item Group    Contains an item group identifier.

PGS-INC-EXC-VAL        Derived
Element: Inc Exc Val

PGS-SHORT-BEG-VAL      Derived
Element: Short Beg Val

PGS-SHORT-END-VAL      Derived
Element: Short End Val

                         PGSELECT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PGSSET1   COMPANY                                                HGLM.1  HPOS.1
          GROUP-NAME                                             HPQC.1  HPRS.1
          EMPLOYEE                                               HR11.1  HR11.2
          SEQ-NBR                                                HR15.1  HR155
                                                                 HR511   HR515
                                                                 HR54.1  HR55.1
                                                                 HR55.2  HR55.3
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA149
                                                                 PA16.1  PA20.1
                                                                 PA21.1  PA22.1
                                                                 PA24.1  PA27.1
                                                                 ...

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
                                                                 BN320   BN331
                                                                 BN340   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
                                                                 HGLM.1  HPOS.1
                                                                 ...

PGSSET5   COMPANY       KeyChange                                HGLM.1  HPOS.1
          FLD-NBR                                                HPQC.1  HPRS.1
          BEGIN-VALUE                                            HR11.1  HR11.2
          GROUP-NAME                                             HR15.1  HR155
          SEQ-NBR                                                HR511   HR515
                                                                 HR54.1  HR55.1
                                                                 HR55.2  HR55.3
                                                                 HR650   HRS1.1
                                                                 HRSC.1  PA02.1
                                                                 PA100   PA102
                                                                 PA13.1  PA13.2
                                                                 PA16.1  PA20.1
                                                                 PA21.1  PA22.1
                                                                 PA24.1  PA27.1
                                                                 PA34.1  PA35.1
                                                                 ...

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

PGSSET7   COMPANY       KeyChange                                HGLM.1  HPOS.1
          GROUP-NAME                                             HPQC.1  HPRS.1
          ITEM-GRP                                               HR11.1  HR11.2
          FLD-NBR                                                HR15.1  HR155
          SEQ-NBR                                                HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HR55.3  HR650
                                                                 HRS1.1  HRSC.1
                                                                 PA02.1  PA100
                                                                 PA102   PA13.1
                                                                 PA13.2  PA16.1
                                                                 PA20.1  PA21.1
                                                                 PA22.1  PA24.1
                                                                 PA27.1  PA34.1
                                                                 PA35.1  PA36.1
                                                                 ...

                         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