What table do I use to trigger a survey for users who used Employee Center?

[JLeong]

Hi Guys,

What table do I use to trigger a survey for users who used Employee Center?

sp_log doesn't contain the user's info.

Thank you!

[Pradeep Thipani]

Hi @JLeong ,

Surveys in the Employee Service Center (ESC) generally utilize the following tables:

• asmt_assessment_instance.LIST: Stores individual survey instances associated with users.
• asmt_assessment_instance_question.LIST: Holds the questions and responses submitted as part of the survey.

Let me know if you're referring to a specific use case!

Thanks,

Pradeep

[JLeong]

I need the table to use here:

[Pradeep Thipani]

@JLeong - In the trigger condition, specify the table from which the survey should be triggered, such as Incidents or Requests.

Thanks,

Pradeep

[JLeong]

Is there a table specifically for EC log?

[Pradeep Thipani]

@JLeong - No!