CREATE TABLE hwm_tcd_exp_data_per_txn (
    TCD_EXP_DATA_PER_TXN_ID      NUMBER(18, 0),
    STATUS                       VARCHAR2(80) ,
    PERSON_DATA_ID               NUMBER(18, 0)    NOT NULL,
    PERSON_DATA_VERSION          NUMBER(9, 0)     NOT NULL,
    TCD_EXP_DATA_TXN_ID          NUMBER(18, 0)    NOT NULL,
    TCD_EXP_DATA_TXN_TYPE        VARCHAR2(60) ,
    TCD_EXP_DATA_TXN_BATCH_ID    NUMBER(9, 0)     NOT NULL,
    DELETE_FLAG                  VARCHAR2(4)  ,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)     NOT NULL,
    ENTERPRISE_ID                NUMBER(18, 0)    NOT NULL,
    CREATED_BY                   VARCHAR2(256)    NOT NULL,
    CREATION_DATE                TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY              VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE             TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN            VARCHAR2(128),
    TCD_EXP_DATA_PER_TXN_ID      NUMBER(18, 0),
    STATUS                       VARCHAR2(80) ,
    PERSON_DATA_ID               NUMBER(18, 0)    NOT NULL,
    PERSON_DATA_VERSION          NUMBER(9, 0)     NOT NULL,
    TCD_EXP_DATA_TXN_ID          NUMBER(18, 0)    NOT NULL,
    TCD_EXP_DATA_TXN_TYPE        VARCHAR2(60) ,
    TCD_EXP_DATA_TXN_BATCH_ID    NUMBER(9, 0)     NOT NULL,
    DELETE_FLAG                  VARCHAR2(4)  ,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)     NOT NULL,
    ENTERPRISE_ID                NUMBER(18, 0)    NOT NULL,
    CREATED_BY                   VARCHAR2(256)    NOT NULL,
    CREATION_DATE                TIMESTAMP(6)     NOT NULL,
    LAST_UPDATED_BY              VARCHAR2(256)    NOT NULL,
    LAST_UPDATE_DATE             TIMESTAMP(6)     NOT NULL,
    LAST_UPDATE_LOGIN            VARCHAR2(128),
    CONSTRAINT pk_hwm_tcd_exp_data_per_txn PRIMARY KEY (TCD_EXP_DATA_PER_TXN_ID, TCD_EXP_DATA_PER_TXN_ID)
);
