EMR entity field option dimension table (Redshift)
Bi_DimEMREntityFieldOption
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 |
|---|---|---|---|---|---|
EMREntityFieldOptionWId | BIGINT IDENTITY | Surrogate warehouse key for the entity field option record | PK | ||
EntityFieldOptionKey | NVARCHAR(300) | Composite key identifying the entity field option uniquely | |||
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) | Unique identifier (GUID) of the organization | an organization entity in the source system | ||
Void | BOOLEAN | Indicates whether the record has been voided/soft-deleted | |||
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 |