|
|
SIBSLISTHD FILE
This is the file that defines a list that can be grouped for bursting and
distributing reports.
REFERENCED BY
BS40.1 BS60.1
UPDATED BY
RD10.1
FIELD NAME DESCRIPTION/VALID VALUES UPDATED BY
LSH-LIST Alpha 15 RD10.1
Element: List
LSH-TYPE Alpha 2 RD10.1
Element: Type AT = Attribute
ID = Id
LSH-OBJ-ID Numeric 12 RD10.1
Element: Obj Id
LSH-DESCRIPTION Alpha 50 (Lower Case) BS60.1 RD10.1
Element: Description This field contains the description.
LSH-LIST-STATUS Alpha 1 RD10.1
Element: List Status A = Active
I = Inactive
LSH-DATE Numeric 8 (yyyymmdd) RD10.1
Element: Date This field contains the system date
when this was created.
LSH-TIME Numeric 6 (hhmmss) RD10.1
Element: Time
SIBSLISTHD FILE INDEX
NAME KEY FIELDS DESCRIPTION / SUBSET CONDITION USED IN
LSHSET1 LIST BS40.1 BS60.1
RD10.1 RD10.2
LSHSET2 LIST KeyChange
TYPE
LSHSET3 TYPE KeyChange
LIST
LSHSET4 OBJ-ID KeyChange, Subset RD10.1
Where OBJ-ID != Zeroes
SIBSLISTHD FILE RELATIONS
ONE TO MANY RELATIONS
RELATION RELATED
NAME FILE INTEGRITY RULES / FIELD MATCH
Bslistgrp BSLISTGRP
LSH-LIST -> LGR-LIST
LGR-GROUP
LGR-ID
Bsrulelist BSRULELIST
LSH-LIST -> RLL-LIST
RLL-RULE-TAG
Lomxvalue LOMXVALUE
LSH-OBJ-ID -> LMV-OBJ-ID
LMV-MATRIX-TYPE
LMV-MATRIX-CAT
Sibslistid SIBSLISTID
LSH-LIST -> LSD-LIST
LSD-ID
|
