Custom macro data dimension table
The table is a component of center settings, allowing for optional macro storage. Ten such fields exist within organization settings, with organization-level values inherited by centers. However, centers can override these values to define specific settings. Importantly, organizations cannot modify center-specific values.
The following tables describes fields present in the custom macro data dimension table available for S3 users.
Table | Field | Description | Field type | Primary key | Mapped Dimension table Mapped Dimension field |
|---|---|---|---|---|---|
Bi_DimCustomMacroData_s3 | macroname | Optional field name | varchar(max) | ||
Bi_DimCustomMacroData_s3 | macrovalue | Optional field value | varchar(max) | ||
Bi_DimCustomMacroData_s3 | OwnerType | Indicates if value is set at center or Org level, 1- Org level, 2- center level | smallint | ||
Bi_DimCustomMacroData_s3 | centerid | Unique identifier for center | varchar(36) | bi_dimcenter_s3 centerid | |
Bi_DimCustomMacroData_s3 | organizationid | Unique identifier for organization | varchar(36) | bi_dimcenter_s3 organizationid | |
Bi_DimCustomMacroData_s3 | void | Indicates if row is active or inactive | boolean | ||
Bi_DimCustomMacroData_s3 | etllastupdatedon | Latest date on which record is updated | TIMESTAMP | ||
Bi_DimCustomMacroData_s3 | etllastupdatedby | System user id that updated the row | NVARCHAR(50) | ||
Bi_DimCustomMacroData_s3 | podname | Indicates point of delivery for customer. Internal to Zenoti | varchar(20) | ||
Bi_DimCustomMacroData_s3 | groupid | Indicates the group number in which the row is processed. Internal to Zenoti | BIGINT |