On Tuesday, September 23, 1997 7:15 PM, FONTAIC [SMTP:[log in to unmask]]
wrote:
> Does anyone know of a HP3000 based zip code validation routine? We
> would like to integrate a product such as this into our applications to
reduce
> keying of data and data entry errors. Ideally, the subroutine would be
> passed a zip code and the valid city & state would be returned to the
> calling program and passed into our existing Image database. This
> subroutine should be updated periodically to capture new zip codes
> and/or change in zip codes.
Seveal years ago, in a prior life, we bought the TV Guide Zip Code/City
file and loaded it to a master dataset within the database. With this
scheme, the zip code can be matched with the city/town name (using certain
algorighms, which are not hard to pick up).
Many mail order houses which have "operators standing by" use this file.
(Next time you order something, and all they ask for is your zip code,
chances are, they are using this file)...
Also, the USPS can also provide you with a file of Zip Codes and
corresponding post offices. I don't know if there's a charge for this
though. The TV Guide file is more extensive in that it can handle
multiple towns in a zip code (such as 19047, which is mine, is the
Langhorne post office, but also serves Penndel and Oxford Valley, both
legal "city names").
> To continue along these lines, is there a similar product that return a
> valid address if passed a social security number (I know I'm grasping
> for straws here!)?
Ahem - this may be a bit tougher to get, as the Social Security
Administration - the keeper of these numbers - do not sell them (or at
least, they're not supposed to). Most companies which do have this
information get it from credit reporting agencie, which have quite a few
on file (if you have credit, then they have your number - it's a key to
their databases).
Best Regards,
Joe Geiser
Joe Geiser, CSI Business Solutions LLC
P: +1 (215) 945-8100 F: +1 (215) 943-8408
[log in to unmask] http://www.csillc.com
|
