Ohio Innovation Exchange Appointment (OXAP)

Last updated May 4, 2017

File Description

The Appointment (OXAP) file contains records detailing Department appointments for people identified in the Directory (OXDI) file.

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

Relationship to Other FIle Submissions

The Appointment (OXAP) file references the following submissions:

  • Directory (OXDI)
  • Department (OXDP)

Template File with Header Row (.csv)

Data Fields

Field Names

Description

Data Format

APPOINTMENT_ID Unique Identifier for this Appointment.

Required

Alphanumeric

30 characters
PERSON_ID Person ID from the Directory (OXDI) file. 

Required

Foreign Key

Alphanumeric

30 characters
TITLE Title awarded to the Person.

Required

Alphanumeric

255 characters
DEPARTMENT_ID Department ID from the Department (OXDP) file.

Required

Foreign Key

Alphanumeric

30 characters
JOB_CODE Job Code or ID identifying job held.

Alphanumeric

20 characters
DATE_APPOINTED Date the Appointment became effective, in YYYY-MM-DD format.

Required

Date

10 characters
PRIMARY Primary, indicating if this is the Person’s primary appointment, Y for Yes, N for No.

Required

Alphabetic

1 character
ACTIVE Active, indicating if this Appointment is active, Y for Yes, N for No.

Required

Alphabetic

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

Required

Alphabetic
1 character