CZ_RW_CONVERSION_RULES

Details

Schema: FUSION
Object owner: CZ
Object type: TABLE
Tablespace: INTERFACE

Primary Key

Name	Columns
CZ_RW_CONVERSION_RULES_INT_PK	RULE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RULE_ID	NUMBER		18	Yes	System generated unique identifier of the rule.
MODEL_NAME	VARCHAR2	255		Yes	Name of the model this rule belongs to.
ORGANIZATION_CODE	VARCHAR2	18		Yes	Organization code where the model belongs to.
INVENTORY_ITEM_ID	NUMBER		18		InventoryItemId of the model this rule belongs to.
ORGANIZATION_ID	NUMBER		18		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.
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.
NAME	VARCHAR2	255			User given Rule Name for the converted redwood rule.
DESCRIPTION	VARCHAR2	1000			User given Rule Description for the converted redwood rule.
VERSION_START_DATE	DATE			Yes	Date when new version is set to be effective.
ACTIVE_FLAG	VARCHAR2	1			Determines whether the Rule will be active or not. Valid Values are Y, N, NULL. NULL is equivalent to Y.
DEFAULTING_FLAG	VARCHAR2	1			Determines whether the Rule will be defaulting rule or not. Valid Values are Y, N, NULL. NULL is equivalent to N.
RULE_OBJECT_TYPE	VARCHAR2	30		Yes	Indicates the type of rule. By default it is STATEMENT. Once the rule is converted it will have LOGIC or FORMULA.
RULE_STATUS	VARCHAR2	30		Yes	Stores current status of the rule - CREATED, VALIDATED, VALIDATION_FAILED, CONVERTED, CONVERSION_FAILED, INSERTED, INSERTION_FAILED.
RULE_CLASS	VARCHAR2	30			Rule Class lookup code. Valid Lookup code values: CONSTRAINT, DEFAULT, SEARCH_DECISION.
RULE_TEXT	CLOB				Rule text of a CDL Rule entered by user.
DELETED_FLAG	NUMBER		18	Yes	This flag indicates the logical deletion of the row. The Non-Zero value represents deleted state and 0 represents not-deleted state. A user-controlled background purge process will actually delete the orphaned rows with the Non-Zero flag value.
CREATION_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the creation of the row.
CREATED_BY	VARCHAR2	64		Yes	Who column: indicates the user who created 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.
BATCH_ID	NUMBER		18		Value that identifies the cz rule conversion batch to process.
JOB_DEFINITION_NAME	VARCHAR2	100			Enterprise Service Scheduler: indicates the name of the job that created or last updated the row.
JOB_DEFINITION_PACKAGE	VARCHAR2	900			Enterprise Service Scheduler: indicates the package name of the job that created or last updated the row.
REQUEST_ID	NUMBER		18		Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row.
LOAD_REQUEST_ID	NUMBER		18		Unique ID of the Load ESS job used to import into an interface table.
TRANSACTION_TYPE	VARCHAR2	30			Type of transaction specified by the user. Currently only CONVERT is available.

Foreign Keys

Table	Foreign Table	Foreign Key Column
cz_rw_expression_nodes	cz_rw_conversion_rules_int	RULE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CZ_RW_CONVERSION_RULES_INT_N1	Non Unique	FUSION_TS_INTERFACE	BATCH_ID, RULE_STATUS
CZ_RW_CONVERSION_RULES_INT_U1	Unique	FUSION_TS_INTERFACE	RULE_ID