Zero Usage Data Model

Some Counter reports such as JR1 must provide the capability to show 0 usage on content, meaning content having been subscribed on a period, but not having been consumed.
Inqwell offers the ability to collect subscribed content and generate the proper reports.

Subscriptions

This is the main subscription table linking an account with the databases he has access to.
We request a daily feed of the entire active subscriptions only. Inqwell processing will handle start & end periods of subscription comparing the current daily feed with the whole history already loaded.
Subscription under grace period should be considered as active thus sent
Any missing subscription in daily feed will lead to exclude their usage from reports
Requesting 0 usage includes subscriptions' contents being active within the desired period

Column	Description	Format
Subscription ID	Unique identifier of a subscription	VARCHAR
Account ID	Account identifier having subscribed	VARCHAR
Database ID	Database Id being subscribed	VARCHAR
Application Id	Application used to serve the content (duplicate rows if several application can serve the same subscription)	VARCHAR

Suspensions

You have the ability to indicates the temporary suspension of an entire subscription. Just add the corresponding data in the daily feed, every day the suspension is valid

Column	Description	Format
Subscription ID	Unique identifier of a subscription	VARCHAR
Account ID	Account identifier having subscribed	VARCHAR
Application Id	Application used to serve the content (duplicate rows if several application can serve the same subscription)	VARCHAR

Exclusions

You have the ability to exclude the access of a database for a given child, and for a given period. Just add the relevant information every day the exclusion occurs

Column	Description	Format
Subscription ID	Unique identifier of a subscription	VARCHAR
Child Account ID	Child Account being excluded from access	VARCHAR
Database ID	Database Id being excluded	VARCHAR
Application Id	Application used to serve the content (duplicate rows if several application can serve the same subscription)	VARCHAR

Databases Content

For 0 usage, indicates in this daily feed all the content available per database. Inqwell wil handle start & end date of a content availability within each its databases for proper reporting. A daily feed is required

Column	Description	Format
Database ID	Unique identifier of a database	VARCHAR
Content Id	Unique identifier of a content	VARCHAR
Application Id	Application used to serve the content (duplicate rows if several application can serve the same subscription)	VARCHAR