Ohio Innovation Exchange Membership (OXMB)

Last updated May 4, 2017

File Description

The Membership (OXMB) file contains records detailing Memberships held by people identified in the Directory (OXDI) file.

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

Relationship to Other FIle Submissions

The Membership (OXMB) file references the following submission:

  • Directory (OXDI)

Template File with Header Row (.csv)

Data Fields

Header

Description

Field Contents

MEMBERSHIP_ID

Unique Identifier for this Membership.

Required

Alphanumeric

30 characters

PERSON_ID

Person ID from the Directory (OXDI) file.

Required

Foreign Key

Alphanumeric

30 characters

ORGANIZATION

Organization for the Membership.

Required

Alphanumeric

1000 characters

DESCRIPTION

Description of the Membership.

Alphanumeric

5000 characters

TITLE

Title or name of the Membership.

Required

Alphanumeric

255 characters

START_YEAR

Year the Membership began.

Numeric

4 digits

END_YEAR

Year (if any) the Membership ended.

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