Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Trunk Database Items 3-81
Trunk Database Items 3
Overview 3
The Trunk database item descriptions apply to historical items.
The Data Type column refers to Cumulative (C), Administrative (A),
Status (S), Row Identifier (I), Busy Hour (B), Special Table (N), or
Maximum Value (M) data. Cumulative, Administrative, Row Identifier,
Busy Hour, and Maximum Value items typically apply to both the current
and previous interval real-time tables. Special Table items are historical,
and apply only to the table in which they are stored.
Historical trunk database items apply to the Intrahour Trunk (
htrunk
),
Daily Trunk (
dtrunk
), Weekly Trunk Group (
wtrunk
), and Monthly
Trunk (
mtrunk
) tables. All items listed in the following Trunk Database
Items table are included in all four tables, unless otherwise noted in the
Column Type column. Any differences in the data format between the
four trunk tables are also noted in the Column Type column. The
historical indexes are EQLOC, ROW_DATE and TKGRP.