CREATE TABLE anc_job_configuration (
    JOB_CONFIGURATION_ID       NUMBER(18, 0) ,
    MODULE_ID                  VARCHAR2(128) ,
    BATCH_EXE_CD               VARCHAR2(120) ,
    JOB_CONFIGURATION_ALTCD    VARCHAR2(120) ,
    ENTERPRISE_ID              NUMBER(18, 0)     NOT NULL,
    THREAD_CNT_NUM             NUMBER(18, 0) ,
    MAX_ERR_NUM                NUMBER(18, 0) ,
    CHUNK_SIZE                 NUMBER(18, 0) ,
    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) ,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)      NOT NULL,
    SGUID                      VARCHAR2(128) ,
    SEED_DATA_SOURCE           VARCHAR2(2048),
    ORA_SEED_SET1              VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2              VARCHAR2(4)       NOT NULL,
    JOB_CONFIGURATION_ID       NUMBER(18, 0) ,
    MODULE_ID                  VARCHAR2(128) ,
    BATCH_EXE_CD               VARCHAR2(120) ,
    JOB_CONFIGURATION_ALTCD    VARCHAR2(120) ,
    ENTERPRISE_ID              NUMBER(18, 0)     NOT NULL,
    THREAD_CNT_NUM             NUMBER(18, 0) ,
    MAX_ERR_NUM                NUMBER(18, 0) ,
    CHUNK_SIZE                 NUMBER(18, 0) ,
    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) ,
    OBJECT_VERSION_NUMBER      NUMBER(9, 0)      NOT NULL,
    SGUID                      VARCHAR2(128) ,
    SEED_DATA_SOURCE           VARCHAR2(2048),
    ORA_SEED_SET1              VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2              VARCHAR2(4)       NOT NULL,
    CONSTRAINT pk_anc_job_configuration PRIMARY KEY (JOB_CONFIGURATION_ID, JOB_CONFIGURATION_ID)
);
