Ohio Innovation Exchange Directory (OXDI)

Last updated May 4, 2017

File Description

The Directory (OXDI) file must contain a record for each person referenced in an Appointment (OXAP), Certification (OXCT), Degree (OXDG), Consulting (OXCN), Honor (OXHN), Patent (OXPT), Membership (OXMB), or Work (OXWK) file. In addition, Resource Contact (OXRC) may optionally use PERSON_IDs.

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

Relationship to Other FIle Submissions

The Directory (OXDI) file must be submitted prior to the following files:

  • Resource Contact (OXRC)
  • Appointment (OXAP)
  • Certification (OXCT)
  • Degree (OXDG)
  • Consulting (OXCN)
  • Honor (OXHN)
  • Patent (OXPT)
  • Membership (OXMB)
  • Work (OXWK)

It may reference the following submissions:

  • Campus (OXCP)
  • Building (OXBL)

Template File with Header Row (.csv)

Data Fields

Field Names

Description

Data Format

PERSON_ID

Unique Identifier for this person.

Required

Alphanumeric

30 characters

FIRST_NAME

First Name.

Required

Alphabetic

50 characters

LAST_NAME

Last Name.

Required

Alphabetic

50 characters

MIDDLE_NAME

Middle Name.

Alphabetic

50 characters

PREFIX

Prefix, for example, Dr. Mr. Ms.

Alphabetic

50 characters

SUFFIX

Suffix, for example, I, II, Jr.

Alphabetic

50 characters

PREFERRED_NAME

Preferred Name, as desired for display. For example, Dr. John H. Smith.

Alphabetic

255 characters

PREVIOUS_LAST_NAME

Previous Last Name, such as a maiden name.

Alphabetic

50 characters

GENDER

Gender, one of the following:

M - Male

F- Female

Alphabetic

1 character

CAMPUS_ID

Campus ID from the Campus (OXCP) file.

Foreign Key

Alphanumeric

30 characters

PRIMARY_EMAIL

Primary Email Address. Must be a valid email address.

Required

Alphanumeric

255 characters

SECONDARY_EMAIL

Primary Email Address. Must be a valid email address, or blank.

Alphanumeric

255 characters

PRIMARY_PHONE

Primary Phone Number.

Alphanumeric

30 characters

SECONDARY_PHONE

Secondary Phone Number.

Alphanumeric

30 characters

STREET_ADDRESS_1

Street Address, first line. For example, 123 Fake Street.

Alphanumeric

255 characters

STREET_ADDRESS_2

Street Address, second line. For example, Suite 200.

Alphanumeric

255 characters

CITY

City. For example, Columbus.

Alphanumeric

100 characters

STATE

State, two character abbreviation. For example, OH.

Alphabetic

2 characters

POSTAL_CODE

Postal Code, for example a Zip Code or Zip + 4.  

Alphanumeric

10 characters

TAG

Tags, should be separated with semi colons.

Alphanumeric

4000 characters

BUILDING_ID

Building ID from the Building (OXBL) file.

Foreign Key

Alphanumeric

30 characters

ORCID

ORCID: This is strongly recommended. It may be provided as a URL (http://orcid.org/0000-0000-0000-0000) or just the number (0000-0000-0000-0000).

Alphanumeric

255 characters

TR_RESEARCHER_ID

Thompson Reuters Researcher ID.

Alphanumeric

255 characters

DELETE_FLAG

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

Required

Alphabetic
1 character