Instructor classes fact table (S3)
Table name: bi_factinstructorclass_s3
This table stores data on instructor classes, supporting efficient tracking, management, and reporting of class-related activities.
Field | Field Type | Description | Primary Key |
|---|---|---|---|
FactSegmentId | BIGINT | Primary key for this table. | PK |
CenterID | VARCHAR(36) | Unique identifier for the center. | |
EmployeeId | VARCHAR(36) | Unique identifier of the employee. | |
OrganizationID | VARCHAR(36) | Unique identifier for the organization. | |
classguid | VARCHAR(36) | Unique identifier of the class. | |
Instructor | BIGINT | Unique identifier of the instructor. | |
podname | VARCHAR(100) | Identifer for the region customer belongs to. Internal to Zenoti. | |
void | INT | Indicates if the record is obsolete. | |
groupid | BIGINT | Internal to Zenoti. Used for data processing. | |
etlcreateddate | TIMESTAMP | Date on which the row was created in the table. | |
etlcreatedby | BIGINT | ETL system admin user who inserted or updated the corresponding record in this table. |