Ohio Innovation Exchange Patent (OXPT)

Last updated May 4, 2017

File Description

The Patent (OXPT) file contains records detailing Department appointments for people identified in the Directory (OXDI) file.

The OXPT file is comma separated values (CSV) and must include the headers in the first row. 

Relationship to Other File Submissions

The Patent (OXPT) file references the following submission:

  • Directory (OXDI)

Template File with Header Row (.csv)

Data Fields

Header

Description

Field Contents

PATENT_ID

Unique Identifier for this Patent.

Required

Alphanumeric

30 characters

PERSON_ID

Person ID from the Directory (OXDI) file.

Required

Foreign Key

Alphanumeric

30 characters

AUTHOR_LIST

Author list for the Patent, comma separated.

Alphanumeric

2000 characters

MANUFACTURER

Manufacturer name (if applicable).

Alphanumeric

1000 characters

SPONSOR

Sponsor of the Patent (if applicable).

Alphanumeric

1000 characters

PATENT_NUMBER

Number issued by the Patent office

Required

Alphanumeric

255 characters

NON_US_PATENT

If the Patent was issued in a country other than the United States, Y for Yes, N for No.

Required

Alphabetic

1 character

TITLE

Title of the Patent.

Required

Alphanumeric

2000 characters

URL

URL for the Patent.

Alphanumeric

1000 characters

DESCRIPTION

Description of the Patent.

Alphanumeric

5000 characters

YEAR_APPLIED

Year the Patent was filed.

Numeric

4 digits

YEAR_ISSUED

Year (if any) the Patent was issued. If blank, it will be assumed the Patent is still pending.

Numeric

4 digits

DELETE_FLAG

Delete Flag. Enter Y if the record is to be deleted from the database. Otherwise, enter N.

Required

Alphabetic
1 character