Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SIRDGRPLGN


                            SIRDGRPLGN FILE

UPDATED BY

RD60.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

GLN-GROUP              Alpha 20  (Lower Case)                    RD60.1
Element: Group

GLN-LOGIN-TYPE         Alpha 5                                   RD60.1
Element: Login Type

GLN-USER-LOGIN         Alpha 80  (Lower Case)                    RD60.1
Element: User Login

GLN-ACCESS-CODE        Alpha 30  (Lower Case)                    RD60.1
Element: Access Code

GLN-OLD-ACCESS-CD      Alpha 30  (Lower Case)                    RD60.1
Element: Old Access Cd

GLN-EXPIRE             Numeric 3                                 RD60.1
Element: Expire

GLN-MESSAGE            Alpha 60  (Lower Case)                    RD60.1
Element: Message

GLN-URL                Alpha 256  (Lower Case)                   RD60.1
Element: Url

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

GLN-TIME               Numeric 6  (hhmmss)                       RD60.1
Element: Time

GLN-TYPE-RECORD        Derived
Element: Type Record

                         SIRDGRPLGN FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

GLNSET1   GROUP
          LOGIN-TYPE
          USER-LOGIN

GLNSET2   LOGIN-TYPE                                             RD60.1
          USER-LOGIN
          GROUP

GLNSET3   USER-LOGIN
          LOGIN-TYPE
          GROUP

                         SIRDGRPLGN FILE RELATIONS

ONE TO ONE RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sirdgrp        SIRDGRP      Required

                            GLN-GROUP         -> RDG-GROUP  (RDGSET1)

Sirdlgntyp     SIRDLGNTYP   Required

                            GLN-LOGIN-TYPE    -> LGT-LOGIN-TYPE

Webuser        WEBUSER      Required
                            When GLN-LOGIN-TYPE = "WEB  "

                            GLN-USER-LOGIN    -> WUR-WEB-USER