Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

PERSGROUP


                             PERSGROUP FILE

                         Employee Group Header

Contains the definition of a user-defined employee group.

REFERENCED BY

AC62.1    BN06.1    BN08.1    BN100     BN101     BN102
BN103     BN145     BN15.1    BN150     BN16.1    BN16.2
BN16.3    BN16.4    BN17.2    BN17.3    BN18.1    BN18.2
BN18.3    BN18.4    BN18.5    BN18.6    BN18.7    BN20.1
BN206     BN215     BN216     BN230     BN231     BN232
BN238     BN240     BN242     BN245     BN246     BN285
BN320     BN321     BN331     BS01.1    BS03.1    BS03.2
BS03.3    HC01.1    HC02.1    FC202     HPRG.1    HR04.4
HR04.5    HR04.6    HR125     HR170     HR211     HR213
HR217     HR220     HR255     HR70.1    PA113     PA125
PA212     PA213     PA214     PA215     PA216     PA217
PA218     PA219     PA220     PA221     PA222     PA224
PA225     PA227     PA248     PA249     PA290     PA296
PA300     PA305     PA310     PA311     PA313     PA315
PA320     PA325     PA330     PA335     PA340     PA345
PA350     PA355     PA360     PA370     PA48.1    PA496
PA66.2    TR02.1    TR113     TR120     HS01.1    HS02.1
HS05.1    HS20.1    HS21.1    HS535     PR127     PR128
PR130     PR131     PR134     PR136     PR139     PR188
PR189     PR195     PR212     PR214     PR226     PR227
PR230     PR240     PR242     PR243     PR245     PR247
PR250     PR252     PR260     PR27.1    PR276     PR277
PR28.1    PR282     PR284     PR297     PR298     PR299
PR32.1    PR32.2    PR33.1    PR33.2    PR33.3    PR35.1
PR35.2    PR35.3    PR35.4    PR35.5    PR35.6    PR35.8
PR37.1    PR530     UK02.1    UK10.1    UK10.4    UK102
UK201     UK210     UK277     UK330     TA125     TA145
TA147     TA180     TA181     TA20.1    TA220     TA40.1
TM240     TM245     TM250     TM255     TM260     TM265
TM470     UK20.1    UK220     UK270     UK300

UPDATED BY

HGLM.1    HPOS.1    HPQC.1    HPRS.1    HR06.1    HR11.1
HR11.2    HR15.1    HR155     HR506     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    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    PR30.1
PRSC.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

PRG-COMPANY            Numeric 4                                 HR55.1  HR55.2
Element: Company       Contains the number that represents an
                       established company and is entered on
                       all functions.

PRG-GROUP-NAME         Alpha 10                                  HR55.1  HR55.2
Element: Group Name    Contains the employee group name.

PRG-DESCRIPTION        Alpha 30  (Lower Case)                    BN17.2  BN17.3
Element: Description   Contains the group description.           BN18.1  BN18.2
                                                                 BN18.3  BN18.4
                                                                 BN18.5  BN18.6
                                                                 BN18.7  HR55.1
                                                                 HR55.2  HR55.3

PRG-FLD-NBR            Numeric 4 Occurs 9 Times                  HR55.1
Dictionary Field       Contains the HR data dictionary field
Number                 number of the item selected as criteria
                       for the employee group.

PRG-LAST-ITEM-SEQ      Numeric 4                                 HR55.2  HR55.3
Element: Item          Contains the sequence number used to
                       store the last employee group selection
                       record.

PRG-UPDATE-FLAG        Alpha 1                                   HGLM.1  HPOS.1
Element: Update Flag   Determines whether the employee group     HPQC.1  HPRS.1
                       is current or needs to be updated.        HR06.1  HR11.1
                                                                 HR11.2  HR15.1
                                                                 HR155   HR506
                                                                 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
                                                                 PA36.1  PA38.1
                                                                 PA502   PA513
                                                                 PA52.1  PA52.3
                                                                 PA52.4  PA52.5
                                                                 PA520   PA54.1
                                                                 PR110   PR113
                                                                 PR120   PR13.1
                                                                 PR13.5  PR13.6
                                                                 PR13.8  PRSC.1
                                                                 TR21.1  TR22.1
                                                                 TR26.1  TR500

