Oracle Fusion · Data dictionary
IRC_SEARCHES_DN
SharedUsed in 0 subject areas36 reporting columns
Recruiting (IRC).
Primary key: not yet catalogued for IRC_SEARCHES_DN, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| FILTER_ASSESSMENT_PACKAGE | ● | Filter assessment package. | |
| FILTER_ASSESSMENT_PERCENTILE | ● | Filter assessment percentile. | |
| FILTER_ASSESSMENT_RESULT | ● | Filter assessment result. | |
| FILTER_BASIC_INFO | ● | Filter basic info. | |
| FILTER_CANDIDATE_TYPE | ● | Type of filter candidate. | |
| FILTER_COMPANIES | ● | Filter companies. | |
| FILTER_DEGREES | ● | Filter degrees. | |
| FILTER_JOB | ● | Filter job. | |
| FILTER_LABEL | ● | Filter label. | |
| FILTER_LANGUAGE | ● | Filter language. | |
| FILTER_LAST_UPDATED_DATE | ● | Filter last updated date. | |
| FILTER_LICENSE | ● | Filter license. | |
| FILTER_LOCATIONS | ● | Filter locations. | |
| FILTER_OPT_IN_MKT_EMAILS_PREF | ● | Filter opt in mkt emails pref. | |
| FILTER_POOL | ● | Filter pool. | |
| FILTER_REHIRE_RECOMMENDATION | ● | Filter rehire recommendation. | |
| FILTER_SKILL | ● | Filter skill. | |
| FILTER_SOURCE | ● | Filter source. | |
| FILTER_SOURCE_MEDIUM | ● | Filter source medium. | |
| FILTER_YEARS_OF_EXP | ● | Filter years of exp. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | ● | Date and time the row was last updated (the incremental-extract key). | |
| LAST_UPDATE_LOGIN | ● | Session login of the user who last updated the row. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| PRECRITERIA_CAND_DETAILS | ● | Precriteria cand details. | |
| PRECRITERIA_COMPANY | ● | Precriteria company. | |
| PRECRITERIA_EDUCATION | ● | Precriteria education. | |
| PRECRITERIA_EXPERIENCE | ● | Precriteria experience. | |
| PRECRITERIA_LOCATION | ● | Precriteria location. | |
| SEARCHDN_ID | ● | Identifier for the searchdn. | |
| SEARCH_BY_EMAIL_FLAG | ● | Indicator (Y/N) for the search by email. | |
| SEARCH_BY_PHONE_FLAG | ● | Indicator (Y/N) for the search by phone. | |
| SEARCH_ID | ● | Identifier for the search. | |
| SEARCH_KEYWORDS | ● | Search keywords. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Subject areas
- ,
Need the extract + dbt staging for IRC_SEARCHES_DN?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table