EMR allergy master dimension table (s3)
Bi_DimEMRAllergyMaster_s3
Master dimension table containing the complete catalog of allergens, including names, categories, synonyms, and external system mappings.
Field | Field type | Description | Primary Key | Mapped Dimension table | Mapped Dimension field |
|---|---|---|---|---|---|
AllergyId | VARCHAR(36) | GUID uniquely identifying the allergy record | PK | ||
AllergenName | NVARCHAR(255) | Name of the allergen | |||
Category | SMALLINT | Category code classifying the allergen type; see EMR domain definition | |||
OrganizationId | VARCHAR(36) | GUID of the organization | Bi_DimCenter | ||
ExternalId | NVARCHAR(255) | Identifier from an external allergy reference system | |||
ExternalCode | NVARCHAR(255) | Code from an external allergy reference system | |||
FullySpecifiedName | NVARCHAR(512) | Fully specified clinical name of the allergen | |||
Synonyms | NVARCHAR(512) | Alternate names or synonyms for the allergen | |||
Active | BOOLEAN | Whether the allergy master record is currently active | |||
Void | BOOLEAN | Indicates whether the record is voided (soft-deleted) | |||
CreatedBy | VARCHAR(36) | GUID of the user who created the record | |||
CreatedDate | TIMESTAMP | Timestamp when the record was created | |||
UpdatedBy | VARCHAR(36) | GUID of the user who last updated the record | |||
UpdatedDate | TIMESTAMP | Timestamp when the record was last updated | |||
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 |