"omit_sys_original=" true Attribute significance on core_company table fields.

Akshay Bhoj
Tera Contributor

Hello All,

 

I see the ""omit_sys_original=" true" attribute present for core_company table fields revenue per year, profits and Market cap.

 

Could you please tell me what is the significance of this attribute and how it is being used. I tried to search it in servicenow docs but unable to get the documentation on this. 

 

Your help is much appreciated. 

 

Thanks,

Akshay

3 REPLIES 3

Bert_c1
Kilo Patron

Hi,

 

Seems you will need to create a case to find out. I have 5 fields on core_company with that attribute, all Currency type. It is not documented here:

 

DictionaryAttributes

 

Good luck.

Hi Bert,

 

Yes there is no documentation. We are not able to query these fields from third party tool even we have provided certain roles to the authenticated user except admin.

 

Thanks,

Akshay

 

SN_Learn
Kilo Patron
Kilo Patron

Hi @Akshay Bhoj ,

 

'omit_sys_original' can be set to true/false for Price and Currrency type field(s).

Jace documented: variable attributes 

 

As currency/Price field involves more complex calculations in form of currency conversion rates on a regular basis in comparison to other generic attributes. So, by setting 'omit_sys_original' to true will avoid retrieving the original value of the field which will enhance the data processing and improve the performance.

 

So, all in all it looks like this attributes helps to reduce performance impacts for the currency or price field.

 

Mark this as Helpful / Accept the Solution if this helps

----------------------------------------------------------------
Mark this as Helpful / Accept the Solution if this helps.