Skip to main content

Issue treatment dimension table

bi_dimissuetreatment

Field

Description

Field Type

Primary Key

active

boolean

etllastupdatedby

ETL system admin user who inserted or updated the corresponding record in this table.

varchar ( 50 )

etllastupdatedon

Latest timestamp at which the corresponding record was either inserted or updated in this table.

timestamp without time zone

issuetreatmentid

varchar ( 36 )

issuetreatmentwid

bigint

organizationid

varchar ( 36 )

podname

varchar ( 20 )

treatmentcode

varchar ( 256 )

treatmentdescription

Brief description about the treatment associated with the issue.

varchar ( 4096 )

treatmentname

Treatment associated with the issue.

varchar ( 256 )

void

boolean

groupid

Internal to Zenoti. Used for data processing.

BIGINT