Ohio Innovation Exchange Department (OXDP)

Last updated May 4, 2017

File Description

The Department (OXDP) file must contain a record for each department referenced in an Appointment (OXAP) file.

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

Relationship to Other FIle Submissions

The Department (OXDP) file must be submitted prior to the following file:

  • Appointment (OXAP)

It references the following submission:

  • College (OXCO)

Template File with Header Row (.csv)

Data Fields

Field Names Description Data Format

DEPARTMENT_ID

Unique Identifier for this Department.

Required

Alphanumeric

30 characters

NAME

Name of this Department.

Required

Alphabetic

255 characters

URL

Link to information about the Department.

Alphanumeric

255 characters

COLLEGE_ID

College ID from the College (OXCO) file.

Required

Foreign Key

Alphanumeric

30 characters

DELETE_FLAG

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

Required

Alphabetic
1 character