CZ_UIS
It is the header table for User Interface of a Configurator Model. Each row on this table represents the User Interface (UI) of a Model Version.
Details
-
Schema: FUSION
-
Object owner: CZ
-
Object type: TABLE
-
Tablespace: SYSTEM
Primary Key
Name | Columns |
---|---|
CZ_UIS_PK |
START_MODEL_VERSION, UI_ID |
Columns
Name | Datatype | Length | Precision | Not-null | Comments |
---|---|---|---|---|---|
UI_ID | NUMBER | 18 | Yes | System generated unique identifier of the UI. | |
CONTEXTUAL_SUMMARY_TEMPL_ID | NUMBER | 18 | Specifies the contextual summary template to use for this UI. A null value indicates no contextual summary will be rendered. | ||
START_MODEL_VERSION | NUMBER | 18 | Yes | Indicates the version from which this UI 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. | |
MODEL_ID | NUMBER | 18 | Yes | Identifier of the model to which the UI belongs. | |
NAME | VARCHAR2 | 255 | Yes | User given UI Name | |
DESCRIPTION | VARCHAR2 | 1000 | User given description of the UI. | ||
UI_TEMPLATE_MAP_ID | NUMBER | 18 | UI_TEMPLATE_MAP_ID | ||
SHELL_TEMPLATE_AS_CHILD | NUMBER | 18 | SHELL_TEMPLATE_AS_CHILD | ||
SHELL_TEMPLATE_AS_PARENT | NUMBER | 18 | SHELL_TEMPLATE_AS_PARENT | ||
INVALID_FLAG | VARCHAR2 | 1 | Yes | If 'Y' then this UI is in invalid state If 'N' then this UI is valid | |
REFRESH_ENABLED_FLAG | VARCHAR2 | 1 | Yes | REFRESH_ENABLED_FLAG | |
UI_TIMESTAMP_REFRESH | TIMESTAMP | Timestamp populated at the end of a successful UI refresh. | |||
EXT_MODEL_KEY | VARCHAR2 | 50 | specifies model key of model for which there is no CZ_MODELS entry (externa model) | ||
UI_TYPE | VARCHAR2 | 10 | specifies UI Type : DYNAMIC, STANDARD or EMPTY | ||
HIDE_EXCLUDED_ITEMS_FLAG | VARCHAR2 | 1 | Yes | If 'Y' then hide excluded UI items in runtime | |
SHOW_HIDDEN_TIAS_FLAG | VARCHAR2 | 1 | This flag indicates whether to display hidden transactional item attributes on the Finish and Review page. Default value is NULL or N. If Y, then hidden TIAs will be displayed in the configuration summary page. | ||
SEQUENCE_NUMBER | NUMBER | 38 | Yes | Indicates the relative position of the UI within the rest of uis of the model | |
ANY_APPLICATION_FLAG | VARCHAR2 | 1 | Yes | 'Y' signifies if all of the registered applications are part of UI applicability definition.'N' signifies only explicitly chosen applications (recorded in CZ_UI_APPLIC_CALL_APPS) are part of UI applicability definition. | |
ANY_LANGUAGE_FLAG | VARCHAR2 | 1 | Yes | 'Y' signifies if all of the installed languages are part of UI applicability definition.'N' signifies only explicitly chosen languages (recorded in CZ_UI_APPLIC_LANGUAGES) are part of UI applicability definition. | |
UI_USAGE | VARCHAR2 | 255 | User given UI usage name. | ||
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 physically 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_UIS | cz_models | MODEL_ID |
Indexes
Index | Uniqueness | Tablespace | Columns |
---|---|---|---|
CZ_UIS_N1 | Non Unique | Default | MODEL_ID, NAME, DELETED_FLAG, END_MODEL_VERSION, START_MODEL_VERSION |
CZ_UIS_U1 | Unique | Default | START_MODEL_VERSION, UI_ID |