Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SIRDGRPROL


                            SIRDGRPROL FILE

This file assigns roles previously defined in WF to ID groups.

REFERENCED BY

RD66.1    RD66.2

UPDATED BY

RD42.1    RD42.2    RD65.1    RD65.2

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

RGP-GROUP              Alpha 20  (Lower Case)                    RD42.1  RD65.1
Element: Group                                                   RD65.2

RGP-ROLE               Alpha 20  (Lower Case)                    RD42.1  RD65.1
Element: Role                                                    RD65.2

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

RGP-TIME               Numeric 6  (hhmmss)                       RD42.1  RD65.1
Element: Time                                                    RD65.2

RGP-TYPE-RECORD        Derived
Element: Type Record

                         SIRDGRPROL FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

RGPSET1   GROUP                                                  RD42.1  RD65.1
          ROLE                                                   RD65.2  RD65.3
                                                                 RD65.4  RD66.1
                                                                 RD66.2

RGPSET2   ROLE                                                   RD42.1  RD42.2
          GROUP

                         SIRDGRPROL FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sirdgrp        SIRDGRP      Required

                            RGP-GROUP    -> RDG-GROUP

Sirdgrprls     SIRDGRPRLS   Not Required, Delete Restricted

                            RGP-GROUP    -> SRS-GROUP
                            RGP-ROLE     -> SRS-ROLE

Sirdrole       SIRDROLE     Required

                            RGP-ROLE     -> SRO-ROLE

                         SIRDGRPROL FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sirdgrpid      SIRDGRPID

                            RGP-GROUP    -> GID-GROUP
                            RGP-ROLE     -> GID-ROLE
                                            GID-ID

Sirdgrprlsp    SIRDGRPRLS   Delete Restricted

                            RGP-GROUP    -> SRS-PARENT-GROUP
                            RGP-ROLE     -> SRS-PARENT-ROLE
                                            SRS-GROUP
                                            SRS-ROLE