sys_choice table vs grc choice table

[amurana2]

Hello, SNOW Experts, 

I am new to SNOW GRC.  I noted that we have a sys_choice table (OOTB) in SNOW and a grc_choice table (OOTB) in SNOW GRC. 

I would like to know:

1.  What is the difference between two choice tables (sys_choice table vs grc_choice table)? 

2.  When do/should we use a grc_choice table instead of a sys_choice table as the best practice?  

3.  Do we have to use a grc_choice table for SNOW GRC apps or even if a grc_choice table is available as OOTB, can we use only a sys_choice table for SNOW GRC apps as the centralized approach?  

Thank you for the advice.  

[Notorious BFG]

Hi @amurana ! The short answer to your question is: the GRC Suite is not just a single “scoped” application (self contained in its own namespace away from global), it’s a suite of scoped applications that work together. To facilitate a shared set of common functions amongst the apps in the suite, there exists a “common/container” scoped app simply called GRC Profiles. This app is accessible to all of the GRC apps and has several shared utility functions and tables and yes, even it’s own special version of sys_choice as this made it easier to ensure a completely secure and segregated set of options that would not impact, or be impacted by changes made in global sys_choice. You’ll even note that grc_choice is extended from sys_choice and inherited many of its attributes. I hope this helps! Ben ʕﾉಠᴥಠʔﾉ*:･ﾟ✧.

[JahanzebB]

That is a really good question @amurana  about how GRC Choice Tables are needed.

Here's a quick tip to start using this table. To get a much better idea of what each Choice is used for, I would suggest adding the Application field to your GRC Choice Table.

Then from there you can determine where the GRC Choice table field is used. For example, 

These Risk Management categories are used on Risk and Risk Statements. For example, on the Risk Statements shown here, you will see the Categories Credit, Financial, IT, etc.

Bonus tip:

Also, take a look at this Entity Scoping: How GRC Community Experts do it Video for some really good tips on using the GRC.

Phillip Swan has provides a clever Tip 6 for Leveraging GRC Choice Table and  how to use the create new Choice fields on your CMDB table. I used those tips to create a Scope of Availability and Line of Business field for my CMDB table.

https://community.servicenow.com/community?id=community_article&sys_id=ac6707fadb7450502be0a851ca961...

 

Hope this helps give you an idea of how to leverage the GRC Choice table. 

Regards,

JB