Digital Usage
Using the Digital Usage subject area, you can create reports and dashboards relating to digital usage and answer the following types of business questions:
- How many times was the digital representation viewed?
- How many times was the digital representation shared?
- How many times was the digital representation access denied?
- How many and which of the digital files were downloaded?
- How many and which of the digital files were viewed?

Star Diagram – Digital Usage
Field Descriptions
The following fields are available in Licenses.

Digital Usage – Field Descriptions
Digital Usage Measures
The Digital Usage Measures table is a fact table that stores all measures relating to digital usage, such as number of digital representation views and number of digital file views.
The number of digital representation views may be greater than the number of digital file views in the following situations:
- If the representation has an access rights policy that requires the patron to acknowledge a copyright statement. If the patron does not accept the copyright statement, it counts as a representation view but not as a file view.
- If the representation has a digital lending access rights policy and the maximum number of concurrent users is exceeded, so that the patron needs to join a waitlist, it counts as a representation view but not as a file view.
| Field | Description | Additional Information |
|---|---|---|
| Num of digital representation views | The number of digital representation views | |
| Num of digital representation shares | The number of digital representation shares | |
| Num of digital representation access denied | The number of digital representation access denied | The number of times access to the digital representation has been denied due to the access rights policy blocking the user. |
| Num of digital file views | The number of digital file views | In the Universal viewer and the Internet Archive Book Reader Viewer, there is no support for counting the number of files viewed (no event is triggered when moving between files), as there is for the Digital Viewer. |
| Num of digital file downloads | The number of digital file downloads |
Digital Usage Details
The Digital Usage Details table is a dimension table that stores additional details about digital usage.
| Field | Description | Additional Information |
|---|---|---|
| Request ID | The request ID | |
| Delivery Type | The delivery type of the representation | Possible Values:
|
| Representation ID | The representation ID | |
| File ID | The file ID | |
| Usage level | The usage level | |
| Creator | The creator of the usage, for example, the user who viewed or downloaded the file. |
Representation Details
The Representation Details table is a dimension table that stores information about digital representations. The Rep Entity fields refer to fields that appear in the Digital Representation Resource Editor when selecting an Entity Type.
| Field | Description | Additional Information |
|---|---|---|
| Rep Creation Date | The date that the representation was created | |
| Rep Creator | The creator of the representation | |
| Rep Delivery URL | The delivery URL of the representation | |
| Rep Deposit ID | The deposit ID of the representation | |
| Rep Digitization ID | The digitization ID of the representation | |
| Rep Entity Author | The Author value of the representation entity type | |
| Rep Entity Creator | The Creator value of the representation entity type | |
| Rep Entity Date | The Date value of the representation entity type | |
| Rep Entity Day in Month | The Day in Month value of the representation entity type | |
| Rep Entity End Page | The End Page value of the representation entity type | |
| Rep Entity End Time | The End Time value of the representation entity type | |
| Rep Entity Issue | The Issue value of the representation entity type | |
| Rep Entity Number | The Number value of the representation entity type | |
| Rep Entity Season Month | The Season/Month value of the representation entity type | |
| Rep Entity Start Page | The Start Page value of the representation entity type | |
| Rep Entity Start Time | The Start Time value of the representation entity type | |
| Rep Entity Title | The Title value of the representation entity type | |
| Rep Entity Track | The Track value of the representation entity type | |
| Rep Entity Type | The entity type of the representation | |
| Rep Entity Volume | The Volume value of the representation entity type | |
| Rep Entity Year | The Year value of the representation entity type | |
| Rep Label | The label of the representation | |
| Rep Last View Date | The last date that the representation was viewed | |
| Rep Lifecycle | The lifecycle of the representation | |
| Rep Link Param 1-5 | The representation link parameters 1-5 | |
| Rep Modification Date | The modification date of the representation | |
| Rep Modified By | The user who modified the representation | |
| Rep Originating System ID | The origination system ID of the representation | |
| Rep Public Note | The public note of the representation | |
| Rep Remote Code | The remote code of the representation | |
| Rep Type Code | The code of the type of the representation | |
| Rep Usage Type | The usage type of the representation | |
| Is Deposit | Indicates if the representation entered the repository as a deposit | |
| Is Digitization | Indicates if the representation entered the repository from a digitization request |
File Details
The File Details table is a dimension table that stores information about the digital file details.
| Field | Description | Location in Alma | Additional Information | Data Type | Data Size |
|---|---|---|---|---|---|
| File Creation Date | The creation date of the file | ||||
| File Creator | The creator of the file | ||||
| File Deleted Type | The type of the deleted file | ||||
| File Extension | The extension of the file | ||||
| File Format Description | The file's Format Library format description | New for March! File Format field in the Technical Information section of the file in Specto Preservation | This is relevant only for institutions using Specto Preservation | VARCHAR | 255 |
| File Format ID | The file’s Format Library format ID in Specto Preservation | New for March! File Format field in the Technical Information section of the file in Specto Preservation | This is relevant only for institutions using Specto Preservation | VARCHAR | 255 |
| File Format Version | The file’s Format Library format version | New for March! File Format field in the Technical Information section of the file in Specto Preservation | This is relevant only for institutions using Specto Preservation | VARCHAR | 255 |
| File ID | The ID of the file | ||||
| File Internal Path | The internal path of the file | ||||
| File Label | The label of the file | ||||
| File Last View Date | The last date the file was viewed | ||||
| File Lifecycle | The lifecycle of the file | ||||
| File Mime Type | The Mime type of the file | ||||
| File Modification Date | The modification date of the file | ||||
| File Modified By | The user who modified the file | ||||
| File Name | The name of the file | ||||
| File Original ID | The original ID of the file | ||||
| File Original Name | The original name of the file | ||||
| File Original Path | The original path of the file | ||||
|
File Technical Issue Details
|
The file’s preservation technical error description
|
New for March! Displayed on the file as a badge in the Content List section of the Title in the Technical Analysis Workbench in Specto Preservation
|
This is relevant only for institutions using Specto Preservation.
Multiple values are separated by a semicolon (;)
|
VARCHAR
|
255
|
|
File Technical Issue Type
|
The file’s preservation technical error types in Specto Preservation, for example Format Identification, Technical MD Extraction, etc.
|
New for March! Displayed on the file as a badge in the Content List section of the Title in the Technical Analysis Workbench in Specto Preservation
|
This is relevant only for institutions using Specto Preservation.
Multiple values are separated by a semicolon (;)
|
VARCHAR
|
255
|
Request Date
The Request Date table is a dimension table that stores information about the digital request date. For the purposes of this table, a request is the same as usage.
| Field | Description | Additional Information | Data Type | Data Size |
|---|---|---|---|---|
| Request Date | The current course end date of the purchase request | The date in the format DD/MM/YYYY | DATE | |
| Request Start of Week | The date of the first business day of the week | The date in the format DD/MM/YYYY | DATE | |
| Request Week Number | The number of the week of the year | There are 52 weeks in a year. | VARCHAR | 2 |
| Request Month Key | The month of the date in number format | For example - February will show the number 2 in this column. This field is useful when you want to sort by month. | INT | |
| Request Month | The month of the date in text format | The month, for example, "February" | VARCHAR | 20 |
| Request Full Month | The year and month that the purchase request was modified | The month in text format and the year. For example - Feb 25 (for February 2025) | VARCHAR | 20 |
| Request Quarter | The quarter in the year in which the purchase request was modified | The quarter of the date in a display format such as Q1 | VARCHAR | 20 |
| Request Year | The year in which the purchase request was modified | The year of the date in the format YYYY . For example - 2025 | VARCHAR | 20 |
| Request Year-Month | The year and the month in which the purchase request was modified | The year and the month in the format YYYY-MM | VARCHAR | 250 |
| Request Fiscal Month Key | The fiscal month of the date in number format | For example - If the fiscal year starts in June, this column will show the number 1 for June, the number 2 for July, and so on. | INT | |
| Request Fiscal Year | The fiscal year of the date in string format | The year is presented according to the description in the mapping table "Fund and Ledger Fiscal Period". For more information, see Configuring Fund and Ledger Fiscal Periods | VARCHAR | 50 |
| Request Date Filter | Used to filter report results by date | Possible values:
|
VARCHAR | 100 |
Bibliographic Details
The Bibliographic Details table is a dimension table that stores the bibliographic details of the digital usage. The primary key of the table is MMS_ID.
The field descriptions can be found in the Bibliographic Details shared dimension.
Dewey Classifications
Books can be classified with Dewey Classifications.
In Dewey Classifications, topics are ordered in a hierarchy that is indicated by a three digit number. The highest level of the hierarchy is indicated by a number with one significant digit followed by two zeros, such as 600. The second level in the hierarchy is indicated by a number with two significant digits followed by one zero, such as 630. The third level in the hierarchy is indicated by a number with three significant digits such as 636.
Note that the Dewey number is taken from the 852 subfield h of the holdings record and not from the 082 of the bibliographic record.
The field descriptions can be found in the Dewey Classifications shared dimension.
LC Classification
Using this dimension, the user can drill down from Group1 to Group4. In each level, the user may see measures accumulated to the relevant group and see the number of items grouped by classification.
The field descriptions can be found in the LC Classifications shared dimension.




