ValueSets
Holds value set definitions, ensuring controlled vocabularies and standardized validation for various fields.
Columns
| Name | Type | Description |
| ValueSetId [KEY] | Long | The unique identifier assigned to the value set, distinguishing it from other value sets. |
| ModuleId | String | The identifier of the module associated with the value set, which helps in linking the value set to a specific module. |
| ValueSetCode | String | The code used to identify the value set, which is typically used in system references. |
| Description | String | A brief description of the value set, explaining its purpose or content. |
| ValidationType | String | The type of validation applied to the values within the set, which could be a range, list, or custom validation rule. |
| ValueDataType | String | The data type associated with the values in the set, such as string, number, or date. |
| ValueSubtype | String | An optional subtype for further categorizing values in the set. |
| ProtectedFlag | String | Indicates whether the value set is protected against modifications or updates (for example, 'Y' or 'N'). |
| MaximumLength | Int | The maximum length (in characters) allowed for a value in the set. |
| Precision | Int | The maximum number of digits allowed for a value in the set, particularly relevant for numeric values. |
| Scale | Int | The maximum number of digits allowed to the right of the decimal point for numeric values. |
| UppercaseOnlyFlag | String | Indicates whether values in the set must be uppercase (for example, 'Y' or 'N'). |
| ZeroFillFlag | String | Indicates whether values should be zero-padded to meet the required length (for example, 'Y' or 'N'). |
| SecurityEnabledFlag | String | Indicates whether data security is enabled for the value set (for example, 'Y' or 'N'). |
| DataSecurityObjectName | String | The name of the data security object, if any, that is used to secure access to the value set. |
| MinimumValue | String | The minimum allowed value for the set, which can be a string, number, or date. |
| MinimumValueNumber | Decimal | The minimum permitted numerical value in the set. |
| MinimumValueDate | Date | The minimum permitted date value for the set. |
| MinimumValueTimestamp | Datetime | The minimum permitted timestamp for the value set. |
| MaximumValue | String | The maximum allowed value for the set, which can be a string, number, or date. |
| MaximumValueNumber | Decimal | The maximum permitted numerical value in the set. |
| MaximumValueDate | Date | The maximum permitted date value for the set. |
| MaximumValueTimestamp | Datetime | The maximum permitted timestamp for the value set. |
| IndependentValueSetId | Long | The ID of the independent value set, if this set is associated with one. |
| IndependentValueSetCode | String | The code of the independent value set, if applicable. |
| CreationDate | Datetime | The date when the value set record was created. |
| CreatedBy | String | The user who created the value set record. |
| LastUpdateDate | Datetime | The date when the value set record was last updated. |
| LastUpdatedBy | String | The user who last updated the value set record. |
| Finder | String | A general-purpose field used for searching or filtering value sets. |