# DW_POSITION_CF_TD_DH

Position Hierarchy top down Column Flattened Dimension

## Details

Module: Global Human Resources

## Key Columns

POSITION_ID, EFFECTIVE_START_DATE, LEAF_POSITION_ID, EFFECTIVE_END_DATE

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
POSITION_ID | NUMBER | 38 | 0 | True | Parent Position Identifier |  |
EFFECTIVE_START_DATE | DATE |  |  | True | Start Date |  |
EFFECTIVE_END_DATE | DATE |  |  | True | End date |  |
LEAF_POSITION_ID | NUMBER | 38 | 0 | True | Last child position at the hierarchy level |  |
SOURCE_RECORD_ID | VARCHAR2 | 256 |  |  | This column is for Oracle Internal use only. Unique source Identifer |  |
TOP_LEVEL_POSITION_ID | NUMBER | 38 | 0 |  | Top child position at the hierarchy level |  |
POSITION_DISTANCE | NUMBER | 38 | 0 |  | Position hierarchy level |  |
LEVEL1_POSITION_ID | NUMBER | 38 | 0 |  | Identifies Level 1 Position record |  |
LEVEL2_POSITION_ID | NUMBER | 38 | 0 |  | Identifies Level 2 Position record |  |
LEVEL3_POSITION_ID | NUMBER | 38 | 0 |  | Identifies Level 3 Position record |  |
LEVEL4_POSITION_ID | NUMBER | 38 | 0 |  | Identifies Level 4 Position record |  |
LEVEL5_POSITION_ID | NUMBER | 38 | 0 |  | Identifies Level 5 Position record |  |
LEVEL6_POSITION_ID | NUMBER | 38 | 0 |  | Identifies Level 6 Position record |  |
LEVEL7_POSITION_ID | NUMBER | 38 | 0 |  | Identifies Level 7 Position record |  |
LEVEL8_POSITION_ID | NUMBER | 38 | 0 |  | Identifies Level 8 Position record |  |
LEVEL9_POSITION_ID | NUMBER | 38 | 0 |  | Identifies Level 9 Position record |  |
LEVEL10_POSITION_ID | NUMBER | 38 | 0 |  | Identifies Level 10 Position record |  |
LEVEL11_POSITION_ID | NUMBER | 38 | 0 |  | Identifies Level 11 Position record |  |
LEVEL12_POSITION_ID | NUMBER | 38 | 0 |  | Identifies Level 12 Position record |  |
LEVEL13_POSITION_ID | NUMBER | 38 | 0 |  | Identifies Level 13 Position record |  |
LEVEL14_POSITION_ID | NUMBER | 38 | 0 |  | Identifies Level 14 Position record |  |
LEVEL15_POSITION_ID | NUMBER | 38 | 0 |  | Identifies Level 15 Position record |  |

Copyright © 2019, 2026, Oracle and/or its affiliates.