What is the primary key of IRC_CAMP_TRACK_RESPONSE?

not marked in the source dictionary

Where is IRC_CAMP_TRACK_RESPONSE used in reporting?

It appears in 0 OTBI subject areas.

Oracle Fusion · Data dictionary

SharedUsed in 0 subject areas11 reporting columnsBICC incremental-ready

Recruiting (IRC).

Primary key: not yet catalogued for IRC_CAMP_TRACK_RESPONSE, reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE

Joins (inferred from key columns): CAMPAIGN_ID → IRC_CAMPAIGNS_B · GOAL_ID → HRG_GOALS

Column	Key	In reports	Description (inferred)
CAMPAIGN_ID		●	Identifier for the campaign.
CREATED_BY		●	User who created the row.
CREATION_DATE		●	Date and time the row was created.
GOAL_ID		●	Identifier for the goal.
GOAL_RESPONSE_ID		●	Identifier for the goal response.
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.
PERSON_ID		●	Identifier for the person.
TRACK_RESPONSE_ID		●	Identifier for the track response.

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

Need the extract + dbt staging for IRC_CAMP_TRACK_RESPONSE?

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

Problems that run through this table