UOW Table

The unit of work table is used by the system to logically group individual items together. It allows users to view duplicate items for a particular unit of work and to delete units of work. The UOW table contains only system columns and must be created as defined below. There should be one UOW table for each namespace.

CREATE TABLE UOW
(
   SYS_UOW_ID              BIGINT          NOT NULL
                                           GENERATED ALWAYS AS IDENTITY,
   SYS_GROUP_ID            VARCHAR(64)     NOT NULL,
   SYS_UOW_NAME            VARCHAR(128),
   SYS_CLIENT_ID           VARCHAR(64),
   SYS_ENTERED_DATE        TIMESTAMP,
   SYS_EXPIRY_DATE         TIMESTAMP,
   SYS_UOW_SIZE            INTEGER,
   SYS_REMAIN_ITEMS        INTEGER,
   SYS_REMAIN_REVIEW       INTEGER,
   SYS_BATCH_MODE          SMALLINT        WITH DEFAULT 1,
   SYS_PRES_GRP_ID         DECIMAL(19,0)   WITH DEFAULT NULL,
   SYS_PRES_ID             DECIMAL(19,0)   WITH DEFAULT NULL,
   SYS_DEBIT_AMT           DECIMAL(15,0)   WITH DEFAULT NULL,
   SYS_CREDIT_AMT          DECIMAL(15,0)   WITH DEFAULT NULL,
   SYS_BUS_DATE            TIMESTAMP       WITH DEFAULT NULL,
   SYS_PRES_RECEIPT_TIME   TIMESTAMP       WITH DEFAULT NULL,
   SYS_PARTNER_ID          CHAR(10)        FOR MIXED DATA WITH DEFAULT NULL,
   SYS_PRODUCT_NAME        VARCHAR(80)     FOR MIXED DATA WITH DEFAULT NULL,
   SYS_REPLY_DEST          VARCHAR(2500)   FOR BIT DATA,

   CONSTRAINT UOW_PK PRIMARY KEY (SYS_UOW_ID),
   CONSTRAINT UOW_KEY UNIQUE (SYS_GROUP_ID)

);
CREATE INDEX UOW_EXPIRY ON UOW ( SYS_EXPIRY_DATE ) ALLOW REVERSE SCANS;