Unizin Product Documentation
ProductsSupport and TrainingPolicies
  • Unizin Product Documentation
  • Products
    • Content
      • Unizin Engage
        • eReader User Guide
          • Notes, Highlights, and Citations
          • Appearance Settings
          • Download for Offline
          • eReader Layout
          • Keyboard Shortcuts
          • Navigating Your eBook
          • Print
          • Text to Speech
          • Copy and Paste
          • Creating Flashcards
          • Collaboration and Note Sharing
          • Pearson Titles
        • Institution Support
          • Disabled Student Services / Alt-Format
            • Best Practices for Republishing Course Content
            • Disabled Student Services
            • Requesting eTextbook Files for Accessibility Purposes
            • WCAG 2.0 AA evaluation for Engage
            • WCAG 2.0 AA evaluation for EPUB for Engage
          • Institution's Support Responsibilities
        • Caliper 1.1 sensor
        • Release Notes
          • 2.28.22
          • 2019-09-17
          • 2019-05-29
          • 2.26.8
          • 2.26.0
          • 2.25.0
          • 2.22.0
          • 2.21.6
          • 2.21.5
          • 2.20.8
          • 2.20.5
          • 2.20.3
          • 2.19.1
          • 2.18.0
          • 2.17.0
          • 2.14.0
          • 2.12.0
          • 2.11.0
          • 2.9.0
          • 2.8.3
          • 2016-03-17
          • 2016-02-11
          • 2016-01-28
        • Using Analytics (New)
      • Unizin Order Tool
        • Overview of the User Interface
        • Key Concepts
          • Profiles
          • Ordering periods
          • Coordinator permissions
          • Program administrator permissions
        • Courses & Ordering
          • Course filtering
          • Place an order
          • Add sections to a placed order
          • Edit a placed order
          • Cancel an order
          • Reordering
        • Order History
          • Instructor Order History
          • Coordinator and Program Administrator Order History
          • Order Activity
        • Student Choice
          • Student Choice (Program Administrators)
          • Student Choice (Students)
        • Entitlements
          • Entitlements (Program Administrators)
          • Entitlements (Students)
        • Catalog Tool
        • Schedule of Classes
        • Content Request Tool
        • Order Tool Dashboard
        • Vendor Sandbox Tenant
        • Institution Support
        • Implementation
          • SIS Data Integration
            • 1.0 - SIS Integration
            • 2.0 - SIS Integration
          • SSO integration
          • UI customizations
          • Order Feed
            • 1.0 - Order Feed
            • 2.0 - Order Feed
            • 3.0 - Order Feed
          • Publisher report
          • Final declined offers feed
          • Institutional (SIS) Catalog Import
          • Student Price
          • Historical Entitlements Import
        • Release Notes
          • Order Tool Bug Fixes and Enhancements
          • Order Tool Bug Fixes
          • Order Tool Accessibility Improvements
          • Order Feed Improvements
          • Content Request Form Update and Minor Bug Fix
          • Flat Markup Fee Update
          • Ordering Email Receipt Update & Minor Bug Fix
          • Bug Fix for Public Catalog Feature
          • Catalog Search Enhancements
          • Reordering Reminder Email Notifications
          • UX Improvements & Minor Bug Fixes
          • Historical Entitlements Import
          • Student Prices
          • Reordering Feature
          • Email Enhancements
          • Ordering Enhancements
          • Bug Fix for the Institutional Catalog Import
          • Bug Fix for the Final Declined Offers Feed (FDOF)
          • Order Activity Feature and Other Enhancements
          • Bug Fixes for Order History and Report an Issue Features
          • Public catalog feature
          • Minor Bug Fixes for Ordering and Student Choice
          • Entitlements Production Release, Bug fixes, and Minor updates
          • Minor Updates and Bug Fixes for Ordering Workflows
          • Catalog Search Optimization
          • Student Choice
          • Archive Terms Feature and Integration Improvements
          • Introduces the Program Administrator role, Catalog Tool, and Schedule
          • User interface updates and improvements
          • Order feed improvements
          • Order history, UI enhancements
          • Email notification upgrades, UI improvements
          • Order feed changes
          • New features for Course coordinators and upgrades to the UI
          • Changes to the Term, Course, and Section models; introduces a Session
          • Bug fixes, import improvements, and validation improvements
          • Tracking Order History
          • Publisher Reporting
          • Fixes the order feed, automates SIS data importing, and automates the generation of order feed repor
    • Data & Analytics
      • Unizin Data Platform
        • Key concepts
          • Platform overview
          • Data categories
          • Data models
          • Loading schemas
          • Keymap
        • Unizin Common Data Model
          • Academic structures (ERD)
          • Learners (ERD)
          • Course structures (ERD)
          • Course resources (ERD)
          • Learner activities (ERD)
          • Quizzes (ERD)
          • Social (ERD)
          • Course outcomes (ERD)
        • System overview
          • Context data pipeline
            • Context data ingress
            • Batch-ingest application
            • Batch-ingest db server
            • Context store
          • Event data pipeline
            • UDP Caliper endpoint
            • Approval process for implementing Caliper compliant tools
            • UDP Event enricher
            • Event store
        • Data stores
          • Data lake
            • UDP Context store
            • UDP Event store
              • Accessing the Event store
              • Expanded table
                • Expanded table: Canvas edApp mapping
            • Synthetic Data [beta]
              • Viewing Synthetic Data datasets within the BigQuery UI
              • Query Synthetic Data via client libraries
          • Data marts
            • UDP Distributions
            • Interaction sessions
            • Learning Environment Organization
            • File Interaction
            • Last Activity
            • Long Inactivity
            • Course Status
            • Daily Course Grade Record
            • LTI Tool Use
            • LMS Tool Use
            • Tool Usage Metrics
            • Links
            • Taskforce
              • Level 1 Aggregated
              • Level 2 Aggregated
              • Level 2 Course Weekly Distribution Summary
              • Student Term Profile
              • Course Profile
            • Student Activity Score
              • Student Course Metrics
              • Student Course Section Metrics
              • Final
              • Course Final
              • Course Section Final
        • Data integrations
          • Context data integration
            • Loading schema
            • Keymap support
            • Manifest file
            • File requirements
            • Integration mechanics
          • Event data integration
          • SIS data integration
          • LMS data integration
            • Instructure Canvas
        • Release Notes
          • UDP Marts Release Notes
            • 1.0.83
            • 1.0.80
            • 1.0.79
            • 1.0.78
            • 1.0.77
            • 1.0.72
            • 1.0.67
            • 1.0.58
            • 1.0.51
            • 1.0.44
            • 1.0.42
            • 1.0.32
            • 1.0.31
            • 1.0.0
            • Level 2 Taskforce data marts now available
          • 2.0.167
          • 2.0.152
          • 2.0.138
          • 2.0.137
          • 2.0.113
          • 2.0.112
          • 2.0.111
          • 2.0.110
          • 2.0.99
          • 2.0.98
          • 2.0.83
          • 2.0.80
          • 2.0.71
          • 2.0.66
          • 2.0.59
          • 2.0.58
          • 2.0.53
          • 2.0.47
          • 2.0.25
        • Miscellaneous
          • Canvas Data additions, ~Fall 2021
          • Canvas Live Events: from SQS to HTTPS
          • Canvas New Analytics vs. UDP
          • Course Section Enrollment Role Status Mappings
          • Migrating from UDW to UDP
      • Unizin Data Warehouse
        • Implementation Guide
        • Scope of Services
        • Access Provisioning
        • Access Revocation
        • Connecting to the UDW
      • Raw Canvas Data 2
        • Flat Files
        • BigQuery Datasets
    • Hosted Services
      • My Learning Analytics
        • Install MyLA via LTI 1.3
        • Custom configure MyLA
  • Support and Training
    • Professional Development
      • Stepping Stones: A Faculty Development Curriculum for Learning Analytics Use
      • Structured Conversations initiative
    • UDP Self-paced Training
    • Resources Site Broken Links
    • Status Pages
  • Policies
    • General policies
      • Sponsor Teams
      • Browser Support Policy
      • Opt-Out & Invoicing Policy (Order Tool)
    • Support Policy
      • Unizin Engage - SP
      • Unizin Order Tool - SP
      • Unizin Data Platform - SP
      • Unizin Data Warehouse - SP
      • Unizin Data Analysis - SP
      • Pressbooks Hosting - SP
    • Privacy Policy
      • Unizin Engage - PP
      • Unizin Order Tool - PP
      • Unizin Data Platform - PP
      • RStudio service - PP
    • End User License Agreements
      • Unizin Engage - EULA
      • Unizin Order Tool - EULA
    • Terms of Use
      • Unizin Data Platform - ToU
    • Incident Reports
