Equipment dimension table
bi_dimequipment
Field | Description | Field Type | Primary Key |
|---|---|---|---|
active | A flag indicating whether the equipment is active. An equipment is considered inactive if it has been removed from the system. - True indicates that the equipment is active - False indicates that the equipment is inactive | boolean | |
allowtobookmorethancapacity | boolean | ||
capacity | The capacity of the equipment that is associated with a service. | integer | |
centerid | varchar ( 36 ) | ||
description | varchar ( 65535 ) | ||
equipmentcode | varchar ( 128 ) | ||
equipmentid | varchar ( 36 ) | ||
equipmentname | The name of the equipment that is associated with a service. | varchar ( 1024 ) | |
equipmentpk | numeric | ||
equipmentwid | bigint | ||
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 | |
lastupdated | timestamp without time zone | ||
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
void | boolean | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |