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

PER_POS_HRCHY_TOPDOWN_RF_CF_V

HCMUsed in 0 subject areas20 reporting columns

Person / Worker (PER) — denormalized view.

Primary key: not yet catalogued for PER_POS_HRCHY_TOPDOWN_RF_CF_V — reference Oracle Tables & Views guide.

Columns

ColumnKeyIn reportsDescription (inferred)
CHILD_LEVELChild level.
CHILD_POS_ID1Child pos id1.
CHILD_POS_ID10Child pos id10.
CHILD_POS_ID11Child pos id11.
CHILD_POS_ID12Child pos id12.
CHILD_POS_ID13Child pos id13.
CHILD_POS_ID14Child pos id14.
CHILD_POS_ID15Child pos id15.
CHILD_POS_ID2Child pos id2.
CHILD_POS_ID3Child pos id3.
CHILD_POS_ID4Child pos id4.
CHILD_POS_ID5Child pos id5.
CHILD_POS_ID6Child pos id6.
CHILD_POS_ID7Child pos id7.
CHILD_POS_ID8Child pos id8.
CHILD_POS_ID9Child pos id9.
EFFECTIVE_END_DATEEnd date of the effective-dated record.
EFFECTIVE_START_DATEStart date of the effective-dated record.
NONNULL_CHILD_POS_ID15Nonnull child pos id15.
POSITION_IDIdentifier for the position.

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_POS_HRCHY_TOPDOWN_RF_CF_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us