1. Tables and Views for Project Management
  2. PJS_BASE_CUSTOM_L

PJS_BASE_CUSTOM_L

This table contains the non-persistent incremental dataset for merging into the corresponding table, PJS_BASE_CUSTOM, and for continuation onto summarization RBS mapping.

Details

  • Schema: FUSION

  • Object owner: PJS

  • Object type: TABLE

  • Tablespace: FUSION_TS_SUMMARY

Columns

Name Datatype Length Precision Not-null Comments Status
TXN_ACCUM_HEADER_ID NUMBER 18 Each TXN_ACCUM_HEADER_ID corresponds to a unique combination of resource attributes and is used for RBS mapping Active
PROJECT_ID NUMBER 18 Contains the PROJECT_ID, not the Project Number (SEGMENT1) Active
PROJECT_UNIT_ID NUMBER 18 Project unit ID Active
TASK_ID NUMBER 18 Task ID Active
CALENDAR_ID NUMBER 18 Time dimension calendar ID Active
CALENDAR_TYPE VARCHAR2 1 Indicates whether PA or GL calendar Active
PERIOD_NAME VARCHAR2 20 Period name Active
CURRENCY_TYPE VARCHAR2 30 Currency type Active
CURRENCY_CODE VARCHAR2 30 Currency code Active
CUSTOM1 NUMBER Placeholder column used to store measures extracted with the custom PL/SQL API. Active
CUSTOM2 NUMBER Placeholder column used to store measures extracted with the custom PL/SQL API. Active
CUSTOM3 NUMBER Placeholder column used to store measures extracted with the custom PL/SQL API. Active
CUSTOM4 NUMBER Placeholder column used to store measures extracted with the custom PL/SQL API. Active
CUSTOM5 NUMBER Placeholder column used to store measures extracted with the custom PL/SQL API. Active
CUSTOM6 NUMBER Placeholder column used to store measures extracted with the custom PL/SQL API. Active
CUSTOM7 NUMBER Placeholder column used to store measures extracted with the custom PL/SQL API. Active
CUSTOM8 NUMBER Placeholder column used to store measures extracted with the custom PL/SQL API. Active
CUSTOM9 NUMBER Placeholder column used to store measures extracted with the custom PL/SQL API. Active
CUSTOM10 NUMBER Placeholder column used to store measures extracted with the custom PL/SQL API. Active
CUSTOM11 NUMBER Placeholder column used to store measures extracted with the custom PL/SQL API. Active
CUSTOM12 NUMBER Placeholder column used to store measures extracted with the custom PL/SQL API. Active
CUSTOM13 NUMBER Placeholder column used to store measures extracted with the custom PL/SQL API. Active
CUSTOM14 NUMBER Placeholder column used to store measures extracted with the custom PL/SQL API. Active
CUSTOM15 NUMBER Placeholder column used to store measures extracted with the custom PL/SQL API. 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