Service segment dimension table
bi_dimservicesegment
Field | Description | Field Type | Primary Key |
|---|---|---|---|
commission | double precision | ||
etllastupdatedby | ETL system admin user who inserted or updated the corresponding record in this table. | varchar ( 50 ) | |
etllastupdatedon | Latest timestamp at which the corresponding record was either inserted or updated in this table. | timestamp without time zone | |
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
segmentorder | integer | ||
serviceid | varchar ( 36 ) | ||
servicesegmentid | varchar ( 36 ) | ||
servicesegmentlength | The ideal time taken to complete a segment (in minutes), as setup in Zenoti. | integer | |
servicesegmentname | The name of the segment. | varchar ( 512 ) | |
servicesegmenttype | integer | ||
servicesegmentwid | bigint | ||
void | smallint | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |