US State/Province choice list or reference table

[Thomas Weyer]

I have yet another project where I need to include a field for a US State.  (Yes, a complete address - I would like to offer the users the ability to select a state from a list instead of freeform text)

Is there a recommended table or choice list OOB that should be used for US States? 

I've tried using the sys_report_map table ... it works most of the time, yet seems a bit cumbersome.  I also feel like I'm using a table for a purpose it was not intended. 

Thanks,
Thomas

[DrewW]

We just created a States and Provinces custom table for this and populated it.  We then used the USPS web service to get zip codes when needed.

[Thomas Weyer]

Yeah, I could do this... it just "feels" that there should be an OOB table with this common data already.  I'm trying not to re-invent something if it already exists.  

Now I'm thinking to either use the sys_report_map table or using this suggestion to create a custom table for county/zip/state to use in our custom apps. 

[Prateek kumar]

Please take a look at the below thread:

https://community.servicenow.com/community?id=community_question&sys_id=95af0623dbda7b00feb1a851ca96...

[BryGuy]

You've probably solved this but for others your best bet is probably to just change the 'state/province' field on the user table to a choice list and create/generate the choices yourself. Then you can 'source' other choice lists from this field moving forward.