PRG-GRP-ORDER          Numeric 1                                 HR55.3
Element: Grp Order     Indicates whether the group is used as
                       a criteria for another group.
                       0
                       1

PRG-BENEFITS           Alpha 1                                   HR55.1  HR55.2
Element: Benefits      Indicates whether the employee group      HR55.3
                       can be used by benefits for plan
                       definition.
                       Y = Yes
                       N = No

                         PERSGROUP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

PRGSET1   COMPANY                                                AC62.1  BN06.1
          GROUP-NAME                                             BN08.1  BN100
                                                                 BN101   BN102
                                                                 BN103   BN145
                                                                 BN15.1  BN150
                                                                 BN16.1  BN16.2
                                                                 BN16.3  BN16.4
                                                                 BN17.2  BN17.3
                                                                 BN18.1  BN18.2
                                                                 BN18.3  BN18.4
                                                                 BN18.5  BN18.6
                                                                 BN18.7  BN20.1
                                                                 BN206   BN215
                                                                 BN216   BN230
                                                                 BN231   BN232
                                                                 ...

PRGSET2   COMPANY       KeyChange, Subset                        HR155
          GRP-ORDER     Where UPDATE-FLAG = "Y"
          GROUP-NAME

PRGSET3   COMPANY       KeyChange                                PA16.1  PA20.1
          GRP-ORDER                                              PA21.1  PA22.1
          GROUP-NAME                                             PA24.1  PA27.1
                                                                 PA34.1  PA35.1
                                                                 PA36.1  PA38.1
                                                                 PA520   TR21.1
                                                                 TR22.1  TR26.1
                                                                 TR500

                         PERSGROUP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Company        PRSYSTEM     Required

                            PRG-COMPANY       -> PRS-COMPANY
                            Spaces            -> PRS-PROCESS-LEVEL

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

                            PRG-FLD-NBR       -> PAD-FLD-NBR

                         PERSGROUP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Employee Nbr   PGSELECT

                            PRG-COMPANY       -> PGS-COMPANY
                            PRG-GROUP-NAME    -> PGS-GROUP-NAME
                                                 PGS-EMPLOYEE
                                                 PGS-SEQ-NBR

Employees      PGEMPLOYEE   Delete Cascades

                            PRG-COMPANY       -> PGE-COMPANY
                            PRG-GROUP-NAME    -> PGE-GROUP-NAME
                                                 PGE-EMPLOYEE

Pgselect       PGSELECT     Delete Cascades

                            PRG-COMPANY       -> PGS-COMPANY
                            PRG-GROUP-NAME    -> PGS-GROUP-NAME
                                                 PGS-EMPLOYEE
                                                 PGS-SEQ-NBR

Progpay        PROGPAY

                            PRG-COMPANY       -> PGP-COMPANY
                            PRG-GROUP-NAME    -> PGP-GROUP-NAME
                            Spaces            -> PGP-REC-TYPE
                                                 PGP-TABLE
                                                 PGP-EFFECT-DATE
                                                 PGP-END-DATE

Progpay Bonus  PROGPAY

                            PRG-COMPANY       -> PGP-COMPANY
                            PRG-GROUP-NAME    -> PGP-GROUP-NAME
                            "B"               -> PGP-REC-TYPE
                                                 PGP-TABLE
                                                 PGP-EFFECT-DATE
                                                 PGP-END-DATE

Selection      PGSELECT     Delete Cascades

                            PRG-COMPANY       -> PGS-COMPANY
                            PRG-GROUP-NAME    -> PGS-GROUP-NAME
                                                 PGS-ITEM-GRP
                                                 PGS-FLD-NBR
                                                 PGS-SEQ-NBR

Standtime      STANDTIME    Required

                            PRG-COMPANY       -> STM-COMPANY
                            Zeroes            -> STM-EMPLOYEE
                            PRG-GROUP-NAME    -> STM-TIME-GROUP
                                                 STM-PAY-CODE
                                                 STM-SEQ-NBR