Ohio Innovation Exchange Work (OXWK)

Last updated May 4, 2017

File Description

The Works (OXWK) file contains records detailing works published by people identified in the Directory (OXDI) file.

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

Relationship to Other FIle Submissions

The Works (OXWK) file references the following submission:

  • Directory (OXDI)

 

Template File with Header Row (.csv)

Data Fields

Header

Description

Field Contents

WORK_ID

Unique Identifier for this Work.

Required

Alphanumeric

30 characters

PERSON_ID

Person ID from the Directory (OXDI) file.

Required

Foreign Key

Alphanumeric

30 characters

WORK_TYPE

Type Code. Must be from the Type Codes below:

AB

Biosketch

AV

Audio Visual

B

Book

C

Conference

J

Journal

P

Presentation

T

Technical Paper

Required

Foreign Key

Alphabetic

2 characters

AUTHOR_LIST

Author list for the Work, comma separated.

Alphanumeric

2500 characters

EDITOR_LIST

Editor list for the Work, comma separated.

Alphanumeric

2500 characters

TITLE_1

Title of the specific publication, presentation, etc.

Required

Alphanumeric

1000 characters

TITLE_2

Title of the event.

Alphanumeric

1000 characters

FORMAT

Format of the Work.

Alphanumeric

1000 characters

START_DATE

Starting date for the Work, in YYYY-MM-DD format.

Date

10 characters

BEGINNING_PAGE

First page of the Work in the publication.

Numeric

4 digits

ENDING_PAGE

Last page of the Work in the publication.

Numeric

4 digits

SPONSOR

Sponsor of the Work.

 

Alphanumeric

1000 characters

PUBLISHER

Publisher of the Work.

Alphanumeric

255 characters

VOLUME

Volume number of the publication.

Alphanumeric

255 characters

EDITION

Edition of the publication.

Alphanumeric

255 characters

URL

URL for the Work.

Alphanumeric

500 characters

ISBN

ISBN for the work.

Alphanumeric

255 characters

DOI

DOI for the work

Alphanumeric

255 characters

ISSUE

Issue number of the publication.

Alphanumeric

255 characters

ABSTRACT

Abstract for the Work.

Alphanumeric

32000 characters

DELETE_FLAG

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

Required

Alphabetic
1 character