All tables combined

Last Updated : May 13, 2024 |

Table1

Application

Description

System Admin1

Agent/ Call Center Admin1

Hist1

aar_agents

Agent Act. Recorder

Agents being traced

X

acd_groups

ACD groups

Global dictionary

X

acd_shifts

DSA, FSA

Agent shifts

X

acdadminlog

Historical reports

Log of ACD admin modifications

X

acds

User Permissions

ACD access

X

ag_actv2

Agent Trace

Agent trace data

X

ag_ex_adm

Exceptions

Agent exceptions admin

X

agex2

Historical reports

Agent exceptions data

X

agroups

Dictionary

Agent groups

X

arch_stat

Archiver

Archive status

X

arch_tz

Timezone

Timezone administration

X

br_dev_types

Backup/Restore

B/R device types

br_devices

Backup/Restore

B/R devices

X

br_fulls

Backup/Restore

Backup history: full backups

br_increms

Backup/Restore

Backup history: inc. backups

br_tables

Backup/Restore

B/R tables

call_rec

Historical reports

Internal call history

X

cmstbls

Dictionary

Database tables

X

cow/reports/ designer

Supervisor

Report designer

X

custobjects

X

customer_log

ELOG

Customer error log

d_secs

Historical reports

X

dagent2

Historical reports

Daily agent data

X

db/gem/c_custom3

Custom Reports

Report GEM files (current)

X

db/gem/h_custom3

Custom Reports

Report GEM files (historical)

X

db/gem/r_custom3

Custom Reports

Report GEM files (real-time)

X

db/journal/ shortcut3

Time Tables

Shortcut settings

X

db/journal/ timetable3

Time Tables

Timetable settings

X

dberrors

IDBM

Error map: Informix vs. CMS

dbitems

Dictionary

Database items

X

dbstatus

Backup/Restore

Hist./forecast tables update status

X

dcadmin

DSA, SPI, install

Data collection admin

dcalloc

DSA, FSA

Data storage allocation admin

dcwc

Historical reports

Daily call work codes data

X

dsplit2

Historical reports

Daily splits data

X

dtkgrp2

Historical reports

Daily trunk groups data

X

dtrunk

Historical reports

Daily trunks data

X

dvdn

Historical reports

Daily VDNs data

X

dvector

Historical reports

Daily vector data

X

error_msg

ELOG

Canned customer error msgs

ex_msgs

Exceptions

Canned exception messages

f_agposrep

Forecast

Agent Positions Required Report

f_cday2

Forecast

Current Day Report

X

f_cdayconf2

Forecast

Current Day Config.

X

f_cdayrep2

Forecast

Current Day Report

X

f_chpap

Forecast

Call Handling Profile

X

f_chprof

Forecast

Call Handling Profile

X

f_cstap

Forecast

Costs Profile

X

f_cstprof

Forecast

Costs Profile

X

f_cstprof

Forecast

Costs Profile

X

f_dataarch

Forecast

Data Storage Alloc.

X

f_dsplit2

Forecast

Daily Split Data

X

f_dtkgrp

Forecast

Daily Trunk Group Data

X

f_fin

Forecast

Financial Report

f_finrep

Forecast

Financial Report

f_hfinrep

Forecast

Hypothetical Financial Report

f_hypodata

Forecast

Hypothetical Data

X

f_hyporep

Forecast

Hypothetical Report

f_intra

Forecast

Intraday Report

f_intrarep

Forecast

Intraday Report

f_ispday2

Forecast

Special Day Split Data

X

f_isplit2

Forecast

Interval Split Data

X

f_itkgrp

Forecast

Interval Trunk Group Data

X

f_long

Forecast

Long Term Report

f_longrep

Forecast

Long Term Report

f_spdays2

Forecast

Special Day Admin

X

f_specrep

Forecast

Special Day Report

f_status

Forecast

Forecast Manager Status

X

f_tkgpprof

Forecast

Trunk Group Profiles

X

f_tkreqrep

Forecast

Trunk Required Report

f_tperfrep

Forecast

Trunk Performance Report

features

User Permissions

Feature access

X

filesys

DSA, FSA

Historical reports file systems

fs_check

CRT

File systems for free space check

h_custom3

Custom Reports

Custom reports: historical

