Reports Schema Functions

Overview

The purpose of these functions in the reports schema is to extract XML content from the tables in the XML schema. Most parse through the nodes of the XML to extract specific information and display it as text. If there are multiple entries, these functions combine the multiple pieces of XML content into one string value. 

Functions To Extract XML Content Into Strings

FunctionExample

string

reports.f_csv_abstract_en(integer)

Display full abstract from content in xml.t_abstract based on ucid or publication number:

select reports.f_csv_abstract_en(xml.f_ucid2id('US-5551212-A'))

---

A package is formed by holding a nonextensible strip taut and wrapping it 
around the upper and/or lower periphery of the bundle and joining the ends of 
the strip segments e.g. by adhesive bonding. A projecting margin of the strip 
is folded to overlie the bundle or underlie the bundle so that an L-
configuration is imparted to the frame formed around the bundle after the 
strip is applied thereto.

string

reports.f_csv_agent(integer)

Display full abstract from content in xml.t_parties where the format is EPO and in the agent node of the content based on ucid or publication number:

select reports.f_csv_agent(xml.f_ucid2id('US-5551212-A'))

---

Dubno, Herbert | Wilford, Andrew


string

reports.f_csv_application_value(integer)


reports.f_csv_application_country(integer)

reports.f_csv_application_date(integer)

reports.f_csv_application_kind(integer)

reports.f_csv_application_number(integer)

reports.f_csv_application_ucid(integer)

reports.f_csv_application_year(integer)

Display different values from content in xml.t_application_reference based on ucid or publication number:

select reports.f_csv_application_kind(xml.f_ucid2id('US-5551212-A'))

---

A

string 

reports.f_csv_assignee(integer)

reports.f_csv_assignee_std(integer)

Display assignee(s) for a patent from xml.t_parties based on ucid or publication number:

select reports.f_csv_assignee(xml.f_ucid2id('US-5551212-A'))

---

OSTMA MASCHINENBAU GMBH

string 

reports.f_csv_claims_value(integer)


reports.f_csv_claims_en(integer)

reports.f_csv_claims_first(integer)

reports.f_csv_claims_original(integer)


Display claim text from xml.t_claims based on ucid or publication number:

select reports.f_csv_claims_en(xml.f_ucid2id('US-5551212-A'))

---

