PPMIC_WORKPLAN_MAPPING

This table stores the mapping information of work plan tasks.

Foreign Keys

This table does not have any foreign keys.

Column Descriptions

Column Name

Null?

Data Type

Description

MAPPING_ID

NOT NULL

VARCHAR2(40)

System-generated identifier in UUID format

TASK_ID

NOT NULL

NUMBER

Identifier for the work plan task

WORKSPACE_ID

NOT NULL

VARCHAR2(256)

Identifier for referenced workspace (instance)

CONFIGURATION_JSON

NOT NULL

CLOB(4000)

User configuration data in JSON format

CONFIGURATION_DISPLAY_JSON

NOT NULL

CLOB(4000)

User configuration data in JSON format for UI display

CREATED_BY

NOT NULL

NUMBER

Identifier for the user who created this record

CREATION_DATE

NOT NULL

DATE

The date when this record is created

LAST_PROMPT_LOG

NOT NULL

VARCHAR2(4000)

Log text from the last prompt of synchronization
PROMPT_STATUS NULLABLE NUMBER Status code from the last prompt of synchronization
LAST_PROMPT_DATE NULLABLE DATE Running time of the last prompt of synchronization

Indexes

Index Name

Index Type

Sequence

Column Name

PK_PPMIC_WORKPLAN_MAPPING

PRIMARY

1

MAPPING_ID

PPMIC_WORKPLAN_MAPPING_U1

UNIQUE

2

TASK_ID

Sequences

This table uses no sequences.