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.