Oracle Fusion · Data dictionary
PJR_RESOURCE_REQUESTS
SharedUsed in 1 subject areas15 reporting columns
Projects Resource Management (PJR).
Likely primary key: RESOURCE_REQUEST_ID (inferred from Oracle naming conventions — verify against Tables & Views)
Columns
| Column | Key | In reports | Description (inferred) |
|---|---|---|---|
| CANCELLATION_DATE | ● | Cancellation date. | |
| CANCELLATION_REASON | ● | Cancellation reason. | |
| FINISH_DATE | ● | Finish date. | |
| LOCATION | ● | Location. | |
| NAME | ● | Name. | |
| NUMBER_OF_WORKING_DAYS | ● | Number of working days. | |
| RESOURCE_REQUEST_ID | PK? | ● | Identifier for the resource request. |
| SPECIAL_INSTRUCTIONS | ● | Special instructions. | |
| STAFFING_REMARKS | ● | Staffing remarks. | |
| START_DATE | ● | Start date. | |
| TARGET_BILL_RATE | ● | Target bill rate. | |
| TARGET_BILL_RATE_CURR_CODE | ● | Code identifying the target bill rate currency. | |
| TARGET_COST_RATE | ● | Target cost rate. | |
| TARGET_COST_RATE_CURR_CODE | ● | Code identifying the target cost rate currency. | |
| TOTAL_HOURS | ● | Total hours. |
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.
Need the extract + dbt staging for PJR_RESOURCE_REQUESTS?
We ship parameterized SQL, BICC config, and dbt models you own.