CZ_UI_ITEM_TEMPL_PARAM_VALS_B
This table is used to store Configuration UI Template Parameter Values associated with a UI Item of a Model Version.
Details
-
Schema: FUSION
-
Object owner: CZ
-
Object type: TABLE
-
Tablespace: SYSTEM
Primary Key
| Name | Columns |
|---|---|
|
CZ_UI_ITEM_TPARAM_VALS_B_PK |
UI_TEMPL_PARAM_VALUE_ID, START_MODEL_VERSION |
Columns
| Name | Datatype | Length | Precision | Not-null | Comments |
|---|---|---|---|---|---|
| UI_TEMPL_PARAM_VALUE_ID | NUMBER | 18 | Yes | Indentifier for the template parameter value | |
| UI_ITEM_ID | NUMBER | 18 | Yes | Associated UI item identifier. | |
| PARAMETER_ID | NUMBER | 18 | Yes | Associated UI Template parameter identifier. | |
| START_MODEL_VERSION | NUMBER | 18 | Yes | Indicates the model version from which this parameter value record will be effective. | |
| END_MODEL_VERSION | NUMBER | 18 | Indicates the model version from which this parameter value record will be ineffective. The NULL value indicates this record has no end date. | ||
| MODEL_ID | NUMBER | 18 | Yes | Associated model identifier. | |
| PARAMETER_NUMERIC_VALUE | NUMBER | Numeric value of the parameter. This value will be null when the parameter is specified as String. When no value is specified, the default value for the parameter, if defined in CZ_UI_TEMPL_PARAMETERS_B is picked up. | |||
| PARAMETER_VALUE | VARCHAR2 | 1000 | Non-translatable character parameter value. | ||
| 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. | |
| 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. | |
| 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_ITEM_TEMPL_PARAM_VALS_B | cz_models | MODEL_ID |
| cz_ui_item_templ_param_vals_tl | cz_ui_item_templ_param_vals_b | UI_TEMPL_PARAM_VALUE_ID, START_MODEL_VERSION |
Indexes
| Index | Uniqueness | Tablespace | Columns |
|---|---|---|---|
| CZ_UI_ITM_TPARAM_VALS_B_N1 | Non Unique | Default | UI_ITEM_ID, PARAMETER_ID, START_MODEL_VERSION |
| CZ_UI_ITM_TPARAM_VALS_B_U1 | Unique | Default | UI_TEMPL_PARAM_VALUE_ID, START_MODEL_VERSION |