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
Element: Obj Id        This is the object identifier. It is
                       used to relate commitments or posted
                       transactions back to the originating
                       subsystems. Each subsystem record that
                       is updated as a commitment or posted
                       transaction is assigned an object
                       identifier. The object identifier is
                       maintained in the subsystem files and in
                       the Activity Commitments Detail and
                       Activity Transaction files. The object
                       identifier is a unique key used to drill
                       back from Activity Management to the
                       subsystems.

MBS-LAST-UPD-DATE      Numeric 8  (yyyymmdd)                     IAMB.1
Element: Last Upd Date The 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