This table contains data regarding status changes of agents from one status to another.
It contains data regarding:
Status changes of the agent as a whole. In this case, the field AcdGroupsID will be NULL.
Status changes of an agent in an ACD group. In this case, the field AcdGroupsID will contain the ID of the ACD Group to which the status change pertains.
Field | Type | Meaning |
|---|---|---|
ID | INT | Unique and automatic ID assigned to each record. |
dtCreated | TIMESTAMP | The date and time the record was created. |
UsersID | INT | The ID of the user for which the record was created. |
AcdAgentStatusID | INT | The ID of the agent status the user changed to when the record was created. |
UsersTelActive | VARCHAR | The active telephone number of the agent at the point in time the status change was made. |
AcdGroupsID | INT | The ID of the ACD group to which this status change pertains. NULL if the status change is for the agent as a whole. |
bGroupLoggedIn | BOOLEAN | Whether the agent was logged in to the group after the status change was made. |
ClientsID | INT | The Clients ID. |
ResellersID | INT | The Resellers ID. |
StatusDuration | INT | The duration of this status record in seconds. Note: it is not recommended to use this value if you expect values obtained from this table to add up to hours, days or weeks etc. This is due to the potential for rounding errors. It is better to calculate the time stamp differences between dtCreated and dtEndStatusinstead, whilst keeping the microsecond values as long as possible before finally (preferably in the last process step) rounding and display of the information is performed, |
LoginActionCode | INT | How the status change to this status occurred. The following values are defined: 1 = Login/Logout by telephone |
LogoutActionCode | INT | How the status change from this status occurred (when the next status record was created): 1 = Login/Logout by telephone |
ACDCDRFileName | VARCHAR | Internal field related to the transfer of this information to backend systems by the appropriate process. |
bAcdLoggedIn | BOOLEAN | Whether the agent was logged into the system after this record was created (0 = no, 1 = yes). Note that only the last record in a logout “chain” of records will contain the value 0. |
bCountedAsLoginLogout | BOOLEAN | Whether this entry counts as logging into the relevant ACD group (if ACDGroupsID IS NOT NULL) or the system (if ACDGroupsID IS NULL). 0 otherwise. |
dtEndStatus | TIMESTAMP | When the next status change was made, and this status ended. |
dtLastModified | TIMESTAMP | When the record was last modified. |
bConfirmedChangeStatus | BOOLEAN | Whether the status change was made by the agent despite a warning dialog being visible that changing status would violate the current system settings, for example pertaining to the minimum number of agents logged into an ACD group. |
UsersProfilesID | INT | The currently active UsersProfilesID for the active user profile of the user, when this status change was made. Note: this value is only completely reliable for records where AcdGroupsID IS NULL. |
bCountedAsLogIn | BOOLEAN | This field is no longer supported and may be removed in a future release. |
geom1_ClientsID | POINT | Geometry point for the fast indexing of records in this table. |
geom2_UsersID | POINT | Geometry point for the fast indexing of records in this table. |
geom3_AcdGroupsID | POINT | Geometry point for the fast indexing of records in this table. |