ZenotiHelp

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.