Professional > Interview scripting > Sample management > Sample management facilities > History table
 
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
Data type: int
Size: 4
Null permitted: No
History record ID.
UserId
Data type: nvarchar
Size: 50
Null permitted: Yes
Interviewer ID (__Web for inbound calls).
SampleId
Data type: nvarchar
Size: 50
Null permitted: Yes
Sample record ID.
StartTime
Data type: datetime
Size: 8
Null permitted: Yes
Interview start time in UTC.
Duration
Data type: int
Size: 4
Null permitted: Yes
Interview length in seconds.
CallOutcome
Data type: nvarchar
Size: 50
Null permitted: Yes
Call outcome code.
InterviewMode
Data type: text
Size: 64
Null permitted: Yes
Interview mode used for a particular interview.
See also
Tracking sample field changes
Sample management facilities