Abbreviation standards

Nick Cianci

Abbreviation standards
Dear List,
is anybody out there aware of an industry standard governing the
abbreviation of field name. If you could forward / post URLs .... etc I'd
be appreciative.

The sort of thing that I'm after is :-
1. Take a word "Abbreviation"
2. remove non-leading vowels ==> Abbrvtn
3. remove repeating characters ==> Abrvtn

Of course nothing is ever that simple, and the mob I'm working with are
wondering if there is a published or well known standard out there for
Abbreviating? I must confess I haven't heard of one, so I thought I'd
canvas the list and hit "Google"

TIA

Cheers,
Nick F. Cianci
IBM Certified Solutions Expert
- DB2 UDB V7.1 Database Administration for OS/390
MailTo:[login to unmask email] <MailTo:[login to unmask email]>

Non scholae sed vitae discimus.

This correspondence is for the named person's use only. It may contain
confidential or legally privileged information or both. No confidentiality
or privilege is waived or lost by this transmission. If you receive this
correspondence in error, please immediately delete it from your system and
notify the sender. You must not disclose, copy or rely on any part of this
correspondence if you are not the intended recipient.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Jim Harrison

Re: Abbreviation standards
(in response to Nick Cianci)
While you are Googling, I'll jump in to say I've not heard of one
either. However, FWIW, I'll offer up our web pages on the subject. Most
of the time our DAs try to run models through a mysterious Erwin process to
automate the abbreviation function - I've still not figured out how it
works. But here are the instructions for creating your own abbreviations.

http://www.cms.hhs.gov/it/database/dastandards/physname.asp#Creating%20Manually

We also maintain a database of words that we've already decided on and you
can query it here (my little contribution to the WWW - it's SQL Server,
not DB2):

http://www.cms.hhs.gov/it/database/naming_tool/default.asp

At 05:42 PM 1/13/2004, Cianci, Nick said:

>Of course nothing is ever that simple, and the mob I'm working with are
>wondering if there is a published or well known standard out there for
>Abbreviating? I must confess I haven't heard of one, so I thought I'd
>canvas the list and hit "Google"

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Walter Eachus

Re: Abbreviation standards
(in response to Jim Harrison)
Nick

I use as a double check the following site : https://dm-app1.dfas.mil/CDTS/

I am a DA and use this often. Most of the times it is a help or a clue.

Walt

-----Original Message-----
From: DB2 Data Base Discussion List [mailto:[login to unmask email] On Behalf
Of Cianci, Nick
Sent: Tuesday, January 13, 2004 5:42 PM
To: [login to unmask email]
Subject: Abbreviation standards


Dear List,
is anybody out there aware of an industry standard governing the
abbreviation of field name. If you could forward / post URLs .... etc I'd
be appreciative.

The sort of thing that I'm after is :-
1. Take a word "Abbreviation"
2. remove non-leading vowels ==> Abbrvtn
3. remove repeating characters ==> Abrvtn

Of course nothing is ever that simple, and the mob I'm working with are
wondering if there is a published or well known standard out there for
Abbreviating? I must confess I haven't heard of one, so I thought I'd
canvas the list and hit "Google"

TIA

Cheers,
Nick F. Cianci
IBM Certified Solutions Expert
- DB2 UDB V7.1 Database Administration for OS/390
MailTo:[login to unmask email] <MailTo:[login to unmask email]>

Non scholae sed vitae discimus.

This correspondence is for the named person's use only. It may contain
confidential or legally privileged information or both. No confidentiality
or privilege is waived or lost by this transmission. If you receive this
correspondence in error, please immediately delete it from your system and
notify the sender. You must not disclose, copy or rely on any part of this
correspondence if you are not the intended recipient.

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm


------------------------------------------------------------------------------
This message is intended only for the personal and confidential use of the
designated recipient(s) named above. If you are not the intended recipient of
this message you are hereby notified that any review, dissemination,
distribution or copying of this message is strictly prohibited. This
communication is for information purposes only and should not be regarded as
an offer to sell or as a solicitation of an offer to buy any financial
product, an official confirmation of any transaction, or as an official
statement of Lehman Brothers. Email transmission cannot be guaranteed to be
secure or error-free. Therefore, we do not represent that this information is
complete or accurate and it should not be relied upon as such. All
information is subject to change without notice.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Bob Galeotti

Re: Abbreviation standards
(in response to Walter Eachus)
Nick -
Not sure if these are "Standards", as that's anyone's definition, but
here's some "Ideas":

http://www.oit.umd.edu/units/dataadmin/Standards/standards.html

http://www.cas.org/ONLINE/standards.html

http://www.eit.utoledo.edu/administrativecomputing/data_warehouse/DW_Abrv_Standards.htm

http://www.for.gov.bc.ca/his/datadmin/s19appb.htm

HTH,

Bob Galeotti, Sales Tech Support
SoftBase Systems, Inc.
800.669.7076 x372
[login to unmask email]
http://www.softbase.com/

----- Original Message -----
From: "Cianci, Nick" <[login to unmask email]>
Newsgroups: bit.listserv.db2-l
To: <[login to unmask email]>
Sent: Tuesday, January 13, 2004 5:42 PM
Subject: Abbreviation standards


> Dear List,
> is anybody out there aware of an industry standard governing the
> abbreviation of field name. If you could forward / post URLs .... etc I'd
> be appreciative.
>
> The sort of thing that I'm after is :-
> 1. Take a word "Abbreviation"
> 2. remove non-leading vowels ==> Abbrvtn
> 3. remove repeating characters ==> Abrvtn
>
> Of course nothing is ever that simple, and the mob I'm working with are
> wondering if there is a published or well known standard out there for
> Abbreviating? I must confess I haven't heard of one, so I thought I'd
> canvas the list and hit "Google"
>
> TIA
>
> Cheers,
> Nick F. Cianci
> IBM Certified Solutions Expert
> - DB2 UDB V7.1 Database Administration for OS/390
> MailTo:[login to unmask email] <MailTo:[login to unmask email]>
>
> Non scholae sed vitae discimus.
>
> This correspondence is for the named person's use only. It may contain
> confidential or legally privileged information or both. No
confidentiality
> or privilege is waived or lost by this transmission. If you receive this
> correspondence in error, please immediately delete it from your system and
> notify the sender. You must not disclose, copy or rely on any part of
this
> correspondence if you are not the intended recipient.
>
> --------------------------------------------------------------------------
-------
> Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and
home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page
select "Join or Leave the list". The IDUG DB2-L FAQ is at
http://www.idugdb2-l.org. The IDUG List Admins can be reached at
[login to unmask email] Find out the latest on IDUG conferences at
http://conferences.idug.org/index.cfm
>

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

Glenn mackey

Re: Abbreviation standards
(in response to Bob Galeotti)
This is out of my manual. It covers the method, I think you have the actual
abbreviations covered.
Also, the text below was in a word document table, which got lost in the cut
and paste. It is in the form, instruction, followed by example and built on
in the next step.


5.1.3 Steps to create a column name
Below are the steps along with an example to illustrate.

1. Rule Example
2. Write a descriptive sentence describing the column listing all
significant characteristics These characteristics are the modifiers.

Example: The date when the automobile insurance medical claim was approved.
3. Remove unimportant joining words, prepositions and words, which add
little or no extra meaning. Keep words describing the major aspects of the
column.
Example: Date automobile, insurance medical claim approved.
4. Arrange the remaining modifiers into a meaningful sequence. Extra words
may have to be introduced.
Example: Automobile insurance medical claim date

5. Assign a classifier. Refer to the classifier list to get values.

For this example, date is the classifier. Ask "what type of data is
represented".
6. If the column name is within the 18-character limit before any
abbreviations are applied, use it if it meets the guidelines at the end of
this table, else continue with step 7.

7. Create a data element name by abbreviating the modifiers where required
and adding the 2-character classifier suffix. Auto_ins_med_clm_aprv_dt
This is 24 characters in length.

8. If the 18-character limit is exceeded, drop modifiers or consider
abbreviating non-abbreviated words until the 18-character limit is enforced.

a) Med_Clm_Aprv_Dt
b) Auto_Clm_Aprv_Dt
c) Claim_Approve_Dt

