Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SIRDGRPSTT


                            SIRDGRPSTT FILE

This file assigns id groups to organization structures for building org charts
and/or trees.

UPDATED BY

RD88.1    RD88.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RST-GROUP              Alpha 20  (Lower Case)                    RD88.1  RD88.2
Element: Group

RST-STRUCTURE          Alpha 10  (Lower Case)                    RD88.1  RD88.2
Element: Structure

RST-DATE               Numeric 8  (yyyymmdd)                     RD88.1  RD88.2
Element: Date          This field contains the system date
                       when this was created.

RST-TIME               Numeric 6  (hhmmss)                       RD88.1  RD88.2
Element: Time

RST-TYPE-RECORD        Derived
Element: Type Record

                         SIRDGRPSTT FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RSTSET1   GROUP                                                  RD88.1  RD88.2
          STRUCTURE

RSTSET3   STRUCTURE
          GROUP

                         SIRDGRPSTT FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Rdstruct       SIRDSTRUCT   Required

                            RST-STRUCTURE    -> STR-STRUCTURE  (STRSET1)

Sirdgrp        SIRDGRP      Required

                            RST-GROUP        -> RDG-GROUP

                         SIRDGRPSTT FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sirdgrpid      SIRDGRPID

                            RST-GROUP        -> GID-GROUP
                                                GID-ROLE
                                                GID-ID

Sirdidgrp      SIRDIDGRP

                            RST-GROUP        -> WDG-GROUP
                                                WDG-ID

Sirdstrdtl     SIRDSTRDTL

                            RST-STRUCTURE    -> STD-STRUCTURE
                                                STD-LEVEL