CZ_UI_ITEMS

Details

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

Primary Key

Name	Columns
CZ_UI_ITEMS_B_PK	START_MODEL_VERSION, UI_ITEM_ID

Columns

Name	Datatype	Length	Precision	Not-null	Comments
UI_ITEM_ID	NUMBER		18	Yes	System generated unique identifier of the UI Item.
UI_ID	NUMBER		18	Yes	System generated unique identifier of the associated UI.
PARENT_UI_ITEM_ID	NUMBER		18		Identifier of the Parent UI Item. Item with NULL parent id is identified as the root UI Item.
START_MODEL_VERSION	NUMBER		18	Yes	Indicates the version from which this UI Item will be effective.
END_MODEL_VERSION	NUMBER		18		Indicates the version from which this UI will be ineffective. The NULL value indicates this UI has no end date.
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.
UI_ITEM_TYPE	VARCHAR2	30		Yes	UI Item type indicates the type of item. Valid values are: SINGLE, GROUP, SUMMARY_GROUP
NAME	VARCHAR2	255		Yes	User given unique UI Item Name in a UI
MODEL_ID	NUMBER		18		UI Item associated model identifier.
MODEL_NODE_PATH	VARCHAR2	1000			Associated Model Node's path.
RELATIVE_NODE_PATH	VARCHAR2	1000			RELATIVE_NODE_PATH
TRANS_ATTR_ID	NUMBER		18		TIA id
SEQUENCE_NUMBER	NUMBER		38		Indicates the order of UI item/groups within their containers.
CX_RULE_ID	NUMBER		18		Indicates whether this UI Item is associated with a CX Rule.
UI_TEMPLATE_ID	NUMBER		18		Associated UI Template identifier.
INVALID_FLAG	VARCHAR2	1		Yes	If ???Y??? then this UI is in invalid state If ???N??? then this UI is valid
EMPTY_FLAG	VARCHAR2	1		Yes	This column is populated only for UI Pages (<=> parent_ui_item_id is null) : if ???Y??? then this UI Page is empty, if ???N??? then this UI Page is not empty
REFRESH_ENABLED_FLAG	VARCHAR2	1		Yes	REFRESH_ENABLED_FLAG
UI_EDITING_FLAG	VARCHAR2	1			if NULL or 'N' then this UI Item is generated bu UI Gen/UI Refresh and it was not edited in CME otherwise it was edited in CME
DISPLAY_CONDITION_ID	NUMBER		18		Refers to UI Display Condition Id
EXT_NODE_TYPE	VARCHAR2	50			extended node type of AMN associated with this UI Item
RECEIVE_NODE_CHANGE_FLAG	VARCHAR2	1			Boolean (Y/N) indicating whether to receive model node changes or not, applicable only to an IFRAME-type UI item, null value equivalent to N
NODE_CHANGE_SCOPE	VARCHAR2	30			The scope of the model node changes to receive, either Associated Model Node or Associated Model Node and Subtree, when the value of RECEIVE_NODE_CHANGE_FLAG is Y
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.
LAST_UPDATE_DATE	TIMESTAMP			Yes	Who column: indicates the date and time of the last update 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_LOGIN	VARCHAR2	32			Who column: indicates the session login associated to the user who last updated the row.

Foreign Keys

Table	Foreign Table	Foreign Key Column
CZ_UI_ITEMS_B	cz_models	MODEL_ID
CZ_UI_ITEMS_B	cz_ui_templates	UI_TEMPLATE_ID
cz_ui_items_tl	cz_ui_items_b	UI_ITEM_ID, START_MODEL_VERSION

Indexes

Index	Uniqueness	Tablespace	Columns
CZ_UI_ITEMS_B_N1	Non Unique	Default	NAME, UI_ITEM_TYPE, UI_ID, PARENT_UI_ITEM_ID, START_MODEL_VERSION, DELETED_FLAG, END_MODEL_VERSION
CZ_UI_ITEMS_B_N2	Non Unique	Default	PARENT_UI_ITEM_ID, START_MODEL_VERSION, DELETED_FLAG
CZ_UI_ITEMS_B_U1	Unique	Default	START_MODEL_VERSION, UI_ITEM_ID