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.