CZ_UI_HINTS_B
A row of this table represents the UI Hint record associated with a model node of a model version.
Details
-
Schema: FUSION
-
Object owner: CZ
-
Object type: TABLE
-
Tablespace: SYSTEM
Primary Key
| Name | Columns |
|---|---|
|
CZ_UI_HINTS_B_PK |
START_MODEL_VERSION, UI_HINT_ID |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| UI_HINT_ID | NUMBER | 18 | Yes | System generated identifier of a UI Hint associated with a model node. | |
| START_MODEL_VERSION | NUMBER | 18 | Yes | Indicates the version from which this applicability and language association record will be effective. | |
| 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. | |
| MODEL_ID | NUMBER | 18 | Yes | Associated model identifier. | |
| NODE_PATH | VARCHAR2 | 1000 | Absolute node path of the UI node that this UI hint belongs. | ||
| NODE_ID | NUMBER | 18 | identifies model nodeto which this UI Hint belongs | ||
| TRANS_ATTR_ID | NUMBER | 18 | identifies TIA to which this UI Hint belongs | ||
| CREATE_PAGE_FLAG | VARCHAR2 | 1 | When ???Y???, this model node will be represented by UI Page. Value must be ???Y??? or ???N??? for non-root Components and Option Classes, and must be NULL for root Components and all other model node types. | ||
| UI_TEMPL_ID_WHEN_REGION | NUMBER | 18 | Template to be used when model node is represented as a region in a UI. A NULL value means that the template will be retrieved from the template map. | ||
| UI_TEMPL_ID_WHEN_PAGE | NUMBER | 18 | Template to be used when model node is represented as a page in a UI. A NULL value means that the template will be retrieved from the template map. | ||
| UI_TEMPL_ID_WHEN_PAGE_ITEM | NUMBER | 18 | Template to be used when model node is represented as a page item in a UI. A NULL value means that the template will be retrieved from the template map. | ||
| UI_TEMPL_ID_WHEN_RGN_HDR | NUMBER | 18 | Template to be used to represent UI Region Header | ||
| UI_TEMPL_ID_RGN_LAYOUT1 | NUMBER | 18 | Template is used to represent UI Region Layout 1 | ||
| UI_TEMPL_ID_RGN_LAYOUT2 | NUMBER | 18 | Template is used to represent UI Region Layout 2 | ||
| UI_TEMPL_ID_RGN_LAYOUT3 | NUMBER | 18 | Template is used to represent UI Region Layout 3 | ||
| DISPLAY_FLAG | VARCHAR2 | 1 | Yes | When ???Y??? the model node will be presented in dynamic and generated User Interfaces. When ???N??? the node will not be displayed unless it is added through UI customization. | |
| DISPLAY_CONDITION_ID | NUMBER | 18 | Associated display condition identifier. | ||
| ENABLE_CONDITION_ID | NUMBER | 18 | Associated enable condition identifier. | ||
| INTEGRATION_MODE | VARCHAR2 | 30 | INTEGRATION_MODE | ||
| NESTED_GROUP_FLAG | VARCHAR2 | 1 | Indicates when to create a nested UI group. Valid values are 1/0/NULL. When equal to '1' then UI Gen will create a nested UI group for model node to which this UI hint belongs. | ||
| END_MODEL_VERSION | NUMBER | 18 | Indicates the version from which this applicability and language association record will be ineffective. The NULL value indicates this record has no end date. | ||
| 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. | |
| UI_TIMESTAMP_ADD | TIMESTAMP | Timestamp populated by CME when a row is added or has its DISPLAY_FLAG changed from N to Y | |||
| UI_TIMESTAMP_REMOVE | TIMESTAMP | Timestamp populated by CME when a row has its DISPLAY_FLAG changed from Y to N | |||
| USER_INPUT_REQUIRED_FLAG | VARCHAR2 | 1 | Y if the runtime user must provide a value for the node, N if not, null if not applicable for node of this type. | ||
| UNSELECTED_IMAGE_ATTACHMENT_ID | NUMBER | 18 | Identifier of the image attachment representing the unselected state of a configuration node. | ||
| SELECTED_IMAGE_ATTACHMENT_ID | NUMBER | 18 | Identifier of the image attachment representing the selected state of a configuration node. | ||
| EXCLUDED_IMAGE_ATTACHMENT_ID | NUMBER | 18 | Identifier of the image attachment representing the excluded state of a configuration node. | ||
| CHILD_SORT_ORDER | VARCHAR2 | 30 | Determines how the node's children will be sorted in the UI. This is currently only applicable to option feature nodes. | ||
| LAST_UPDATE_DATE | TIMESTAMP | Yes | Who column: indicates the date and time of the last update of the row. | ||
| 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_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_HINTS_B | cz_ui_templates | UI_TEMPL_ID_WHEN_REGION |
| CZ_UI_HINTS_B | cz_attachments | UNSELECTED_IMAGE_ATTACHMENT_ID |
| CZ_UI_HINTS_B | cz_models | MODEL_ID |
| CZ_UI_HINTS_B | cz_ui_templates | UI_TEMPL_ID_WHEN_PAGE |
| CZ_UI_HINTS_B | cz_ui_templates | UI_TEMPL_ID_WHEN_PAGE_ITEM |
| CZ_UI_HINTS_B | cz_attachments | SELECTED_IMAGE_ATTACHMENT_ID |
| CZ_UI_HINTS_B | cz_attachments | EXCLUDED_IMAGE_ATTACHMENT_ID |
| cz_ui_hints_tl | cz_ui_hints_b | UI_HINT_ID, START_MODEL_VERSION |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CZ_UI_HINTS_B_U1 | Unique | Default | START_MODEL_VERSION, UI_HINT_ID |