X

hagent2

Historical reports

Intrahour agent data

X

haglog2

Historical reports

Intrahour agent login-logout data

X

hcwc

Historical reports

Intrahour call work code data

X

hsplit2

Historical reports

Intrahour split data

X

htkgrp2

Historical reports

Intrahour trunk group data

X

htrunk

Historical reports

Intrahour trunk data

X

hvdn

Historical reports

Intrahour VDN data

X

hvector

Historical reports

Intrahour vector data

X

linkex

Historical reports

Link exceptions data

X

m_secs

Historical reports

X

magent2

Historical reports

Monthly agent data

X

main_menu3

CRT

Main menu

X

mctex2

Historical reports

Malicious call trace exceptions

X

mcwc

Historical reports

Monthly call work code data

X

menu3

CRT

Submenu

X

menu_add3

CRT

Menu additions

X

menu_help

CRT

Menu help

menu_item_help

CRT

More help for menu items

msplit2

Historical reports

Monthly split data

X

mtkgrp2

Historical reports

Monthly trunk group data

X

mtrunk

Historical reports

Monthly trunk data

X

mvdn

Historical reports

Monthly VDN data

X

mvector

Historical reports

Monthly vector data

X

print_adm

Printer Admin

Printer parameters

r_custom3

Custom Reports

Custom reports: real time

X

scwininfo3

Short Cuts

Shortcut window info

X

sp_ex_adm

Exceptions

Split exceptions admin

X

spex2

Historical reports

Split exceptions

X

split_pro2

ACD profiles

Split profile

X

splits2

User Permissions

Split access

X

std_rpts

Custom Reports

Standard reports list

synonyms

Dictionary

Synonyms

X

sys_info

DSA, FSA

DC parameters

X

ten_agent4

Multi-tenancy

Tenant agent assignments

X

ten_cwc4

Multi-tenancy

Tenant Call Work Code assignments

X

ten_spl4

Multi-tenancy

Tenant split/skill assignments

X

ten_tkgrp4

Multi-tenancy

Tenant trunk group assignments

X

ten_vdn4

Multi-tenancy

Tenant VDN assignments

X

ten_vector4

Multi-tenancy

Tenant vector assignments

X

tenants4

Multi-tenancy

Tenant permissions

X

tg_ex_adm

Exceptions

Trunk group exceptions admin

X

tgex

Historical reports

Trunk group exceptions

X

tgroups

User Permissions

Trunk groups access

X

tt_hostname

Time Tables, Host Name

Timetables

ttsc3

Time Tables, User Perms

Timetables

X

ttsched3

Time Tables, User Perms

Schedules

X

ttsctasks3

Time Tables, User Perms

Associated tasks

X

user_colors3

CRT

Color options

X

user_defval3

CRT

User defaults

X

users3

User Permissions

Users

X

vdn_pro

ACD profiles

VDN profile

X

vdn_x_adm

Exceptions

VDN exceptions admin

X

vdnex

Historical reports

VDN exceptions data

X

vdns

User Permissions

VDN access

X

vec_x_adm

Exceptions

Vector exceptions admin

X

vecex

Historical reports

Vector exceptions data

X

vectors

User Permissions

Vector access

X

w_secs

Historical reports

X

wagent2

Historical reports

Weekly agent data

X

wcwc

Historical reports

Weekly call work code data

X

workcodes

User Permissions

Work codes access

X

wsplit2

Historical reports

Weekly split data

X

wtkgrp2

Historical reports

Weekly trunk group data

X

wtrunk

Historical reports

Weekly trunk data

X

wvdn

Historical reports

Weekly VDN data

X

wvector

Historical reports

Weekly vector data

X

  1. Data contained in the tables that are not marked (X) in the System Administration, Agent/Call Center Administration, or Historical data columns is not migrated to the new system. The tables are empty until the first backup is run.

  2. Indicates tables or data affected by the EAS format.

  3. Indicates tables that hold data associated with a specific CMS user ID. If the user ID is removed from CMS, an application that uses the migrated data, such as a Timetable report, might report an error and fail.

  4. Indicates tables new with CMS R18 that will be migrated when upgrading to future R18 and later releases.You must upgrade a system with Multi-tenancy to a new system that supports Multi-tenancy.