CUCM 12.5 Data Dictionary

Table Name	Column Name	Description
aardialprefixmatrix		Defines the assigned digits to prepend to dialed digits to specified from and to AAR neighborhoods.
	dialprefix	The prefix digits to use for automated alternate routing within this AAR group.
	fkaarneighborhood_from	Specifies the AAR Neighborhood from which a call is being made. Inserted by trigger.
	fkaarneighborhood_to	Specifies the AAR Neighborhood to which a call is being made. Inserted by trigger.
	pkid	Unique ID to identify a record.
aarneighborhood		Automated alternate routing (AAR) provides a mechanism to reroute calls through the PSTN or other network by using an alternate number when Cisco CallManager blocks a call due to insufficient location bandwidth.
	name	Logical name of the AAR group
	pkid	Unique ID to identify a record.
activationcode		Activation codes for endpoints
	codelower	Specifies encrypted second part of the activation code)
	codeupper	Specifies encrypted first part of the activation code)
	expiretime	Denotes the expiration datetime of the activation code.
	fkdevice	Pkid of the Device
	fromgds	true indicates activation code came from GDS.
	pkid	Unique ID to identify a record.
activationcodetbr		Activation codes for endpoints - codes are inactive and ready to be released (TBR). Activation codes are inserted to this table when deleted from activationCode table
	codelower	Specifies encrypted second part of the activation code)
	codeupper	Specifies encrypted first part of the activation code)
	expiretime	Denotes the expiration datetime of the activation code.
	fromgds	true indicates activation code came from GDS.
	gctime	Denotes the gabage collection time.
	pkid	Unique ID to identify a record.
advanceddeviceconfigparams		Defines the product specific configuration for devices in key-value format
	fkdevice	Pkid of the Device
	paramname	Specifies the parameter key name (corresponding to flatten XML tag name)
	paramvalue	Specifies the parameter key value (corresponding to flatten XML tag value)
	pkid	Unique ID to identify a record.
alarmconfig		Records alarm settings per node (server) per service per monitor. These records are inserted at install time.
	enablealternativelog	Enable Alternative Logging for the Alarm Settings from Syslog Server.
	fkprocessnodeservice	Specifies the node/service combination for this alarm configuration.
	monitorstatus	True if this monitor is on.
	pkid	Unique ID to identify a record.
	server	Application managed container for remote syslog destination server information. No DB format support, validation, or special migration.
	tkalarmseverity	The alarm severity.
	tkmonitor	The type of monitor (event log, sys log, etc.) being configured.
alarmmonitorcapabilities		Used to determine which monitors are allowed with each service. These records are inserted at install time.
	enum	A number to identify the record
	tkmonitor
	tkservice
alarmusertext		User defined text for alarms
	alarmname
	catalogname
	pkid	Unique ID to identify a record.
	userdefinedtext
alternatenumber		Stores the Enterprise and E164 numbers linked to a directory number (from Numplan table).
	dnderived	Derived value of directory number
	dnormask	SIP alternate number, may be a mask.
	doroutebyroutestring	Indicates whether other clusters may route to this URI or number using route string.
	doroutelocal	Indicates whether the alternate number may be used for routing on the cluster on which it is defined.
	fknumplan	The directory number to which the alternate number belongs.
	fkroutepartition	The partition to which the URI belongs.
	isaar	Indicates whether this number is valid for dialing on the PSTN.
	istemplate	Distinguish the Universal Line Template with the real alternate number.
	isurgent	Indicates whether the alternate number is urgent.
	pkid	Unique ID to identify a record.
	tkglobalnumber	Functional classification, applies only to TEL URI.
analogaccess		This subclasses the device table for analog access information not in the Device table.
	fkdevice	Points to the device record being "subclassed." Device.tkModel must be analog access.
	pkid	Unique ID to identify a record.
	tktrunkselectionorder	IE. Bottom up or top down.
analogaccessport		Analog access ports associtated with an analog access Device.
	attendantdn	For Ground Start and Loop Start ports, enter the number to which you want incoming calls routed; for example, zero or a directory number for an attendant.
	calleriddn	If specified, use this for the CallerID.
	e164dn	E164 Directory Number
	expecteddigits	Enter the number of digits that are expected on the inbound side of the trunk. For this rarely used field, leave zero as the default value if you are unsure.
	fkdevice	device::tModel must be analog access
	inboundcalleridenable	If true, CallerID is enabled.
	numdigits	Enter the number of significant digits to collect. Cisco CallManager counts significant digits from the right (last digit) of the number called. Use this field for the processing of incoming calls and to indicate the number of digits starting from the last digit of the called number that is used to route calls coming into the PRI span. See Prefix DN.
	pkid	Unique ID to identify a record.
	portnum	1-8 For Vega; 1 for MGCP_STATION; 1 for MGCP_TRUNK and tkDeviceProtocol=AnalogAccess
	prefixdn	The prefix digits that are appended to the digits that this trunk receives on incoming calls. The Cisco CallManager adds prefix digits after it truncates the number in accordance with the Num Digits setting.
	sigdigits	Obsolete - NumDigits is always used. Flag to allow only certain amount of digits.
	smdiportnumber	Use this field for analog access ports that connect to a voice-mail system. Set the SMDI Port Number equal to the actual port number on the voice-mail system to which the analog access port connects.
	timer1	In Milliseconds
	timer2	In Milliseconds
	timer3	In Milliseconds
	timer4	In Milliseconds
	timer5	In Milliseconds
	timer6	In Milliseconds
	tkcallingpartyselection	Source of the calling party number: originator = 1, first redirect = 2, last redirect = 3
	tkdigitsending	DTFM, MF, etc.
	tkpresentationbit	CLID presentationBit: allowed = 1, restricted = 2
	tksilencesuppressionthreshold	in dbm0
	tkstartdialprotocol	Immediate, Wink Start, etc.
	tktrunk	The type of trunk. (Ground Start, Loop Start, DID, POTS, E&M)
	tktrunkdirection	Inbound, outbound and both are valid Directions. Outbound equates to DOD. Both only allowed on Ground Start (GS)
	tktrunklevel
	tktrunkpad_rx
	tktrunkpad_tx
	unattendedport
	xml	Product specific configuration XML not used by CCM
apdiscoveryschedule		Table to store the sync schedule information of Wireless LAN Controller or Cisco Prime Infrastructure
	fkapdiscoveryserver	AP Discovery Server with which the Schedule is associated.
	intervalvalue	IntervalValue combined with Schedule Unit determins how often to sync (e.g., every 2 Days or every 12 Hours).
	nextsynctime	Timestamp when next synchronization should happen for related WLC.
	pkid	Unique ID to identify a record.
	tkscheduleunit	Schedule Unit combined with IntervalValue determines how often to sync (e.g., every 2 Days or every 12 Hours).
apdiscoveryserver		Table to store the information of Wireless LAN Controller or Cisco Prime Infrastructure
	description	Description for Wireless Controller name.
	lastsynctime	Timestamp when last synchronization started.
	name	Host name of Wireless LAN Controller. Could also be FQDN or IP Address
	password	User Id password in v3 mode are stored in an encrypted format.
	pkid	Unique ID to identify a record.
	snmpprivacypassword	The SNMP privacy password in v3 mode are stored in an encrypted format.
	syncnow	SyncNow field is used to trigger a synchronization request for the related WLC.
	tksnmpauthenticationprotocol	The authentication protocol in v3 mode
	tksnmpprivacyprotocol	The privacy protocol in v3 mode
	tksnmpversion	Default value is 2c. In this mode we rely on community string setting.
	tksyncstatus	Status of synchronization for the related WLC.
	useridorcommunitystring	Holds either SNMP Community string in v2c or UserId in v3 mode.
applicationdialrule		Holds Dial Rule Info.
	description
	digitsremoved
	name
	numbeginwith
	numofdigits
	pkid	Unique ID to identify a record.
	prefix
	priority
	tkapplicationdialrule	The type of Dial Rule. (Basic, Directory)
applicationuser		Special Application users of CCM system. These users will not show up in a list of users shown to a customer
	aclallowreplace	Whether SIP header replacement allowed
	acloobsubscription	Obsolete
	acloodrefer
	aclpresencesubscription
	aclunsolicitednotification
	fkmatrix_presence	Pkid for Presence Group Matrix record. This is required for extension mobility. Appuser table does not need this because appuser cannot do extension mobility.
	isstandard	Created during installation.
	name	Records inserted by install.
	passwordreverse	Used for digest authentication
	pkid	Unique ID to identify a record.
	userrank	Rank of application user. Access control groups assigned to the application user should be either of equal or lower rank. Required reference to enum column of parent record in table UserRank
applicationusercapfmap		1-N relation between App User to CAPF
	authenticationstring
	fkapplicationuser
	instanceid	To distinguish multiplicity for a single user.
	packetcaptureduration
	pkid	Unique ID to identify a record.
	subjectname	Subject name of the certificate
	tkauthenticationmode
	tkcertificate
	tkcertificateoperation	Certificate Operation
	tkcertificatestatus
	tkeckeysize	EC Key Size(bits) for ApplicationUserCapfMap table
	tkkeyorder	Key Order for ApplicationUserCapfMap table
	tkkeysize
	tkpacketcapturemode
	upgradefinishtime
applicationusercapfmapdynamic		Frequently updated settings for Application User CAPF settings
	datetimestamp
	fkapplicationusercapfmap
	fkprocessnode	The server to which this user, with this certificate, has opened a CTI provider.
	pkid	Unique ID to identify a record.
	userstate
applicationuserdevicemap		Maps controllability between App Users & Devices.
	description	ApplicationUser-entered description of a controlled device (allows Unicode).
	fkapplicationuser
	fkdevice
	pkid	Unique ID to identify a record.
	tkuserassociation
applicationuserdirgroupmap		Similar to UserGroupMap to group ApplicationUser into a DirGroup
	fkapplicationuser
	fkdirgroup
	isstandard	If standard set true during installation. Standard groups are only modifiable by installations.
	pkid	Unique ID to identify a record.
applicationusernumplanmap		To keep M-N relation between App User & NumPlan
	fkapplicationuser
	fknumplan
	pkid	Unique ID to identify a record.
	tkdnusage
appserver		Denotes the various Application servers that a CCM communicates with
	administrationurl	Used to create a link to the Administrative application for the AppServer
	enduserurl	Used to create a link to the EndUser application for the AppServer
	fkprocessnode	Allows an application server's settings to be associated with a specific server in the cluster
	ipaddr	IP Address of the App server.
	name
	pkid	Unique ID to identify a record.
	tkappserver
appserverapplicationusermap		This table will hold the relationship on the CCM side between application server and application user used to log into application server
	content
	fkapplicationuser
	fkappserver
	pkid	Unique ID to identify a record.
appserverinfo		Contains info pertaining to App servers
	content
	fkappserver
	pkid	Unique ID to identify a record.
	tkappservercontent
availdialplan		Available DialPlan table
	availableversion	Version number of the Dial Plan installer
	description	Description of the Dial Plan (e.g., North American Numbering Plan)
	dialplan	Name of the Dial Plan (e.g., NANP)
	pkid	Unique ID to identify a record.
	systemdialplan	Unique ID of the Dial Plan as it appears in the DialPlan table (DialPlan.pkid)
axlchangenotifyclient		Lists all applications that can subscribe for AXL Change Notification.
	bitmap	To store the unique value for each client.
	clientname	Name of the application that can subscribe for Change Notification.
	networkid	NetworkID of Client.
	pkid	Unique ID for the table.
	pollingstarttime	Time from which Notification will be monitored.
	subscriberid	Subscription Unique Id whose value would be between 1 and 10.
axlchangenotifysubscribe		Maps each AXL Change Notify Client to the subscription type.
	fkaxlchangenotifyclient	Unique ID of the AXLChangeNotifyClient.
	pkid	Unique ID for the table.
	tkchangenotifysubscribe	Determines the class of Change Notification subscription : 0=User,1=Line,2=Phone.
batfileinfo		Information of BAT Files
	datecreated	Date when the file is uploaded
	enduser	User who created this job
	isfilefound	Date when the file is uploaded
	name	BAT File Name
	pkid	Unique ID to identify a record.
	tkbatfunction	File Transaction
batfileinfojobmap		Mapping of Fileinfo and job
	fkbatfileinfo
	fkbatjob
	pkid	Unique ID to identify a record.
batinputdata		Input data other than csv files
	data	Input Data for BAT Jobs
	name
	pkid	Unique ID to identify a record.
	tkbatfunction	Type of Input Data
	tkbatusage	Type of Input Data
batinputdatajobmap		Mapping pf BATInputData and Job
	fkbatinputdata
	fkbatjob
	pkid	Unique ID to identify a record.
batjob		Job submitted via BAT
	description	Description of the Job
	enduser	User who created this job
	fkdevice	Template Information is provided from this device
	fkenduser	Template Information is provided for this User
	fkmgcp	Template Information is provided from this MGCP
	fknumplan	Template Information is provided from this DNorPattern
	frequencyjobend	Denotes when a recurring job ends
	jobid	unique ID to track Jobs.
	pkid	Unique ID to identify a record.
	scheduleddatetime	Denotes the job schedule time.
	sequence	A number to resolve job execution order when they are scheduled together.
	submitdatetime	Denotes when the job is submitted
	tkbatfrequency
	tkbatfunction
	tkbatjobstatus	Holds the Status of the Job
batjobresults		Results of BAT Jobs
	fkbatjob	Job for which the results are displayed
	isfilefound	Status of the Job
	launchdatetime	Data time when job is started
	logfilename	Name of the log file
	numrecordsfailed	Number of Records Failed
	numrecordsprocessed	Total Number of Records processed
	numrecordstotal	Total Number of Records processed
	pkid	Unique ID to identify a record.
	tkbatresultstatus	Status of the Job
billingserver		Off cluster billing server
	directory
	enablecdroffloading	If set to false, CDRs are not offloaded to that particular billing server
	hostname	FQDN or IP
	password
	pkid	Unique ID to identify a record.
	preserve
	resendonfailure	Tells CDRM whether or not to send CDR/CMR fiiles after FTP connection is restored.
	selorder	order of server
	tkbillingserverprotocol	conf Bridge location
	userid
blfdirectedcallpark		Busy lamp monitor entries for Directed Call Park feature
	blfindex	This field identifies the Directed Call Park Monitor button on the phone (for example, 1, 2, 3, or 4).
	fkdevice
	fknumplan
	label	The text that appears for the BLF Directed Call Park button (allows Unicode).
	labelascii	A safe version of the BLF Directed Call Park Button Label using only English letters (a to Z) and punctuation.
	pkid	Unique ID to identify a record.
blfspeeddial		Keeps line status of internal DNs
	blfdestination	This is the number or url that the system dials when the user presses the speed-dial button.
	blfindex	This field identifies the speed-dial button on the phone (for example, 1, 2, 3, or 4).
	blfsdoptionbitmask	A Bitmask comprised of valid combinations of values from TypeBLFSpeedDialOption (0 or 1 in this release)
	fkdevice
	fknumplan	pointer to dn and partionion if null use destination
	label	The text that appears for the BLF Speed Dial button (allows Unicode).
	labelascii	A safe version of the BLF Speed Dial Button Label using only English letters (a to Z) and punctuation.
	pkid	Unique ID to identify a record.
blockingcsslookup		CUBA: To store a mapping between allowed calls and blocking CSS detailsS
	allowcallpark	check for callpark
	allowcallpickup	check for callpickup
	allowemergencycalls	check for emergency calls
	fkcallingsearchspace	Reference to CallingSearchSpace
	pkid	Unique identifier for the record
	tkcosrouting	reference to cosrouting
callerfilterlist		List of allowed or blocked callers for Mobility
	description
	fkenduser	Owner of CallerFilterList
	isallowedtype	False = Blocked; True = Allowed
	name
	pkid	Unique ID to identify a record.
