3. Clicdata‎ > ‎

Your data in clicdata

In order to make it possible to have all the surveys and answer responses available for report building and database wide analysis, Esensorics generates flat tables that contain all the data in columns.

Survey fields:

publishedOn - time stamp when the survey was published
createdByUser - name of the admin user who created the survey
sampleDescription - sample description
sampleName - sample name
surveyName - survey name

Sample fields:
answerComment - every question in Esensorics has comment box: .  The text saved in this comment box is here. 
answerKeyLabel - The text label of the response answer choice
answerKeyStaticLabel - The text label of the response answer choice above the slider value (only used for slider)
answerKeyValue - stores the value of selected answer defined by admin
answerValue - stores the position of selected answer
fieldLabel - field/question name
fieldType - field/question type, eg select, slider, textfield, etc

User fields, same logic as for sample fields, names start with U:

UanswerComment
UanswerKeyLabel
UanswerKeyStaticLabel
UanswerKeyValue
UanswerValue
UfieldLabel
UfieldType
userid



Comments