Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SIRDGRP


                              SIRDGRP FILE

REFERENCED BY

LO62.1    LO72.1    RD12.1    RD42.1    RD60.1    RD65.1
RD65.2    RD65.3    RD65.4    RD66.1    RD66.2    RD88.1
RD88.2    RD88.3    RD88.4    RD90.1    RD955     RD96.2

UPDATED BY

LO13.3    RD54.1    RD54.2    RD54.3    RD54.4    RD54.5
RD54.6    RD55.1    RD55.2    RD55.3    RD55.4    RD55.5
RD55.6    RD56.1    RD56.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RDG-GROUP              Alpha 20  (Lower Case)                    LO13.3  RD54.1
Element: Group                                                   RD54.2  RD54.3
                                                                 RD54.4  RD54.5
                                                                 RD54.6  RD55.1
                                                                 RD55.2  RD55.3
                                                                 RD55.4  RD55.5
                                                                 RD55.6  RD56.1
                                                                 RD56.2

RDG-RECORD-TYPE        Numeric 2                                 LO13.3  RD54.1
Element: Record Type   This field identifies the type of         RD54.2  RD54.3
                       record defined.                           RD54.4  RD54.5
                                                                 RD54.6  RD55.1
                       Valid values are:                         RD55.2  RD55.3
                       S=Summary                                 RD55.4  RD55.5
                       D=Detail                                  RD55.6  RD56.1
                       01 = People                               RD56.2
                       02 = Organizations
                       03 = Things
                       09 = Universal

RDG-STATUS             Numeric 1                                 LO13.3  RD54.1
Element: Status        This field contains the status of the     RD54.2  RD54.3
                       transaction.                              RD54.4  RD54.5
                       1 = Active                                RD54.6  RD55.1
                       2 = Inactive                              RD55.2  RD55.3
                                                                 RD55.4  RD55.5
                                                                 RD55.6  RD56.1
                                                                 RD56.2

RDG-DESCRIPTION        Alpha 50  (Lower Case)                    LO13.3  RD54.1
Element: Description   This field contains the description.      RD54.2  RD54.3
                                                                 RD54.4  RD54.5
                                                                 RD54.6  RD55.1
                                                                 RD55.2  RD55.3
                                                                 RD55.4  RD55.5
                                                                 RD55.6  RD56.1
                                                                 RD56.2  RD90.1

RDG-DEFAULT-ROLE       Alpha 20  (Lower Case)                    RD54.1  RD54.2
Element: Default Role

RDG-DATE               Numeric 8  (yyyymmdd)                     LO13.3  RD54.1
Element: Date          This field contains the system date       RD54.2  RD54.3
                       when this was created.                    RD54.4  RD54.5
                                                                 RD54.6  RD55.1
                                                                 RD55.2  RD55.3
                                                                 RD55.4  RD55.5
                                                                 RD55.6  RD56.1
                                                                 RD56.2

RDG-TIME               Numeric 6  (hhmmss)                       LO13.3  RD54.1
Element: Time                                                    RD54.2  RD54.3
                                                                 RD54.4  RD54.5
                                                                 RD54.6  RD55.1
                                                                 RD55.2  RD55.3
                                                                 RD55.4  RD55.5
                                                                 RD55.6  RD56.1
                                                                 RD56.2

                         SIRDGRP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RDGSET1   GROUP                                                  LO13.1  LO13.2
                                                                 LO13.3  LO62.1
                                                                 LO72.1  RD12.1
                                                                 RD42.1  RD54.1
                                                                 RD54.2  RD54.3
                                                                 RD54.4  RD54.5
                                                                 RD54.6  RD54.7
                                                                 RD54.8  RD54.9
                                                                 RD55.1  RD55.2
                                                                 RD55.3  RD55.4
                                                                 RD55.5  RD55.6
                                                                 RD55.7  RD55.8
                                                                 RD55.9  RD56.1
                                                                 RD56.2  RD60.1
                                                                 RD65.1  RD65.2
                                                                 ...

RDGSET2   RECORD-TYPE   KeyChange                                LO13.3  RD54.1
          GROUP                                                  RD54.2  RD54.3
                                                                 RD54.4  RD54.5
                                                                 RD54.6  RD55.1
                                                                 RD55.2  RD55.3
                                                                 RD55.4  RD55.5
                                                                 RD55.6  RD56.1
                                                                 RD56.2

                         SIRDGRP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Lochngrp       LOCHNGRP
                            Valid When RDG-RECORD-TYPE = 9

                            RDG-GROUP    -> CHG-GROUP
                                            CHG-CHANNEL-ID

Logrppage      LOGRPBKMRK   Delete Cascades
                            Valid When RDG-RECORD-TYPE = 9

                            RDG-GROUP    -> GPP-GROUP
                                            GPP-BOOK-MARK

Lowdgtgrp      LOWDGTGRP    Delete Cascades

                            RDG-GROUP    -> LWG-GROUP
                                            LWG-WIDGET-ID

Sirddirsrv     SIRDDIRSRV
                            Valid When RDG-RECORD-TYPE = 9

                            RDG-GROUP    -> SRV-GROUP
                                            SRV-SERVER-NAME
                                            SRV-PORT-NUMBER

Sirdgrpid      SIRDGRPID
                            Valid When RDG-RECORD-TYPE = 9

                            RDG-GROUP    -> GID-GROUP
                                            GID-ROLE
                                            GID-ID

Sirdgrplgn     SIRDGRPLGN
                            Valid When RDG-RECORD-TYPE = 9

                            RDG-GROUP    -> GLN-GROUP
                                            GLN-LOGIN-TYPE
                                            GLN-USER-LOGIN

Sirdgrploc     SIRDGRPLOC
                            Valid When RDG-RECORD-TYPE = 9

                            RDG-GROUP    -> GRL-GROUP
                                            GRL-LEVEL

Sirdgrprol     SIRDGRPROL
                            Valid When RDG-RECORD-TYPE = 9

                            RDG-GROUP    -> RGP-GROUP
                                            RGP-ROLE

Sirdgrpstt     SIRDGRPSTT
                            Valid When RDG-RECORD-TYPE = 9

                            RDG-GROUP    -> RST-GROUP
                                            RST-STRUCTURE

Sirdidgrp      SIRDIDGRP    Delete Cascades
                            Valid When RDG-RECORD-TYPE = 9

                            RDG-GROUP    -> WDG-GROUP
                                            WDG-ID

Sirdstrdtl     SIRDSTRDTL
                            Valid When RDG-RECORD-TYPE = 9

                            RDG-GROUP    -> STD-GROUP
                                            STD-STRUCTURE
                                            STD-LEVEL
                                            STD-LEVEL-PARENT