Ohio Innovation Exchange Honor (OXHN)

Last updated May 4, 2017

File Description

The Honor (OXHN) file contains records detailing Honors awarded to people identified in the Directory (OXDI) file.

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

Relationship to Other FIle Submissions

The Honor (OXHN) file references the following submission:

  • Directory (OXDI)

Template File with Header Row (.csv)

Data Fields

Header

Description

Field Contents

HONOR_ID

Unique Identifier for this Honor.

Required

Alphanumeric

30 characters

PERSON_ID

Person ID from the Directory (OXDI) file.

Required

Foreign Key

Alphanumeric

30 characters

TITLE

Title or name of the Honor.

Required

Alphanumeric

1000 characters

DESCRIPTION

Description of the Honor.

Alphanumeric

5000 characters

AWARDING_BODY

Organization awarding the Honor.

Alphanumeric

255 characters

YEAR_AWARDED

Year the Honor was awarded.

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