Have an idea?

Visit Sawtooth Software Feedback to share your ideas on how we can improve our products.

Difference between sys_RespNum and sys_SequentialRespNum

What is the difference between both of these variables?
Which of these is unique and cannot have a duplicate value in any case? Please explain. Thanks.
asked Nov 14, 2014 by Niks Bronze (620 points)

1 Answer

+1 vote
sys_respnum is unique resp num in csv file while sequentialresp num is a unique field created after accumulation.

sys_respnum can be duplicate across offline capi data files & sawtooth prompts to change/keep same while accumulation.
answered Nov 14, 2014 by Saurabh Aggarwal Gold (30,780 points)
And to add to Saurabh's comments, the sys_SequentialRespNum is assigned when your survey data is imported into Sawtooth whilst the sys_RespNum is assigned on the server during field work.

If you filter (e.g. completed surveys only) the sys_SequentialRespNum when exporting from Sawtooth, this field will have gaps in the numbering. Just something you should be aware of.

Thanks Saurabh for your comments too.
Thanks Saurabh and Paul!
Case: If I delete a particular record from server with sys_RespNum=7 and the field work is still on, can a new record be assigned the same value(7) for sys_RespNum?
The sys_RespNum's are assigned starting from 1 and as more respondents go in to perform the survey, they will be assigned a sys_RespNum that is the next available. This includes completed surveys, disqualifieds and incompletes. So if 1-100 sys_RespNum's have been used, the next person will be assigned sys_RespNum =101 regardless of their final status.

If you delete a survey, you will find that sys_RespNum will not be included in your final data file, hence, you will have a gap in sys_RespNum's.

Also note that in v8 under survey settings/advanced, you have the option to start the sys_RespNum at a number you desire. Check out the setting for "Respondent Number Start". This can come in handy for studies that have wave data or multiple surveys for the one study.