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.
Problems that run through this table