EMR entity field option dimension table (s3)
Bi_DimEMREntityFieldOption_s3
Master dimension table containing the predefined options for EMR custom fields, mapping each field to its selectable labels and values.
Field | Field type | Description | Primary Key | Mapped Dimension table | Mapped Dimension field |
|---|---|---|---|---|---|
EntityFieldOptionKey | NVARCHAR(300) | Composite key identifying the entity field option uniquely | PK | ||
EntityFieldId | INT | Source system integer identifier of the parent entity field | |||
EntityType | SMALLINT | Code indicating the EMR entity type the field belongs to; see EMR domain definition | |||
FieldName | NVARCHAR(255) | Internal name of the parent entity field | |||
FieldDisplayName | NVARCHAR(255) | Display label of the parent entity field | |||
OptionLabel | NVARCHAR(255) | Human-readable label for this option value | |||
OptionValue | NVARCHAR(255) | Stored value for this option | |||
OrganizationId | VARCHAR(36) | GUID of the organization | Bi_DimCenter | ||
Void | BOOLEAN | Indicates whether the record is voided (soft-deleted) | |||
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 |