Issues fact table
Bi_FactIssues
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
|---|---|---|---|---|---|
BatchId | VARCHAR(36) | A unique identifier for the Issue Batch. | |||
Center | NVARCHAR(16000) | The Centre code | |||
Centerwid | bigint | A unique identifier for the center, generated in Centre dimension(Bi_DimCenter). | Bi_DimCenter centerwid | ||
CreatedBywid | bigint | A unique identifier of the employee who created the invoice(bi_dimuser). | Bi_Dimuser userwid | ||
CreatedDate | TIMESTAMP | Date on which the opportunity was created. This date is in the center time zone. | |||
CreatedUTCDate | TIMESTAMP | Date on which the opportunity was created. This date is in UTC time zone. | |||
DispositionId | VARCHAR(36) | Unique identifier of followup disposition | |||
EndDate | TIMESTAMP | DO NOT USE- THIS FIELD IS BEING DEPRECATED | |||
ExpectedCloseDate | TIMESTAMP | Expected close date of the opportunity. | |||
FollowUpDate | TIMESTAMP | Next follow-up date for the business to contact the guest. | |||
Guestwid | bigint | A unique identifier generated for the Guest.(Bi_DimUser) | Bi_Dimuser userwid | ||
InsertedDateTime | TIMESTAMP | The timestamp at which the record was inserted/created. | |||
IssueCategorywid | bigint | A unique identifier for the Issue Category.(Bi_DimIssueCategories) | Bi_DimIssueCategories IssueCategorywid | ||
IssueDesc | NVARCHAR(16000) | Brief description about the issue. For manual issues, the employee who created the issue provides the description. - For automatic issues, the description is auto-populated with the feedback comments provided by the guest. | |||
IssueId | VARCHAR(36) | A unique identifier for the issue. This is a non-blank value that gets populated for every issue. | |||
issuewid | bigint | A unique identifier for the issue. This is a non-blank value that gets populated for every issue. | Yes | ||
IssueNo | INT | A unique number associated with the issue. This maps to the issue no. in core. | |||
IssuePK | numeric(19) | A unique identifier(integer value) for each record generated in the fact table. | |||
IssueStatuswid | bigint | A unique identifier for the Issue Status.(Bi_DimIssueStatusType) | Bi_DimIssueStatusType IssueStatusTypewid | ||
IssueSubCategorywid | bigint | A unique identifier for the Issue SubCategory.(Bi_DimIssueSubCategories) | Bi_DimIssueSubCategories IssueSubCategorywid | ||
IssueTitle | VARCHAR(16000) | Title of the issue. For manual issues, the employee who created the issue specifies the title. - For automatic issues, the title is auto-generated in Guest Feedback (Invoice: ##) format. | |||
IssueTreatmentSourcewid | bigint | A unique identifier for the Issue Treatment Source.(Bi_DimIssueSource) | Bi_DimIssueSource IssueSourcewid | ||
IssueTreatmentwid | bigint | A unique identifier for the Issue Treatment.(Bi_DimIssueTreatment) | Bi_DimIssueTreatment IssueTreatmentwid | ||
IssueTypewid | bigint | A unique identifier for the Issue Type.(Bi_DimIssueType) | Bi_DimIssueType IssueTypewid | ||
IsVoid | BOOLEAN | Flag that indicates whether the opportunity is voided or not. - True: Opportunity is deleted - False: Opportunity is not deleted | |||
ListPrice | FLOAT | Actual price for the opportunity. | |||
Notes | VARCHAR(65535) | Notes entered against the opportunity. | |||
OfferedPrice | FLOAT | Offered price for the opportunity. This price can either be same as List Price or a bit lower so as to attract guests to make the purchase. | |||
opportunityno | INT | Unique identifier of the opportunity. This is a non-mandatory value and it can be blank. This maps to the opportunity number in the core system. This is unique within each center. | |||
OpportunityReferralSourcewid | bigint | A unique identifier for the Opportunity referral source.(Bi_DimOpportunitySource) | Bi_DimOpportunitySource OpportunitySourcewid | ||
OpportunityType | VARCHAR(16000) | Type of the opportunity. | |||
OptionalText1 | VARCHAR(16000) | Optional text field 1 to add more information about the opportunity. | |||
OptionalText2 | VARCHAR(16000) | Optional text field 2 to add more information about the opportunity. | |||
OptionalText3 | NVARCHAR(16000) | Optional text field 3 to add more information about the opportunity. | |||
OrganizationId | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter Organizationid | ||
Ownerwid | bigint | A unique identifier for the Issue Owner.(Bi_DimUser) | Bi_Dimuser userwid | ||
PODID | integer | Internal to the ETL, says from which POD data is being synced the table | |||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
PriorityTypewid | bigint | A unique identifier for the Issue Priority Type.(Bi_DimIssuePriorityType) | Bi_DimIssuePriorityType PriorityTypewid | ||
StartDate | TIMESTAMP | Date and time at which the issue was created. | |||
Therapistwid | bigint | Unique identifier for each employee who is scheduled to service the guest. This is generated in analytics and it does not exist in core.(Bi_DimUser) | Bi_Dimuser userwid | ||
TicketId | VARCHAR(36) | A unique identifier for each appointment group. Appointment group refers to a set of appointments that are booked together for a guest. This is the appointment group associated with the corresponding issue. It is generated only for automatic issues. It is blank for manual issues. | |||
UpdatedBy | VARCHAR(36) | The user that updated the issue. | |||
Void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||