From Bright Pattern Documentation
• 日本語
wfm_agent_adherence
The wfm_agent_adherence table contains historical Workforce Management (WFM) adherence data for agents. It provides information about scheduled and actual activities, adherence status and duration, and any excused periods.
Description of Data
The following provides the column name, data type, and description for the wfm_agent_adherence 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 adherence interval |
| end_time | DATETIME | End time of the adherence interval |
| scheduled_activity_name | VARCHAR(255) | Name of the activity the agent was scheduled to perform |
| scheduled_activity_type | ENUM('lunch','break','work','planned-events','time-off') | Type of scheduled activity |
| actual_activity_name | VARCHAR(255) | Name of the agent's actual activity |
| adherent | TINYINT(1) | Indicates whether the agent was adherent during the interval |
| duration_sec | INT | Duration of the interval in seconds |
| excused_duration_sec | INT | Duration of excused non-adherence in seconds |
| excuse_comment | VARCHAR(255) | Comment associated with the excused period |
| excused_by_login_id | VARCHAR(255) | Login ID of the user who excused the non-adherence |
| excused_by_name | VARCHAR(255) | Name of the user who excused the non-adherence |
| shift_id | CHAR(26) | Identifier of the associated shift |
| version | INT | Record version used to track updates to adherence data |