IBM InfoSphere Master Data Management, Version 11.3The V_ELEMENT_PARAM table contains the parameters for a particular field level validation rule.
| Name | Comment | Datatype | Null Option | Is PK |
|---|---|---|---|---|
| PARAM_TYPE | Parameter Type can be anything that is interpreted by a validation function. For example: Param Type: MinLength; Param Value: 10. The MinLength Java function expects exactly the word "MinLength" in order to get the param value "10". | VARCHAR(50) | Not Null | Yes |
| VALIDATION_CODE | The unique identifier of a validation rule. | BIGINT | Not Null | Yes |
| PARAM_VALUE | Parameter Value can be anything that is interpreted by a validation function. For example: Param Type: MinLength; Param Value: 10. The MinLength Java function expects exactly the word "MinLength" in order to get the param value "10". | VARCHAR(50) | Not Null | Yes |
| DESCRIPTION | The description of this parameter. | VARCHAR(50) | Null | No |
| EXPIRY_DT | The date when this record becomes inactive. | TIMESTAMP | 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 |