Naming Standards for the Customer (Sponsor) and People Files

Purpose

This document provides naming standards to be used in the following files within the Oracle Applications at the Research Foundation:

• Customer
• People

Names

Proper names should be typed in mixed case (upper/lowercase).

1. Abbreviations. Names should be spelled out in full. For people, first and last names should be spelled out in full, with middle initial (no punctuation).
   For the supplier file people's names should not be prefixed with "Dr.", "Mr.", "Mrs.", etc.

   Correct	Incorrect
   James T Walsh	J Walsh
   Oracle Corporation	Oracle Corp

2. Initials. Businesses that are more commonly known by their initials than by what the initials stand for should be input as initials. Examples:
   • AT&T
   • KPMG
   • IBM Corporation
     
     Note: Remove all spaces and punctuation, use appropriate symbols, such as the ampersand (&).
     
     
3. Punctuation and symbols. Do not use periods (. commas (,) apostrophes (')parentheses(()) or semicolons (;).
   
   Exceptions: People's last names may have apostrophes (') or hyphens (-), and businesses may use an ampersand (&), such as AT&T.
   Note: Do not put spaces before or after.

   Correct	Incorrect
   Mary Braunagel-Brown	ATT
   William O'Connor
   Bills Pencil Supply Incorporated	Bill's Pencil Supply, Inc.

4. Remove "the" at the beginning of a name.

   Correct	Incorrect
   Research Foundation of State University of New York	The Research Foundation of State University of New York

5. Government Entities. The first word should be the state, county, city, or locality. Note: Use the full name as given for private organizations.

   Correct	Incorrect
   Buffalo Water Department	Water Department of Buffalo

6. Remove spaces in people's last names.

   Correct	Incorrect
   McAdoo	Mc Adoo

Addresses

All addresses should be typed in mixed case (upper/lowercase).

1. Street Address:
   • Street Name should be spelled out completely.
   • Street, Road, etc. should be spelled out completely (e.g. Street, Road, Drive, Parkway).
2. Post Office Boxes, Rural Routes:
   • Post Office Box should be abbreviated as PO Box (no periods, no space between).
   • Rural Route should be abbreviated as RR (no periods).
3. City Names:
   • City name should be spelled out completely. Common abbreviations, such as ST for SAINT are acceptable. Do not use punctuation.
4. State and Country Names:
   • State and country names should be spelled out.

Change History

• December 28, 2001 - Revised to eliminate Supplier File information. Standards for Supplier File are in a separate document "Naming Standards
  for the Supplier File.

Feedback
Was this document clear and easy to follow? Please send your feedback to webfeedback@rfsuny.org.