Instruction manual
Database Tables
CentreVu®
CMS Open Database Connectivity
How Database Items are Presented 3-4
Column Types 3
The database column type indicates the format of the information within
that database item. The column type definition includes either the length
in bits of the database item or the
Informix
data type. The column types
are included in the database item tables, along with the length or
Informix
data type. Column type and length information is included for the user’s
reference. Because data gathered through ODBC can be used in a
variety of applications, it is helpful to know what type of data you are
accessing and how long it is in bytes. Any difference or exception in the
column type or length between tables in a table group; such as, between
the
hsplit
and
msplit
tables in the split/skill table group, are indicated
in the Column Type and Length columns.
Informix
Column
Types
3
The following table defines the data column types in the open database.
ECS Cross-
Reference Tables
3
CentreVu
CMS database items apply to specific ECS releases. Following
each database item table is an ECS cross-reference table. The ECS
cross-reference tables list each database item by ECS release.
Column Type Definition
char(
n
) An ASCII string of
n
characters, 1 byte per
character.
date
Informix
date type, 4 bytes long.
The
Informix
date format is yyyy-mm-dd. For
example, May 19, 1998 would display as 1998-
05-19.
integer 4 byte integer
smallint 2 byte integer
smallfloat
Informix
floating point numerical type, 4 bytes
long. The
Informix
smallfloat format is a decimal
type used for percentages, and includes a
comma and a plus/minus sign.