What is the primary key of HRT_POOL_ASSOCIATIONS?

POOL_ASSOCIATION_ID (likely, inferred from column markers)

Where is HRT_POOL_ASSOCIATIONS used in reporting?

It appears in 0 OTBI subject areas.

Oracle Fusion · Data dictionary

SharedUsed in 0 subject areas11 reporting columnsBICC incremental-ready

Talent Profile (HRT).

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

Joins (inferred from key columns): POOL_ID → HRT_POOLS_VL

Column	Key	In reports	Description (inferred)
CREATED_BY		●	User who created the row.
CREATION_DATE		●	Date and time the row was created.
ENTERPRISE_ID		●	Identifier for the enterprise.
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_ID		●	Identifier for the object.
OBJECT_TYPE		●	Type of object.
OBJECT_VERSION_NUMBER		●	Optimistic-locking version number, incremented on each update.
POOL_ASSOCIATION_ID	PK?	●	Identifier for the pool association.
POOL_ID		●	Identifier for the pool.

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

Need the extract + dbt staging for HRT_POOL_ASSOCIATIONS?

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

Problems that run through this table