Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
Data Collection Period Database Items 3-147
Data Collection Period Database Items 3
Overview 3
The Administrative data collection period database items apply to the
Daily Data Collection Period (
d_secs
), Weekly Data Collection Period
(
w_secs
), and Monthly Data Collection Period (
m_secs
) tables. All items
listed in the following table are included in all three tables, unless
otherwise noted in the Column Type column. Any differences in the data
format between the three data collection period tables are also noted in
the Column Type column. The indexes are ROW_DATE and ACD. The
tables indicate the number of seconds in the data collection period (daily,
weekly, monthly).
Because the data contained in the Data Collection periods tables are
administrative, the table does not rely on ECS releases.
Data Collection
Period Database
Items
3
The following table describes the data items in the CMS Data Collection
Periods database tables.
Database Item Description
Data
Type
Column Type Length
ACD (index) The ACD number for which data
was collected.
A smallint 2 bytes
ROW_DATE The day for which data was
collected or the exception
occurred.
A date 4 byte
Informix
date
SECSPERDAY The number of seconds in the daily
data collection period
A integer; only
in d_secs
table
4 bytes
SECSPERMN The number of seconds in the
monthly data collection period.
A integer; only
in m_secs
table
4 bytes
SECSPERWK The number of seconds in the
weekly data collection period.
A integer; only
in w_secs
table
4 bytes