Ohio Innovation Exchange Certification (OXCT)

Last updated May 4, 2017

File Description

The Certification (OXCT) file contains records detailing Certifications awarded to people identified in the Directory (OXDI) file.

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

Relationship to Other FIle Submissions

The Certification (OXCT) file references the following submission:

  • Directory (OXDI)

Template File with Header Row (.csv)

Data Fields

Field Names

Description

Data Format

CERTIFICATION_ID

Unique Identifier for this Certification.

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 Certification.

Required

Alphanumeric

255 characters

CERTIFYING_BODY

Governing Body that issued the Certification.

Required

Alphanumeric

255 characters

YEAR_AWARDED

Year the Certification was awarded.

Numeric

4 digits

YEAR_EXPIRES

Year the Certification expires. Leave blank if there is no expiration.

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