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.