| Table of Contents |
|---|
| minLevel | 1 |
|---|
| maxLevel | 2 |
|---|
| outline | false |
|---|
| type | list |
|---|
| printable | false |
|---|
|
...
Overview
This how-to guide contains instructions on exporting data from Consortia Manager (CM) to help answer various questions.
Listed in the table below are the relevant report types.
...
Relevant Report Types
Report Types | Possible Uses | Limitations |
|---|
Prices | List past and current subscriptions, and all future renewals
List cancellations | No Deposit Account metadata
Doesn’t show subscription notes |
Subscriptions | List past and current subscriptions, and any future renewals that have been accepted
Use to calculate price increases | Doesn’t show upcoming renewals that aren’t accepted
Doesn’t show cancellations |
Please contact OCLS if you would like want the raw data for a pro forma Deposit Account Balance Statement.
Report Field Terms
| Expand |
|---|
| title | Expand for a glossary of terms |
|---|
|
Some price fields are distinguished by (Original currency) VS (Local currency). Field Name | Report | Notes |
|---|
Account | Subscriptions | Paid out of Deposit Account or not | Final price | Subscriptions | Ignore. Sales price with exchange rate applied. | Group start/end date | Subscriptions, Agreements | The start and end date for multi-year agreements | List price | Subscriptions | Only recorded for Full Service subscriptions | Sales Price last year | Price, Subscriptions | The previous year’s 12 month price / annual rate | Publisher Adjustments | Subscriptions | The amount added/subtracted from Sales Price when there’s prorating or a one-time credit / discount. | Price last year | Subscriptions | The previous year’s 12 month price | Price status | Price | If a price has been Accepted, Rejected, or is Waiting for a decision.
“Not Sent” - these are either not ready, or we don’t have pricing on hand. | Price type | Price | If a subscription is New or a Renewal | Product category | Subscriptions | Type of product e.g. book / journal / multimedia | Publisher Adjustments | Subscriptions | The amount added/subtracted from Sales Price when there’s prorating or a one-time credit / discount. | Publisher name | Subscriptions, Price | Vendor name; we do not distinguish | Status | Subscriptions | Active/inactive - whether the subscription is ongoing or has expiredbetween vendor and publisher | Sales Price | Price, Subscriptions | 12 month price / annual rate | Start Date/End Date | Subscriptions, Price | When the subscription starts and ends | Status | Subscriptions | Active - a subscription term is ongoing
Inactive - a subscription term has ended or yet to start | Total price | Subscriptions | Sales Price + Publisher Adjustments.
If Total price (Local currency), it includes exchange rate. | Price type | Price | If a subscription is New or a Renewal | Price status | Price | If a price has been Accepted, Rejected, or is Waiting for a decision.
“Not Sent” - these are either not ready, or we don’t have pricing on hand. | Discounts | Price | Publisher Adjustments that are subtracted | Fees | Price | Publisher Adjustments that are added | Final price | Subscriptions | Ignore. Sales price with exchange rate applied. | Group start/end date | Subscriptions, Agreements | The start and end date for multi-year agreements | Account | Subscriptions | Paid out of Deposit Account or not |
A little on system logic All subscription records are price records, but not all price records are subscriptions. Subscriptions are specifically price records with a status of “Accepted”, and only “Accepted”. Renewals are price records with a type of “Renewal”, and can have different statuses.
|
Get to the Reports Module
| Excerpt |
|---|
|
In the top navigation bar, hover over MORE In the drop down, click on REPORTS
 |
...