Ohio Innovation Exchange Degree (OXDG)

Last updated May 4, 2017

File Description

The Degree (OXDG) file contains records detailing Degrees awarded to people identified in the Directory (OXDI) file.

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

Relationship to Other FIle Submissions

The Degree (OXDG) file references the following submission:

  • Directory (OXDI)

Template File with Header Row (.csv)

Data Fields

Field Names

Description

Data Format

DEGREE_ID

Unique Identifier for this Degree.

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 Degree. For example, Bachelor’s of Science.

Required

Alphanumeric

255 characters

INSTITUTION

Institution that awarded the Degree. For example, Capital University.

Required

Alphanumeric

255 characters

AREA_OF_STUDY

Area of study, major or field of study. For example, Computer Science.

Alphanumeric

255 characters

YEAR_AWARDED

Year the Degree was awarded.

Required

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