Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Database Items 3-155
Database Items 3
Overview 3
The Database Items descriptions apply specifically to items in the
dbitems
table. The table contains definitions for Dictionary standard
and custom database items, constants, and calculations. The index is
ITEM_NAME. Because the data contained in the
dbitems
table are
administrative, and are used to define dictionary entries, the table is not
dependent on ECS releases.
Database Items 3
The following table describes the data items in the CMS Database Items
dictionary table.
Database Item Description
Data
Type
Column
Type
Length
ITEM_TYPE
(index)
The type of data for the row. Valid
values are:
dbase = database item
calc = calculation
constant = constant
cust_def = customer-defined
database item
A char(8) 8 byte
ASCII
text string
ITEM_NAME
(index)
The name of the data item. There
can be many ITEM_NAMEs for a
specific ITEM_TYPE.
A char(20) 20 byte
ASCII
text string
FORMULA The formula for the database
constant or calculation.
A char(70) 70 byte
ASCII
text string
STANDARD This item indicates if the item is a
standard or custom database item.
Values are:
1 = standard, not 1 (null) = custom.
A smallint 2 bytes
DESCR The description of the database
calculation, constant, or
standard/custom database item.
A char(50) 50 byte
ASCII
text string