1. Tables and Views for Project Management
  2. PJS_CN_ACT_PLAN_F

PJS_CN_ACT_PLAN_F

This table is used for the actuals and plan data for contract/project.

Details

  • Schema: FUSION

  • Object owner: PJS

  • Object type: TABLE

  • Tablespace: TRANSACTION_TABLES

Primary Key

Name Columns

PJS_CN_ACT_PLAN_F_PK

CONTRACT_ID, CONTRACT_LINE_ID, CONTRACT_PROJECT_LINKAGE_ID, AGGR_LEVEL, PERIOD_NAME, LINK_TASK_ID, CURRENCY_CODE

Columns

Name Datatype Length Precision Not-null Comments Status
BUSINESS_UNIT_ID NUMBER 18 Business Unit ID Active
CONTRACT_ID NUMBER 18 Yes Contains the Contract ID, not the Contract Number. Active
CONTRACT_LINE_ID NUMBER 18 Yes Contains the Contract Line ID. Active
CONTRACT_PROJECT_LINKAGE_ID NUMBER 18 Yes Contains the unique ID for a link between a project task (or project) and a contract line (or contract). Active
LINK_PROJECT_ID NUMBER 18 Project ID linked to the contract line or contract Active
LINK_TASK_ID NUMBER 18 Yes Task ID Active
AGGR_LEVEL VARCHAR2 1 Yes Indicates whether the data is aggregated to the project, contract_line, or contract level. Active
PERIOD_NAME VARCHAR2 30 Yes Period name Active
CURRENCY_CODE VARCHAR2 15 Yes Currency code Active
ACT_BURDENED_COST NUMBER Burdened cost Active
BILLABLE_ACT_BURDENED_COST NUMBER Billable burdened cost Active
BUDGET_REVENUE NUMBER Budget revenue Active
FORECAST_REVENUE NUMBER Forecast revenue Active
PROJECT_REVENUE NUMBER Project revenue Active
BILLING_TYPE_CODE VARCHAR2 30 Yes Billing type code Active
LAST_UPDATE_DATE TIMESTAMP Yes Who column: indicates the date and time of the last update of the row. Active
LAST_UPDATED_BY VARCHAR2 64 Yes Who column: indicates the user who last updated the row. Active
CREATION_DATE TIMESTAMP Yes Who column: indicates the date and time of the creation of the row. Active
CREATED_BY VARCHAR2 64 Yes Who column: indicates the user who created the row. Active
LAST_UPDATE_LOGIN VARCHAR2 32 Who column: indicates the session login associated to the user who last updated the row. Active
EFFECTIVE_START_DATE DATE Date Effective Entity: indicates the date at the beginning of the date range within which the row is effective.
EFFECTIVE_END_DATE DATE Date Effective Entity: indicates the date at the end of the date range within which the row is effective.

Indexes

Index Uniqueness Tablespace Columns Status
PJS_CN_ACT_PLAN_F_N2 Non Unique FUSION_TS_TX_DATA LINK_PROJECT_ID, LINK_TASK_ID Active
PJS_CN_ACT_PLAN_F_U1 Unique Default CONTRACT_ID, CONTRACT_LINE_ID, CONTRACT_PROJECT_LINKAGE_ID, AGGR_LEVEL, PERIOD_NAME, LINK_TASK_ID, CURRENCY_CODE