1. A method of packaging a plurality of articles, the method comprising the 
steps of: (a) assembling a plurality of the articles into a bundle with the 
articles in contact with one another and the bundle having upper and lower 
annular edges, a plurality of corners at each of the edges, respective top and
bottom surfaces bounded by the edges, a predetermined height between its top 
and bottom surfaces, and side faces; (b) drawing a planar strip of a 
substantially non-stretchable cardboard packaging material of a width less 
than the height of the bundle and of a length greater than that of one of the 
edges from a supply roll of the packaging material and severing the strip from 
the supply roll so that the strip has two ends; (b') scoring the strip to 
define a fold line extending a full length of the strip; (b") cutting a margin 
of the strip at respective locations spaced corresponding to the corners of 
the one edge; (c) wrapping the scored and cut planar strip around the one edge 
on the side faces in direct contact with the articles with the fold line at 
the one edge and the margin cuts at the corners while drawing the strip taut 
so that the margin of the strip projects beyond the one edge, the side faces 
of the bundle are left mainly exposed by the strip, and the ends of the strip 
overlap upon complete encircling of the bundle by the strip; (d) folding the 
margin inward long the fold line to overlap the articles of the bundle on the 
respective surface, to overlap the margin with itself at the corners, and to 
impart an L-section to the strip; and (e) connecting the ends together where 
they overlap and connecting the margin together where it overlaps at the 
corners. | 2. The method defined in claim 1 wherein the articles are 
rectangular parallelepipeds. | 3. The method defined in claim 2 wherein...

string

reports.f_csv_correspondent(integer)

Display names of correspondents from xml.t_parties based on ucid or publication number:

select reports.f_csv_correspondent(xml.f_ucid2id('US-20110047312-A1'))

---

WSGR, C/O QUI LU FLOOD, SENIOR PARALEGAL

string 

reports.f_csv_cpc_all(integer)

reports.f_csv_cpc_fi(integer)

Display all or first inventive classification identifiers from xml.t_classifications_cpc:

select reports.f_csv_cpc_all(xml.f_ucid2id('US-5551212-A'))

---

B65B 13/02

string 

reports.f_csv_date_produced(integer)

Display date produced from xml.t_patent_document_values:

select reports.f_csv_date_produced(xml.f_ucid2id('US-5551212-A'))

---

2020-01-18

string 

reports.f_csv_designated_states(integer)

Display filing countries or regions from xml.t_international_convention_data:

select reports.f_csv_designated_states(xml.f_ucid2id('WO-2003104808-A1'))

---

AE | AG | AL | AM | AT | AU | AZ | BA | BB | BE | BF | BG | BJ | BR | BY | BZ 
| CA | CF | CG | CH | CI | CM | CN | CO | CR | CU | CY | CZ | DE | DK | DM | 
DZ | EC | EE | ES | FI | FR | GA | GB | GD | GE | GH | GM | GN | GQ | GR | GW 
| HR | HU | ID | IE | IL | IN | IS | IT | JP | KE | KG | KP | KR | KZ | LC | 
LK | LR | LS | LT | LU | LV | MA | MC | MD | MG | MK | ML | MN | MR | MW | MX 
| MZ | NE | NL | NO | NZ | OM | PH | PL | PT | RO | RU | SC | SD | SE | SG | 
SI | SK | SL | SN | SZ | TD | TG | TJ | TM | TN | TR | TT | TZ | UA | UG | US 
| UZ | VC | VN | YU | ZA | ZM | ZW

string 

reports.f_csv_ecla(integer)

Display ECLA codes defined by EPO examiners, based on ucid or publication_number in xml.t_classification_ecla:

select reports.f_csv_ecla(xml.f_ucid2id('US-5551212-A'))

---

B65B 13/02

string 

reports.f_csv_examiner(integer)

Display examiners, based on ucid or publication_number in xml.t_parties:

select reports.f_csv_examiner(xml.f_ucid2id('US-5551212-A'))

---

Johnson, Linda

string 

reports.f_csv_family_id(integer)

Display family ids, based on ucid or publication_number in xml.t_patent_document_values:

select reports.f_csv_family_id(xml.f_ucid2id('US-5551212-A'))

---

6413406

string 

reports.f_csv_family_members(integer)

Display simple family members based on ucid or publication number:

select reports.f_csv_family_members(xml.f_ucid2id('US-5551212-A'))

---

AT-96388-T | AU-636238-B2 | AU-8174591-A | CA-2050271-A1 | CA-2050271-C | DE-
4027762-C1 | DE-59100535-D1 | DK-0477487-T3 | EP-0477487-A1 | EP-0477487-B1 | 
ES-2046827-T3 | JP-2113465-C | JP-H054613-A | JP-H0825524-B2 | NO-913030-A | 
NO-913030-D0 | NO-913030-L | TR-25401-A | ZA-9106183-A | ZA-9106183-B

string 

reports.f_csv_forward_citations(integer)

reports.f_csv_forward_citations_ex(integer)

Display all forward citations based on ucid or publication number:

select reports.f_csv_forward_citations(xml.f_ucid2id('US-5551212-A'))

---

US-10053871-B2 | US-10099808-B2 | US-10206333-B2 | US-20050028485-A1 | US-
20050149389-A1 | US-20090303188-A1 | US-20110016831-A1 | US-20120186197-A1 | 
US-20130067865-A1 | US-20160152363-A1 | US-5735104-A | US-6223499-B1 | US-
6338410-B1 | US-8216509-B2 | US-8448411-B2 | US-8516780-B2 | US-9156575-B2 | 
US-9655303-B2

string 

reports.f_csv_fterms_all(integer)


Display all forward citations based on ucid or publication number:

select reports.f_csv_fterms_all(xml.f_ucid2id('JP-2000357571-A'))

---

2G003AG08 | 2G003AG16 | 2G003AG01 | 2G003AA07 | 5E024CA18 | 5E024CB05 | 
5E024CA30

string 

reports.f_csv_ifi_adjusted_expiration(integer)

reports.f_csv_ifi_expiration(integer)


Display expected expiration dates based on IFI data using ucid or publication number:

select reports.f_csv_ifi_expiration(xml.f_ucid2id('US-5551212-A'))

---

20130903

string 

reports.f_csv_ifi_assignee(integer)

reports.f_csv_ifi_assignee_current(integer)

reports.f_csv_ifi_assignee_original(integer)

reports.f_csv_ifi_assignee_probable(integer)


Display assignees from xml.t_ifi_integrated_content using ucid or publication number:

select reports.f_csv_ifi_assignee(xml.f_ucid2id('US-5551212-A'))

---

OSTMA Maschinenbau GmbH

string 

reports.f_csv_ifi_publication_type(integer)


Display publication type from xml.t_ifi_integrated_content using ucid or publication number:

select reports.f_csv_ifi_publication_type(xml.f_ucid2id('US-5551212-A'))

---

G

string 

reports.f_csv_ifi_status(integer)


Display the latest patent status from xml.t_ifi_integrated_content using ucid or publication number:

select reports.f_csv_ifi_status(xml.f_ucid2id('US-5551212-A'))

---

Expired - Lifetime

string 

reports.f_csv_inpadoc_family(integer)

reports.f_csv_inpadoc_family_ex(integer)


Display extended family members related to ucid or publication number:

select reports.f_csv_inpadoc_family_ex(xml.f_ucid2id('US-5551212-A'))

---

US-5551212-A | AT-96388-T | AU-636238-B2 | AU-8174591-A | CA-2050271-A1 | 
CA-2050271-C | DE-4027762-C1 | DE-59100535-D1 | DK-0477487-T3 | 
EP-0477487-A1 | EP-0477487-B1 | ES-2046827-T3 | JP-H054613-A | 
JP-H0825524-B2 | NO-913030-D0 | NO-913030-L | TR-25401-A | ZA-9106183-B

string 

reports.f_csv_inventor_first(integer)

reports.f_csv_inventors(integer)

Display inventors or first inventor from xml.t_parties based on ucid or publication number:

select reports.f_csv_inventors(xml.f_ucid2id('US-5551212-A'))

---

ODENTHAL HEINZ F

string 

reports.f_csv_ipc_all(integer)

reports.f_csv_ipc_p(integer)


Display all or primary classification identifiers from xml.t_classification_ipc:

select reports.f_csv_ipc_all(xml.f_ucid2id('US-5551212-A'))

---

IPCv6 | B65B 13/02 | B65B 61/02

string 

reports.f_csv_ipcr_all(integer)


Display all classification identifiers from xml.t_classifications_ipcr:

select reports.f_csv_ipcr_all(xml.f_ucid2id('US-5551212-A'))

---

B65B 17/02 | B65D 71/02 | B65B 13/18 | B65B 13/02

string 

reports.f_csv_legal_status(integer)

Display legal status from xml.t_legal_status based on ucid or publication number. Returns date, country, code, and description for each entry:

select reports.f_csv_legal_status(xml.f_ucid2id('US-5551212-A'))

---

Date: 20080211 Country: US Code: FPAY Desc:  FEE PAYMENT - year of fee 
payment  - 12 | Date: 20040213 Country: US Code: FPAY Desc:  FEE PAYMENT - 
year of fee payment  - 8 | Date: 20000222 Country: US Code: FPAY Desc:  FEE 
PAYMENT - year of fee payment  - 4 | Date: 19960823 Country: US Code: STCF 
Desc:  INFORMATION ON STATUS: PATENT GRANT - PATENTED CASE

string 

reports.f_csv_load_id(integer)

Display load ids, based on ucid or publication_number in xml.t_patent_document_values:

select reports.f_csv_load_id(xml.f_ucid2id('US-5551212-A'))

---

426242

string 

reports.f_csv_name(xml)

Display the name as either the value of /addressbook/name, orgname or a concatenation of last-name, first-name in the xml of xml.t_parties, as associated with a ucid based on the value of the assignee, applicant, inventor or agent:

select reports.f_csv_name( 
		(xml.f_getElementsByTagName('inventor',(select content from xml.t_parties where publication_id=xml.f_ucid2id('US-5551212-A')))
	)[1] 
);

---

ODENTHAL HEINZ F

string 

reports.f_csv_non_patent_citations(integer)

Display non-patent citations based on ucid or publication_number in xml.t_citations:

select reports.f_csv_non_patent_citations(xml.f_ucid2id('EP-2365746-A1'))

---

No further relevant documents disclosed | See also references of WO  2010053910A1

string 

reports.f_csv_patent_citations(integer)

Display patent citations based on ucid or publication_number in xml.t_citations:

select reports.f_csv_patent_citations(xml.f_ucid2id('US-5551212-A'))

---

DE-3606826-A1 | US-4546875-A | EP-0313721-A2 | US-3187480-A | EP-0061805-A1 | 
US-2043419-A | DE-8002686-U1 | DE-3138439-A1 | US-4905451-A | US-4631900-A | 
EP-0225665-A1 | US-4828110-A | US-4534151-A

string 

reports.f_csv_pct_application_number(integer)

Display application number where filing country is WO, based on ucid or publication_number in xml.t_priority_claims:

select reports.f_csv_pct_application_number(xml.f_ucid2id('DE-69937298-T2'))

---

JP-9903310-W

string

reports.f_csv_priority_value(integer)


reports.f_csv_priority_country(integer)

reports.f_csv_priority_date(integer)

reports.f_csv_priority_number(integer)

reports.f_csv_priority_years(integer)

Display different values from content in xml.t_priority_claims based on ucid or publication number:

select reports.f_csv_priority_country(xml.f_ucid2id('US-5551212-A'))

---

US | US | DE

string

reports.f_csv_publication_value(integer)


reports.f_csv_publication_country(integer)

reports.f_csv_publication_date(integer)

reports.f_csv_publication_kind(integer)

reports.f_csv_publication_number(integer)

reports.f_csv_publication_ucid(integer)

reports.f_csv_publication_year(integer)

Display values from xml.t_patent_document_values based on ucid or publication number:

select reports.f_csv_publication_ucid(xml.f_ucid2id('US-5551212-A'))

---

US-5551212-A

string 

reports.f_csv_related_applications(integer)

Display related documents from xml.t_related_documents:

select reports.f_csv_related_applications(xml.f_ucid2id('US-5551212-A'))

---

US-2582893-A 19930303 US-74719691-A 19910816     continuation

string

reports.f_csv_title_language(integer)


reports.f_csv_title_de(integer)

reports.f_csv_title_en(integer)

reports.f_csv_title_es(integer)

reports.f_csv_title_fr(integer)

Display title with a specific language from xml.t_invention_title based on ucid or publication number. Currently available for DE, EN, ES, and FR:

select reports.f_csv_title_fr(xml.f_ucid2id('EP-0613670-B1'))

---

Procédé de fabrication d'un pansement adhésif

string 

reports.f_csv_us_class_all(integer)

reports.f_csv_us_class_p(integer)

Display all (or primary) classification identifiers from xml.t_classification_national where country is 'US':

select reports.f_csv_us_class_all(xml.f_ucid2id('US-5551212-A'))

---

053397 | 053399 | 053411