• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 556
  • Last Modified:

Universal Standard for name and address data

Can somebody recommend a simple and effective standard (universal - international - ISO?) for holding names and address details in data (database/column based file).

Thanks

Carl.
0
Carl Sudholz
Asked:
Carl Sudholz
  • 3
  • 2
2 Solutions
 
Jeffrey CoachmanCommented:
Not sure what you mean here...but something like this would be fairly standard...


Table Name: Customers
Fields:
cID (Primary Key, AutoNumber)
cFName (Text)
cLName (Text)
cMiddleInit (Text)
cAddress( Text)
cAddress2 (Text)
cCity (Text)
cStateOrProvince (Text)
cPostalCode (Text)
cCountry (Text)


JeffCoachman
0
 
Carl SudholzAuthor Commented:
Thanks Jeff,

Yes that is very close to what I do now.  However, I was looking for an officially recognized Standard for personal details management - such as one by the International Organization for Standardization (ISO), or some similarly recognized Government or industry body.

My searching thus far has come up blank.
0
 
Jeffrey CoachmanCommented:
I don't think there is such a thing...
But if you are really into this sort of thing see this link:
http://www.isotc211.org/address/docs/Draft_ISO19160-1_20111208.pdf



Note that this is a very broad topic...

You can get into things like TitleOfCourtesy, Email, Phone, ...etc
...That would technically require related tables...
0
 
Carl SudholzAuthor Commented:
Thanks, that is closer to what I am after and I am aware of the complexities of the topic.  

I just thought someone would have come up with a simple and standard data dictionary for such commonly required data.
0
 
Carl SudholzAuthor Commented:
Thanks team.
0

Featured Post

Configuration Guide and Best Practices

Read the guide to learn how to orchestrate Data ONTAP, create application-consistent backups and enable fast recovery from NetApp storage snapshots. Version 9.5 also contains performance and scalability enhancements to meet the needs of the largest enterprise environments.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now