CREATE TABLE cmp_tcs_per_row_values (
    PER_ROW_VALUE_ID          NUMBER(18, 0) ,
    STMT_PERD_ID              NUMBER(18, 0)     NOT NULL,
    PERD_RUN_ID               NUMBER(18, 0)     NOT NULL,
    PER_PERD_ID               NUMBER(18, 0)     NOT NULL,
    PER_PERD_STMT_ID          NUMBER(18, 0)     NOT NULL,
    CAT_ID                    NUMBER(18, 0)     NOT NULL,
    ROW_IN_CAT_ID             NUMBER(18, 0)     NOT NULL,
    PERSON_ID                 NUMBER(18, 0)     NOT NULL,
    LEGAL_ENTITY_ID           NUMBER(18, 0) ,
    ASSIGNMENT_ID             NUMBER(18, 0) ,
    DISPLAY_DATE              DATE          ,
    COLUMN1_NUM_VALUE         NUMBER        ,
    COLUMN1_TEXT_VALUE        VARCHAR2(4000),
    COLUMN1_DATE_VALUE        DATE          ,
    COLUMN1_UOM               VARCHAR2(120) ,
    COLUMN2_NUM_VALUE         NUMBER        ,
    COLUMN2_TEXT_VALUE        VARCHAR2(4000),
    COLUMN2_DATE_VALUE        DATE          ,
    COLUMN2_UOM               VARCHAR2(120) ,
    COLUMN3_NUM_VALUE         NUMBER        ,
    COLUMN3_TEXT_VALUE        VARCHAR2(4000),
    COLUMN3_DATE_VALUE        DATE          ,
    COLUMN3_UOM               VARCHAR2(120) ,
    COLUMN4_NUM_VALUE         NUMBER        ,
    COLUMN4_TEXT_VALUE        VARCHAR2(4000),
    COLUMN4_DATE_VALUE        DATE          ,
    COLUMN4_UOM               VARCHAR2(120) ,
    COLUMN5_NUM_VALUE         NUMBER        ,
    COLUMN5_TEXT_VALUE        VARCHAR2(4000),
    COLUMN5_DATE_VALUE        DATE          ,
    COLUMN5_UOM               VARCHAR2(120) ,
    BUSINESS_GROUP_ID         NUMBER(18, 0)     NOT NULL,
    REQUEST_ID                NUMBER(18, 0) ,
    JOB_ID                    NUMBER(18, 0) ,
    JOB_DEFINITION_NAME       VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE    VARCHAR2(3600),
    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) ,
    PER_ROW_VALUE_ID          NUMBER(18, 0) ,
    STMT_PERD_ID              NUMBER(18, 0)     NOT NULL,
    PERD_RUN_ID               NUMBER(18, 0)     NOT NULL,
    PER_PERD_ID               NUMBER(18, 0)     NOT NULL,
    PER_PERD_STMT_ID          NUMBER(18, 0)     NOT NULL,
    CAT_ID                    NUMBER(18, 0)     NOT NULL,
    ROW_IN_CAT_ID             NUMBER(18, 0)     NOT NULL,
    PERSON_ID                 NUMBER(18, 0)     NOT NULL,
    LEGAL_ENTITY_ID           NUMBER(18, 0) ,
    ASSIGNMENT_ID             NUMBER(18, 0) ,
    DISPLAY_DATE              DATE          ,
    COLUMN1_NUM_VALUE         NUMBER        ,
    COLUMN1_TEXT_VALUE        VARCHAR2(4000),
    COLUMN1_DATE_VALUE        DATE          ,
    COLUMN1_UOM               VARCHAR2(120) ,
    COLUMN2_NUM_VALUE         NUMBER        ,
    COLUMN2_TEXT_VALUE        VARCHAR2(4000),
    COLUMN2_DATE_VALUE        DATE          ,
    COLUMN2_UOM               VARCHAR2(120) ,
    COLUMN3_NUM_VALUE         NUMBER        ,
    COLUMN3_TEXT_VALUE        VARCHAR2(4000),
    COLUMN3_DATE_VALUE        DATE          ,
    COLUMN3_UOM               VARCHAR2(120) ,
    COLUMN4_NUM_VALUE         NUMBER        ,
    COLUMN4_TEXT_VALUE        VARCHAR2(4000),
    COLUMN4_DATE_VALUE        DATE          ,
    COLUMN4_UOM               VARCHAR2(120) ,
    COLUMN5_NUM_VALUE         NUMBER        ,
    COLUMN5_TEXT_VALUE        VARCHAR2(4000),
    COLUMN5_DATE_VALUE        DATE          ,
    COLUMN5_UOM               VARCHAR2(120) ,
    BUSINESS_GROUP_ID         NUMBER(18, 0)     NOT NULL,
    REQUEST_ID                NUMBER(18, 0) ,
    JOB_ID                    NUMBER(18, 0) ,
    JOB_DEFINITION_NAME       VARCHAR2(400) ,
    JOB_DEFINITION_PACKAGE    VARCHAR2(3600),
    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_cmp_tcs_per_row_values PRIMARY KEY (PER_ROW_VALUE_ID, PER_ROW_VALUE_ID)
);
