Oracle Fusion · Data dictionary
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
Joins (inferred from key columns): TREE_VERSION_ID → FND_TREE_VERSION_VL
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. |
Used by reports
No cataloged report reads from this table yet, it's part of the broader Fusion dictionary.
- ,
Where this surfaces in OTBI
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.
Problems that run through this table