CREATE TABLE irc_searches_dn (
    SEARCHDN_ID                      NUMBER        ,
    FILTER_REHIRE_RECOMMENDATION     VARCHAR2(800) ,
    FILTER_ASSESSMENT_PACKAGE        VARCHAR2(4000),
    FILTER_ASSESSMENT_RESULT         VARCHAR2(800) ,
    FILTER_ASSESSMENT_PERCENTILE     VARCHAR2(800) ,
    FILTER_ASSESSMENT_SCORE          VARCHAR2(4000),
    FILTER_ASSESSMENT_BAND           VARCHAR2(4000),
    FILTER_CITIZENSHIP               VARCHAR2(4000),
    SEARCH_ID                        NUMBER            NOT NULL,
    SEARCH_KEYWORDS                  VARCHAR2(4000),
    SEARCH_BY_RESUME_FLAG            VARCHAR2(4)   ,
    SEARCH_BY_EMAIL_FLAG             VARCHAR2(4)   ,
    SEARCH_MODE                      VARCHAR2(800) ,
    SEARCH_BY_PHONE_FLAG             VARCHAR2(4)   ,
    FILTER_LABEL                     VARCHAR2(3200),
    FILTER_OPT_IN_MKT_EMAILS_PREF    VARCHAR2(1200),
    FILTER_CANDIDATE_TYPE            VARCHAR2(800) ,
    FILTER_LOCATIONS                 VARCHAR2(3200),
    FILTER_DEGREES                   VARCHAR2(3200),
    FILTER_COMPANIES                 VARCHAR2(3200),
    FILTER_YEARS_OF_EXP              VARCHAR2(800) ,
    FILTER_LAST_UPDATED_DATE         VARCHAR2(800) ,
    PRECRITERIA_CAND_DETAILS         VARCHAR2(4000),
    PRECRITERIA_LOCATION             VARCHAR2(4000),
    PRECRITERIA_EDUCATION            VARCHAR2(4000),
    PRECRITERIA_EXPERIENCE           VARCHAR2(4000),
    PRECRITERIA_COMPANY              VARCHAR2(4000),
    FILTER_BASIC_INFO                VARCHAR2(4000),
    FILTER_SOURCE                    VARCHAR2(4000),
    FILTER_SOURCE_MEDIUM             VARCHAR2(4000),
    FILTER_POOL                      VARCHAR2(4000),
    FILTER_LANGUAGE                  VARCHAR2(4000),
    FILTER_LICENSE                   VARCHAR2(4000),
    FILTER_JOB                       VARCHAR2(4000),
    FILTER_SKILL                     VARCHAR2(4000),
    FILTER_REQUISITION               VARCHAR2(4000),
    FILTER_INTERACTIONS_TYPE         VARCHAR2(4000),
    FILTER_INTERACTIONS_DATE         VARCHAR2(800) ,
    FILTER_EVENT                     VARCHAR2(4000),
    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) ,
    SEARCHDN_ID                      NUMBER        ,
    SEARCH_ID                        NUMBER            NOT NULL,
    SEARCH_KEYWORDS                  VARCHAR2(4000),
    FILTER_CANDIDATE_TYPE            VARCHAR2(800) ,
    FILTER_LOCATIONS                 VARCHAR2(3200),
    FILTER_DEGREES                   VARCHAR2(3200),
    FILTER_COMPANIES                 VARCHAR2(3200),
    FILTER_YEARS_OF_EXP              VARCHAR2(800) ,
    FILTER_LAST_UPDATED_DATE         VARCHAR2(800) ,
    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) ,
    FILTER_REHIRE_RECOMMENDATION     VARCHAR2(800) ,
    FILTER_ASSESSMENT_PACKAGE        VARCHAR2(4000),
    FILTER_ASSESSMENT_RESULT         VARCHAR2(800) ,
    FILTER_ASSESSMENT_PERCENTILE     VARCHAR2(800) ,
    PRECRITERIA_CAND_DETAILS         VARCHAR2(4000),
    PRECRITERIA_LOCATION             VARCHAR2(4000),
    PRECRITERIA_EDUCATION            VARCHAR2(4000),
    PRECRITERIA_EXPERIENCE           VARCHAR2(4000),
    PRECRITERIA_COMPANY              VARCHAR2(4000),
    FILTER_BASIC_INFO                VARCHAR2(4000),
    FILTER_SOURCE                    VARCHAR2(4000),
    FILTER_SOURCE_MEDIUM             VARCHAR2(4000),
    FILTER_POOL                      VARCHAR2(4000),
    FILTER_LANGUAGE                  VARCHAR2(4000),
    FILTER_LICENSE                   VARCHAR2(4000),
    FILTER_JOB                       VARCHAR2(4000),
    FILTER_SKILL                     VARCHAR2(4000),
    SEARCH_BY_EMAIL_FLAG             VARCHAR2(4)   ,
    SEARCH_BY_PHONE_FLAG             VARCHAR2(4)   ,
    FILTER_LABEL                     VARCHAR2(3200),
    FILTER_OPT_IN_MKT_EMAILS_PREF    VARCHAR2(1200),
    FILTER_REQUISITION               VARCHAR2(4000),
    FILTER_EVENT                     VARCHAR2(4000),
    FILTER_ASSESSMENT_SCORE          VARCHAR2(4000),
    FILTER_ASSESSMENT_BAND           VARCHAR2(4000),
    FILTER_CITIZENSHIP               VARCHAR2(4000),
    SEARCH_BY_RESUME_FLAG            VARCHAR2(4)   ,
    SEARCH_MODE                      VARCHAR2(800) ,
    FILTER_INTERACTIONS_TYPE         VARCHAR2(4000),
    FILTER_INTERACTIONS_DATE         VARCHAR2(800) ,
    CONSTRAINT pk_irc_searches_dn PRIMARY KEY (SEARCHDN_ID, SEARCHDN_ID)
);
