User allergy reactions fact table (s3)
Bi_FactUserAllergyReactions_s3
Fact table recording the specific reactions associated with guest allergy entries.
Field | Field type | Description | Primary Key | Mapped Dimension table | Mapped Dimension field |
|---|---|---|---|---|---|
FactSegmentId | DECIMAL(19,0) | Business/natural key for the fact segment | |||
UserAllergyReactionPK | BIGINT | Source system primary key of the user allergy reaction record | PK | ||
UserAllergyReactionId | VARCHAR(36) | GUID of the allergy reaction record | |||
UserAllergyFK | BIGINT | Foreign key reference to the parent user allergy record (source system) | |||
ReactionFK | VARCHAR(36) | GUID of the reaction from the health condition master | Bi_DimEMRHealthConditionMaster | ||
ReactionName | NVARCHAR(255) | Name of the allergy reaction | |||
OrganizationId | VARCHAR(36) | GUID of the organization | Bi_DimCenter | ||
Active | BOOLEAN | Whether the allergy reaction record is currently active | |||
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 |