Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

SIRDIDROLE


                            SIRDIDROLE FILE

UPDATED BY

RD43.1    RD43.2    RD54.2    RD64.1    RD64.2    RD64.3

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

SIR-ID                 Alpha 20  (Lower Case)                    RD54.2  RD64.1
Element: Id                                                      RD64.2  RD64.3

SIR-ROLE               Alpha 20  (Lower Case)                    RD54.2  RD64.1
Element: Role                                                    RD64.2  RD64.3

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

SIR-TIME               Numeric 6  (hhmmss)                       RD64.1  RD64.2
Element: Time                                                    RD64.3

                         SIRDIDROLE FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

SIRSET1   ID                                                     RD54.2  RD64.1
          ROLE                                                   RD64.3

SIRSET2   ROLE                                                   RD43.1  RD43.2
          ID                                                     RD64.2

                         SIRDIDROLE 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

Sirdidhdr      SIRDIDHDR    Required

                            SIR-ID        -> IDH-ID

Sirdrole       SIRDROLE     Required

                            SIR-ROLE      -> SRO-ROLE