ZenotiHelp

Employee Deputation Dimension Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Dimension table storing employee deputation assignments to centers, tracking the period and location of each deputation.

Columns

Column Name Data Type Nullable Description
employeedeputationwid BIGINT IDENTITY No Surrogate warehouse key for employee deputation (Primary Key)
employeedeputationid VARCHAR(36) Yes Natural unique identifier (GUID) for the employee deputation record
employeewid BIGINT Yes Foreign key reference to the employee dimension
centerwid BIGINT Yes Foreign key reference to the center dimension
startdate TIMESTAMP Yes Start date of the deputation period
enddate TIMESTAMP Yes End date of the deputation period
podid INTEGER Yes Identifier for the source Pod
void BOOLEAN Yes Soft-delete flag indicating if the record is voided

Note: All dimension tables also include standard ETL metadata columns (podname, organizationid, groupid, etlLastUpdatedOn, etlLastUpdatedBy) which are omitted from this reference for brevity.

Primary Key

employeedeputationwid

Foreign Keys

Column References
employeewid the employee dimension table
centerwid the center dimension table
Was this article helpful?
Your feedback helps us improve our documentation.