Service categories dimension table (s3)
S3 stage table for service-category association dimension data, mapping services to their categories.
Field | Field type | Description | Primary Key | Mapped Dimension table | Mapped Dimension field |
|---|---|---|---|---|---|
ServiceCategoryPK | DECIMAL(19,0) | Surrogate key for the service-category mapping record. | PK | ||
ServiceId | VARCHAR(36) | GUID of the service. |
| ||
CategoryId | VARCHAR(36) | GUID of the category the service belongs to. |
| ||
OrganizationId | VARCHAR(36) | GUID of the organization this record belongs to. | Bi_DimCenter | ||
Void | BOOLEAN | Indicates if the record is voided (soft-deleted). | |||
ETLLastUpdatedOn | TIMESTAMP | Timestamp of the last ETL update for this record. | |||
ETLLastUpdatedBy | VARCHAR(50) | User or process that last updated this record via ETL. | |||
Podname | VARCHAR(20) | Name of the source pod from which the data originated. | |||
groupid | BIGINT | Internal to Zenoti. Used for data processing. |