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     BN231     BN232     BN238
BN242     BN245     BN246     BN285     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     PA248     PA249     PA290     PA296
PA300     PA305     PA310     PA311     PA313     PA315
PA320     PA325     PA330     PA335     PA340     PA345
PA350     PA355     PA360     PA370     PA48.1    PA490
PA66.2    TR02.1    TR113     TR120     HS01.1    HS02.1
HS05.1    HS20.1    HS21.1    HS535     PR128     PR131
PR134     PR136     PR139     PR195     PR212     PR214
PR226     PR230     PR247     PR260     PR27.1    PR276
PR277     PR28.1    PR297     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     TA180     TA20.1    TA220     TM240     TM245
TM250     TM255     TM470     UK20.1    UK220     UK270

UPDATED BY

HR15.1    HR155     HR511     HR54.1    HR55.1    HR55.2
HR55.3    HR650     HRS1.1    HRSC.1    PA16.1    PA502
PA513     PA54.1    TR22.1    TR500     PR13.1    PR13.5
PR13.6    PR13.8    PR30.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                                     HR15.1  HR155
Update Flag          Determines whether the employee group       HR511   HR54.1
                     is current or needs to be updated.          HR55.1  HR55.2
                                                                 HR55.3  HR650
                                                                 HRS1.1  HRSC.1
                                                                 PA16.1  PA502
                                                                 PA513   PA54.1
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8
                                                                 TR22.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   BN231
                                                                 BN232   BN238
                                                                 ...

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

PRGSET3   COMPANY       KeyChange                                PA16.1  TR22.1
          GRP-ORDER                                              TR500
          GROUP-NAME

                         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