While combing through addresses on a data hygiene quest, I’ve run across a few interesting city names.... These were all records created via the Constituent Import Utility, and the city name came through the process as "Bra #..." (see screenshot). It’s happened on different records, from different imports run by different users.
When I checked back in the txt files with the data for these imports, the city names listed there are more mundane.
Any theories as to what these bras are and how they got in my database?
Thanks!
Hello folks,
This is interesting - I've never seen/noticed this table before. It doesn't show up in my System Tables (I'm a system admin) nor in the documentation.
I'm just curious to see if I can make it work for us here in Australia - does anyone have any notes/docs they'd share about this?
Martin
Hi Kevin,
I already use TR_PCLOOKUP table but was hoping TR_CITYSTATE might offer something more.
Thanks for the info though.