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 |
|---|---|---|---|---|
| int | X | X | ||
| int | ||||
| nvarchar(255) | X | |||
| int | X | |||
| int | X | |||
| datetime | ||||
| datetime | ||||
| datetime | ||||
| int | ||||
| int | ||||
| int | ||||
| int | ||||
| int | ||||
| varchar(255) | ||||
| varchar(255) | ||||
| int | ||||
| int | ||||
| int | X | |||
| PRODUCER_BATCH_ID | numeric(19) | |||
| CREATE_AUDIT_KEY | numeric(19) | X | ||
| UPDATE_AUDIT_KEY | numeric(19) | X |
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.
LASTCHANGE
The GMT-equivalent date and time when the object was last changed (including object creation or removal).
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_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.
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.