Cisco Cisco IP Contact Center Release 4.6.1 Technical References

Page of 404
 
2-136
Cisco ICM Software Database Schema Handbook
78-11677-04
Chapter 2      Table Details
Next_Available_Number Table
Next_Available_Number Table
Each row identifies the next available unique integer ID value for a specific database table.
The ICM software automatically maintains the Next_Available_Number table.
Object_Access_Xref Table
Lists the access levels available for each object type.
Related tables:
Object List (via ObjectType)
Object_List Table
Lists the objects that are available.
Table 2-114 Next_Available_Number Table
Field Name
Description
Data Type
Keys and Null 
Option
TableName
The name of the table associated with the row.
varchar(30)
AK1, NOT 
NULL
NextAvailableNumber
The next available unique ID value for the table.
int
NOT NULL
Table 2-115 Object_Access_Xref Table
Field Name
Description
Data Type
Keys and Null 
Option
ObjectAccessXrefID
A unique identifier for the record.
int
PK, NOT NULL
ObjectType
Identifies the object type. 
int
AK1, NOT 
NULL
AccessLevel
Indicates an access level supported by the object type. 
int
AK1, NOT 
NULL
Table 2-116 Object_List Table
Field Name
Description
Data Type
Keys and Null 
Option
ObjectType
A unique identifier for the object type. 
int
PK, NOT NULL
Name
The name of the object.
varchar(30)
AK1, NOT 
NULL
Description
Additional information about the object.
varchar(255)
NOT NULL