What is sn_ent_model_classification?

[cloudyrobert]

Can anyone tell me the purpose of sn_ent_model_classification? There's no documentation that I can find beyond the release notes for Expanded Model and Asset Classes that reference additions to it.

Version 2.1.0 - May 2023

• New:
  • Added new model classes for Drug, Vaccination, and Medication
  • Added new role: sn_ent.classification_manager
  • Added new fields on sn_ent_model_classification
    • Parent
    • Model categories
    • Classification (display_name)
    • Path (internal hidden field)
  • Added new ACLs on sn_ent_model_classification
    • Read for model_manager and sn_ent.classification_manager
    • Write for sn_ent.classification_manager
    • Create for sn_ent.classification_manager
  • Added new ACLs on sn_ent_model_classification_source
    • Read for sn_ent.classification_manager
    • Write for sn_ent.classification_manager
    • Create for sn_ent.classification_manager

It has just a handful of fields:

<xml>
<sn_ent_model_classification>
<cmdb_model_category/>
<code/>
<description/>
<display_name/>
<parent/>
<path/>
<source/>
<sys_created_by/>
<sys_created_on/>
<sys_domain/>
<sys_id/>
<sys_mod_count/>
<sys_updated_by/>
<sys_updated_on/>
<type/>
</sn_ent_model_classification>
</xml>

[Maik Skoddow · Accepted solution]

Hi @cloudyrobert 

unfortunately I don't have access to an instance with EAM. Therefore I can only describe my approach to come to an answer for you.

A Google search for "sn_ent_model_classification" points me to the page https://demo.erm4sn.com/table/100/d05f2764cd044d105f8f885618e9d295#.diagram which provides lots of interesting information like the table name "Enterprise model classification"

That table entered into the search of docs.servicenow.com leads me to https://docs.servicenow.com/bundle/vancouver-it-asset-management/page/product/enterprise-asset-manag... where I can read something about "Classification codes".

Another Google search for "servicenow enterprise asset management classification codes" returns the video https://www.youtube.com/watch?v=8tJaZk_jWyQ . I had no the time to watch it but maybe it can help you.

Maik

[cloudyrobert]

Well, I bow to your superior method -- ha! I did find that demo page as the only other search result, but it's mostly just data model stuff you can get out of the platform. That docs page & YouTube video were very helpful, though. I offered feedback that they add the table name to the docs page.

Anyway, for other folks, it appears basically be to support an approach to tracking third-party industry codes for models, such as ECRI for medical asset models. I still question the utility of it as an independent table as it's referenced by sn_ent_model rather than having an m2m relationship. So I don't believe this scenario is supported:

Model Infusion Pump XYZ has the code 12345 from ECRI and A5678 from the EMDN. Each of these codes gets it's own record, references the source (ECRI or EMDN), and are tied back to the model Infusion Pump XYZ through m2m relationship or one model to many codes by reference field on the classification.

Rather, you can associate multiple models with a code, but you cannot associate multiple codes with a model.