Difference between revisions of "Stdorgname Table"

From edegan.com
Jump to navigation Jump to search
m (MarcelaInteriano moved page Stdorgname to Stdorgname Table)
Line 30: Line 30:
 
==Table Purpose==
 
==Table Purpose==
 
<section begin="std" />
 
<section begin="std" />
The Stdorgname Table was used to standardize firm names in the database in the Matchorgname Table.
+
The Stdorgname Table is used to standardize firm names in the database in the Matchorgname Table.
 
<section end="std" />
 
<section end="std" />
  
 
==Current Problems==
 
==Current Problems==

Revision as of 10:03, 25 July 2016

Return to Patent Data Specifications.

Table Structure

            Table "public.stdorgname"
  Column   |          Type          | Modifiers 
-----------+------------------------+-----------
stdorgname | character varying(255) | 
stdorgname            
---------------------------------
000 “Midera-K”
000 “MP ELSYS”
002134761 Ontario Ltd.
002152706 Ontario Ltd.
0055 Management Services Pty Ltd
01Click, L.L.C.
01 Communique Laboratory Inc.
01 dB Metravib
01 Inc.
0200L, LLC
02 (Germany) GmbH & Co. OHG
02IC, Inc.
02Micro
02 Micro, Inc
02Micro Intermnational Limited

Table Variables

The table consists of all the aliases and variations of a firm's name. Each entry is unique.

Table Purpose

The Stdorgname Table is used to standardize firm names in the database in the Matchorgname Table.

Current Problems