9. Unfortunately, sometimes the column name may seem very unintuitive, but
until the 18-character limit is removed, there is no alternative. This
example has a few options, and the final decision will depend on the
application and the main keywords that convey the most significant meaning
of the data represented by the column.

Do not use complete words in the following situations, even though the
length does not exceed 18 characters.
§ Always use the abbreviation for PLCY_NO, AGNT_ID.
§ If the table in question, or generally other tables for the applications,
or generally all applications abbreviate the data element, continue to
abbreviate the data element. This is really following a previously set
precedence.
§ If 18 characters limit is hit, and you cannot feel you can remove an
abbreviated modifier, consider making an abbreviation of 2 abbreviations. Eg
Med_Clm à MClm



-----Original Message-----
From: Cianci, Nick [mailto:[login to unmask email]
Sent: Tuesday, January 13, 2004 4:42 PM
To: [login to unmask email]
Subject: Abbreviation standards


Dear List,
is anybody out there aware of an industry standard governing the
abbreviation of field name. If you could forward / post URLs .... etc I'd
be appreciative.

The sort of thing that I'm after is :-
1. Take a word "Abbreviation"
2. remove non-leading vowels ==> Abbrvtn
3. remove repeating characters ==> Abrvtn

Of course nothing is ever that simple, and the mob I'm working with are
wondering if there is a published or well known standard out there for
Abbreviating? I must confess I haven't heard of one, so I thought I'd
canvas the list and hit "Google"

TIA

Cheers,
Nick F. Cianci
IBM Certified Solutions Expert
- DB2 UDB V7.1 Database Administration for OS/390
MailTo:[login to unmask email] <MailTo:[login to unmask email]>

Non scholae sed vitae discimus.

This correspondence is for the named person's use only. It may contain
confidential or legally privileged information or both. No confidentiality
or privilege is waived or lost by this transmission. If you receive this
correspondence in error, please immediately delete it from your system and
notify the sender. You must not disclose, copy or rely on any part of this
correspondence if you are not the intended recipient.

----------------------------------------------------------------------------
-----
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home
page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select
"Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org.
The IDUG List Admins can be reached at [login to unmask email] Find
out the latest on IDUG conferences at http://conferences.idug.org/index.cfm

This message and accompanying documents are covered by the Electronic
Communications Privacy Act, 18 U.S.C. §§ 2510-2521, and contains information
intended for the specified individual(s) only. This information is
confidential. If you are not the intended recipient or an agent responsible
for delivering it to the intended recipient, you are hereby notified that
you have received this document in error and that any review, dissemination,
copying, or the taking of any action based on the contents of this
information is strictly prohibited. If you have received this communication
in error, please notify us immediately by e-mail, and delete the original
message.

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm