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 |