Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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    HPRG.1    HR04.4    HR04.5
HR04.6    HR125     HR170     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     PR300     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     UK210
UK330     TA125     TA145     TA147     TA180     TA181
TA20.1    TA220     TA40.1    TM240     TM245     TM250
TM255     TM470     UK20.1    UK220     UK270     UK300

UPDATED BY

HR06.1    HR11.1    HR11.2    HR15.1    HR155     HR506
HR511     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
Company              Contains the number that represents an
                     established company and is entered on
                     all functions.

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

PRG-DESCRIPTION      Alpha 30  (Lower Case)                      BN16.1  BN16.2
Description          Contains the group description.             BN17.2  BN17.3
                                                                 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
Item                 Contains the sequence number used to
                     store the last employee group selection
                     record.

PRG-UPDATE-FLAG      Alpha 1                                     HR06.1  HR11.1
Update Flag          Determines whether the employee group       HR11.2  HR15.1
                     is current or needs to be updated.          HR155   HR506
                                                                 HR511   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
Grp Order            Indicates whether the group is used as
                     a criteria for another group.
                     0
                     1

PRG-BENEFITS         Alpha 1                                     HR55.1  HR55.2
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