Powered by GitBook
LogoLogo

Unizin Homepage

  • unizin.org

Data & Analytics

  • Unizin Data Platform
  • Unizin Data Warehouse

Content

  • Unizin Engage
  • Unizin Order Tool

Hosted Services

  • My Learning Analytics

Copyright © 2023, Unizin, Ltd.

On this page
  • Overview
  • Filename schema
  • File format
  • File contents
  • Processing the feed
  • Things to keep in mind
  1. Products
  2. Content
  3. Unizin Order Tool
  4. Implementation

Final declined offers feed

Order Tool's Final Declined Offers feed provides institutions with a complete list of students who declined offers of digital course materials in a particular term. That is, the Final Declined Offers feed presents, based on student choice and entitlements, the list of students who should not be charged for particular digital course materials. The Final Declined Offers feed includes all student choices and entitlements active on a given date. However, student choices are not deemed final until the bill-after date for the session that a section is a part of has passed, at which point all opt-outs and automatically declined offers due to an entitlement are included in the file.

Overview

The Final Declined Offers feed is formatted as a comma-separated value (CSV) file. Order Tool outputs this file to the FTP server for the institution to pull down. The file path is as follows:

<environment>/declined-offers-feed/<filename>.csv

Every Final Declined Offers feed file is term-specific; therefore, multiple Final Declined Offers feed files may be reported to an institution on any given day.

