ValueSetsvalidationTable
Indicates the base table used for validation, defining the permissible values for procurement data fields.
Columns
| Name | Type | Description |
| ValueSetsValueSetId [KEY] | Long | The unique identifier of the value set. This ID links the validation table to a specific value set, ensuring that the validation rules apply to the correct set of values. |
| ValueSetId [KEY] | Long | The unique identifier of the validation table. This ID links the validation table to a specific data table used for validating the values in the value set. |
| FromClause | String | The FROM clause used in the validation query. This clause specifies the source table(s) from which the validation data will be retrieved, enabling proper validation of value set entries. |
| WhereClause | String | The WHERE clause used in the validation query. It defines the conditions that must be met for a value to be considered valid within the value set, filtering the data accordingly. |
| OrderByClause | String | The ORDER BY clause used in the validation query, if any. It specifies the sorting order for the results of the validation query, ensuring consistent and predictable results. |
| ValueColumnName | String | The name of the value column in the validation table. This column stores the actual values that will be validated and used within the value set. |
| ValueColumnLength | Int | The length of the value column, specifying the maximum number of characters or digits that the values in this column can hold. |
| ValueColumnType | String | The data type of the value column, indicating whether the column stores strings, numbers, dates, or other types of data. |
| IdColumnName | String | The name of the ID column, if any, in the validation table. This column holds a unique identifier for each row, often used for referencing specific entries in the table. |
| IdColumnLength | Int | The length of the ID column, specifying the maximum number of characters or digits that the ID values can hold. |
| IdColumnType | String | The data type of the ID column, indicating whether the column stores integer, string, or other types of identifiers. |
| DescriptionColumnName | String | The name of the description column, if any, in the validation table. This column contains a textual description of the value stored in the value column, providing additional context. |
| DescriptionColumnLength | Int | The length of the description column, specifying the maximum number of characters or digits that the descriptions in this column can hold. |
| DescriptionColumnType | String | The data type of the description column, indicating whether the column stores strings, numbers, or other types of data used to describe the value. |
| EnabledFlagColumnName | String | The name of the enabled check box column, if any, in the validation table. This column determines whether a particular value is enabled for use in the value set. |
| StartDateColumnName | String | The start date column name, if any, in the validation table. This column indicates when a particular value or record becomes valid and eligible for use in the value set. |
| EndDateColumnName | String | The name of the end date column, if any, in the validation table. This column specifies when a particular value or record expires or is no longer valid. |
| ValueAttributesTableAlias | String | The alias of the table containing the value attribute columns, if any. This alias helps simplify referencing the value-related columns within the validation query. |
| CreationDate | Datetime | The date when the validation record was created. This timestamp is used to track the creation of the record for auditing and historical purposes. |
| CreatedBy | String | The user who created the validation record. This field helps trace the origin of the record and provides accountability for its creation. |
| LastUpdateDate | Datetime | The date when the validation record was last updated. This timestamp is important for tracking changes and ensuring the data is up-to-date. |
| LastUpdatedBy | String | The user who last updated the validation record. This provides traceability for any modifications made to the record over time. |
| Finder | String | A text field used for searching or filtering the validation records. This can help quickly locate relevant records within large datasets or when managing multiple validation rules. |
| ValueSetCode | String | The code that identifies the value set associated with this validation table. This code is used to reference the specific value set and its validation rules. |