Analytics Catalog/Data dictionary/PER_DEPT_TREE_NODE_CF
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

PER_DEPT_TREE_NODE_CF

HCMUsed in 0 subject areas235 reporting columnsBICC incremental-ready

Person / Worker (PER).

Primary key: not yet catalogued for PER_DEPT_TREE_NODE_CF, reference Oracle Tables & Views guide. · Incremental key: LAST_UPDATE_DATE
Joins (inferred from key columns): TREE_VERSION_ID → FND_TREE_VERSION_VL

Columns

ColumnKeyIn reportsDescription (inferred)
CF_TREE_NODE_ID●Identifier for the cf tree node.
CREATED_BY●User who created the row.
CREATION_DATE●Date and time the row was created.
DEP0_DATA_SOURCE_ID●Identifier for the dep0 data source.
DEP0_PK1_VALUE●Dep0 pk1 value.
DEP0_PK2_VALUE●Dep0 pk2 value.
DEP0_PK3_VALUE●Dep0 pk3 value.
DEP0_PK4_VALUE●Dep0 pk4 value.
DEP0_PK5_VALUE●Dep0 pk5 value.
DEP0_TREE_NODE_ID●Identifier for the dep0 tree node.
DEP10_DATA_SOURCE_ID●Identifier for the dep10 data source.
DEP10_PK1_VALUE●Dep10 pk1 value.
DEP10_PK2_VALUE●Dep10 pk2 value.
DEP10_PK3_VALUE●Dep10 pk3 value.
DEP10_PK4_VALUE●Dep10 pk4 value.
DEP10_PK5_VALUE●Dep10 pk5 value.
DEP10_TREE_NODE_ID●Identifier for the dep10 tree node.
DEP11_DATA_SOURCE_ID●Identifier for the dep11 data source.
DEP11_PK1_VALUE●Dep11 pk1 value.
DEP11_PK2_VALUE●Dep11 pk2 value.
DEP11_PK3_VALUE●Dep11 pk3 value.
DEP11_PK4_VALUE●Dep11 pk4 value.
DEP11_PK5_VALUE●Dep11 pk5 value.
DEP11_TREE_NODE_ID●Identifier for the dep11 tree node.
DEP12_DATA_SOURCE_ID●Identifier for the dep12 data source.
DEP12_PK1_VALUE●Dep12 pk1 value.
DEP12_PK2_VALUE●Dep12 pk2 value.
DEP12_PK3_VALUE●Dep12 pk3 value.
DEP12_PK4_VALUE●Dep12 pk4 value.
DEP12_PK5_VALUE●Dep12 pk5 value.
DEP12_TREE_NODE_ID●Identifier for the dep12 tree node.
DEP13_DATA_SOURCE_ID●Identifier for the dep13 data source.
DEP13_PK1_VALUE●Dep13 pk1 value.
DEP13_PK2_VALUE●Dep13 pk2 value.
DEP13_PK3_VALUE●Dep13 pk3 value.
DEP13_PK4_VALUE●Dep13 pk4 value.
DEP13_PK5_VALUE●Dep13 pk5 value.
DEP13_TREE_NODE_ID●Identifier for the dep13 tree node.
DEP14_DATA_SOURCE_ID●Identifier for the dep14 data source.
DEP14_PK1_VALUE●Dep14 pk1 value.
DEP14_PK2_VALUE●Dep14 pk2 value.
DEP14_PK3_VALUE●Dep14 pk3 value.
DEP14_PK4_VALUE●Dep14 pk4 value.
DEP14_PK5_VALUE●Dep14 pk5 value.
DEP14_TREE_NODE_ID●Identifier for the dep14 tree node.
DEP15_DATA_SOURCE_ID●Identifier for the dep15 data source.
DEP15_PK1_VALUE●Dep15 pk1 value.
DEP15_PK2_VALUE●Dep15 pk2 value.
DEP15_PK3_VALUE●Dep15 pk3 value.
DEP15_PK4_VALUE●Dep15 pk4 value.
DEP15_PK5_VALUE●Dep15 pk5 value.
DEP15_TREE_NODE_ID●Identifier for the dep15 tree node.
DEP16_DATA_SOURCE_ID●Identifier for the dep16 data source.
DEP16_PK1_VALUE●Dep16 pk1 value.
DEP16_PK2_VALUE●Dep16 pk2 value.
DEP16_PK3_VALUE●Dep16 pk3 value.
DEP16_PK4_VALUE●Dep16 pk4 value.
DEP16_PK5_VALUE●Dep16 pk5 value.
DEP16_TREE_NODE_ID●Identifier for the dep16 tree node.
DEP17_DATA_SOURCE_ID●Identifier for the dep17 data source.
DEP17_PK1_VALUE●Dep17 pk1 value.
DEP17_PK2_VALUE●Dep17 pk2 value.
DEP17_PK3_VALUE●Dep17 pk3 value.
DEP17_PK4_VALUE●Dep17 pk4 value.
DEP17_PK5_VALUE●Dep17 pk5 value.
DEP17_TREE_NODE_ID●Identifier for the dep17 tree node.
DEP18_DATA_SOURCE_ID●Identifier for the dep18 data source.
DEP18_PK1_VALUE●Dep18 pk1 value.
DEP18_PK2_VALUE●Dep18 pk2 value.
DEP18_PK3_VALUE●Dep18 pk3 value.
DEP18_PK4_VALUE●Dep18 pk4 value.
DEP18_PK5_VALUE●Dep18 pk5 value.
DEP18_TREE_NODE_ID●Identifier for the dep18 tree node.
DEP19_DATA_SOURCE_ID●Identifier for the dep19 data source.
DEP19_PK1_VALUE●Dep19 pk1 value.
DEP19_PK2_VALUE●Dep19 pk2 value.
DEP19_PK3_VALUE●Dep19 pk3 value.
DEP19_PK4_VALUE●Dep19 pk4 value.
DEP19_PK5_VALUE●Dep19 pk5 value.
DEP19_TREE_NODE_ID●Identifier for the dep19 tree node.
DEP1_DATA_SOURCE_ID●Identifier for the dep1 data source.
DEP1_PK1_VALUE●Dep1 pk1 value.
DEP1_PK2_VALUE●Dep1 pk2 value.
DEP1_PK3_VALUE●Dep1 pk3 value.
DEP1_PK4_VALUE●Dep1 pk4 value.
DEP1_PK5_VALUE●Dep1 pk5 value.
DEP1_TREE_NODE_ID●Identifier for the dep1 tree node.
DEP20_DATA_SOURCE_ID●Identifier for the dep20 data source.
DEP20_PK1_VALUE●Dep20 pk1 value.
DEP20_PK2_VALUE●Dep20 pk2 value.
DEP20_PK3_VALUE●Dep20 pk3 value.
DEP20_PK4_VALUE●Dep20 pk4 value.
DEP20_PK5_VALUE●Dep20 pk5 value.
DEP20_TREE_NODE_ID●Identifier for the dep20 tree node.
DEP21_DATA_SOURCE_ID●Identifier for the dep21 data source.
DEP21_PK1_VALUE●Dep21 pk1 value.
DEP21_PK2_VALUE●Dep21 pk2 value.
DEP21_PK3_VALUE●Dep21 pk3 value.
DEP21_PK4_VALUE●Dep21 pk4 value.
DEP21_PK5_VALUE●Dep21 pk5 value.
DEP21_TREE_NODE_ID●Identifier for the dep21 tree node.
DEP22_DATA_SOURCE_ID●Identifier for the dep22 data source.
DEP22_PK1_VALUE●Dep22 pk1 value.
DEP22_PK2_VALUE●Dep22 pk2 value.
DEP22_PK3_VALUE●Dep22 pk3 value.
DEP22_PK4_VALUE●Dep22 pk4 value.
DEP22_PK5_VALUE●Dep22 pk5 value.
DEP22_TREE_NODE_ID●Identifier for the dep22 tree node.
DEP23_DATA_SOURCE_ID●Identifier for the dep23 data source.
DEP23_PK1_VALUE●Dep23 pk1 value.
DEP23_PK2_VALUE●Dep23 pk2 value.
DEP23_PK3_VALUE●Dep23 pk3 value.
DEP23_PK4_VALUE●Dep23 pk4 value.
DEP23_PK5_VALUE●Dep23 pk5 value.
DEP23_TREE_NODE_ID●Identifier for the dep23 tree node.
DEP24_DATA_SOURCE_ID●Identifier for the dep24 data source.
DEP24_PK1_VALUE●Dep24 pk1 value.
DEP24_PK2_VALUE●Dep24 pk2 value.
DEP24_PK3_VALUE●Dep24 pk3 value.
DEP24_PK4_VALUE●Dep24 pk4 value.
DEP24_PK5_VALUE●Dep24 pk5 value.
DEP24_TREE_NODE_ID●Identifier for the dep24 tree node.
DEP25_DATA_SOURCE_ID●Identifier for the dep25 data source.
DEP25_PK1_VALUE●Dep25 pk1 value.
DEP25_PK2_VALUE●Dep25 pk2 value.
DEP25_PK3_VALUE●Dep25 pk3 value.
DEP25_PK4_VALUE●Dep25 pk4 value.
DEP25_PK5_VALUE●Dep25 pk5 value.
DEP25_TREE_NODE_ID●Identifier for the dep25 tree node.
DEP26_DATA_SOURCE_ID●Identifier for the dep26 data source.
DEP26_PK1_VALUE●Dep26 pk1 value.
DEP26_PK2_VALUE●Dep26 pk2 value.
DEP26_PK3_VALUE●Dep26 pk3 value.
DEP26_PK4_VALUE●Dep26 pk4 value.
DEP26_PK5_VALUE●Dep26 pk5 value.
DEP26_TREE_NODE_ID●Identifier for the dep26 tree node.
DEP27_DATA_SOURCE_ID●Identifier for the dep27 data source.
DEP27_PK1_VALUE●Dep27 pk1 value.
DEP27_PK2_VALUE●Dep27 pk2 value.
DEP27_PK3_VALUE●Dep27 pk3 value.
DEP27_PK4_VALUE●Dep27 pk4 value.
DEP27_PK5_VALUE●Dep27 pk5 value.
DEP27_TREE_NODE_ID●Identifier for the dep27 tree node.
DEP28_DATA_SOURCE_ID●Identifier for the dep28 data source.
DEP28_PK1_VALUE●Dep28 pk1 value.
DEP28_PK2_VALUE●Dep28 pk2 value.
DEP28_PK3_VALUE●Dep28 pk3 value.
DEP28_PK4_VALUE●Dep28 pk4 value.
DEP28_PK5_VALUE●Dep28 pk5 value.
DEP28_TREE_NODE_ID●Identifier for the dep28 tree node.
DEP29_DATA_SOURCE_ID●Identifier for the dep29 data source.
DEP29_PK1_VALUE●Dep29 pk1 value.
DEP29_PK2_VALUE●Dep29 pk2 value.
DEP29_PK3_VALUE●Dep29 pk3 value.
DEP29_PK4_VALUE●Dep29 pk4 value.
DEP29_PK5_VALUE●Dep29 pk5 value.
DEP29_TREE_NODE_ID●Identifier for the dep29 tree node.
DEP2_DATA_SOURCE_ID●Identifier for the dep2 data source.
DEP2_PK1_VALUE●Dep2 pk1 value.
DEP2_PK2_VALUE●Dep2 pk2 value.
DEP2_PK3_VALUE●Dep2 pk3 value.
DEP2_PK4_VALUE●Dep2 pk4 value.
DEP2_PK5_VALUE●Dep2 pk5 value.
DEP2_TREE_NODE_ID●Identifier for the dep2 tree node.
DEP30_DATA_SOURCE_ID●Identifier for the dep30 data source.
DEP30_PK1_VALUE●Dep30 pk1 value.
DEP30_PK2_VALUE●Dep30 pk2 value.
DEP30_PK3_VALUE●Dep30 pk3 value.
DEP30_PK4_VALUE●Dep30 pk4 value.
DEP30_PK5_VALUE●Dep30 pk5 value.
DEP30_TREE_NODE_ID●Identifier for the dep30 tree node.
DEP31_DATA_SOURCE_ID●Identifier for the dep31 data source.
DEP31_PK1_VALUE●Dep31 pk1 value.
DEP31_PK2_VALUE●Dep31 pk2 value.
DEP31_PK3_VALUE●Dep31 pk3 value.
DEP31_PK4_VALUE●Dep31 pk4 value.
DEP31_PK5_VALUE●Dep31 pk5 value.
DEP31_TREE_NODE_ID●Identifier for the dep31 tree node.
DEP3_DATA_SOURCE_ID●Identifier for the dep3 data source.
DEP3_PK1_VALUE●Dep3 pk1 value.
DEP3_PK2_VALUE●Dep3 pk2 value.
DEP3_PK3_VALUE●Dep3 pk3 value.
DEP3_PK4_VALUE●Dep3 pk4 value.
DEP3_PK5_VALUE●Dep3 pk5 value.
DEP3_TREE_NODE_ID●Identifier for the dep3 tree node.
DEP4_DATA_SOURCE_ID●Identifier for the dep4 data source.
DEP4_PK1_VALUE●Dep4 pk1 value.
DEP4_PK2_VALUE●Dep4 pk2 value.
DEP4_PK3_VALUE●Dep4 pk3 value.
DEP4_PK4_VALUE●Dep4 pk4 value.
DEP4_PK5_VALUE●Dep4 pk5 value.
DEP4_TREE_NODE_ID●Identifier for the dep4 tree node.
DEP5_DATA_SOURCE_ID●Identifier for the dep5 data source.
DEP5_PK1_VALUE●Dep5 pk1 value.
DEP5_PK2_VALUE●Dep5 pk2 value.
DEP5_PK3_VALUE●Dep5 pk3 value.
DEP5_PK4_VALUE●Dep5 pk4 value.
DEP5_PK5_VALUE●Dep5 pk5 value.
DEP5_TREE_NODE_ID●Identifier for the dep5 tree node.
DEP6_DATA_SOURCE_ID●Identifier for the dep6 data source.
DEP6_PK1_VALUE●Dep6 pk1 value.
DEP6_PK2_VALUE●Dep6 pk2 value.
DEP6_PK3_VALUE●Dep6 pk3 value.
DEP6_PK4_VALUE●Dep6 pk4 value.
DEP6_PK5_VALUE●Dep6 pk5 value.
DEP6_TREE_NODE_ID●Identifier for the dep6 tree node.
DEP7_DATA_SOURCE_ID●Identifier for the dep7 data source.
DEP7_PK1_VALUE●Dep7 pk1 value.
DEP7_PK2_VALUE●Dep7 pk2 value.
DEP7_PK3_VALUE●Dep7 pk3 value.
DEP7_PK4_VALUE●Dep7 pk4 value.
DEP7_PK5_VALUE●Dep7 pk5 value.
DEP7_TREE_NODE_ID●Identifier for the dep7 tree node.
DEP8_DATA_SOURCE_ID●Identifier for the dep8 data source.
DEP8_PK1_VALUE●Dep8 pk1 value.
DEP8_PK2_VALUE●Dep8 pk2 value.
DEP8_PK3_VALUE●Dep8 pk3 value.
DEP8_PK4_VALUE●Dep8 pk4 value.
DEP8_PK5_VALUE●Dep8 pk5 value.
DEP8_TREE_NODE_ID●Identifier for the dep8 tree node.
DEP9_DATA_SOURCE_ID●Identifier for the dep9 data source.
DEP9_PK1_VALUE●Dep9 pk1 value.
DEP9_PK2_VALUE●Dep9 pk2 value.
DEP9_PK3_VALUE●Dep9 pk3 value.
DEP9_PK4_VALUE●Dep9 pk4 value.
DEP9_PK5_VALUE●Dep9 pk5 value.
DEP9_TREE_NODE_ID●Identifier for the dep9 tree node.
DISTANCE●Distance.
ENTERPRISE_ID●Identifier for the enterprise.
LAST_UPDATED_BY●User who last updated the row.
LAST_UPDATE_DATEINCR●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.
TREE_CODE●Code identifying the tree.
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.

Subject areas

Need the extract + dbt staging for PER_DEPT_TREE_NODE_CF?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us
Problems that run through this table
The report that lies quietly · Approval history vanishes · What the extract does not carry