Jump to: navigation, search

In the Column List:

  • P = Primary key
  • M = Mandatory field
  • F = Foreign key
  • In the Data Type column, varchar/nvarchar means that the data type is varchar except in multi-language databases that use Unicode, in which case the data type is nvarchar. (The Info Mart database in Cloud deployments is not multi-language.)

Table GCX_SUBCODE


This table stores information about associations of Action Codes to Subcodes, including terminated associations.

Column List

Legend

Column Data Type P M F Description

ID

numeric(16) X X The unique, autonumbered ID of this record. This is the primary key.

CodeID

int X X The DBID of the Action Code object that is associated with the subcode.

Name

varchar(255) X Subcode name

Code

varchar(255) X Subcode ID

Status

int X 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—ynchronization is in progress for an active record.

#DICTIONARY TYPE 24

Created

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

Deleted

datetime The GMT-equivalent date and time when this record was deleted.

Created_ts

int The UTC-equivalent value of the CREATED field.

Created_tcode

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

Deleted_ts

int The UTC-equivalent value of the DELETED field.

Deleted_tcode

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

GSYS_DOMAIN

int 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

int A key that is used for partitioning.

GSYS_SYS_ID

int System ID. Reserved for future use.

GSYS_SEQ

bigint Insert Sequence. Not unique.

GSYS_USEQ

bigint Update Sequence. Not unique.

GSYS_TS

datetime Reserved

GSYS_TC

int Reserved

GSYS_EXT_VCH1

varchar(255) Reserved

GSYS_EXT_VCH2

varchar(255) Reserved

GSYS_EXT_INT1

int 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

int Reserved


Index List

Index Name U C

IDX_SUBCODE

 

 

Feedback

Comment on this article:

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