Table User[sys_user], field Country code[country], Table Location[cmn_location] field Country[country], Table Company[core_company] field Country[country] -> defined as string instead of reference

[michaelsch_fer]

Table User[sys_user]
Country code[country] is defined as string
In choice list there is an incomplete list of choices (9 country codes and one invalid? entry:
Label: javascript:'System (' + GlideLocale.get().getCurrent().getCountry() + ')'
Value: NULL_OVERRIDE

Table Location[cmn_location]
Country[country] is defined as string
In choice list there is an incomplete list of choices (9 countries)

Table Company[core_company]
Country[country] is defined as string
No choice list

Wouldn't it be better for  all three  above mentioned fields to define them as reference fields towards table Country[core_country]?

Table Country[core_country]
has got all fields 'display' attribute set to 'false'.
I propose to set for field Name[name] display to 'true'.

With referencing to Country table other attributes (like ISO-2 country code, ...) can be made available in views and reports easily.

Does anybody know why these fields are defined as String instead of Reference to table Country[core_country]?

Has anybody changed from String to Reference and made better experience with that?

With kind regards

Michael Schäfer

[neetika]

From where the currency of each country code is defined?

e.g. France has Euros , where is it defined?