Difference between revisions of "Match Orgname Table"

From edegan.com
Jump to navigation Jump to search
 
(12 intermediate revisions by 2 users not shown)
Line 1: Line 1:
Return to [[Patent Data Specifications]].
+
Return to [[Patent]].
  
 +
==Table Purpose==
 +
<section begin="orgname" />
 +
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.
 +
<section end="orgname" />
 
==Table Structure==
 
==Table Structure==
 
             Table "public.matchorgname"
 
             Table "public.matchorgname"
Line 24: Line 28:
  
 
==Table Variables==
 
==Table Variables==
==Table Purpose==
+
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==
 
==Current Problems==
 +
There are currently no known issues with the Match Orgname Table.
 +
[[Category: Internal]]
 +
[[Internal Classification: Data Tables| ]]

Latest revision as of 17:44, 2 September 2016

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.