ZenotiHelp

Instructor Class Fact Table

ZTZenoti Docs Team Updated April 10, 2026 1 min readGuide

Maps instructors (employees) to the classes they teach, linking employee, center, and class dimensions.

Columns

Column Name Data Type Nullable Description
FactSegmentWID BIGINT IDENTITY NOT NULL Surrogate warehouse key for the instructor-class assignment record.
FactSegmentId BIGINT NULL Source system identifier for the instructor-class segment.
EmployeeWID BIGINT NULL Warehouse key referencing the instructor (employee) dimension.
CenterWID BIGINT NULL Warehouse key referencing the center dimension.
ClassWID BIGINT NULL Warehouse key referencing the class dimension.
InstructorPK BIGINT NULL Primary key of the instructor in the source system.
void INT NULL Flag indicating whether the record is voided (soft delete).

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

Primary Key

FactSegmentWID

Foreign Keys

Column References
EmployeeWID Bi_DimUser.userwid
CenterWID Bi_DimCenter.centerwid

Enumerator Values

Column Values
void 0 = Active, 1 = Voided
Was this article helpful?
Your feedback helps us improve our documentation.