Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

ETGROUP


                              ETGROUP FILE

REFERENCED BY

HR07.1    HR11.1    HR11.2    HR507     HR511     HR650
PA02.1    PA100     PA102     PA13.1    PA13.2    PA502
PA513     PA52.1    PA52.3    PA52.4    PA52.5    PR110
PR113     PR120     PR13.1    PR13.5    PR13.6    PR13.8

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GRP-GROUP-ID           Numeric 10
Element: Numeric 1

GRP-GROUP-CODE         Alpha 10
Element: Alpha 10      This is a free form grouping code which
                       allows users to run reports for certain
                       sub-groups of contracts.

GRP-GROUP-NAME         Alpha 30  (Lower Case)
Element: Name

GRP-GROUP-TYPE         Numeric 10
Element: Numeric 1

GRP-GROUP-HRCPY-ID     Numeric 10
Element: Numeric 1

GRP-GROUP-HRGRPCD      Alpha 20
Element: Alpha 1

GRP-GROUP-HRDEPCD      Alpha 20
Element: Alpha 1

GRP-GROUP-COSTCNTR     Alpha 20
Element: Alpha 1

GRP-GROUP-TIM-DISP     Numeric 10
Element: Numeric 1

GRP-GROUP-TIM-ENT      Numeric 10
Element: Numeric 1

GRP-GROUP-TIM-EXC      Numeric 10
Element: Numeric 1

GRP-GROUP-EXP-DISP     Numeric 10
Element: Numeric 1

GRP-GROUP-EXP-SYS      Numeric 10
Element: Numeric 1

GRP-GROUP-HOL-SET      Numeric 10
Element: Numeric 1

GRP-GROUP-PAYPDSET     Numeric 10
Element: Numeric 1

GRP-GROUP-TC-RT-ID     Numeric 10
Element: Numeric 1

GRP-GROUP-ERPTRTID     Numeric 10
Element: Numeric 1

GRP-GROUP-ER-RT-ID     Numeric 10
Element: Numeric 1

GRP-GROUP-EA-RT-ID     Numeric 10
Element: Numeric 1

GRP-GROUP-HRS-SUN      Numeric 10
Element: Numeric 1

GRP-GROUP-HRS-MON      Numeric 10
Element: Numeric 1

GRP-GROUP-HRS-TUES     Numeric 10
Element: Numeric 1

GRP-GROUP-HRS-WED      Numeric 10
Element: Numeric 1

GRP-GROUP-HRS-THUR     Numeric 10
Element: Numeric 1

GRP-GROUP-HRS-FRI      Numeric 10
Element: Numeric 1

GRP-GROUP-HRS-SAT      Numeric 10
Element: Numeric 1

GRP-GROUP-EXP-CODE     Alpha 30
Element: Alpha 30

GRP-GROUP-WK-START     Numeric 10
Element: Numeric 1

GRP-GROUP-EXPCURSL     Numeric 10
Element: Numeric 1

                         ETGROUP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GRPSET1   GROUP-ID

GRPSET2   GROUP-HRCPY-ID                                         HR07.1  HR11.1
          GROUP-HRGRPCD                                          HR11.2  HR507
          GROUP-HRDEPCD                                          HR511   HR650
          GROUP-ID                                               PA02.1  PA100
                                                                 PA102   PA13.1
                                                                 PA13.2  PA502
                                                                 PA513   PA52.1
                                                                 PA52.3  PA52.4
                                                                 PA52.5  PR110
                                                                 PR113   PR120
                                                                 PR13.1  PR13.5
                                                                 PR13.6  PR13.8