User allergies fact table (s3)
Bi_FactUserAllergies_s3
Fact table recording allergy entries logged against guests, including allergen details, severity, status, and the context in which they were captured.
Field | Field type | Description | Primary Key | Mapped Dimension table | Mapped Dimension field |
|---|---|---|---|---|---|
FactSegmentId | DECIMAL(19,0) | Business/natural key for the fact segment | |||
UserAllergyPK | BIGINT | Source system primary key of the user allergy record | PK | ||
AllergyId | VARCHAR(36) | GUID of the allergy record | Bi_DimEMRAllergyMaster | ||
AllergenName | NVARCHAR(255) | Name of the allergen | |||
AllergenCategory | SMALLINT | Category code classifying the allergen type; see EMR domain definition | |||
SeverityLevel | SMALLINT | Severity level code of the allergy reaction; see EMR domain definition | |||
Notes | NVARCHAR(512) | Clinical notes associated with the allergy record | |||
SourceFK | INT | Source code indicating the origin context of the allergy record; see EMR domain definition | |||
Status | SMALLINT | Status code of the allergy record; see EMR domain definition | |||
UserId | VARCHAR(36) | GUID of the user/guest | Bi_DimUser | ||
OrganizationId | VARCHAR(36) | GUID of the organization | Bi_DimCenter | ||
RelatedType | INT | Code indicating the type of entity this allergy is related to; see EMR domain definition | |||
RelatedId | VARCHAR(36) | GUID of the related entity (e.g., appointment, form) | |||
FormId | VARCHAR(36) | GUID of the form through which the allergy was recorded | |||
RelatedTime | TIMESTAMP | Timestamp of the related entity event | |||
CriticalType | SMALLINT | Criticality classification code of the allergy; see EMR domain definition | |||
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 | |||
CenterId | VARCHAR(36) | GUID of the center | Bi_DimCenter | ||
EtlCreatedBy | DECIMAL(19,0) | ID of the ETL process/user that created this record | |||
EtlCreatedDate | TIMESTAMP | Timestamp when the ETL process created this record | |||
Void | BOOLEAN | Indicates whether the record is voided (soft-deleted) | |||
PodName | VARCHAR(20) | Name of the source pod from which the data originated | |||
groupid | BIGINT | Identifier for the data group used in ETL partitioning |