Lawson Insight Technical Documentation

                             SIRDIDGRP FILE

                                ID Group

This file assigns id's to id groups.

UPDATED BY

LO13.3    LO901     RD30.1    RD30.2    RD50.1    RD50.2
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    RD65.3    RD70.1    RD70.2    RD955

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

WDG-GROUP              Alpha 20  (Lower Case)                    LO901   RD54.2
Element: Group                                                   RD54.4  RD54.6
                                                                 RD54.7  RD54.8
                                                                 RD54.9  RD55.2
                                                                 RD55.4  RD55.6
                                                                 RD55.7  RD55.8
                                                                 RD55.9  RD56.1
                                                                 RD65.3  RD955

WDG-ID                 Alpha 20  (Lower Case)                    LO901   RD54.2
Element: Id                                                      RD54.4  RD54.6
                                                                 RD54.7  RD54.8
                                                                 RD54.9  RD55.2
                                                                 RD55.4  RD55.6
                                                                 RD55.7  RD55.8
                                                                 RD55.9  RD56.1
                                                                 RD65.3  RD955

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

WDG-TIME               Numeric 6  (hhmmss)                       LO901   RD54.2
Element: Time                                                    RD54.4  RD54.6
                                                                 RD55.2  RD55.4
                                                                 RD55.6  RD56.1
                                                                 RD65.3  RD955

WDG-GRPTYPE-RECORD     Derived
Element: Grptype Record

WDG-ID-RECORD          Derived
Element: Id Record

WDG-GRP-DESC           Derived
Element: Grp Desc

                         SIRDIDGRP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

WDGSET1   GROUP                                                  LO13.3  LO901
          ID                                                     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
                                                                 RD65.2  RD65.3
                                                                 RD65.4  RD955

WDGSET2   ID                                                     RD30.1  RD30.2
          GROUP                                                  RD50.1  RD50.2
                                                                 RD54.7  RD54.8
                                                                 RD54.9  RD55.7
                                                                 RD55.8  RD55.9
                                                                 RD56.1  RD70.1
                                                                 RD70.2

                         SIRDIDGRP FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Name First     LOMXVALUE    Not Required

                            IDH-OBJ-ID    -> LMV-OBJ-ID
                            "PRIMARY   "  -> LMV-MATRIX-TYPE
                            "NAME-FIRST   -> LMV-MATRIX-CAT

Name Last      LOMXVALUE    Not Required

                            IDH-OBJ-ID    -> LMV-OBJ-ID
                            "PRIMARY   "  -> LMV-MATRIX-TYPE
                            "NAME-LAST    -> LMV-MATRIX-CAT

Sirdgrp        SIRDGRP      Required

                            WDG-GROUP     -> RDG-GROUP

Sirdidhdr      SIRDIDHDR    Required

                            WDG-ID        -> IDH-ID

                         SIRDIDGRP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sirdgrpid      SIRDGRPID

                            WDG-GROUP     -> GID-GROUP
                            WDG-ID        -> GID-ID
                                             GID-ROLE

Sirdidrole     SIRDIDROLE

                            WDG-ID        -> SIR-ID
                                             SIR-ROLE

Sirdidstt      SIRDIDSTT

                            WDG-ID        -> IDS-ID
                                             IDS-STRUCTURE