ValueSets
ValueSets
Columns
Name | Type | Description |
ValueSetId [KEY] | Long | The unique identifier of the value set. |
ModuleId | String | The module ID of the value set. |
ValueSetCode | String | The value set code identifying the value set. |
Description | String | The description of the value set. |
ValidationType | String | The validation type of the value set. |
ValueDataType | String | The value data type of the value set. |
ValueSubtype | String | The value subtype of the value set. |
ProtectedFlag | String | Indicates if the value set is protected against updates. |
MaximumLength | Int | The maximum permitted length for a value. |
Precision | Int | The maximum number of digits in a value. |
Scale | Int | The maximum number of digits permitted to the right of the decimal point. |
UppercaseOnlyFlag | String | Indicates if the value must be in uppercase. |
ZeroFillFlag | String | Indicates if a value must be left-padded with zeros. |
SecurityEnabledFlag | String | Indicates if data security is enabled for this value set. |
DataSecurityObjectName | String | The name of the data security object, if any, used to secure this value set. |
MinimumValue | String | The minimum permitted value. |
MinimumValueNumber | Decimal | The minimum permitted number value. |
MinimumValueDate | Date | The minimum permitted date value. |
MinimumValueTimestamp | Datetime | The minimum permitted time stamp value. |
MaximumValue | String | The maximum permitted value. |
MaximumValueNumber | Decimal | The maximum permitted number value. |
MaximumValueDate | Date | The maximum permitted date value. |
MaximumValueTimestamp | Datetime | The maximum permitted time stamp value. |
IndependentValueSetId | Long | The value set ID, if any, of the independent value set. |
IndependentValueSetCode | String | The value set code, if any, of the independent value set. |
CreationDate | Datetime | The date when the record was created. |
CreatedBy | String | The user who created the record. |
LastUpdateDate | Datetime | The date when the record was last updated. |
LastUpdatedBy | String | The user who last updated the record. |
Finder | String | finder |