# 3.0 - Order Feed

## Data specification <a href="#id-3.0orderfeed-dataspecification" id="id-3.0orderfeed-dataspecification"></a>

The following table describes the data specification in Order Feed 3.0. A full overview of the Order Feed and recommendations for processing can be found [here](https://resources.unizin.org/products/content/unizin-order-tool/implementation/order-feed). Order Feed 3.0 includes \`**ci\_student\_price\`** which describes how much a student will be charged for the purchase of a digital course material.

<table data-full-width="true"><thead><tr><th width="256.33333333333337">Column name</th><th width="116">Data type</th><th>Definition</th></tr></thead><tbody><tr><td><strong>order_id</strong></td><td>Integer</td><td>A unique Unizin ID for the order.</td></tr><tr><td><strong>order_created</strong></td><td>Datetime</td><td>A date &#x26; time in ISO 8601.</td></tr><tr><td><strong>order_updated</strong></td><td>Datetime</td><td>A date &#x26; time in ISO 8601.</td></tr><tr><td><strong>sis_section_id</strong></td><td>Text</td><td>An SIS section ID that is on an order.</td></tr><tr><td><strong>sis_content_id</strong></td><td>Text</td><td>This data is only applicable to Indiana University. In many cases, the value will be `null`.</td></tr><tr><td><strong>content_id</strong></td><td>Text</td><td>This value is a unique identifier for each content item available in Unizin's Master Catalog.</td></tr><tr><td><strong>is_deleted</strong></td><td>Boolean</td><td>If "true," the Order to which the content-section pair belongs has been canceled.</td></tr><tr><td><strong>order_item_type</strong></td><td>Text</td><td>A value, from an enumerated set, describing the type of item on a particular order. Possible values include <code>catalog_item</code> and <code>content_request</code>.</td></tr><tr><td><strong>ci_author</strong></td><td>Text</td><td>The author of a content item that is on the order. If multiple authors are present, they are separated by a semicolon.</td></tr><tr><td><strong>ci_title</strong></td><td>Text</td><td>The title of a content item that is on the order.</td></tr><tr><td><strong>cr_created</strong></td><td>Datetime</td><td>The timestamp that the content request was created. This is a timestamp in ISO 8601.</td></tr><tr><td><strong>cr_title</strong></td><td>Text</td><td>The title of the Content request, as input by the user.</td></tr><tr><td><strong>cr_isbn</strong></td><td>Text</td><td>The ISBN of the Content request, as input by the user.</td></tr><tr><td><strong>cr_status</strong></td><td>Text</td><td>The Status of the Content request. Values include <code>Submitted</code>, <code>Researching</code>, <code>Approved</code>, <code>Canceled</code> or <code>Denied</code>.</td></tr><tr><td><strong>ci_searchable_isbn</strong></td><td>Text</td><td>The best ISBN students can use to search for and find the title on the web.</td></tr><tr><td><strong>ci_publication_date</strong></td><td>Date</td><td>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).</td></tr><tr><td><strong>ci_delivery_solution</strong></td><td>Text</td><td>The name of the reader used to deliver the solution. Values will be either "Unizin Engage" or "Publisher DLT".</td></tr><tr><td><strong>ci_sis_publisher_id</strong></td><td>Text</td><td>This is only applicable for Indiana University. In many cases, it will be `"null"`.</td></tr><tr><td><strong>ci_publisher_name</strong></td><td>Text</td><td>The name of the content item’s publisher.</td></tr><tr><td><strong>ci_edition</strong></td><td>Text</td><td>The edition of the content item.</td></tr><tr><td><strong>ci_print_list_price_original</strong></td><td>Number</td><td>If the print list price has been updated, this column will show the original print list price it was updated from.</td></tr><tr><td><strong>ci_print_list_price</strong></td><td>Number</td><td>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).</td></tr><tr><td><strong>ci_offer_price_original</strong></td><td>Number</td><td>If the offer price has been updated, this column will show the original offer price it was updated from.</td></tr><tr><td><strong>ci_offer_price</strong></td><td>Number</td><td>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).</td></tr><tr><td><strong>ci_student_price_original</strong></td><td>Number</td><td>If the student price has been updated, this column will show the original student price it was updated from.</td></tr><tr><td><strong>ci_student_price</strong></td><td>Number</td><td>The <a href="../student-price">student price</a> for the content item (this is the price students will be charged, which is calculated as the offer price plus the institutional markup, if applicable).</td></tr><tr><td><strong>is_royalty</strong></td><td>Boolean</td><td>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.<br><br><strong>Note</strong>: this is an order-level assertion but presented for each content item. In short, it should not be assumed that if this value is true, it is because the user ordering the content stands to earn royalties from this particular content item.</td></tr></tbody></table>


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://resources.unizin.org/products/content/unizin-order-tool/implementation/order-feed/3.0-order-feed.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.