Employee break category dimension table
bi_dimemployeebreakcategory
Field | Description | Field Type | Primary Key |
|---|---|---|---|
accountname | The break account name of the organization. In most cases, this is the same as 'organization account name'. This field is populated only when the record name is 'Break'. | varchar ( 1024 ) | |
active | A flag indicating whether the employee break category is active. This field is populated only when the 'record name' is 'Break'. | boolean | |
countinutilization | A flag indicating whether the break should be counted in utilization. This field is populated only when the 'record name' is 'Break'. | boolean | |
employeebreakcategorycode | The code associated with the break category. This field is populated only when the 'record name' is 'Break'. | varchar ( 512 ) | |
employeebreakcategoryname | The category name of the break. This field is populated only when the 'record name' is 'Break'. | varchar ( 1024 ) | |
employeebreakcategorypk | numeric | ||
employeebreakcategorywid | bigint | ||
employeebreakduration | The duration (in minutes) that is configured for the corresponding break. This is a default duration and it can be modified from the appointment book. This field is populated only when the 'record name' is 'Break'. | integer | |
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 ) | ||
organizationname | varchar ( 1024 ) | ||
podname | varchar ( 20 ) | ||
void | boolean | ||
bookable | This flag indicates if appointments can be booked during breaks for mentioned break category | boolean | |
groupid | Internal to Zenoti. Used for data processing. | BIGINT |