Oracle Fusion · Data dictionary
EGO_ROUTE_PEOPLE_BI_V
SharedUsed in 2 subject areas9 reporting columns
denormalized view.
Primary key: not yet catalogued for EGO_ROUTE_PEOPLE_BI_V, reference Oracle Tables & Views guide.
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| ASSIGNEE_ID | ● | Identifier for the assignee. | |
| ASSIGNEE_TYPE_CODE | ● | Code identifying the assignee type. | |
| ORIGINAL_ASSIGNEE_ID | ● | Identifier for the original assignee. | |
| ORIGINAL_ASSIGNEE_TYPE | ● | Type of original assignee. | |
| REASSIGNED_TO | ● | Reassigned to. | |
| RESPONSE_CODE | ● | Code identifying the response. | |
| RESPONSE_REQUIRED_FROM | ● | Response required from. | |
| TASK_COMPLETE_TIME | ● | Task complete time. | |
| TASK_START_TIME | ● | Task start time. |
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.
- Product Management - Change Order Approvals Real Time
- Product Management - New Item Request Approvals Real Time
Need the extract + dbt staging for EGO_ROUTE_PEOPLE_BI_V?
We ship parameterized SQL, BICC config, and dbt models you own.
Problems that run through this table