Is there a table built for US States and Canadian provinces?

[kevinfrost471]

I am looking to add a State field to a field - I have the City and Zip field as these are just strings but I was hoping to use a choice based field for the State or Province.     Is there a table in ServiceNow where this is kept or do you have a resource where the best table can be downloaded and loaded into ServiceNow?

Thank you for any guidance!

[sergiu_panaite]

Locations are stored in cmn_location table, but I think it doesn't contains all US/Canada locations. You will probably need add them or import them:

Location setup

[mechamberlain]

I know of no pre-defined table that is included "standard" with ServiceNow.   You will probably have to build a table to reference (as you suspected).   Here are a couple of sources of information to help you...

https://simple.wikipedia.org/wiki/List_of_U.S._states

https://simple.wikipedia.org/wiki/Provinces_and_territories_of_Canada

[David Whaley]

You might want to look at the table sys_report_map it has all the State data for the USA and Province data for Canada.   It is used for the Map reports but could also be used as a source for populating the state and province fields.

[ericcrawford]

I used this and then a reference qualifier to get the values that I wanted. Thanks for the share. Was about to build a custom table to accommodate!