Developer Documentation Library > Data Model > Available DSCs > Relational MR database (RDB) CDSC > Relational MR Database CDSC schema > LevelResponseX table
 
LevelResponseX table
The LevelResponsesX table stores responses to categorical and integer questions that belong to LevelDepth at X.
Column
Serial
Key: Yes
Column type: Integer
Linked: No
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.
SerialX (where X is 1, 2,3, and so on)
Key: Yes
Column type: Integer
Linked: No
The number of columns of type SerialX depends on the depth of unexpanded loop variables in the hierarchy.
[Serial1 ..SerialX] is the unique identifier for this row if LevelDepth is X.
For example, [Serial1.. Serial3] is the unique identifier for this row when LevelDepth is 3.
Each column of type SerialX is part of the primary key.
VariableID
Key: Yes
Column type: Integer
Linked: Variables.VariableID
The ID of the variable to which this response corresponds.
OrderChosen
Key: Yes
Column type: Smallint
Linked: No
For categorical variables, the order in which responses are chosen. The value is auto-incrementing and provides a unique primary key. No conclusions should be drawn from the numbers in this column (the order is not consistently assigned). The order is indexed from 0. For non-categorical responses, this should always be set to 0.
Response
Key: No
Column type: Integer
Linked: No
The actual response for responses of type Categorical and Long.
Status
Key: No
Column type: Integer
Linked: No
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. In future versions it is planned to extend the possible values; for example, so you can distinguish between responses that were on and off path.
See also
Variables table
Responses2 table
OtherData2 table
ResponseSerial table
SchemaVersion table
Responses table
OtherData table
OtherID table
LevelOtherDataX table
LevelSerial table
Categories table
CategoriesLookup table
Relational MR Database CDSC schema