EMR entity field dimension table (Redshift)
Bi_DimEMREntityField
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 |
|---|---|---|---|---|---|
EMREntityFieldWId | BIGINT IDENTITY | Surrogate warehouse key for the EMR entity field record | PK | ||
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) | Unique identifier (GUID) of the entity field record | |||
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 | Indicates whether the field is currently enabled for data entry | |||
IsRequired | BOOLEAN | Indicates whether the field is required for form submission | |||
DataType | SMALLINT | Data type code for the field value; see EMR domain definition | |||
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) | Unique identifier (GUID) of the organization | an organization entity in the source system | ||
Void | BOOLEAN | Indicates whether the record has been voided/soft-deleted | |||
CreatedById | VARCHAR(36) | Identifier (GUID) of the user who created the record | |||
CreatedDate | TIMESTAMP | Timestamp when the record was created | |||
ModifiedById | VARCHAR(36) | Identifier (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 | Group identifier for multi-tenant partitioning | |||
EtlCreatedDate | TIMESTAMP | Timestamp when the ETL process created this record | |||
PodName | NVARCHAR(100) | Name of the source pod from which the data originated |