CZ_RW_MODEL_PARAMETERS

This table stores parameters that control Redwood configuration model behavior in Oracle Configurator.

Details

• Schema: FUSION

• Object owner: CZ

• Object type: TABLE

• Tablespace: SYSTEM

Primary Key

Name	Columns
CZ_RW_MODEL_PARAMETERS_PK	PARAMETER_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
PARAMETER_ID	NUMBER		18	Yes	System generated unique identifier of the model parameters.
INVENTORY_ITEM_ID	NUMBER		18	Yes	This is Foreign Key to inventory_item_id of EGP_SYSTEM_ITEMS_B. It represents the root item of the model for which the model parameters are defined.
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.
SALES_ORDER_ASST_ENABLED_FLAG	VARCHAR2	1		Yes	Indicates whether the model is enabled for use by the Configurable Product Agent within the Sales Order Assistant. Possible values are Y/N.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created the row.
VERSION_START_DATE	DATE			Yes	Date when new version is set to be effective.
VERSION_END_DATE	DATE				Date after which the version will no longer remain effective.
ACD_TYPE	VARCHAR2	30		Yes	Refers to the type of modification made to the model parameters, such as add, update or delete.
CHANGE_LINE_ID	NUMBER		20	Yes	A unique identifier of a change order. This is the change order line for the model item to which the model parameters belong. This is a Foreign Key to change_line_id of ego_change_lines_b.
VERSION_ID	NUMBER		20	Yes	Version number to identify a version uniquely within a revision. This is a Foreign Key to ego_versions_b.
IMPLEMENTATION_DATE	DATE				Date on which the model parameters definition is scheduled to be implemented.
CHANGE_BIT_MAP	VARCHAR2	400		Yes	This stores information about which attributes were modified for a specific model parameters record. This column uses a bitwise representation, where each bit corresponds to a model parameter, allowing the system to track changes to multiple attributes efficiently within a single row and detect modifications to model parameters data.
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.
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_MODEL_PARAMETERS_N1	Non Unique	Default	INVENTORY_ITEM_ID, ORGANIZATION_ID
CZ_RW_MODEL_PARAMETERS_U1	Unique	Default	PARAMETER_ID