Issues Fact Table
ZTZenoti Docs Team Updated April 10, 2026 2 min readGuide
Stores issues and opportunities (tickets, leads, tasks) including status, priority, category, treatment details, pricing, ownership, and lifecycle dates.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| issuewid | BIGINT IDENTITY | No | Surrogate primary key (auto-generated) |
| issuepk | NUMERIC(19,0) | Yes | Source primary key of the issue |
| issueid | VARCHAR(36) | Yes | Unique identifier (GUID) of the issue |
| issueno | INTEGER | Yes | Human-readable issue number |
| issuetitle | VARCHAR(16000) | Yes | Title of the issue |
| issuedesc | VARCHAR(65535) | Yes | Description of the issue |
| issuetypewid | BIGINT | Yes | Foreign key to the issue type dimension |
| batchid | VARCHAR(36) | Yes | Batch identifier for grouping issues |
| issuestatuswid | BIGINT | Yes | Foreign key to the issue status dimension |
| prioritytypewid | BIGINT | Yes | Foreign key to the priority type dimension |
| centerwid | BIGINT | Yes | Foreign key to the center dimension |
| center | VARCHAR(16000) | Yes | Name of the center (denormalized) |
| createddate | TIMESTAMP | Yes | Issue creation datetime |
| createdutcdate | TIMESTAMP | Yes | Issue creation datetime in UTC |
| startdate | TIMESTAMP | Yes | Issue start date |
| enddate | TIMESTAMP | Yes | Issue end date |
| guestwid | BIGINT | Yes | Foreign key to the guest (user) dimension |
| ownerwid | BIGINT | Yes | Foreign key to the owner/assignee (user) dimension |
| listprice | DOUBLE PRECISION | Yes | List price of the opportunity |
| offeredprice | DOUBLE PRECISION | Yes | Offered price of the opportunity |
| followupdate | TIMESTAMP | Yes | Next follow-up date |
| opportunitytype | VARCHAR(16000) | Yes | Type of opportunity |
| optionaltext1 | VARCHAR(16000) | Yes | Optional custom text field 1 |
| optionaltext2 | VARCHAR(16000) | Yes | Optional custom text field 2 |
| optionaltext3 | VARCHAR(16000) | Yes | Optional custom text field 3 |
| expectedclosedate | TIMESTAMP | Yes | Expected close date for the opportunity |
| issuecategorywid | BIGINT | Yes | Foreign key to the issue category dimension |
| issuesubcategorywid | BIGINT | Yes | Foreign key to the issue subcategory dimension |
| issuetreatmentwid | BIGINT | Yes | Foreign key to the issue treatment dimension |
| issuetreatmentsourcewid | BIGINT | Yes | Foreign key to the issue treatment source dimension |
| opportunityno | INTEGER | Yes | Human-readable opportunity number |
| therapistwid | BIGINT | Yes | Foreign key to the therapist (user) dimension |
| ticketid | VARCHAR(36) | Yes | GUID of the related ticket |
| createdbywid | BIGINT | Yes | Foreign key to the user who created the issue |
| updatedby | VARCHAR(36) | Yes | GUID of the user who last updated the issue |
| opportunityreferralsourcewid | BIGINT | Yes | Foreign key to the opportunity referral source dimension |
| orgdispositionwid | BIGINT | Yes | Foreign key to the organization disposition dimension |
| void | BOOLEAN | Yes | Indicates if the record is voided |
| podid | INTEGER | Yes | Pod identifier for multi-tenant partitioning |
| inserteddatetime | TIMESTAMP | Yes | Datetime when the record was inserted into the data warehouse |
| isvoid | BOOLEAN | Yes | Flag indicating if the issue is voided |
| notes | VARCHAR(65535) | Yes | Free-text notes on the issue |
Note: All fact tables also include standard ETL metadata columns (
podname,organizationid,groupid,etlCreatedDate) which are omitted from this reference for brevity.
Primary Key
issuewid
Foreign Keys
| Column | References |
|---|---|
| centerwid | Bi_DimCenter.centerwid |
| guestwid | Bi_DimUser.userwid |
| ownerwid | Bi_DimUser.userwid |
| therapistwid | Bi_DimUser.userwid |
| createdbywid | Bi_DimUser.userwid |
Enumerator Values
| Column | Values |
|---|---|
| void | TRUE = Voided; FALSE = Active. |
| isvoid | TRUE = Voided; FALSE = Active. |
Was this article helpful?
Your feedback helps us improve our documentation.