Oracle Fusion · Data dictionary
IRC_SUBMISSIONS
SharedUsed in 0 subject areas37 reporting columnsBICC incremental-ready
Recruiting (IRC).
Likely primary key: SUBMISSION_ID (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): AF_VERSION_ID → IRC_AF_VERSIONS · PROFILE_ID → HRT_PROFILES_B · REQUISITION_ID → IRC_REQUISITIONS_B
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ACTIVE_FLAG | ● | Indicator (Y/N) for the active. | |
| ADDED_BY_CONTEXT_CODE | ● | Code identifying the added by context. | |
| ADDED_BY_PERSON_ID | ● | Identifier for the added by person. | |
| AF_VERSION_ID | ● | Identifier for the af version. | |
| CONFIRMED_BY_PERSON_ID | ● | Identifier for the confirmed by person. | |
| CONFIRMED_FLAG | ● | Indicator (Y/N) for the confirmed. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| CURRENT_PHASE_ID | ● | Identifier for the current phase. | |
| CURRENT_STATE_ID | ● | Identifier for the current state. | |
| DISCARDED_FLAG | ● | Indicator (Y/N) for the discarded. | |
| DISQUALIFIED_FLAG | ● | Indicator (Y/N) for the disqualified. | |
| ESIGN_DESC_VERSION_ID | ● | Identifier for the esign description version. | |
| INTERNAL_FLAG | ● | Indicator (Y/N) for the internal. | |
| IS_COMPLETED_FLAG | ● | Indicator (Y/N) for the is completed. | |
| IS_RESTRICTED_FLAG | ● | Indicator (Y/N) for the is restricted. | |
| LAST_UPDATED_BY | ● | User who last updated the row. | |
| LAST_UPDATE_DATE | INCR | ● | 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. | |
| LEGAL_DESC_VERSION_ID | ● | Identifier for the legal description version. | |
| MERGED_FLAG | ● | Indicator (Y/N) for the merged. | |
| OBJECT_STATUS | ● | Status of the object. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| PERSON_ID | ● | Identifier for the person. | |
| PIPELINE_SUBMISSION_ID | ● | Identifier for the pipeline submission. | |
| PROCESS_ID | ● | Identifier for the process. | |
| PROFILE_ID | ● | Identifier for the profile. | |
| PUBLIC_STATE_ID | ● | Identifier for the public state. | |
| QSTNR_SCORE | ● | Qstnr score. | |
| REQUISITION_ID | ● | Identifier for the requisition. | |
| SITE_NUMBER | ● | Site number. | |
| SUBMISSION_CONFIRMED_DATE | ● | Submission confirmed date. | |
| SUBMISSION_DATE | ● | Submission date. | |
| SUBMISSION_ID | PK? | ● | Identifier for the submission. |
| SUBMISSION_LANGUAGE_CODE | ● | Code identifying the submission language. | |
| SUBM_LAST_MODIFIED_DATE | ● | Subm last modified date. | |
| SYSTEM_PERSON_TYPE | ● | Type of system person. |
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_SUBMISSIONS?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table