What is the primary key of IRC_APPLY_FLOWS_B?

APPLY_FLOW_ID (likely, inferred from column markers)

Where is IRC_APPLY_FLOWS_B used in reporting?

It appears in 0 OTBI subject areas.

Oracle Fusion · Data dictionary

SharedUsed in 0 subject areas9 reporting columnsBICC incremental-ready

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

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

Column	Key	In reports	Description (inferred)
AF_CODE		●	Code identifying the af.
AF_STATUS_CODE		●	Code identifying the af status.
AF_TYPE_CODE		●	Code identifying the af type.
APPLY_FLOW_ID	PK?	●	Identifier for the apply flow.
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.

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

Need the extract + dbt staging for IRC_APPLY_FLOWS_B?

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

Problems that run through this table