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. (The Info Mart database in Cloud deployments is not multi-language.)

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


Index List

Index Name U C

IDX_G_SAMPLE_CDATA_TS

 

 

Feedback

Comment on this article:

blog comments powered by Disqus
This page was last modified on October 31, 2016, at 15:02.