Difference between revisions of "Stdorgname Table"

From edegan.com
Jump to navigation Jump to search
Line 29: Line 29:
  
 
==Table Purpose==
 
==Table Purpose==
 +
<section begin="std" />
 
The Stdorgname Table was used to standardize firm names in the database in the Matchorgname Table.
 
The Stdorgname Table was used to standardize firm names in the database in the Matchorgname Table.
 +
<section end="std" />
  
 
==Current Problems==
 
==Current Problems==

Revision as of 09:56, 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 was used to standardize firm names in the database in the Matchorgname Table.

Current Problems