PER_ORG_TREE_NODE_RF

HCMUsed in 1 subject areas28 reporting columnsBICC incremental-ready

Person / Worker (PER).

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

Columns

Column	Key	In reports	Description (inferred)
ANCESTOR_DATA_SOURCE_ID		●	Identifier for the ancestor data source.
ANCESTOR_PK1_VALUE		●	Ancestor pk1 value.
ANCESTOR_PK2_VALUE		●	Ancestor pk2 value.
ANCESTOR_PK3_VALUE		●	Ancestor pk3 value.
ANCESTOR_PK4_VALUE		●	Ancestor pk4 value.
ANCESTOR_PK5_VALUE		●	Ancestor pk5 value.
ANCESTOR_TREE_LABEL_ID		●	Identifier for the ancestor tree label.
ANCESTOR_TREE_NODE_ID		●	Identifier for the ancestor tree node.
CREATED_BY		●	User who created the row.
CREATION_DATE		●	Date and time the row was created.
DATA_SOURCE_ID		●	Identifier for the data source.
DISTANCE		●	Distance.
ENTERPRISE_ID		●	Identifier for the enterprise.
IS_LEAF		●	Is leaf.
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.
PK1_VALUE		●	Pk1 value.
PK2_VALUE		●	Pk2 value.
PK3_VALUE		●	Pk3 value.
PK4_VALUE		●	Pk4 value.
PK5_VALUE		●	Pk5 value.
RF_TREE_NODE_ID		●	Identifier for the rf tree node.
TREE_CODE		●	Code identifying the tree.
TREE_LABEL_ID		●	Identifier for the tree label.
TREE_NODE_ID		●	Identifier for the tree node.
TREE_STRUCTURE_CODE		●	Code identifying the tree structure.
TREE_VERSION_ID		●	Identifier for the tree version.

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

The OTBI subject areas that expose this table. You can't join across them in OTBI — the owned conformed model joins them on shared keys.

Need the extract + dbt staging for PER_ORG_TREE_NODE_RF?

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