Lawson Insight Technical Documentation

                            SIRDLGNTYP FILE

UPDATED BY

RD40.1    RD40.2    RD40.3    RD60.1

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

LGT-LOGIN-TYPE         Alpha 5                                   RD40.1  RD40.2
Element: Login Type                                              RD40.3  RD60.1

LGT-LOGIN-STATUS       Alpha 1                                   RD40.1  RD40.2
Element: Login Status  A = Active                                RD40.3  RD60.1
                       I = Inactive

LGT-DESCRIPTION        Alpha 50  (Lower Case)                    RD40.1  RD40.2
Element: Description   This field contains the description.      RD40.3  RD60.1

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

LGT-TIME               Numeric 6  (hhmmss)                       RD40.1  RD40.2
Element: Time                                                    RD40.3  RD60.1

                         SIRDLGNTYP FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

LGTSET1   LOGIN-TYPE                                             RD40.1  RD40.2
                                                                 RD40.3  RD60.1

                         SIRDLGNTYP FILE RELATIONS

ONE TO MANY RELATIONS


RELATION       RELATED
 NAME           FILE        INTEGRITY RULES / FIELD MATCH

Sirdgrplgn     SIRDGRPLGN

                            LGT-LOGIN-TYPE    -> GLN-LOGIN-TYPE
                                                 GLN-USER-LOGIN
                                                 GLN-GROUP

Sirdidlgn      SIRDIDLGN

                            LGT-LOGIN-TYPE    -> ILG-LOGIN-TYPE
                                                 ILG-USER-LOGIN
                                                 ILG-ID