Here are field names from Win2000 Find Users, Contacts, and Groups. [Text in brackets present issues such as different text on GUI screen labels]
Tables are named with the first letter capitalized, and in the plural.
Column names begin with the table name in singular. For example:
The content of most interest within tablas are "content" columns:
It is best not to name fields "identifier" or "Id" but reserve it for computer-generated keys usually not shown to users. These are usually of numeric integer format.
These fields are usually preented on input forms for users to supply values.
Each row contains several fields to track when content values where last changed. These columns are always determined by the system and not among input fields presented to any user.
Every method which modifies the row should update this value.
Some tables have a set of create and change columns.
Most data tables have a status column.
The Status Type table provides a name and description:
Names with a status other than Active should be displayed after being appended with "(obsolete)".
For a demonstration of this, see the Countries and Currencies table.
Progamming code to test for values within this column should look for one character among many rather than assuming that the column only contains single-character values.
These fields are for date-sensitive data (which many are). "Effective" is defined by the application's business rules. For example, Content management systems define effective as the period when the row is visible to users.
Items accessed before the from date are Pending.
An application's business rules define whether dates within a row are subordinate to status flags (they usually are).
The table below lists fields in the Microsoft Active Directory used by Win2000 Find Users, Contacts, and Groups. It is (will be) compared against the names of fields in LDAP and other address database.
[Text in brackets present issues such as different text on GUI screen labels]
In the US are two offical sources of place names:
Place names that the US uses for places outside the US are maintained by NGA GEOnet Names Server (GNS) holding a database containing this format and accessible publicly from this Geonames Search Page.
The Alexandria Digital Library (ADL) Gazetteer Server (at UCSD) retrieves place and facility locations within a specified area of interest specified on a map (generated by ESRI).
Region names such as "Midwest" are not official designations.
Exonym names are used in a specific language for a geographical feature situated outside the area where that language has official status, and differing in its form from the name used in the official language or languages of the area where the geographical feature is situated.
Endonym names of a geographical feature in one of the languages occurring in that area where the feature is situated.
According to US Procedures for General Toponymic Analysis, the English name for Bahrain, Egypt, Iraq, Jordan, Kuwait, Oman, Qatar, Saudi Arabia, Syria, United Arab Emirates, and Yemen are transliterated using the BGN/PCGN 1956 Arabic Transliteration System. fuzzy matching works from provided vowels and a nine-level matching quality specification. CIA incubator InQTel provides US-GNS fuzzy searching in four additional languages: Korean, Persian, Pushto, and Urdu.
Some state codes in Australia are supposed to contain spaces.
Your first name:
Your family name:
Your location (city, country):
Your Email address:
Top of Page