TableName | Field | Field Type | Description | PrimaryKey | MappedDimensionTable | DimensionTableField |
Bi_FactIssues_s3 | BatchId | VARCHAR(36) | A unique identifier for the Issue Batch. | |||
Bi_FactIssues_s3 | Center | NVARCHAR(16000) | The Centre code | |||
Bi_FactIssues_s3 | CenterID | VARCHAR(144) | A unique identifier for the center, generated in Centre dimension(Bi_DimCenter). | Bi_DimCenter_s3 | centerid | |
Bi_FactIssues_s3 | CreatedBy | VARCHAR(36) | A unique identifier of the employee who created the invoice(bi_dimuser). | Bi_Dimuser_s3 | userid | |
Bi_FactIssues_s3 | CreatedDate | TIMESTAMP | Date on which the opportunity was created. This date is in the center time zone. | |||
Bi_FactIssues_s3 | CreatedUTCDate | TIMESTAMP | Date on which the opportunity was created. This date is in UTC time zone. | |||
Bi_FactIssues_s3 | DispositionId | VARCHAR(36) | Unique identifier of followup disposition | |||
Bi_FactIssues_s3 | EndDate | TIMESTAMP | DO NOT USE- THIS FIELD IS BEING DEPRECATED | |||
Bi_FactIssues_s3 | ExpectedCloseDate | TIMESTAMP | Expected close date of the opportunity. | |||
Bi_FactIssues_s3 | FollowUpDate | TIMESTAMP | Next follow-up date for the business to contact the guest. | |||
Bi_FactIssues_s3 | GuestId | VARCHAR(36) | A unique identifier generated for the Guest.(Bi_DimUser) | Bi_Dimuser_s3 | userid | |
Bi_FactIssues_s3 | InsertedDateTime | TIMESTAMP | The timestamp at which the record was inserted/created. | |||
Bi_FactIssues_s3 | IssueCategoryId | VARCHAR(36) | A unique identifier for the Issue Category.(Bi_DimIssueCategories) | Bi_DimIssueCategories_s3 | IssueCategoryId | |
Bi_FactIssues_s3 | 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. | |||
Bi_FactIssues_s3 | IssueId | VARCHAR(36) | A unique identifier for the issue. This is a non-blank value that gets populated for every issue. | Yes | ||
Bi_FactIssues_s3 | IssueNo | INT | A unique number associated with the issue. This maps to the issue no. in core. | |||
Bi_FactIssues_s3 | IssuePK | DECIMAL(19,0) | A unique identifier(integer value) for each record generated in the fact table. | |||
Bi_FactIssues_s3 | IssueStatusId | VARCHAR(36) | A unique identifier for the Issue Status.(Bi_DimIssueStatusType) | Bi_DimIssueStatusType_s3 | IssueStatusTypeID | |
Bi_FactIssues_s3 | IssueSubCategoryId | VARCHAR(36) | A unique identifier for the Issue SubCategory.(Bi_DimIssueSubCategories) | Bi_DimIssueSubCategories_s3 | IssueSubCategoryId | |
Bi_FactIssues_s3 | IssueTitle | NVARCHAR(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. | |||
Bi_FactIssues_s3 | IssueTreatmentId | VARCHAR(36) | A unique identifier for the Issue Treatment.(Bi_DimIssueTreatment) | Bi_DimIssueTreatment_s3 | IssueTreatmentId | |
Bi_FactIssues_s3 | IssueTreatmentSourceId | VARCHAR(36) | A unique identifier for the Issue Treatment Source.(Bi_DimIssueSource) | Bi_DimIssueSource_s3 | IssueSourceId | |
Bi_FactIssues_s3 | IssueType | VARCHAR(36) | A unique identifier for the Issue Type.(Bi_DimIssueType) | Bi_DimIssueType_s3 | IssueTypeId | |
Bi_FactIssues_s3 | IsVoid | BOOLEAN | Flag that indicates whether the opportunity is voided or not. - True: Opportunity is deleted - False: Opportunity is not deleted | |||
Bi_FactIssues_s3 | ListPrice | FLOAT | Actual price for the opportunity. | |||
Bi_FactIssues_s3 | Notes | NVARCHAR(65535) | Notes entered against the opportunity. | |||
Bi_FactIssues_s3 | 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. | |||
Bi_FactIssues_s3 | 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. | |||
Bi_FactIssues_s3 | OpportunityReferralSourceId | VARCHAR(36) | A unique identifier for the Opportunity referral source.(Bi_DimOpportunitySource) | Bi_DimOpportunitySource_s3 | OpportunitySourceId | |
Bi_FactIssues_s3 | OpportunityType | NVARCHAR(16000) | Type of the opportunity. | |||
Bi_FactIssues_s3 | OptionalText1 | NVARCHAR(16000) | Optional text field 1 to add more information about the opportunity. | |||
Bi_FactIssues_s3 | OptionalText2 | NVARCHAR(16000) | Optional text field 2 to add more information about the opportunity. | |||
Bi_FactIssues_s3 | OptionalText3 | NVARCHAR(16000) | Optional text field 3 to add more information about the opportunity. | |||
Bi_FactIssues_s3 | OrganizationId | VARCHAR(36) | A unique identifier for the organition for which this data belongs | Bi_DimCenter_s3 | Organizationid | |
Bi_FactIssues_s3 | OwnerId | VARCHAR(36) | A unique identifier for the Issue Owner.(Bi_DimUser) | Bi_Dimuser_s3 | userid | |
Bi_FactIssues_s3 | PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
Bi_FactIssues_s3 | PriorityTypeId | VARCHAR(36) | A unique identifier for the Issue Priority Type.(Bi_DimIssuePriorityType) | Bi_DimIssuePriorityType_s3 | PriorityTypeId | |
Bi_FactIssues_s3 | StartDate | TIMESTAMP | Date and time at which the issue was created. | |||
Bi_FactIssues_s3 | TherapistId | VARCHAR(36) | 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_s3 | userid | |
Bi_FactIssues_s3 | 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. | |||
Bi_FactIssues_s3 | UpdatedBy | VARCHAR(36) | The user that updated the issue. | |||
Bi_FactIssues_s3 | Void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
Bi_FactIssues_s3 | groupid | BIGINT | Internal to Zenoti. Used for data processing. |