Jump to: navigation, search

Table GIDB_GC_TENANT

Description

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

The table stores information about Tenant configuration objects.

The TENANT view is based on this table.

Column List

Column Data Type P M F

ID

int X X

FOLDERID

int

NAME

nvarchar(255) X

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 Tenant object. This is the primary key.

FOLDERID

The DBID of the folder for the object.

NAME

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

The name of the object.

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

STATUS

The status of the tenant. One of the following:

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

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

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

LASTCHANGE

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

CREATED_TS

The UTC-equivalent value of the CREATED field.

DELETED_TS

The UTC-equivalent value of the DELETED field.

LASTCHANGE_TS

The UTC-equivalent value of the LASTCHANGE field.

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.

GSYS_SYS_ID

System ID. Reserved for future use.

GSYS_EXT_VCH1

Reserved

GSYS_EXT_VCH2

Reserved

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.

GSYS_EXT_INT2

Reserved

DATA_SOURCE_KEY

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

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.

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.

This page was last edited on August 10, 2017, at 13:43.

Feedback

Comment on this article:

blog comments powered by Disqus