Version 1.0 of the Order Feed is deprecated in favor of Version 2.0.
Data specification
The following table describes the data specification in Order Feed 1.0. A full overview of the Order Feed and processing the data can be found here.
| Column name | Data type | Definition |
|---|---|---|
order_id | Integer | A unique Unizin ID for the order. |
order_created | Datetime | A date & time in ISO 8601. |
| order_updated | Datetime | A date & time in ISO 8601. |
| sis_section_id | Text | An SIS section ID that is on the order. |
| sis_content_id | Text | This is only applicable for IU. In many cases, the value will be `"null"`. |
| is_deleted | Boolean | If "true," the Order to which the content-section pair belongs has been deleted. |
| author | Text | The authors of a content item that is on the order. If multiple authors are present, they are separated by a semicolon. |
| title | Text | The title of a content item that is on the order. |
| searchable_isbn | Text | The best ISBN students can use to search for and find the title on the web. |
| publication_date | Date | The publication date of the title, if available from the publisher. This is a date in ISO 8601 (note: it is only a date object). |
delivery_solution | Text | The name of the reader used to deliver the solution. Values will be either "Unizin Engage" or "Publisher DLT". |
| sis_publisher_id | Text | This is only applicable for IU. In many cases, it will be `"null"`. |
| publisher_name | Text | The name of the content item’s publisher. |
| edition | Text | The edition of the content item. |
| offer_price | Number | The offer price for the content item and the exact price that Unizin will charge institutions for the content. (this includes any Unizin markups or platform fees). |
| print_list_price | Number | The print list price for the content item (this is the nominal price of the content item. Offer prices are generally calculated as a function of the print list price). |
| is_royalty | Boolean | This is a boolean value corresponding to whether or not the person who ordered the content item for this section asserted that they may earn royalties. Note: this is an order level assertion but we'll present it as if for each content item, anyway. In short, it should not be assumed that if this value is true, it is because the user ordering the content stands to early royalties from this particular content items. |