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 | 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 |
The DBID of the Tenant object. This is the primary key.
The DBID of the folder for the object.
Modified: 8.5.014.34 (data type changed from varchar to nvarchar)
The name of the object.
The object state. This corresponds to the CfgObjectState enumeration (Configuration Server). One of the following values:
#DICTIONARY TYPE 500
The status of the tenant. One of the following:
unable to determine record status.
#DICTIONARY TYPE 24
The GMT-equivalent date and time when the object was written to IDB. This is not necessarily the actual creation time of the object.
The GMT-equivalent date and time when the object was removed.
The GMT-equivalent date and time when the object was last changed (including object creation or removal).
The UTC-equivalent value of the CREATED field.
The UTC-equivalent value of the DELETED field.
The UTC-equivalent value of the LASTCHANGE field.
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.
System ID. Reserved for future use.
Reserved
Reserved
A flag indicating the reliability of timestamp information stored in the CREATED and DELETED fields. One of the following values:
Reserved
The field references an internal ID that Genesys Info Mart assigns to the upstream data source. Reserved for internal use.
Introduced: 8.5.015.19
Reserved for internal use.
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.
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.