Issue categories dimension table
bi_dimissuecategories
Field | Description | Field Type | primary key |
|---|---|---|---|
active | boolean | ||
categorycode | varchar ( 256 ) | ||
categorydescription | Brief description about the category associated with the issue. | varchar ( 4096 ) | |
categoryname | Category associated with the issue. | varchar ( 256 ) | |
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 | |
issuecategoryid | varchar ( 36 ) | ||
issuecategorywid | bigint | ||
organizationid | varchar ( 36 ) | ||
podname | varchar ( 20 ) | ||
void | boolean | ||
groupid | Internal to Zenoti. Used for data processing. | BIGINT |