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.

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.

Key: Yes

Column type: Integer

Linked: Variables.VariableID

The ID of the variable to which this response corresponds.

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.

Key: No

Column type: Integer

Linked: No

The actual response for responses of type Categorical and Long.

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.