MBRSHARES FILE
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
MBS-MBR-OBJ-ID Numeric 12
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
Parent Obj Id The Parent Object Identifier field
contains the object identifier of the
member parent.
MBS-LAST-UPD-DATE Numeric 8 (yyyymmdd)
Last Update Date The Last Update Date field contains the
date the member was last updated.
MBS-LAST-UPD-TIME Numeric 6 (hhmmss)
Last Upd Time The Last Update Time field contains the
time the member was last updated.
MBS-DATA-MART-NAME Alpha 20 (Lower Case)
Data Mart Name
MBS-DIM-OBJ-ID Numeric 12
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
PARENT-OBJ-ID
MBSSET2 DIM-OBJ-ID KeyChange
LAST-UPD-DATE
LAST-UPD-TIME
MBR-OBJ-ID
PARENT-OBJ-ID
|
