From Bright Pattern Documentation
• 日本語
wfm_agent_schedule
The wfm_agent_schedule table contains Workforce Management (WFM) schedule data for agents. It provides information about scheduled activities, their duration and source, and the agents and teams associated with them.
Description of Data
The following provides the column name, data type, and description for the wfm_agent_schedule table.
| Column Name | Data Type | Description |
|---|---|---|
| pkid | INT | Primary key - Unique identifier of the record |
| login_id | VARCHAR(255) | Login ID of the agent |
| agent_name | VARCHAR(255) | Name of the agent |
| team_name | VARCHAR(255) | Name of the agent's team |
| start_time | DATETIME | Start time of the scheduled activity |
| end_time | DATETIME | End time of the scheduled activity |
| duration_sec | INT | Duration of the scheduled activity in seconds |
| scheduled_activity_name | VARCHAR(255) | Name of the scheduled activity |
| scheduled_activity_type | ENUM('lunch','break','work','planned-events','time-off') | Type of scheduled activity |
| schedule_source | ENUM('shift','time-off-request') | Source of the scheduled activity |
| schedule_id | CHAR(26) | Identifier of the associated schedule record |
| version | INT | Record version used to track updates to schedule data |