Manualsbrain.com
  1. Manuals
  2. Brands
  3. Cisco
  4. Cisco IPCC Web Option
  5. Technical References

Cisco Cisco IPCC Web Option Technical References

Download
Page of 404
 
2-115
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Ids Table
Ids Table
Indicates whether a specific object type supports row-level security. For those object types that do 
support row-level security, the Ids table contains one row for each object of that type.
Related tables:
Object List (via ObjectType)
Object Security (via ObjectType + ObjectID)
User Security Control (via ObjectType+ ObjectID)
Import_Log Table
Central database only.
Contains information about schedule import operations that have been performed. The ICM software 
automatically creates an Import_Log row each time it imports schedule information.
Table 2-93 Ids Table
Field Name
Description
Data Type
Keys and Null 
Option
ObjectType
Identifies the object type. 
int
PK, FK, NOT 
NULL
ObjectID
Identifies a specific object for which row-level security is 
supported. If the object type does not support row-level 
security, this value is 0.
int
PK, NOT NULL
ParentObjectType
Identifies the object type of the object’s parent. For example, 
a peripheral is a parent to its trunk groups. A value of 0 
indicates that the object has no parent.
int
NOT NULL
ParentObjectID
Identifies the object’s parent. A value of 0 indicates that the 
object has no parent.
int
NOT NULL
Table 2-94 Import_Log Table
Field Name
Description
Data Type
Keys and Null 
Option
DateTime
The date and time when the row was generated.
datetime
PK, NOT NULL
ScheduleID
Identifies the schedule affected.
int
PK, FK, NOT 
NULL
TimeZone
The time zone for the date and time. The value is the 
offset in minutes from GMT.
int
PK, NOT NULL
LogOperation
The operation that was logged; for example Import or 
Edit.
varchar(32)
NOT NULL
WorkstationName
The workstation from which data was imported.
varchar(32)
NOT NULL
RowsCopied
The number of rows imported or modified.
int
NOT NULL