History table
The sample history table, called HistoryTable, is a database table in a SQL Server database that stores history records containing information about how sample records have been used for outbound calling. sample management writes a history record to this table when:
▪an interview is terminated in some way (for example, it is completed or stopped)
or
▪the GetSampleRec function in an outbound telephone interviewing project drops a sample record (for example, because the number is busy when called).
If a sample record is called more than once, the table will contain one history record for each call.
Columns
Id
History record ID.
Data type: int
Size: 4
Null permitted: No
UserId
Interviewer ID (__Web for inbound calls).
Data type: nvarchar
Size: 50
Null permitted: Yes
SampleId
Data type: nvarchar
Size: 50
Null permitted: Yes
Sample record ID.
StartTime
Interview start time in UTC.
Data type: datetime
Size: 8
Null permitted: Yes
Duration
Interview length in seconds.
Data type: int
Size: 4
Null permitted: Yes
CallOutcome
Call outcome code.
Data type: nvarchar
Size: 50
Null permitted: Yes
InterviewMode
Interview mode used for a particular interview.
Data type: text
Size: 64
Null permitted: Yes
See also