Difference between revisions of "Match Orgname Table"
Jump to navigation
Jump to search
| (10 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | Return to [[Patent | + | 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== | ||
| − | The stdorgname is the standardized name of a firm or organization. The orgname is any name used to refer to a firm. The | + | 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 16: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.
