PJT_INT_OPTION
Microsoft Project Integration Option describes the actions and controls available when sending, receiving, or synchronization information between Oracle Projects and Microsoft Projects. This object will be seeded and will not be updateable by users. The options are organized in a hierarchy with multiple levels. The top level is an option grouping while lower levels represent dependencies between options.
Details
-
Schema: FUSION
-
Object owner: PJT
-
Object type: TABLE
-
Tablespace: REFERENCE
Primary Key
| Name | Columns |
|---|---|
|
PJT_INT_OPTION_B_PK |
OPT_CODE, OPT_PRODUCT_CODE, ENTERPRISE_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| ENTERPRISE_ID | NUMBER | 18 | Yes | ENTERPRISE_ID | |
| OPT_CODE | VARCHAR2 | 30 | Yes | Lookup type PJT_INT_OPTION_CODE ***** | |
| OPT_PRODUCT_CODE | VARCHAR2 | 30 | Yes | OPT_PRODUCT_CODE ***** | |
| OPT_TYPE | VARCHAR2 | 20 | Yes | Lookup type PJT_INT_OPTION_TYPE ***** | |
| OPT_GROUPING_CODE | VARCHAR2 | 30 | Yes | OPT_GROUPING_CODE ***** | |
| OPT_DISPLAY_SEQUENCE | NUMBER | 10 | Yes | OPT_DISPLAY_SEQUENCE ***** | |
| OPT_LOOKUP_TYPE_CODE | VARCHAR2 | 30 | OPT_LOOKUP_TYPE_CODE ***** | ||
| OPT_OVERRIDE_PU_FLAG | VARCHAR2 | 1 | Yes | OPT_OVERRIDE_PU_FLAG ***** | |
| OPT_OVERRIDE_TEMPLATE_FLAG | VARCHAR2 | 1 | Yes | OPT_OVERRIDE_TEMPLATE_FLAG ***** | |
| OPT_OVERRIDE_PROJECT_FLAG | VARCHAR2 | 1 | Yes | OPT_OVERRIDE_PROJECT_FLAG ***** | |
| LAST_UPDATED_BY | VARCHAR2 | 64 | Yes | Who column: indicates the user who last updated the row. | |
| LAST_UPDATE_LOGIN | VARCHAR2 | 32 | Who column: indicates the session login associated to the user who last updated the row. | ||
| 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_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| 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_B_PK | Unique | FUSION_TS_TX_DATA | OPT_CODE, OPT_PRODUCT_CODE, ENTERPRISE_ID, ORA_SEED_SET1 |
| PJT_INT_OPTION_B_PK1 | Unique | FUSION_TS_TX_DATA | OPT_CODE, OPT_PRODUCT_CODE, ENTERPRISE_ID, ORA_SEED_SET2 |