CZ_RW_RULE_PARTICIPANTS
This table is used to store Inventory Item Id of Redwood Rules data in Oracle Configurator.
Details
-
Schema: FUSION
-
Object owner: CZ
-
Object type: TABLE
-
Tablespace: SYSTEM
Primary Key
| Name | Columns |
|---|---|
|
CZ_RW_RULE_PARTICIPANTS_PK |
PARTICIPANT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| PARTICIPANT_ID | NUMBER | Yes | System generated unique identifier of the participant. | ||
| RULE_ID | NUMBER | 18 | Yes | Attribute indicating the unique identifier of the Rule. This is Foreign Key to Rule_id of CZ_RW_RULES_B. | |
| INVENTORY_ITEM_ID | NUMBER | 18 | Yes | Inventory item id which are participating in rule. | |
| ORGANIZATION_ID | NUMBER | 18 | Yes | An organizing unit in the internal or external structure of your enterprise. Organization structures provide the framework for performing legal reporting, financial control, and management reporting. This is Foreign Key to Organization_id of HR_ALL_ORGANIZATION_UNITS_F. | |
| PARENT_ITEM_ID | NUMBER | 18 | Inventory item ID of parent of PIM component referred by a rule. | ||
| OBJECT_VERSION_NUMBER | NUMBER | 9 | Yes | Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried. | |
| 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. |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CZ_RW_RULE_PARTICIPANTS_N1 | Non Unique | Default | ORGANIZATION_ID, INVENTORY_ITEM_ID |
| CZ_RW_RULE_PARTICIPANTS_U1 | Unique | Default | PARTICIPANT_ID |