Ohio Innovation Exchange Building (OXBL)

Last updated May 4, 2017

File Description

The Building (OXBL) file must contain a record for each building referenced in a Resource (OXRS) or Directory (OXDI) file.

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

 

Relationship to Other FIle Submissions

The Building (OXBL) file must be submitted prior to the following files:

  • Directory (OXDI)
  • Resource (OXRS)

It may reference the following submissions:

  • Campus(OXCP)

 

Template File with Header Row (.csv)

Data Fields

Field Names

Description

Data Format

BUILDING_ID

Unique Identifier for this Building.

Required

Alphanumeric

30 characters

NAME

Name of the Building.

Required

Alphanumeric

255 characters

CAMPUS_ID

Campus ID from the Campus (OXCP) file.

Foreign Key

Alphanumeric

30 characters

STREET_ADDRESS

Street Address for the Building.

Alphanumeric

255 characters

CITY

City for the Building.

Alphanumeric

100 characters

STATE

State, two character abbreviation. For example, OH.

Alphabetic

2 characters

POSTAL_CODE

Postal Code, for example a Zip Code or Zip + 4.  

Alphanumeric

10 characters

LONGITUDE

Longitude for the Building, 10 digits including up to 7 decimal places. For example, -83.0401441. 

Latitude and Longitude should be specified as positive and negative decimal numbers. Do not use degree symbols, hours and minutes, or NSEW.

Numeric

10 digits

LATITUDE

Latitude for the Building, 10 digits including up to 7 decimal places. For example, 39.9999431.

Latitude and Longitude should be specified as positive and negative decimal numbers. Do not use degree symbols, hours and minutes, or NSEW.

Numeric

10 digits

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

Required

Alphabetic
1 character