Skip to main content

Employee deputation dimension table

bi_dimemployeedeputation

Field

Description

Field Type

Primary Key

centerwid

bigint

employeedeputationid

varchar ( 36 )

employeedeputationwid

bigint

employeewid

bigint

enddate

timestamp without time zone

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

organizationid

varchar ( 36 )

podid

integer

podname

varchar ( 20 )

startdate

timestamp without time zone

void

boolean

groupid

Internal to Zenoti. Used for data processing.

BIGINT