STAGLOG

This table holds changes made on the Authoring or Staging environment that can be propagated to the Production Server using the StagingProp utility.

Column Descriptions:

NameTypeDescription
STGRFNBRBIGINT NOT NULLThe reference number for the staging row.
STGSTMPTIMESTAMP NOT NULLTime stamp at which change was recorded.
STGTABLECHAR (30) NOT NULLName of staged table for which change occurred.
STGOPCHAR (1) NOT NULLChange operator:
  • I = insert
  • U = update
  • D = delete
STGMENBRNAMECHAR (32)Reserved for HCL internal use.
STGMENBRINTEGERIndicates whether record is of merchant or site scope:
  • 0 = site scope
  • 1 = merchant scope
STGPKEYNAMECHAR (32)Reserved for HCL internal use.
STGPKEYBIGINTReserved for HCL internal use.
STGKEY1NAMECHAR (32)Name of only primary-key column of table identified by STGTABLE or Name of 1 of (up to) 5 columns in composite primary-key of table identified by STGTABLE
STGKEY2NAMECHAR (32)Name of only primary-key column of table identified by STGTABLE or Name of 1 of (up to) 5 columns in composite primary-key of table identified by STGTABLE
STGKEY3NAMECHAR (32)Name of only primary-key column of table identified by STGTABLE or Name of 1 of (up to) 5 columns in composite primary-key of table identified by STGTABLE
STGKEY4NAMECHAR (32)Name of only primary-key column of table identified by STGTABLE or Name of 1 of (up to) 5 columns in composite primary-key of table identified by STGTABLE
STGKEY5NAMECHAR (32)Name of only primary-key column of table identified by STGTABLE or Name of 1 of (up to) 5 columns in composite primary-key of table identified by STGTABLE
STGOKEY1BIGINTOld value in column identified by STGKEY1NAME.
STGOKEY2BIGINTOld value in column identified by STGKEY2NAME.
STGOKEY3VARCHAR (254)Old value in column identified by STGKEY3NAME.
STGOKEY4BIGINTOld value in column identified by STGKEY4NAME.
STGOKEY5VARCHAR (254)Old value in column identified by STGKEY5NAME.
STGNKEY1BIGINTNew value in column identified by STGKEY1NAME.
STGNKEY2BIGINTNew value in column identified by STGKEY2NAME.
STGNKEY3VARCHAR (254)New value in column identified by STGKEY3NAME.
STGNKEY4BIGINTNew value in column identified by STGKEY4NAME.
STGNKEY5VARCHAR (254)New value in column identified by STGKEY5NAME.
STGPROCESSEDINTEGER DEFAULT 0Indicates whether record has been processed by StagingProp:
  • -5 = primary-key for table specified in STGTABLE column not found in physical table on staging database
  • -4 = error encountered during consolidation when consolidation-error-toleration is enabled
  • -3 = error encountered during propagation of 'I' record when action-on-error semantics are enabled
  • -2 = error encountered during propagation of 'U' record when action-on-error semantics are enabled
  • -1 = error encountered during propagation of 'D' record when action-on-error semantics are enabled
  • 0 = not processed
  • 1 = processed
STGRESERVED1INTEGER DEFAULT 0Reserved for HCL internal use.
STGLDPTHVARCHAR (254)Reserved for HCL internal use.
STGLDCOLSVARCHAR (4000)Reserved for HCL internal use.
STGFILTERBIGINTThis column is used to propagate data by filter value. When StagingProp is invoked with -filter <n> (and -filtercolumn <s> is not specified), only records whose STGFILTER value matches <n> will be propagated.
OPTCOUNTERSMALLINT NOT NULL DEFAULT 0The optimistic concurrency control counter for the table. Every time there is an update to the table, the counter is incremented.

Indexes:

NameColumn NamesType
<SYSTEM-GENERATED>STGRFNBRPrimary Key
I0001457STGTABLE+STGPROCESSED+STGSTMP+STGRFNBRNon-Unique Index
I0001458STGPROCESSED+STGSTMP+STGRFNBRNon-Unique Index
I0001538STGTABLE+STGPROCESSED+STGRFNBR+STGSTMPNon-Unique Index