PJT_PROJ_PLAN_LINES

SharedUsed in 9 subject areas30 reporting columns

line table — one row per line item under the header.

Likely primary key: PROJ_PLAN_HEADER_ID, LINE_NUMBER (inferred from Oracle naming conventions — verify against Tables & Views)

Columns

Column	Key	In reports	Description (inferred)
ACTUAL_EXPENSE_COST_AMOUNT		●	Actual expense cost amount.
ACTUAL_FINISH_DATE		●	Actual finish date.
ACTUAL_LABOR_BILLED_AMOUNT		●	Actual labor billed amount.
ACTUAL_LABOR_COST_AMOUNT		●	Actual labor cost amount.
ACTUAL_START_DATE		●	Actual start date.
COST_PERCENT_COMPLETE		●	Cost percent complete.
CREATION_DATE		●	Date and time the row was created.
DURATION		●	Duration.
EXPENSE_COST_AMOUNT		●	Expense cost amount.
FINISH_DATE		●	Finish date.
ITD_QUANTITY		●	Itd quantity.
LABOR_BILLED_AMOUNT		●	Labor billed amount.
LABOR_COST_AMOUNT		●	Labor cost amount.
LINE_NUMBER	PK?	○	Line number.
PERCENT_COMPLETE		●	Percent complete.
PHYSICAL_PERCENT_COMPLETE		●	Physical percent complete.
PLAN_LINE_TYPE_CODE		●	Code identifying the plan line type.
PRIORITY		●	Priority.
PROGRESS_STATUS_CODE		●	Code identifying the progress status.
PROJECT_ID		●	Identifier for the project.
PROJ_ELEMENT_ID		●	Identifier for the proj element.
PROJ_PLAN_HEADER_ID	PK?	○	Identifier for the proj plan header.
QUANTITY		●	Quantity.
REMAINING_EXPENSE_COST_AMOUNT		●	Remaining expense cost amount.
REMAINING_LABOR_BILLED_AMOUNT		●	Remaining labor billed amount.
REMAINING_LABOR_COST_AMOUNT		●	Remaining labor cost amount.
REMAINING_QUANTITY		●	Remaining quantity.
RESOURCE_ALLOCATION_PERCENT		●	Resource allocation percentage.
START_DATE		●	Start date.
TOTAL_ACTUAL_COST_AMOUNT		●	Total actual cost amount.
TOTAL_COST_AMOUNT		●	Total cost amount.
TOTAL_REMAINING_COST_AMOUNT		●	Total remaining cost amount.

No cataloged report reads from this table yet — it's part of the broader Fusion dictionary.

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_PROJ_PLAN_LINES?

We ship parameterized SQL, BICC config, and dbt models you own.