Instructor classes fact table (Redshift)
Table name: bi_factinstructorclass
This table stores data on instructor classes, supporting efficient tracking, management, and reporting of class-related activities.
Field | Field Type | Description | Primary Key |
|---|---|---|---|
FactSegmentWId | BIGINT | Primary key for this table. | PK |
CenterWID | VARCHAR(36) | Unique identifier for the center. | |
EmployeeWId | VARCHAR(36) | Unique identifier for the employee. | |
OrganizationID | VARCHAR(36) | Unique identifier for the organization. | |
classguid | VARCHAR(36) | Unique identifier for the class. | |
Instructor | BIGINT | Unique identifier for 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. |