Match Orgname Table

From edegan.com
Revision as of 17:44, 2 September 2016 by Carlin (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Return to Patent.

Table Purpose

The Matchorgname Table is used to match firm names to a standardized name in the database. Since firms are referred to by many variations of their names or may have a large number of subsidiaries, especially large corporations such as Samsung, the Matchorgname Table will allow us to standardize all our records on a firm and ensure that we do not miss any available data related to the organization.

Table Structure

           Table "public.matchorgname"
  Column   |          Type          | Modifiers 
-----------+------------------------+-----------
stdorgname | character varying(255) | 
orgname    | character varying(255) | 

Example of table entries:

           stdorgname            |             orgname               
---------------------------------+----------------------------------
000 “Midera-K”                   | 000 “Midera-K”
000 “MP ELSYS”                   | 000 “MP ELSYS”
002134761 Ontario Ltd.           | 002134761 Ontario Ltd.
002152706 Ontario Ltd.           | 002152706 Ontario Ltd.
002152706 Ontario Ltd.           | 002152706 ONTARIO LTD.
0055 Management Services Pty Ltd | 0055 Management Services Pty Ltd
01Click, L.L.C.                  | 01Click, L.L.C.
01 Communique Laboratory Inc.    | 01 Communique Laboratory Inc.
01 dB Metravib                   | 01 dB Metravib
01 Inc.                          | 01 Inc.

Table Variables

The stdorgname is the standardized name of a firm or organization. The orgname is any name used to refer to a firm. The table has a composite key consisting of a unique pair of stdorgname and orgname.

Current Problems

There are currently no known issues with the Match Orgname Table.