Feedback v2 fact table
Bi_FactFeedBackV2_s3
Field | Field Type | Description | PrimaryKey | MappedDimensionTable DimensionTableField | |
AppGroupId | VARCHAR(36) | appointment group id | |||
etlCreatedBy | DECIMAL(19,0) | ETL system admin user who inserted or updated the corresponding record in this table. | |||
etlCreatedDate | TIMESTAMP | Latest timestamp at which the corresponding record was either inserted or updated in this table. | |||
FeedBackId | DECIMAL(19,0) | Unique identifier for the row. Primary Key | Yes | ||
OrganizationId | VARCHAR(36) | A unique identifier for the organization for which this data belongs | Bi_DimCenter_s3 OrganizationId | ||
PodName | VARCHAR(20) | Internal to the ETL, says from which POD data is being synced the table | |||
Tag1 | NVARCHAR(65535) | tags in feedback form | |||
Tag2 | NVARCHAR(65535) | tags in feedback form | |||
Tag3 | NVARCHAR(65535) | tags in feedback form | |||
Tag4 | NVARCHAR(65535) | tags in feedback form | |||
Tag5 | NVARCHAR(65535) | tags in feedback form | |||
Tag6 | NVARCHAR(65535) | tags in feedback form | |||
Tag7 | NVARCHAR(65535) | tags in feedback form | |||
Tag8 | NVARCHAR(65535) | tags in feedback form | |||
Void | BOOLEAN | Indicates if the row should be inserted or deleted. 1- delete, 0-insert | |||
groupid | Internal to Zenoti. Used for data processing. | BIGINT | |||