EMR entity field dimension table (s3)
Bi_DimEMREntityField_s3
Master dimension table containing the custom fields defined for EMR entities, including their display names, data types, validation rules, and configuration settings.
Field | Field type | Description | Primary Key | Mapped Dimension table | Mapped Dimension field |
|---|---|---|---|---|---|
Id | INT | Source system integer identifier of the entity field | |||
EntityType | SMALLINT | Code indicating the EMR entity type this field belongs to; see EMR domain definition | |||
RowGuid | VARCHAR(36) | GUID uniquely identifying the entity field record | PK | ||
Name | NVARCHAR(255) | Internal name of the field | |||
DisplayName | NVARCHAR(255) | Display label shown to users for the field | |||
DefaultValue | NVARCHAR(512) | Default value for the field if not explicitly set | |||
Options | NVARCHAR(MAX) | Available option values for selection-type fields | |||
IsEnabled | BOOLEAN | Whether the field is currently enabled for data entry | |||
IsRequired | BOOLEAN | Whether the field is required for form submission | |||
DataType | VARCHAR(200) | Data type descriptor for the field value | |||
Description | NVARCHAR(512) | Descriptive text explaining the purpose of the field | |||
Unit | NVARCHAR(50) | Unit of measurement for the field (e.g., kg, cm) | |||
ValidationRules | NVARCHAR(1024) | Validation rules applied to the field value | |||
OrganizationId | VARCHAR(36) | GUID of the organization | Bi_DimCenter | ||
Void | BOOLEAN | Indicates whether the record is voided (soft-deleted) | |||
CreatedById | VARCHAR(36) | GUID of the user who created the record | |||
CreatedDate | TIMESTAMP | Timestamp when the record was created | |||
ModifiedById | VARCHAR(36) | GUID of the user who last modified the record | |||
ModifiedDate | TIMESTAMP | Timestamp when the record was last modified | |||
LocalizationId | NVARCHAR(255) | Localization identifier for multi-language support | |||
groupid | BIGINT | Identifier for the data group used in ETL partitioning | |||
EtlLastUpdatedOn | TIMESTAMP | Timestamp of the last ETL update for this record | |||
EtlLastUpdatedBy | NVARCHAR(50) | User or process that last updated this record via ETL | |||
podname | VARCHAR(20) | Name of the source pod from which the data originated |