User`s guide

9030971 E17 Data Structure of SQL Tables

C-5

SPECTRUM Data Types

Extended Attributes

Description: List of extension ﬂags and object identiﬁers for all

attributes

Columns: lh The landscape handle, a 4-byte integer

mth The model type handle, a 4-byte integer

attrid The attribute ID, a 4-byte integer

xﬂags The attribute’s extension ﬂags, a 2-byte

integer. The bit ﬂags have the following

values:

01 = POLLED 02 = LOGGED

04 = INIT_AUTO 08 = INIT_MANUAL

16 = MEMORY 32 = DATABASE

256 = LOADED 512 = READ_CALC

1024 = WRITE_CALC

oidstr The object identiﬁer for the attribute, a 130-

byte varying character string, nulls allowed

pollgroup The attribute’s polling group id, a 2-byte

integer

Indexed by: lh + mth + attrid

NOTE

For event exports involving multiple landscapes, the data is sorted by

landscape, by model type, and by model. For example, data for Landscape1

occurs ﬁrst by order of model type, and by order of model within each model

type (for example, ModelType1, Model1, Model2, ModelType2, Model1,

Model2, etc.). Data for Landscape2 occurs next in the same manner, and so

on for all additional landscapes.