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

BN305     HAP3.1    HEP4.1    HPOS.1    HPQC.1    HPRS.1
HR15.1    HR155     HR511     HR515     HR54.1    HRS1.1
HRSC.1    LP100     LP101     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    TM250     TM255     BN100     BN101
BN102     BN103     BN105     BN145     BN232     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     HR710


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
Element: Fld Nbr       Contains the HR data dictionary field
                       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                                                BN305   HAP3.1
          GROUP-NAME                                             HEP4.1  HPOS.1
          EMPLOYEE                                               HPQC.1  HPRS.1
          SEQ-NBR                                                HR11.1  HR11.2
                                                                 HR15.1  HR155
                                                                 HR511   HR515
                                                                 HR54.1  HR55.1
                                                                 HR55.2  HR55.3
                                                                 HRS1.1  HRSC.1
                                                                 LP100   LP101
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA149   PA16.1
                                                                 PA20.1  PA21.1
                                                                 ...

PGSSET4   COMPANY       KeyChange                                BN100   BN101
          FLD-NBR                                                BN102   BN103
          GROUP-NAME                                             BN105   BN145
          SEQ-NBR                                                BN232   BN245
                                                                 BN305   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
                                                                 ...

PGSSET5   COMPANY       KeyChange                                BN305   HAP3.1
          FLD-NBR                                                HEP4.1  HPOS.1
          BEGIN-VALUE                                            HPQC.1  HPRS.1
          GROUP-NAME                                             HR11.1  HR11.2
          SEQ-NBR                                                HR15.1  HR155
                                                                 HR511   HR515
                                                                 HR54.1  HR55.1
                                                                 HR55.2  HR55.3
                                                                 HRS1.1  HRSC.1
                                                                 LP100   LP101
                                                                 PA02.1  PA100
                                                                 PA102   PA115
                                                                 PA13.1  PA13.2
                                                                 PA16.1  PA20.1
                                                                 PA21.1  PA22.1
                                                                 ...

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

PGSSET7   COMPANY       KeyChange                                BN305   HAP3.1
          GROUP-NAME                                             HEP4.1  HPOS.1
          ITEM-GRP                                               HPQC.1  HPRS.1
          FLD-NBR                                                HR11.1  HR11.2
          SEQ-NBR                                                HR15.1  HR155
                                                                 HR511   HR515
                                                                 HR54.1  HR55.2
                                                                 HR55.3  HRS1.1
                                                                 HRSC.1  LP100
                                                                 LP101   PA02.1
                                                                 PA100   PA102
                                                                 PA115   PA13.1
                                                                 PA13.2  PA16.1
                                                                 PA20.1  PA21.1
                                                                 PA22.1  PA24.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