For each term, Order Tool will generate the Final Declined Offers feed during the following period:

  • Starting once student enrollments for a term have been received

  • Ending once the final bill-after date for all sessions in a term has passed

During this period, the Final Declined Offers feed is generated daily at 8:00 am UTC and immediately uploaded to the FTP server.

Please note that, while generated daily, the Final Declined Offers feed captures declined offers for a moment in time in a given term. In other words, each file is a current accounting of all declined course material offers by students, for a particular term, at that point in time. These offers are considered final once the bill-after date for a corresponding session in a term has passed.

Final Declined Offers feeds are generated for both the production (PROD) and user acceptance testing (UAT) environments. Institutions may use the same FTP server credentials they use to push their data integration for Order Tool in the PROD and UAT environments.

Filename schema

The Final Declined Offers feed is a single CSV file reported for each term. This feed reports on all declined offers by students for the term. Consequently, the file's contents will only grow over time. The filename format of the Final Declined Offers feed is as follows:

final_declined_offers_<sis_term_id>.csv

Where <sis_term_id> is the institution's SIS identifier for the term.

File format

The Final declined offers feed is formatted as a CSV file with the following properties:

  • All values are in double-quotes.

  • If no value is required or available for a field, the string "null" is the value, not a blank.

  • All lines are terminated with a UTF-8 Unix style newline.

  • The escape character is a backslash (\\).

  • Timestamps are in ISO 8601 format and must include the time (e.g., `2020-12-15 04:35`).

File contents

The contents of the Final Declined Offers feed has the following schema.

Field name
Data type
Description

sis_student_id

Text

The SIS identifier for the student who declined the offer and therefore should not be billed, per the institution's data integration with Order Tool.

student_first_name

Text

The student's first name, per the institution's data integration with Order Tool.

student_last_name

Text

The student's last name, per the institution's data integration with Order Tool.

student_email_address

Text

The student's email address, per the institution's data integration with Order Tool.

sis_term_id

Text

The SIS identifier of the academic term corresponding to the course and section in which the student declined to purchase the course material.

term_name

Text

The name of the academic term corresponding to the sis_term_id.

sis_course_id

Text

The SIS identifier of the course corresponding to the section in which the student declined the offer to purchase the course material.

course_subject

Text

The course subject corresponding to the sis_course_id.

course_number

Text

The course number corresponding to the sis_course_id.

course_title

Text

The course title corresponding to the sis_course_id.

sis_section_id

Text

The SIS identifier of the section in which the student declined the offer to purchase the course material.

section_lms_id

Text

The lms_id corresponding to the section.

section_label

Text

The section label corresponding to the sis_section_id.

content_id

Text

This value is a unique identifier for each content item available in Unizin's Master Catalog. It is the same content_id provided in the Order Feed.

content_slug

Text

The Unizin slug corresponding to the content_id.

content_title

Text

The course material title corresponding to the content_id.

content_list_price

Number

The list price corresponding to the content_id.

content_offer_price

Number

The Unizin offer price, which is the exact price Unizin charges institutions for content, corresponding to the content_id.

offer_declined_reason

Text

The reason, asserted by the student, why they declined to purchase the digital course material. If the student had an entitlement and did not need to repurchase the material to receive it, the offer declined reason will be "The student has an entitlement (automatic)".

student_choice_end_date

Date

The date (YYYY-MM-DD) when the student choice period ended for the section in which this student declined to purchase the digital course material.

Processing the feed

The Final Declined Offers feed contains all declined offers at a specific time in a given term. It is a full accounting of all declined course materials up to that date. Given that there likely are multiple student choice periods in an academic term, it is recommended that institutions process the feed daily to properly charge students for their course material purchases. Please note however that declined offers may change up to the bill-after date, after which declined offers are considered final.

Things to keep in mind

\

PreviousPublisher reportNextInstitutional (SIS) Catalog Import

Last updated 7 months ago

Please note that any student with only one record will not appear in the Final Declined Offers Feed. In the future, if the same title adoption is offered to a student in a new term or a second entitlement record is captured in a new term, from this point, the student will be included in the Final Declined Offers Feed.

In the event that the exact same adoption is being offered to a student for the first time in the same term in multiple courses, perhaps two courses as an example, then only one record of an entitlement is captured and will appear in the Final Declined Offers Feed. Multiple entitlements will not be created for the same title offered in many courses in the same term because at least one of those courses will assume a fee should be charged to the student for the materials. Depending on how many courses offer the same adoption will depend upon how many entitlement records appear in the feed. In the example of a student being offered a title in two courses in the same term for the first time, only one entitlement record will exist. The purchase history in the Order Tool user interface indicates that the same title has been adopted within the same term, but it does not mean that a student was actually charged for that title twice. It simply represents that the student has the same title offered in two courses in the same term at the same time with the price listed, and the existing term is when the initial (one time) charge will occur for the student. Only institutions may charge students for the purchase of digital materials. The Final Declined Offers Feed is not intended to be used as an invoice. Rather, it is a feed that captures all records of and entitlements for a term in order to provide data to an institution so they may determine what students should not be charged.\

entitlement
student choices