County Codes

[Carol Riter]

Good Morning,

I'm curious how other hospitals are handling the build for county codes.  It's a lot of work for our IT department and they are pushing back on this.  Any information about formatting or shortcuts would be much appreciated.  Also I assume the 0-9 can accept multiple digits as the codes are not single digit.  

Thanks,

Carol

[Gregory Briddick, Jr.]

What platform are you trying to work on the mapping?  SQL, Python?

[Carol Riter]

Hi, We are Cerner and use CCL.  IT is working to figure out if our program needs to build logic to handle all those codes. 

[Gregory Briddick, Jr.]

I am not familiar with CCL.  Cerner typically utilizes Oracle for their databases.  If your IT is comfortable with working with JSON in their system, there is a Python code which will pull the CDCs Zipcode mapping to FIPS.  See here.....  https://github.com/bgruber/zip2fips

[Carol Riter]

Thanks so much Gregory!

--

"Make the most of yourself, for that is all there is of you."
                        Ralph Waldo Emerson