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

JLeong
Mega Sage

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!

 

9 REPLIES 9

Pradeep Thipani
Mega Sage

Hi @JLeong ,

 

 

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

PradeepThipani_0-1733798724327.png

 

  • 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

 

 

I need the table to use here:

JLeong_0-1733800362280.png

 

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

PradeepThipani_0-1733800592745.png

 

 

Thanks,

Pradeep

 

 

Is there a table specifically for EC log?

@JLeong - No!