Responses2 table
The Responses2 table stores responses to categorical and integer questions. The Responses2 table is used only in the RDB DSC 2 schema.
Columns
Serial
The identifier for the respondent associated with this response. The identifier is unique within each project within the database. The Serial column stores the Respondent.Serial system variable. When a record is written, Relational MR Database CDSC generates an error if the serial number already exists for the same project within the database, and generates a new serial number if Respondent.Serial does not exist or is blank.
Key: Yes
Column type: Integer
Linked: No
VariableID
The ID of the variable to which this response corresponds.
Key: Yes
Column type: Integer
Linked: Variables.VariableID
OrderChosen
For categorical variables, the order in which responses are chosen. The value is auto-incrementing and provides a unique primary key. Do not conclude anything from the numbers in this column because the order is not consistently assigned. The order is indexed from 0. For non-categorical responses, this should always be set to 0.
Key: Yes
Column type: Smallint
Linked: No
Response
The actual response for responses of type Categorical and Long.
Key: No
Column type: Integer
Linked: No
Status
Indicates the status of the response. This always has a value of 0, which indicates that the question was asked, answered, and was on path.
Key: No
Column type: Integer
Linked: No
See also