Oracle Fusion · Data dictionary
IRC_CMT_RECIPIENTS
SharedUsed in 0 subject areas22 reporting columnsBICC incremental-ready
Recruiting (IRC).
Primary key: not yet catalogued for IRC_CMT_RECIPIENTS — reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ADDRESS | ● | Address. | |
| ADDRESS_ID | ● | Identifier for the address. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| DELIVERY_TYPE_CODE | ● | Code identifying the delivery type. | |
| 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. | |
| LAUNCH_ID | ● | Identifier for the launch. | |
| MSG_BOUNCE_REASON | ● | Msg bounce reason. | |
| MSG_BOUNCE_TS | ● | Msg bounce ts. | |
| MSG_BOUNCE_TYPE_CODE | ● | Code identifying the msg bounce type. | |
| MSG_DELIVERY_TS | ● | Msg delivery ts. | |
| MSG_OPEN_TS | ● | Msg open ts. | |
| MSG_RETRY_COUNT | ● | Msg retry count. | |
| MSG_SENT_TS | ● | Msg sent ts. | |
| MSG_STATUS_CODE | ● | Code identifying the msg status. | |
| MSG_UNSENT_TYPE_CODE | ● | Code identifying the msg unsent type. | |
| OBJECT_VERSION_NUMBER | ● | Optimistic-locking version number, incremented on each update. | |
| PERSON_ID | ● | Identifier for the person. | |
| RECIPIENT_ID | ● | Identifier for the recipient. | |
| UMS_MSG_ID | ● | Identifier for the ums msg. |
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_CMT_RECIPIENTS?
We ship parameterized SQL, BICC config, and dbt models you own.