System variables
The UNICOM Intelligence products use a number of system variables. The way the system variables are used varies from product to product. For example, Respondent.Serial.SourceFile is used by UNICOM Intelligence Interviewer - Paper/Scan Add-on but not by UNICOM Intelligence Interviewer.
System variables
This section lists all the system variables. Some data sets may have some but not all of these system variables.
Respondent.ID
MDM variable type: Text
The respondent ID that links a respondent record to log entries. When the respondent data is collected using UNICOM Intelligence Interviewer Web interviewing, this is either the ID from the sample record or an ID generated randomly by UNICOM Intelligence Interviewer. It can be supplied by the interview engine host using the RespondentID property. If it is not supplied, the Respondent ID will be stored as "".
Valid values: From 0 to 50 characters.
Respondent.Origin
MDM variable type: Multiple-response categorical
The origin of the respondent data. This is the ID of the software product that created the respondent data. In UNICOM Intelligence Interviewer it is supplied by the interview engine host using the Origin property. This must be set by the engine host and cannot be changed in script. If not supplied, the value is set to Other.
Valid values: From 1 to 6 of the following categories: Scan, HTMLPlayer, CATI_HTMLPlayer, CATI_TTYPlayer, DataEntryPlayer, Other.
Respondent.Origin.Other
MDM variable type: Text
The source software product name. This is used when the Other category is specified for Respondent.Origin. In UNICOM Intelligence Interviewer it is supplied by the interview engine host using the OriginName property. This must be set by the engine host and cannot be changed in script. If not supplied, the OriginName property is based on the Origin setting. If the Origin is also not set, the OriginName is empty.
Valid values: From 0 to 25 characters.
Respondent.Serial
MDM variable type: Long
The respondent's serial number. The serial number is important for assigning a unique ID to the data for each respondent. In UNICOM Intelligence Interviewer it can be optionally supplied by the interview engine host using the Serial property. If not supplied, the next available serial number is used when writing the respondent record.
Valid values: A whole number from 1 to 2147483647.
Respondent.Serial.SourceFile
MDM variable type: Text
A source file variable indicating where the respondent serial number can be found. Typically the path to a .tiff file created during scanning.
Valid values: From 0 to 1024 characters.
DataCollection.BatchID
MDM variable type: Text
Records a unique ID for the batch.
Valid values: From 0 to 50 characters.
DataCollection.BatchName
MDM variable type: Text
Records a readable name for the batch.
Valid values: From 0 to 50 characters.
DataCollection.CurrentPage
MDM variable type: Long
The current page the respondent is answering. This is a number indicating how many pages have been answered. UNICOM Intelligence Interviewer numbers pages starting with 0 for the first page.
Valid values: A whole number from 0 to 2147483647.
DataCollection.DataEntryMode
MDM variable type: Single-response categorical
This represents the data entry case’s current mode.
Valid values: One of the following categories will be set: Initial, Full, Partial, or Maintenance.
Initial is the default value and is used for initial data entry.
Full is for full verification.
Partial is for partial verification.
Maintenance is for future use
DataCollection.Debug
MDM variable type: Text
The SIF stores some debugging information here.
UNICOM Intelligence Interviewer does not use this variable.
Valid values: From 0 to 1024 characters.
DataCollection.EndQuestion
MDM variable type: Text
When an interview is completed, stopped, or times out, this variable will hold the last question that was presented to the respondent. When an interview ends after a pause, this variable holds the pause ID number. The pause ID is a sequential number that represents the position in which the pause appears in the script. This variable is not set when an the interview crashes.
Valid values: From 0 to 255 characters.
DataCollection.FinishTime
MDM variable type: Date
The time of the last clean finish of the interview, through, for example, the respondent stopping or completing it, a clean server shutdown, or a timeout. The time is written in universal co-ordinated time (UTC). This variable is not set when an interview crashes. This variable is reset to NULL when an interview restarts.
Valid values: Any valid value for the Date variable type.
DataCollection.InterviewEngine
MDM variable type: Text
The version of the interview engine used for the interview. In UNICOM Intelligence Interviewer surveys that use the Interview Object Model, the version is of the form IOM major.minor (for example, IOM 3.0). This variable is set when the interview is created. It is not updated when the interview is restarted, even if a new version of the Interview Object Model is used for the restart.
Valid values: From 0 to 15 characters.
DataCollection.InterviewerID
MDM variable type: Text
The interviewer ID. This property is not supplied for projects using inbound sample management (the variable is then set to "") unless the TrackWebSessions option is enabled. When TrackWebSessions is enabled, the interview session token is stored for the InterviewerID.
Valid values: From 0 to 50 characters.
DataCollection.InterviewMode
MDM variable type: Single-response categorical
The current interview mode.
Valid values: The following categories can be set:
▪Web - specifies web interview case data.
▪Phone - specifies CATI interview case data.
▪Local - specifies locally deployed case data.
▪DataEntry - specifies data entry case data.
DataCollection.InterviewerTimeZone
MDM variable type: Long
The time zone which the CATI interviewer is in. It is normally supplied by the interview engine host using the InterviewerTimeZone property. If this property is not supplied, the ServerTimeZone is used instead.
Valid values: Any whole number that corresponds to a valid timezone (see
Time zone management).
DataCollection.MetadataVersion
MDM variable type: Single-response categorical
This is a derived categorical variable that makes it easy to filter case data on the metadata version used to collect it. Unlike the other system variables, this one is present at runtime only, is included only if requested, and is not persisted in the metadata. The MDM automatically creates a category in this variable for each version that you select when you open or connect to the metadata. For example, if you open versions 1, 2, and 3, this variable will have three categories, one for each version.
Valid values: The category names are of the form ver_ n where n is the version name, and the category labels show the version name.
DataCollection.MetadataVersionGUID
MDM variable type: Text
The metadata version that was used for the interview, expressed as a GUID. In UNICOM Intelligence Interviewer it is set by the Interview Object Model when the interview is created., based on the current version of the supplied MDM document.
Valid values: A GUID, which is 36 characters long.
DataCollection.MetadataVersionNumber
MDM variable type: Text
The metadata version that was used for the interview. In UNICOM Intelligence Interviewer this is set by the Interview Object Model when the interview is created, based on the current version of the supplied MDM document. If the interview is restarted, the original MDM version is used.
Valid values: From 0 to 15 characters.
DataCollection.QuotaID
MDM variable type: Long
This system variable is no longer in use. It might still exist in metadata files that were created in UNICOM Intelligence Data Model 2.4 or 2.5.
DataCollection.Removed
MDM variable type: Boolean
Indicates if the case has been removed.
Valid values: True when the case has been removed; False when a case is first created. False is the default value.
When this variable is set to True, the DataCollection.Status variable may automatically be set to Shutdown.
DataCollection.RespondentTimeZone
MDM variable type: Long
The time zone which the CATI respondent is in. It is normally supplied by the interview engine host using the RespondentTimeZone property. If this property is not supplied, the ServerTimeZone is used instead.
Valid values: Any whole number that corresponds to a valid timezone: see
Time zone management.
DataCollection.RoutingContext
MDM variable type: Single-response categorical
The routing context that was used for the interview. This is taken from the Current property of routing contexts on the supplied MDM document.
Valid values: One of the following categories: PAPER, SIF, Web.
DataCollection.SeedValue
MDM variable type: Long
The seed value for the interview. This is a random value used to control the rotation of responses, questions, and loop control items. It ensures that when you snap back and redo parts of the interview, rotated items are presented in the same order as when they were first encountered. In UNICOM Intelligence Interviewer it can be optionally supplied by the interview engine host using the SeedValue property. If not supplied, the initial SeedValue is based on the current tick count.
Valid values: Any valid value for the Long variable type.
DataCollection.ServerTimeZone
MDM variable type: Long
The time zone which the CATI interviewing server is in. This is set by the Interview Object Model when the interview is created, and is based on the time zone of the local computer.
Valid values: Any whole number that corresponds to a valid timezone: see
Time zone management.
DataCollection.StartTime
MDM variable type: Date
The interview start time, set when the interview is created. The time is written in universal co-ordinated time (UTC).
When storing the interview start and finish times, the UNICOM Intelligence Data Model automatically uses the locale of the component writing the data to convert the time to UTC. Similarly, when displaying the times, the UNICOM Intelligence Data Model uses the locale of the component displaying the data to translate from UTC.
Valid values: Any valid value for the Date variable type.
DataCollection.Status
MDM variable type: Multiple-response categorical
The status of the interview. In UNICOM Intelligence Interviewer this is based on the Interview status and the setting of the IsReview and IsTest properties as follows:
Active if interview status is isIdle or isPost.
Completed if interview status is isComplete.
RespondentStopped if interview status is isStopped.
Reviewed if the IsReview property is True.
ScriptStopped if interview status is isStopped (Suspend).
Shutdown if interview status is isShutdown. This setting may be automatically set when the DataCollection.Removed variable is set to True.
Signal if interview status is isComplete (Terminate).
Test if the IsTest property is True.
TimedOut if interview status is isTimedOut.
Valid values: From 1 to 3 categories as follows:
One of the following categories (numeric values in parenthesis): Active (7), Completed (6), RespondentStopped (10), ScriptStopped (9), Shutdown (11), Signal (13), TimedOut (8).
Plus, none, one, or both of the following categories: Reviewed (12), Test (14).
Note While the numeric values are provided here for reference, it is recommended that you use the category names whenever possible. The numeric values above may change in future versions of the product.
DataCollection.TerminateSignal
MDM variable type: Long
Signal used for termination of interview. DataCollection.Status should have the Signal category set.
Valid values: A whole number from 0 to 2147483647.
DataCollection.Variant
MDM variable type: Text
Used by UNICOM Intelligence Interviewer - Paper to store the paper variant of the questionnaire. This provides a way of implementing regional differences and simulating randomization in paper questionnaires.
Valid values: From 0 to 255 characters.
DataCleaning.Note
MDM variable type: Text
Records a note to indicate why the case data record was flagged for review, delete, and so on.
Valid values: From 0 to 1024 characters.
DataCleaning.ReviewStatus
MDM variable type: Multiple-response categorical
Records additional information about the data cleaning status.
Valid values: From 1 to 4 of the following categories: FlaggedForReview, FlaggedForMove, FlaggedForCopy, FlaggedForDelete.
DataCleaning.Status
MDM variable type: Multiple-response categorical
Indicates the cleaning status of the case data record. Typically DataCleaning.ReviewStatus and/or DataCleaning.Note will hold additional information when the NeedsReview category is set.
Valid values: One or both of the following categories: Clean, NeedsReview.
See also