ZenotiHelp

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.