Digital Inventory
The Digital Inventory subject area allows you to create reports concerning digital inventory and answer the following business questions:
- How many files and remote representation do we have in the repository, grouped by library?
- What is the last usage date of a specific file or representation?
- What is the total number of file downloads for a specific file?
- What is the size (in bytes) of a specific representation?
- What is the most widely used representation access right for digital inventory?
- How many representations and remote representations do we have in the repository by LC /Dewey classifications?

Digital Inventory
Field Descriptions

Digital Inventory – Field Descriptions
Digital Measures
The Digital Measures table is a fact table that stores all measures relating to digital inventory.
Field | Description | Additional Information |
---|---|---|
Representation Level | ||
Num Digital Representations (Deleted + In Repository) | The number of digital representations that were deleted and that are in the repository | |
Num Digital Representations (In Repository) | The number of digital representations that are in the repository | |
Num Digital Representations (Deleted) | The number of digital representations that were deleted | |
File Level | ||
Num Digital Files (Deleted + In Repository) | The number of digital files that were deleted and that are in the repository | |
Num Digital Files (In Repository) | The number of digital files that are in the repository | |
Num Digital Files (Deleted) | The number of digital files that were deleted | |
Digital File Views | The number of digital file views | |
Digital File Downloads | The number of digital file downloads | |
Digital File Size (In Bytes) | The digital file size in bytes | |
Digital File Size (In Kilobytes) | The digital file size in kilobytes | |
Digital File Size (In Terabytes) | The digital file size in terabytes |
Representation Details
The Representation Details table is a dimension table that stores information about digital representations.
Field | Description | Additional Information |
---|---|---|
Rep Availability | Indicates if the representation is active or inactive | |
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 ID | The ID of the representation | |
Rep Label | The label of the representation | |
Rep Lifecycle | The lifecycle of the representation | |
Rep Link Param 1-5 | The representation link parameters 1-5. This is relevant only for remote citations. | |
Rep Modified By | The user who modified the representation | |
Rep Num of Views | The number of views of the representation | |
Rep Last View Date | The last view date of the representation | |
Rep Num of Shares | The number of times the representation was shared | |
Rep Originating System ID | The origination system ID of the representation | |
Rep Public Note | The public note of the representation | |
Rep Type | The type of the representation | |
Rep Usage Type | The usage type of the representation | |
IED | The IED value | |
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 |
Representation Creation Date
The Representation Creation Date table is a dimension table that stores information about the representation creation date.
Field | Description | Additional Information |
---|---|---|
Rep Creation Date | Stores the representation creation date in the date format 2/29/2012 | |
Rep Creation Start of Week | The date of the first business day of the week | |
Rep Creation Week Number | The number of the week of the year | |
Rep Creation Month Key | Stores the month of the date in number format such as 2 for February | This field is useful when you want to sort by month |
Rep Creation Month | Stores the month of the date in month description format such as February | |
Rep Creation Full Month | Stores the month and the year of the date in a display format such as Feb 12 | |
Rep Creation Quarter | Stores the quarter of the date in a display format such as Q1 | |
Rep Creation Year | Stores the year of the date in string format such as 2012 | |
Rep Creation Fiscal Month Key | Stores the fiscal year of the date in number format such as 2 for February. | |
Rep Creation Fiscal Year | Stores the year of the date in string format such as 2012 | |
Rep Creation Date Filter | Used to filter report results by date. |
Representation Modification Date
The Representation Modification Date table is a dimension table that stores information about the representation modification date.
Field | Description | Additional Information |
---|---|---|
Rep Modification Date | Stores the modification date in the date format 2/29/2012 | |
Rep Modification Start of Week | The date of the first business day of the week | |
Rep Modification Week Number | The number of the week of the year | |
Rep Modification Month Key | Stores the month of the date in number format such as 2 for February | This field is useful when you want to sort by month |
Rep Modification Month | Stores the month of the date in month description format such as February | |
Rep Modification Full Month | Stores the month and the year of the date in a display format such as Feb 12 | |
Rep Modification Quarter | Stores the quarter of the date in a display format such as Q1 | |
Rep Modification Year | Stores the year of the date in string format such as 2012 | |
Rep Modification Fiscal Month Key | Stores the fiscal year of the date in number format such as 2 for February. | |
Rep Modification Fiscal Year | Stores the year of the date in string format such as 2012 | |
Rep Modification Date Filter | Used to filter report results by date |
Representation Library Unit
The Library Unit table is a dimension table that stores details about the library where the representation was created. The primary key of the table is LIBRARYID.
The field descriptions can be found in the Library Unit shared dimension.
Representation Access Rights
The Representation Access Rights table is a dimension table that stores information about the representation access rights.
Field | Description | Additional Information |
---|---|---|
Access Right ID | The ID of the access right | |
Access Right Desc | The description of the access right | |
Access Right Name | The name of the access right | |
Access Right Type | The type of the access right | |
(For future use) CDL Concurrent Users Limit Reached Note |
The note that appears when a patron requests a digital resource that has reached the maximum number of concurrent users | |
Copyright File Name | The file name of the copyright | |
Creation Date | The creation date of the access right | |
Creator | The creator of the access right | |
Denied Note | The denied note of the access right | |
(For future use) Is CDL |
Indicates if the Controlled Digital Lending (CDL) checkbox is selected for the access right | |
Modification Date | The modification date of the access right | |
Modified By | The user who modified of the access right | |
Obtrusive Copyrights | Indicates if the access rights has obtrusive copyrights | |
Required Copyright | Indicates if the access rights has a required copyright | |
Resource Type | The resource type of the access rights |
Representation Entity Type
The Representation Entity Type table is a dimension table that stores information about the representation entity type.
Field | Description | Additional Information |
---|---|---|
Rep Entity Type | The entity type of the representation | |
Rep Entity Author | The Author value of the representation entity type | |
Rep Entity Title | The Title value of the representation entity type | |
Rep Entity Creator | The Creator value of the representation entity type | |
Rep Entity Issue | The Issue value of the representation entity type | |
Rep Entity Volume | The Volume value of the representation entity type | |
Rep Entity Number | The Number value of the representation entity type | |
Rep Entity Track | The Track value of the representation entity type | |
Rep Entity Date | The Date value of the representation entity type | |
Rep Entity Year | The Year value of the representation entity type | |
Rep Entity Season Month | The Season/Month value of the representation entity type | |
Rep Entity Day In Month | The Day in Month value of the representation entity type | |
Rep Entity Start Time | The Start Time value of the representation entity type | |
Rep Entity End Time | The End Time value of the representation entity type | |
Rep Entity Start Page | The Start Page value of the representation entity type | |
Rep Entity End Page | The End Page value of the representation entity type |
Remote Digital Repository
The Remote Digital Repository table is a dimension table that stores information about the remote digital repository.
Field | Description | Additional Information |
---|---|---|
Remote Integration Code | The remote integration code | |
Remote Integration Name | The remote integration name | |
Remote Creation Date | The remote creation date | |
Remote Modification Date | The remote modification date | |
Remote System Name | The remote system name | |
Remote Repository Name | The remote repository name | |
Remote Status | The remote status |
File Details
The File Details table is a dimension table that stores information about the digital file details.
Field | Description | Additional Information |
---|---|---|
File Lifecycle | The lifecycle of the file | |
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 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 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 Creation Date
The File Creation Date table is a dimension table that stores information about the digital file creation date.
Field | Description | Additional Information |
---|---|---|
File Creation Date | Stores the file creation date in the date format 2/29/2012 | |
File Creation Start of Week | The date of the first business day of the week | |
File Creation Week Number | The number of the week of the year | |
File Creation Month Key | Stores the month of the date in number format such as 2 for February | This field is useful when you want to sort by month |
File Creation Month | Stores the month of the date in month description format such as February | |
File Creation Full Month | Stores the month and the year of the date in a display format such as Feb 12 | |
File Creation Quarter | Stores the quarter of the date in a display format such as Q1 | |
File Creation Year | Stores the year of the date in string format such as 2012 | |
File Creation Fiscal Month Key | Stores the fiscal year of the date in number format such as 2 for February. | |
File Creation Fiscal Year | Stores the year of the date in string format such as 2012 | |
File Creation Date Filter | Used to filter report results by date. |
File Modification Date
The File Modification Date table is a dimension table that stores information about the digital file modification date.
Field | Description | Additional Information |
---|---|---|
File Modification Date | Stores the modification date in the date format 2/29/2012 | |
File Modification Start of Week | The date of the first business day of the week | |
File Modification Week Number | The number of the week of the year | |
File Modification Month Key | Stores the month of the date in number format such as 2 for February | This field is useful when you want to sort by month |
File Modification Month | Stores the month of the date in month description format such as February | |
File Modification Full Month | Stores the month and the year of the date in a display format such as Feb 12 | |
File Modification Quarter | Stores the quarter of the date in a display format such as Q1 | |
File Modification Year | Stores the year of the date in string format such as 2012 | |
File Modification Fiscal Month Key | Stores the fiscal year of the date in number format such as 2 for February. | |
File Modification Fiscal Year | Stores the year of the date in string format such as 2012 |
Bibliographic Details
The Bibliographic Details table is a dimension table that stores the bibliographic details of the digital inventory item. The primary key of the table is MMS_ID.
The field descriptions can be found in the Bibliographic Details shared dimension.
LC Classifications
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.
Dewey Classifications
Digital Inventory 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.