Analytics Catalog/Data dictionary/PJT_PROJECT_RESOURCE
Explore the catalogReportsModulesEnterprise modelOTBI subject areasBICC PVOs
Oracle Fusion · Data dictionary

PJT_PROJECT_RESOURCE

SharedUsed in 1 subject areas7 reporting columns

Source object in the Oracle Fusion data model.

Primary key: not yet catalogued for PJT_PROJECT_RESOURCE — reference Oracle Tables & Views guide.

Columns

ColumnKeyIn reportsDescription (inferred)
ALLOCATIONAllocation.
END_DATE_ACTIVEEnd date active.
EXPENSE_AMOUNTExpense amount.
LABOR_BILL_RATELabor bill rate.
LABOR_COST_RATELabor cost rate.
LABOR_EFFORTLabor effort.
START_DATE_ACTIVEStart date active.

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 PJT_PROJECT_RESOURCE?
We ship parameterized SQL, BICC config, and dbt models you own.
Talk to us