Purpose
Provides publishers current CA and TA adoptions in Connect and the price of the adoption for the Bookstore.
Report Notes
❌ This report will retire on May 1, 2026. It is replaced by the Affordability Program Tracker Report. Please review the documentation and start using the new report for clearer and more effective insights on Affordability Programs. |
Definition of filters
| Filter Name | Description | Usage | |
Term Start Date (Required) | Term start date according to the school’s set up in Connect | Defaulted to “current quarter” | |
| Institution Name | Name of the institution (Manage company name) | Use to look up a specific institution(s) | |
| Publisher Name | The name of the publisher that owns the content | Use to look up a specific publisher(s) | |
| Product Name | Name of the item adopted in Connect | Use to look up a specific product(s) | |
| Product SKU | VitalSource ID associated with the adopted item (if a match exists in the VitalSource system) | Use to search for a specific asset or for many assets. You can easily copy/paste multiple values. This can be completed through copying a column of ISBNs or VBIDs from an excel-like document or copying ISBNs or VBIDs separated by commas.
| |
| Participation Model | Indicates the participation model for the institution, either: Opt-in or Opt-out | Use to narrow to specific participation models | |
| Department Name | Department name in Connect | Use to narrow to specific department(s) | |
| Course Name | Course name in Connect | Use to narrow to specific course(s) | |
| Section Status | Indicates whether a section is “Active” or “Inactive”. | Use to narrow to a specific section status |
Definition of fields
| Field Name | Description | |
| Institution Name | Name of the institution (Manage company name) | |
| Institution Manage ID | Institution’s VitalSource Manage ID number | |
| Connect Organization | Name of the institution (Connect name) | |
| IPEDS ID | Institution’s IPEDs number | |
| Ringgold ID | Institution’s Ringgold number | |
| Term Name | This is the term name, recorded as a catalog in Connect. | |
| Schedule Name | Schedule Name from Connect. Useful for noting various schedules within a term. | |
| Department Name | Department name in Connect | |
| Course Name | Course name in Connect | |
| Section Name | Section name in Connect | |
| Instructor Name | Instructor name for the course | |
| Section Status | Indicates whether a section is “Active” or “Inactive”. | |
| Product Name | Name of the item adopted in Connect | |
| Content Type | The type associated with the product. Differentiates eBooks, courseware and bundles. | |
| Billing ISBN | ISBN and rental duration of item adopted in Connect | |
| VitalSource SKU | VitalSource ID associated with the adopted item (if a match exists in the VitalSource system) | |
| Publisher Name | The name of the publisher that owns the content | |
| Program Type | Program that an Institution offers, by catalog (i.e., the specific department, course, section, and adopted content) | |
| Participation Model | Indicates the participation model for the institution, either: Opt-in or Opt-out | |
| Access Codes Required | Indicates if the product will be delivered via access codes or not. | |
| Delivery Method | Delivery method as noted in Connect. Values may be “VitalSource”, “From Publisher”, “Other”, or null. | |
| Launch Enabled | Boolean field that notes whether an LMS Course ID is present. | |
| LMS Course ID | LMS Course ID stored in Connect for this adoption | |
| Item Created Date | The date the product was created in Connect. | |
| Item Updated Date | The date the product was last updated in Connect. | |
| Schedule Opt-in/out Deadline | Date which an Institution’s opt-in/opt-out decisions must be completed | |
| Term Start Date | Term start date according to the school’s set up in Connect | |
| Term End Date | Term end date according to the school’s set up in Connect | |
| Invoice Date | Term start date according to the school’s set up in Connect | |
| Cost to Bookstore | This is the net price to the bookstore. Only populated when the product has been created in Connect. Note that some bookstores will use placeholder prices on inactive sections to remind of future work required. | |
| Enrolled | Number of students rostered into the section (to-date)
| |
| Drop | The number of students that have dropped. | |
| Continuation | The number of students that are continuing and already have the content. | |
| Opt-In | The number of students that have opted-in to the CA/TA program. | |
| Opt-Out | The number of students that have opted-out from the CA/TA program. | |
| Pct with Content | The percentage of students enrolled that have access to the materials either by opting-in to the program or from continuation. |