Resource dimension table
bi_dimresource
Field | Description | Field Type | Primary Key |
|---|---|---|---|
canexceedroomcapacity | A flag indicating whether the room capacity can be exceeded. | boolean | |
capacity | The capacity of the resource associated with the service. | integer | |
centerid | varchar ( 36 ) | ||
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 | |
indicatorcolor | The hexadecimal color code of the room. This is the color code that appears in the Appointment Book for appointments associated with the corresponding room. | varchar ( 128 ) | |
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
resourcecode | Unique code of the resource associated with the service. | varchar ( 128 ) | |
resourceid | varchar ( 36 ) | ||
resourcename | Name of the resource associated with the service. | varchar ( 128 ) | |
resourcetypeid | varchar ( 36 ) | ||
resourcetypename | Type of the resource associated with the service. | varchar ( 128 ) | |
resourcewid | bigint | ||
roomcategorycode | The category code of the room. | varchar ( 800 ) | |
roomcategoryid | varchar ( 36 ) | ||
roomcategoryname | The category of room associated with the service. | varchar ( 800 ) | |
showinreceipt | A flag indicating whether to show resource details in the receipt or not. | boolean | |
void | boolean | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |