CZ_RW_RULES

Details

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

Primary Key

Name	Columns
CZ_RW_RULES_PK	RULE_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
RULE_ID	NUMBER		18	Yes	System generated unique identifier of the rule.
HCM_LIST_ID	NUMBER		18		HCM List Unique Identifier to identify the Rule Builder rule
PERSISTENT_RULE_ID	NUMBER		18	Yes	System generated unique identifier of the rule persistent id. this is the persistent id of the rule across versions/changes
INVENTORY_ITEM_ID	NUMBER		18	Yes	INVENTORY_ITEM_ID. This is Foreign Key to inventory_item_id of EGP_SYSTEM_ITEMS_B. This the root item for the model in which the rule is 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
NAME	VARCHAR2	255		Yes	User given Rule Name in Redwood.
RULE_OBJECT_TYPE	VARCHAR2	30		Yes	Indicates the type of rule. Following are the valid lookup code values:, STATEMENT
DESCRIPTION	VARCHAR2	1000			User given description of the rule.
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.
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.
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	Values PROD/ADD/UPDATE/DELETE/HISTORY
CHANGE_LINE_ID	NUMBER		18	Yes	A unique identifier of a change order. This is the change order line for the model item to which the rule belongs. This is a Foreign Key to change_line_id of ego_change_lines_b
VERSION_ID	NUMBER		18	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 item revision is scheduled to be implemented
CHANGE_BIT_MAP	VARCHAR2	400		Yes	Attribute indicating attribute changed value. Default value is 0
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.
ACTIVE_FLAG	VARCHAR2	1			Determines whether the Rule is active or not. Valid Values are Y, N, NULL. NULL is equivalent to Y.
STATUS_CODE	VARCHAR2	30			Stores current status of the rule. Valid Values are VALID, ERROR, NULL
VALID_UNTIL	TIMESTAMP				Indicates the date at which rule record will be ineffective. The NULL value indicates this record has no end date.
DEFAULTING_FLAG	VARCHAR2	1			Determines whether the Rule is defaulting rule or not. Valid Values are Y, N, NULL. NULL is equivalent to N.

Foreign Keys

Table	Foreign Table	Foreign Key Column
cz_rw_rules_tl	cz_rw_rules_b	RULE_ID

Indexes

Index	Uniqueness	Tablespace	Columns
CZ_RW_RULES_N1	Non Unique	Default	INVENTORY_ITEM_ID, ORGANIZATION_ID, NAME, DELETED_FLAG
CZ_RW_RULES_U1	Unique	Default	RULE_ID