EMR health condition master dimension table (Redshift)
Bi_DimEMRHealthConditionMaster
Master dimension table containing the complete catalog of health conditions, including names, descriptions, categories, synonyms, and external system mappings.
Field | Field type | Description | Primary Key | Mapped Dimension table | Mapped Dimension field |
|---|---|---|---|---|---|
EMRHealthConditionMasterWId | BIGINT IDENTITY | Surrogate warehouse key for the health condition master record | PK | ||
HealthConditionId | VARCHAR(36) | Unique identifier (GUID) of the health condition record from the source system | |||
ConditionName | NVARCHAR(256) | Name of the health condition | |||
ConditionDescription | NVARCHAR(512) | Descriptive text explaining the health condition | |||
Category | SMALLINT | Category code classifying the health condition type; see EMR domain definition | |||
ConditionType | SMALLINT | Type code for the health condition; see EMR domain definition | |||
ExternalId | NVARCHAR(255) | Identifier from an external health condition reference system (e.g., ICD) | |||
ExternalCode | NVARCHAR(255) | Code from an external health condition reference system | |||
FullySpecifiedName | NVARCHAR(512) | Fully specified clinical name of the condition | |||
Synonyms | NVARCHAR(512) | Alternate names or synonyms for the condition | |||
LocalizationId | NVARCHAR(255) | Localization identifier for multi-language support | |||
OrganizationId | VARCHAR(36) | Unique identifier (GUID) of the organization | an organization entity in the source system | ||
Active | BOOLEAN | Indicates whether the health condition master record is currently active | |||
Void | BOOLEAN | Indicates whether the record has been voided/soft-deleted | |||
CreatedBy | VARCHAR(36) | Identifier (GUID) of the user who created the record | |||
CreatedDate | TIMESTAMP | Timestamp when the record was created | |||
UpdatedBy | VARCHAR(36) | Identifier (GUID) of the user who last updated the record | |||
UpdatedDate | TIMESTAMP | Timestamp when the record was last updated | |||
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 |