Table GIDB_GC_SKILL

Description

Modified: 8.5.015.19 (PRODUCER_BATCH_ID column added); 8.5.014.34 (data type for various columns modified)

This table stores information about the configuration of Skill objects.

The SKILL view is based on this table.

Column List

Column	Data Type	P	M	F
ID	int	X	X
NAME	nvarchar(255)		X
TENANTID	int		X	X
FOLDERID	int
STATE	int		X
STATUS	int		X
CREATED	datetime
DELETED	datetime
LASTCHANGE	datetime
CREATED_TS	int
DELETED_TS	int
LASTCHANGE_TS	int
GSYS_DOMAIN	int
GSYS_SYS_ID	int
GSYS_EXT_VCH1	varchar(255)
GSYS_EXT_VCH2	varchar(255)
GSYS_EXT_INT1	int
GSYS_EXT_INT2	int
DATA_SOURCE_KEY	int		X
PRODUCER_BATCH_ID	numeric(19)
CREATE_AUDIT_KEY	numeric(19)		X
UPDATE_AUDIT_KEY	numeric(19)		X

ID

The DBID of the Skill object. This is the primary key.

>> Back to Column List

NAME

Modified: 8.5.014.34 (data type changed from varchar to nvarchar)

The name of the Skill object.

>> Back to Column List

TENANTID

The DBID of the Tenant to which this object belongs.

>> Back to Column List

FOLDERID

The DBID of the Folder for the object.

>> Back to Column List

STATE

The object state. This corresponds to the CfgObjectState enumeration (Configuration Server). One of the following values:

• 0—Unknown. Reserved for when ICON is unable to determine object state.
• 1—Enabled.
• 2—Disabled.

#DICTIONARY TYPE 500

>> Back to Column List

STATUS

The status of the object described by the record. One of the following values:

• 0—The status is unknown. Reserved for when ICON is unable to determine record status.
• 1—Record is active.
• 2—Record is inactive (object is deleted).
• 10—Synchronization is in progress for an active record.

#DICTIONARY TYPE 24

>> Back to Column List

CREATED

The GMT-equivalent date and time when the object was written to IDB. This is not necessarily the actual creation time of the object.

>> Back to Column List

DELETED

The GMT-equivalent date and time when this object was removed.

>> Back to Column List

LASTCHANGE

The GMT-equivalent date and time when the object was last changed (including object creation or removal).

>> Back to Column List

CREATED_TS

The UTC-equivalent value of the CREATED field.

>> Back to Column List

DELETED_TS

The UTC-equivalent value of the DELETED field.

>> Back to Column List

LASTCHANGE_TS

The UTC-equivalent value of the LASTCHANGE field.

>> Back to Column List

GSYS_DOMAIN

Contains the data source session ID (DSS_ID) for the session that was active when the data was processed by ICON. For more information, see the description in System Fields.

>> Back to Column List

GSYS_SYS_ID

System ID. Reserved for future use.

>> Back to Column List

GSYS_EXT_VCH1

Reserved

>> Back to Column List

GSYS_EXT_VCH2

Reserved

>> Back to Column List

GSYS_EXT_INT1

A flag indicating the reliability of timestamp information stored in the CREATED and DELETED fields. One of the following values:

• 0—Highly reliable; timestamps for both fields are taken from Configuration Server runtime notifications or the Configuration Server history log.
• 1—CREATED timestamp is that of the time when configuration data was requested from Configuration Server, either during the initial ICON startup or during synchronization.
• 2—DELETED timestamp is that of the time when configuration data was requested from Configuration Server; either during the initial ICON startup or during synchronization.
• 3—Both CREATED and DELETED timestamps are taken from the time when configuration data was requested from Configuration Server, either during the initial ICON startup or during synchronization.

>> Back to Column List

GSYS_EXT_INT2

Reserved

>> Back to Column List

DATA_SOURCE_KEY

The field references an internal ID that Genesys Info Mart assigns to the upstream data source. Reserved for internal use.

>> Back to Column List

PRODUCER_BATCH_ID

Introduced: 8.5.015.19

Reserved for internal use.

CREATE_AUDIT_KEY

The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data creation. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools — that is, applications that need to identify newly added data.

>> Back to Column List

UPDATE_AUDIT_KEY

The surrogate key that is used to join to the CTL_AUDIT_LOG control table. The key specifies the lineage for data update. This value can be useful for aggregation, enterprise application integration (EAI), and ETL tools — that is, applications that need to identify recently modified data.

>> Back to Column List