PJT_INT_OPTION_VALUE
Microsoft Project Integration Option Value describes the value selected for each integration option at the global, project unit, template, and project level. The records will be created by the system, and the user can update the records but cannot explicitly create new values.
Details
-
Schema: FUSION
-
Object owner: PJT
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
PJT_INT_OPTION_VALUE_PK |
OPTV_ID, ENTERPRISE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTERPRISE_ID | NUMBER | 18 | Yes | ENTERPRISE_ID | |
| OPTV_ID | NUMBER | 18 | Yes | OPTV_ID ***** | |
| OPTV_OPTION_CODE | VARCHAR2 | 30 | Yes | OPTV_OPTION_CODE ***** | |
| OPTV_PRODUCT_CODE | VARCHAR2 | 30 | Yes | OPTV_PRODUCT_CODE ***** | |
| OPTV_VALUE | VARCHAR2 | 255 | OPTV_VALUE ***** | ||
| OPTV_OVERRIDE_PU_ID | NUMBER | 18 | OPTV_OVERRIDE_PU_ID ***** | ||
| OPTV_OVERRIDE_TEMPLATE_ID | NUMBER | 18 | OPTV_OVERRIDE_TEMPLATE_ID ***** | ||
| OPTV_OVERRIDE_PROJECT_ID | NUMBER | 18 | OPTV_OVERRIDE_PROJECT_ID ***** | ||
| CREATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who created the row. | |
| CREATION_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the creation of the row. | ||
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| OPTV_ENABLED_FLAG | VARCHAR2 | 1 | OPTV_ENABLED_FLAG ***** | ||
| SEED_DATA_SOURCE | VARCHAR2 | 512 | Source of seed data record. A value of 'BULK_SEED_DATA_SCRIPT' indicates that record was bulk loaded. Otherwise, specifies the name of the seed data file. | ||
| ORA_SEED_SET1 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET1. Context values are Y or N. | |
| ORA_SEED_SET2 | VARCHAR2 | 1 | Yes | Oracle internal use only. Indicates the edition-based redefinition (EBR) context of the row for SET2. Context values are Y or N. |
Foreign Keys
| Table | Foreign Table | Foreign Key Column |
|---|---|---|
| PJT_INT_OPTION_VALUE | pjt_int_option | OPTV_OPTION_CODE, OPTV_PRODUCT_CODE, ENTERPRISE_ID |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| PJT_INT_OPTION_VALUE_PK | Unique | FUSION_TS_TX_DATA | OPTV_ID, ENTERPRISE_ID, ORA_SEED_SET1 |
| PJT_INT_OPTION_VALUE_PK1 | Unique | FUSION_TS_TX_DATA | OPTV_ID, ENTERPRISE_ID, ORA_SEED_SET2 |