Instruction manual

Database Tables CentreVu® CMS Open Database Connectivity
ACD Shifts Database Items 3-154
ACD Shifts Database Items 3
Overview 3
The ACD shifts database item descriptions apply specifically to items in
the
acd_shifts
table. The table contains information on ACD shift
times and the maximum number of agents logged in for each shift. The
indexes are ACD and SHIFT_ID. Because the data contained in the
acd_shifts
table are administrative, the table is not dependent on
ECS releases.
ACD Shifts
Database Items
3
The following table describes the data items in the CMS ACD Shifts
database dictionary table.
Database Item Description
Data
Type
Column
Type
Length
ACD (index) The ACD number for which data
was collected.
A smallint 2 bytes
SHIFT_ID The identification number of the
ACD shift. Values are 1 - 4.
A smallint 2 bytes
START_TIME The ACD shift start time. A smallint 2 bytes
STOP_TIME The ACD shift stop time. A smallint 2 bytes
MAX_AGENTS The maximum number of agents
logged in per shift.
A smallint 2 bytes