docs for schema/column definitions of SNOW tables

MultazimD
Kilo Contributor

Hi,

 

Where can I get docs for schema/column definitions of below SNOW tables. 

 

sn_customerservice_case

sn_customerservice_escalation

sn_customerservice_u_case_esc_sla

incident

incident_sla

 

I am working on some Analytics on Historical customer service related data and might need to see definitions of more tables in future to accurately understand what data each column contains.

3 REPLIES 3

lauri457
Giga Sage

The columns are defined on-platform in table [sys_dictionary]. incident_sla for example is just a database view of task_sla and incident and will join these two tables together.

Ankur Bawiskar
Tera Patron
Tera Patron

@MultazimD 

everything is available in docs for these tables and what they are being used for

-> sn_customerservice_case (OOTB table to store CSM Case)

-> sn_customerservice_escalation (OOTB table to store Escalations related to CSM Case)

-> incident (OOTB table to store incidents raised by end users)

-> incident_sla (OOTB Database view table joining incident and task_sla table)

-> sn_customerservice_u_case_esc_sla (Seems to be a custom table or a database view table in your instance)

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader

@MultazimD 

Thank you for marking my response as helpful.

💡 If my response helped, please mark it as correct and close the thread 🔒— this helps future readers find the solution faster! 🙏

Regards,
Ankur
Certified Technical Architect  ||  9x ServiceNow MVP  ||  ServiceNow Community Leader