Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key
  • In the Data Type column, varchar/nvarchar means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar.

Table G_SAMPLE_CUST_ADATA


This sample table stores attached call data from a custom attached data dispatcher.

Tip
To assist you in preparing supplementary documentation, click the following link to download a comma-separated text file containing information such as the data types and descriptions for all columns in this table: Download a CSV file.

Hint: For easiest viewing, open the downloaded CSV file in Excel and adjust settings for column widths, text wrapping, and so on as desired. Depending on your browser and other system settings, you might need to save the file to your desktop first.

Column List

Legend

Column Data Type P M F Description
ID numeric(16) X X The unique, autonumbered ID of this record. This is the primary key.
CALLID varchar(50) X Global unique call ID.
CALL_TS int X The timestamp of call creation.
Switch_ID int X The DBID of the Switch configuration object in Configuration Server where the call was observed.
Tenant_ID int X The DBID of the Tenant where the Switch is configured.
C_INT_1 int The integer value of attached data key.
C_INT_2 int The integer value of attached data key.
C_INT_3 int The integer value of attached data key.
C_INT_4 int The integer value of attached data key.
C_INT_5 int The integer value of attached data key.
C_INT_6 int The integer value of attached data key.
C_INT_7 int The integer value of attached data key.
C_INT_8 int The integer value of attached data key.
C_INT_9 int The integer value of attached data key.
C_INT_10 int The integer value of attached data key.
C_INT_11 int The integer value of attached data key.
C_INT_12 int The integer value of attached data key.
C_INT_13 int The integer value of attached data key.
C_INT_14 int The integer value of attached data key.
C_INT_15 int The integer value of attached data key.
C_INT_16 int The integer value of attached data key.
C_INT_17 int The integer value of attached data key.
C_INT_18 int The integer value of attached data key.
C_INT_19 int The integer value of attached data key.
C_INT_20 int The integer value of attached data key.
C_INT_21 int The integer value of attached data key.
C_INT_22 int The integer value of attached data key.
C_INT_23 int The integer value of attached data key.
C_INT_24 int The integer value of attached data key.
C_INT_25 int The integer value of attached data key.
C_INT_26 int The integer value of attached data key.
C_INT_27 int The integer value of attached data key.
C_INT_28 int The integer value of attached data key.
C_INT_29 int The integer value of attached data key.
C_INT_30 int The integer value of attached data key.
C_INT_31 int The integer value of attached data key.
C_INT_32 int The integer value of attached data key.
C_INT_33 int The integer value of attached data key.
C_INT_34 int The integer value of attached data key.
C_STR_1 varchar(10) The string value of the call attached data key.
C_STR_2 varchar(10) The string value of the call attached data key.
C_STR_3 varchar(10) The string value of the call attached data key.
C_STR_4 varchar(10) The string value of the call attached data key.
C_STR_5 varchar(10) The string value of the call attached data key.
C_STR_6 varchar(10) The string value of the call attached data key.
C_STR_7 varchar(10) The string value of the call attached data key.
C_STR_8 varchar(10) The string value of the call attached data key.
C_STR_9 varchar(10) The string value of the call attached data key.
C_STR_10 varchar(10) The string value of the call attached data key.
C_STR_11 varchar(10) The string value of the call attached data key.
C_STR_12 varchar(10) The string value of the call attached data key.
C_STR_13 varchar(10) The string value of the call attached data key.
C_STR_14 varchar(10) The string value of the call attached data key.
C_STR_15 varchar(10) The string value of the call attached data key.
C_STR_16 varchar(10) The string value of the call attached data key.
C_STR_17 varchar(10) The string value of the call attached data key.
C_STR_18 varchar(10) The string value of the call attached data key.
C_STR_19 varchar(10) The string value of the call attached data key.
C_STR_20 varchar(10) The string value of the call attached data key.
C_STR_21 varchar(10) The string value of the call attached data key.
C_STR_22 varchar(10) The string value of the call attached data key.
C_STR_23 varchar(10) The string value of the call attached data key.
C_STR_24 varchar(10) The string value of the call attached data key.
C_STR_25 varchar(10) The string value of the call attached data key.
C_STR_26 varchar(10) The string value of the call attached data key.
C_STR_27 varchar(10) The string value of the call attached data key.
C_STR_28 varchar(10) The string value of the call attached data key.
C_STR_29 varchar(10) The string value of the call attached data key.
C_STR_30 varchar(10) The string value of the call attached data key.
C_STR_31 varchar(10) The string value of the call attached data key.
C_STR_32 varchar(10) The string value of the call attached data key.
C_STR_33 varchar(10) The string value of the call attached data key.
C_STR_34 varchar(10) The string value of the call attached data key.
GSYS_DOMAIN int Reserved
GSYS_PARTITION int A key that is used for partitioning.
GSYS_SYS_ID int System ID. Reserved for future use.
GSYS_SEQ bigint Insert Sequence. Not unique.
GSYS_USEQ bigint Update Sequence. Not unique.
GSYS_TS datetime Reserved
GSYS_TC int Reserved
GSYS_EXT_VCH1 varchar(255) Reserved
GSYS_EXT_VCH2 varchar(255) Reserved
GSYS_EXT_INT1 int Reserved
GSYS_EXT_INT2 int Reserved
This page was last edited on January 10, 2020, at 15:27.
Comments or questions about this documentation? Contact us for support!