Purchase Requests (Analytics)
Using the Purchase Requests subject area you can create reports concerning purchase requests and answer the following business questions:
- How many purchase requests were made in a time range?
- How many purchase requests were assigned to a user?
- How many purchase requests have a PO line?
- How many purchase requests were made per status?

Star Diagram – Purchase Requests
Field Descriptions
The following lists the fields available in Purchase Requests.

Purchase Requests – Field Descriptions
Purchase Request Measures
The Purchase Request Measures table is a fact table that stores the measures of purchase requests.
Field | Description | Additional Information |
---|---|---|
Number of Purchase Requests | The number of purchase requests | |
Estimated Cost | The estimated cost | |
Number of Purchase Requests - Books | The number of purchase requests for books | |
Number of Purchase Requests - Electronic | The number of purchase requests for electronic material | |
Number of Purchase Requests - Electronic Books | The number of purchase requests for electronic books | |
Number of Purchase Requests - Electronic Journals | The number of purchase requests for electronic journals | |
Number of Purchase Requests - Journals | The number of purchase requests for journals | |
Number of Purchase Requests - Physical | The number of purchase requests for physical material | |
Number of Purchase Requests - Physical Books | The number of purchase requests for physical books | |
Number of Purchase Requests - Physical Journals | The number of purchase requests for physical journals | |
Number of Purchase Requests Approved | The number of purchase requests approved | |
Number of Purchase Requests In Review | The number of purchase requests in review | |
Number of Purchase Requests Rejected | The number of purchase requests rejected | |
Number of Purchase Requests With Funds | The number of purchase requests with funds | |
Number of Purchase Requests With PO Lines | The number of purchase requests with PO lines | |
Number of Purchase Requests With Reading Lists | The number of purchase requests with reading lists |
Purchase Request Details
Purchase Request Details is a dimension table that contains fields relating to purchase request details, such as Currency, Purchase Request ID, and Request Status.
Field | Description | Additional Information |
---|---|---|
Application | The application that created the record | |
Approved Format | The approved format of the purchase request | |
Author | The author of the purchase request | |
Citation Type | The citation type of the purchase request | |
Creation Date and Time | The creation date and time | |
Currency | The currency of the purchase request | |
ISSN / ISBN | The ISSN / ISBN of the purchase request | |
LCCN | The LCCN of the purchase request | |
Located Bibliographic Information | Indicates (Yes/No) if the purchase request has a linked bibliographic record | |
Located Bibliographic Information Flag | Indicates (1/0) if the purchase request has a linked bibliographic record | |
Modification Date and Time | The modification date and time | |
Modification Details | The modification details of the purchase request | |
Modified By Job | The job ID of the last job that updated the record | |
OCLC Number | The OCLC number of the purchase request | |
Purchase Request ID | The ID of the purchase request | |
Rejection Reason | The rejection reason of the purchase request | |
Request Status | The request status of the purchase request | |
Requested Format | The requested format of the purchase request | |
Requester Note | The requester note of the purchase request | |
Source Type | The source type of the purchase request | |
Title | The title of the purchase request |
Bibliographic Details
Bibliographic details is a shared dimension that contains bibliographic information about the purchase request.
Classifications
Classifications contains the Dewey Classification, LC Classification, and Other Classifications shared dimensions.
Creation Date
The Creation Date dimension is a dimension table that stores details about the creation date of the purchase request.
Field | Description | Additional Information |
---|---|---|
Creation Date | Stores the date in the format 2/29/2012 | |
Creation Start of Week | The date of the first business day of the week | |
Creation Week Number | The number of the week of the year | |
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 |
Creation Month | Stores the month of the date in month description format such as February | |
Creation Full Month | Stores the month and the year of the date in a display format such as Feb 12 | |
Creation Quarter | Stores the quarter of the date in a display format such as Q1 | |
Creation Year | Stores the year of the date in string format such as 2012 | |
Creation Fiscal Month Key | Stores the fiscal month of the date in number format such as 2 for February | |
Creation Fiscal Year | Stores the fiscal year of the date in string format such as 2012. | |
Creation Date Filter | Used to filter report results by date | |
Creation Date | Stores the Hierarchy column that allows the user to drill down from the year to the month to the specific loan date. Using this column provides the user with the option to view the accumulative measures in each level of the hierarchy. |
Modification Date
The Modification Date dimension is a dimension table that stores details about the modification date of the purchase request.
Field | Description | Additional Information |
---|---|---|
Modification Date | Stores the date in the format 2/29/2012 | |
Modification Start of Week | The date of the first business day of the week | |
Modification Week Number | The number of the week of the year | |
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 |
Modification Month | Stores the month of the date in month description format such as February | |
Modification Full Month | Stores the month and the year of the date in a display format such as Feb 12 | |
Modification Quarter | Stores the quarter of the date in a display format such as Q1 | |
Modification Year | Stores the year of the date in string format such as 2012 | |
Modification Fiscal Month Key | Stores the fiscal month of the date in number format such as 2 for February | |
Modification Fiscal Year | Stores the fiscal year of the date in string format such as 2012. | |
Modification Date Filter | Used to filter report results by date | |
Modification Date | Stores the Hierarchy column that allows the user to drill down from the year to the month to the specific loan date. Using this column provides the user with the option to view the accumulative measures in each level of the hierarchy. |
Fund
The Fund table is a dimension table that stores the details about the fund with which the purchase request is associated.
Field | Description | Additional Information |
---|---|---|
Fund Currency | Stores the fund's currency | |
Fund External ID | The fund ID used by an external system. | |
Fiscal Period ID | The ID of the fiscal period | |
Fund Area Code | Stores values defined in the Fund Types table and attributed to funds, for example: Endowed, Gift, General, Grant, Income, and Resource Sharing. For more information, see Configuring Fund Types. | This field is named Fund type in Alma and is created via a mapping table. See the figures Fund and Ledger - Summary Details and Fund Types, below. |
Fund Area Description | Stores the fund area description | |
Fund Description | The contents of the Description field of the Summary tab of the fund | |
Fund Code | Stores the fund code unique to each institution and fiscal period | This code is not unique, since each year another entry is made for the same code |
Fund ID | Stores the unique ID of the fund | |
Fund Name | Stores the fund name | |
Fund Owner Code | The owner code of the fund | |
Fund Owner Name | The owner name of the fund | |
Fund Status | Indicates if the fund is active or inactive | |
Fund Type | Stores one of the following types:
|
|
Fund Note | Stores the note | |
Parent Fund Code |
Stores the parent fund code | |
Parent Fund ID | Stores the unique ID of the fund's parent | |
Parent Fund Name | Stores the parent fund name |
Library Unit
The Library Unit table is a dimension table that stores details about the library where the PO Line was created.
Owning Library
The Owning Library table is a dimension table that stores details about the library/institution that created the purchase request. The primary key of the table is ORGANIZATION_ID.
Field | Description | Additional Information |
---|---|---|
Owning Library Code | Stores the owning library code | |
Owning Library Code (Active) | Stores the code of active (not deleted) owning libraries | |
Owning Library Name | Stores the owning library name | |
Owning Library Name (Active) | Stores the owning library name of active (not deleted) libraries | |
Owning Library Description | Stores the owning library description | |
Owning Library Type | Stores the type of organization unit of th eowning library | Values can be Institution/Library |
Owning Location Code | Stores the owning library location code | |
Owning Location Name | Stores the owning library location name |
PO Line
The PO Line table is a dimension table that stores details about the PO and the PO Line that is associated with the fund transaction.
PO Line Approver
The PO Line Approver table is a dimension table that stores details about the approver of the PO line.
PO Line Creation Date
The PO Line Creation Date table is a dimension table that stores details about the date that the PO line was created.
Field | Description | Additional Information |
---|---|---|
PO Line Creation Date | Stores the date in the date format 2/29/2012 | |
PO Line Creation Start Of Week | The date of the first business day of the week | |
PO Line Creation Week Number | The number of the week of the year | |
PO Line Creation Month Key | Stores the month of the date in number format such as 2 for February | |
PO Line Creation Month | Stores the month of the date in month description format such as February | |
PO Line Creation Full Month | Stores the month and the year of the date in a display format such as Feb 12 | |
PO Line Creation Quarter | Stores the quarter of the date in a display format such as Q1 | |
PO Line Creation Year | Stores the year of the date in string format such as 2012 | |
PO Line Creation Fiscal Month Key | Stores the fiscal month of the date in number format such as 2 for February | |
PO Line Creation Fiscal Year | Stores the fiscal year of the date in string format such as 2012. | |
PO Line Creation Date Filter | Used to filter report results by date. |
Purchase Request Approver, Purchase Request Assigned To, Purchase Request Creator, Purchase Request Modified By, Purchase Request Requester
The Purchase Request Approver, Purchase Request Assigned To, Purchase Request Creator, Purchase Request Modified By, and Purchase Request Requester tables are dimension tables that contain fields relating to details of the roles of the purchase request workflow.
Field | Description | Additional Information |
---|---|---|
Birth Date | The birth date | |
Campus Code | The campus code | |
Creation Date | The creation date | |
Creator | The creator | |
Expiry Date | The expiry date | |
External ID | The external ID | |
Failed Authentication | Indicates if authentication failed | |
First Name | The first name | |
Full Name | The full name | |
Gender | The gender | |
Identifier 1-2 | Identifiers 1-2 | |
Job Category | The job category | |
Job Description | The job description | |
Last Name | The last name | |
Last Activity Date | The last date that a patron made a request or borrowed or returned an item | |
User – Linked from Institution Code | The linked from institution code | |
User – Linked from Institution Name | The linked from institution name | |
Linked to Other Institution | Indicates if linked to another institution | |
User – Linked From Other Institution | Indicates if the user is linked from another institution | Possible values:
|
Locked Out Date | The locked out date | |
Middle Name | The middle name | |
Modification Date | The modification date | |
Modified By | The user that modified | |
Preferred Language | The preferred language | |
Primary Identifier | The primary identifier | |
Purge Date | The purge date | |
Resource Sharing Library | The resource sharing library | |
Resource Sharing Library Code | The resource sharing library code | |
Statistical Category 1-10 | Statistical categories 1-10 | These fields allow you to map ten statistical categories. This allows you to filter reports based on advanced user information typically stored in the statistical category fields. For more information, see Configuring Statistical Categories for Analytics. |
Status | The status | |
Status Date | The status date | |
User Group | The user group at the time the report is run. | |
User Group Code | The user group code | |
User ID | The user ID | |
User Record Type | The user record type | |
User Title | The user title | |
User Type | The user type | |
Cataloger Level | The cataloger level of the user | |
Has Role Other Than Patron | indicates if the patron has a role other than Patron | |
Has Role Other Than Patron and Instructor | Indicates if the patron has a role other than Patron and Instructor | |
Is Blocked | Indicates if the patron is blocked | |
Patron Letters Opt In | The letters for which the patron has opted in | |
Patron Letters Opt Out | The letters for which the patron has opted out |
Reading List Citations
The Reading List Citations table is a dimension table that contains fields relating to reading list citations.
Field | Description | Additional Information |
---|---|---|
Additional Person Name | The additional person name | |
Article End Page | The end page of the article | |
Article Number of Pages | The number of pages in the article | |
Article Start Page | The start page of the article | |
Assign to ID | The assign to ID | |
Author | The author of the article | |
Barcode | The barcode | |
Book Call Number | The call number of the book | |
Book Chapter Author | The author of the book chapter | This field is relevant only for citations created after March 2018. |
Book Chapter Editor | The editor of the book chapter | This field is relevant only for citations created after March 2018. |
Book Chapter Number | The chapter number of the book | |
Book Chapter Title | The title of the book chapter | This field is relevant only for citations created after March 2018. |
Book Edition | The edition of the book | |
Citation Alerts | The alerts of the citation | |
Citation Attribute (1-5) | The citation attributes. | For information on configuring the citation attribute fields, see Displaying Citation Attributes in Analytics Reports. |
Citation Copyright ID | The citation copyright ID | |
Citation Copyright Status | The citation copyright status | |
Citation Creation Date | The date the citation was created | |
Citation Created By | The creator of the citation | |
Citation Due Date | The due date of the citation | |
Citation Has Public Note | Indicates if the citation has a public note | |
Citation ID | The ID of the citation | |
Citation Library Internal Tags | The library internal tags of the citation | |
Citation Library Tags | The library tags of the citation | |
Citation License Type | Indicates the type of the citation license, for example: Creative commons and DCS. | |
Citation License Type Code | Indicates the code of the license type of the citation | |
Citation Locate Status | Indicates if the resource is located. | Possible values are:
|
Citation Material Type | The citation material type. | |
Citation Material Type Code | The citation material type code. | |
Citation Modification Date | The citation modification date | |
Citation Modified By | The person who modified the citation | |
Citation Order | A number indicating the place of the citation in order | |
Citation Origin | Where the citation originated. | Possible values are the following. Values such as Digital/Physical/Electronic indicate that the citation's origin is the Alma repository and the available formats of the resource:
|
Citation Public Note | The public note of the citation | |
Citation Public Tags | The public tags of the citation | |
Citation Source | The source of the citation | |
Citation Source 1-10 | The sources of the citation | |
Citation Status | The status of the citation | |
Citation Type | The citation type. | Possible values are:
|
Citation Uploaded File | The file name that was uploaded to the citation | |
CLA/DCS Link | The CLA/DCS link | |
Course End date | The course end date | |
Course ID | The course ID | |
Course Start Date | The course start date | |
Digital File Date Added | The date that the digital file was added | |
Digital File Name | The name of the digital file | |
DOI | The digital object identifier | |
ISBN | The ISBN of the book | |
ISSN | The ISSN of the journal | |
Issue | The issue of the journal | |
Journal Title | The title of the journal | |
Leganto Citation Hidden Links | Indicates if there are hidden links in the citation | Possible values:
|
Leganto Citation Library Discussion Last Update | The last day the citation was discussed | |
Library ID | The library ID | |
Locate Status | The locate status | |
MMS ID | The MMS ID | |
Note | The note | |
Number of Citations | The number of citations | |
Number of Library Discussions | The number of library discussions of the citation | |
Number of Likes | The number of likes of the citation | |
Number of Read It | The number of Read Its of the citation | |
Number of Student Comments | The number of student comments of the citation | |
OCLC Number | The OCLC number | |
Owner ID | The owner ID | |
Pages | The pages of the citation | |
Part | The part | |
Publication Date | The date of publication | |
Publication Place | The place of publication | |
Publish Citation End Date | The publish citation end date | |
Publish Citation Start Date | The publish citation start date | |
Publish Materials End Date | The publish materials end date | |
Publish Materials Start Date | The publish materials start date | |
Publish Section Visible | Indicates whether the section is hidden from students outside of the section dates | |
Publisher | The publisher | |
Reading List ID | The reading list ID | |
Representation URL | The representation URL | |
Section ID | The section ID | |
Section Library Internal Tags | The section library internal tags | |
Section Library Tags | The section library tags | |
Section Public Tags | The section public tags | |
Title | The title of the citation | |
Volume | The volume of the citation |