Lawson Software

Lawson Insight Technical Documentation

Generated by:
Documentation generated by Decision Analytics

ERDs Tables Elements Libraries App Forms


                             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
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
Parent Obj Id        The Parent Object Identifier field
                     contains the object identifier of the
                     member parent.


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

MBS-LAST-UPD-TIME    Numeric 6  (hhmmss)                         IAMB.1
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
Data Mart Name

MBS-DIM-OBJ-ID       Numeric 12                                  IAMB.1
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