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 table describes fields present in the custom macro data dimension table available for redshift users.
Field | Description | Field type | Primary key | Mapped Dimension table Mapped Dimension field |
|---|---|---|---|---|
custommacrodatawid | bigint | Yes | ||
macroname | Optional field name | varchar(max) | ||
macrovalue | Optional field value | varchar(max) | ||
OwnerType | Indicates if value is set at center or Org level, 1- Org level, 2- center level | smallint | ||
centerid | Unique identifier for center | varchar(36) | bi_dimcenter centerid | |
organizationid | Unique identifier for organization | varchar(36) | bi_dimcenter organizationid | |
void | Indicates if row is active or inactive | boolean | ||
etllastupdatedon | Latest date on which record is updated | TIMESTAMP | ||
etllastupdatedby | System user id that updated the row | NVARCHAR(50) | ||
podname | Indicates point of delivery for customer. Internal to Zenoti | varchar(20) | ||
groupid | Indicates the group number in which the row is processed. Internal to Zenoti | BIGINT |