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 |
FactSegmentId | BIGINT | Source system identifier for the instructor-class segment. | |
CenterWID | VARCHAR(36) | Unique identifier for the center. | |
EmployeeWId | VARCHAR(36) | Unique identifier for the employee. | |
OrganizationID | VARCHAR(36) | Unique identifier for the organization. | |
ClassWID | BIGINT | Warehouse key referencing the class dimension. | |
InstructorPK | BIGINT | Primary key of the instructor in the source system. | |
EtlLastUpdatedOn | TIMESTAMP | Timestamp of the last ETL update (defaults to current UTC time). | |
EtlLastUpdatedBy | VARCHAR(50) | User or process that last updated this record via ETL (defaults to current user). | |
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. |