All tables combined

Last Updated : May 13, 2024 |
Prolog information
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.