Auditing telephone interviewing supervisory sessions
The CatiSupervisorSession and CatiSupervisorSessionHistory tables record information about interviewer monitoring and are defined as follows:
CREATE TABLE (
SupervisorId nvarchar(128) NOT NULL
ApplicationSessionId nvarchar(128) NOT NULL
InterviewerApplicationSessionId nvarchar(128) NOT NULL
AudioMonitoring bit(1) NOT NULL DEFAULT (1)
Comments nvarchar(512) NULL
CatiSupervisorSessionStart datetime(8) NOT NULL
CatiSupervisorSessionEnd datetime(8) NULL CatiSupervisorSessionHistory table only
LastUpdated datetime(8) NOT NULL CatiSupervisorSession table only
)
Columns
ApplicationSessionId
The ID for this monitoring session.
SupervisorId
The supervisor's login name.
AudioMonitoring
Whether audio monitoring is possible.
Comments
Comments entered by the supervisor at the start or end of the session.
CatiSupervisorSessionStart
The date and time that the supervisor started the monitoring activity.
CatiSupervisorSessionEnd
The date and time that the supervisor closed the monitoring activity.
LastUpdated
The date and time that the record was last updated (records are updated periodically while monitoring is in progress).
Flowchart showing interaction of session monitoring object model with the process of monitoring interviewers
This flowchart shows what happens when a supervisor monitors interviewers and the points at which the session monitoring object model gets information for the audit trail.
See also
