PM_SYNCHED_FIELDS

This table stores the MSP fields that needs to be synchronized with PPM Center.

Foreign Keys

Primary Key Table

Primary Key Column

Foreign Key Column

PM_PROJECT_TYPES

PROJECT_TYPE_ID

PROJECT_TYPE_ID

Column Descriptions

Column Name

Null?

Data Type

Description

PROJECT_TYPE_ID

NOT NULL

NUMBER

A foreign key reference to project_type_id of PM_PROJECT_TYPES table.

IS_SYNCHED_FLAG

NULLABLE

VARCHAR2(1)

Indicates whether the MSP field needs to be synchronized

FIELD_TYPE

NOT NULL

NUMBER

Index within the list of fields

Indexes

Index Name

Index Type

Sequence

Column Name

SYS_C005201560

UNIQUE

1

PROJECT_TYPE_ID

SYS_C005201560

UNIQUE

2

FIELD_TYPE

Sequences

This table uses no sequences.