CREATE TABLE hrc_comp_inst_vals_b (
    INSTANCE_VALUE_ID        NUMBER(18, 0)     NOT NULL,
    ENTERPRISE_ID            NUMBER(18, 0)     NOT NULL,
    IKEY                     VARCHAR2(512)     NOT NULL,
    INSTANCE_ID              NUMBER(18, 0)     NOT NULL,
    TEMPLATE_ID              NUMBER(18, 0)     NOT NULL,
    ITEM_ID                  NUMBER(18, 0) ,
    CAT_DEF_VAL_ID           NUMBER(18, 0) ,
    OPT_DEF_VAL_ID           NUMBER(18, 0) ,
    SUGV_FLAG                VARCHAR2(120)     NOT NULL,
    VALUE_TYPE               VARCHAR2(120)     NOT NULL,
    VALUE_NAME               VARCHAR2(512) ,
    VALUE_DATATYPE           VARCHAR2(120)     NOT NULL,
    VALUE_VARCHAR2           VARCHAR2(4000),
    VALUE_NUMBER             NUMBER(18, 0) ,
    VALUE_TIMESTAMP          TIMESTAMP(6)  ,
    VALUE_DATE               DATE          ,
    VALUE_BLOB               BLOB          ,
    VALUE_CLOB               CLOB          ,
    VALUE_SKID               NUMBER(18, 0) ,
    FOOTNOTE_REFS            VARCHAR2(4000),
    ATTR_CHAR1               VARCHAR2(4000),
    ATTR_CHAR2               VARCHAR2(4000),
    ATTR_CHAR3               VARCHAR2(4000),
    ATTR_NUMBER1             NUMBER(18, 0) ,
    ATTR_NUMBER2             NUMBER(18, 0) ,
    ATTR_NUMBER3             NUMBER(18, 0) ,
    ATTR_DATE1               DATE          ,
    ATTR_DATE2               DATE          ,
    ATTR_DATE3               DATE          ,
    OBJECT_VERSION_NUMBER    NUMBER(9, 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) ,
    INSTANCE_VALUE_ID        NUMBER(18, 0)     NOT NULL,
    ENTERPRISE_ID            NUMBER(18, 0)     NOT NULL,
    IKEY                     VARCHAR2(512)     NOT NULL,
    INSTANCE_ID              NUMBER(18, 0)     NOT NULL,
    TEMPLATE_ID              NUMBER(18, 0)     NOT NULL,
    ITEM_ID                  NUMBER(18, 0) ,
    CAT_DEF_VAL_ID           NUMBER(18, 0) ,
    OPT_DEF_VAL_ID           NUMBER(18, 0) ,
    SUGV_FLAG                VARCHAR2(120)     NOT NULL,
    VALUE_TYPE               VARCHAR2(120)     NOT NULL,
    VALUE_NAME               VARCHAR2(512) ,
    VALUE_DATATYPE           VARCHAR2(120)     NOT NULL,
    VALUE_VARCHAR2           VARCHAR2(4000),
    VALUE_NUMBER             NUMBER(18, 0) ,
    VALUE_TIMESTAMP          TIMESTAMP(6)  ,
    VALUE_DATE               DATE          ,
    VALUE_BLOB               BLOB          ,
    VALUE_CLOB               CLOB          ,
    VALUE_SKID               NUMBER(18, 0) ,
    FOOTNOTE_REFS            VARCHAR2(4000),
    ATTR_CHAR1               VARCHAR2(4000),
    ATTR_CHAR2               VARCHAR2(4000),
    ATTR_CHAR3               VARCHAR2(4000),
    ATTR_NUMBER1             NUMBER(18, 0) ,
    ATTR_NUMBER2             NUMBER(18, 0) ,
    ATTR_NUMBER3             NUMBER(18, 0) ,
    ATTR_DATE1               DATE          ,
    ATTR_DATE2               DATE          ,
    ATTR_DATE3               DATE          ,
    OBJECT_VERSION_NUMBER    NUMBER(9, 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) 
);
