Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key

Table GC_GROUP


This table stores information about agent group, place group, and DN group configuration objects.

Column List

Legend

Column Data Type P M F Description

ID

INTEGER X X The DBID of the Group object. This is the primary key.

Name

VARCHAR2(255) X The name of the object.

TenantID

INTEGER X X The DBID of the Tenant to which this object belongs.

FolderID

INTEGER The DBID of the Folder for the object.

Type

INTEGER X The type of the Group corresponding to the CfgGroupType enumeration in Configuration Server. One of the following values:
  • 0—Unknown Group Type
  • 1—Agent Group
  • 2—Place Group
  • 3—DN Group
  • 4—Access Group

#DICTIONARY TYPE 540

DNGroupType

INTEGER The type of DN Group corresponding to the CfgDNGroupType enumeration in Configuration Server. This is applicable only to DN group records. Refer to G_Dictionary Values for a listing of permissible values.

#DICTIONARY TYPE 508

State

INTEGER X The object state corresponding to the CfgObjectState enumeration in 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

Script

VARCHAR2(255) The Virtual Agent Group script expression. This is applicable only to Agent Group objects.

Status

INTEGER X The status of 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

Created

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

Deleted

TIMESTAMP(3) The GMT-equivalent date and time when this object was removed.

LastChange

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

Created_ts

INTEGER The UTC-equivalent value of the CREATED field.

Created_tcode

INTEGER A reference, derived from the value of the CREATED_TS field, to a record in the G_TIMECODE table.

Deleted_ts

INTEGER The UTC-equivalent value of the DELETED field.

Deleted_tcode

INTEGER A reference, derived from the value of the DELETED_TS field, to a record in the G_TIMECODE table.

LastChange_ts

INTEGER The UTC-equivalent value of the LASTCHANGE field.

LastChange_tcode

INTEGER A reference, derived from the value of the LASTCHANGE_TS field, to a record in the G_TIMECODE table.

GSYS_DOMAIN

INTEGER 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.

GSYS_PARTITION

INTEGER A key that is used for partitioning.

GSYS_SYS_ID

INTEGER System ID. Reserved for future use.

GSYS_SEQ

INTEGER Insert Sequence. Not unique.

GSYS_USEQ

INTEGER Update Sequence. Not unique.

GSYS_TS

TIMESTAMP(3) Reserved

GSYS_TC

INTEGER Reserved

GSYS_EXT_VCH1

VARCHAR2(255) Reserved

GSYS_EXT_VCH2

VARCHAR2(255) Reserved

GSYS_EXT_INT1

INTEGER 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.

GSYS_EXT_INT2

INTEGER Reserved

   

 

Comment on this article:

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