CREATE TABLE hrc_dl_all_parameters[ (
    PARAMETER_ID                 NUMBER(18, 0)     NOT NULL,
    PARAM_NAME                   VARCHAR2(120)     NOT NULL,
    PARAM_CATEGORY               VARCHAR2(120)     NOT NULL,
    PARAM_SET_TYPE               VARCHAR2(120) ,
    DEFAULT_VALUE                VARCHAR2(960) ,
    HSDL_DEFAULT_VALUE           VARCHAR2(960) ,
    HDL_ENABLED                  VARCHAR2(4)       NOT NULL,
    HDL_OVERRIDE_ENABLED         VARCHAR2(4)       NOT NULL,
    HSDL_ENABLED                 VARCHAR2(4)       NOT NULL,
    HSDL_OVERRIDE_ENABLED        VARCHAR2(4)       NOT NULL,
    HSDL_TEMPLATE_ENABLED        VARCHAR2(4)       NOT NULL,
    VALUE_DATA_TYPE              VARCHAR2(4)       NOT NULL,
    VALUE_MINIMUM                NUMBER(9, 0)  ,
    VALUE_MAXIMUM                NUMBER(9, 0)  ,
    VALUE_SUGGESTED_MAX          NUMBER(9, 0)  ,
    VALUE_MAX_LENGTH             NUMBER(9, 0)  ,
    VALUE_LOOKUP_TYPE            VARCHAR2(120) ,
    SET_COMMAND                  VARCHAR2(960) ,
    BUS_OBJ_TOP_DISCRIMINATOR    VARCHAR2(400) ,
    DISPLAY_CONDITION            VARCHAR2(4000),
    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) ,
    OBJECT_VERSION_NUMBER        NUMBER(9, 0)      NOT NULL,
    SEED_DATA_SOURCE             VARCHAR2(2048),
    ORA_SEED_SET1                VARCHAR2(4)       NOT NULL,
    ORA_SEED_SET2                VARCHAR2(4)       NOT NULL,
    RETENTION_METHOD             VARCHAR2(80)  ,
    ORIGINATING_PROCESS          VARCHAR2(120) 
);
