PARAM_TYPE
The PARAM_TYPE table defines a parameter that is used within a condition. The type of parameter is driven based on the type of RHS operand. For example: For an RHS operand type of "XML Header Element", the parameter type is "XMLHeaderElement". For an RHS operand type of "Static Value", the parameter type is "value". For an RHS operand type of "External Value", the parameter type is "classpath" that contains the path to a java class that can obtain the values.
This table is used by the following functional feature.
| Name | Comment | Datatype | Null Option | Is PK |
|---|---|---|---|---|
| PARAMETER_TP_CD | The Parameter Type Code. For example, "Default Static Values", "Default System Timestamp", or "Default XML Header Element". | BIGINT | Not Null | Yes |
| OPERAND_TP_CD | The type of operand (RHS) that determines how a value, or set of values, that make up the right hand side of an equation are obtained and used in evaluating constraints. For example, "Static Values", "XMLHeader Element", "System Value" (such as system time, etc.), "Any Value", "Logical Expression", "Accessor Value", "Dynamic Value", or "Object Attribute Value". | BIGINT | Not Null | No |
| NAME | A short, meaningful label for the value of the type code. | VARCHAR(120) | Not Null | No |
| DESCRIPTION | Provides extra information either as an additional definition of the type code value or as free form user comments to provide further meaning to the type code. | VARCHAR(255) | Null | No |
| MIN_PARAMS | The minimum number of parameter values required when used in a condition. | SMALLINT | Null | No |
| MAX_PARAMS | The maximum number of parameter values required when used in a condition. | SMALLINT | Null | No |
| LAST_UPDATE_DT | When a record is added or updated, this field is updated with the date and time. On subsequent updates, the system uses this information to ensure that the update request includes a matching date and time on this field; if it does not, the update fails. | TIMESTAMP | Not Null | No |