Ohio Innovation Exchange Consulting (OXCN)

Last updated May 4, 2017

File Description

The Consulting (OXCN) file contains records detailing Consulting activities of people identified in the Directory (OXDI) file.

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

 

Relationship to Other FIle Submissions

The Consulting (OXCN) file references the following submission:

  • Directory (OXDI)

Template File with Header Row (.csv)

Data Fields

Field Names

Description

Data Format

CONSULTING_ID

Unique Identifier for this Consulting.

Required

Alphanumeric

30 characters

PERSON_ID

Person ID from the Directory (OXDI) file.

Required

Foreign Key

Alphanumeric

30 characters

ORGANIZATION

Name of the Organization the Person was consulting with.

Required

Alphanumeric

1000 characters

DESCRIPTION

Description of the work, accomplishments, etc.

Alphanumeric

5000 characters

FOR_PROFIT_ORGANIZATION

For Profit status of the Organization, Y for Yes, N for No.

Alphabetic

1 character

CITY

City of the Organization. For example, Columbus.

Alphanumeric

100 characters

STATE

State, two character abbreviation. For example, OH.

Alphabetic

2 characters

START_DATE

Date (in month and year) the Consulting engagement began, in YYYY-MM format.

Date

7 characters

END_DATE

Date (in month and year) the Consulting engagement ended, in YYYY-MM format.

Date

7 characters

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

Required

Alphabetic
1 character