Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Conditions Elements Libraries APIs Forms

MBRSHARES


                             MBRSHARES FILE

UPDATED BY

IA120     IA15.1    IAMB.1    IA300

FIELD NAME             DESCRIPTION/VALID VALUES                  UPDATED BY

MBS-MBR-OBJ-ID         Numeric 12                                IAMB.1
Element: Mbr Obj Id    The Member Object Identifier field
                       contains a unique numeric identifier
                       assigned to a member, which associates
                       this record to the appropriate MEMBER
                       file record.

MBS-PARENT-OBJ-ID      Numeric 12                                IAMB.1
Object                 The Parent Object Identifier field
Identification         contains the object identifier of the
                       member parent.


MBS-LAST-UPD-DATE      Numeric 8  (yyyymmdd)                     IAMB.1
Element: Last Update DaThe Last Update Date field contains the
                       date the member was last updated.

MBS-LAST-UPD-TIME      Numeric 6  (hhmmss)                       IAMB.1
Element: Last Upd Time The Last Update Time field contains the
                       time the member was last updated.

MBS-DATA-MART-NAME     Alpha 20  (Lower Case)                    IAMB.1
Element: Data Mart NameThis field contains the name of the data
                       mart.

MBS-DIM-OBJ-ID         Numeric 12                                IAMB.1
Element: Dim Obj Id    The Dimension Object Identifier field
                       contains a unique numeric identifier
                       assigned to the dimension, which
                       associates this record to the member
                       records.

                         MBRSHARES FILE INDEX

NAME      KEY FIELDS    DESCRIPTION / SUBSET CONDITION           USED IN

MBSSET1   MBR-OBJ-ID    KeyChange                                IA120   IA15.1
          PARENT-OBJ-ID                                          IA300   IAMB.1

MBSSET2   DIM-OBJ-ID    KeyChange                                IA120
          LAST-UPD-DATE
          LAST-UPD-TIME
          MBR-OBJ-ID
          PARENT-OBJ-ID