What is the primary key of IRC_CAMPAIGNS_B?

CAMPAIGN_ID (likely, inferred from column markers)

Where is IRC_CAMPAIGNS_B used in reporting?

It appears in 0 OTBI subject areas.

Oracle Fusion · Data dictionary

SharedUsed in 0 subject areas20 reporting columnsBICC incremental-ready

Recruiting (IRC), base table, language-neutral data (paired with _TL labels and the _VL view).

Likely primary key: CAMPAIGN_ID (inferred from Oracle naming conventions, verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE

Column	Key	In reports	Description (inferred)
ACTIVATED_ON_DATE		●	Activated on date.
AUDIENCE_POPULATED_FLAG		●	Indicator (Y/N) for the audience populated.
AUDIENCE_SAVED_SEARCH_ID		●	Identifier for the audience saved search.
CAMPAIGN_CODE		●	Code identifying the campaign.
CAMPAIGN_ID	PK?	●	Identifier for the campaign.
CAMPAIGN_LANGUAGE_CODE		●	Code identifying the campaign language.
CAMPAIGN_STATUS_CODE		●	Code identifying the campaign status.
CAMPAIGN_TYPE_CODE		●	Code identifying the campaign type.
CANCELLED_ON_DATE		●	Cancelled on date.
CLOSED_ON_DATE		●	Closed on date.
CREATED_BY		●	User who created the row.
CREATION_DATE		●	Date and time the row was created.
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.
OBJECT_VERSION_NUMBER		●	Optimistic-locking version number, incremented on each update.
PURPOSE_CODE		●	Code identifying the purpose.
REQ_SAVED_SEARCH_ID		●	Identifier for the req saved search.
SEARCH_REQUISITIONS_FLAG		●	Indicator (Y/N) for the search requisitions.
TARGET_GOAL_VALUE		●	Target goal value.

No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.

Need the extract + dbt staging for IRC_CAMPAIGNS_B?

We ship parameterized SQL, BICC config, and dbt models you own.

Problems that run through this table