Employee Role Dimension Table
ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide
Slowly changing dimension (SCD) table tracking employee role assignments over time, recording which role type an employee held at a given center during a specific period. Populated from employee role transactional data.
Columns
| Column Name | Data Type | Nullable | Description |
|---|---|---|---|
| dimeployeerolewid | BIGINT IDENTITY | No | Surrogate warehouse key for the employee role dimension |
| dimemployeeroleid | NUMERIC(19,0) | Yes | Natural numeric identifier of the employee role record |
| employeeid | VARCHAR(36) | Yes | Identifier of the employee |
| employeetypename | VARCHAR(128) | Yes | Display name of the employee role/type (e.g., Therapist, Manager) |
| centerid | VARCHAR(36) | Yes | Identifier of the center where the role applies |
| startdate | TIMESTAMP | Yes | Effective start timestamp of the role assignment |
| enddate | TIMESTAMP | Yes | Effective end timestamp of the role assignment |
| iscurrentrecord | BOOLEAN | Yes | SCD flag; TRUE indicates this is the most recent version of the record |
| void | BOOLEAN | Yes | Soft-delete flag; TRUE means the record is logically deleted |
| podid | INTEGER | Yes | Identifier of the source pod |
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
dimeployeerolewid
Foreign Keys
| Column | References |
|---|---|
| employeeid | Bi_DimEmployee.employeeid |
| centerid | Bi_DimCenter.centerid |
Enumerator Values
| Column | Values |
|---|---|
| employeetypename | Therapist Manager Front Desk Receptionist Stylist Trainer |
Was this article helpful?
Your feedback helps us improve our documentation.