Oracle Fusion · Data dictionary
PER_MANAGER_HRCHY_CF
HCMUsed in 0 subject areas54 reporting columnsBICC incremental-ready
Person / Worker (PER).
Likely primary key: PERSON_ID (inferred from Oracle naming conventions — verify against Tables & Views) · Incremental key: LAST_UPDATE_DATE
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ASSIGNMENT_ID | ● | Identifier for the assignment. | |
| CREATED_BY | ● | User who created the row. | |
| CREATION_DATE | ● | Date and time the row was created. | |
| EFFECTIVE_END_DATE | ● | End date of the effective-dated record. | |
| EFFECTIVE_START_DATE | ● | Start date of the effective-dated record. | |
| ENTERPRISE_ID | ● | Identifier for the enterprise. | |
| JOB_DEFINITION_NAME | ● | Name of the job definition. | |
| JOB_DEFINITION_PACKAGE | ● | Job definition package. | |
| 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. | |
| LEVEL10_MANAGER_ASSIGNMENT_ID | ● | Identifier for the level10 manager assignment. | |
| LEVEL10_MANAGER_ID | ● | Identifier for the level10 manager. | |
| LEVEL11_MANAGER_ASSIGNMENT_ID | ● | Identifier for the level11 manager assignment. | |
| LEVEL11_MANAGER_ID | ● | Identifier for the level11 manager. | |
| LEVEL12_MANAGER_ASSIGNMENT_ID | ● | Identifier for the level12 manager assignment. | |
| LEVEL12_MANAGER_ID | ● | Identifier for the level12 manager. | |
| LEVEL13_MANAGER_ASSIGNMENT_ID | ● | Identifier for the level13 manager assignment. | |
| LEVEL13_MANAGER_ID | ● | Identifier for the level13 manager. | |
| LEVEL14_MANAGER_ASSIGNMENT_ID | ● | Identifier for the level14 manager assignment. | |
| LEVEL14_MANAGER_ID | ● | Identifier for the level14 manager. | |
| LEVEL15_MANAGER_ASSIGNMENT_ID | ● | Identifier for the level15 manager assignment. | |
| LEVEL15_MANAGER_ID | ● | Identifier for the level15 manager. | |
| LEVEL16_MANAGER_ASSIGNMENT_ID | ● | Identifier for the level16 manager assignment. | |
| LEVEL16_MANAGER_ID | ● | Identifier for the level16 manager. | |
| LEVEL17_MANAGER_ASSIGNMENT_ID | ● | Identifier for the level17 manager assignment. | |
| LEVEL17_MANAGER_ID | ● | Identifier for the level17 manager. | |
| LEVEL18_MANAGER_ASSIGNMENT_ID | ● | Identifier for the level18 manager assignment. | |
| LEVEL18_MANAGER_ID | ● | Identifier for the level18 manager. | |
| LEVEL19_MANAGER_ASSIGNMENT_ID | ● | Identifier for the level19 manager assignment. | |
| LEVEL19_MANAGER_ID | ● | Identifier for the level19 manager. | |
| LEVEL1_MANAGER_ASSIGNMENT_ID | ● | Identifier for the level1 manager assignment. | |
| LEVEL1_MANAGER_ID | ● | Identifier for the level1 manager. | |
| LEVEL20_MANAGER_ASSIGNMENT_ID | ● | Identifier for the level20 manager assignment. | |
| LEVEL20_MANAGER_ID | ● | Identifier for the level20 manager. | |
| LEVEL2_MANAGER_ASSIGNMENT_ID | ● | Identifier for the level2 manager assignment. | |
| LEVEL2_MANAGER_ID | ● | Identifier for the level2 manager. | |
| LEVEL3_MANAGER_ASSIGNMENT_ID | ● | Identifier for the level3 manager assignment. | |
| LEVEL3_MANAGER_ID | ● | Identifier for the level3 manager. | |
| LEVEL4_MANAGER_ASSIGNMENT_ID | ● | Identifier for the level4 manager assignment. | |
| LEVEL4_MANAGER_ID | ● | Identifier for the level4 manager. | |
| LEVEL5_MANAGER_ASSIGNMENT_ID | ● | Identifier for the level5 manager assignment. | |
| LEVEL5_MANAGER_ID | ● | Identifier for the level5 manager. | |
| LEVEL6_MANAGER_ASSIGNMENT_ID | ● | Identifier for the level6 manager assignment. | |
| LEVEL6_MANAGER_ID | ● | Identifier for the level6 manager. | |
| LEVEL7_MANAGER_ASSIGNMENT_ID | ● | Identifier for the level7 manager assignment. | |
| LEVEL7_MANAGER_ID | ● | Identifier for the level7 manager. | |
| LEVEL8_MANAGER_ASSIGNMENT_ID | ● | Identifier for the level8 manager assignment. | |
| LEVEL8_MANAGER_ID | ● | Identifier for the level8 manager. | |
| LEVEL9_MANAGER_ASSIGNMENT_ID | ● | Identifier for the level9 manager assignment. | |
| LEVEL9_MANAGER_ID | ● | Identifier for the level9 manager. | |
| MANAGER_TYPE | ● | Type of manager. | |
| PERSON_ID | PK? | ● | Identifier for the person. |
| REQUEST_ID | ● | Identifier of the process that created or last updated the row. |
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_MANAGER_HRCHY_CF?
We ship parameterized SQL, BICC config, and dbt models you own.