Skip to main content

Item source dimension table

bi_dimitemsource

Field

Description

Field Type

Primary Key

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

itemsourcewid

bigint

organizationid

varchar ( 36 )

podname

varchar ( 20 )

sourcename

The application from where the appointment was created. For example, through the Employee app, the mobile app, etc.

varchar ( 128 )

sourcenum

integer

groupid

Internal to Zenoti. Used for data processing.

BIGINT