ValueSetsvalidationTable
Specifies the underlying validation table for value sets, directing how lookups and data checks occur.
Columns
| Name | Type | Description |
| ValueSetsValueSetId [KEY] | Long | The unique identifier assigned to the value set, used to distinguish it from other value sets. |
| ValueSetId [KEY] | Long | The unique identifier of the validation table, representing the table used for validation. |
| FromClause | String | The FROM clause in the SQL query, defining the source tables for the data retrieval. |
| WhereClause | String | The WHERE clause in the SQL query, used to filter the data based on specified conditions. |
| OrderByClause | String | The ORDER BY clause in the SQL query, which determines how the resulting data is sorted, if applicable. |
| ValueColumnName | String | The name of the column in the validation table that stores the actual value for the value set. |
| ValueColumnLength | Int | The length (in characters) of the value column, indicating the maximum allowable size for the values. |
| ValueColumnType | String | The data type of the value column, which defines the kind of data it can store (for example, string, integer, date). |
| IdColumnName | String | The name of the column that holds the ID, if applicable, for identifying rows uniquely. |
| IdColumnLength | Int | The length (in characters) of the ID column, indicating the maximum allowable size for the ID. |
| IdColumnType | String | The data type of the ID column, which defines the kind of data it can store (for example, string, integer). |
| DescriptionColumnName | String | The name of the column that stores descriptions related to the values, if applicable. |
| DescriptionColumnLength | Int | The length (in characters) of the description column, indicating the maximum allowable size for descriptions. |
| DescriptionColumnType | String | The data type of the description column, which defines the kind of data it can store (for example, string, text). |
| EnabledFlagColumnName | String | The name of the column that indicates whether a value is enabled or not, typically represented as a Boolean flag. |
| StartDateColumnName | String | The name of the column that stores the start date for the validity of the value set, if applicable. |
| EndDateColumnName | String | The name of the column that stores the end date for the validity of the value set, if applicable. |
| ValueAttributesTableAlias | String | The alias for the table containing the value attribute columns, if any, used for referencing in the query. |
| CreationDate | Datetime | The date and time when the record was created in the system. |
| CreatedBy | String | The user who created the record in the system. |
| LastUpdateDate | Datetime | The date and time when the record was last updated. |
| LastUpdatedBy | String | The user who last updated the record. |
| Finder | String | A general-purpose field used for searching or filtering records in the system. |
| ValueSetCode | String | The code used to identify the value set, typically a short string that references the set in the system. |