callerfilterlistmember		Members of CallerFilterLists
	dnmask	DN mask (allows 0-9, *, #, mask character X and +). Pattern can start and end with wildcard character (!)
	fkcallerfilterlist
	pkid	Unique ID to identify a record.
	tkcallerfiltermask
callforwardalloverride		For DNs where forwarding is ignored allowing calls to ring through while a DN is forwarded (CFwdAll)
	callingpartynumber	Calling Party Number for which calls should not be forwarded
	fknumplan	NumPlan record for DN to which Override is applied (the forwarded line)
	pkid	Unique ID to identify a record.
callforwarddynamic		Frequently updated settings for Call Forward All
	cfadestination	Call Forward All (not a pattern)
	cfavoicemailenabled
	datetimestamp
	fkcallingsearchspace_cfa	Call Forward All
	fkcallingsearchspace_scfa	Secondary Call Forward All
	fknumplan
	pkid	Unique ID to identify a record.
callforwardhistorydynamic		To store the last 5 Call Forward destination DN updates done on a line
	datetimestamp	Uniform Integer representation of the most recent time that the corresponding DNOrPattern was used as a forward destination for the associated line
	dnorpattern	Indicates the CallForward DN associated with a line for a given timestamp
	fknumplan	Represents the line on which Call Forward was updated. This field is intentionally marked as NOT cascade delete since its a CUBA table
	pkid	Unique identifier for the record
callingsearchspace		For Dial Plan - devices call to a calling search space made up of route partitions.
	clause	Ordered list of colon separated RoutePartition Names via CallingSearchSpaceMember
	description	Description for CallingSerachSpace.
	dialplanwizardgenid	This record created by DialPlanWizard
	name	Unique name
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	tkpartitionusage	Defines use of CSS (Intercom or other)
	tkreset	Set by DeviceReset stored procedure.
callingsearchspacemember		Lists the RoutePartitions in a Calling Search Space.
	fkcallingsearchspace
	fkroutepartition
	pkid	Unique ID to identify a record.
	sortorder	Gaps in SortOrder are allowed - not rebuilt on delete
callmanager		Lists every CallManager in the system.
	ctiid	Trigger set on insert. Try to keep number as small so reuse missing numbers. This value is used by CCM to identify itself to other CCM applications on other servers in the cluster.
	description	Description of the Cisco CallManager.
	ethernetphoneport	Cisco CallManager uses this TCP port to communicate with the Cisco IP Phones on the network. Accept the default port of 2000 unless this port is already in use on your system. Ensure all port entries are unique. Valid port numbers range from 1024 to 49151.
	fklbmgroup	LBMGroup associated to a node. LBMGroup assigment is optional as long as LBM service is running locally on UCM node
	fkprocessnode	Select the server where this Cisco CallManager is installed.
	mgcpkeepaliveport	Cisco CallManager uses this TCP port to exchange keepalive messages with its associated MGCP gateway. Accept the default port of 2428 unless this port is already in use on your system. Ensure all port entries are unique. Valid port numbers range from 1024 to 49151.
	mgcplistenport	Cisco CallManager uses this TCP port to detect messages from its associated MGCP gateway. Accept the default port of 2427 unless this port is already in use on your system. Ensure all port entries are unique. Valid port numbers range from 1024 to 49151.
	name	Name of this CallManager.
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	sipoauthmraport	Cisco CallManager uses this port for secure SIP communication with MRA devices registered over Expressway. Ensure all port entries are unique. Default port value is 5091. Valid port numbers range from 1024 to 49151. Port 999999 is reserved for scenario when no port is available to be opened as SIPOAuthMRAPort.
	sipoauthport	Cisco CallManager uses this port for authenticated communication with end points (Jabber) connecting over SIP protocol. Ensure all port entries are unique. Default port value is 5090. Valid port numbers range from 1024 to 49151. Port 999998 is reserved for scenario when no port is available to be opened as SIPOAuthPort.
	sipport	Cisco CallManager uses this port to communicate with the Cisco IP Phones on the network for SIP protocol. Accept the default port of 5060 unless this port is already in use on your system. Ensure all port entries are unique. Valid port numbers range from 1024 to 49151.
	sipsecuredport	Cisco CallManager uses this port for secured communication with the Cisco IP Phones on the network for SIP protocol. Accept the default port of 5061 unless this port is already in use on your system. Ensure all port entries are unique. Valid port numbers range from 1024 to 49151.
	tkreset	Set by DeviceReset stored procedure.
callmanagergroup		Used for redundancy and rehoming of devices
	name	Name of the CallManager group.
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	tftpdefault	Whether this Cisco CallManager group is the default Cisco CallManager group when auto-registration is enabled. Note : Each Cisco CallManager cluster can have only one default auto-registration group.
	tkreset	Set by DeviceReset stored procedure.
callmanagergroupmember		Ordered membership of CallManagers in CallManagerGroups
	fkcallmanager
	fkcallmanagergroup
	pkid	Unique ID to identify a record.
	priority	CallManager Groups are made up of an ordered list of from one to three CallManagers. This field orders the members of the group. There is no requirment for a member in a group to be at priority 0. Nor is there a requirment that the priorities be sequential within a CallManager Group.
callpark		Table for storing CTI ID for ParkDNs
	ctiid	Serial Unique ID for CTI
	fknumplan	CallPark number in NumPlan
	pkid	Unique ID to identify a record.
carrierselectcodedetails		CUBA: Code details for particular carrier
	fkcarrierselectprofile	Reference to Carrier Select Profile entry
	pkid	Unique identifier for the record
	tkcarrierselectcode	Reference to TypeCarrierSelectCode
	value	Reference to TypeCarrierSelectCode
carrierselectprofile		CUBA: Profiles for different carriers
	description	Description for CS Profile.
	name	Unique name
	pkid	Unique identifier for the record
carrierselectprofiletrunkmap		CUBA: Mapping between Profile and Trunks
	fkcarrierselectprofile	Reference to Carrier Select Profile entry
	fkdevice	indirect from DeviceName
	pkid	Unique identifier for the record
ccaprofile		This profile contains CCA-ID, Softswitch ID, Object Class field, Subscriber Type field, SIP Alias suffix, Sip User Name field suffix made configurable.
	ccaid	The LDAP server that stores the Directory Number Alias records uses this field to appropriately authorize subsequent updates of the records in the LDAP Database. The Directory Number Alias server will only allow update operations on a record originating from the CUCM cluster that originally added the record by identifying the CUCM Cluster Identifier set in this field.
	ccaprofile_id	Unique id to CCAProfile which would be use in numplan table
	objectclass	This field when configured specifies the object class in the LDAP Routing database to which the Directory Number record will belong to when the Directory Number is pushed by the DN Alias Sync server
	pkid	Unique ID to identify a record.
	primaryccasoftswitchid	The LDAP server that stores the Directory Number Alias records uses this field to appropriately authorize subsequent updates of the records in the LDAP Database. The Directory Number Alias server will only allow update operations on a record originating from the CUCM Primary Soft Switch that originally added the record by identifying the CUCM Primary Soft Switch Identifier set in this field.
	secondaryccasoftswitchid	The LDAP server that stores the Directory Number Alias records uses this field to appropriately authorize subsequent updates of the records in the LDAP Database. The Directory Number Alias server will only allow update operations on a record originating from the CUCM Secondary Soft Switch that originally added the record by identifying the CUCM Secondary Soft Switch Identifier set in this field.
	sipaliassuffix	This field when configured specifies the prefix that is added to the full Commericial number before it is stored in the SIP Alias field in the LDAP Routing database.
	sipusernamesuffix	This field when configured specifies the prefix that is added to the User ID field before it is stored in the SIPuserName field in the LDAP Routing database.
	subscribertype	This field when configured specifies the Subscriber Type in the LDAP Routing database of the Directory Number when the Directory Number is pushed by the DN Alias Sync server
ccdadvertisingserviceprofile		Call Control Discovery Advertising Profile for Call Manager
	fkccdhosteddngroup	pkid of Hosted DN Group
	fkdevice_ict	pkid of ICT Trunk
	fkdevice_sip	pkid of SIP Trunk
	fksafservices	pkid of the row in the SAFServices Table
	pkid	Unique ID to identify a record.
	resettoggle	Reset toggle CCD service
ccdhosteddn		CCD Hosted DN Pattern
	description	Description of the Time Period, up to 128 characters including Unicode
	fkccdhosteddngroup
	hostedpattern	This is the Dn to be advertized
	pkid	Unique ID to identify a record.
	pstnfailoverprependdigits	This is a PSTN Failback Prepend Digites
	pstnfailoverstripdigits	PSTN Failover Strip Digits
	usedforpstnfailover	Used existing hosted DN for PSTN failover
ccdhosteddngroup		CCD Hosted DN Group
	description	Description is up to 128 characters including Unicode
	name	name of the Hosted DN group
	pkid	Unique ID to identify a record.
	pstnfailoverprependdigits	This is a PSTN Failback Prepend Digites
	pstnfailoverstripdigits	PSTN Failover Strip Digits
	usedforpstnfailover	Used existing hosted DN for PSTN failover
ccdrequestingserviceprofile		Call Control Discovery Receiving Profile for Call Manager
	fkroutepartition	pkid of Route Partition
	fksafservices	pkid of the row in the SAFServices Table
	learnedpatternprefix	This is a Prefix
	pkid	Unique ID to identify a record.
	pstnprefix	This is a Prefix
	resettoggle	Reset toggle CCD service
cdrmconfig		Similar to process config for CDR
	cdrcmrfiledeletiondisabled
	cdrrepmgrhostaddress	CDR Repository Manager host IP address string in textual presentation
	cdrrepmgrhostname	CDR Repository Manager host name
	diskallocation	in Megabytes
	highwatermark	percentage
	lowwatermark	percentage
	pkid	Unique ID to identify a record.
	windowsize	number of days of CDR files to preserve
certificate		Certificate Information
	certificate	Certificate
	ipv4address	IPv4Address
	ipv6address	IPv6Address
	issuername	Name of issuer
	pkid	Unique ID to identify Certificate record
	serialnumber	hex representation of serial number
	servername	Name of the server
	subjectname	Name of subject
	timetolive
	tkcertificatedistribution	Type of certificate.
certificatehashmap		Certificate Hash Map
	fkcertificate	Reference to Certificate record
	hash
	pkid	Unique ID to identify certificatehashmapdynamic record
	tkhash
certificateprocessnodemap		Certifiacte Process Node Mapping
	fkcertificate	References Certificate Record
	fkprocessnode	associated processnode
	ipv4address	IPv4Address
	ipv6address	IPv6Address
	pkid	Unique ID to identify CertificateProcessNodeMap record
	servername	Name of the server
certificateservicecertificatemap		Maps each certificate service to its respective certificate
	fkcertificate	Pkid of the Certificate for the corresponding Certificate Service
	pkid	Unique ID to identify a CertificateServiceCertificateMap record
	tkcertificateservice	The enum value of Certificate service defined in the TypeCertificateService table
certificatetrustrolemap		Certifiacte Trust Role
	fkcertificate	Reference to certificate
	pkid	Unique ID to identify CertificateRoleMapDynamic record
	tktrustrole	Reference to typetrunstrole
cloudheartbeatdetails		Table to store the heart beat details for cloud operations.
	clusterid	The cluster id is to unqiuely identify this cluster on Cisco Cloud.
	heartbeaturl	URL for Cisco Management Agent Service to send heartbeat to Cisco Cloud services.
	miscellaneous	This field stores all the micellaneous urls that are needed to access Cisco Cloud.
	pkid	Unique ID to identify a record.
cmcinfo		Contains the authorization information for Client Meta Code
	code	All Digits
	description
	pkid	Unique ID to identify a record.
codeclist		This table documents the existence of a named, ordered list of the codecs supported by the system. Records marked as IsStandard are not eligible for user modification nor are their associated member lists eligible for user change.
	description	Localizable description of the Codec List.
	isstandard	Indicates whether the Codec List is Standard or not. A Standard Codec List is not eligible for user modification nor its associated member lists eligible for a user change. Created during installation. 2 Standard Codec Lists - Lossy,Low-Loss.
	name	Name of the Codec List supported by the system. Records marked as isStandard are not eligible for user modification nor are their associated member lists eligible for a user change.
	pkid	Unique ID to identify a record.
codeclistmember		This table records the ordered set of codecs for each defined CodecList. Records associated with a CodecList which is NOT IsStandard may be re-ordered.
	fkcodeclist	Unique ID of the Codec List. Identifies the Codec to be a Lossy or Low-Loss Codec.
	pkid	Unique ID to identify a record.
	preferenceorder	Determines the preference of Codec within a single Codec List. The same Codec in two different lists (Lossy and Low-Loss) can have different preference order in both the lists. The preference order can be changed by the user.
	tkcodec	Determines the type of Codec. Refers to the Codec supported by the system.
commondeviceconfig		Used for DeviceMobility. Have user oriented fields.
	calreference	user can assign confidential access level value to the group of devices
	fkmlppdomain	This is the MLPP domain associated with this profile. If this field is blank, this devices using this profile inherit the MLPP domain from the value set for the MLPP Domain Identifier enterprise parameter.
	fksoftkeytemplate	This is the softkey template that is associated with the devices using the profile.
	holdpartynetworkholdmohaudiosourceid	This is the audio source to use for music on hold (MOH) when the network initiates a hold action.
	holdpartyuserholdmohaudiosourceid	This is the audio source to use for music on hold (MOH) when a user initiates a hold action.
	name
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	tkcalmode	user can assign confidential access level mode to the group of devices
	tkipaddressingmode	Indicates the IPaddressingMode of device, ipv4, ipv6 or both type of IP addresses
	tkipaddressingmodeprefcontrol	Indicates what IP type device should connect to UCM if device has both IP's availab
	tkpreemption	This setting specifies whether devices using the profile and capable of preempting calls in progress will use the capability when the devices place an MLPP precedence call. Note : Do not configure a profile with the following combination of settings: MLPP Indication is set to Off or Default (when default is Off) while MLPP Preemption is set to Forceful.
	tkreset	Set by DeviceReset stored procedure.
	tkstatus_allowipv6autoconfigforphones
	tkstatus_allowipv6duplicateaddressdetection	Allow Duplicate Address Detection for CommonDeviceConfig.This parameter determines whether the duplicate address detection should be performed on each of the addresses in any identity associations(IAs) it receives in the Reply message before using that address for traffic.
	tkstatus_ipv6acceptredirectmessages	Accept Redirect Messages for CommonDeviceConfig.This parameter provides an ability to accept or ignore the redirect messages.
	tkstatus_ipv6replymulticastechorequest	Reply Multicast Echo Request for CommonDeviceConfig.This parameter allows the phone to enable or disable the ability to send an Echo Reply message in response to an Echo Request message sent to an IPv6 multicast or anycast address.
	tkstatus_mlppindicationstatus	This setting specifies whether devices using the profile and capable of playing precedence tones will use the capability when the devices place an MLPP precedence call. Null means uses enteprise value. Note : Do not configure a profile with the following combination of settings: MLPP Indication is set to Off or Default (when default is Off) while MLPP Preemption is set to Forceful.
	tkstatus_viprenabled	Is ViPR enabled on this device common config
	tkuserlocale	This is the locale that is associated with the phones and gateways using the profile. The user locale identifies a set of detailed information to support users, including language and font. Note : If this is null, the locale that is specified in the Cisco Unified CallManager clusterwide parameters as Default User Locale applies.
	usetrustedrelaypoint	Indicates whether Trusted Relay Point should be used if available
	versionstamp	New guid plus seconds past midnight 1970 are concatenated
commonphoneconfig		Common Profile Information (only applies to SIP intially)
	description
	fkfeaturecontrolpolicy	Feature Control Policy Record
	fkvpngroup	References VPNGroup Record Null allowed, null by default
	fkvpnprofile	References VPNProfile Record Null allowed, null by default
	fkwifihotspotprofile	Reference to WiFi HotspotProfile.
	isstandard	Whether it is standard
	name
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	sshpassword	SSH Password
	sshuserid
	tkdndoption	Type of call handling while DND is enabled (0=Ringer Off, 1=Call Reject); depends on product support
	tkphonepersonalization
	tkphoneservicedisplay	Identifies which services are displayed for a button (services, directories, messages): Internal, External, Both, or Default (use Enterprise Parameter value)
	tkreset	Set by DeviceReset stored procedure.
	tkringsetting_dnd
	tkstatus_alwaysuseprimeline	Determines off-hook behavior of phones with active calls present
	tkstatus_alwaysuseprimelineforvm	Determines Voice Message retreival behavior of phones
	versionstamp	New guid plus seconds past midnight 1970 are concatenated
	zzbackgroundimageaccess	is background Image Access Enabled
	zzunlockpassword	unlock password
commonphoneconfigxml		XML configuration for Common Phone Config
	fkcommonphoneconfig
	pkid	Unique ID to identify a record.
	xml	Product configuration XML not used by CCM
componentversion		RPM versions of components
	fkprocessnode
	installationcomponent
	pkid	Unique ID to identify a record.
	softwarecomponent
	version
confidentialaccesslevel		Access level and Text selection
	enum	unique identifier for ConfidentialaccessLevel
	name	Unique name given to this specific Confidential Access Level
confidentialaccesslevelmatrix		Selection Resultant based upon incoming and outgoing CAL level
	confidentialaccesslevel_in	Incoming confidential access level which would be assigned to device or trunk or line
	confidentialaccesslevel_out	Outgoing confidential access level which would be assigned to device or trunk or line
	confidentialaccesslevel_result	Resolved confidential access level from the incoming and outgoing confidential access level
	enum	unique identifier for Records of the confidential access level matrix
corsdomain		Cross-Origin Resource Sharing (CORS)
	description	Description of the CORS Domain.
	isfullaccess	If true then is full access, else read only
	name	Specifies the Domain for Cross-Origin Resource Sharing (CORS)
	pkid	Unique ID to identify a record.
credential		Authentication information and policies for App and End Users
	cantchange	A flag indicating whether the user can set this credential.
	credentials	The PIN or password, for a user. The credentials are stored in an encrypted format.
	credmustchange	A flag indicating whether the user must change their credentials (PIN or password) at the next login.
	doesntexpire	A flag indicating whether this user credential will expire, and therefore the user must change the credential periodically. However, if the credential does not expire (value = "1"), the user still may change the credential (if allowed by CantChange).
	fkapplicationuser	The unique identifier of the Application User to which this credential belongs.
	fkcredentialpolicy	The unique identifier of the CredentialPolicy that is associated with this credential.
	fkenduser	The unique identifier of the End User to which this credential belongs.
	imsinfo	Information used by IMS to encrypt data
	pkid	Unique ID to identify a record.
	timeadminlockout	The date and time that the credential was locked by an administrator.
	timechanged	The date and time when the credentials were last changed. The date and time is recorded in this column whenever a user credential is created or changed.
	tkcredential	The type of credential such as password, PIN, Windows or Domino credential.
credentialdynamic		Frequently updated settings for Credentials
	datetimestamp	Time value for last change (for replication conflict resolution)
	fkcredential	Parent record for which this record holds the dynamic settings
	hackcount	The number of logons attempted that failed due to invalid credentials. The Unity system or external authentication provider determined that the credentials supplied as part of a user logon attempt were invalid.
	lastsuccessfulloginip	Last successful login IP address
	lastsuccessfullogintime	Time value for the last successful login reported by IMS
	lastunsuccessfulloginip	Last un-successful login IP address
	pkid	Unique ID to identify a record.
	previoushackcount	The number of logons attempted that failed due to invalid credentials
	prevlastsuccessfullogintime	Time value for the previous last successful login reported by IMS
	timehackedlockout	The date and time that the credential was locked due to too many hacks. The date and time is recorded in this column whenever a user credential is locked due to too many hacks based on the credential policy.
	timelastaccessed	Time value for the last access of the credential (create, read or update)
	timelasthacked	The date and time of the last logon attempt with an invalid user credential.
credentialhistory		Stores past credentials for enforcement of password history restrictions (non-reuse)
	changeid	A historical index of credential changes. Allows the fetching of the last 'n' credentials, if desired.
	credentials	The credential, e.g., PIN or password created by this change. Credentials can be an encoded PIN or password.
	fkapplicationuser	The unique identifier of the ApplicationUser object for which this credential change occurred.
	fkenduser	The unique identifier of the EndUser object for which this credential change occurred.
	pkid	Unique ID to identify a record.
	timechanged	The date and time the credential was created or changed.
	tkcredential	The type of credential such as a password or PIN.
credentialpolicy		Settings for enforcement of credential policy (password strength, expiration, etc.)
	displayname	The unique text name (e.g., "Administrator Password Policy") of the credential policy to be used when displaying entries in the administrative console, e.g. Cisco Unified CallManager Administration
	expirywarningdays	Number of days prior to Credential Expiring that warning message should be presented to the user. A value of 0 means no warning is given.
	hackresettime	The length of time (in minutes) after which if no failed logon attempts occur, the count of failed logon attempts is cleared
	isstandard	Indicates installed standard Credential Policy - cannot be modified or deleted
	lockoutduration	The length of time (in minutes) that a user who is locked out must wait until they can attempt to access the system again with this credential. A value of "0" means the user is locked out until the credential/account is unlocked by an administrator.
	maxdays	The maximum number of days before the credential must be changed. A value of "0" means the credential will never expire.
	maxhacks	The maximum number of failed logon attempts (hacks) before action is taken. A value of "0" means an unlimited number of logon attempts (i.e., no lockout) are allowed.
	maxinactivedays	The number of days after which a credential is disabled if not used. A value of 0 means the credential is never disabled because of inactivity
	mincharstochange	The minimum number of characters change between old and new password.
	minduration	The minimum number of minutes that must pass from the time of the last change before the credential can be changed. A value of "0" means that there are no restrictions on how often the user can change the credential.
	minlength	The minimum number of characters or digits (PIN) required for the credential.
	pkid	Unique ID to identify a record.
	prevcredcount	The number of credentials to store. A value of "0" means that a new credential is not compared with previous credentials; thus a user can reuse a credential.
	trivialcredchecking	A flag indicating whether to check against trivial credentials for extra security; True = check to make sure credentials are not trivial; False = do not check for trivial credentials (check length and valid characters only)
credentialpolicydefault		Specifies the default CredentialPolicy for each combination of user and credential type
	cantchange	A flag indicating whether the user can set this credential.
	credentials	The default PIN or password for new credentials. The credentials are stored in an encrypted format.
	credmustchange	A flag indicating whether the user must change their credentials (PIN or password) at the next login.
	doesntexpire	A flag indicating whether this user credential will expire, and therefore the user must change the credential periodically. However, if the credential does not expire (value = "1"), the user still may change the credential (if allowed by CantChange).
	fkcredentialpolicy	The default Credential Policy for new credentials of the specificed type (credential and user)
	imsinfo	Default Information used by IMS to encrypt data
	pkid	Unique ID to identify a record.
	tkcredential	Used in combination with type of Credential User to establish a default
	tkcredentialuser	Used in combination with type of Credential to establish a default
crsapplication		Application specific data for CRS
	aakeypadmapping	The mapping of aapromptname to numbers only
	aapromptname	The letter representation of the search name using IVR
	fkenduser
	fnamealtpronun	First Name Alternate Pronunciations delimited by a seperator
	lnamealtpronun	Last Name Alternate Pronunciations delimited by a seperator
	pkid	Unique ID to identify a record.
crsuserclusterspecific		Stores user information for the CRS Application
	administratorlevel	Whether an Administrator
	clustername
	fkenduser
	issupervisor	Whether a Supervisor
	pkid	Unique ID to identify a record.
cubacountryregionalinfo		CUBA: Table to store Country Regional Packs on Cuba platform.
	pkid	Unique identifier for the record
	tkcountry	Country id from typecountry table.
	xml	Ring Tones and Other Region Specific Product configuration XML not used by CCM
cubaproductsupport		CUBA:CubaProductSupport table to store the models that are supported in Pajaro system
	displayname
	enum	A number to identify the record
	tkcubaproductdisplaygroup	A number to identify the record
	tkdeviceprotocol	Enum of Device Protocol record
	tkmodel
	tkproduct
customannouncement		subset of TypeAnnouncement with rows having AllowCustom = 1
	description	Description of the custom announcements
	issystem	isSystem is an internal control for ipvms install to pre-configure some CustomAnnouncement entries with UI restriction (user cannot edit some fields). Records which have initial contents may be altered by the administrator, but may not be removed.
	name
	pkid	Unique ID to identify a record.
	tkannouncementfile	A number to identify the record
	tkannouncements	A number to identify the record
customannouncementlocale		null
	description
	filename
	fkcustomannouncement
	highsourcefiledatetime
	isenabled
	lowsourcefiledatetime
	pkid	Unique ID to identify a record.
	tkuserlocale	reference to TypeUserLocale
customer		Used for HCS-SA to differenciate the customers in the DB
	createtime	UTC time of creation
	lastaudittime	UTC time of last Audit
	name	A unique name for Customer
	pkid	Unique ID to identify a record.
customuserattributedata		Stores data to be syncronized to respective Custom Field Attribute. Each Record is associated to an End User and mapped to each supported TypeCustomUserAttributes
	fkenduser	Key Reference to the User to whom the data in the Value column applies.
	pkid	Unique ID to identify a record.
	tkcustomuserattribute	This field is to map one of the 5 available custom field to the Data in CustomUserAttributeName table.
	value	Data retrieved from LDAP for the specified Custom Attribute for the user associated with this record.
customuserattributename		Records in this table contain Configurable friendly names to all the Custom Field attributes defined in TypeCustomUserAttributes
	customfieldattributename	CustomFieldAttributeName field stores the name of the attribute during LDAP syncronization of EndUsers.
	pkid	Unique ID to identify a record.
	tkcustomuserattribute	This field is to map one of the 5 available custom field to the Name in CustomUserAttributeName table.
datetimesetting		Common/shared date time zone and format settings
	datetemplate	Template to be used to display date on an IP Phone. If the last character is 'A' then it is 24 hour time. Otherwise, it is 12 hour time.
	name	A descriptive name for the Date/Time group.
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	tkreset	Set by DeviceReset stored procedure.
	tktimezone	Time zone for the CallManager group. The option "local time zone of CallManager" copies the time zone information from the operating system of the server where Cisco CallManager is installed.
defaults		CallManager specific default attributes for devices
	fkdevicepool	Device pool that is associated with each type of device. The device pool defines common characteristics for all devices in the pool.
	fkphonetemplate	This is the phone template to assign to a device that auto-registers. It must be usable on the specified model.
	inactiveloadinformation	The filename of the inactive firmware load that is used with phone models that support dual-bank firmware (background download). The file is fed to the phones via TFTP but is not active. This can be overridden at the device level. If not overridden, then all devices of this model will download this firmware load file as the inactive load.
	loadinformation	The filename of the firmware load that is used with a particular type of hardware device model. The file is fed to the phones via TFTP. This can be overridden at the device level. If not overridden, then all devices of this model will use this firmware load file.
	pkid	Unique ID to identify a record.
	preferactcodeoverautoreg	Does this phone model support and prefer using activation codes over auto registration
	resettoggle	Should this device or group be reset
	tkdeviceprotocol	Default value for Device Protocol
	tkmodel	A defaults record must exist for every IP Phone.
	tkreset	Set by DeviceReset stored procedure.
	versionstamp	New guid plus seconds past midnight 1970 are concatenated
defaultucuserprofile		Indicates which UCUserProfile record is the System Default if left unspecified where needed.
	fkucuserprofile	Defines which UCUserProfile should be used when one is required but left unspecified.
	pkid	Unique ID to identify a record.
destinationcodecontrol		Allows configuration of outbound traffic throttling for a specific dialing plan destination, (Route Pattern), in accordance with DOD UCR 2008 specifications related to Destination Code Control, (DCC).
	blockedcallpercentage	This value specifies the percentage of lower precedence calls made to this destination that get blocked by the route pattern. This percentage limits the lower precedence calls only, the flash and higher precedence calls made to this destination are allowed at all times.
	enabledccenforcement	Allows the application and enforcement of the restrictions specified in this DCC record to be enabled or disabled so that the specifications may be left intact without being active.
	fknumplan	Indicates the associated DN or Pattern, (RoutePattern), to which this record's DCC specifications apply
	pkid	Unique ID to identify a record.
device		Lists every device in system from the CallManager perspective
	allowcfbcontrolofcallsecurityicon	Allow Conference Bridge control of the call security icon
	allowcticontrolflag	If true, this device allows CTI Control.
	allowhotelingflag	If true, this device allows extension mobility.
	allowmramode	The administrator may set this to TRUE to permit a user to Onboard and Register a Mobile / Remote Access, (MRA), device via the Activation Code Based Onboarding feature. Neither this setting, nor any change to it, has any current effect on devices already registered, irrespective of their means of onboarding, or on those being onboarded manually. By intent, this setting would affect the scope of issued OAuth tokens, granted during Activation Code Based Onboarding, to avoid automatically enabling all such phones for MRA use.
	authenticationstring
	calledinternationalprefix	Called International Prefix
	calledinternationalstripdigits	Called International Strip Digits
	callednationalprefix	Called National Prefix
	callednationalstripdigits	CalledNational Strip Digits
	calledsubscriberprefix	Called Subscriber Prefix
	calledsubscriberstripdigits	Called Subscriber Strip Digits
	calledunknownprefix	Called Unknown Prefix
	calledunknownstripdigits	Called Unknown Strip Digits
	calreference	user can assign confidential access level value to the device
	ctiid	Trigger set on insert. (one greater than highest). 32 bit value for Computer Telephony Interface
	datetimeinserted	Date and Time when Phone was inserted. Will be provided by an active B-Rule on device insert. Format is YYMMDD:HrMinSec
	defaultdtmfcapability	Is this a dead field?
	description
	deviceleveltraceflag
	dialplanwizardgenid	This record created by DialPlanWizard
	dndtimeout	Period in minutes to remind the user that DND is active
	earlyoffersupportforvoicecall	True-AS-SIP endpoints supports early offer for voice calls; False-AS-SIP endpoints supports delayed offer for voice calls. The default value is False.
	ecpublickeycurve	EC key size(bits) for device table
	enableactivationid	true indicates activation is enabled
	enablebfcp	Boolean flag to control whether or not Binary Floor Control Protocol (BFCP) is enabled for this device.
	enablecallroutingtordwhennoneisactive	This flag is used to determine if Call has to be forwarded to all Remote destinations or not.
	enablegatewayrecordingqsig	Allow sending recording control adpu on qsig link.
	enableixchannel	Boolean flag to control whether or not iX Channel is enabled for this device.
	fkaarneighborhood	Used by both gateway and Phone
	fkcallingsearchspace
	fkcallingsearchspace_aar
	fkcallingsearchspace_calledintl	Called Party International Number
	fkcallingsearchspace_callednational	Called Party National Number
	fkcallingsearchspace_calledsubscriber	Called Party Subscriber Number
	fkcallingsearchspace_calledunknown	Called Party Unknown Number
	fkcallingsearchspace_cdpntransform	If useDevicePoolCdpnTransformCSS is set to False this transformation will be applied on the called party
	fkcallingsearchspace_cgpningressdn	Calling search space applied to calling party number on ingress from the calling device
	fkcallingsearchspace_cgpnintl	Calling Party International Number
	fkcallingsearchspace_cgpnnational	Calling Party National Number
	fkcallingsearchspace_cgpnsubscriber	Calling Party Subscriber Number
	fkcallingsearchspace_cgpntransform	Calling Search Space for Calling Party Name Transformation Pattern
	fkcallingsearchspace_cgpnunknown	Calling Party Unknown Number
	fkcallingsearchspace_rdntransform	If useDevicePoolRdnTransformCSS is set to False this transformation will be applied on the Redirecting Number
	fkcallingsearchspace_refer	Pkid of CallingSearchSpace record for refer called Rerouting Calling Search Space in Admin
	fkcallingsearchspace_reroute	Pkid of CallingSearchSpace record for rerouting called Out-of-dialog Refer Calling Search Space in Admin
	fkcallingsearchspace_restrict	Pkid of CallingSearchSpace record for restriction
	fkcallmanagergroup	Used only by some Gateways.
	fkcommondeviceconfig
	fkcommonphoneconfig
	fkdevicepool
	fkdialrules	Pkid of DialRules record
	fkelingroup	ELINGroup record used by this Device
	fkenduser	This is the id of currently logged on user if EM is being used, or the owner of the device if EM is not being used.
	fkenduser_mobility	End User that owns Dual-Mode, SNR Device, or deskphone with Mobility button (for Cell Pickup)
	fkfeaturecontrolpolicy	Feature Control Policy Record
	fkgeolocation
	fkgeolocationfilter_lp
	fklocation
	fkmatrix_presence	delete likely, use securityprofile
	fkmediaresourcelist
	fkmlppdomain	null means uses device pool value
	fkmobilesmartclientprofile	Type of Smart Client for smart client devices and dual-mode phones
	fkmraservicedomain	Pkid of the MRA service domain
	fkphonetemplate	If tModel.tClass is not phone, then this is NULL
	fkprocessnode	This is the node this device is running on if the device is a process.
	fksecurityprofile	Foreign Key to Security Profile
	fksipprofile
	fksoftkeytemplate	association between device and softkey template
	fkvipre164transformation
	fkwifihotspotprofile	Reference to WiFi HotspotProfile.
	fkwirelesslanprofilegroup	Reference to Wireless LAN Profile Group.
	hotlinedevice	TRUE if this is a Hotline device
	huntlistforvm
	ignorepi
	ikdevice_defaultprofile	Points to the profile to log in when "logout" is called. If an insert or update is performed, and this field is NULL, then generate an auto-generated profile based on this device's current settings. If this value was pointing to a AGP, then delete the old AGP. If the AllowHotellingFlag is true.
	ikdevice_primaryphone	Primary Phone associated with this device
	internationalprefix	International Prefix
	internationalstripdigits	International Strip Digits
	isactive	Determines whether a phone consumes licenses and can register with CUCM. Intended to allow BAT dummy phones to be provisioned for use with TAPS without consuming additional licenses.
	isdualmode	Indicates a remote destination is a dual-mode phone; set based on device type
	ispaienabled
	isprotected	Device is used for secure calls with supplementary services disabled
	isrpidenabled
	isstandard	if set to true, then this device cannot be inserted or deleted, except by another business rule or the install
	istrustedrelaypoint	Applies to MTP or transcoder that acts as Trusted Relay Point for virtual networks
	lscissuername	This is LSC issuer name of device.
	lscissuervaliduntil	This field is expiry date of LSC Issuer(CAPF) for a device. Format of the date is time_t saved as long
	lscvaliduntil	This field is expiry date of LSC for a device. Format of the date is time_t saved as long.
	md5hash
	msisdn	Mobile Device MSISDN.
	mtprequired
	name	URL friendly characters; 15 char for non MGCP devices else XXX@MGCPDomainName
	nationalprefix	National Prefix
	nationalstripdigits	National Strip Digits
	ndescription	Copy of Description used for collating
	networkholdmohaudiosourceid
	packetcaptureduration	Duration in minutes
	pkid	Unique ID to identify a record.
	pstnaccess
	publickey
	remotedevice
	requirecerlocation	Enables CER tracking of the device
	requiredtmfreception
	resettoggle	Should this device or group be reset
	retryvideocallasaudio
	rfc2833disabled
	routelistenabled
	runonallnodes	The Run On All Nodes flag allows logical device definitions, (such as a SIP Trunk Handler Process), to be defined once and then marked to execute on each node. This reduces admin effort and inter-node handoff processing
	sendgeolocation	If true the GeoLocation is sent for the device else not
	specialloadinformation	Used only by devices with firmware loads
	srtpallowed
	srtpfallbackallowed	Allow fallback to Local SRTP
	sshpassword	SSH password for phone
	sshuserid	SSH userid for phone
	subscriberprefix	Subscriber Prefix
	subscriberstripdigits	Subscriber Strip Digits
	subunit
	tkbarge
	tkcalmode	user can assign confidential access level mode to the device
	tkcertificateoperation	Certificate Operation
	tkcertificatestatus
	tkclass	Redundant. Use tkModel to look up Class in TypeModel table.
	tkcountry
	tkdeviceprofile	Is this record a profile or real device
	tkdeviceprotocol
	tkdevicetrustmode	Allows for administrative control of the display of secure icon for specified device types. Options are Trusted and Not Trusted.
	tkdndoption	Type of call handling while DND is enabled (0=Ringer Off, 1=Call Reject); depends on product support; overrides CommonPhoneConfig setting
	tkdtmfsignaling
	tkkeyauthority	TypeKeyAuthority
	tkmodel	Redundant. Use tkProduct to look up tkModel in TypeProduct table.
	tknetworklocation	Stores OffNet/OnNet info
	tkoutboundcallrollover	Determines rollover behavior of phones when MaxNumCalls is exceeded on a line and a new call is started
	tkpacketcapturemode
	tkphonepersonalization
	tkphoneservicedisplay	Identifies which services are displayed for a button (services, directories, messages): Internal, External, Both, or Default (use CommonPhoneConfig value)
	tkpreemption
	tkproduct	Product type does not support Control of Call Security Icon Aggregation
	tkproduct_base	Is this a dead field? Used by GW?
	tkprotocolside	Network side or User Side
	tkqsig
	tkreset	Set by DeviceReset stored procedure.
	tkringsetting_dnd
	tksipassertedtype	SIP Asserted Type only applies to SIP Trunk. Other Device should set to default (0)
	tksipcodec_mtppreferredorigcodec	Preferred Originating Codec (G711u, G711a, G729a, G729ab, G729b)
	tksipprivacy	SIP Privacy only applies to SIP Trunk. Other Device should set to default (0)
	tkstatus_alwaysuseprimeline	Determines off-hook behavior of phones with active calls present
	tkstatus_alwaysuseprimelineforvm	Determines Voice Message retreival behavior of phones
	tkstatus_audiblealertingbusy	Indicates whether Audible Alert tone is played when phone is busy (call active); Default means use the Service Parameter setting
	tkstatus_audiblealertingidle	Indicates whether Audible Alert tone is played when phone is idle (no call active); Default means use the Service Parameter setting
	tkstatus_builtinbridge
	tkstatus_devicemobilitymode
	tkstatus_joinacrosslines	Protected phone cannot have Join Across Line Features active
	tkstatus_mlppindicationstatus
	tkstatus_usetrustedrelaypoint	Indicates whether Trusted Relay Point should be used if available
	tktrustreceivedidentity
	tkuserlocale	User local of device, see device pool if null
	transmitutf8	If true, transmit utf8 calling party id
	unattended_port
	unit
	unknownprefix	Unknown Prefix
	unknownstripdigits	Unknown Strip Digits
	upgradefinishtime
	usedevicepoolcalledcssintl	If set to true fkCallingSearchSpace_CalledIntl setting from Device Pool will be used and if false use setting on Device including NULL to mean no Calling Search Space
	usedevicepoolcalledcssnatl	If set to true fkCallingSearchSpace_CalledNational setting from Device Pool will be used and if false use setting on Device including NULL to mean no Calling Search Space
	usedevicepoolcalledcsssubs	If set to true fkCallingSearchSpace_CalledSubscriber setting from Device Pool will be used and if false use setting on Device including NULL to mean no Calling Search Space
	usedevicepoolcalledcssunkn	If set to true fkCallingSearchSpace_CalledUnknown setting from Device Pool will be used and if false use setting on Device including NULL to mean no Calling Search Space
	usedevicepoolcdpntransformcss	If set to true fkCallingSearchSpace_CdPNTransform setting from Device Pool will be used and if false use setting on Device including NULL to mean no Calling Search Space
	usedevicepoolcgpningressdn	Indicates whether to use fkCallingSearchSpace_CgpnIngressDN on this Device (this table) or from the Device Pool.
	usedevicepoolcgpntransformcss	If set to true fkCallingSearchSpace_CgPNTransform setting from Device Pool will be used and if false use setting on Device including NULL to mean no Calling Search Space
	usedevicepoolcgpntransformcssintl	If set to true fkCallingSearchSpace_CgpnTransform setting from Device Pool will be used and if false use setting on Device including NULL to mean no Calling Search Space
	usedevicepoolcgpntransformcssnatl	If set to true fkCallingSearchSpace_CgpnTransform setting from Device Pool will be used and if false use setting on Device including NULL to mean no Calling Search Space
	usedevicepoolcgpntransformcsssubs	If set to true fkCallingSearchSpace_CgpnTransform setting from Device Pool will be used and if false use setting on Device including NULL to mean no Calling Search Space
	usedevicepoolcgpntransformcssunkn	If set to true fkCallingSearchSpace_CgpnTransform setting from Device Pool will be used and if false use setting on Device including NULL to mean no Calling Search Space
	usedevicepoolrdntransformcss	If set to true fkCallingSearchSpace_RdNTransform setting from Device Pool will be used and if false use setting on Device including NULL to mean no Calling Search Space
	userholdmohaudiosourceid
	v150modemrelaycapable
	versionstamp	New guid plus seconds past midnight 1970 are concatenated
deviceaddonmodulemap		Map device to phone template for add-on-modules
	fkdevice
	moduleindex
	pkid	Unique ID to identify a record.
	specialloadinformation	used only by addon with firmware
	tkmodel
deviceautoreg		Stores device auto registration configuration, existence of record implies auto registration is enabled.
	autoregistrationenddn	This is the last directory number to use for auto-registration of devices. Specifying a valid range of directory numbers in the Starting Directory Number and Ending Directory Number fields automatically enables auto-registration. Setting the starting and ending directory numbers to the same value disables auto-registration.
	autoregistrationnextdn	This field is incremented by Cisco CallManager after a device has autoregistered.
	autoregistrationstartdn	This is the first directory number to use for auto-registration of devices.
	enable	Indicates wheather auto-registration is enabled..
	fkcallmanager	Reference to CallManager.
	fkdevice	Reference to Universal device template for auto-registration
	fknumplan	Reference to Universal line template for auto-registration
	pkid	Unique ID to identify a record.
devicecerdynamic		Table for tracking off-premise capable devices for CER
	allowoutboundcalls	Flag to allow OutboundCall
	datetimestamp	Time value for last change (for replication conflict resolution).
	fkdevice	Foreign key to Device table
	pkid	Unique ID to identify a record
	sendxsi	Indication to CUCM for sending XSI to device
	tke911locationstate	Reference to TypeE911LocationState
	url	URL to CER user page
devicefeaturemember		Generic table for associating a list of features with a device
	fkdevice_group
	member
	pkid	Unique ID to identify a record.
	selectionorder
	tkdevicefeature
devicehlogdynamic		Frequently updated settings for Hunt Group Log In/Out
	datetimestamp
	fkdevice
	hlog	By default a Hunt List to which a device belongs will extend calls to the device (logged in when hlog = true). When hlog is set to false, Hunt List will not extend calls to this device (logged out swhen hlog = false)
	pkid	Unique ID to identify a record.
devicemanagementdynamic		Stores the timestamp for remote wipe/lock state change request or acknowlegement for mobile devices
	datetimestamp	Time stamp for the last remote/wipe state change.
	fkdevice	Foreign key to Device table
	latestlockacknowledge	Time stamp for last lock acknowledge.
	latestlockrequest	Time stamp for last lock request.
	latestwipeacknowledge	Time stamp for last wipe acknowledge.
	latestwiperequest	Time stamp for last wipe request.
	pkid	Unique ID to identify a record.
devicemanagementinfo		This table is used to store the http information for MCU Conference Bridge.
	conferencebridgeprefix	Conference Bridge Prefix
	fkdevice	Refers to the device record for MCU Conference bridge.
	managementport	Http Port No
	overridesiptrunkaddress	Override SIP Trunk address as HTTP address
	password	Used for Authentication
	pkid	Unique ID to identify a record.
	usehttps	Flag to use HTTPS port, this would ensure that all the message interactions are through Secure port
	username
devicemobilitydynamic		Frequently updated settings for Mobility
	datetimestamp
	fkdevice
	fkdevicepool_devicemobility
	pkid	Unique ID to identify a record.
	versionstamp	New guid is generated every time this device is updated
devicemobilitygroup		Used for Device Mobility
	description
	name
	pkid	Unique ID to identify a record.
devicemobilityinfo		Device Mobility Mapping
	name
	pkid	Unique ID to identify a record.
	subnet
	subnetipv6	IPv6 address in presentation format and may be in shortened form.
	subnetipv6expanded	IPV6 full-length address and not modifiable (generated from short form address)
	subnetmasksz
	subnetmaskszipv6	It is the prefix size or 0 if IPv6 subnet is not used.
devicenumplanmap		Ordered association of NumPlan records with a device (line appearance)
	busytrigger
	callinfodisplaymask
	ctiid	Trigger set on insert. 32 bit value for Computer Telephony Interface
	dialplanwizardgenid	This record created by DialPlanWizard
	display	The localized name to display for internal Caller ID
	displayascii	A safe version of the Caller ID Display text using only English letters (a to Z) and punctuation, used when endpoints are using different language groups.
	e164mask	masked against NumPlan.DnOrPattern to get full number to display on Telecaster
	fkcallingsearchspace_monitoring	CallingSearchSpace used for monitoring if supported by associated device
	fkdevice
	fknumplan
	fkrecordingprofile	Profile used for Call Recording if supported by associated device
	label	The text that appears for the line button (allows Unicode).
	labelascii	A safe version of the Line Button Label using only English letters (a to Z) and punctuation.
	logmissedcalls	Determines whether missed calls on this line appearance are shown in the call history for the phone.
	maxnumcalls	MaxNumCalls for an Intercom line must be set to 1
	numplanindex	While this is unique per device, there is no requirement for the index to be sequential nor to begin with a particular value per device.
	pkid	Unique ID to identify a record.
	speeddial	This is the number that the system dials when the user presses the feature (Intercom) button.
	tkmwlpolicy	MWL Policy cannot be set for an Intercom line
	tkpartitionusage	Identifies entries belonging to Line or Intercom features
	tkpreferredmediasource	where is recording controlled from.
	tkringsetting	Ring Setting (Idle) cannot be set for an Intercom line
	tkringsetting_activepickupalert	Pickup Audio Alert Settings
	tkringsetting_consecutive	Ring Setting (Active) cannot be set for an Intercom line
	tkringsetting_idlepickupalert	Pickup Audio Alert Settings
	tkstatus_audiblemwi	On/Off/Default setting for Audible Message Waiting Indication on a line appearance
devicenumplanmapendusermap		Settings for SIP Publication of line status for presence
	fkdevicenumplanmap	Line appearance being monitored for status
	fkenduser	EndUser to whom status information is be published
	pkid	Unique ID to identify a record.
devicenumplanmapremdestmap		Maps Remote Destinations to the template or dual mode phone lines with which they are used
	fkdevicenumplanmap	Line from template or Dual Mode phone that is used for Remote Destination
	fkremotedestination	Remote Destination using the line for Single Number Reach (SNR)
	pkid	Unique ID to identify a record.
devicepool		Common collections of device attributes
	calledinternationalprefix	Called International Prefix
	calledinternationalstripdigits	Called International Strip Digits
	callednationalprefix	Called National Prefix
	callednationalstripdigits	Called National Strip Digits
	calledsubscriberprefix	Called Subscriber Prefix
	calledsubscriberstripdigits	Called Subscriber Strip Digits
	calledunknownprefix	Called Unknown Prefix
	calledunknownstripdigits	Called Unknown Strip Digits
	connectionmonitorduration
	fkaarneighborhood
	fkcallingsearchspace_aar
	fkcallingsearchspace_adjunct	For emergency call during cross cluster EM login
	fkcallingsearchspace_autoregistration	This is the calling search space to assign to devices in this device pool that auto-registers with Cisco CallManager. The calling search space specifies partitions that devices can search when attempting to complete a call.
	fkcallingsearchspace_calledintl	Called Party International Number
	fkcallingsearchspace_callednational	Called Party National Number
	fkcallingsearchspace_calledsubscriber	Called Party Subscriber Number
	fkcallingsearchspace_calledunknown	Called Party Unknown Number
	fkcallingsearchspace_cdpntransform	If useDevicePoolCdpnTransformCSS is set to True this transformation will be applied on the called party
	fkcallingsearchspace_cgpningressdn	Calling search space applied to calling party number on ingress from the calling device
	fkcallingsearchspace_cgpnintl	Calling Party International Number
	fkcallingsearchspace_cgpnnational	Calling Party National Number
	fkcallingsearchspace_cgpnsubscriber	Calling Party Subscriber Number
	fkcallingsearchspace_cgpntransform	Calling Party Transformation Number
	fkcallingsearchspace_cgpnunknown	Calling Party Unknown Number
	fkcallingsearchspace_cntdpntransform	Calling Search Space for Connected Party Name Transformation Pattern
	fkcallingsearchspace_mobility
	fkcallingsearchspace_rdntransform	If useDevicePoolRdnTransformCSS is set to True this transformation will be applied on the Redirecting Number
	fkcallmanagergroup	This is the Cisco CallManager group to assign to devices in this device pool. A Cisco CallManager group specifies a prioritized list of up to three Cisco CallManagers. The first Cisco CallManager in the list serves as the primary Cisco CallManager for that group, and the other members of the group serve as backup Cisco CallManagers for redundancy.
	fkdatetimesetting	This is the date/time group to assign to devices in this device pool. The date/time group specifies the time zone and the display formats for date and time.
	fkdevicemobilitygroup
	fkelingroup	ELINGroup record used by this DevicePool
	fkgeolocation
	fkgeolocationfilter_lp
	fklocation
	fkmediaresourcelist	This is the media resource group list associated with the device pool. A media resource group list specifies a prioritized list of media resource groups. An application selects the required media resource (for example, a music on hold server, transcoder, or conference bridge) from the available media resource groups according to the priority order that is defined in a media resource group list.
	fkmraservicedomain	Pkid of the MRA service domain
	fkphysicallocation
	fkregion	This is the Cisco CallManager region to assign to devices in this device pool. The Cisco CallManager region settings specify voice codec that can be used for calls within a region and between other regions.
	fksrst	This is the survivable remote site telephony (SRST) reference to assign to devices in this device pool.
	fkviprpublisheddidpatterngroup
	fkwirelesslanprofilegroup	Reference to Wireless LAN Profile Group.
	internationalprefix	International Prefix
	internationalstripdigits	International Strip Digits
	name	A unique name.
	nationalprefix	National Prefix
	nationalstripdigits	National Strip Digits
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	subscriberprefix	Subscriber Prefix
	subscriberstripdigits	Subscriber Strip Digits
	tkbarge
	tkcountry
	tkreset	Set by DeviceReset stored procedure.
	tkrevertpriority
	tkstatus_joinacrosslines
	unknownprefix	Unknown Prefix
	unknownstripdigits	Unknown Strip Digits
	versionstamp	New guid plus seconds past midnight 1970 are concatenated
devicepooldevicemobilityinfomap		Used for DeviceMobility.
	fkdevicemobilityinfo
	fkdevicepool
	pkid	Unique ID to identify a record.
devicepoolroutegroupmap		Used for mapping multiple Route Groups to a Device Pool. According to the Multiple Local Route Group feature, we can assign more than one Route Groups to a Device Pool. So this table is used for mapping between the two.
	fkdevicepool	reference to device pool
	fkroutegroup	fkRouteGroup should contain the fk to route group only if isLocalRouteGroup is set to false. This field is mandatory as it will point to the actual Route Group that will be used for handling all the Route related activities.
	fkroutegroup_local	fkRouteGroup_local should contain the fk to route group only if isLocalRouteGroup is set to true. The value in this field will just be used to give a name to the actual route group that is being used.
	pkid	Unique ID to identify a record.
deviceprivacydynamic		Frequently updated settings for Privacy
	datetimestamp
	fkdevice
	pkid	Unique ID to identify a record.
	tkstatus_callinfoprivate	display call info to caller?
deviceprovidermap		CUBA: This table will contains information about device configuration to provider mapping, so admin will know using which provider device is configured
	fkdevice	Device for providerdevicemap record
	fkprovider	Provider for providerdevicemap record
	pkid	Unique identifier for providerdevicemap record
	tkcubadevice	CubaDevice type for providerdevicemap record
	versionnumber	This will store the version number of the provider in providerdevicemap
devicerelatedversionstamp		List of Devices that requires versionstamp update
	fkdevice	Pkid of the Device
	pkid	Unique ID to identify a record.
	versionstamp	New guid plus seconds past midnight 1970 are concatenated and is generated every time this device is updated
devicereset		For device reset functionality. Records inserted into this table will inform CCM to reset the device.
	devicepkid	Set by DeviceReset stored procedure.
	fkcallmanager	Set by DeviceReset stored procedures.
	name	Set by DeviceReset stored procedure.
	pkid	Unique ID to identify a record.
	resetgrouping	Unique ID to identify a record. will be same for all reset requests
	tkmodel	Set by DeviceReset stored procedure.
	tkreset	Set by DeviceReset stored procedure.
	tkresethandshake	Set the reset to ensure tftp reacts to it before actual device reset.
devicesipdevicemap		Keep multi function device records for mapping between Device and SIPDeivce record.
	fkdevice	Reference to a specific Device
	fksipdevice	Points to the corresponding SIP Device record.
	pkid	Unique ID to identify a record.
devicetftpdynamic		VersionStamp Mismatch Recovery
	fkdevice	Points to the device record being "subclassed." Device.tkModel must be tkclass=1.
	pkid	Unique ID to identify a record.
	rebuildtoggle	Should this device be rebuilt
devicetokendynamic		Frequently updated settings for CUCM Push Notifications Call Support
	algorithm	This is the algorithm to be used during encryption.
	fkdevice	pkid from Device. The Device must be Dual-mode for iPhone or Jabber for Tablet.
	fkenduser	Set to the current logged in user of the device.
	key	This is the key for payload encryption. It can contain letters, numbers, hyphen and underscore. Regular expression used to validate: ^[a-zA-Z0-9-_]{0,128}$
	pkid	Unique ID to identify a record.
	pushchanneltype	This specifies the channel type by which the push token is sent.It can have a-z,A-Z and a colon.
	pushnotifytoken	Token to communicate with apple cloud for sending push notification.
devicexml16k		Defines the product specific configuration for devices:16K
	fkdevice	Pkid of the Device corresponding to the XML column of DeviceXML16L table
	pkid	Unique ID to identify a record.
	xml	Product configuration XML for DeviceXML16K
devicexml4k		Defines the product specific configuration for devices:4K
	fkdevice	Pkid of the Device corresponding to the XML column of DeviceXML4K table
	pkid	Unique ID to identify a record.
	xml	Product configuration XML for DeviceXML4K
devicexml8k		Defines the product specific configuration for devices:8K
	fkdevice	Pkid of the Device corresponding to the XML column of DeviceXML8K table
	pkid	Unique ID to identify a record.
	xml	Product configuration XML for DeviceXML8K
dhcpserver		(not supported yet)DHCP server configuration
	arpcachetimeout	server
	domainname	domain name
	domainnameserver1	IP Address for primary dns
	domainnameserver2	IP Address for secondary dsn
	fkprocessnode	Associated server
	ipaddrleasetime	server
	nextserver	IP Address for the next server cisco tftp
	pkid	Unique ID to identify a record.
	t1	server
	t2	server
	tftpserver1	IP Address for the primary cisco tftp
	tftpserver2	IP Address for secondary cisco tftp
	tftpservername	tftp server name (option 150)
dhcpsubnet		(not supported yet)DHCP subnet configuration
	arpcachetimeout	subnet
	domainname	subnet
	domainnameserver1	IP Address for primary dns
	domainnameserver2	IP Address for secondary dsn
	fkdhcpserver	Associated server
	ipaddrfrom1	subnet
	ipaddrfrom2	subnet
	ipaddrleasetime	server
	ipaddrto1	subnet
	ipaddrto2	subnet
	nextserver	IP Address for the next server cisco tftp
	pkid	Unique ID to identify a record.
	router1	subnet
	router2	subnet
	subnet	subnet
	subnetmask	subnet
	t1	server
	t2	server
	tftpserver1	IP Address for the primary cisco tftp (option 66)
	tftpserver2	IP Address for secondary cisco tftp (option 66)
	tftpservername	tftp server name (option 150)
dialplan		List of known dial plans
	description
	name
	pkid	Unique ID to identify a record.
	version	Version number of the installed Dial Plan
dialplandetails		CUBA: This table will be used to store different parameters for dial plan e.g. Extension no length, FeaturePrefix etc.
	defaultvalue	Default value for parameters in dialplandetail table
	paramname	ParamName for dialplandetails
	paramvalue	ParamValue for dialplandetails
	pkid	Unique id for dialplandetails table
dialplantag		Tag name for a portion of a directory number used by digit analysis
	fkdialplan
	pkid	Unique ID to identify a record.
	suppressfromroutefilter	Don't show this tag in RouteFilterMember.
	tag
	tkoperator_max	Maximum value for operator in RouteFilterMember for this tag
dialrules		Dial Rules
	description	Description of the dial rule
	isstandard	Whether standard dial rule
	name	Name of dial rule
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	tkdialpattern	Pkid of Dial Pattern record
	tkreset	Set by DeviceReset stored procedure.
	versionstamp	New guid plus seconds past midnight 1970 are concatenated
dialrulespatternmap		DialRules Pattern Map
	description	Description of pattern on dial rule
	fkdialrules	Pkid of DialRules record
	pkid	Unique ID to identify a record.
	selectionorder	Selection order
	tkpattern	Enum of TypePattern record
digitalaccessbri		Digital access BRI information not in Device table
	acceptinboundrdnis
	calleriddn
	conncallbeforeplayingann	True, if inbound call should be connected before playing queuing announcement.
	dchannelenable
	displayie
	firstdelay
	fkdevice	device::tModel must be digital access
	gclearenable	Enables G.Clear support for a BRI trunk (using values specified in G.Clear related Service Parameters)
	intradelay
	numberie
	numdigits
	pkid	Unique ID to identify a record.
	prefix
	sendrestart
	setupnonisdnpiflag
	sigdigits	Must be 1 if (NumDigits >= 0) AND (NumDigits <= 32), or 0 if (NumDigits = 99)
	stablein4
	statuspoll
	stripcountout
	tkbriprotocol
	tkcallingpartyselection	Source of the calling party number: originator = 1, first redirect = 2, last redirect = 3
	tkclockreference	Indicates if the device sync up with the Network clock or use it's own clock for timing
	tkcsuparam	TX-level CSU parameter for PRI interface
	tkencode
	tkfdlchannel
	tkframing
	tknumberingplan_called
	tknumberingplan_calling
	tkpresentationbit	CLID presentationBit: allowed = 1, restricted = 2
	tkpriofnumber_called
	tkpriofnumber_calling
	tktrunklevel
	tktrunkpad_rx
	tktrunkpad_tx
	tktrunkselectionorder
	tkyellowalarm
	tkzerosuppression
digitalaccesspri		Digital access PRI information not in Device table
	acceptinboundrdnis
	calleriddn
	conncallbeforeplayingann	True, if inbound call should be connected before playing queuing announcement.
	dchannelenable
	displayie
	enableprotectedfacilityie	Allows use of secure calls (on PRI E1 trunks only)
	firstdelay
	fkcallingsearchspace_cntdpntransform	Calling Search Space for Connected Party Number Transformation Pattern
	fkdevice	device::tModel must be digital access
	gclearenable	Enables G.Clear support for a PRI trunk (using values specified in G.Clear related Service Parameters)
	interfaceidentifierpresent
	interfaceidentifiervalue
	intradelay
	mcdnenable
	numberie
	numdigits
	passingprecedencelevelthroughuuie
	pkid	Unique ID to identify a record.
	prefix
	protocolprofile91nameonly
	securityaccesslevel
	sendcallingnameinfacilityie
	sendexleadingcharindispie
	sendrestart
	setupnonisdnpiflag
	sigdigits	Must be 1 if (NumDigits >= 0) AND (NumDigits <= 32), or 0 if (NumDigits = 99)
	smdibaseport
	span
	statuspoll
	stripcountout
	tkasn1roseoidencoding
	tkcallingpartyselection	Source of the calling party number: originator = 1, first redirect = 2, last redirect = 3
	tkclockreference	Indicates if the device sync up with the Network clock or use it's own clock for timing
	tkconnectedpbx
	tkcsuparam	TX-level CSU parameter for PRI interface
	tkencode
	tkfdlchannel
	tkframing
	tknumberingplan_called
	tknumberingplan_calling
	tkpresentationbit_callingline	CLID presentationBit: allowed = 1, restricted = 2
	tkpresentationbit_connectedline	CLID presentationBit: allowed = 1, restricted = 2
	tkprichanie
	tkpriofnumber_called
	tkpriofnumber_calling
	tkpriprotocol
	tkqsigvariant
	tkstatus_routeclasssignalingenabled	Indicates whether Route Class Signaling is enabled on a PRI trunk
	tktrunklevel
	tktrunkpad_rx
	tktrunkpad_tx
	tktrunkselectionorder
	tkyellowalarm
	tkzerosuppression
	usedpconnectedpartytransformationcss	If set to true fkCallingSearchSpace_CntdPNTransform setting from Device Pool will be used and if false use setting on DigitalAccessPri including NULL to mean no Calling Search Space. The Default value is TRUE
digitalaccesst1		Digital access T1 information not in Device table
	conncallbeforeplayingann	True, if inbound call should be connected before playing queuing announcement.
	encodevoicerouteclass	TRUE if this T1 (CAS) i/f should signal the voice route class digit
	fkdevice
	handledtmfprecedencesignals
	pkid	Unique ID to identify a record.
	releaseguardtimer	This timer is used by gateway to release the channel back to idle state on receiving clear-forward from the far end,This timer is used to protect gateway from any race conditions that could occur when we receive Release from both sides
	seizureacktime	This is the delay (in milliseconds) between the gateway that receives seizure and sends seizure acknowledgment (ACK)
	smdibaseport
	tkclockreference
	tkcsuparam
	tkdigitsending	DTMF or MF
	tkencode
	tkfdlchannel
	tkframing
	tkstatus_routeclasssignalingenabled	Indicates whether Route Class Signaling is enabled on a CAS trunk
	tktrunkselectionorder
	tkyellowalarm
	tkzerosuppression
digitalaccesst1port		Ports on a Digital Access T1
	attendantdn	If Inbound type call and Loop Start are Ground Start Attendant Number is needed
	calleriddn
	endpointid	User may only change the PhysicalLocation and not @domain part. Default is PhysicalLocation from MGCPDeviceTable + portNum + @domain
	expecteddigits
	fkdevice
	inboundcalleridenable
	numdigits	Maximum number of digits to collect. Collects least significant to NumDigits selected
	pkid	Unique ID to identify a record.
	portnum	fkDevice+PortNum are unique; 1-24; 1-8 For Vega
	prefix	Prefix digits to apply in inbound call only.
	sigdigits	Obsolete - NumDigits is always used. Flag to allow only certain amount of digits.
	timer1	In Milliseconds
	timer2	In Milliseconds
	timer3	In Milliseconds
	timer4	In Milliseconds
	timer5	In Milliseconds
	timer6	In Milliseconds
	tkcallerid
	tkcallingpartyselection	Source of the calling party number: originator = 1, first redirect = 2, last redirect = 3
	tkdigitsending	DTMF or MF
	tkpresentationbit	CLID presentationBit:allowed = 1, restricted = 2
	tksilencesuppressionthreshold	in dbm0
	tkstartdialprotocol
	tktrunk
	tktrunkdirection	Inbound Outbound and Both are valid Directions. Outbound equates to DOD. Both only allowed on Ground Start (GS)
	tktrunklevel	used to set PAD level
	tktrunkpad_rx	+/- 32db
	tktrunkpad_tx	+/- 32db
	unattendedport
	versionstamp	New Guid is generated when the port XML change
	xml	Product configuration XML not used by CCM
digitdiscardinstruction		Digit Discard Instruction clauses
	clause
	digitanalysisid
	fkdialplan
	name	Removed Unique key constraint on name field
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	tkreset	Set by DeviceReset stored procedure.
digitdiscardinstructionmember		List of tags per Digit Discard Instruction
	fkdialplantag
	fkdigitdiscardinstruction
	pkid	Unique ID to identify a record.
directorypluginattribute		attributes to be synced from LDAP server
	dirobjectclassattrname
	fkdirectorypluginconfig
	pkid	Unique ID to identify a record.
	tkldapserverattr
directorypluginconfig		Configuration data for the corporate Directory connector
	agreementstatus
	applymask	When true, the Mask field will be applied on the telephone number
	applypoollist	When true, the extension number will selected from the pool
	connectedldaphost
	fkfeaturegrouptemplate	Reference to Featuregrouptempate for common enduser fields
	fkldapfilter	Empty means use the default filter for the directory host type associated with the agreement. Otherwise use the specified filter for which the host type should match the associated host type for the agreement.
	fkldapfilter_group	Empty means use the default group filter for the directory host type associated with the agreement. Otherwise use the specified Group filter for which the host type should match the associated host type for the agreement.
	fullsyncstatus
	highestcommittedusn
	incsyncstatus
	invocationid
	ldapdn
	ldappassword
	ldapsynchronizationbase
	mask	Mask to be applied on the telephone number
	name
	pkid	Unique ID to identify a record.
	syncgroups	This field is set to TRUE when Group sync is also required along with usersync from Ad server.
	syncnow
	tkldapdirectoryfunction	Reference to TypeLDAPDirectoryFunction
	userrank	Rank assigned to new users imported based on this directory sync config. Access control groups assigned to the directory sync config should be either of equal or lower rank. Required reference to enum column of parent record in table UserRank
directorypluginconfigdirgroupmap		Stores a preprovisioned list of DirGoups to be associated with endusers inserted from ldap
	fkdirectorypluginconfig	Reference to sync agreement
	fkdirgroup	Reference to groups that are applied to end users added by this sync agreement
	pkid	Unique ID to identify a record.
directorypluginhost		Host names of LDAP servers
	fkdirectorypluginconfig
	hostname
	ldapportnumber
	pkid	Unique ID to identify a record.
	priority
	sslenabled
directorypluginpoollist		Pool List for a particular Directory Plugin Config
	dnprefix	DN prefix for the poolrange.
	enddn	Ending DN in the pool.
	fkdirectorypluginconfig	Reference to DirectoryPluginConfig for this pool list.
	nextdn	Next DN in the pool.
	pkid	unique ID to identify a record.
	priority	Priority of the pool list.
	startdn	Starting DN in the pool.
directorypluginroutingdatabase		This table holds the Data specific to DN Alias Sync and Lookup LDAP servers
	cacheage	It represents the age of the records present in the Cache
	cacheenable	Boolean field to user records caching state for the DN Alias Sync. If true, the user records are cached before syncing to DN Alias Sync otherwise no caching happens.
	cachesize	User can spefiy the number of records to be cache before the sync to the DN Alias Sync
	fkdirectorypluginconfig	Reference to DirectoryPluginConfig
	ldapkeepalivesearchdn	It serches the specified user Distinguished Name in DN Alias Sync and Lookup LDAP servers
	pkid	Unique ID to identify a record.
	sipaliassuffix	This field when configured specifies the prefix that is added to the full Commericial number before it is stored in the SIP Alias field in the LDAP Routing database.
	tkkeepalivetimeinterval	Reference to TypeKeepAliveTimeInterval
directorypluginschedule		Schedule for directory plugin task
	active
	fkdirectorypluginconfig
	intervalvalue
	nextexectime
	pkid	Unique ID to identify a record.
	repeatable
	tkscheduleunit
dirgroup		Categorizes users and Application users
	isstandard	Created during installation.
	minimumuserrank	Rank of access control group. Minimum rank that end user, application user, bat user template, directory sync configuration must have to be associated with this access control group. Required reference to enum column of parent record in table UserRank
	name
	pkid	Unique ID to identify a record.
dmmsdevice		Cellular Subscriber data not in Device Table
	cnumber	Subscriber cellular number
	disableappdialrules
	enablefollowme
	fkdevice
	fkdevice_wsm
	pkid	Unique ID to identify a record.
dnaliassynckeymap		This table holds the mapping between the Key used by the CUCM database to identify a Number and the Key used by the DNAlias Sync LDAP server
	ccaid	The LDAP server that stores the Directory Number Alias records uses this field to appropriately authorize subsequent updates of the records in the LDAP Database. The Directory Number Alias server will only allow update operations on a record originating from the CUCM cluster that originally added the record by identifying the CUCM Cluster Identifier set in this field.
	dnaliassynckey	this field holds the User Id that was pushed to the DNAlias Sync Server which will be used as a key by the DNAlias Sync Server
	pkid	Unique ID to identify a record.
dnddynamic		Frequently updated settings for Do Not Disturb (DND)
	datetimestamp	for replication and conflict resolution
	dndstatus
	fkdevice
	pkid	Unique ID to identify a record.
dntracelogging		Allows configuration of Called Party DN to trace a call back to the original party, this is in accordance with DOD UCR 2008 specifications related to Dynamic / Destination Call Tracing
	description	Describes the Traced called party DN, documenting the owner / destination and / or a reason / reference for the trace.
	directorynumber	Indicates the Called Party DN on which tracing is enabled
	pkid	Unique ID to identify a record.
dpcallrecordserver		Diagnostic Portal Call Record Server
	alternatename
	alternateport
	clusterid	This is only for UCM ,UCMBE
	description
	domainname
	ikdpcallrecordserver_primary	This is the PKID for Primary (peer) call record server
	instancename
	name	Diagnostic Portal CallRecord Server Name or ip address
	password
	pkid
	port
	tkdpdeviceprotocol	TypeDeviceProtocol
	tkdpproduct	TypeProduct
	tkdpverificationstatus	TypeVerificationStatus - One of the following: 0 (notdone), 1 (Failed) or 2(Success)
	username
	verificationfailurereason
	verificationtimestamp	UTC time of Verification
	version
dpcertificate		Diagnostic Portal Certificate
	certificate	Diagnostic Portal Certificate
	issuername
	pkid
	serialnumber	hex representation of serial number
	subjectname
	validfromdate	UTC time
	validtodate	UTC time
dpdevice		Diagnostic Portal Device
	alternateaccessname
	clusterid	ClusterID
	description
	isseeddevice	Is seed device
	name	Diagnostic Portal Device - This is groupHost name or IP v4 address
	nodeid	NodeID
	pkid
	tkdpproduct	The enum value of the corresponding device type defined in the TypeDPProduct table
	version
dpdeviceaccess		Diagnostic Portal Device Access Method definition
	alternateport
	fkdpdevice	DP Device can be there in many groups
	password
	pkid
	port
	tkdpdeviceprotocol	TypeDeviceProtocol
	tkdpverificationstatus	TypeVerificationStatus - One of the following: 0 (notdone), 1 (Failed) or 2(Success)
	username
	verificationfailurereason
	verificationtimestamp	UTC time of Verification
dpdevicecallrecordservermap		Diagnostic Portal Device to Call Record Server mapping
	fkdpcallrecordserver
	fkdpdevice
	pkid
dpdevicegroupmap		Diagnostic Portal Devices mapping into Groups
	fkdpdevice	DP Device can be there in many groups
	fkdpgroup	DP Group can have many devices
	pkid
dpdevicejobcomponent		Diagnostic Portal Jobs for device and component
	componentpath	"/" separated list of component nodes from root to leaf node. Derived from ListTraceComponent and ListLogComponent command results.
	customcookiestring	Custom Cookie String
	fkdpdevice	DP Device can be there in many groups
	fkdpjob	DP Device can be there in many groups
	islogcollectable
	istracecollectionselected	True - collect traces associated with the job; False - do not collect traces.
	istracecomponent	True(default) - Trace Component and False - Log Component
	pkid
	tkdptracelevel
	tkdptracelevel_previous
	tkdpwebprotocol	TypeDPWebProtocol - One of the following: 0 (REST) default, 1 (SOAP) or 2 (Not Applicable)
dpdeviceproductcomponent		Diagnostic Portal Device Product Component
	fkdpdevice	Product Component Relation to Device
	name	Name of the Product component
	pkid
dpdevicetraceservermap		Diagnostic Portal Device to Trace Server mapping
	fkdpdevice
	fkdptraceserver
	pkid
dpemail		Diagnostic Portal Email addresses
	name	Email address for notifications
	pkid
dpemaillist		Diagnostic Portal List of Email addresses
	description
	name	List of Email addresses for notifications
	pkid
dpemaillistmap		Maps Diagnostic Portal Email address to the List of Email addresses
	fkdpemail	Reference to an Email Address
	fkdpemaillist	Reference to a list of Diagnostic Portal Email Addresses
	pkid
dpftpserver		Defines the FTP Server for the Diagnostic Portal
	description
	destinationdirectory	Path
	name	Diagnostic Portal TFTP Server Name
	password
	pkid
	port
	tkdpdeviceprotocol
	tkdpverificationstatus	TypeVerificationStatus - One of the following: 0 (notdone), 1 (Failed) or 2(Success)
	username
	verificationfailurereason
dpgroup		Diagnostic Portal Group
	description
	name	Name of Diagnostic Portal Group
	pkid
dpjob		Diagnostic PortalJob definition
	creationtime
	description
	downloadlocation
	endtime	UTC format (32 bit integer)
	failurereason	Reason For Failure
	frequency	Frequency of the Diagnostic Portal Job
	groupname
	isemailnotificationrequired
	isscheduledtracesetting
	macaddress	MAC Address of subject
	name	User Defined job name
	noofbytestransferred
	nooffilestransferred
	pkid
	starttime	UTC format (32 bit integer)
	statusoflastrun
	templatename
	timeoflastrun
	timezone
	tkdpjobfeature	TypeDPJobFeature - One of the following: 0 (Scheduled Collection) or 1 (Scheduled Trace Modification and Collection)
	tkdpjobstatus	The enum value defined in the TypeDPJobStatus table
dpjobemaillistmap		Maps Diagnotistic Portal Jobs to list of email addresses for notifications
	fkdpemaillist	Reference to a list of Diagnostic Portal Email Addresses
	fkdpjob	DP Device can be there in many groups
	pkid
dpmailserver		Defines the Mail Server for the Diagnostic Portal
	description
	name	Diagnostic Portal Mail Server Name
	pkid
	port	Port used for SMTP protocol
	senderemail
	tkdpverificationstatus	TypeVerificationStatus - One of the following: 0 (notdone), 1 (Failed) or 2(Success)
	verificationfailurereason
dpntpserver		Diagnostic Portal NTP Server
	name
	pkid
dptemplate		Defines the template for the Diagnostic Portal
	description
	isstandard	Created during installation.
	name	Name of Diagnostic Portal Template
	pkid
dptemplatecomponentdata		Defines the template Component Data for the Diagnostic Portal
	fkdptemplate
	fkdptemplatemetacomponentlist
	isstandard	Created during installation.
	pkid
	tkdptracelevel	This is trace level
dptemplatemetacomponentlist		Defines the TemplateMetaComponentList for Diagnostic Portal
	componentpath	"/" separated list of component nodes from root to leaf node. Derived from ListTraceComponent and ListLogComponent command results.
	islogcollectable
	isstandard	Created during installation.
	istracesetable
	pkid
	tkdpproduct	The enum value of the corresponding device type defined in the TypeDPProduct table
dptraceserver		Diagnostic Portal Trace Server
	alternatename
	alternateport
	description
	homedirectory	Home Directory.
	name	Diagnostic Portal Trace Server Name or ip address
	password
	pkid
	port
	tkdpdeviceprotocol	TypeDeviceProtocol
	tkdpverificationstatus	TypeVerificationStatus - One of the following: 0 (notdone), 1 (Failed) or 2(Success)
	username
	verificationfailurereason
drfcomponent		Disater recovery framework status and dependacy
	fkprocessnodeservice	Associated server
	id	ID from registration
	ikdrfcomponent	service that must be started first
	pkid	Unique ID to identify a record.
	tkdrfregistered	Registration status
drfscript		Disater recovery framework configured scripts
	fkdrfcomponent	Registered drf component associated with script
	name	script name
	orderid	order of scripts to be run per component during backup or restore
	pkid	Unique ID to identify a record.
	tkdrfscript	type backup or restore
e911messages		Table used for storing legal disclaimer messages sent to phone for off premise e911.
	message	Message text that will be sent to phone (allows Unicode).
	pkid	Unique ID to identify a record.
	tke911message	This is the message type for e911.
	tkuserlocale	This is the locale associated with the e911 message.
elingroup		Table to store the ELIN Groups. Typically, each ELIN Group represents an ERL
	description	Description for Emergency Location Identification Number Group.
	name	Name of the ELIN Group, usually corresponds to the Emergency Response Location.
	pkid	Unique ID to identify a record.
elingroupmember		Table to store the ELIN Groups to ELIN mapping
	datetimestamp	Updates when the record is inserted or updated.
	fkelingroup	The pkid of the ELINGroup
	fknumplan_elin	The pkid of the ELIN
	pkid	Unique ID to identify a record.
elinmappingdynamic		Dynamic mapping table between Cgpn and used ELIN for emergency call. This table does not allow user (Admin, AXL, BAT) to insert or delete.
	datetimestamp	Updated when the record is inserted or updated.
	fkdevice	The foreign key of the device that originate the emergency call
	fknumplan_cgpn	The foreign key to the Calling Party Number of the emergency call.
	fknumplan_elin	The foreign key to the ELIN which is used for the emergency call from this Cgpn.
	pkid	Unique ID to identify a record.
emccdynamic		Dynamic data for the EMCC base phone when a user remotely logs in.
	addonmoduleinfo	AddOn Module Info
	datetimestamp	Time stamp
	devicename	Device name for the remote login device
	fkdevice	EMCC base phone record
	fksecurityprofile	Foreign Key to Security Profile Set by EMDB by matching Product, Protocol, non-secure, isStatnard
	geolocationinfo	geolocationInfo from the remote cluster for the remote login device
	locationname	Reference to remote location name for EMCC device
	locationpkid	Reference to remote location pkid for EMCC device
	locationremoteclusterpkid	Reference to EMCC remote cluster pub's pkid
	md5hash
	pkid	Unique ID to identify a record.
	publickey
	remotesipsrstip	Sip address for SRST GW
	remotesipsrstipv6	SIP IPv6 Address for GW.
	remotesipsrstport	Sip port for SRST GW
	remotesrstip	IP address for the SRST GW in visiting cluster for the remote login device
	remotesrstoption	Srst.srstOption.name
	remotesrstport	The port number for the SRST in visiting cluster for the remote login device
	tftpencryptedflag	TFTP Encrypted Flag
	tkclass	Remote login device class type
	tkdeviceprotocol	Remote login device protocol type
	tkdevicesecuritymode
	tkipaddressingmode	Porting form visiting cluster realDevice.commonDeviceConfig.ipAddressingMode
	tkkeyauthority	TypeKeyAuthority
	tkmodel	Remote login device model
	tkproduct	Remote login device product type
	tkstatus_allowipv6autoconfigforphones	Porting form visiting cluster realDevice.commonDeviceConfig.tkstatus_allowipv6autoconfigforphones
	tkstatus_allowipv6duplicateaddressdetection	Allow Duplicate Address Detection for EMCCDynamic.This parameter determines whether the duplicate address detection should be performed on each of the addresses in any identity associations(IAs) it receives in the Reply message before using that address for traffic.
	tkstatus_ipv6acceptredirectmessages	Accept Redirect Messages for EMCCDynamic.This parameter provides an ability to accept or ignore the redirect messages.
	tkstatus_ipv6replymulticastechorequest	Reply Multicast Echo Request for EMCCDynamic.This parameter allows the phone to enable or disable the ability to send an Echo Reply message in response to an Echo Request message sent to an IPv6 multicast or anycast address.
	tktransport
emergencylocidnumber		Stores the static portion of the Emergency Location Id Numbers for devicepools. The information to be stored includes fkdevicepool, LocIdNumber
	fkdevice	Device (SIP Trunk for FXO Port) associated with the Emergency Location ID Number (ELIN)
	fkdevicepool	reference to device pool
	locidnumber	To identify the location of the emergency calls
	pkid	Unique ID to identify a record.
	trunkprefix	Prefix used to route emergency calls to a specific analog trunk for an ELIN. If no prefix use any available trunk or gateway.
emergencylocidnumberdynamic		Stores the dynamic portion of the Emergency Location Id Numbers. The information to be stored includes origCallingExtension, Datetimestamp, fkEmergencyLocIdNumber
	datetimestamp	Time stamp
	fkemergencylocidnumber	Indicates the ELIN which is used for an emergency call
	origcallingdn	original calling DN
	pkid	Unique ID to identify a record.
emremotedynamic		Common dynamic data for both visiting cluster and home cluster.
	datetimestamp	Time stamp
	emuri	The URI for the visiting EM service. This is always the visiting EM URI.
	fkdevice	Link back to the EMCC base phone in home cluster. Link back to the real phone in visiting cluster
	lastremoteuserid	The userid string for the last remote login user. Should be set to Null for the home cluster
	logintime	When the user logged in. This is a time_t value stored as a long. Set by the Login stored procedure.
	pkid	Unique ID to identify a record.
	remoteclusterid	The cluster ID for the remote login user in visiting cluster. The cluster ID for the remote login device in home cluster
	remoteuserid	The userid string for the remote login user. This is mainly for administrative report purpose on remote cluster. Should be set to Null for the home cluster
	temptftp1v4	The TFTP IP address for the home TFTP. It is set during remote login procedure in both remote and home cluster
	temptftp1v6	The TFTP IP address for the home TFTP. It is set during remote login procedure in both remote and home cluster
	temptftp2v4	The TFTP IP address for the home TFTP. It is set during remote login procedure in both remote and home cluster
	temptftp2v6	The TFTP IP address for the home TFTP. It is set during remote login procedure in both remote and home cluster
	versionstamp
enduser		Lists the end users for the system
	allowcticontrolflag	If true, when a user logins to device, the device allows CTI Control.
	assocpc	pingable DNS name (not dotted IP address)
	building
	conferencenowaccesscode
	deletedtimestamp
	department	User's department number.
	directoryuri	URI for Cisco Unified Communications
	discoveryuseridentity	A unique ID (similar to UserPrincipalName in Active Directory) used to determine if a user exists and is local to this UCM cluster.
	displayname	Preferred display of user's name.
	emmaxlogintime	Extension Mobility Max Login Time.
	enablecalendarpresence	Determines whether others are allowed to see the meeting information for the user in Presence status
	enablecups	If true user can be assigned to a UCM IM & Presence Server
	enableemcc	To indicate whether user has capability to access EMCC feature
	enablemobilevoice	Enable IVR/Two-stage Dialing access
	enablemobility	Indicates whether a user has been licensed to use Mobility (SNR) features
	enableusertohostconferencenow	This will give user privilege to start a meeting in Conference Now with their PIN. User may set up optional attendee access code on the Self-care portal.
	facsimiletelephonenumber
	firstname	User's first name.
	fkcallingsearchspace_restrict	Pkid of CallingSearchSpace record for restriction
	fkdirectorypluginconfig
	fkmatrix_presence	Pkid for Presence Group Matrix record. This is required for extension mobility. Appuser table does not need this because appuser cannot do extension mobility.
	fkucserviceprofile	A reference to the UC Service Profile record that defines UC Services for the end user.
	fkucuserprofile	Optional reference to profile record containing shared user attributes.
	homephone
	islocaluser	Indicate whether the user is local to the UCM cluster
	keypadenteredalternateidentifier	If Provided, a distinct identifier for the user which may be entered from their telephone keypad and which can be used to distinguish the user from others when performing IVR based interactions such as Self-Provisioning.
	lastname	User's last name.
	mailid
	manager	Name of the user manager ID.
	maxdeskpickupwaittime	Max wait time for desk phone pickup in milliseconds
	middlename	User's middle name.
	mobile
	nickname
	ocsprimaryuseraddress	Corresponds to the msRTCSIP-primaryuseraddress field in Active Directory schema
	pager
	passwordreverse	Used for digest authentication
	pkid	Unique ID to identify a record.
	primarynodeid	EnterpriseNode (Presence Server) to which the user is assigned
	remotedestinationlimit	Max number of remote desintations associated with the EndUser (Mobility must also be enabled)
	site
	status	Active or Inactive
	telephonenumber	This is the telephone number as synchronized from a corporate directory. It typically is the outbound directory number. It is used for reporting purposes and if blank, applications should rely on the directory numbers assigned to phones associated with this user.
	title
	tkuserlocale	This is the Locale that is associated with the user. The user locale identifies a set of detailed information to support users, including language and font.
	tkuserprofile	ID to identify whether a real user or a template user
	uniqueidentifier	It will be ObjectGUID from ActiveDirectory or ciscoatUniqueIdentifier for ND/iPLanet
	userid	User identification name.
	userrank	Rank of end user. Access control groups assigned to the end user should be either of equal or lower rank. Required reference to enum column of parent record in table UserRank
enduserappservermap		Which App servers service which end user(s)
	content
	fkappserver
	fkenduser
	pkid	Unique ID to identify a record.
endusercapfmap		1-N relation between End User to CAPF
	authenticationstring
	fkenduser
	instanceid	To distinguish multiplicity for a single user.
	packetcaptureduration
	pkid	Unique ID to identify a record.
	subjectname	Subject name of the certificate
	tkauthenticationmode
	tkcertificate
	tkcertificateoperation	Certificate Operation
	tkcertificatestatus
	tkeckeysize	EC Key Size(bits) for EndUserCapfMap table
	tkkeyorder	Key Order for EndUserCapfMap table
	tkkeysize
	tkpacketcapturemode
	upgradefinishtime
endusercapfmapdynamic		Frequently updated settings for End User CAPF settings
	datetimestamp
	fkendusercapfmap
	fkprocessnode	The server to which this user, with this certificate, has opened a CTI provider.
	pkid	Unique ID to identify a record.
	userstate
endusercustomermap		mapping table for HCS-SA for customers to users
	fkcustomer	Reference to parent record in table Customer
	fkenduser	Reference to parent record in table EndUser
	pkid	Unique ID to identify a record.
	timestamp	UTC time of creation/modification
enduserdevicemap		Control association between users and devices (many to many)
	defaultprofile	This device is the default EM profile for this user.
	description	User-entered description of a controlled device (allows Unicode).
	fkdevice
	fkenduser
	pkid	Unique ID to identify a record.
	tkuserassociation
enduserdirgroupmap		Many to many relationship between EndUser and DirGroup
	fkdirgroup
	fkenduser
	pkid	Unique ID to identify a record.
enduserlicense		Licensable feature for end users
	enablecupc	Obsolete. Separate licenses (DLUs) are no longer needed for CUP Clients. This table to be removed in future releases.
	enablecups	Obsolete. See EndUser.EnableCUPS instead to check if presence is enabled. CUPS no longer requires separate license (DLUs). This table to be removed in future releases.
	fkenduser	Foreign key back to end user identifying the end user association
	pkid	Unique ID to identify a record.
endusermlppauthentication		Settings for Enduser MLPP authentication.
	fkenduser	The end user can be associated with zero or one numeric id.
	mlpppassword	The MLPPPassword is used to authenticate the End User requesting MLPP escalated call when they dial their ID when placing an Assured Services call
	numericuserid	The Numeric User Identifier is used to determine which End User is requesting an MLPP escalated call when they dial their ID when placing an Assured Services call.
	pkid	Unique ID to identify a record.
	tkpatternprecedence	MLPP Precedence Levels.
endusernotification		Storage of notification messages that are unread by a user who logins to the application
	clause	Clause shows the messages and status of each message for the user. For each message, the clause contains message id (tkUserNotificationMessage) followed by its enabled and read status. Multiple messages are separated by commas (e.g., 3:1:1,6:1:0).
	enablenotify	Enable or Disable User notification message store
	fkenduser	Unique ID of enduser who would receive the notification messages
	pkid	Unique ID to identify a record.
endusernumplanmap		Many to many relationship between EndUsers and DNs.
	fkenduser
	fknumplan
	pkid	Unique ID to identify a record.
	sortorder	The SortOrder column allows a User's associated Extensions in the EndUserNumPlanMap table to have a logical EXTENSION NUMBER defined. This may be used in automated template based device setup.
	tkdnusage
enterprisenode		All of the IM & Presence nodes in the enterprise
	fkprocessnode	The owning processnode for local nodes. This helps with management of local entries
	id	Unique ID to identify a record.
	islocal	True if the entry is from a local user
	isprimary	True if this is the primary node of a subcluster
	jsmid	Id of home Jsm component for node 1
	name	Name of the Node
	peerid	Which cluster did this entry originate. local is the local node, pkid is a value from cupsinterclusterpeers.pkid
	pkid	Unique ID to identify a record (UCM standard).
	remotefkprocessnode	The remote cluster pkid for the node, used for tracking by ICSA
	remoteid	The remote cluster id for the 8.5.x and greater node, used for tracking by ICSA
	subclusterid	Subcluster ID
	tkhaserverstate	For HA server status
enterprisephoneconfigxml		XML configuration for Common Phone Config
	pkid	Unique ID to identify a record.
	xml	Product configuration XML not used by CCM
enterprisesubcluster		All of the IM & Presence subclusters in the enterprise
	description	Admin entered description for the subcluster
	haenabled	Identifies if HA has been enabled for the subcluster
	id	Unique ID to identify a record.
	islocal	True if the entry is from a local user
	name
	peerid	Which cluster did this entry originate. local is the local node, pkid is a value from cupsinterclusterpeers.pkid
	pkid	Unique ID to identify a record (UCM standard).
	remoteid	Remote id for 8.5.x subclusters and later
	remotepkid	Remote pkid for 8.0.x subclusters and earlier
	sipport	Port to use for SIP communications
	siptransport	Transport to use for SIP communications, default is TCP
	srvname
	supportsxcp	Is this subcluster from an 8.0.x and later cluster
expresswaycconfiguration		Table to store Expressway-C details like IP Address/hostname and X509SubjectName
	description
	hostnameorip	IPv4 address or IPv6 address or Hostname of the Expressway-C.
	pkid	Unique ID to identify a record.
	x509subjectnameoraltname	Specifies X509SubjectName or SubjectAlternateName of Expressway-C
extensionmobilitydynamic		Settings updated for EM login/logout; record inserted by trigger when EM is enabled for a device, and deleted by trigger when EM is disabled.
	allowcticontrolflag
	ctiidbase	Used by CTI to uniquely identify lines and pick up changes
	datetimestamp
	fkcallingsearchspace_emcc	Need to be copied over from deviceprofile during EMCC login. Device Profile stores the value in Device.fkCallingSearchSpace column. This field is used by EMCC only.
	fkcallingsearchspace_restrict
	fkdevice
	fkdevice_currentloginprofile	GUID for current login device profile. Set by the Login stored procedure if AllowHotellingFlag is true.
	fkenduser
	fkenduser_lastlogin	This is the id of the last logged on EM user
	fkfeaturecontrolpolicy	Feature Control Policy Record
	fkmatrix_presence
	fkmlppdomain
	fkphonetemplate
	fksoftkeytemplate
	ignorepi
	lastnumplanindex
	loginduration
	logintime	When the user logged in. This is a time_t value stored as a long. Set by the Login stored procedure.
	mismatchedlogin
	pkid	Unique ID to identify a record.
	tkbarge
	tkdndoption	Type of call handling while DND is enabled (0=Ringer Off, 1=Call Reject); depends on product support; overrides Device setting while logged in
	tkpreemption
	tkringsetting_dnd
	tkstatus_alwaysuseprimeline	Determines off-hook behavior of phones with active calls present
	tkstatus_alwaysuseprimelineforvm	Determines Voice Message retreival behavior of phones
	tkstatus_joinacrosslines
	tkstatus_mlppindicationstatus
	tkuserlocale
	userholdmohaudiosourceid
	versionstamp
externalcallcontrolprofile		For External Call Control Profiles
	enableloadbalancing
	fkcallingsearchspace_diversionrerouting
	name
	pkid	Unique ID to identify a record.
	primaryuri
	routingrequesttimer	This timer specifies the maximum time, in milliseconds, that Cisco Unified Communications Manager will wait for the response from the web service for a call routing request before taking the default call routing action
	secondaryuri
	tkcalltreatmentonfailure
facinfo		Contains the authorization information for For
	authorizationlevel
	code	All digits
	name	Used in CDR
	pkid	Unique ID to identify a record.
fallbackprofile		FallBack Profile
	description	Description is up to 128 characters including Unicode
	dtmfcollectiontimer	DTMFCollectionTimer
	fallbackcallanswertimer	FallbackCallAnswerTimer
	fallbackdid	Fall Back DID of the IME Published DID Pattern Group
	fallbackdn	Fall Back Directory Number of the IME Published DID Pattern Group
	fallbackqossensitivity	FallbackQOSSensitivity
	fkroutepartition
	name	Name of the FallBack Profile
	numcalleridmatchdigit	numCallerIDMatchDigit
	numfallbackdtmfdigit	numFallbackDTMFDigit
	pkid	Unique ID to identify a record
	tkfallbackcssselection
	tkfallbacksensitivitylevel
featureconfig		Feature specific parameters
	keyname	name of the Feature Configuration Parameter
	pkid	Unique ID to identify a record.
	tkfeatureconfig
	value
featurecontrolpolicy		FeatureControlPolicy
	clause	String indicating the feature by enum and the policy setting for that feature which overrides its default. Formatted as feature:setting;feature:setting
	description
	name	Unique name
	pkid	Unique ID to identify a record.
	versionstamp	New guid plus seconds past midnight 1970 are concatenated
featuregrouptemplate		Stores the provisioning data needed to a template of settings used when creating new end users
	allowcticontrolflag	When AllowCTIControlFlag is enabled, all users created based on this template will when a user logins to device, the device allows CTI Control
	cupsenabled	When CUPSEnabled is enabled, all users created based on this template will have CUPS client enabled
	description	A localizable administrative description of the Feature Group Template
	enablecalendarpresence	Determines whether others are allowed to see the meeting information for the user in Presence status
	enableemcc	When enableEMCC is enabled, all users created based on this template will have capability to access EMCC feature
	enablemobilevoice	When EnableMobileVoice is enabled, all users created based on this template Enable IVR/Two-stage Dialing access
	enablemobility	When EnableMobility is enabled, all users created based on this template Indicates whether a user has been licensed to use Mobility (SNR) features
	enableusertohostconferencenow	This will give user privilege to start a meeting in Conference Now with their PIN. User may set up optional attendee access code on the Self-care portal.
	fkcallingsearchspace_restrict	Reference CallingSearchSpace record that defines restriction.
	fkmatrix_presence	Reference to Presence Group Matrix record. This is required for extension mobility. Appuser table does not need this because appuser cannot do extension mobility
	fkucserviceprofile	Reference to UC Service Profile record that defines UC Services for the end user.
	fkucuserprofile	Used to define for users created via this FGT the optional UCUserProfile with which, if present, they should be associated.
	islocaluser	When IsLocalUser is enabled, all users created based on this template Indicate whether the user is local to the UCM cluster
	maxdeskpickupwaittime	All users created based on this template will have Max wait time for desk phone pickup in milliseconds
	name	Unique name to Identify the Feature Group Template
	pkid	Unique identifier for the record
	remotedestinationlimit	All users created based on this template will have this Max number of remote destinations associated with the EndUser (Mobility must also be enabled)
	tkuserlocale	all users created based on this template will have this Locale associated with the user. The user locale identifies a set of detailed information to support users, including language and font.
functionrole		A role comprises a function which is a set of permissions on resource-action tuples.
	description
	isstandard
	name
	pkid	Unique ID to identify a record.
functionroledirgroupmap		Many to many relationship between FunctionRole and DirGroup
	fkdirgroup
	fkfunctionrole
	pkid	Unique ID to identify a record.
functionroleresourcemap		Captures what roles have what permissions.
	fkfunctionrole
	permission
	pkid	Unique ID to identify a record.
	tkresource
gatekeeper		Gatekeeper information in not in Device table
	enabledevice
	fkdevice
	pkid	Unique ID to identify a record.
	retrytimeout
	rrqtimetolive
gatewaylayout		Static table for MGCP gateway layout.
	endpointformatstring
	enum	A number to identify the record
	lev1header
	lev2header
	slotposition
	tkdeviceprotocol
	tkmgcpslotmodule
	tkmgcpvic
	tkproduct
gatewaynetworkdetail		CUBA: GatewayNetworkDetail table to store the network details for the Gateway.
	defaultgateway	DefaultGateWay for the gateway table
	fkmgcp	Reference to MGCP
	ipaddress	ipAddress for the gateway table
	isdhcp	check for DHCP
	pkid	Unique identifier for the record
	primarydns	PrimaryDNS for the gateway table
	secondarydns	SecondaryDNS for the gateway table
	subnetmask	SubNetMask for the gateway table
geolocation		Used to store the GeoLocation for devices
	a1	National Subdivision
	a2	District
	a3	Community Name
	a4	City Division
	a5	Neighbourhood
	a6	Street
	country	Country name identified by two letter ISO
	description
	flr	Floor
	hno	House Number
	hns	House Number Suffix
	lmk	Landmark
	loc	Location
	nam	Occupant Name
	name	Unique Name to identify a record
	pc	Postal Code
	pkid	Unique ID to identify a record
	pod	Trailing Street Suffix
	prd	Leading Street Direction
	sts	Street Suffix
geolocationfilter		Used to store GeoLocation filters
	description
	name	Unique Name to identify a record
	pkid	Unique ID to identify a record
	usea1	If true A1 column is part of the filter string else not
	usea2	If true A2 column is part of the filter string else not
	usea3	If true A3 column is part of the filter string else not
	usea4	If true A4 column is part of the filter string else not
	usea5	If true A5 column is part of the filter string else not
	usea6	If true A6 column is part of the filter string else not
	usecountry	If true Country column is part of the filter string else not
	useflr	If true FLR column is part of the filter string else not
	usehno	If true HNO column is part of the filter string else not
	usehns	If true HNS column is part of the filter string else not
	uselmk	If true LMK column is part of the filter string else not
	useloc	If true LOC column is part of the filter string else not
	usenam	If true NAM column is part of the filter string else not
	usepc	If true PC column is part of the filter string else not
	usepod	If true POD column is part of the filter string else not
	useprd	If true PRD column is part of the filter string else not
	usests	If true STS column is part of the filter string else not
geolocationpolicy		Used to store Logical Partition policy records
	a1	National Subdivision
	a2	District
	a3	Community Name
	a4	City Division
	a5	Neighbourhood
	a6	Street
	country	Country name identified by two letter ISO
	description
	flr	Floor
	hno	House Number
	hns	House Number Suffix
	lmk	Landmark
	loc	Location
	nam	Occupant Name
	name	Unique Name to identify a record
	pc	Postal Code
	pkid	Unique ID to identify a record
	pod	Trailing Street Suffix
	prd	Leading Street Direction
	sts	Street Suffix
geolocationpolicymatrix		Used to store Logical Partition Policies
	fkgeolocationpolicy_a
	fkgeolocationpolicy_b
	pkid	Unique ID to identify a record
	tkgeolocationdevice_a	Refers to the Logical Partition Device type
	tkgeolocationdevice_b	Refers to the Logical Partition Device type
	tklogicalpartitionpolicy	Refers to the Logical Partition Policy
globalsetting		Definition records for use by various applications as persistent global settings. Useful in pointing to a record in another table as a default setting or where referential or control rules are needed.
	pkid	GUID based surrogate primary key for unique application reference to the GlobalSetting type definition record
	settingvalue	Contains the actual Setting Value for the Global Setting as defined by the referenced TypeGlobalSetting foreign key in this record
	tkglobalsetting	Foreign key indentifying the associated type definition which describes the purpose, use, and rules associated with this setting
grtreport		A report
	description
	isstandard
	name
	pkid	Unique ID to identify a record.
grtreportsourcemap		A mapping table to map GRTSource and GRTReport
	fkgrtreport
	fkgrtsource
	isstandard
	pkid	Unique ID to identify a record.
	priority
	sourceparam
grtsource		Data sources for Reporting tool
	beforegenprompt	Prompt to display before generating this report.
	description
	isstandard
	javamethod
	javaobj
	name
	pkid	Unique ID to identify a record.
	remedy	possilbe remedy to resolve data under test
	symptom	possible symptoms if errors exist in data under test
h323device		H.323 information not in Device table
	acceptinboundrdnis
	activecap
	allowh235passthrough	Pass through of the H.235 ClearToken encryption key through an Cisco Unifed CM H.323 ICT, H.323 Trunk or H.323 Gateway is Allowed
	calleriddn
	conncallbeforeplayingann	True, if inbound call should be connected before playing queuing announcement. It is applicable only for H.323 Gateways and H.225 Trunk (Gatekeeper and Non-gatekeeper Controlled Intercluster Trunks). It is not applicable to H.323 clients
	displayie
	e164
	enableinboundfaststart
	enableoutboundfaststart
	fkcallingsearchspace_cntdpntransform	Calling Search Space for Connected Party Name Transformation Pattern
	fkdevice
	fkdevice_gatekeeper
	ictpassingprecedencelevelthroughuuie	Valid for Non-Gatekeeper Controlled Inter-cluster Trunks only
	ictsecurityaccesslevel	SAL is ignored when PassingPrecedenceLevelThroughUUIE is FALSE
	issafenabled	Indicates as to whether the trunk is enabled for SAF
	numberie
	numdigits	99 is used for all digits instead of SigDigits = false
	pathreplacementsupport
	pkid	Unique ID to identify a record.
	prefix
	runh225doneverynodeflag
	sigdigits	Must be 1 if (NumDigits >= 0) AND (NumDigits <= 32), or 0 if (NumDigits = 99)
	signalingport
	technologyprefix
	tkasn1roseoidencoding
	tkcallingpartyselection	Source of the calling party number: originator = 1, first redirect = 2, last redirect = 3
	tkmediapayload
	tknumberingplan_called
	tknumberingplan_calling
	tkpresentationbit	CLID presentationBit: allowed = 1, restricted = 2
	tkpriofnumber_called
	tkpriofnumber_calling
	tkqsigvariant
	tkterminal
	tktunneledprotocol
	useclientconfiguration
	usedpconnectedpartytransformationcss	If set to true fkCallingSearchSpace_CntdPNTransform setting from Device Pool will be used and if false use setting on H323Device including NULL to mean no Calling Search Space. The Default value is TRUE
	zone
h323trunkdestination		To store the details of H323 Trunk destination
	address	IP address or host name for this EndPoint instance of the corresponding H323 Device
	fkh323device	Points to the corresponding H323 Device record to which the EndPoint Address relates.
	pkid	Unique ID to identify a H323 Trunk Destination record.
	sortorder	Numeric value used to control selection logic associated with choosing the next H323TrunkEndPoint address for a given logical H323 Trunk Endpoint. This value should be unique among the set of all endpoint addresses associated with a given H323 Trunk record.
hostedroutepattern		Numeric route patterns that should be replicated to other clusters
	description
	pattern	Numeric route pattern
	pkid	Unique ID to identify a record.
	pstnfailoverprependdigits	Digits to prepend to called party number when re-routing to the PSTN.
	pstnfailoverstripdigits	Number of leading digits to remove from the called party number when re-routing to the PSTN.
	tkglobalnumber	Categorizes the pattern as specific type of global number.
	tkhostedroutepatternpstnrule	Specifies the method for deriving the PSTN Failover Number.
hosteduri		URI member of HostedURICatalog
	hosteduricatalogkey_id	Hosted Catalog Key ID
	pattern	ILS Learned Pattern for Hosted URI.
	pkid	Unique ID to identify a record.
	pstnfailover
	tkpatternusage	Pattern usage for ILS Learned Pattern Hosted URI
	usn	Update sequence number for intercluster replication.
hosteduricatalog		Set of URIs homed on external systems for which this cluster acts as a publisher to other clusters in the ILS network.
	description	Description of the catalog.
	loadedfilename	Name of the administrator-specified URI file most recently loaded.
	name	Unique name for this catalog.
	peerid	Unique identifier on the ILS network. This value cannot be modified after the collection has been created.
	pkid	Unique ID to identify a record.
	replicationset	Catalog's replication set
	resultfilename	Name of file generated for ILS.
	routestring	Administrator-defined character string to which SIP Route Pattern is compared.
	timestamploadedutc	Date/time the catalog was loaded.
hosteduricatalogkey		Non Reference Index constrained map between HostedURI and HostedURICatalog
	fkhosteduricatalog	Pkid reference from HostedURICatalog.
	hosteduricatalogkey_id	A reasonable sized key. Generated for use from HostedURI to reference associated Hosted URI Catalog.
	isdeleted	When true, the associated Hosted URI Catalog has been deleted but all dependent Hosted URIs are not yet scrubbed.
	pkid	Unique ID to identify a record.
httpinterfaceaddress		Contain HTTP Interface info which is used for TelePresence conference bridge management
	address	IPV4/IPv6address/hostname for HTTP desitination address for TelePresence Conference Bridge
	fkdevicemanagementinfo	Reference to a specific DeviceManagementInfo
	pkid	Unique ID to identify a record.
httpprofile		Http Profile Information, stores URI information relating to various Http services such as Video Quality of Service
	password	HTTP Service login password
	pkid	Unique ID to identify a record.
	profilename	Unique identifcation of the HTTPProfile.
	requesttimeout	This timer specifies the maximum time, in milliseconds, that Cisco Unified Communications Manager will wait for the response from the web service.
	retrycount	RetryCount specifies the number of times that Cisco CallManager will re-send the request. Default should be 4
	tkhttpprofile	Specifies the HTTP Profile Usage
	username	HTTP Service login user name
	webservicerooturi	Base URI which is joined with the associated connection type and extension to form a full URI.
httpprofileuriextension		Http Profile URI Extension Information which specifies the URI extensions and profile type for a Http Profile.
	fkhttpprofile	Reference to the Http Profile. Obsolete - not used
	pkid	Unique ID to identify a record. Obsolete - not used
	tkhttpprofileuri	Specifies the type of HTTP Profile URI. Obsolete - not used
	uriextension	Specifies the URI extension which is appended to the associated profile's webServiceRootURI. Obsolete - not used
httpproxyexception		Stores Exception details for Wireless LAN HTTP Proxy.
	fknetworkaccessprofile	Reference to Wireless LAN Network Access Setting.
	pkid	Unique ID to identify a record.
	uri	HTTP Proxy Exception URI
huntpilotqueue		To store settings used by Queue calls in hunt pilot
	fkcallingsearchspace_maxwaittime	Wait Time Reached Route Call to CSS
	fkcallingsearchspace_noagent	Route Call to CSS if no agent logged in or registered
	fkcallingsearchspace_pilotqueuefull	Queue Full Route Call to CSS
	fknumplan_pilot	Hunt Pilot using the Queue
	maxcallersinqueue	Max Number of Callers Allowed in Queue
	maxwaittimedestination	Wait Time Reached Route Call to DN
	maxwaittimeinqueue	Max Queue Wait Time
	networkholdmohaudiosourceid	Network Hold Audio Source ID
	noagentdestination	Route Call to DN if no agent logged in or registered
	pkid	Unique identifier for native queue call record
	queuefulldestination	Queue Full Route Call to DN
imsintegratedmobile		Settings specific to IMS Integrated Mobile devices (IMS Clients)
	blockincomingcallswhenroaming	Block incoming calls on the IMS Client when it is outside its home network
	fkdevice	Reference to an IMS Integrated Mobile Device
	homenetworkid	Network name or identifier of the IMS Client home network. Required for blocking incoming calls when roaming
	pkid	Unique identifier for the record
	requirethirdpartyregistration	Require client registration (with an application server) prior to allowing any incoming or outgoing calls
inactiveusers		Table for storing inactive endusers
	fkenduser	Foreign key to EndUser table
	pkid	Unique ID to identify a record
incomingtransformationprofile		Incoming Transformation Profile
	description	Description is up to 128 characters including Unicode
	fkcallingsearchspace_intl	International Number
	fkcallingsearchspace_national	National Number
	fkcallingsearchspace_subscriber	Subscriber Number
	fkcallingsearchspace_unknown	Unknown Number
	internationalprefix	International Prefix
	internationalstripdigits	International Strip Digits
	name	Name of the IncomingTransformationProfile
	nationalprefix	National Prefix
	nationalstripdigits	National Strip Digits
	pkid	Unique ID to identify a record
	subscriberprefix	Subscriber Prefix
	subscriberstripdigits	Subscriber Strip Digits
	unknownprefix	Unknown Prefix
	unknownstripdigits	Unknown Strip Digits
infrastructuredevice		The table is used to store the information of upstream neighbour infrastructure device
	bssidwithmask	Basic Service Set Identifier:A unique address that identifies the access point/router that creates the wireless network.
	datetimestamp	Denotes last time the fields were updated.
	ipv4address	IPv4 address of the Ethernet switch or the Access point.
	ipv6address	IPv6 address of the Ethernet switch or the AP.
	isactive	If true, then device (i.e Switch,or Wireless Access Point) is active, otherwise it is not communicable and inactive.
	name	Name of Ethernet switch or Access point.
	pkid	Unique identifier for the record.
	waplocation	Location of Wireless application protocol.
installmonitor		Used to send change notification of subscriber install
	datetimestamp	Time stamp
	id	Unique orderable id.
	nodename	Name of Subscriber pulling subscription
	pkid	Used only to trigger MakeDB to generate Change Notification triggers
interclusterserviceprofile		Locally configured intercluster services information
	fkdevice_sip	Pkid that points to dynamic SIP trunk device.
	isactivated
	pkid	Unique ID to identify a record.
	tkinterclusterservice
intercomdynamic		Reserved for future use; Current device association for Intercom line when used with EM.
	datetimestamp	Time value for last change (for replication conflict resolution)
	fkdevice	Reserved for future use; References the current active device associated with an intercom for EM
	fknumplan	References Intercom pattern in NumPlan table
	pkid	Unique ID to identify a record.
	versionstamp	New guid plus seconds past midnight 1970 are concatenated
ipmalineinfo		IPMA relationship between two lines for two users
	fkenduser	Asst?
	fknumplan
	ikipmalineinfo	Manager's line
	isprimary
	lineindex	Ordering of lines.
	pkid	Unique ID to identify a record.
ipmamanagerassistant		Relationship for IPMA between a manager and an assistant
	fkenduser_assistant
	fkenduser_manager
	pkid	Unique ID to identify a record.
ipmastaticdata		IPMA data that used to be in a BLOB
	diverttargetnumber
	filterexclusive	digit strings (0-9*+X) separated by delimiter "~&^"
	filterinclusive	digit strings (0-9*+X) separated by delimiter "~&^"
	fkdevice
	fkenduser
	fkenduser_defaultasst
	fknumplan_intercomdn
	fknumplan_primarydn
	mobilemanager
	pkid	Unique ID to identify a record.
	settingsdata
	shortcutkeys
	tkipmalinemode
	tkipmatarget_divert
ipmauser		Additional IPMA information not in EndUser
	alerttone
	assistantwatch
	available
	callplaneoverwriteenabled	True to allow screen refresh while on call, false to prevent screen refresh while attending a call
	desktopauthenticated
	dnd
	filter
	filtertype
	fkenduser
	phoneauthenticated
	pkid	Unique ID to identify a record.
	pool	IPMA Pool from Service Parameters (ID 1 to 10)
	sac
	secretkey
	selecteduserid
	smartsortenabled	True to sort display by call state, false to sort in defined order
	stopupdate	Indicates the status of update of manager calls on assistant phone is on/off (false/true)
	usertype
ivruserlocale		Order of prompts for IVR menus
	orderindex	Sort order for locales offered for IVR prompts
	pkid	Unique ID to identify a record.
	tkuserlocale	Locale used for IVR prompts (Mobility features)
lbmgroup		Location Bandwidth Manager Group refers to the group of nodes that have LBM service activated
	description	Description is up to 128 characters including Unicode
	fkprocessnode_active	Active node/server that has LBM service activated
	fkprocessnode_standby	Standby node/server that has LBM service activated
	name	Name of the Location Bandwidth Manager Group
	pkid	Unique ID to identify a Location Bandwidth Manager Group
lbmhubgroup		Defines a group of LBM nodes that serve as the hub contact list for the associated spoke LBM nodes. The hub group member could be a local or remote LBM hub node
	description	Description is up to 100 characters in any language
	hostorip_primary	Primary member of LBM Hub Group. If your network uses DNS services, you can enter the host name of the Cisco CallManager server. Otherwise, you must enter the full IP address of the server.
	hostorip_secondary	Secondary member of LBM Hub Group. If your network uses DNS services, you can enter the host name of the Cisco CallManager server. Otherwise, you must enter the full IP address of the server.
	hostorip_tertiary	Tertiary member of LBM Hub Group. If your network uses DNS services, you can enter the host name of the Cisco CallManager server. Otherwise, you must enter the full IP address of the server.
	name	Name of the Location Bandwidth Manager Hub Group
	pkid	Unique ID to identify LBM Hub Group configured
ldapauthentication		Used for authentication with Corp. Dir.
	authenticatewithcorpdir
	ldapdn
	ldappassword
	pkid	Unique ID to identify a record.
	userbase
ldapauthenticationhost		LDAP Server host name for authentication
	hostname
	pkid	Unique ID to identify a record.
	portnumber
	priority
	sslenabled
	tkldapprotocol
ldapfilter		LDAP Filter
	filter	The Filter string to be passed to the LDAP Host in a sync request used to restrict results to a subset of the possible result records.
	name	The filter name should help the administrator identify and select the appropriate customized filter for reference by a sync agreement.
	pkid	Unique ID to identify a record.
ldapsearchagreement		Directory Search LDAP for Edge Clients
	distinguishedname	Distinguished Name of LdapSearchAgreement
	enabledirectorysearch	Flag indicating whether user search is enabled
	enablerecursivesearch	Flag indicating whether recursive search is enabled
	fkldapfilter_group	Association between LDAPFilter and LdapSearchAgreement. This filter is used to search only groups
	fkldapfilter_user	Association between LDAPFilter and LdapSearchAgreement. This filter is used to search only users
	fkucservice_primary	Association between UCService directory and LdapSearchAgreement. Primary service will have the information about the hostname/ipaddress and protocol to make the necessary primary LDAP connection
	fkucservice_secondary	Association between UCService directory and LdapSearchAgreement. Secondary service will have the information about the hostname/ipaddress and protocol to make the necessary secondary LDAP connection
	fkucservice_tertiary	Association between UCService directory and LdapSearchAgreement. Tertiary service will have the information about the hostname/ipaddress and protocol to make the necessary Tertiary LDAP connection
	password	LDAP password of LdapSearchAgreement
	pkid	Unique ID to identify a record
	usersearchbase1	Primary UserSearchBase for LDAP. This will be used by Cisco Jabber client to search the User through UDS from the Enterprise Directory
	usersearchbase2	Secondary UserSearchBase for LDAP. This will be used by Cisco Jabber client to search the User through UDS from the Enterprise Directory
	usersearchbase3	Third UserSearchBase for LDAP. This will be used by Cisco jabber client to search the User through UDS from the Enterprise Directory
ldapsearchattribute		Table which will store UDS tag and LDAP attribute mapping
	dirobjectclassattrname	LDAP attribute name
	fkldapsearchagreement	Association with the ldapsearchagreement table.
	pkid	Unique ID to identify a record.
	tkldapserverattr	LDAP attribute type mapping.
ldapserverattribute		Prepopulated ldap attribute names for each server type
	dirobjectname
	pkid	Unique ID to identify a record.
	tkldapserver
	tkldapserverattr
ldapsystemconfig		LDAP System Config
	pkid	Unique ID to identify a record.
	syncenabled	Indicates whether plugin is enabled
	tkldapserver
	useridattributename	Attribute name to be used for Userid
licensedistributionused		Contains information about license units distributed and license units checked out to each license server for each feature
	distributedlicenseunits	Number of license units available on each license server for each feature.
	fklicenseserver
	isavailable	Indicates License Unit availability including substitution via borrowing from Parent license(s).
	pendinglicenseunits	Number of DLUs required to convert BAT dummy phones (or other inactive device) to a real licenses phone
	pkid	Unique ID to identify a record.
	tklicensefeature
	usedlicenseunits	Cumulative license units checked out from each license server.
licenseinfo		Licenseing acccounting for a server for a partincular fearture
	fklicenseserver
	isdemo	License is for demonstration (trial) only
	isvalid
	licenselineid	LicenseLineID
	licenseunits	Number of license units available on each license server for each feature.
	licfileid	identifer of license file. example 20050826140539162
	licfileversion	version of license file. example 1.0
	macaddress	This is the media access control (MAC) address of the network interface card (NIC) of server where intial license was isuesed
	origmacid	This is a second media access control (MAC) address of the network interface card (NIC) of server where intial license was isuesed. example 000BCD4EE59D
	overdraftunits
	pkid	Unique ID to identify a record.
	tklicensefeature
	upgradefromwindows	The default for UpgradeFromWindows is false
	version
licenseserver		The prioritized list of license servers is specified in this table
	description
	elmlastcontactts	This is the time of last contact of the product with the ELM that it is registered to
	elmname	Could be hostname or ip address
	fkprocessnode	associated processnode to license server
	graceleftdays
	gracestarttime
	lastresourceusagecalculationts	This is the time stamp for the latest calculation of Licensed Resource Utilization on the product.
	name	Could be hostname or ip address
	pkid	Unique ID to identify a record.
	priority	Specifies which license server has greater priority for the cluster.
	tklicensingmode	This is the Licensing Mode on the product.
	tklicensingstate	This is the State on the product with reference to Licensing.
licensingresourceusage		Contains the resource device tier usage count per user
	adjunct
	bronze
	copper
	em	True if EM is configured for user.
	fkenduser	Unique ID of enduser whose device usage is counted, null for devices not associated with a user.
	gold
	pkid	Unique identifier for the record
	presence	TRUE if user has IM And Presence.
	silver
	snr	True if SNR is configured for user.
	telepresence
	tin
	unknowndevice
linegroup		Used by Route/Hunt Lists
	autologoffhuntmembers	This field indicates that the Hunt members associated to the Line Group will be logged off automatically from the Hunt List when a member does not answer the call. The member will be auto logged off when the value is set to true.
	name	Unique name
	pkid	Unique ID to identify a record.
	rnareversiontimeout	Time, in seconds, after which call distribution will distribute a call to the next available or idle member of this line group if the call is not answered.
	tkdistributealgorithm	Distribution algorithm. It could be Top Down, Circular, Longest Idle Time (default) or Broadcast.
	tkhuntalgorithm_busy
	tkhuntalgorithm_down
	tkhuntalgorithm_rna
linegroupnumplanmap		Maps Line Groups to NumPlans to be used by Route/Hunt Lists
	fklinegroup
	fknumplan
	lineselectionorder	There is no requirment for this index to be sequential per LineGroup nor to begin with a particular value per Line Group.
	pkid	Unique ID to identify a record.
localestringformatrulemap		Mapping of string formats to user locales.
	pkid	Unique ID to identify a record.
	tkstringformatrule	Rule that the locale is associated with.
	tkuserlocale	Locale that the rule is associated with.
location		Location to specify the number/combined size of calls within a zone
	fkmatrix	Pkid of Matrix record for RSVP Policy
	hiresversionstamp	Hi Rez VersionStamp combination of DateTimeStamp and counter
	id
	isstandard	Whether it is standard
	name	Unique name.
	pkid	Unique ID to identify a record.
	resynctoggle	Should this location be resyced
	withinlocation_immersivekbits	Maximum amount of video bandwidth (in kbps) that is available for all video calls on the link between specified locations A and B. For Immersive video calls, the video bandwidth does not include overhead.
	withinlocation_kbits	Maximum amount of audio bandwidth (in kbps) that is available for all audio calls on the link between this location and other locations. For audio calls, the audio bandwidth includes overhead.
	withinlocation_videokbits	Maximum amount of video bandwidth (in kbps) that is available for all video calls on the link between this location and other locations. For video calls, the video bandwidth does not include overhead.
locationmatrix		Edge bandwidth available between locations
	fklocation_a	Side A of edge, that forms the link between locations A and B. Edges are non directional, so A->B is same as B->A
	fklocation_b	Side B of edge, that forms the link between locations A and B. Edges are non directional, so A->B is same as B->A
	hiresversionstamp	Hi Rez VersionStamp combination of DateTimeStamp and counter
	immersivekbits	Maximum amount of video bandwidth (in kbps) that is available for all video calls on the link between specified locations A and B. For Immersive video calls, the video bandwidth does not include overhead.
	kbits	Maximum amount of audio bandwidth (in kbps) that is available for all audio calls on the link between specified locations A and B. For audio calls, the audio bandwidth includes overhead.
	pkid	Unique ID to identify Location Edge
	videokbits	Maximum amount of video bandwidth (in kbps) that is available for all video calls on the link between specified locations A and B. For video calls, the video bandwidth does not include overhead.
	weight	Weight of a location edge refers to the cost incurred in using the edge for routing. Shortest call path consumes least weight. Weight defaults to 50
machineaccountdetails		Table to store the refresh and access token details when UCM or IMP is obtaining a token from an external Authorization Server.
	accesstokenurl	The Auth MicroService URL that UCM/CIMP must use to obtain new access token (using refresh token).
	alarmurl	URL for Cisco Management Agent Service to register alarms associated with Cisco Cloud services.
	cacerturl	Get CA api URL which is used to get CA certificates.
	expiresin	The lifetime in seconds of the refresh token. UCM/CIMP does not need to replicate or use this value. ExpiresIn will be typically 60 days.
	metricsurl	URL for Cisco Unified Presence to track metrics associated with Cisco Cloud services.
	pkid	Unique ID to identify a record.
	pushmsurl	URL that CIMP must use to send a jabber push notification.
	refreshtoken	The refresh token can be used by UCM/CIMP to obtain new access token from Cisco Cloud using AccessTokenUrl.
	refreshtokenurl	The Auth MicroService URL that UCM/CIMP must use to delete a refresh token
	refreshuuid	The refresh UUID can be used by UCM to call the DeleteRefreshToken API and GetCA API on Cisco Cloud using the respective URLs.
machineaccounturl		Machine account URLs
	fkmachineaccountdetails	foreign key to machine account detail
	pkid	Unique ID to identify a record.
	serviceurl
	tkcloudservice	The type of cloud service
matrix		Generic Matrix Table
	description	Description of the matrix record
	ikmatrix	Pkid of Matrix record for chaining.
	isstandard	Whether it is a standard security policy
	name	A name to identify the record
	pkid	Unique ID to identify a record.
	tkmatrix	Type of Matrix record
matrixmember		Member records for Matrix
	fkmatrix_1	Pkid of Matrix record
	fkmatrix_2	Pkid of Matrix related record
	pkid	Unique ID to identify a record.
	tkmatrixvalue	Refers to the various types but for a particular Matrix type
mediamixer		Software conference bridge device settings
	basemulticastaddress
	basemulticastport
	fkdevice
	maxstreams	Number of ports supported.
	pkid	Unique ID to identify a record.
mediaresourcegroup		A group of media resources to be used by a device
	description	Description for the Media Resource Group.
	multicast	Whether to use multicast for Music On Hold Audio.
	name	Unique name to identify the Media Resource Group.
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	tkreset	Set by DeviceReset stored procedure.
mediaresourcegroupmember		Ties devices to Media Resource Groups
	fkdevice	1-20 per group
	fkmediaresourcegroup
	pkid	Unique ID to identify a record.
mediaresourcelist		A list of MediaResourceGroups to be used by a device
	clause	Trigger updated. Colon separated list.
	name	Unique name to identify the Media Resource Group List.
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	tkreset	Set by DeviceReset stored procedure.
mediaresourcelistmember		Ties Media Resource Groups to Media Resource Lists
	fkmediaresourcegroup	Media resource group that belongs to this Media Resource Group List.
	fkmediaresourcelist
	pkid	Unique ID to identify a record.
	sortorder	There is no requirement for this index to be sequential nor to start with any particular value for a Media Resource Group.
mgcp		MGCP device information sometimes refered to as box level information
	description	Description of the MGCP gateway that clarifies the purpose of the device.
	domainname	Name that identifies the Cisco MGCP gateway.
	fkcallmanagergroup	Cisco CallManager redundancy group.
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	scratch	Used to store temporary info for GUI
	specialloadinformation
	tkclass
	tkdeviceprotocol
	tkproduct
	tkreset	Set by DeviceReset stored procedure.
	versionstamp	New guid is generated every time this gateway is updated
	xml	Product configuration XML not used by CCM
mgcpdevicemember		Relationships between MGCP and Devices.
	fkdevice
	fkmgcp
	pkid	Unique ID to identify a record.
	port
	slot
	subunit
mgcpslotconfig		Used by the GUI to show slots and VIC configurations for MGCP devices.
	beginningportnumber
	fkmgcp
	pkid	Unique ID to identify a record.
	slot
	subunit
	tkmgcpslotmodule
	tkmgcpvic
mlaparameter		Configuration parameters for MultiLevelAdmin
	name
	pkid	Unique ID to identify a record.
	value
mlppdomain		Domains for Mlpp
	id	hex identity of domain
	name	name of domain
	pkid	Unique ID to identify a record.
	usermodifiable
	versionstamp	New guid plus seconds past midnight 1970 are concatenated
mobilesmartclientprofile		Settings for Smart Client devices used with Mobility
	enablecfauri	URI to enable call forward all
	enablesnruri	URI to enable mobile connect
	handoffuri	URI for handoff
	isstandard	Standard entry created by install that cannot be modified or removed
	name	Name of this profile
	pkid	Unique ID to identify a record.
	tkmobilesmartclient	Smart client application model
mobilityprofile		To store details of Mobility Profile for Least Cost Routing
	description	Localizable description of Mobility Profile
	dvofserviceaccessnumber	parameter specifies an alternative service access number for smart phone users to dial when invoking the Dial-via-Office Forward feature
	dvorcallerid	Mobility will use this as callerid for the callback to mobile in case of DVO-Reverse
	fknumplan	points to the numplan entry that specifies a number for smart phone users to dial when invoking the Dial-via-Office Forward feature.
	name	Unique name
	pkid	Unique ID to identify a record.
	tkdialviaoffice	Reference to the DialViaOffice type setting associated with this MobilityProfile. Indicates how external calls made through the UCM, (by Remote Destinations associated with this profile), should be connected with the originator.
modelfeaturemap		All feature types allowed for a particular model
	enum	Used for primary key so can be replicated by SQL
	tkdeviceprotocol
	tkfeature
	tkmodel
mohaudiosource		information on sources for music for Music on Hold
	alwaysplayinitialannouncement	AlwaysPlayInitialAnnouncement gives the user an option to choose whether to play the initial announcement to hunt pilot callers. when it is set to False, caller will not hear initial announcement when an agent is availble.
	fkcustomannouncement_initial	Initial custom announcement
	fkcustomannouncement_repeat	Repeat Custom Announcement
	highsourcefiledatetime
	isexternalsource	Used to indicate a change of meaning for the SourceFile field.
	lowsourcefiledatetime
	multicast
	name
	pkid	Unique ID to identify a record.
	repeat
	repeatinterval	Repeat interval for custom announcement
	sourcefile	MOH Fixed Audio Source stream (51) uses empty source file for disabled, /dev/dsp for enabled. Other values are invalid.
	sourceid
	tkuserlocale_announcements	Reference to TypeUserLocale
mohserver		Music on Hold server information
	fixedaudiosourceid	1-1000
	fkdevice
	maxmulticaststreams
	maxunicaststreams
	multicastbaseipaddress	Multicast base IP Address and Port must be set in tandem
	multicastbaseport	Multicast base IP Address and Port must be set in tandem
	multicastincrementonip
	pkid	Unique ID to identify a record.
	runflag
mohservermulticastinfo		ties multicast MOHAudioSources to MOHServers
	fkdevice
	maxhops
	mohaudiosourceid
	multicastaddress
	multicastport
	pkid	Unique ID to identify a record.
	tkmohcodec
mraservicedomain		MRA service domains
	isdefault	true indicates the current record is the default MRA service domain.
	name	A unique name for Customer
	pkid	Unique ID to identify a record.
	servicedomains
mrgmediaaccesspermission		CUBA: To store the permission information between media access (checkbox in UI which take input on access to MOH, MTP, CFB) and MRGL
	allowann	check for annonciater
	allowcfb	check for conference bridge
	allowmoh	check for Musich on hold
	allowmtp	check for MTP
	fkmediaresourcegroup	Reference to MRG
	pkid	Unique identifier for the record
networkaccessprofile		Stores Network Access details for a Wireless LAN Profile.
	description	Description of the Wireless LAN HTTP Proxy.
	name	Name of the Wireless LAN HTTP Proxy.
	namecredentialfornetauthentication	User identification name for network authentication.
	passwordreverse	Used for digest authentication
	pkid	Unique ID to identify a record.
	port	Port on which it makes the connection.
	proxyuri	ProxyURI
	requireauthentication	Indicates whether it requires authentication to make the connection.
	tkhttpproxy	Type of HTTP Proxy used.
	tkstatus_vpnrequired	Specifies the status on VPN requirement.
nsfinformationelement		For ISDN Network Specific Facilities information elements
	carrieridentificationcode
	fknumplan
	paramvalue
	pkid	Unique ID to identify a record.
	tknsfservice
	tkpriprotocol
nsfprotocolservicemap		Map NSF services to NSF supported Pri Protocols
	cicvalidation
	enum	A number to identify the record
	paramvaluevalidation
	tknsfservice
	tkpriprotocol
ntpserver		Servers to get time value from
	description	Description of NTP Server
	ipv6address	IPV6 address of the phone NTP server.
	name	IP Address for NTP Server
	pkid	Unique ID to identify a record.
	tkzzntpmode	NTP Mode
ntpserverdatetimesettingmap		Mapping between NTP Server and DateTimeSetting
	fkdatetimesetting	pkid of DateTimeSetting
	fkntpserver	pkid of NTP Server record
	pkid	Unique ID to identify a record.
	selectionorder	Identifies the order in which the NTP Server should be selected
numplan		List of all directory numbers and patterns
	aardestinationmask
	aarkeepcallhistory
	aarvoicemailenabled
	alertingname
	alertingnameascii	This is same as Alerting Name if all characters are ASCII.
	allowcticontrolflag	If true, this line allows CTI Control.
	authorizationcoderequired	Authorization Code (FAC) cannot be used when Overlap Sending is allowed
	authorizationlevelrequired	Configurable with AuthorizationRequired checked
	blockenable	Block CallerID on outbound calls?
	calledpartytransformationmask	A transform
	callforwardexpansionmask	CallForwardExpansionMask is set only for Route and Translation Patterns
	callingpartyprefixdigits	A transform - this is a mask pattern similar to PrefixDigitsOut
	callingpartytransformationmask	A transform
	calreference	user can assign confidential access level value to the line
	cfaptdestination	Call Forward Alternate Party Target Destination
	cfaptduration	CFAPTDuration is set only for Directory Numbers
	cfaptvoicemailenabled	CFAPTVoiceMailEnabled is TRUE only for Directory Numbers
	cfbdestination	Call Forward Busy (not a pattern)
	cfbintdestination
	cfbintvoicemailenabled
	cfbvoicemailenabled	CFBVoiceMailEnabled is TRUE only for Directory Numbers
	cfdfvoicemailenabled	CFDFVoiceMailEnabled is TRUE only for Directory Numbers.
	cfhrdn	Call Forward On Hold Reversion Destination (not a pattern)
	cfhrduration	time (in seconds) before held call is forwarded to CFHRDN; -1 defaults to Service Parameter, 0 disables feature; timer starts when HRDuration is reached
	cfhrintdn
	cfhrintvmenabled
	cfhrvmenabled
	cfnadestination	Call Forward No Answer (not a pattern)
	cfnaduration	CFNADuration is set only for Directory Numbers
	cfnaintdestination
	cfnaintvoicemailenabled
	cfnavoicemailenabled	CFNAVoiceMailEnabled is TRUE only for Directory Numbers
	cfurdestination
	cfurintdestination
	cfurintvoicemailenabled
	cfurvoicemailenabled
	clientcoderequired	Client Matter Code (CMC) cannot be used when Overlap Sending is allowed
	cssforcfa	CSS pkid string combined device CSS and line CSS when fkCallingSearchSpace_CFA is Null
	description
	devicefailuredn	Device failure
	deviceoverride	Used to denote if RP associated can be overridden
	dialplanwizardgenid	This record created by DialPlanWizard
	displayconnectedpartynumber	When this checkbox is enabled, caller will see the actual DN inside Line group which answered the call as connected party
	dnorpattern	Depends on PatternUsage
	dnorpatternipv6	SIP route pattern to include IPv6 address for URL based patterns. This field does not allow domain names.
	dontwaitforidtatsubsequenthops	When this checkbox is enabled, Inter digit timeout will not occur at any of the subsequent matches.
	externalpresentationname	This field displays the External Presentation Name on the device.
	externalpresentationnumber	External Presentation Number for the user.
	fkaarneighborhood
	fkcallingsearchspace_cfapt	Call Forward Alternate Party
	fkcallingsearchspace_cfb	Call Forward Busy
	fkcallingsearchspace_cfbint
	fkcallingsearchspace_cfhr	Call Forward On Hold Reversion
	fkcallingsearchspace_cfhrint
	fkcallingsearchspace_cfna	Call Forward No Answer
	fkcallingsearchspace_cfnaint
	fkcallingsearchspace_cfur	Call Forward Not Registered
	fkcallingsearchspace_cfurint	Call Forward Not Registered
	fkcallingsearchspace_devicefailure	Device failure
	fkcallingsearchspace_mwi	CallingSearchSpace_MWI is required only for Message Waiting Indicators
	fkcallingsearchspace_pff
	fkcallingsearchspace_pffint
	fkcallingsearchspace_pkmonfwdnoret	Calling Search Space for Park Monitoring Forward No Retreive Destination
	fkcallingsearchspace_pkmonfwdnoretint	Calling Search Space for Park Monitoring Forward No Retreive Internal Destination
	fkcallingsearchspace_reroute	NOT USED TODAY - Called Redirect CallingSearchSpace on admin
	fkcallingsearchspace_revert
	fkcallingsearchspace_sharedlineappear	CallingSearchSpace_SharedLineAppear is required only for Directory Numbers, Voice Mail Ports, Intercom Lines and line templates
	fkcallingsearchspace_translation	used only if tkPatternUsage is translation
	fkcallmanager	Pointer to CallManager assoicated with callparck
	fkdevice_intercomdefault	References the device associated with intercom line when EM is not used or not logged in
	fkdialplan	used only for route pattern
	fkdigitdiscardinstruction	A transform
	fkexternalcallcontrolprofile	NumPlan_fkExternalCallControlProfile must be null for pattern usage other than directory number, translation pattern, route pattern and line template
	fkmatrix_presence	Pkid for Presence Group Matrix record
	fkresourceprioritynamespace	Resource Priority Namespace for Route Patterns and Translation Patterns
	fkroutefilter	used only if pattern contains an @
	fkroutepartition	Route Partition is required for Intercom lines and Intercom Translation patterns.
	fkvoicemessagingprofile	VoiceMessagingProfile is required only for Directory Numbers
	hrduration	time (in seconds) before notification starts for held call; -1 defaults to Service Parameter, 0 disables feature
	hrinterval	time (in seconds) between notifications for held call; -1 defaults to Service Parameter, 0 disables feature
	iknumplan_parkcode	Directed Call Park record for which this record specifies the Retrieval Code.
	isanonymous	if true, External Presentation Name and External Presentation Number will be disabled.
	iscallable	If this numplan is mapped in DeviceNumPlanMap, this is true. Otherwise, this is user settable if it tkPatternUsage is device.
	isemergencyservicenumber	Whether the pattern is a Emergency Service Number
	ismessagewaitingon
	mlpppreemptiondisabled	if this is true, the matching patterns will not be preempted
	networkholdmohaudiosourceid	NetworkHoldMOHAudioSourceID is set only for Directory Numbers
	nfkccaprofile_id	The association of the CCAProfile with the DN will act as a flag that suggests the CCA service (DNAlias sycn service) should push the DN into the DNAlias sycn server. If there is no DN with CCAProfile configured, then CCA service would find this as an indication that the Admin doesn't want to push any records into the DNAlias sycn server and will not use up the CPUs.
	outsidedialtone	Dialtone associated with Gateways etc.
	parkmonforwardnoretrievedn	Park Monitoring Forward No Retreive Destination
	parkmonforwardnoretrieveintdn	Park Monitoring Forward No Retreive Internal Destination
	parkmonforwardnoretrieveintvmenabled	Park Monitoring Forward No Retrieve Internal Voice Mail is Enabled
	parkmonforwardnoretrievevmenabled	Park Monitoring Forward No Retrieve Voice Mail is Enabled
	parkmonreversiontimer	Park Monitoring Reversion Timer
	patternurgency	if true, then autodial when go off hook
	personalroutingenabled
	pff_cfb
	pff_cfna
	pffdestination
	pffintdestination
	pffintvoicemailenabled
	pffvoicemailenabled
	pkid	Unique ID to identify a record.
	prefixdigitsout	A transform - this is a mask pattern
	rejectanonymouscall	When RejectAnonymousCall is enabled, all anonymous incoming calls will be rejected
	resettoggle	Should this device or group be reset
	revertdestination	Revert destination when direct call park timeout expired
	routenexthopbycgpn	TRUE if Digit Analysis should use Calling Party Number when attempting to find the next pattern match
	routeonuserpart	The field is used for SIP Domain Routing Patterns
	supportoverlapsending	SupportOverlapSending is set only for Route Patterns
	tkautoanswer	auto answer enabled
	tkcalmode	user can assign confidential access level mode to the line
	tkcfacssactivationpolicy	CFA CSS Activation Policy
	tkdevicesecuritymode_minimumallowed	Level of security required for a Conference initiated on a Meet-Me pattern; not used for other pattern types
	tkmixer	used only if tkPatternUsage is MeetMe. Unicast/Multicast
	tknetworklocation	Only Route or Translation Pattern can be off-net
	tknumberingplan_called	Values are based on TypeNumberingPlan
	tknumberingplan_calling	Values based on TypeNumberingPlan
	tkpatternprecedence	MLPP Pattern Precedence can be other than Default only for Route Patterns, Translation Patterns, and Hunt Pilots
	tkpatternrouteclass
	tkpatternusage	{CallPark uses pattern, MeetMe uses DN, Device uses DNOrPattern, Translation uses pattern, PickupGroup uses DN}
	tkpresentationbit	References TypePresentationBit for port access where values 0/1/2 represents DEFAULT/ALLOWED/RESTRICTED
	tkpresentationbit_callingline	PresentationBit_CallingLine is Default only for Route and Translation Patterns
	tkpresentationbit_callingname	PresentationBit_CallingName is Default only for Route and Translation Patterns
	tkpresentationbit_connectedline	PresentationBit_ConnectedLine is Default only for Route and Translation Patterns
	tkpresentationbit_connectedname	PresentationBit_ConnectedName is Default only for Route and Translation Patterns
	tkpriofnumber_called	Values are based on TypePriOfNumber
	tkpriofnumber_calling	Values based on TypePriOfNumber
	tkreleasecausevalue	ReleaseCauseValue is No Error only for Route and Translation Patterns
	tkreset	Set by DeviceReset stored procedure.
	tkroaminguserstatus	0-if super user is logged in. 1-if logged out. 2-if logged out through ILS. Default is 1.
	tkstatus_partyentrancetone	Determines whether entrance tone is played for cBarge, Barge, and Conference entrance/exit.
	tkstatus_usefullyqualcallingpartynum	Must use default for non-route/translation patterns
	usecallercss	The field is used for SIP Domain Routing Patterns
	useoriginatorcss	When this checkbox is enabled, the call will be routed using originator's Calling Search Space
	userholdmohaudiosourceid	UserHoldMOHAudioSourceID is required only for Directory Numbers
	withtag	// update NSF element table if (SUCCEEDED(hr) && pnsfIEListDeletes && (pnsfIEListDeletes->GetRecordCount() >0 )) hr = DeleteNSFInformationElement(connectionInfo, errorInfo, pnsfIEListDeletes); if (SUCCEEDED(hr) && pnsfIEList && (pnsfIEList->GetRecordCount() > 0)) hr = BlastUpdateNSFInformationElement(connectionInfo, errorInfo, pnsfIEList); //Build and update withTag and withValueClause for numplan if (SUCCEEDED(hr) && ((pnsfIEList && (pnsfIEList->GetRecordCount() >0)) \|\| (pnsfIEListDeletes &&(pnsfIEListDeletes->GetRecordCount() >0)))) { _bstr_t clause; _bstr_t tag; trace.tracef(SDI_LEVEL_ARBITRARY, "Start to build Tag and Clause"); pRS->MoveFirst(); _bstr_t numplanID = pRS->GetFields()->GetItem("pkid")->GetValue().bstrVal; trace.tracef(SDI_LEVEL_ARBITRARY, "NumPlan ID is: [%s]", numplanID); hr = CNumPlanRulesWorker::BuildWithTagAndClause(pConnection, numplanID, tag, clause); trace.tracef(SDI_LEVEL_ARBITRARY, "Built Tag is: [%s]---Built Clause is: [%s]", tag, clause); if (SUCCEEDED(hr)) hr = hr = CNumPlanRulesWorker::UpdateWithTagAndClause(pConnection, numplanID, tag, clause); }
	withvalueclause	// update NSF element table if (SUCCEEDED(hr) && pnsfIEListDeletes && (pnsfIEListDeletes->GetRecordCount() >0 )) hr = DeleteNSFInformationElement(connectionInfo, errorInfo, pnsfIEListDeletes); if (SUCCEEDED(hr) && pnsfIEList && (pnsfIEList->GetRecordCount() > 0)) hr = BlastUpdateNSFInformationElement(connectionInfo, errorInfo, pnsfIEList); //Build and update withTag and withValueClause for numplan if (SUCCEEDED(hr) && ((pnsfIEList && (pnsfIEList->GetRecordCount() >0)) \|\| (pnsfIEListDeletes &&(pnsfIEListDeletes->GetRecordCount() >0)))) { _bstr_t clause; _bstr_t tag; trace.tracef(SDI_LEVEL_ARBITRARY, "Start to build Tag and Clause"); pRS->MoveFirst(); _bstr_t numplanID = pRS->GetFields()->GetItem("pkid")->GetValue().bstrVal; trace.tracef(SDI_LEVEL_ARBITRARY, "NumPlan ID is: [%s]", numplanID); hr = CNumPlanRulesWorker::BuildWithTagAndClause(pConnection, numplanID, tag, clause); trace.tracef(SDI_LEVEL_ARBITRARY, "Built Tag is: [%s]---Built Clause is: [%s]", tag, clause); if (SUCCEEDED(hr)) hr = hr = CNumPlanRulesWorker::UpdateWithTagAndClause(pConnection, numplanID, tag, clause); }
numplanappservermap		Which App servers service which DN(s)
	content
	fkappserver
	fknumplan
	pkid	Unique ID to identify a record.
numplandcpsyn		stores the pkid for directed call park patterns in NumPlan table that need to be synchronized
	parkcodeid	The pkid of the Directed Call Park code that requires Retrieval code sync. Does not use foreign key to avoid problems when deleting Directed Call Park numbers.
	pkid	Unique ID to identify a record.
	retrievalcodeid	The pkid of the Retrieval Code that needs sync with the Park Code. Null if Retrieval Code has not been created.
	seq	Trigger set on insert
numplandynamic		Separate MWI from NumPlan
	datetimestamp
	faxmessagecounts	FaxMessageCounts
	faxmessagecountsnew	FaxMessageCountsNew
	faxmessagecountsold	FaxMessageCountsOld
	faxmessagecountsurgent	FaxMessageCountsUrgent
	faxmessagecountsurgentnew	FaxMessageCountsUrgentNew
	faxmessagecountsurgentold	FaxMessageCountsUrgentOld
	fknumplan
	pkid	Unique ID to identify a record.
	tklampblinkrate_messagewaiting	This line has a message waiting (lamp is on). Set only by CallManager.
	voicemessagecounts	VoiceMessageCounts
	voicemessagecountsnew	VoiceMessageCountsNew
	voicemessagecountsold	VoiceMessageCountsOld
	voicemessagecountsurgent	VoiceMessageCountsUrgent
	voicemessagecountsurgentnew	VoiceMessageCountsUrgentNew
	voicemessagecountsurgentold	VoiceMessageCountsUrgentOld
numplansubpatternusagemap		CUBA: Mapping between NumPlan and NumPlan creator
	fknumplan	Reference to NumPlan entry
	pkid	Unique identifier for the record
	tksubpatternusage	Reference to typesubpatternusage for NumPlan
numplanuri		Stores URIs associated with a directory number
	doroutebyroutestring	Indicates whether other clusters may route to this URI or number using route string.
	fkendusernumplanmap	When a URI is a Directory URI this points to the primary extension that it is associated with.
	fknumplan	The directory number to which the URI belongs.
	fkroutepartition	The partition to which the URI belongs.
	isprimary	Indicates whether the URI is the primary URI for the directory number.
	pkid	Unique ID to identify a record.
	uri	SIP URI or number. If number, may be a mask.
onboardingdetails		Table to store the Cloud On-boarding registration details.
	alarmencryptkey	Stored alarm encryption key (encrypted)
	alarmpushintervalsecs	Interval between pushing queued alarms to cloud
	alarmpushnowtoggle	When this is modified it will trigger immediate push of queued alarms
	alarmsendencrypteddata	TRUE - if we need to send Encrypted Info is selected
	allowanalyticscollection	If set to true, troubleshooting information will be sent to Cisco Cloud.
	anonymousanalytics	A number to identify If the Analytic data should be send anonymouse
	customeronetimepassword	The indicate the One time password for create otp
	email	Email address used for delivery of the OTP (One Time Password for Apple Push Notification Registration.)
	enablegdscommunication	Enable GDS for activation codes
	enablehttpproxy	If set to true, the HTTP Proxy is enabled.
	enablepushnotification	If set to true, the machine is registered for Cloud On-boarding.
	enabletroubleshooting	If set to true, cisco will send trouble shooting information to the Cisco Cloud.
	enabletrustcacertificate	If set to true, cisco will manage the required CA certificates and copy it to Tomcat trust store.
	httpproxyaddress	URI for the HTTP Proxy if enabled.
	mraactivationdomain	Mra activation domain for activation codes
	orgid	The Organization id is to unqiuely identify the customer Org on Cisco Cloud.
	orgname	Organization name.
	partneremail	Email address used for delivery of the OTP (One Time Password for Apple Push Notification Registration.)
	pkid	Unique ID to identify a record.
	proxypassword	HTTP proxy password. The credentials are stored in an encrypted format.
	proxyusername	HTTP proxy username.
	serviceaddress	Cloud On-boarding service address.
	tkalarmseverity	The alarm severity.
	tkonboardingregistrationstatus	Identifies APNS auth registration status.
outboundappservercn		Custom CN for Apps that are not CN clients
	pkid	Unique ID to identify a record.
pagetemplate		Contains template names
	pkid	Unique ID to identify PageTemplate record
	templatename	Name of a UI page template
pagetemplatedetail		Contains details assigned to a template
	attributename	Name of a UI page attribute
	attributevalue	Value of a UI page attribute
	fkpagetemplate
	isdefault	Indicates a default field for this web page attribute
	ishidden	Indicates a hidden field for this web page attribute
	isreadonly	Indicates a readonly field for this web page attribute
	pkid	Unique ID to identify PageTemplateDetail record
patternparametermap		Pattern Parameter Map
	fkdialrulespatternmap	Pkid of DialRulesPatternMap record
	pkid	Unique ID to identify a record.
	selectionorder
	tkdialparameter
	value
personaladdressbook		Users keep their contacts here for Personal Address Book/TabSync
	email
	firstname
	fkenduser
	fkenduser_contact	Contact userid that an user would like to add to his PAB
	lastname
	nickname
	pkid	Unique ID to identify a record.
personalphonebook		Users keep their DNs here for Personal Address Book/TabSync
	fkenduser
	fkpersonaladdressbook	Phone Number must be associated with Address Book
	personalfastdialindex
	phonenumber
	pkid	Unique ID to identify a record.
	tkpersonalphonenumber
phonebutton		Individual button specification for a phone button template
	buttonnum
	fkphonetemplate
	isfixedfeature
	label
	paramn1	optional parameter is feature dependant
	paramn2	Cannot change fixed feature button
	paramt1	Cannot change fixed feature button
	paramt2	Cannot change fixed feature button
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	tkfeature	was Program using TypeButton
	tkreset	Set by DeviceReset stored procedure.
phonetemplate		Name and description for button templates downloaded to phone devices and addon modules
	name	Unique name to identify the phone button template.
	numofbuttons
	pkid	Unique ID to identify a record.
	privatetemplate	Template private to that particular device
	resettoggle	Should this device or group be reset
	tkdeviceprotocol
	tkmodel	Phone model associated with phone template
	tkreset	Set by DeviceReset stored procedure.
	usermodifiable
	versionstamp	New guid plus seconds past midnight 1970 are concatenated
physicallocation		Used for DeviceMobility
	description
	name
	pkid	Unique ID to identify a record.
pickupgroup		Used for PickupGroup
	calledinfoenabled
	callinginfoenabled
	fknumplan_pickup
	name
	pickupnotificationtimer	seconds
	pkid	Unique ID to identify a record.
	tkpickupnotification
pickupgroupendusermap		CUBA: Table to map pickup group to enduser on Cuba platform
	fkenduser	Reference to Enduser
	fkpickupgroup	Reference to pickupgroup
	pkid	Unique identifier for the record
pickupgrouplinemap		Used for PickupGroup
	fknumplan_line
	fkpickupgroup
	pkid	Unique ID to identify a record.
pickupgroupmember		Used for PickupGroup
	fkpickupgroup_member
	fkpickupgroup_primary
	pkid	Unique ID to identify a record.
	priority
pickupgroupprocessnodemapdynamic		For registering CTI pickup group call alert
	alertnotificationenabled	Updated by CTI at run time
	datetimestamp	Time stamp
	fkpickupgroup	Unique in combination with fkprocessgroup
	fkprocessnode	Unique in combination with callpickup group
	pkid	Unique ID to identify a record.
plmvoucherdetails		The information stored in this table will be used for authentication while sending rest api request to Create OTP.
	elmcertificate	This is to store the ELM certificate.
	intermediatecertificate	This is to store the Intermediate certificate for satellite deployment model of CSSM. Regular Expression to validate: ^[a-zA-Z0-9!#$%&'()*+,./:;<=>?@_\r\n\s-]{0,8000}$.
	pkid	Unique ID to identify a record.
	vouchercode	This is the Voucher code of the ELM certificate
	vouchersignature	This is the Voucher signature.
plugin		List of menu items to plug into/show on the Web Admin.
	customurl
	description
	name	Plugin name
	pkid	Unique ID to identify a record.
	showonuseroption	This field is not editable.
	tkpluginusage
	url
pnpselectedlanguage		Self Provisioning IVR Plug and Play Selected Language
	pkid	Unique ID to identify a record.
	priority	Priority of the selected language.
	tkuserlocale	Enum of the typeuserlocale table for the language selected.
preferences		UI Preferences
	fkenduser
	name
	pkid	Unique ID to identify a record.
	value
processconfig		All service configuration. Attributes of a process on a node.
	fkprocessnode
	paramname
	paramvalue	if tParam is boolean, use "T" or "F"
	pkid	Unique ID to identify a record.
	primarydata	Flag to show if should be on main part of setup screen (true) or advanced section of screen (false)
	resettoggle	Should this device or group be reset
	tkparam
	tkreset	Set by DeviceReset stored procedure.
	tkservice
	versionstamp	New guid plus seconds past midnight 1970 are concatenated
processconfigdefaults		Default service configuration parameters for each service type.
	enum	Used for primary key so can be replicated by SQL
	maxlongvalue
	minlongvalue
	paramname
	paramvalue
	primarydata	Flag to show if should be on main part of setup screen (true) or advanced section of screen (false)
	servicewide	is this parameter service wide?
	tkparam
	tkservice
	typetablelink	Name of related type table
processnode		All machines running Cisco process in the cluster. The "Enterprise Node" is identified by the pkid of '00000000-1111-0000-0000-000000000000'. This is a special record used to record enterprise parameters in ProcessConfig.
	description	Description of the server.
	fklbmhubgroup	Unique ID of the Location Bandwidth Manager Hub Group.LBM Hub Node should not have Hub Group association
	ipv6name	Allow IPv6 address or hostname. Should be IPv6 format or name.
	isactive	When this record is installed by an installation, this is set to true. When it is preconfigured by the admin, it can be set to false so warnings are not sent about failed replication.
	mac	This is the media access control (MAC) address of the network interface card (NIC) in the Cisco CallManager server. The MAC address specifies the permanent hardware address of the NIC.
	name	Primary host name of a machine. If your network uses DNS services, you can enter the host name of the Cisco CallManager server. Otherwise, you must enter the full IP address of the server.
	nodeid	Integer vaeue for node
	pkid	Unique ID to identify a record.
	systemnode
	tknodeusage	Indicates a node is a Pub or a Sub
	tkprocessnoderole	Identifies the Role of the Server in the cluster (Voice or Presence)
	tkssomode	Field used in the ProcessNode table to indicate current Single Sign On mode.
processnodeaudit		Defines the Audit settings for each node
	auditfiletraceflag	Audit File Trace is Enabled
	auditmaxfilesize	Maximum Audit Log File Size
	auditnumfiles	Number of Audit Log Files
	auditnumlines	Number of Lines per Audit Log
	auditnumminutes	Number of Minutes per Audit Log
	audittracelevel	Audit Trace Level
	enableauditlog	Audit Log is Enabled
	enabledetailedauditlog	Enabling Detailed Audit Logging Level
	enableidsaudit	Informix Dynamic Server (IDS) Audit is Enabled
	enablelogrotation	Audit Log Rotation is Enabled
	enablepurging	Audit Log Purging is Enabled
	fkprocessnode	Refer to the Server to which the Audit settings are applied.
	idsauditlogrotateenabled	If set to true , enable log rotation of IDS Audit logs, provided IDS logs are enabled
	idsdeletenumauditfiles	Number of IDS Audit Log Files To Be Deleted
	idsmaxnumauditfiles	Maximum Number of IDS Audit Log Files
	overflowwarningthreshold	Overflow warning threshold value is set
	pkid	Unique ID to identify a record
	remotesyslogservername	The remote sysLog server name used for sending out Audit Events.
	tkalarmseverity_remotesyslog	The audit event severity for remote syslog.
	tkidsauditlevel	Indicates the Informix Dynamic Server (IDS) Audit Level - Schema, Admin, Updates and Reads
processnoderoleservicemap		Maps Services to the different server roles (voice, presence) in a cluster. A Service (from TypeService) may run on one or more types of servers.
	enum	A number to identify the map record
	tkprocessnoderole	Reference to the Role of the ProcessNode
	tkservice	Reference to the Service type
processnodesec		security information for processonde
	cert	certificate of the server.
	fkprocessnode	associated processnode for security
	hostname	Primary host name of a machine. If your network uses DNS services, you can enter the host name of the Cisco CallManager server.
	ip	IP address of the server.
	pkid	Unique ID to identify a record.
	sftpkey	certificate of the server.
processnodesecack		node acknolegement security information for processonde
	fkprocessnode	associated processnode to receive acknowledgement
	fkprocessnodesec	associated processnode with new certificate
	pkid	Unique ID to identify a record.
processnodeservice		Used to identify which services are installed on a particular node and various trace configurations. Trigger will insert all services when ProcessNode record is inserted.
	devicenamemonitorflag	Trace configuartion option
	devicetypemonitorflag	Trace configuartion option
	enable	Trace configuartion option
	filetraceflag	Trace configuartion option. This enables sending the output of the trace to a log file. Each Cisco CallManager service includes a default log file.
	fkprocessnode
	includenondevicetraces	Trace configuartion option
	isactive	Set by Serviceability to show if a service is activate or not.
	maxfilesize	Created during installation.
	numfiles	Trace configuartion option. Total number of trace files for a given service. Cisco CallManager automatically appends a sequence number to the file name to indicate which file it is; for example, ccm299.txt. When the last file in the sequence is full, the trace data begins writing over the first file.
	numlines	Trace configuartion option. Maximum number of lines of data stored in each trace file.
	numminutes	Trace configuartion option
	outputdebugstringflag	Trace configuartion option
	pkid	Unique ID to identify a record.
	priority	if servcie is of restricted type, priority oder of box (primary secandary)
	restrictserver	When set, service can not be de-activated
	servername	Trace configuartion option
	tkservice
	tracedrive	For Windows only, the drive letter for trace file location.
	tracelevel	Trace configuartion option. This specifies the level of information to be traced. Levels range from error to detailed.
	usercategories	Trace configuartion option
	usexml	Trace configuartion option. This specifies whether to format the output of the trace in XML format. Trace Analysis requires XML format. Cisco CallManager, CTIManager, and Cisco TFTP services support this setting.
productcapabilities		List of allowed values for various attributes (defined in TypeProductConfig) for a product. This is a subset of allowed values for the attribute.
	enum	Used for primary key so can be replicated by SQL
	enumvalue	A number to identify the record
	moniker	A sort name to identify the record
	tkproduct
	tkproductconfig
productsupportsfeature		the product/feature, model/feature map
	enum	A number to identify the record
	param
	tkdeviceprotocol	Pkid of Device Protocol record
	tkmodel
	tkproduct
	tksupportsfeature
provider		CUBA: This table will use to store all the information related to Provider, provider is the concept to render the UI pages dynamically
	displayname	Display Name for provider
	ikprovider_base	will store the information about the base provider of the given provider
	jsondata	store json data for provider
	name	Name for the Provider
	pkid	Unique identifier for provider record
	tkconnection	information about the type of connection
	tkprovider	Store the type of provider
	versionnumber	This will store the version number of the provider
recordingdynamic		Frequently updated settings for the Recording Feature
	datetimestamp
	fkdevicenumplanmap
	pkid	Unique ID to identify a record.
	tkrecordingflag
recordingprofile		Frequently updated settings for Monitor and Record
	fkcallingsearchspace_callrecording
	name	Unique name to identify a profile
	pkid	Unique ID to identify a record.
	recorderdestination	Recorder URL or DN
refreshtokendetails		Table to store the refresh token details when UCM is acting as the Authorization Server for users
	clientid	ClientID of the client used by the user
	pkid	Unique ID to identify a record.
	refreshtokenindex	SHA256 sum of the refresh token generated for a client by CUCM/IMP.
	state	State (Random Number) associated with the client.
	tkrefreshtoken	Type of refresh token, either user or device.
	userid	Username
	validity	The lifetime in seconds of the refresh token.
region		Region endpoint for IP network spans
	name	A Unique name for the region.
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	tkreset	Set by DeviceReset stored procedure.
regionmatrix		Directonal bandwidth available between regions
	audiobandwidth	Value determined by Region.audioBandwidth
	fkcodeclist	Unique ID of the Codec List. Identifies the Codec to be a Lossy or Low-Loss Codec.
	fkregion_a	Trigger inserts records and sets field when Region record instered.
	fkregion_b	Trigger inserts records and sets field when Region record instered.
	immersivebandwidth	Specifies the maximum total bit rate (in kbps) for each immersive video call between a particular region and another region (Interregion). 0 indicates no immersive video call allowed, -1 indicates no immersive video call allowed, -2 indicates use system default, like the Default Intraregion Max Immersive Video Call Bit Rate (Includes Audio), or Default Interregion Max Immersive Video Call Bit Rate (Includes Audio)
	pkid	Unique ID to identify a record.
	videobandwidth	Value determined by Region.videoBandwidth
registrationdynamic		Table for tracking last known IP and last known Unified Communications Manager phone registered with.
	datetimestamp	Time value for last change (for replication conflict resolution).
	fkdevice	Foreign key to Device table.
	lastactive	Denotes the last active time of the phone
	lastknownconfigversion	New guid is generated every time this gateway is updated
	lastknownipaddress	Last known ip address of phone
	lastknownipv6address	IPV6 address of the Registration dynamic.
	lastknownucm	Last known Unified Communications Manager this phone registered to.
	lastseen	Denotes When was the last time the device reported its location, or the device registered.
	locationdetails	Location
	pkid	Unique ID to identify a record
	portorssid	The port on the Ethernet Switches on which the endpoint is connected to or the SSID a wireless device is using
	tkendpointconnection	Type of Connection between the endpoint and its upstream neighbor infrastructure device
	tkrisstatus	Device Registration Status
remotecatalogkey		Non-RI-Constrained Map between RemoteRoutingPattern and RemoteClusterURICatalog. Delete flag used when RemoteClusterURICatalog with referenced PeerID is removed.
	isdeleted	When true, the associated Pattern Catalog has been deleted but all dependent RemoteRoutingPatterns are not yet scrubbed.
	pkid	Bloated, wasteful surrogate PK as big as the real key which follows.
	remotecatalogkey_id	Finally, a reasonable sized key. Generated for use from RemoteRoutingPattern to reference associated Pattern Catalog of a Remote Cluster.
	remoteclusteruricatalog_peerid	The real PK related 1 to 1 with PeerID column from RemoteClusterURICatalog.
remotecluster		Define remote clusters under the enterprise
	clusterid	Cluster ID
	description	Description of the Time Period, up to 128 characters including Unicode
	fullyqualifiedname	FQ hostname or IP address of the remote cluster
	pkid	Unique ID to identify a record.
	version
remoteclusterilshostinfo		Remote cluster hosts discovered by ILS
	fkremoteclusterilsstatus	Foreign key to RemoteClusterILSStatus table.
	hostname
	ipaddress	IP address of the host
	pkid	Unique ID to identify a record.
remoteclusterilsstatus		Tracks information about clusters discovered by ILS
	fkremotecluster	Foreign key to RemoteCluster table.
	hubpeerid	Identifier of the hub for this cluster on the ILS network
	lastcontacttime	Time of last successful contact to replication peer.
	peerid	Identifier of this cluster on the ILS network
	pkid	Unique ID to identify a record.
	replicationset	Identifier for the remote cluster's current replication set
remoteclusterservicemapdynamic		remote cluster is added to the Cluster table .
	datetimestamp	Time stamp
	enabled	Controlled by local Admin EMApp must check to allow/deny EMLogin
	fkremotecluster	Link to RemoteCluster table
	isclustersecure	This field is used to indicate whether offcluster is secure or not
	isremoteactivated	Indicates if the service is activated in the remote cluster
	overrideserviceaddress	This will determine if the address configuration obtained from the remote cluster can be manually overridden
	pkid	Unique ID to identify a record.
	remoteipaddr1	IP Address for remote cluster service
	remoteipaddr2	IP Address for remote cluster service
	remoteipaddr3	IP Address for remote cluster service
	remoteport	Remote Port number
	remotetrunkpkid	SIP Trunk PKID in visiting cluster.
	tkinterclusterservice	Inter Cluster Service Type
remoteclusteruricatalog		URI catalogs published by other clusters
	catalogsyncsetinstance	ensure that the source and destination agree that the set of syncd patterns associated with a catalog are complete and consistent with the current view of the source
	fkremotecluster	Foreign key to RemoteCluster table.
	lastdatareceivedtime	Time of new data received.
	name	Catalog name.
	peerid	UNIQUE Identifier of the corresponding cluster or URI catalog on the ILS network
	pkid	Unique ID to identify a record.
	routestring	Route string.
	tkilssyncstatus	Specifies the status of the last contact to the replication peer.
remotecommoninfo		Stores Remote Common Info.
	pkid	Unique ID to identify a record.
	remotekey	Remote Numplan Key
	remotepeerid	Remote Numplan Key
	usn	Update sequence number for the object referenced by pkid.
remotedestination		Mobility settings for Dual-Mode and Single Number Reach devices
	fkdevice_ctird	CTI RD device associated with the Remote Destination. This field can only refer to the pkid of a CTI RD type device
	fkdevice_dualmode	Device to which these settings apply (must be a Remote Destination device)
	fkdevice_mobilesmartclient	Mobile Smart Client associated with the Remote Destination or Dual-mode phone
	fkdevice_remotedestinationtemplate	Remote Destination Template
	fkdevice_sipline	Device to which these settings apply (must be a SIP line device that supports send call to mobile)
	fkmobilityprofile	Mobility Profile associated to a remote destination device
	fktodaccess	References the Time of Day Access list settings for this Remote Destination.
	name	User defined description for Remote Destination (e.g., My Cell Phone)
	pkid	Unique ID to identify a record.
	tktimezone	Local Time Zone of the Remote Destination.
	tkvmavoidancepolicy	Defines the type of voice mail avoidance policy used by CallManager to determine whether a call extended to remote destination is received by a real mobile user or by a mobile voice mail. Valid policy types include : 0 - Use System Default, 1 - Timer Control, 2 - User Control.
	tkvmavoidancepolicy_dvor	Defines the type of Dial via Office Reverse (DVOR) voice mail avoidance policy used by CallManager to determine whether a call extended to remote destination is received by a real mobile user or by a mobile voice mail. Valid policy types include : 0 - Use System Default, 1 - Timer Control, 2 - User Control.
remotedestinationdynamic		Used to set Enable Single Number Reach from IVR
	answertoolatetimer	in milliseconds
	answertoosoontimer	in milliseconds
	datetimestamp	Time value for last change (for replication conflict resolution)
	delaybeforeringingcell	in milliseconds
	destination	Raw Cellular Number (must be unique)
	enablesinglenumberreach	Indicates whether or not a Remote Destination is active for Mobility (SNR) feature
	fkremotedestination
	ismobilephone	Indicates a remote destination is a mobile phone
	ispreferredrd	This field is applicable to only CTI RD. It Indicates a preferred remote destination to be used by the CTI app when no RD is specified. Only one row per associated CTI RD can be true.
	pkid	Unique ID to identify a record.
	transactionid	TransactionID added specifically for CTI applications, to track the notifications for RD. This field will have a value only when an RD is set as active.
remotedestinationhistorydynamic		Holds last 5 distinct number selections for the Reach Me Anywhere
	datetimestamp	Time value for last change
	destination	Raw Cellular Number
	fkenduser_mobility	End User that owns Dual-Mode, SNR Device, or deskphone with Mobility button (for Cell Pickup).Cascade delete is omitted intentionally due to CUBA table rules to avoid autogenerated cascade delete rule addition to enterprise end user rules.
	pkid	unique id to identify record
remotedestinationusagemodelmap		Association of TypeModel records with a TypeRemoteDestinationUsage
	enum	Unique identifier
	tkmodel	Foreign key reference to TypeModel for this association.
	tkremotedestinationusage	Foreign key reference to TypeRemoteDestinationUsage for this association.
remotenumplan		Stores Remote Numplan Info.
	fkremotecommoninfo	Reference
	number
	pkid	Unique ID to identify a record.
	tag	Tag
remoteobjectblockrule		Specifies attributes of objects replicated into the cluster that should be blocked
	clusterid	Cluster ID to which the rule applies
	description
	pattern	Numeric pattern to which the rule applies
	pkid	Unique ID to identify a record.
	prefix	Prefix of learned number to which the rule applies
	tkglobalnumber	Type of global number to which the rule applies.
remoteobjectpartitionrule		Specifies criteria used to match to objects replicated into the cluster from remote clusters and action to take when a match is found.
	fkroutepartition	The partition into which the remote object should be placed if this rule matches.
	isurgentfixedlen	Treat fixed-length patterns matching this rule as urgent.
	isurgentvariablelen	Treat variable-length patterns matching this rule as urgent.
	pkid	Unique ID to identify a record.
	tkglobalnumber	Type of global number to which the rule applies.
	tkpatternusage	Pattern usage matching tkGlobalNumber and tkRemoteObject
	tkremoteobject	Type of remote object to which the rule applies.
remoteroutingpattern		Stores Reported Patterns, (URIs and Numbers), from Remote Clusters to support Local ILS Feature.
	pattern	Number or URI pattern shared from Remote Cluster Peer.
	pkid	Unique ID to identify a record.
	remotecatalogkey_id	Integer fk ref to RemoteCatalogKey record associated with this pattern. The RemoteCatalogKey record contains a PeerID key to the RemoteClusterURICatalog record defining the Catalog and associated Routing Info.
	remotekey	GUID provided by Remote Host Cluster for use as pattern, (remote numplan), reference key. (9.x does not use so NULL and Pattern is used as identity.)
	tkpatternhandlingflaginfo	Indicates how DA / CP / Routing should use the pattern in this record.
	tkpatternusage	Indicates what kind of pattern / number / uri the record contains. (Default of 28 = ILS Learned URI)
	usn	Sequence Number for use in tracking object version when synchronizing updates.
remotesyslog		Remote Syslog Table
	enable	Apply to All Services Per Server when Enabled for Application Messages
	fkprocessnode	Specifies ProcessNode
	pkid	Unique ID to identify a record.
	tkalarmseverity	Indicates the AlarmSeverity Level - ALARM_SEVERITY_*; Emergency, Alert, Critical, Error, Warning, Notice, Informational and Debug
	tksyslogmessage	Indicates the Syslog Message Level - SYSLOG_MESSAGE_* ; Security, System and Application
remotesyslogappservermap		A mapping table to map AppServer and RemoteSyslog
	fkappserver
	fkremotesyslog
	pkid	Unique ID to identify a record.
remoteuri		Stores Remote URI Info.
	fkremotecommoninfo	Reference
	pkid	Unique ID to identify a record.
	uri
replicationdynamic		Realtime replication counter
	datetimestamp
	fkprocessnode
	pkid	Unique ID to identify a record.
	replicationsetuptime	Time value indicating last change in replication status
	tkreplicationstatus	Status of replication setup (or repair) on the referenced node
resourceprioritydefaultnamespace		The Default Resource Priority Namespace for the system. One record only and must contain a Namespace if any are defined
	fkresourceprioritynamespace	The Default Namespace for the system. If Namespaces are defined, then the default cannot be null
	pkid	Unique ID to identify a record.
resourceprioritynamespace		Defines a Resource Priority Namespace
	description	Description for Resource Priority Namespace.
	name	Unique (case sensitive) identifier for a namespace
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	tkreset	Set by DeviceReset stored procedure.
resourceprioritynamespacelist		Defines a List of Resource Priority Namespaces
	description
	name	Unique (case sensitive) identifier for a namespace list
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	tkreset	Set by DeviceReset stored procedure.
resourceprioritynamespacemap		Maps Resource Priority Namespaces to Resource Priority Namespace Lists (many-to-many)
	fkresourceprioritynamespace
	fkresourceprioritynamespacelist
	index	Indicates relative priority of a namespace in the list. DO NOT use as an index as the values may not be sequential
	pkid	Unique ID to identify a record.
routefilter		Route filter clauses for NumPlan records used by digit analysis
	clause	Trigger updated. Colon separated list.
	dialplanwizardgenid	This record created by DialPlanWizard
	fkdialplan	Dial plan; for example, North American Numbering Plan.
	name	Unique name for Route Filter
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	tkreset	Set by DeviceReset stored procedure.
routefiltercosroutingmap		CUBA: Table to store the mapping between routefilter and COSRouting
	fkroutefilter	Reference to the routefilter.
	pkid	Unique identifier for the record
	tkcosrouting	reference to cosrouting
routefiltermember		Used to create RouteFilter for NumPlan records used by digit analysis
	digits
	fkdialplantag
	fkroutefilter
	pkid	Unique ID to identify a record.
	precedence	There is no requirement for this index to be sequential nor to begin with a particular value in a Route Filter.
	tkoperator
routegroup		Dial Plan Route Groups
	description	Description for Route Group.
	dialplanwizardgenid	This record created by DialPlanWizard
	islocalroutegroup	If this is a Local Route Group
	name	Unique name for Route Group
	pkid	Unique ID to identify a record.
	tkdistributealgorithm	Distribution algorithm for a route group. It could be Top Down, Circular (default) or Longest Idle Time.
	tkqsig	default is invalid until updated.
routegroupdevicemap		Maps multiple Devices to be in a Route Group.
	deviceselectionorder	This ordering within the route group does not have to be sequential. There can be gaps.
	dialplanwizardgenid	This record created by DialPlanWizard
	fkdevice
	fkroutegroup
	pkid	Unique ID to identify a record.
	port	Port 0 means all ports of the fkDevice.
routelist		Dial Plan Route Lists used by Route Groups and Line Groups. A bettern name for this table would be DeviceRouteLineGroupMap, since these records are a many-to-many relationship between device recordes that are of model Route List and Route/Line groups.
	calledpartytransformationmask	A transform
	callingpartyprefixdigits	A transform - similar to PrefixDigitsOut
	callingpartytransformationmask	A transform
	dialplanwizardgenid	This record created by DialPlanWizard
	fkcallingsearchspace	CallingSearchSpace is required only for Route Group
	fkdevice
	fkdigitdiscardinstruction	A transform
	fklinegroup
	fkroutegroup
	pkid	Unique ID to identify a record.
	prefixdigitsout	A transform
	selectionorder	There is no requirment for this index to be sequential nor for this value to start at any particular value per Route List.
	tknumberingplan_called	Values are based on TypeNumberingPlan
	tknumberingplan_calling	Values based on TypeNumberingPlan
	tkpriofnumber_called	Values are based on TypePriOfNumber
	tkpriofnumber_calling	Values based on TypePriOfNumber
	tkstatus_usefullyqualcallingpartynum	Status_useFullyQualCallingPartyNum is Default 2 only for Route Group
routepartition		Lists partitions for NumPlan
	description	A partition is a collection of numbers
	dialplanwizardgenid	This record created by DialPlanWizard
	fktimeschedule
	name
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	tkpartitionusage	Defines use of partition (Intercom or other)
	tkreset	Set by DeviceReset stored procedure.
	tktimezone
	useoriginatingdevicetimezone
rtmtprofile		Stores the Real Time Monitoring tools profile
	content	Split content of the profile
	index	Index of the split profiles starting at 1
	name	Name of the Real Time Monitor Profile
	pkid	Unique ID to identify a record.
rtmtreportingdynamic		RTMT Reporting Dynamic
	datetimestamp	Time stamp
	filenameandlocation	learnedpatterns.xml
	fkcallmanager
	pkid	Unique ID to identify a record.
	replyreadyid	Timestamp
	requestid	Timestamp
	tkrtmtreportingservice
	tktaskstatus
safccdpurgeblocklearnedroutes		SAF CCD Purge Block Learned Routes
	callcontrolidentity	Call Control Identity
	ipaddress	IP Address for the SAF Forwarder
	learnedpattern	Learned Pattern to blok
	learnedpatternprefix	Learned Pattern Prefix to block
	pkid	Unique ID to identify a record.
safclientcmnodemap		Map for SAFClientSettings and ProcessNode
	fkcallmanager
	fksafclientsettings
	pkid	Unique ID to identify a record.
safclientsettings		SAF Forwarder Settings
	clientlabel	Protocol specific Client label
	description	Description is up to 128 characters including Unicode
	enabletcplayermonitor
	fksafsecurityprofile	pkid of SAF Security Profile
	ipaddress	IP Address for the SAF Forwarder
	name	name of the SAf Client Settings
	pkid	Unique ID to identify a record.
	port	Port number to connect to the SAF forwarder
	safnotificationswindowsize	SAF notifications flow-control window size
	safreconnectinterval	In Seconds
safsecurityprofile		SAF Security Profile
	description	Description is up to 128 characters including Unicode
	name	name of the CCD Security Profile
	pkid	Unique ID to identify a record.
	tkdevicesecuritymode
	username
	userpassword	Used for digest authentication
safservices		SAF Services
	description	Description of the SAF Service, up to 128 characters including Unicode
	isactivated	Indicates as to whether the Service is Activated or not
	name	name of the CCD Service Profile
	pkid	Unique ID to identify a record.
	tksafservice
safservicetrunkmap		Map for SAF Service and Trunk device
	fkdevice
	fksafservices
	pkid	Unique ID to identify a record.
schapplication		Contains a single record which consolidates all of the Smart Call Home feature's general application configuration information for the assocoated Cluster.
	enableanonymouscallhome	Enable Anonymous call home
	enablereminder
	enablesmartcallhome	EnableSmartCallHome Application
	fkschuserclusterinfo	Refers to the Cluster user information for the SCH Application
	httphost	Proxy IP/Hostname
	httpport	Proxy port number to comunicate
	otherrecipients
	pkid	Unique ID to identify a record.
	sendlog
	sendtociscotac	SendToCiscoTAC Enable
	sendtootherrecipients	SendToOtherRecipients Enable
	tkschciscotacdestination
schscript		Each record describes a script used by the Smart Call Home feature.
	description
	maxexecutionseconds
	name
	outputfilebasename	Unique OutputFileName
	outputpath	Path to SmartCallHome script output.
	pkid	Unique ID to identify a record.
	scriptfilename	Unique Script Name
	scriptpath	Path to SmartCallHome script when installed on CUCM.
schscriptexecution		This table is used to store schedule of the execution of scripts used by Smart Call Home feature.
	enableexecution	Enable of Execution of SCH Scripts
	fkschscript	Refers to information about SCH Scripts.
	pkid	Unique ID to identify a record.
	starttime	Time in secs
	tkdayofmonth
	tkdayofweek
schuserclusterinfo		This table consolidates into a single record cluster specific information including a globally unique cluster identifier and demographic data such as primary cluster administrative contact info and the company name. The data in this record is primarily used by the Smart Call Home application.
	clusteruniqueid	Unique Cluster ID
	companyaddress
	companyname	Company name
	contactemail	Contact Email
	contactname
	contactphone	This is the telephone number as synchronized from a corporate directory. It typically is the outbound directory number. It is used for reporting purposes and if blank, applications should rely on the directory numbersassigned to phones associated with this user.
	pkid	Unique ID to identify a record.
	priorclusteruniqueid	PriorClusterUniqueID
scratch		blob used for anything including device specific information, service parameter specification, dependancy results, etc. Some records are temporary, some need to persist.
	content
	name
	pkid	Unique ID to identify a record.
	readonly
sdpattribute		SDP attribute
	attributenamestring	SDP Attribute name
	fksdpattributelist	Reference to a specific SDP Attribute List
	pkid	Unique ID to identify a record.
	tksdpattributehandling	Type of SDP attribute handling, 0 - Property, 1 - Any Value, 2 - Any Value From List
sdpattributeallowedvalues		SDP attribute allowed values
	allowedvalue	SDP Attribute name
	fksdpattribute	Reference to a specific SDP Attribute
	pkid	Unique ID to identify a record.
sdpattributelist		SDP attribute list profile
	description	Description of SDP Attribute List
	isstandard	Indicates installed standard SDP transparency profile - cannot be modified or deleted
	name	SDP Attribute List name
	pkid	Unique ID to identify a record.
secureconfig		Read-only System Level configuration
	name	Unique name to identify the configuration property
	pkid	Unique ID to identify a record.
	value	The value for the configuration property, stored as a string
securityprofile		Different Security profiles in Call Manager
	aclallowreplace	Whether SIP header replacement allowed
	acloobsubscription	Whether OOB Subscription Allowed (Obsolete)
	acloodrefer	Whether out of dialog refer allowed
	aclpresencesubscription	Whether presence subsription allowed
	aclunsolicitednotification	Whether unsolicitated subscription allowed
	allowchargingheader	Allow transmissions of P-Charging header in SIP Messages
	applevelauth
	description	Description of the Security Profile
	digestauthall	Whether to authenicate ALL messages
	excludedigestcredflag	Exclude Digest Credentials Flag
	incomingport	Used for receiving UDP/TCP messages
	isstandard	Whether it is a standard security policy
	name	Name of the Security Profile
	noncepolicytime	Time in secs
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	serveriphostname	Specifies ServerIPHostName in either IP address or HostName format
	sipoauthflag	SIP OAuth Flag
	tftpencryptedflag	TFTP Encrypted Flag
	tkauthenticationmode
	tkdeviceprotocol
	tkdevicesecuritymode
	tkeckeysize	EC Key Size(bits) for SecurityProfile
	tkkeyorder	key Order for SecurityProfile
	tkkeysize
	tkmodel	Redundant. Use tkProduct to look up tkModel in TypeProduct table.
	tkreset	Set by DeviceReset stored procedure.
	tksecuritypolicy
	tktransport
	tktransport_out	CUMA security profile outgoing transport type can not be set.
	tkv150sdpfilter	SDP Outbound Offer Filter selection for V.150 capability handling.
	transmitsecuritystatus
	versionstamp	New guid plus seconds past midnight 1970 are concatenated
	x509subjectname	X509 Subject Name List
sipdevice		Contains data for SIP Trunk implementation
	acceptinboundrdnis	Redirecting number delivery (inbound) flag.
	acceptoutboundrdnis	Same as NumberIE field in H323Device.
	calleriddn	Override callers phone number and displays PresentationNumber on the device.
	callername	This field displays the PresentationName on the device using this SIP Trunk.
	enableqsigutf8
	fkcallingsearchspace_cntdpntransform	Calling Search Space for Connected Party Name Transformation Pattern
	fkdevice
	fksipnormalizationscript	Reference to a specific SIP Normalization script
	isanonymous	This field is used to enable or disable the Anonymous Presentation details on SIP Trunk.
	isscripttraceenabled	SIP Device script trace
	numdigits
	originatingparametervalue	For ISC Trunk: Specifies the route header parameter value that is specified to indicate that the call is originating
	outbounduriroutinginstructions	For ISC Trunk: URI for routing outbound IMS call...
	parameterlabel	For ISC Trunk: Specifies the route header parameter label that is used to identify the originating or termination calls
	pathreplacementsupport
	pkid	Unique ID to identify a record.
	preferrouteheaderdestination	SIP Trunk will use the destination specified in route header of an outgoing request when one is present, instead of using the destination(s) configured on the trunk itself.
	prefixdn	Used for Inbound Call Routing Information.
	requesturidomainname	For an ISC trunk specifies the domain part of the URI for Request URIs
	scriptparameters	SIP Device script parameters
	service	For ISC Trunk: Service name that is in the user part of the top route header of the incoming SIP request message. If left blank cucmas is used.
	sigdigits	Must be 1 if (NumDigits >= 0) AND (NumDigits <= 32), or 0 if (NumDigits = 99)
	terminatingparametervalue	For ISC Trunk: Specifies the route header parameter value that is specified to indicate that the call is terminating
	tkasn1roseoidencoding
	tkcallingpartyselection
	tkpresentationbit_callingline	Calling Party ID Presentation
	tkpresentationbit_callingname	Calling Party Name Presentation
	tkpresentationbit_connectedline	Connected Party ID Presentation
	tkpresentationbit_connectedname	Connected Party Name Presentation
	tkqsigvariant
	tksipcodec	Preferred Originating Codec (G711u, G711a, G729a, G729ab, G729b)
	tksipidentityblend	Configuration option for what information to include in connected party identity.
	tksiptrunkcalllegsecurity	Defines whether a call across a SIP Trunk is considered secure with or without TLS. Applies only to SIP Trunks where sRTP is allowed.
	tkstatus_routeclasssignalingenabled	Indicates whether Route Class Signaling is enabled on a SIP trunk
	tktrunkservice
	tktunneledprotocol
	usecalleridcallernameinurioutgoingrequest	Set to true when either CallerID or CallerName has a value for a SIP Device, either CallerId or CallerName or both will be included in the FROM URI of outgoing requests
	usedpconnectedpartytransformationcss	The Default for useDPConnectedPartyTransformationCSS is TRUE
	useorigcallingpartypresondivert	False means CLIR/CLIP setting will be picked up from Diverted party whereas True means CLIR/CLIP setting will be picked from original calling party
	useviprpublicipandport	if IsAnonymous is true, PresentationNumber(CallerIdDN) must be Null and PresentationName(CallerName) must be empty.
sipnormalizationscript		Lists all the configured SIP Normalization scripts
	description	SIP Normalization script description
	isstandard	Is it a standard SIP Normalization script record?
	luascriptsourcefilename	Name of the corresponding SIP normalization LUA script file. It should contain the full path to a text file that has the LUA script to load.
	maxluainstructionsthreshold	Threshold value for Lua script instructions
	maxmemorythreshold	Threshold value for memory usage
	name	Unique script name
	pkid	Unique ID to identify a SIP Normalization script record.
	scriptsignature	Holds the pkid of the last chunk of the sipnormalizationscript and aids in verifying integrity of chunks.
	tksipscripterrorhandling_resource	Enum value defined in TypeSIPScriptErrorHandling table. Options can be Disable Script, Reset Script and Reset Trunk
	tksipscripterrorhandling_runtime	Enum value defined in TypeSIPScriptErrorHandling table. Options can be Rollback Only, Disable Script, Reset Script and Reset Trunk
sipnormalizationscriptchunk		Holds chunks pertaining to all the SIP Normalization scripts
	chunk	A SIP Normalization script chunk
	fksipnormalizationscript	Reference to a specific SIP Normalization script
	pkid	Unique ID to identify a SIP Normalization script chunk record.
	sequence	Sequence of the chunk in a SIP Normalization script
sipprofile		SIP Profile Information
	allowixchannel	This configuration allows or rejects iX Channel
	allowmultiplecodecsinanswersdp	This configuration allows the endpoint behind trunk to handle multiple codec
	allowpresentationsharingusingbfcp	This configuration allow or reject Presentation Sharing using BFCP
	allowrrandrsbandwidthmodifier	Indicates whether CUCM can signal RR (RTCP bandwidth for Receivers) and RS (RTCP bandwidth for Senders) bandwidth modifiers.
	calleriddn	This field displays the ExternalPresentationNumber on the device.
	callername	This field displays the ExternalPresentationName on the device using this SIPProfile
	conncallbeforeplayingann	True, if inbound call should be connected before playing queuing announcement. It is applicable to Trunks only (not Phones).
	defaulttelephonyeventpayloadtype	The Telephony Event Payload Type
	delivercnfbridgeid	True -Enables support of conference bridge identifier for inter-cluster conference; False - Disables it
	description	Description of SIP Profile
	destroutestring	If true, SIP message flow on the SIP trunk will insert destination route string in SIP messages
	earlyofferforgclearenable	To enable early offer for G.clear, with default value of False
	enableanatforearlyoffercalls	Indicates whether UCM should send out early Offer with MTP with ANAT semantics having both IPv4 and IPv6 address in SDP
	enableexternalqos	When External QoS is enabled at the system level (Service Parameter), this setting applies to all devices using the SIP profile whether trunk or line. If the flag is False then no QoS is information is sent to the SDN controller for flows originating at the device. If the flag is True the SDN controller is instructed to set QoS for flows originating from that device.
	enableoutboundoptionsping	If true, SIP profile configuration to have Send OPTIONS ping enabled for default trunk service type
	enableurioutdialsupport	This configuration enable or disable the use of FQDN in outgoing call
	fallbacktolocalrsvp
	faxinvite	Determines whether Fax Invite has valid Ip and Send Receive Mode
	fkresourceprioritynamespace	Foreign key reference to ResourcePriorityNamespace
	fkresourceprioritynamespacelist	Prioritized List of Resource Priority Namespaces assigned to a SIP Trunk
	fksdpattributelist	Reference to a specific SDP Attribute list
	fksipnormalizationscript	Reference to a specific SIP Normalization script
	inactivesdprequired	Require Inactive SDP for mid-call media change
	isanonymous	This field is used to enable or disable the Anonymous External Presentation details on SIP Profile.
	isassuredsipserviceenabled	True - Enables support of Assured SIP service; False - Disables it.
	isscripttraceenabled	SIP Line script trace
	isstandard	If this is a standard SIP profile
	mlppuserauthorization	This field will be used by SIP Phone to determine whether to challenge the endpoint when an RP header with a non-routine priority is received in an INVITE. The default value is False.
	name	SIP Profile name
	optionspingintervalwhenstatusnotok	Retry interval (in seconds) for SIP trunk out of service
	optionspingintervalwhenstatusok	Retry interval (in seconds) for SIP trunk in-service or partially-in-service
	pkid	Unique ID to identify a record.
	rejectanonymousincomingcall	When RejectAnonymousIncomingCall is enabled, all anonymous incoming calls will be rejected
	rejectanonymousoutgoingcall	When RejectAnonymousOutgoingCall is enabled, all anonymous outgoing calls will be rejected
	resettoggle	Should this device or group be reset
	ringing180
	scriptparameters	SIP Profile script parameters for SIP Lines
	sendrecvsdpinmidcallinvite	If true, Mid call message flow on the SIP trunk will change allowing SDP packets to be sent or received. It can be enabled if Early Offer support for voice call is also enabled
	sipoptionspingretrycount	This parameter specifies the number of times that Cisco CallManager will re-send the OPTIONS message. Default should be 6.
	sipoptionspingtimer	This parameter specifies the maximum time, in milliseconds, that Cisco CallManager will wait to resend a OPTIONS request. If a response is not received before the time specified in this timer expires, Cisco CallManager resends the request when this timer expires. Default 500 msec
	sipretryinvite	Max number of times an INVITE request is retransmitted
	sipretrynoninvite	Max number of times a SIP message other than INVITE is retransmitted
	sipstartmediaport	Start RTP range for media
	sipstartvideoport	Start range for Video Port
	sipstopvideoport	Stop range for VideoPort
	siptimerinviteexp	in secs after which a SIP INVITE expires
	siptimerregdelta	Time in secs at which registration will occur. Used in conjuction with SIPTimerRegExpires parameter. Phone will register SIPTimerRegDelta secs before reg period ends as governed by SIPTimerRegExpires.
	siptimerregexpires	Time in secs after which reg expires
	siptimert1	Lowest value, in millisecs, of the retransmission for SIP messages
	siptimert2	Highest value, in millisecs, of the retransmission for SIP messages
	t38invite	Determines whether to use T.38 Invite over SIP for interoperability with T.38 fax transmission
	tkcalheaders	Used to specify the behavior of CAL Header
	tkcallinglineidentification	CallingLineIdentification lists available Identification presentations, 0 - Default, 1 - URI Only, 2 - P-Asserted Only
	tkcucmversioninsipheader	Set CUCM Version info in UA and server header for SIP trunk
	tkdscpvalue_audiocalls	References TypeDSCPValue, DSCP for Audio Calls
	tkdscpvalue_audioportionoftelepresencecalls	References TypeDSCPValue, DSCP for Audio Calls of TelePresence Calls
	tkdscpvalue_audioportionofvideocalls	References TypeDSCPValue, DSCP for Audio Calls of Video Calls
	tkdscpvalue_telepresencecalls	References TypeDSCPValue, DSCP for TelePresence Calls
	tkdscpvalue_videocalls	References TypeDSCPValue, DSCP for Video Calls
	tkeosuppvoicecall	Sets the Early Offer support for voice calls and video calls
	tkgclear	Indicates the G.Clear types - Disabled,Clearmode,CCD,G.nX64 and X-CCD
	tkreset	Set by DeviceReset stored procedure.
	tkrsvpoversip
	tksipbandwidthmodifier	Reference to TypeSIPBandwidthModifier for SIPProfile
	tksiprel1xxoptions	SIP Rel1XX Options can not be disabled if RSVP over SIP policy is E2E
	tksipreroute	Where to get information (device id) for rerouting SIP trunk calls
	tksipsessionrefreshmethod	Sets the configuration option for SIP method to be used for session refresh, 0 - INVITE, 1 - UPDATE
	tkstatus_handlingofreceivedoffercodecpreferences	Controls the CUCM response to the passing of an explicit preferred Codec List in the SDP Offer message. Possible values include - Ignore(0), Honor(1), Use System Default(2)
	tktelnetlevel
	tkuridisambiguationpolicy	Configuration option for how to disambiguate dial strings that could be interpreted as either DTMF or URI.
	tkuseragentserverheaderinfo	sets the config option for Standard SIP Profile to Send Unified CM Version Information as User-Agent Header and for Standard SIP Conference Bridge Profile to Pass Through Received Information as User-Agent and Server Header
	tkvideocalltrafficclass	Defines the type of video call traffic class configured for a SIP trunk device. Valid traffic class type includes, 1-Immersive, 2-Desktop and 3-Mixed video.
	tkzzdndcontrol	DND control
	tkzzdtmfdblevel	dtmf Db Level
	tkzzpreff_zzanonymouscallblock
	tkzzpreff_zzcalleridblocking
	tkzzpreff_zzcallholdringback
	tkzzpreff_zzdndcontrol
	tkzzuserinfo	user Info
	usecalleridcallernameinurioutgoingrequest	Set to true when either CallerID or CallerName has a value for a device using this SIPProfile, either CallerId or CallerName or both will be included in the FROM URI of outgoing requests
	versionstamp	New guid plus seconds past midnight 1970 are concatenated
	zzabbreviateddialuri	call Pickup URI
	zzcallforwarduri	call Pickup URI
	zzcallpickupgroupuri	call Pickup Group URI
	zzcallpickuplisturi	callPickup List URI
	zzcallpickupuri	call Pickup URI
	zzcallstats	is callStats Enabled
	zzcnfjoinenabled	is conference Join Enabled
	zzenablevad	is VAD Enabled
	zzmaxredirects
	zzmeetmeserviceuri	meet Me Service URI
	zzoffhooktofirstdigittmr
	zzredirectbyapp	is redirecatble by appliction
	zzrfc2543hold	is rfc2543 Hold Enabled
	zzsemiattendedtransfer	is semiAttended Transfer Enabled
	zzstopmediaport
	zzstuttermsgwaiting	is stutter message Waiting Enabled
	zztimerkeepaliveexpires
	zztimersubscribedelta
	zztimersubscribeexpires	if IsAnonymous is true, ExternalPresentationNumber(CallerIdDN) and ExternalPresentationName(CallerName) must be empty.
siprealm		SIP Realm (security domain) athentiction information for out going calls
	passwordreverse	Generated hash value, should not be empty
	pkid	Unique ID to identify a record.
	realm
	userid	Same as Name in ApplicationUser.
siptrunkdestination		To store the destination details of a SIP trunk
	address	IPV4 address or host name for this Destination instance of the corresponding SIP Device
	addressipv6	IPV6 address or host name for this Destination instance of the corresponding SIP Device.
	fksipdevice	Points to the corresponding SIP Device record to which the Destination Address relates.
	pkid	Unique ID to identify a SIP Trunk Destination record.
	port	IP Service Port Number associated with the address for this Destination instance of the corresponding SIP Device. A port id of 0 indicates that the corresponding address is an SRV address and that actual target selection is performed by DNS.
	sortorder	Numeric value used to control selection logic associated with choosing the next SIPTrunkDestination address for a given logical SIP Trunk Destination. This value should be unique among the set of all destination addresses associated with a given SIP Trunk record.
site		CUBA: To store the information related to every site in an enterprise. The information to be stored includes the site type (Central, Teleworkers or Branch), area code, if the site has access to gateway etc
	allowemercos	Identify emergency calls are allowed from this site
	allowremotegwconnection	Identify whether this location is access to gw
	areacodes	area code for physical location
	centralsiteaudioallocation	Percent of Audio allocation for site
	emergencyservicenumbers	comma delimited list of emergency service numbers
	enableintersitevideo	Boolean flag to control whether or not video is enabled between this site and others. (Except for Teleworkers, Video is always enabled between phones within the same site.)
	fkcallingsearchspace	reference to callingsearchspace
	fkdevicepool	reference to device pool
	localmobileaccesscodes	This is to store local mobile access codes associated with a site
	pkid	unique id to identify record
	spadialplanstring	Dialplan for SPA8800 GW
	tkbandwidth_intersite	Reference to Typebandwidth for intersite
	tkcosrouting_max	Identify what kind of routing allowed for location
	tkgatewayusage	reference to typegatewayusage
	tkpipesize	Reference to TypePipeSize for site
	tksite	reference to typesite
siteroutepartitionmember		CUBA: To store the mapping information between a Site, Route Partition and Classes of Service associated with that partition
	fkroutepartition	refference to routepartition
	fksite	Reference to site
	pkid	Unique identifier for the record
	tkcosrouting	reference to typecosrouting
slminfo		Table to store response coming from CSSM through Smart agent API calls will be stored here. The APIs are invoked via GUI or CLI
	authorizationexpires	Date and time at which the product license authorization will expire. Product license authorization must be renewed before this date.
	authorizationfailedreason	Reason for authorization attempt failure.
	daysleft	Number of days left in evaluation mode.
	enableslr	true indicates specific license reservation [SLR] is enabled.
	evaluationexpiredtime	Date and time at which product evaluation period expired.
	exportcontrolledallow	false indicates cannot turn on encryption
	fkslmserver	Association to SLMServer table.
	isauthorizationfailed	Ture if product license authorization attempt has failed.
	isregistrationfailed	Ture if product license registration attempt has failed.
	lastauthattempt	Date and time of last renewal attempt for the product license authorization.
	lastrenewalattempt	Date and time of last renewal attempt for the product license registration.
	nextauthattempt	Date and time of next renewal attempt for the product license authorization.
	nextrenewalattempt	Date and time of next renewal attempt for the product license registration.
	pkid	Unique ID to identify a record.
	registrationexpires	Date and time at which the product license registration will expire. Product license registration must be renewed before this date
	registrationfailedreason	Reason for registration attempt failure.
	reservationrequested	Date and time at which the license reservation was requested.
	smartaccountname	Smart account name.
	tkcssmauthstatus	Authorization status id of CUCM with CSSM or satellite.
	tkcssmregstatus	Registration status id of CUCM with CSSM or satellite.
	virtualaccountname	Virtual account name.
slmserver		Table to store CUCM specific information which is required to be sent to CSSM, these are predefined. Inputs provided to CUCM will also be stored in this table
	deploymentmode	Deployment mode of the product.
	isprivacyenabled	If false then hostname or ip are sent to CSSM
	isprovisionallowed	If true then allow the provision of users and devices, otherwise not
	nodeid	Node id.
	overagedays	OverageDays are the no. of days Customer can use CUCM after Out Of Compliance
	overagedaysupdatedtime	Time stamp when overage days column is updated
	pkid	Unique ID to identify a record.
	productinstancename	Host name of the node during registration with CSSM
	proxyhostnameorip	Intermediate HTTP/HTTPS proxy Host name or IP address
	proxyport	Intermediate HTTP/HTTPS proxy port address
	serialnum	Serial number to identify the product.
	tkbe6000starterbundle	Status id of BE6k Starter Bundle.
	tkslmtransport	Status id of SLM Transport Type used to communicate with CSSM or satellite.
	transportgatewayurl	Smart Software Manager satellite URL
	transporturl	Cisco Smart Software Manager transport URL.
	uuid	Unique id created during install.
slmstatus		Table to store license authorization status coming from CSSM through Smart agent API.
	pkid	Unique ID to identify a record.
	tkcssmenforcemode	Enforce mode id for each license type
	tkslmfeature	References TypeSLMFeature table which has details about license types
softkeyset		Map the sofykey to softkey template based on different call states
	fksoftkeytemplate	The softkey template associated with the softkey set
	pkid	Unique ID to identify a record.
	positionid
	tkcallstate	what call state does the softkey set belong to
	tksoftkey	the softkey associated with the softkey set
softkeytemplate		Softkey templates
	description
	iksoftkeytemplate_base	the original softkey template on which the current template is based; if this is a standard template the value will be the same its pkid; a standard template cannot be modified
	name
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	softkeyclause	This clause contains all the softkeys used by the softkey template, and the softkey is separated by ":" and sorted by eventID.
	softkeysetclause	This clause contains the information for softkey sets used by the softkey template
	tkreset	Set by DeviceReset stored procedure.
	versionstamp	New guid is generated every time this softkeytemplate is updated
softkeytemplatedefault		Used to define a Default SoftkeyTemplate as the entry removed from DevicePool table
	fksoftkeytemplate
	pkid	Unique ID to identify a record.
softkeytemplateservicemap		Many to many relationship between services with softkeys and softkey templates
	fksoftkeytemplate
	pkid	Unique ID to identify a record.
	tkservice
speeddial		Speed dial entries for phone Devices
	fkdevice
	fkpersonalphonebook	Associates a contact phone number from the personal address book of an end user to a speed dial button
	label	The text that appears for the speed-dial button (allows Unicode).
	labelascii	A safe version of the Speed Dial Button Label using only English letters (a to Z) and punctuation.
	pkid	Unique ID to identify a record.
	speeddialindex	This field identifies the speed-dial button on the phone (for example, 1, 2, 3, or 4).
	speeddialnumber	This is the number that the system dials when the user presses the speed-dial button.
spokenname		Spoken name data as in CRSApplication
	creationdatetime	Timestamp to mark spoken name sequence members
	encodeddata	for table spokenname
	fkenduser	associated enduser for spokenname
	numberofsegments	Number of segments in the spoken name sequence
	pkid	Unique ID to identify a record.
	seqno	spoken name sequence number
	tkmediapayload
	versionstamp	New guid is generated every time this device is updated
srst		Survival Remote Site Telephony configuration
	certificate	Cannot change system SRST records; update new and legacy records only
	certificateproviderport	Cannot change system SRST records; update new and legacy records only
	ipaddr1	IP Address for the first device in the SRST config list. Enter the IP address of the gateway for devices in a device pool to use as an SRST reference.
	ipaddr2	IP Address for the second device in the SRST config list
	ipaddr3	IP Address for the third device in the SRST config list
	issecure	Cannot change system SRST records; update new and legacy records only
	name	Unique name
	pkid	Unique ID to identify a record.
	port1	port number for the first device in the SRST config list
	port2	port number for the second device in the SRST config list
	port3	port number for the third device in the SRST config list
	resettoggle	Should this device or group be reset
	sipipaddr1	SIP IP Address for the first device in the SRST config list. Enter the IP address of the gateway for devices in a device pool to use as an SRST reference.
	sipipaddr2	SIP IP Address for the second device in the SRST config list
	sipipaddr3	SIP IP Address for the third device in the SRST config list
	sipipv6addr	SIP IPv6 Address in the SRST Config list.
	sipport1	SIP port number for the first device in the SRST config list
	sipport2	SIP port number for the second device in the SRST config list
	sipport3	SIP port number for the third device in the SRST config list
	tkreset	Set by DeviceReset stored procedure.
	tksrstoption	Indicate what kind of SRST configuration is
	usermodifiable	Indicate whether use can modify this SRST configuration or not
stalelscdetails		Table to store the LSCs that were generated in response to an endpoint CSR but were never installed
	certhash	SHA256 hash of the LSC
	cn	The Common Name of the LSC
	issuer	The issuer of the LSC
	pkid	Unique ID to identify a record.
	serialnumber	The Serial Number of the LSC
	validfrom	The date from which the LSC is valid
	validtill	The date till which the LSC is valid
starterbundlestatus		Table to store license authorization status coming from CSSM through Smart agent API.
	pkid	Unique ID to identify a record.
	tkbe6000starterbundle	References TypeBE6000StarterBundle table which has details about BE6k starter bundle license types
	tkcssmenforcemode	Enforce mode id for each BE6k starter bundle license type
supportsfeatureattributemap		Contains the mapping between the product support feature and the actual field name in the database
	emimpact	The indicator for being overwritten during EM log in/out procedure
	fieldname	The name of the field that associated with the support feature. The field name is null implies that whole table is related with the support feature
	isbooleanfield	If true, then the field is a boolean column.
	pkid	Unique ID to identify a record.
	tablename	The name of the table the associated with supported features
	tksupportsfeature	The reference to product support features
	usedefault	The indicator for using the default model profile configuration during mismatch type login.
	useenduser	if set to true, then use the setting configured for enduser during EM login
tapssecurenumplan		Table containing the list of Secure DNs
	fknumplan	Unique ID to identify the secure DN
	pkid	Unique ID to identify a record.
tapsuserlocale		Table containing the list of supported user locales for TAPS application
	pkid	Unique ID to identify a record.
	tkuserlocale	supported user Locales
telecaster		Telecaster information not in Device Table
	authenticationurl
	directoryservicesurl1
	directoryservicesurl2
	fkdevice
	idletimeout
	idleurl
	pkid	Unique ID to identify a record.
	proxyurl
	secureauthenticationurl
	securecontactsearchurl
	securedirectoryurl
	secureidleurl
	secureinformationurl
	securemessageurl
	secureservicesurl
	voicemailurl1
	voicemailurl2
telecasterservice		High level information about a Cisco IP Phone Service that can be subscribed to.
	description
	enabled	If true the service is available for subscription, or displayed as an enterprise subscription; if false it is not shown or available
	enterprisesubscription	If true the service is shown in the service list for all devices in the cluster; if false service must be subscribed to following normal process
	name	Name of IP Phone Service (allows Unicode).
	nameascii	A safe version of the Label using only English letters (a to Z) and punctuation.
	pkid	Unique ID to identify a record.
	priority	Priority from low to high defines where in a list a Service should appear: 1 = top of list, 50 (default) = middle, 100 = bottom
	secureurltemplate
	tkphoneservice	Identifies the button (services, directories, messages) for which a service is displayed when subscribed
	tkphoneservicecategory	Identifies the button (services, directories, messages) for which a service is displayed when subscribed
	urltemplate
	vendor	Identifies the source of the service
	version	Identifies the version of the service
telecasterserviceparameter		Details about parameters on the query string for a Cisco IP Phone Service.
	defaultvalue
	description
	displayname
	fktelecasterservice
	hidden
	name
	pkid	Unique ID to identify a record.
	required
telecastersubscribedparameter		The user specified value for a query string parameter for a subscribed Telecaster Service.
	fktelecasterserviceparameter
	fktelecastersubscribedservice
	pkid	Unique ID to identify a record.
	value
telecastersubscribedservice		Releates a device to a TelecasterService
	fkdevice
	fktelecasterservice
	pkid	Unique ID to identify a record.
	priority	Priority from low to high defines where in a list a Service should appear: 1 = top of list, 50 (default) = middle, 100 = bottom
	secureserviceurl	Trigger updated. Build the complete URL/SecureURL with parameters based on TelecasterSubscribedParameter.
	servicename	Name of Subscribed IP Phone Service (allows Unicode).
	servicenameascii	A safe version of the Subscribed IP Phone Service Name using only English letters (a to Z) and punctuation.
	serviceurl	Trigger updated. Build the complete URL with parameters based on TelecasterSubscribedParameter.
	urlbuttonindex	The index for feature URL. Index 0 is for normal subscribed services. Not-0 index should be unqiue on device based.
	urllabel	The display label for URL.
	urllabelascii	A safe version of the URL Button Label using only English letters (a to Z) and punctuation.
testnotify		Test change notification
	intvalue
	name
	pkid	Unique ID to identify a record.
	stringvalue
timeperiod		List of all Time Period
	dayofmonth	EndUser TimePeriods must have the day of month and month of year to be 0
	dayofmonth_end	End of time period day
	description	Description of the Time Period, up to 128 characters including Unicode
	fkenduser	Owner of the TimePeriod. Empty by default indicating a system owned time period
	ispublished	Reserved for future use
	name
	pkid	Unique ID to identify a record.
	tkdayofweek_end
	tkdayofweek_start	EndUser TimePeriods must have the endday of the week same as the startday of the week
	tkmonthofyear
	tkmonthofyear_end	End of time period month
	tktimeofday_end
	tktimeofday_start	End time must be later than start time if either time is specified
timeschedule		List of all Time Schedules
	description	Description of the Time Schedule, up to 128 characters including Unicode
	fkenduser	Owner of the TimeSchedule. Empty by default indicating a system owned time schedule
	ispublished	Reserved for future use
	name
	pkid	Unique ID to identify a record.
	tktimeschedulecategory	Reserved for future use
timescheduletimeperiodmap		Mapping between time schedules and time
	fktimeperiod
	fktimeschedule
	pkid	Unique ID to identify a record.
todaccess		Time Of Day Access
	description	Description of the Time of Day Access list, up to 128 characters including Unicode
	fkenduser	EndUser associated with the Time of Day Access list. Write-once, cannot be changed to a different user
	name	Unique name for an EndUser ToDAccess list. (Same name can be used by different EndUsers.)
	pkid	Unique ID to identify a record.
todaccesssetting		Time Of Day Access setting (maps time schedules to ToD Access)
	fkcallerfilterlist	References the CallerFilterLlist for this ToDAccess setting. Must have same fkEndUser as the referenced ToDAccess and Time Schedule.
	fktimeschedule	References the Time Schedule for this ToDAccess setting. Must have same fkEndUser as the referenced CallerFilterList and ToDAccess.
	fktodaccess	References the ToDAccess list to which this setting belongs. Must have same fkEndUser as the referenced CallerFilterList and Time Schedule.
	pkid	Unique ID to identify a record.
treecontrolgroupnodes		Contains records to build the CCMAdmin tree control
	action
	displayorder
	expanded
	groupname
	icon
	label
	nodename
	pkid	Unique ID to identify a record.
	productmask	Bitmask of products to which this menu applies (CCM, Unity, etc.)
	target
	tkresource
	tooltip
troubleshootingtrace		Trace settings for troubleshooting page
	devicenamemonitorflag
	devicetypemonitorflag
	enable
	filetraceflag
	fkprocessnode
	includenondevicetraces
	maxfilesize
	numfiles
	numlines
	numminutes
	outputdebugstringflag
	pkid	Unique ID to identify a record.
	sdltracedataflags
	sdltraceflag
	sdltracemaxfilesize
	sdltracemaxlines
	sdltracetotalnumfiles
	sdltracetypeflags
	sdlxmlflag
	tkservice
	tracelevel
	usercategories
	usexml
typeadminboolean		Tri-state boolean values
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeadminerror		null
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeadminfieldinfo		Overrides field info entries for validation
	checkconstraint
	enum	A number to identify the record
	overunique
	propnotnull
	propnull
	tkadminboolean_isunique
	tkadminboolean_nullallowed
	validation
typeadminfieldinfomap		Maps Admin fields for validation
	enum	A number to identify the record
	label
	maxlength	Maxlength for Textbox
	property
	tkadminfieldinfo
	tkfieldinfo
	tkrelatedfieldinfo
	tkwebpageinfo
typealarmseverity		Used for AlarmConfiguration severities
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeannouncementfile		Loaded from TypeAnnouncements
	description
	enum	A number to identify the record
	filename
	ishidden
	isuserlocale
	moniker	A moniker to identify the record
	name
typeannouncements		IPVMSA apps announcements
	allowcustom
	description
	enum	A number to identify the record
	intervalvalue
	moniker	A moniker to identify the record
	name
	tkannouncementfile_1	A number to identify the typeAnnouncementFile record which is for verbal announcement followed by a repeating tone announcement.
	tkannouncementfile_2	A number to identify the typeAnnouncementFile record which is for repeating tone announcement
typeapplication		List of applications that support MLA
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
	vroot
typeapplicationdialrule		Various Dial Rules
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeappserver		Various types of App servers
	administrationurltemplate	Used to create a link to the Administrative application for the AppServer; [IPAddr] replaced by AppServer.IPAddr, [HostName] replaced by AppServer.Name
	enduserurltemplate	Used to create a link to the EndUser application for the AppServer; [IPAddr] replaced by AppServer.IPAddr, [HostName] replaced by AppServer.Name
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeappservercontent		Differentiates the contents per App server
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
	tkappserver
typeasn1roseoidencoding		For Qsig Variant
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeassignmentmode		Specifies the method by which users are dispersed among available nodes for UCM IM & Presence
	enum	Unique identifer
	moniker	A sort name to identify the record
	name	Specifies the dispersal type for IM & Presence node assignment
typeauthenticationmode		Defines the different authentication means a phone can use while authenticating itself to CAPF (Certificate Authority Proxy Function).
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeautoanswer		types of auto answer
	enum	A number to identify the record
	isintercomcompatible	Whether this enum can be used for Intercom Feature
	moniker	A sort name to identify the record
	name
typebandwidth		network bandwidth between regions
	bandwidth	This fields is added per CallProcessing request since the enum and the actual bandwidth used may not be the same.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typebarge		Types of Barge (and cBarge)
	enum	A number to identify the record
	moniker
	name
typebatfile		Used to differentiate the various types of files used by BAT
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typebatfilesubclause		Used to differentiate the various types of functions used by BAT
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typebatfrequency		Duration frequency types
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typebatfunction		Different Functions of BAT Jobs
	allowsuploading	Is the BAT CSV file uploaded for this function
	enum	A number to identify the record
	filelocation	Location of BAT CSV Files based on location
	moniker	A sort name to identify the record
	name
	tkbatfile
	tkbatfilesubclause
	tkbattarget
typebatfunctionfieldinfomap		Mapping of BAT function with Fields
	displayname	Display Name of the field in the BAT Pages
	enum	A number to identify the record
	ismandatory	Is the Field Mandatory
	tkbatfunction	Type of Input Data
	tkbatusage	Type of Input Data
	tkconfiginputdata
	tkfieldinfo	Holds the field enum
typebatjobstatus		State of BAT Job
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typebatresultstatus		Status of BAT job results
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typebattarget		Target for which BAT is performed
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typebatusage		Data usage submitted from UI
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typebe6000starterbundle		Table to store BE6k Starter Bundle details
	description	Localized string to define the purpose of the list item
	enum	A number to identify the list item
	moniker	A globally unique programmatic name to identify the list item
	name	Localized string displayed to users to identify list item
	tag	Tag for BE6k Starter Bundle
typebillingserverprotocol		billingserverprotocol (0 - SFTP,1 - FTP)
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typebitpos		Enumerates the bit positions
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeblfsdoption		Defines additional behaviors available with Busy Lamp Field (BLF) Speed Dial feature
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeboolean		used by Web Admin for text conversion of boolean values. Not actually related to any other table.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typebriprotocol		supported BRI protocols
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typecalheaders		Specifies whether the CAL Header is disabled or present in the Supported header or Require header
	enum	Unique identifer
	moniker	A sort name to identify the record
	name	Specifies the behavior of CAL Header
typecallerfiltermask		Type of mask used as filter for Caller Lists
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typecallerid		ANI vs DNIS
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typecallinglineidentification		Lists different available Identification presentation for SIP trunks. Each presentation represent a pattern in the SIP messages header.
	enum	A number to identify the record
	moniker	A sort naming pattern to identify different presentation record
	name	A sort name to identify different presentation record
typecallingpartyselection		Calling Party selection
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typecallstate		List of Call States defined by CallManager
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typecalltreatmentonfailure		For CallInterceptProfile
	enum	Unique identifier for the record
	moniker	A sort name to identify the record
	name
typecalmode		List of CAL Modes
	enum	unique identifier for TypeMode
	moniker	Moniker for mode of Confidentialaccesslevel
	name	Text display of mode of the Confidentialaccesslevel
typecarrierselectcode		CUBA: Carrier Select Code details
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typecertificate		Defines the status of the certificate
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typecertificatedistribution		The possible certificate types
	description	Description of type of certificate.
	enum	A Unique identity for certificate types
	moniker	A sort name to identify the certificate
	name	Specifies the certificate type
typecertificateoperation		Defines the different operations that are done on a certificate.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typecertificateservice		Types of certificate services
	enum	A number to identify the record
	moniker	A moniker to identify the record
	name	A name to identify the record
	usestruststore	To check the usage of Trust Store
typecertificatestatus		Defines the different status for certification operation.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typecertificateverificationlevel		Determines the type of security certificate accepted for identity verification: Any Certificate, Self-signed or Keystore, Keystore Only
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	Name of the Certificate Verification Level
typecfacssactivationpolicy		Types of Call Forward All Calling Search Space Activation Policy
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typechangenotifysubscribe		Type of AXL handlers supported
	enum	A number to identify the record.
	moniker	A sort name to identify the change notification subscription type.
	name	Name of the change notification subscription type.
typeclass		generic device type labels
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeclockreference		Internal vs. external clock reference
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typecloudservice		Type of cloud services
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typecodec		This table lists the codecs supported by the system. Each record represents a different Media ID to the system. The value is equal to the Media ID used internally by the system.
	defaultorder	Determines the default preference of Codec within a single Codec List. The Codec List will have the default preference order and would need special handling if the order needs to be changed.
	enum	A number to identify the record
	minimumbandwidth	This is the minimum bandwidth in K Bits Per Second at which the associated Codec will operate
	moniker	A sort name to identify the record
	name	A sort name to identify different presentation record
	tkmedia	Determines the type of Media.
typeconfiginputdata		Configuration Tool Meta-data
	enum	A number to identify the record
	filename
	moniker	A sort name to identify the record
	name
	priorityindex
	tkconfiginputdatagrouping	Values based on TypeConfigInputData
typeconfiginputdatagrouping		Groupings for Configuration Tool Meta-data
	enum	A number to identify the record
	index	A number to identify the order of the groupings
	moniker	A sort name to identify the record
	name
typeconnectedpbx		Type of PBX models connected to CallManager over QSIG trunk
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeconnection		CUBA: This table will contains the information about the different kind of connection supported by provider/pajaro
	enum	unique identifier for typeConnection
	moniker	Moniker for typeConnection
	name	Name for the typeConnection
	tkclass	Class type for typeConnection
	tkdeviceprotocol	DeviceProtocol type for typeConnection
	tkproduct	Product type for typeConnection
typeconnectiondevice		CUBA: This table will contains the mapping between TypeConnection and TypeCubaDevice
	enum	unique identifier for typeConnectionDevice
	tkconnection	Connection type for typeConnectionDevice
	tkcubadevice	CubaDevice type for typeConnectionDevice
typeconnectionusage		CUBA: This table contains the information about the usage type of the PSTN connection
	enum	unique identifier for TypeConnectionUsage
	moniker	Moniker for TypeConnectionUsage
	name	Name for the TypeConnectionUsage
typeconnectprotocol		Determines the protocol used for communication between UCM and other Unified Communications (UC) products
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	Name of the Connection Protocol
typecosrouting		CUBA: To store the different types of Classes Of Service.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	Name of the type of cosrouting
typecosroutingclassification		CUBA: This table will contains the further classification for the COSRouting
	enum	unique identifier for typeCOSroutingclassification
	moniker	Moniker for typeCOSroutingclassification
	name	Name for the typeCOSroutingclassification
	tkcosrouting	enum for tupeCOSrouting
typecountry		Countries for which CallManager can generate proper network tones
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typecredential		Type of Password/PIN
	enum	From CUC: 1 = Windows (not used), 2 = Domino (not used), 3 = Password, 4 = PIN
	moniker	A sort name to identify the record
	name
typecredentialuser		Types of users that have Credentials (Password/Pin) stored in database for IMS
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typecssmauthstatus		Table to store product authorization statuses with CSSM
	description	Localized string to define the purpose of the list item
	enum	A number to identify the list item
	moniker	A globally unique programmatic name to identify the list item
	name	Localized string displayed to users to identify list item
	tag	Smart Agent status codes for Authorization
typecssmenforcemode		Table to store CSSM enforcement modes
	description	Localized string to define the purpose of the list item
	enum	A number to identify the list item
	moniker	A globally unique programmatic name to identify the list item
	name	Localized string displayed to users to identify list item
	tag	Smart Agent enforce mode codes
typecssmregstatus		Table to store product registration statuses with CSSM
	description	Localized string to define the purpose of the list item
	enum	A number to identify the list item
	moniker	A globally unique programmatic name to identify the list item
	name	Localized string displayed to users to identify list item
typecsuparam		CSU parameter for PRI interface
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typecubadevice		CUBA: This table will contains the information of the different type of device provides PSTN connection in Pajaro
	enum	unique identifier for typeCubaDevice
	moniker	Moniker for typeCubaDevice
	name	Name for the typeCubaDevice
typecubaproductdisplaygroup		CUBA: Table to store display groups for endpoints on Cuba platform
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typecubasupportedcountry		CUBA: The TypeCubaSupportedCountry table stores certain country specific information and defaults for CUBA.
	accesscode	Long distance prefix that is dialed out
	carrierselectcodelength	To store length of Carrier Select Codes for the country
	countrycode	Two character country code to identify country.
	countryexitcode	Standard international dial code of the country using which international calls can exit.
	datetemplate	Template to be used to display default date template for a country. If the last character is 'A' then it is 24 hour time. If the last character is 'a', it is 12 hour time.
	defaulttimezone	Default timezone for country.
	enum	A number to identify the record
	isdcode	To store ISD codes for the country
	ise1r2enabled	Flag to show if it should allow E1 CAS R2 (true) or not (false)
	islogicalpartitioningenabled
	numplanname
	supportcarrierselectcode	Flag to show if particular country supports Carrier Select Code or not
	tkcountry	Country id from typecountry table.
	tklanguage_default	Default language for country.
typecucmversioninsipheader		Configuration type of CUCM version information to be send in SIP User-agent and Server header.
	enum	Unique identifier for TypeCUCMVersionInSipHeader.
	moniker	Moniker for TypeCUCMVersionInSipHeader.
	name	Name of Handling TypeCUCMVersionInSipHeader.
typecustomuserattribute		Table to support 5 new attributes in addition to already existing attributes in TypeLdapServerAttr
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	This field is the place holder for the CustomFieldAttributes in TypeCustomUserAtribute
typedayofmonth		Used for Time Period
	description
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typedayofweek		Used for Time Period
	displayname
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typedberrors		Database error definitions
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typedevicefeature		List of feature for a device.
	enum	A number to identify the record
	isusermodifiable
	moniker	A sort name to identify the record
	name
typedeviceprofile		Defines types of device records - device profile, real device, etc.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typedeviceprotocol		protocol used by device
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typedevicesecuritymode		Used for specifying Device Security Mode
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typedevicetrustmode		Types of Device Trust Modes
	enum	A number to identify the record
	moniker	A moniker to identify the record
	name	A name to identify the record
typedialparameter		Dial Parameter types
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typedialpattern		Dial Pattern types
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typedialviaoffice		Dial Via Office modes
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typedigitsending		DTMF, MF, PULSE
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typedistributealgorithm		The types of distribution algorithms used by different types of Groups
	enum	A number to identify the record
	mask
	moniker	A sort name to identify the record
	name
typedndoption		type of call handling while DND is enabled (0=Ringer Off, 1=Call Reject)
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typednusage		Enumerates the type of extensions for users.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typedpdeviceprotocol		Diagnostic Portal Protocols Types :Telnet(0) SSH(1) HTTPS(2) and so on .
	enum	A number to identify the record
	moniker	A short name to identify the record
	name
typedpjobfeature		Diagnostic Portal Job Feature
	enum	A number to identify the record
	moniker	A short name to identify the record
	name
typedpjobstatus		Diagnostic Portal Job Status:Scheduled(0),Running(1),Completed(2) and so on.
	enum	A number to identify the record
	moniker	A short name to identify the record
	name
typedpproduct		Diagnostic Portal Product Types :Cisco Unified Communications Manager(0) Cisco Unified Customer Voice Portal(2) and so on .
	enum	A number to identify the record
	moniker	A short name to identify the record
	name
typedptracelevel		Diagnostic Portal Generic Trace Levels:Level0 (0) Level1 (1) Level2 (2) and so on .
	enum	A number to identify the record
	moniker	A short name to identify the record
	name
typedpverificationstatus		Diagnostic Portal Verification Status:NotDone(0),Failed(1),Success(2).
	enum	A number to identify the record
	moniker	A short name to identify the record
	name
typedpwebprotocol		Diagnostic Portal Web Protocols Types: REST(0) SOAP(1) and NotApplicable(2).
	enum	A number to identify the record
	moniker	A short name to identify the record
	name
typedrfregistered		Disater recovery framework status of framewrok
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typedrfscript		Disater recovery framework type of script
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typedscpsetting		Associates the DSCP marking service parameter name with the Traffic Class Label (TCL) attribute defined in SIP SDP protocol
	dscpsettingxmltag	Identifes the XML Tag of the DSCP marking service parameters
	enum	Unique identifier
	moniker	Moniker
	name	Associates the DSCP marking UCM service parameter name with the Traffic Class Label (TCL) attribute defined in SIP SDP protocol
	tclstring	Traffic Class Label (TCL) helps to identify/classify various traffic flows in the network
typedscpvalue		Commonly used DSCP and Precedence values used in QoS class maps and policy maps.
	enum	A number to identify the list item
	moniker	A globally unique programmatic name to identify the list item
	name	Localized string displayed to users to identify list item
	sortorder	Numeric value used to control selection logic associated with choosing the next DSCP Value for a given logical DSCP Value. This value should be unique among the set of all DSCP values
typedtmfsignaling		DTMF Signaling Types
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typee911locationstate		Lists different states for e911 locations.
	enum	A number to identify the record.
	moniker	A sort name to identify the record.
	name	Name of the location state.
typee911message		This table stores the different types of messages for e911.
	enum	A number to identify the record.
	moniker	A sort name to identify the record.
	name	Name of the message type.
typeeckeysize		Table Containing EC key Size(bits) of 256, 384 and 521
	description	Description of the ECKeySize list containing 256,384 and 512 bits
	enum	A number to identify the ECKeySize list
	moniker	A globally unique programmatic name to identify the ECKeySize list item
	name	Localized string displayed to users to identify the ECKeySize list
typeencode		a-law vs. u-law
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeendpointconnection		The table describes possible endpoint connection types like CDP and LLDP (for wired devices) or SSID (for wireless devices).
	enum	A number to identify the list item.
	moniker	A globally unique programmatic name to identify the list item.
	name	Localized string displayed to users to identify list item.
typeeosuppvoicecall		Option for SIP early offer
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typefallbackcssselection		Used for specifying Fallback CSS selection type for IME Enrolled DID group
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typefallbacksensitivitylevel		Used for specifying Fallback QoS Sensitivity Level
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typefdlchannel		used for T1 and PRI
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typefeature		defines every feature that might be assigned on a button template
	allowmultiple	If true then multiple instances of the feature can appear on a phone button template. If false, only one instance of the feature is allowed. There is no hard rule to enforce this - applications should observe the setting but are allowed to temporarily have more than one instance of any feature while updating button templates
	englishlabel	The English label for a feature key, such as "Privacy".
	enum	A number to identify the record
	isemcompatible	Can the feature be configured on a Device Profile for use with Extension Mobility
	moniker	A sort name to identify the record
	name
	tag	This tag is used for localization application to look up the display text for phone
	tksoftkey	Corresponding entry in TypeSoftkey for same function
typefeatureconfig		Define Feature Configuration Types
	configfileprefix
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typefeaturecontrol		Feature Control Types
	description	Description to be used by program
	enum	A number to identify the record
	isenabledbydefault	Default policy setting for this feature (true = enabled; false = disabled)
	moniker	Unique string for programmatic use
	name	A name to identify the record
	versionstamp	New guid plus seconds past midnight 1970 are concatenated
typefieldinfo		Field information (datadictionary in database)
	checkconstraint	Text that will be used to specifiy the rules for multipble columns in a table.(must follow check SQL syntax)
	defaultvalue	Value that will be inserted for this column if no value is specified.
	dntype	If the FieldType is DN, then this is the type of DN.
	enum	Integer that enumerates column
	errormsg
	fieldname	Name of column
	fieldtype	Type of column
	iscascadedelete	True if wthe the table pointed to by the column the SQL enginge will attemt to automatically delete the record in this table
	isclustered	True if this column should be optiminal optiomize for searching (data is found at end of search)
	isindexed	True if this column should be optiomize for searching
	isunique	True if the value in this column unique for this table.
	length	Maximum number of charters in a string
	migrationsource	Textual description of where this value is created from(table and column) in previous schema.
	notmodifiable	True if can not be modified by user (only modified by install or trigger)
	nullallowed	True if this column can be NULL
	remarks
	tktableinfo	ID of table associated with column
	validation	Text that describes validation rules
typeforward		all, busy, no answer
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeframing		used for T1 and PRI
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typegatewayusage		CUBA: Table to store the different types of gateway usage for PSTN access
	description	Description of the type of Gateway Usage
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	Name of the Gateway Usage Mode
typegclear		G.Clear Types
	enum	A number to identify the record
	moniker	Name to be used by program
	name	A name to identify the record
typegeolocationdevice		Used to store Logical Partition device types
	enum	A number to identify the record
	moniker	Name to be used by program
	name	A name to identify the record
typegkoption		type of H.323 gate keeper
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeglobalnumber		Classification applied to global numbers
	enum	Unique identifier
	moniker	Moniker
	name	Text display
typeglobalsetting		A non-modifiable set of definitions for GlobalSetting table records. Each type record here defines a setting record there along with providing a data driven initialization method and other operational and descriptive information.
	defaultvalue	Free form field for storage of the default value for use in the initialization of the associated GlobalSetting record''s Value field. Used in the event that the InitializationSQL is absent
	description	ASCII description of a TypeGlobalSetting type definition record and its purpose and usage. For use by developers typically in understanding how the setting is maintained and used. Example: This global setting is used by the xxx application. Its value is set by .... It is used to .... It must be ....
	enum	Unique, numeric, surrogate primary key for unique application reference to the TypeGlobalSetting type definition record
	initializationsql	SQL statement used to produce, from the Target DB, a custom initialization value for the associated GlobalSetting record. If specified, it will be used during install or upgrade to initialize the SettingValue of a new GlobalSetting record. This allows initialization values to be based on other data in the DB rather than only hardcoded defaults. The SQL query is assumed to produce a single initialization value result. (Only the first field of the first result row will be used. If no row is present, the initialization will be to NULL.)
	moniker	Unique, alpha-numeric, application label key for unique reference to the TypeGlobalSetting type definition record and for autogeneration of defined enumerated name value pairs for program inclusion and record access
	name	Unique, alpha-numeric, user friendly label key for unique identification of a TypeGlobalSetting type definition record and, if so desired, also for use in reporting output and self documenting query joins
	rules	Stores a user oriented message describing the rules which will be applied to this setting and perhaps the restrictions related to it. It would aid the programmer in ensuring that implemented rules are correct and the user in understanding why something they did resulted in an error. So for example: You may not remove the Global Mobility Default Enterprise Feature Access DN without clearing its Default marking or choosing a different Default EFA DN. The Global Mobility Default Enterprise Feature Access DN selection may either be unspecified or may designate an existing DN marked for use as a Mobility Enterprise Feature Access DN. (NumPlan.tkPatternUsage==PATTERN_MOBILITY_DTMF)
typegroupversionstamp		Used to update groups of devices based on common configuration settings
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
	versionstamp	New guid plus seconds past midnight 1970 are concatenated
typehaserverstate		CUP HA server status
	description	Localized string to define the purpose of the list item
	enum	A number to identify the list item
	moniker	A globally unique programmatic name to identify the list item
	name	Localized string displayed to users to identify list item
typehash		Hash info
	enum	A number to identify the record
	moniker	A short name to identify the record
	name
typehostedroutepatternpstnrule		Rule for deriving PSTN failover number for HostedRoutePattern
	enum	Unique identifier
	moniker	Moniker
	name	Name of the remote object pattern block
typehotspotauthenticationmethod		Type of Authentication methods that can be used by Hotspot Profile
	displayorder	Order of display sections with in a web page
	enum	Unique identifer
	moniker	A sort name to identify the record
	name	Specifies the behavior of Authentication Method
typehttpprofile		Specifies the classification of a HTTP Profile
	enum	Unique identifier for TypeHttpProfile
	moniker	A sort name to identify the record
	name	Name of the HTTP Profile Type
typehttpprofileuri		Specifies the URI Type for a HTTP Profile Extension
	enum	Unique identifier for TypeHttpProfileURIType. Obsolete - not used
	moniker	A sort name to identifier the record. Obsolete - not used
	name	Name of the HTTP Profile URI Type, used in connection string. Obsolete - not used
typehttpproxy		Type of HTTP Proxies that can be defined for a Wireless LAN Profile.
	enum	Unique identifer
	moniker	A sort name to identify the record
	name	Specifies the behavior of HTTP Proxy
typehuntalgorithm		Defines type of hunt algorithm supported
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeidsauditlevel		Informix Dynamic Server (IDS) Audit Levels
	enum	A number to identify the record
	moniker	A short name to identify the record
	name
typeilssyncstatus		Enums that display the current status of the sync.
	enum	unique identifier for TypeILSSyncStatus
	moniker	Moniker for TypeILSSyncStatus
	name	Text display of status
typeinputguiwidget		Table to infer type of input GUI widget for sub-resource configuration
	description	Localized string to define the purpose of the list item
	enum	A number to identify the list item
	moniker	A globally unique programmatic name to identify the list item
	name	Localized string displayed to users to identify list item
typeinterclusterservice		Types of Inter Cluster Services
	allowoverrideserviceaddress	This will determine if the service itself will allow manually overriding the address configuration
	enum	A number to identify the record.
	moniker	A sort name to identify the record
	name
typeipaddressingmode		Type of IP Addressing Mode
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeipaddressingmodeprefcontrol		Prefered IP Addressing Mode Control
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeipmalinemode		Distinguishes between proxy and shared
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeipmatarget		Mgr/Asst(1) vs. Anyconfigured no.(2)
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typekeepalivetimeinterval		This table holds the possible values for the keep alive time interval duration in minutes for DN Alias Sync and Lookup LDAP servers
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	Name used to identify an ordered list of LDAP keep alive Intervals
typekeyauthority		Defines different key types for Devices
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typekeyorder		Table containing Key Orders of types EC, RSA and EC preferred RSA backup
	description	Description of the KeyOrder list containing EC, RSA and EC preferred RSA backup options
	enum	A number to identify the KeyOrder list
	moniker	A globally unique programmatic name to identify the KeyOrder list
	name	Localized string displayed to users to identify the KeyOrder list
typekeysize		Defines the different Key Sizes that are used for private and public generation for a phone.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typelampblinkrate		Allowed values for lamp blink rates.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typelanguage		list of languages
	code
	enum	A number to identify the record
	isinuse
	moniker	A sort name to identify the record
	name
	nativename	Localized name of language (e.g., Deutsch for German)
	tklanguagegroup
typelanguagegroup		Grouping of languages based on character sets they support.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeldapdirectoryfunction		This table holds the possible purposed for which the LDAP server is being used where it could be either used for Dirsyn or for DN Alias Sync/Lookup purposes
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	Name used to identify an ordered list of LDAP Database
typeldapprotocol		Defines different LDAP Protocols
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
	tkldapserver
typeldapserver		Used for LDAP Directory Plugin Server type
	displayname
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
	standardissuefilterstring	The Cisco Standard Issue Filter string for this LDAP Server Type to be passed by default to the LDAP Host in a sync request used to restrict results to a subset of the possible result records.
typeldapserverattr		Used for LDAP Directory Plugin attribute types
	displayed
	displayname
	displayorder	Display order for the ldap server attribute field on the web page
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
	tkcustomuserattribute	This field is to map one of the 5 available custom field to the entry in TypeLdapServerAttr table
	udstag	To map udstag with ldap attribute
typelicensedresource		Contains the different devices tiers
	description	Description of the device license tier.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	Name of the device tier
typelicensedresourceproductmap		Maps phones to device tier
	enum	A number to identify the record
	tklicensedresource	Licensing Device Tier.
	tkproduct	Product id.
typelicensefeature		Type table containing information on features licensed
	enum	A number to identify the record
	featuredescription
	iktypelicensefeature_myparent	Enum value reference to another related record within TypeLicenseFeature. That other record defines a Next-Level-Up License from which borrowing may occur if no license units of this license are available.
	moniker	A sort name to identify the record
	name
	tklicensingmode	Enum value defined in the TypeLicensingMode table.
typelicenseunit		Type table containing number of license units required for each subtype of license feature
	adjunctunits	The adjusted license units charged for a phone used as a secondary phone. The default value -1 means a device type cannot be used as a secondary phone.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
	tklicensefeature
	units
typelicensingmode		The TypeLicensingMode table defines a license family and groupings within them enabling license related data (TypeLicenseFeature records) to exist for multiple licensing schemes concurrently.
	description	Description of the Licensing Mode and its associated purpose and usage.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	Name of the Licensing Mode type.
typelicensingstate		Contains the states of a license
	allowprovisioning	Boolean flag to control whether or not provisioning is allowed.
	description	Description of the State of the License.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	Name of state the license is in
typelogicalpartitionpolicy		Used to store Logical Partition Policy Types
	enum	A number to identify the record
	moniker	Name to be used by program
	name	A name to identify the record
typelossynetwork		For Region Matrix relationships to indicate level of packet loss across link
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typematrix		Matrix Type Table
	enum	A number to identify the record
	moniker	Name to be used by program
	name	A name to identify the record
typematrixvalue		Keeps allowable values for each of the Matrix types
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
	tkmatrix
typemedia		Type of Media supported - Invalid(0),Audio(1),Video(2),Data App(3),Data App BFCP(4)
	enum	A number to identify the record
	moniker	A sort name to identify different presentation record
	name	A sort name to identify different presentation record
typemediapayload		Used for H323 FastStart
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typemgcpslotmodule		Known types of slot modules for MGCP
	configurableportnumbers
	enum	A number to identify the record
	maxsubunits
	moniker	A sort name to identify the record
	name
	tkproduct_slotmodule
typemgcpvic		Known types of Vics for MGCP
	beginningportnumber
	beginportnum_second
	enum	A number to identify the record
	maxnumports
	moniker	A sort name to identify the record
	name
	tkproduct_second
	tkproduct_vic
typemixer		mixer for conferece bridge
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typemobilesmartclient		Mobility Smart Client Application Models
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typemodel		all device types (was typeDevice)
	defaultdtmfcapability
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
	showindevicedefaults
	tkclass
	tkphonecategory	Specifies type of phone for association. Valid values are - Desk Phone(0), Mobile Device(1), Profile(2)
	tkrisclass
	tksubclass	The sub class of the model
typemohcodec		used for MOH
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typemonitor		Used for AlarmConfiguration monitors
	display
	displayservername
	enum	A number to identify the record
	moniker	A sort name to identify the record
	monitorstatus
	name
	tkalarmseverity
typemonthofyear		Used for Time Period
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typemrapolicy		The possible MRA policy types
	enum	Unique identifer
	moniker	A sort name to identify the record
	name	Specifies the MRA policy service
typemwlpolicy		Policies for Message Waiting Light
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typenamedisplayformat		CUBA: Table to store the different types of Name display formats (e.g., First Name Last Name)
	description	Description of the Display Format
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	Name of the Display Format
typenetworklocation		On/Off Network
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typenodeusage		Identifies node as a Publisher (0) or Subscriber (1)
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	0=Publisher, 1=Subscriber
typensfservice		List of configurable network services provided by carrier used with NSFProtocalServiceMap
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
	nsfservicecode
	parametername
typenullrestriction		Matt will fill this in
	enum	A number to identify the record
	name
typenumberingplan		Numbering Plan for PRI
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typenumplanuritype		Types of URIs
	enum	Unique identifier for URI type
	moniker	Moniker
	name	Text display
typeonboardingregistrationstatus		Table to store different status related to Cloud On-boarding.
	enum	A number to define the status.
	moniker	A moniker to identify the record.
	name	Name of the APNS status.
typeoperator		operators used by GUI with Route Filter Details
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeoutboundcallrollover		Identifies behavior for features when MaxCalls is exceeded on a line and other lines are available
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typepacketcapturemode		Used to store the per-device basis setting to capture the signaling messages.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeparam		parameter types for service configuration
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typepartitionusage		Identifies Intercom vs. other types of partitions and calling search spaces
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typepattern		Pattern Types
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typepatternhandlingflaginfo		Defines allowed setting combinations of bitmapped flags based on integer lookup values.
	description	For each record with an enum value resulting from zero or 1 bit-flag set, this describes the flag purpose. Other records have NULL here.
	enum	Unique numeric surrogate primary key used as record identifer in this table.
	moniker	Unique, strictly formatted, string key for program / programmer record reference use.
	name	Unique User-Facing Name
typepatternprecedence		MLPP Precedence level
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
	precedencelevel
typepatternrouteclass		Route Class Setting
	enum	A number to identify the record
	moniker	A moniker to identify the record
	name	A name to identify the record
typepatternusage		type of pattern in NumPlan
	allowlocaladministration	Indicates that patterns with this marking may be provisioned by the administrator. (As contrasted with LEARNED patterns imported to the dial plan via some mechanism.
	enum	A number to identify the record
	isusedbydigitanalysis	Indicates that patterns with this marking are included in those considered by Call Processing Digit Analysis and should be included in route reporting.
	moniker	A sort name to identify the record
	name
typepersonalphonenumber		categorizes as fax, mobile etc.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typephonecategory		List of telephone catagories
	enum	A number to identify the record
	moniker	A moniker to identify the record
	name	A short name to identify the record
typephonefeature		CUBA: This table will store the information about the fields for the usage profile phone feature page
	cubadefaultval	Default value for the XML tag
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typephonefeaturecubaproductmap		CUBA: This table will store the mapping between default values and productspecific default values for usage profile
	enum	Unique identifier for the record
	fkcubaproductsupport	reference to cubaproductsupport
	productxmltag	Keep the XML tag specific to product
	tkphonefeature	Reference to phone feature
typephonepersonalization		Phone Personalization Settings
	enum	A number to identify the record
	moniker
	name
typephoneservice		IP Phone Service types: Standard IP Phone Service, Directories, Messages
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typephoneservicecategory		Type of Service:XML Service=0,Java MIDlet=1
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typephoneservicedisplay		Display setting for IP Phone Services: Internal, External URL, Both, Default
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typephonetemplateusage		define what PhoneTemplate is used for - traditional phone or a type of addon module
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
	tkmodel
typepickupnotification		Defines the different Notification options available with Pickup
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typepipesize		CUBA: To store the different kind of pipe sizes.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	Name of the typePipeSize
	valueinkbits	Kbits value for the pipesize
typeplaceholdertag		List of the place holder for Tags
	description	Description of the tag usage for each defined tag
	enum	A number to identify the TypePlaceHolderTag record
	iconfile	Icon File Name of the Place Holder Tag.
	moniker	A moniker to identify the record
	name	Name of the Place Holder Tag
	tag	Tag of the Place Holder Tag. It starts and ends with a #
typeplaceholdertagfieldinfomap		List of mapping between a Place Holder Tag and field number of its applicable table.column
	enum	A number to identify the TypePlaceHolderTagFieldInfoMap record
	tkfieldinfo_applicable	Field number of a table.column whose value can be generated using place holder tags
	tkplaceholdertag	Reference to TypePlaceHolderTag
typepluginusage		Whether a plugin record is for the menu or is an application.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeportaluri		Relative URI paths to Self-Care Portal.
	enum	Unique identifier
	istoplevel	When true, the URI is the entry point for the self-care portal
	moniker	Moniker
	name	Name of the self-care portal page.
	uri	Relative URI for self-care portal.
typepreemption		Type of preemption behavior or tone (for MLPP)
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typepreferredmediasource		List of media sources for recording.
	enum	A number to identify the record.
	moniker	A sort name to identify the record.
	name	Name of the location state.
typepresentationbit		Presentaton bit for access ports
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeprichanie		Digital Access Pri channel IE values
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typepriofnumber		null
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typepriprotocol		supported Primary Rate protocols
	enum	A number to identify the record
	isqsig
	moniker	A sort name to identify the record
	name
typeprocessnoderole		Types of server roles within a cluster: 1 = Voice (default) and 2 = IM and Presence
	enum	A number to identify the TypeProcessNodeRole record
	moniker	A moniker to identify the record
	name	Name of the ProcessNode Role
typeproduct		complete list of products for combo boxes
	devicenameformat	Use regular expression (up to 255 characters) to define format
	devicenamestring
	enum	A number to identify the record
	isinstalleddefault	Is this product included in a default installation
	maxports
	moniker	A sort name to identify the record
	name
	showindropdown
	tkmodel
typeproductconfig		list of configurable attributes used with ProductCapabilities
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeprotocolside		user/network values
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeprovider		CUBA: This table will contains the information about the different type of providers
	enum	unique identifier for typeprovider
	moniker	Moniker for typeprovider
	name	Name for the typeprovider
typeqsig		Describes what type of devices are in a particular route list or route group.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeqsigvariant		For Qsig Variant
	enum	A number to identify the record.
	moniker	A sort name to identify the record
	name
typerecordingflag		Automatic Call Recording Enabled, Application Invoked Call Recording Enabled, Call Recording Disabled
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typerefreshtoken		Table to store type of token
	enum	A number to identify the record
	moniker	A short name to identify the record
	name
typerelatedfieldinfo		Charlie will fill this in
	checkconstraint
	conditionalvalue
	defaultvalue
	dntype
	enum	A number to identify the record
	involvedfields
	length
	notmodifiable
	optype
	remarks
	tkfieldinfo_conditional
	tkfieldinfo_enforcedon
	tknullrestriction
	tktableinfo
	validation
typereleasecausevalue		List of allowable cause value for when a pattern is blocked.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeremotedestinationusage		This table holds the possible RemoteDestination usages and the field on the RemoteDestination table which stores the association for that usage type.
	enum	Unique identifier
	moniker	Moniker
	name	Display name of the Remote Destination Usage type.
	tkfieldinfo	Field used in the Remote Destination table for this usage type.
typeremoteobject		Types of objects replicated into the cluster from other clusters
	enum	Unique identifier
	moniker	Moniker
	name	Name for the Remote Object type
typereplicationstatus		List of states that replication setup (and repair) goes through
	enum	A number to identify the TypeReplicationStatus record
	moniker	A moniker to identify the record
	name	Name of the Replication Status
typereset		Having soft and hard reset types
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeresethandshake		Defines different types of handshake between tftp and ccm for devicereset
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeresource		Resource is an entity that have action performed on them.
	description	Description of resource types used for access privileges (user groups and permisssions)
	enum	A number to identify the record
	iktyperesource_parent	gives the parent's pkid for the subresources
	moniker	A sort name to identify the record
	name
	prefix	Strut action prefixes for a resource.
	tkapplication
	tkinputguiwidget	gives input GUI widget type (applies to subresource only)
typeresourceaction		Actions and references to resources.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
	tkbitpos
	tkresource
typerevertpriority		Use for the priority for incoming call and hold reversion call
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeringsetting		Type of different ring setting for normal ringer, flash and consecutive call ringer
	enum	A number to identify the record
	islinecompatible	Whether this enum can be used as line setting for device or not
	moniker	A sort name to identify the record
	name
typerisclass		Table of risc mananaged class of device
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typerisstatus		Lists Ris Status
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeroaminguserstatus		tri-status values (Logged In, Logged Out, Logged Out through ILS)
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeroutingdatabasecachetimer		This table holds the value for the time duration in hours to retain the information fetched from the DN Alias Lookup server in the cache
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	Name used to identify an cache timer
typersvpoversip		Define RSVP over SIP policy
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typertmtreportingservice		The types of RTMT Reporting Services
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typerule		Types of database Rules implemented in triggers (triggering event in paratheses)
	description
	enum	A number to identify the record
	name
typeruleinfo		The database rules for this database, usually implemented in triggers on one or more tables.
	description
	enum	A number to identify the record
	errormessage
	implemented
	remedy
	rulename
	testcondition
	tkrule
typesafservice		The types of SAF services that can be run on the system
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeschciscotacdestination		Used by Smart Call Home application to choose Cisco TAC Destination by HTTPS or EMAIL.
	description
	destination
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typescheduleunit		Used to determine a scheduling unit of time
	displayname
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typesdpattributehandling		Handling Type of a SDP attribute
	enum	Unique identifier for TypeSDPAttributeHandling.
	moniker	Moniker for TypeSDPAttributeHandling record.
	name	Name of Handling Type of a SDP attribute.
typesecuritypolicy		Security Policy Types
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeserversecuritymode		Used for specifying Server Security Mode
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeservice		types of Cisco voice processes
	canbedisabled
	dbuser	Database user for process.
	devicenamemonitorflag
	devicetypemonitorflag
	enable
	enabledbydefault
	enum	A number to identify the record
	filename
	filetraceflag
	includenondevicetraces
	log4jpackage
	maxfilesize	Created during installation.
	maxnumservers
	moniker	A sort name to identify the record
	name
	nameforcontrol
	numfiles
	numlines
	numminutes	Trace configuartion option. Maximum minutes of data stored in each trace file.
	outputdebugstringflag	Trace configuartion option. Cisco engineers use this setting
	pathname	Service Parameter Rule Path Name.
	processname	Process name that uses Database.
	productmask	Bitmask of products to which this service applies (CCM, Unity, etc.)
	servername
	supportalarm
	supportsditrace	indicator for whether the service support SDI trace
	supportsdltrace	indicator for whether the service support SDL trace
	supportserviceparams
	supportslog4jtrace	Created during installation.
	tkservicecategory
	tkservicegrouping	controls grouping of display
	tkservicerestriction	controls if number of servers can be activated
	tktracelevelgroups
	tracelevel
	tracelevelcategory	if standard set true during installation.
	tracename	short service name used for trace log
	usercategories
	usexml
typeservicecategory		list of servcie category
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeservicegrouping		list of goups of servcies
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeservicerestriction		Is number of servers servcie can be activated restricted
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typesilencesuppressionthreshold		allowed silence suppression thresholds in dB
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typesipassertedtype		Options: Default=0, PAI=1, PPI=2
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typesipbandwidthmodifier		The TypeSIPBandwidthModifiers table adds support to SIP session level bandwidth modifiers
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	Name of the Bandwidth MOdifier type.
typesipcodec		used for SIP Trunk codecs
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typesipidentityblend		Options for what information to include in SIP connected party identity headers.
	enum	unique identifier for TypeSIPIdentityBlend
	moniker	Moniker for TypeSIPIdentityBlend
	name	Name of the SIP identity blend option
typesipprivacy		Options: Default=0, None=1, ID=2, ID Critical=6
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typesiprel1xxoptions		Define Rel1XX Options for SIP profile
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typesipreroute		Type of rerouting information used for calls over SIP trunks
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typesipscripterrorhandling		Type values for SIP Normalization script error handling
	enum	A number to identify the TypeSIPScriptErrorHandling record
	isavailableselectionforresourceerror	To check if this particular TypeSIPScriptErrorHandling entry is available to select for Resource Error Action
	isdefaultforresourceerror	To check if this particular TypeSIPScriptErrorHandling entry is the default for Resource Error Action
	isdefaultforruntimeerror	To check if this particular TypeSIPScriptErrorHandling entry is the default for Run Time Error Action
	moniker	A moniker to identify the TypeSIPScriptErrorHandling record
	name	A name to identify the TypeSIPScriptErrorHandling record
typesipsessionrefreshmethod		Options for SIP method for session refresh
	enum	Unique identifier for TypeSipSessionRefreshMethod.
	moniker	Moniker for TypeSipSessionRefreshMethod record.
	name	Name of SIP method for session refresh.
typesiptrunkcalllegsecurity		Options for Call Leg Security on a SIP Trunk when using sRTP
	enum	A number to identify the record
	moniker	A moniker to identify the record
	name	A name to identify the record
typesite		CUBA: Different type of sites like hub,internet,remote
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	Name of the type of site
typeslmfeature		Table to store entitlement tags
	enum	A number to identify the list item
	moniker	A globally unique programmatic name to identify the list item
	name	Localized string displayed to users to identify list item
	tag	Entitlement tag for a license type
	tklicensefeature	Entitlement name.
typeslmtransport		Table to store transport types of the product instance to communicate with CSSM/satellite
	description	Localized string to define the purpose of the list item
	enum	A number to identify the list item
	moniker	A globally unique programmatic name to identify the list item
	name	Localized string displayed to users to identify list item
typesnmpauthenticationprotocol		Type to collect the various SNMP authentication protocols
	enum	Unique identifer.
	moniker	A sort name to identify the record.
	name	Specifies the names of SNMPAuthenticationProtocol.
typesnmpprivacyprotocol		Type to collect the various SNMP privacy protocols
	enum	Unique identifer.
	moniker	A sort name to identify the record.
	name	Specifies the names of SNMPPrivacyProtocol.
typesnmpversion		Type to collect the various version of SNMP
	enum	Unique identifer.
	moniker	A sort name to identify the record.
	name	Specifies the names of SNMP version.
typesoftkey		Softkey event for Sculpin
	englishlabel	The English label for softkey, such as "Redial".
	enum	range of 1-255. This enum is actually a event ID, which is associated with application. 1-64 for Call Processing, 65-255 for other application
	helpid	help id for telecatser help text
	mandatorymask	Indicator for whether the softkey is required in certain call state
	moniker	A sort name to identify the record
	name
	tag	This tag is used for localization application to look up the display text for phone
	tkservice
	validationmask	Indicator for whether the softkey is valid in certain state
typespa8800port		CUBA: This table contains the information about ports in SPA8800 gateway
	enum	unique identifier for typeSPA8800Port
	ispstnconnection	Indicates FXO port (True) or FXS port (False) of the typeSPA8800Port
	mgcpport	This will store the MGCP port number of the typeSPA8800Port
	moniker	Moniker for typeSPA8800Port
	name	Name for the typeSPA8800Port
	tcpport	This will store the TCP port number of the typeSPA8800Port
typesrstoption		List of SRST option supported by Cisco Phone and DB
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typessomode		The possible single sign-on modes
	enum	Unique identifer
	moniker	A sort name to identify the record
	name	Specifies the Single Sign On mode
typestartdialprotocol		Immediate vs wink, etc.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typestatus		tri-state values (on, off, default)
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typestringformat		Localized string format type.
	enum	Unique identifier
	moniker	Moniker
	name	Name of the string format type
typestringformatrule		Localized string format rule.
	enum	Unique identifier
	moniker	Moniker
	name	Name of the string format rule
	ruleexpression	String format rule expression with replacement tokens.
	tkstringformat	String format type with which this rule is associated.
typesubclass		CIA-309 to facilitate Servicability
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
	tkclass
	value
typesubpatternusage		CUBA: Creator of pattern in NumPlan
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typesupportsfeature		The various features support by CM
	description	Describes the feature and any extra values it might require.
	enum	A number to identify the record
	hasparameter	Does this feature have a parameter that the user might enter?
	isgatewayfeature	Is this a gateway feature?
	isphonefeature	Is this a phone feature?
	moniker	A sort name to identify the record
	name
typesyncstatus		Type to collect the various status of the sync process to WLC or CPI
	enum	Unique identifer.
	moniker	A sort name to identify the record.
	name	Specifies the names of WLC Sync Status.
typesyslogmessage		Syslog Message Levels
	enum	A number to identify the record
	moniker	A short name to identify the record
	name
typesystemfeature		null
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typetableinfo		Table information (datadictionary in database)
	checkconstraint	Text that will be used to specifiy the rules for a column.(must follow check SQL syntax)
	convertcopy	true is talbe is to be copied during db conversion
	description	Best development descriptoin of table
	enum	Integer that enumerates tables
	excludechangenotifycheck	True if change notify is not used with this able
	hasdefaultrecords	True if recoreds for this table are found in datadictionary
	isreplicated	Shall this table be incoperated in to replication configuration.
	migrationnote	Textual description of where this value is created from(table and column) in previous schema.
	notmodifiable	True if can not be modified by user (only modified by install or trigger)
	nouserinsert	True if can not be inserted by user (only inserted by install or trigger)
	processconfigrelation
	schemaowner	UCM 1 CDS 2 BOTH 3
	tableguid
	tablename	Name of table
typetaskstatus		Task Status
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typetelnetlevel		telnet enable level for 7960 and 7940 phones
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeterminal		used for gatekeeper
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typetimeofday		Used for Time Period
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typetimeschedulecategory		Type of Time Schedule Categories, regular or holiday/vacation schedule
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typetimezone		24 time zones
	abbreviation
	bias
	description
	dstbias
	dstdate
	enum	A number to identify the record
	legacyname	the old timezone name before Olson
	moniker	A sort name to identify the record
	name
	stdbias
	stddate
typetracelevelgrouping		Used to map which trace level to trace level groups
	description
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
	tktracelevelgroups
	value
typetracelevelgroups		Used to specify which trace level group will be used by service
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typetransport		used for SIP Trunk, has 2 values TCP or UDP
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typetrunk		trunk types for access devices
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typetrunkdirection		direction for access ports
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typetrunklevel		trunk application types
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
	trunkapplicationdescription
typetrunkpad		pad values for trunks in dB
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typetrunkselectionorder		bottom-up, or top-down selection order
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typetrunkservice		Types of Trunk Service
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typetrustreceivedidentity		Options: Trust All (Default)=0, Trust PAI Only=1, Trust None=2
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typetrustrole		Trust Verification Service Roles
	enum	A number to identify the record
	moniker	A short name to identify record
	name	Name
typetunneledprotocol		Defines Tunneled Protocol for Intercluster trunks
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
	tunneledprotocol
typeucproduct		Specific Unified Communications (UC) products that interact with UCM (e.g., Unity, Unity Connection, WebEx, MeetingPlace, Exchange)
	advancedproductsettingsfile	Path to file containing XML used to render additional settings for the UC Service
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	Name of the Unified Communications Product
	showhostnameorip	Indicates whether or not a Host Name or IP Address is used to integrate with the UC Product management interface
	showport	Indicates whether or not a Port number is used to integrate with the UC Product management interface
	tkucservice	Reference to Unified Communications Service for which this Product is used
typeucproductappservermap		Maps the existing UCM Application Server types to the UC Product types. For example, maps existing Unity AppServer type to the Unity UC Product.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	Name of the Unified Communications Product to Application Server Mapping
	tkappserver	Reference to UCM Application Server type that matches the UC Product
	tkucproduct	Reference to Unified Communications Product
typeucproductconnectprotocolmap		Defines the allowed connection protocols for communication between UCM and other UC products.
	defaultport	Default Port for Unified Communications Product Type
	enum	A number to identify the record
	isdefault	Indicates whether or not a Connection Protocol is the default for a UC Product
	moniker	A sort name to identify the record
	name	Name of the Unified Communications Product to Application Server Mapping
	sortorder	Used to order the display of Connection Protocols for a UC Product
	tkconnectprotocol	Reference to a Connection Protocol that is used to manage the UC Product
	tkucproduct	Reference to Unified Communications Product
typeucservice		General classifications for Unified Communications services that interact around UCM (e.g., Voicemail, Conferencing, Directory, Presence)
	advancedprofilesettingsfile	Path to file containing XML used to render additional Service Profile settings for the UC Service
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	Name of the Unified Communications Service
	requireconsistentproduct	Indicates whether or not a Service Profile can contain a mix of different products or product versions for this type of UC Service. If true, all products for the UC Service (e.g., for Conferencing) must be identical in the Service Profile.
	showcertificateverificationlevel	Indicates whether or not Certificate Verification Level is used with this UC Service type. If true, a level must be indicated in the UC Service Profile Detail. If false, no level is specified (null).
	tagname	TagName to provide separation between the display name and XML element name for the UCService
typeuridisambiguationpolicy		Options for interpreting an ambiguous called party identifier.
	enum	unique identifier for TypeURIDisambiguationPolicy
	moniker	Moniker for TypeURIDisambiguationPolicy
	name	Name of the URI disambiguation policy
typeusageprofilefeature		CUBA: To store a list of available features for usageprofile
	enum	A number to identify the record
	featurecontrolclause	Indicates a colon separated list of feature control type associated with the usage profile
	moniker	A sort name to identify the record
	name	Name of the type of usageprofile feature
	softkeyclause	Indicates the colon separated list of softkey associated with the usage profile
	tkfeature	reference to feature
typeuseentity		CUBA: To store different type of entity like enduser,department
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	Name of the typeUse
typeuseragentserverheaderinfo		The TypeUserAgentServerHeaderInfo table specifies User-agent and server header pass through config options on SIP Profile
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	Name of the User-agent and server header pass through config options type.
typeuserassociation		User association types (CTI Control IN, CTI control out, Digest In, Digest Out, Profile Available)
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeuserlocale		list of user locales
	alternatescript
	cmversion
	componentversion
	enum	A number to identify the record
	languagelocalecode	ISO two character ISO language code and two character ISO country code concatenated with an underscore (mixed case): example fr_FR, en_US, it_IT, zh_HK
	localecode	ISO three character locale code (uppercase): example FRA, ENU, ITA, PTB, ZHH
	moniker	A sort name to identify the record
	name
	nativename
	tklanguage_spoken
	tklanguage_written
	tkwincharset
typeusernotificationmessage		The TypeNotificationMessage table adds support to store the standard User Notification messages
	description	Description of the Notification Message displayed to ensuser
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name	Name of the notification message
	tkusernotificationsection	Determines the class of user notification message: Info=1 Setup=2 Feature=3
typeusernotificationsection		This table is used to identify the section of notification message displayed to user:Info,Setup and Feature specific notificaiton messages
	enum	A number to identify the record
	moniker	A sort name to identify the notification message section
	name	Name of the notification message section
typeuserprofile		Types of users - Real or Template
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typeusntype		Update sequence number payload types.
	enum	unique identifier for TypeUsnType
	moniker	Moniker for TypeUsntype
	name	Text display
	tag	Tag used in replication protocol
typev150sdpfilter		SDP Filter setting options for V150 Capabilities. Applicable to SIP Trunks in Security Profiles.
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typevideocalltrafficclass		Type of Video Call Traffic Class configured on a SIP Profile for a Trunk
	enum	A number to identify the type of video call traffic
	moniker	A moniker to identify the record
	name	A name to identify the record
typeviprfilterelement		Used for specifying filter element type for VIPR filter elements
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typevmavoidancepolicy		Type of VoiceMail Avoidance Policy to determine whether a real mobile user or mobile voice mail answers a call
	enum	A number to identify the type of voice mail avoidance policy chosen
	moniker	A moniker to identify the record
	name	A name to identify the record
typevpnclientauthentication		VPN Client Authentication Types:User And Password (0), Password Only (1), Certificate (2).
	enum	A number to identify the record
	moniker	A short name to identify the record
	name
typewebpage		Stores administration web page information. The content of this table is maintained by CMUI team
	enum	A number to identify the record.
	moniker	A sort name to identify the record.
	name	Name of the location state.
typewebpagedisplay		Stores administration web page display control options
	enum	A number to identify the record.
	moniker	A sort name to identify the record.
	name	Name of the location state.
typewebpageinfo		List of web pages in CCMAdmin
	bundle
	description
	enum	A number to identify the record
	findlisttopicmarker
	formname
	pagename
	title
	topicmarker
	webapp
typewebpagesection		Stores administration web page section information. The content of this table is maintained by CMUI team
	displayorder_default	Default order of display sections with in a web page
	enum	A number to identify the record.
	isrequired	When IsRequired is enabled, tkWebPage display cannot be hidden
	moniker	A sort name to identify the record.
	name	Name of the location state.
	tkwebpage	Reference to web page
	tkwebpagedisplay_default	Default reference to Web page Display
typewifiauthenticationmethod		Type of Authentication methods that can be used by Wireless LAN Profile
	displayorder	Order of display sections with in a web page
	enum	Unique identifer
	moniker	A sort name to identify the record
	name	Specifies the behavior of Authentication Method
typewififrequency		Type of WiFi frequencies that can be used by Wireless LAN Profile.
	enum	Unique identifer
	moniker	A sort name to identify the record
	name	Specifies the behavior of WiFi Frequency
typewifiusercertificate		Type of User Certificate for EAP-TLS AuthenticationMethod
	enum	Unique identifer.
	moniker	A sort name to identify the record.
	name	Specifies the names of UserCertificate.
typewincharset		List of Windows character set
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typewlanprofilechanges		Indicates what level of changes can be done to Wireless LAN Profile.
	enum	Unique identifer.
	moniker	A sort name to identify the record.
	name	Specifies the behavior of Wireless LAN Profile changes.
typeyellowalarm		used for T1 and PRI
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typezerosuppression		used for T1 and PRI
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typezzconfbridge		use local or phone conference bridge (0 - Local,1 - CCM Conf)
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typezzdndcontrol		Types of Do Not Disturb (DND) control for SIP Phones
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typezzdtmfdblevel		dtmf transmit level (1 - 6 dB below nominal, 2 - 3 dB below nominal, 3-nominal, 4-3 dB above nominal, 5-6 dB above nominal)
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typezznetworkmediatype		network Media (0 - Auto, 1 - Full100, 2 - Half100, 3 - Full10, 3 - Half10)
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typezzntpmode		Types of NTP for SIP Phones
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
	phone
typezzpreff		Used to differentiate phone control levels for SIP phones
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
typezzuserinfo		type of user (0 - none,1 - phone,2- ip)
	enum	A number to identify the record
	moniker	A sort name to identify the record
	name
ucservice		Stores the provisioning data needed to integrate Unified Communications (UC) products with UCM. A UC Service is a specific instance of a product running on a host
	description	A localizable administrative description of the UC Service
	fkappserver	When there is an Application Server configured that maps to this UC Service type and Host Name or IP Address, a reference to that AppServer is recorded here (by rule).
	hostnameorip	When required for the UC Service type, the host name or IP address of the server where the UC Service resides
	name	Unique name to Identify the Unified Communications Service
	pkid	Unique identifier for the record
	port	When required for the UC Service type, the port used to communicate with the UC Service (management interface)
	resettoggle	Should this device or group be reset
	tkconnectprotocol	Reference to a Connection Protocol that is used to interact with the Unified Communications Product
	tkreset	Set by DeviceReset stored procedure. Possible values can be - Hard Reset(1), Soft Reset(2), Apply Configuration(3)
	tkucproduct	Reference to Unified Communications Product defined for this service
ucserviceprofile		Stores data defining a profile that groups together multiple UC Services of various types
	description	A localizable administrative description of the UC Service Profile
	isdefault	Indicates whether or not this is the default UC Service Profile for the cluster
	name	A unique name to identify the UC Service Profile (a collection of UC Services of different types)
	pkid	Unique identifier for the record
	resettoggle	Should this device or group be reset
	tkreset	Set by DeviceReset stored procedure. Possible values can be - Hard Reset(1), Soft Reset(2), Apply Configuration(3)
	versionstamp	New guid is generated every time this UCServiceProfile is updated
ucserviceprofiledetail		Stores the specific hosts and settings to used when provisioning new users. Each detail record may include up to 3 UC Services of the specified type (e.g., 3 Conferencing services). The services must be of the same type but may be different products (e.g., both Unity and Unity Connection for voicemail).
	fkucservice_1	A reference to a configured UC Service of the specific type for the UC Service Profile Details. This is the Primary instance of this UC Service in the Profile
	fkucservice_2	A reference to a configured UC Service of the specific type for the UC Service Profile Details. This is the Secondary instance of this UC Service in the Profile
	fkucservice_3	A reference to a configured UC Service of the specific type for the UC Service Profile Details. This is the Tertiary instance of this UC Service in the Profile
	fkucserviceprofile	A reference to the UC Service Profile for which this record defines UC Services of a specified type (e.g., the Mail Store services)
	pkid	Unique identifier for the record
	tkcertificateverificationlevel	When used for a UC Service Type, a reference to the level of verification for security certificates needed for communication between hosts
	tkucservice	A reference to the type of UC Service that this record defines in the UC Service Profile
ucserviceprofiledetailxml		Stores additional provisioning data in XML format for the referenced UCService in the profile, as specified in the Advanced Profile Settings file for the referenced UC Service
	fkucserviceprofiledetail	A reference to the UC Service Profile Detail to which this XML applies
	pkid	Unique identifier for the record
	xml	XML as defined in the Advanced Settings file for the UC Service type
ucservicexml		Stores additional provisioning data in XML format for the referenced UCService, as specified in the Advanced Product Settings file for the referenced UC Product
	fkucservice	A reference to the UC Service to which this XML applies
	pkid	Unique identifier for the record
	xml	XML as defined in the Advanced Settings file for the UC Product type
ucuserprofile		Named Groupings of shared User Characteristics and Settings used to reduce manual input when defining user related information. The admin selects a Profile rather than each individual setting.
	allowusertoselfprovisionuptodevlimit	User permission flag to allow Self-Provisiooning.
	allowusertosetemmaxtime	Allow user to set Extension Mobility Max Login Time
	description	Permits admin entry of locale-adjusted descriptive text to aid in UC User Profile selection.
	enablemra	Indicates whether MRA is enabled.
	name	Name used to identify and select the UC User Profile
	pkid	Unique ID to identify a record.
	tkmrapolicy_desktop	Policy setting for desktop devices.
	tkmrapolicy_mobile	Policy setting for mobile devices.
	userdevicelimitwhenselfprovisioning	Even Users permitted to self-provision may not do so if it will cause them to have more than this many devices. Used to limit license consumption impact of inadvertent or excess user-initiated device configurations.
ucuserprofiledevicemap		Associates a UC User Profile with Universal Device Template(s) used in Quick Phone Provisioning of different category phones models
	fkdevice	Reference to Common device template
	fkucuserprofile	Reference to the UC User Profile to which the associated Universal Device Template applies.
	pkid	Unique identifier for the record
	tkphonecategory	Specified type of phone for assoication.
ucuserprofilenumplanmap		Associates a UC User Profile with the Universal Line Template used in Quick Phone Provisioning line setup.
	fknumplan	Reference to numplan records
	fkucuserprofile	Reference to UC User Profile to which the associated Universal Line Template applies.
	pkid	Unique ID to identify a record.
usageprofile		CUBA: Usage Profile is a collection of different CUCM configurations that can be assigned to a group of users
	allowedfeaturelist	CSV string of feature numbers
	allowemergencycalls	check for Emergency calls
	allowemfordevices	Extension Mobility Allowed For Devices
	allowemforusers	Extension Mobility Allowed For Users
	allowsinglenumberreach	Single Number Reach Allowed
	allowvoicemail	Voice Mail Allowed for the users belongs to this usageProfile
	cfbdestination	Destination for Forward Busy in a Usage Profile
	cfbvoicemailenabled
	cfnadestination	Destination for Forward No Answer in a Usage Profile
	cfnavoicemailenabled
	description	Description for usageprofile
	devicexml	XML To hold phone specific parameters
	fkcallingsearchspace_blocking	Stores a CSS reference for Blocking.
	fkcommondeviceconfig	Common device onfig setting for useprofile
	fkcommonphoneconfig	Common phone config for useprofile
	fkphonetemplate	Reference to phonetemplate
	mohaudiosource	Moh for useprofile
	name	Unique name
	pkid	Unique id for useprofile table
	tkcosrouting_max	Referece to CoSRouting
usageprofileendusermember		CUBA: Store the information of the enduser and usageprofile association
	fkenduser	Reference to EndUser
	fkusageprofile	Reference to UsageProfile
	pkid	Unique identifier for the record
	tkuseentity	Reference to TypeUseEntity
usageprofileproductspecific		CUBA: UsageProfileProductSpecific to store Usage Profile phone model specific information.
	devicexml	XML for useprofileproductspecific
	fkphonetemplate	Reference to phonetemplate for useprofileproductspecific
	fkusageprofile	refernece to useprofile
	pkid	Unique id for UseProfileProductSpecific
	tkdeviceprotocol	Protocol type
	tkproduct	product type
usageprofiletelecasterservicemap		CUBA: To store associate phoneservices with usageprofile
	fktelecasterservice	Reference to Telecasterservice
	fkusageprofile	Reference to usageprofile
	ispushtotalk	Flag to show if PTT is enabled
	pkid	Unique identifier for the record
usergroup		Defines User Groups for administrative or organizational purposes.
	deletedtimestamp	Deleted Timestamp for Usergroup
	distinguishedname	Distinguished Name of Group Object peresent on AD server.
	fkdirectorypluginconfig
	name	Name to identify the group
	pkid	Unique identifier for the record
	status	Active or Inactive
	uniqueid	It will be ObjectGUID from ActiveDirectory
usergroupmember		Stores the association between User Groups and the Users from an external LDAP server.
	deletedtimestamp	Deleted Timestamp for UsergroupMember
	fkenduser	Refernce for the EndUser record.
	fkusergroup	Refernce for the UserGroup record.
	pkid	Unique identifier for the record
	status	Active or Inactive
userrank		Table to store default and user configured ranks of rank heirarchy.
	description	Description of the configured rank.
	enum	enum is used for defining the position in the rank hierarchy. The lower the enum the higher up in the hierarchy.
	name	A unique name for userrank.
usn		Update sequence numbers and primary keys of objects to which they refer.
	datetimestamp	Time value for last change
	isdeleted	Indicates whether the object specified by the pkid has been deleted
	pkid	Unique ID to identify a record.
	tkusntype	USN type
	usn	Update sequence number for the object referenced by pkid.
usnreplset		Replication set and associated attributes.
	lastusn	Highest USN generated for the replication set
	pkid	Unique ID to identify a record.
	replicationset	Identifier for the current replication set
usnsyncservice		Replication set for Directory Number Alias Sync Server and associated attributes.
	lastusn	Highest Update Sequence Number generated for the replication set for Directory Number Alias Sync Server
	pkid	Unique ID to identify a record.
	replicationset	Identifier for the current replication set
usntombstoneuri		USNs for rows deleted from NumPlanURI.
	pkid	Unique ID to identify a record.
	uri	URI deleted from the database.
vipre164transformation		IME E164 Transformation
	description	Description is up to 128 characters including Unicode
	fkcallingsearchspace_outgoingcdpntranf
	fkcallingsearchspace_outgoingcgpntranf
	fkincomingtransformationprofile_cdpn
	fkincomingtransformationprofile_cgpn
	ispretransformationoutgoingcdpn
	ispretransformationoutgoingcgpn
	name	Name of the IME E164
	pkid	Unique ID to identify a record
viprexcludeddidpatterngroup		IME Excluded Pattern Groups
	description	Description is up to 128 characters including Unicode
	name	Name of the IME excluded DID Pattern Group
	pkid	Unique ID to identify a record
viprfilterelement		IME Filter Elements
	description	Description is up to 128 characters including Unicode
	fkviprfiltergroup
	name	Name of the IME Domain
	pkid	Unique ID to identify a record
	tkviprfilterelement
viprfiltergroup		IME Filter Groups
	description	Description is up to 128 characters including Unicode
	name	Name of the IME Domain Group
	pkid	Unique ID to identify a record
	trusted
viproffpathserver		IME off path Servers
	description	Description is up to 128 characters including Unicode
	ipaddress	IP Address for the IME
	name	Name of the ASA Server
	pkid	Unique ID to identify a record.
	port	Port number to connect to the IME
viprpublisheddidpattern		IME Enrolled Patterns
	description	Description is up to 128 characters including Unicode
	fkviprexcludeddidpatterngroup	The IME Pattern must be in IME Enrolled or Excluded Pattern Group or in both.
	fkviprpublisheddidpatterngroup
	pattern	Published DID Pattern
	pkid	Unique ID to identify a record
viprpublisheddidpatterngroup		IME Enrolled Pattern Groups
	description	Description is up to 128 characters including Unicode
	fkfallbackprofile
	ispatternallalias	All the patterns are alias in this group
	name	Name of the IME Published DID Pattern Group
	pkid	Unique ID to identify a record
viprserver		IME
	description	Description is up to 128 characters including Unicode
	fkapplicationuser
	ipaddress	IP Address for IME
	name	Name of IME
	pkid	Unique ID to identify a record.
	port	Port number to connect to IME
	reconnectinterval	Reconnect Interval
	tkserversecuritymode
viprservice		IME Services
	activate
	description	Description is up to 128 characters including Unicode
	domain	Domain
	fkdevice
	fkviprexcludeddidpatterngroup
	fkviprfiltergroup
	fkviproffpathserver
	fkviprserver_primary
	fkviprserver_secondary
	ispublic
	name	Name of the IME Network
	pkid	Unique ID to identify a record.
viprserviceccmexternalipmap		IME Service CallManager External IP Map
	fkcallmanager
	fkviprservice
	ipaddresshost
	pkid	Unique ID to identify a record.
	port	Port number to connect to the IME
viprservicedidpatterngroupmap		Many to many relationship between VIPR Services and DIDs
	fkviprpublisheddidpatterngroup
	fkviprservice
	pkid	Unique ID to identify a record.
vipruri		Used for specifying for validated IME URI
	pkid	Unique ID to identify a record.
	uri
viprurivalidateddidmap		IME URI and Validated DID Map
	fkvipruri
	fkviprvalidateddid
	pkid	Unique ID to identify a record.
viprvalidateddid		IME Validated DIDs
	adminenabled
	e164did	DID
	fkdevice_sip	SIP Device
	grantingdomain	Domain
	nodeid	nodeid
	pkid	Unique ID to identify a record
	ticket	Ticket
	validityendtime	ValidityEndTime
	validitystarttime	ValidityStartTime
vohserver		Contains data for video on hold server
	defaultvideostreamid	Default Video Stream Identifier
	description	Description of Video On Hold Server
	fkdevice	Reference to a specific Device for SIP Trunk
	name	Video On Hold Server name
	pkid	Unique ID to identify a record.
voicemessagingpilot		null
	description	Cannot change system VM Pilot record except default setting
	directorynumber	Cannot change system VM Pilot record except default setting
	fkcallingsearchspace	Cannot change system VM Pilot record except default setting
	isdefault
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	tkreset	Set by DeviceReset stored procedure.
voicemessagingprofile		null
	description	Cannot change system VM Profile record except default setting
	fkvoicemessagingpilot	Cannot change system VM Profile record except default setting
	isdefault
	name	Cannot change system VM Profile record except default setting
	pkid	Unique ID to identify a record.
	resettoggle	Should this device or group be reset
	tkreset	Set by DeviceReset stored procedure.
	versionstamp	New guid plus seconds past midnight 1970 are concatenated
	voicemailboxmask	Cannot change system VM Profile record except default setting
vpngateway		VPN Head End (group of nodes sharing a URL for VPN access)
	description
	name
	pkid	Unique ID to identify VPNGateway record
	url
	versionstamp	New guid plus seconds past midnight 1970 are concatenated
vpngatewaycertificatemap		Certificates associated with each VPN Gateway (up to 10 per VPN Gateway)
	fkcertificate	References Certificate Record
	fkvpngateway	References VPNGateway Record
	pkid	Unique ID to identify VPNGatewayCertificateMap record
vpngroup		Ordered list of VPN Gateways (primary, secondary, etc.)
	description
	name
	pkid	Unique ID to identify VPNGroup record
	versionstamp	New guid plus seconds past midnight 1970 are concatenated
vpngroupvpngatewaymap		Members of each VPN Group)
	fkvpngateway	References VPNGateway Record
	fkvpngroup	References VPNGroup Record
	pkid	Unique ID to identify VPNGroupVPNGatewayMap record
	priority	Relative order of group members
vpnprofile		VPN Profile
	autonetworkdetect	The default is auto-network detection is disabled
	description
	enablehostidcheck	The default for EnableHostIDCheck is TRUE
	failtoconnect	The FailToConnect time specifies the maximum time to wait for TCP connect, SSL setup, and login/connect request/response. The value range is 0 to 600 seconds (10 minutes). The 0 value disables FailToConnect timeout. The default value is 30 seconds.
	mtu	MTU value allows the system administrator to set the maximum limit of MTU for the tunnel. The actual MTU used can be less than this value. The supported configurable MTU value range is 256 bytes to 1406 bytes. The default MTU on CNU operating system and the maximum supported MTU is 1290 bytes. If the phone is configured with the value larger than 1290 bytes, the maximum MTU allowed will still be 1290 bytes.
	name
	passwordpersistent	The default is password persistent is disabled
	pkid	Unique ID to identify VPNProfile record
	tkvpnclientauthentication	Reference to TypeVPNClientAuthentication Table:User And Password (0), Password Only (1), Certificate (2). Non-null.
	versionstamp	New guid plus seconds past midnight 1970 are concatenated
webpagesection		Stores provisioning administration web page section control information. The content of this table is maintained by CMUI team
	displayorder	Order of display sections with in a web page
	pkid	Unique identifier for the record
	tkwebpagedisplay	Reference to Web page Display
	tkwebpagesection	Reference to web page section
wifihotspotprofile		Hotspot Profile is used to send Wireless Hotspot configuration to phones that support the feature.
	authserver	Specifies Authentication Server in either IP address or HostName format
	authserverport	Port on which it makes the connection.
	description	Description of the Hotspot Profile.
	name	Name of the Hotspot Profile.
	passdescription	Used to recall forgotten password.
	passwordreverse	Used for digest authentication
	pkid	Unique ID to identify a record.
	ssidprefix	SSID
	tkhotspotauthenticationmethod	Type of Authentication used by Hotspot.
	tkwififrequency	Type of WiFi frequency used.
	tkwlanprofilechanges	Type of changes allowed to this Hotspot profile.
	versionstamp	New guid is generated every time this Hotspot Profile is updated
wirelesslanprofile		Wireless LAN Profile that can be associated to a wireless device.
	description	Description of the Wireless LAN Profile.
	fknetworkaccessprofile	Reference to Network Access profile for Wireless LAN profile.
	name	Name of the Wireless LAN Profile.
	passdescription	Used to recall forgotten password.
	passwordreverse	Used for digest authentication
	pkid	Unique ID to identify a record.
	ssid	SSID
	tkwifiauthenticationmethod	Type of Authentication used.
	tkwififrequency	Type of WiFi frequency used.
	tkwifiusercertificate	Type of UserCertificate for EAP-TLS AuthenticationMethod.
	tkwlanprofilechanges	Type of Wireless LAN Profile changes.
	userid	User identification name.
wirelesslanprofilegroup		Stores Wireless LAN Group details which can hold up to 4 Wireless LAN Profiles.
	description	Description of the Wireless LAN Profile Group.
	issystemdefault
	name	Name of the Wireless LAN Profile Group.
	pkid	Unique ID to identify a record.
	resettoggle	Should the devices associated to this Wireless LAN Profile Group be reset.
	versionstamp	New guid is generated every time this Wireless LAN Profile Group is updated
wirelesslanprofilegroupmember		Specifies which Wireless LAN Profiles are members of a particular Wireless LAN Group.
	fkwirelesslanprofile	Reference to Wireless LAN Profile.
	fkwirelesslanprofilegroup	Reference to Wireless LAN Profile Group.
	pkid	Unique ID to identify a record.
	sortorder	SortOrder
wsmdevice		Contains data for WSM Trunk implementation
	destinationaddress	ip address or Domain name of WSM device
	destinationport
	fkdevice
	pkid	Unique ID to identify a record.
wwwcookie		Used for cookie (and related stats) on browsers
	callbackdn
	pkid	Unique ID to identify a record.
xmldisplayinstancerulemap		Maps an XML display instance to an XML rule - both stored in scratch table
	fkscratch_displayinstance
	fkscratch_rule
	pkid	Unique ID to identify a record.