Ohio Innovation Exchange Resource (OXRS)

Last updated May 4, 2017

File Description

The Resource (OXRS) file is comma separated values (CSV) and must include the headers in the first row. The Resource (OXRS) file must contain a record for each resource referenced in a Resource Contact (OXRC) file.

Relationship to Other FIle Submissions

The Resource (OXRS) file must be submitted prior to the following files:

  • Resource Contact (OXRC)

It may reference the following submissions:

  • Building (OXBL)

Template File with Header Row (.csv)

Data Fields

Header Description Field Contents
RESOURCE_ID Unique Identifier for this Resource.

Required
Alphanumeric
30 characters

TYPE_CODE

Type Code. Must be from the Type Codes below:

BIOSP (Biological Specimen)
DBASE (Database)
DOCMT (Document)
FAMLY (Family)
GNALT (Genetic Alteration)
HUMSY (Human Study)
HUMST (Human Subject)
INSTR (Instrument)
ORGVS (Organism or Virus)
ORGZN (Organization)
PERSN (Person)
REAGT (Reagent)
REAOY (Research Opportunity)
REACN (Resource Collection)
SERVE (Service)
SFTWR (Software)

Required
Foreign Key
Alphabetic
5 characters

NAME Name of the Resource.

Required
Alphanumeric
255 characters

MANUFACTURER Manufacturer Name for the Resource, if applicable. Alphanumeric
255 characters
MODEL Model Name for the Resource, if applicable.

Alphanumeric
255 characters

DESCRIPTION Description of the Resource.

Alphanumeric
5000 characters

CAPABILITIES Capabilities of the Resource.

Alphanumeric
5000 characters

TAG Tags, should be separated with semi colons.

Alphanumeric
4000 characters

URL

Link for information about the Resource.

Alphanumeric
255 characters

FEES

Fees, if they are charged for use of the Resource. Y for Yes, N for No.

Required
Alphabetic
1 Character

TRAINING_AVAILABLE

Training, if it is available for the Resource. Y for Yes, N for No.

Required
Alphabetic
1 Character

STREET_ADDRESS

Street Address where the Resource is located.

Alphanumeric
255 characters

CITY

City for where the Resource is located.

Alphanumeric
30 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 Resource’s location, 10 digits including up to 7 decimal places. For example, -83.0401441.

Numeric
10 digits

LATITUDE

Latitude for the Resource’s location, 10 digits including up to 7 decimal places. For example, 39.9999431.

Numeric
10 digits

BUILDING_ID

Building ID from the Building (OXBL) file.

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

Additional Information

Important Notes about CSV Files

  • Fields with embedded commas or double-quote characters must be quoted.
  • Each of the embedded double-quote characters must be represented by a pair of double-quote characters.

 

Importance of ID fields

Each file asks for some kind of unique identifier which is unique to that record, examples: PERSON_ID, CAMPUS_ID, COLLEGE_ID, DEPARTMENT_ID, etc. This along with the institution the record is tied to uniquely identifies a record in our system. We use these IDs to determine if a record should be created, updated, or deleted. This also serves to link all the different data files together to normalize the data. We cannot accept records without a unique identifier.

 

Required Fields

Fields that are marked as required must be present and in the correct format specified. If they are not present the whole file will be rejected.

 

Foreign Keys

Fields that are marked as foreign keys indicate they reference an ID from another file. This is how data elements are linked to one another. If a foreign key field is given an invalid or blank value it will be treated as a NULL value. If it is required and invalid or blank the record will be rejected.

 

Definitions and Descriptions of Data Fields

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

 

Handling Corrections / Deletions

The Ohio Innovation Exchange is not the authoritative source of data; the institutions are responsible for the data they transmit. If there is an error or incorrect data is transmitted, please correct the data at the source and retransmit.