Survey / questionnaire data storage

[Former Member]

Hello CRM guru's!

Does anyone know if the entered values in a questionnaire / survey are stored in tables? And if this is the case; in which tables are they stored?

Will reward points!

Regards,

Joost Goudriaan

[Former Member · Accepted solution]

Hi Joost,

The following are the tables related to the Survey. Hope this would be helpful.

To have these tables populated with values you have to define the survey configurations with the option Evaluation without Business Information Warehouse.

SURVEY TABLES

USED SURVEYS IN ACTIVITIES:

Table CRMC_SVY_DET:

Table CRM_SVY_DB_SD for Survey Title

SURVEY QUESTIONS:

Table CRM_SVY_RE_QUEST

SURVEY ANSWERS:

Table CRM_SVY_RE_ANSW

SURVEY VALUES:

SURVEY GUID LINK IN ACTIVITIES:

Table CRMD_LINK

With GUID_HI = Activity Guid with a survey

OBJTYPE_HI = "05"

OBJTYPE_SET = "58"

Result :

GUID_SET > link for value guid

SURVEY STATUS, CREATED DATA AND USER:

Table CRM_SVY_DB_SVS

SURVEY QUESTIONS AND ANSWERS ID:

Table CRM_SVY_DB_SV

Gud Luck

Hari

[marco_simon2 · Accepted solution]

Hi Hari,

facing the same problem I'd like to say thanks for your explaination of the participating tables.

There's just one last step I'm missing:

I can't find the relationship (the keys/foreign-keys) between the activity and the survey.

Or perhaps in other words:

>

> SURVEY GUID LINK IN ACTIVITIES:
> Table CRMD_LINK
>          With                GUID_HI = Activity Guid with a survey
> OBJTYPE_HI = "05"
> OBJTYPE_SET = "58"
>             Result :            
> GUID_SET > link for value guid

That GUID_SET which you named "link for value guid"... in which table can I find that key again?

I'm missing the technical relationshipt between the activity and the survey.

[Former Member · Accepted solution]

Marco:

Did you find the table that relates Survey and Activity?

Best regards,

Cristina

[Former Member]

Hi Joost.

The answer from a questionnaire, can be stored in CRM o in BW.

If you store the answer in CRM, you sould mark in "Marketing Survey Attributes" or "CrtlF12" "Evaluation without Business Information Warehouse" and your answer can see in "Extras->Display Evaluation" or "CrtlShift+F3"

If you store yours answer in BW, I can't help you.

Regards Miguel