DARA
Using the Dara subject area, you can create reports and dashboards concerning the use of the DARA recommendations received by your institution and can answer the following types of business questions:
- How many recommendations were used?
- How many recommendations were dismissed?
- What were the recommendations?
- What was the dismissal reason for the recommendation?
- Who made the changes to the recommendation?
- When was the recommendation created and when was it changed?
Field Descriptions
The following lists the fields available in DARA
DARA Measures
DARA Measures is a fact table that stores measures relating to DARA.
| Field | Description | Additional Information |
|---|---|---|
| No. of Recommendations | The number of recommendations | |
| No. of Implemented Recommendations | The number of implemented recommendations | |
| No. of Manually Implemented Recommendations | The number of recommendations implemented manually (not through DARA) | |
| No. of DARA Implemented Recommendations | The number of recommendations implemented through DARA | |
| No. of Dismissed Recommendations | The number of dismissed recommendations | |
| No. of Expired Recommendations | The number of expired recommendations | |
| No. of Recommendations with Feedback | The number of recommendations with feedback |
DARA Details
DARA Details is a dimension table that stores details relating to DARA.
| Field | Description | Additional Information |
|---|---|---|
| Comment | The comment on a recommendation | |
| Criteria | The criteria for analytics based recommendations | |
| Dismiss Reason | The dismiss reason of a recommendation | |
| Feedback | The feedback of a recommendation | |
| Global Index | The global index of a recommendation | Some recommendations use a global index, for example, the usage data recommendations use the global vendors index |
| Grade | The grade of a recommendation | The rating given to a recommendation when closed, indicating if it was helpful or not |
| Status | The status of a recommendation | |
| Security Parameters | The security parameters of a recommendation | |
| Type | The type of a recommendation |
Assigned To
Assigned To is a dimension table that stores details relating to whom the DARA recommendation is assigned.
| Field | Description | Additional Information |
|---|---|---|
| Birth Date | The birth date | |
| Campus Code | The campus code | |
| Cataloger Level | The cataloger level of the user | |
| Creation Date | The creation date | |
| Creator | The creator | |
| Expiry Date | The expiry date | |
| External ID | The external ID | |
| First Name | The first name | |
| Full Name | The full name | |
| Gender (Not in Use) | The gender | |
| 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 | |
| Identifier 1-2 | Identifiers 1-2 | |
| Is Blocked | Indicates if the patron is blocked | |
| Job Category | The job category | |
| Job Description | The job description | |
| Last Activity Date | The last date that a patron made a request or borrowed or returned an item | |
| Last Name | The last name | |
| User – Linked from Institution Code | The linked from institution code | |
| User – Linked from Institution Name | The linked from institution name | |
| User – Linked From Other Institution | Indicates if the user is linked from another institution | Possible values:
|
| Linked to Other Institution | Indicates if the user accessed Primo/Alma for services in another institution. Note that this does not necessarily indicate that the services were actually supplied or that a linked account was created. | Possible values:
|
| Middle Name | The middle name | |
| Modification Date | The modification date | |
| Modified By | The user that modified | |
| 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 | |
| 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. |
| Status | The status | |
| Status Date | The status date | |
| User Group | The user group | |
| 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 |
Creation Date
The Creation Date dimension is a dimension table that stores details about the creation date of the DARA recommendation.
| Field | Description | Additional Information | Data Type | Data Size |
|---|---|---|---|---|
| Creation Date | The creation date of the DARA recommendation | The date in the format DD/MM/YYYY | DATE | |
| Creation Start of Week | The date of the first business day of the week. | The date in the format DD/MM/YYYY | DATE | |
| Creation Week Number | The number of the week of the year. | There are 52 weeks in a year. | VARCHAR | 2 |
| Creation Month Key | The month of the date in number format. | E.g. February shows the number 2 in this column. This field is useful when you want to sort by month. | INT | |
| Creation Month | The month of the date in text format. | The month, e.g. February | VARCHAR | 20 |
| Creation Full Month | The year and month that the reading list was modified. | The month in text format and the year. E.g. Feb 25 (for February 2025) | VARCHAR | 20 |
| Creation Quarter | The quarter in the year in which the reading list was modified. | The quarter of the date in a display format such as Q1 | VARCHAR | 20 |
| Creation Year | The year in which the reading list was modified. | The year of the date in the format YYYY . E.g. 2025 | VARCHAR | 20 |
| Creation Fiscal Month Key | The fiscal month of the date in number format. | E.g. If the fiscal year starts in June, this column shows the number 1 for June, the number 2 for July, and so on. | INT | |
| Creation 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 |
| Modification Date Filter | Used to filter report results by date. |
Possible values:
|
VARCHAR | 100 |
| Creation Date Year-Month | The year and the month in which the reading list was modified. | The year and the month in the format YYYY-MM | VARCHAR | 250 |
| Creation Date | Stores the date in a hierarchy format | 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. |
Library Unit
The Library Unit table is a dimension table that stores details about the library where the PO Line was created.
| Field | Description | Field Location in Alma | Additional Information | Data Type | Data Size |
|---|---|---|---|---|---|
| Library Address Line 1 | The first line of the address of the institution. It usually includes the building number and the street name. |
Configuration > General > Add a Library or Edit Library Information > Contact Information tab. This is taken from the address configured as the Preferred address. The label in Alma is Address Line 1. |
VARCHAR | 1000 | |
| Library City | The city of the library. |
Configuration > General > Add a Library or Edit Library Information > Contact Information tab. This is taken from the address configured as the Preferred address. The label in Alma is City. |
VARCHAR | 255 | |
| Library Code | The library code | Configuration > General > Libraries > Add a Library or Edit Library Information > Libraries tab > Path [the text after the period] | VARCHAR | 50 | |
| Library Code (Active) | The code of active (not deleted) libraries | Configuration > General > Libraries > Add a Library or Edit Library Information > Libraries tab > Path [the text after the period] | The same as Library Code without deleted libraries. | VARCHAR | 50 |
| Library Country | The country of the library. |
Configuration > General > Add a Library or Edit Library Information > Contact Information tab. This is taken from the address configured as the Preferred address. The label in Alma is Country. |
VARCHAR | 320 | |
| Library Description | The library description |
Configuration > General > Libraries > Add a Library or Edit Library Information > Libraries tab The label in Alma is Description. |
VARCHAR | 100 | |
| Library Name | The library name |
Configuration > General > Libraries > Add a Library or Edit Library Information > Libraries tab The label in Alma is Organization Unit Name. |
VARCHAR | 255 | |
| Library Name (Active) | The library name of active (not deleted) libraries |
Configuration > General > Libraries > Add a Library or Edit Library Information > Libraries tab The label in Alma is Organization Unit Name. |
The same as Library Name without deleted libraries. | VARCHAR | 255 |
| Library Postal Code | The postal code of the library. |
Configuration > General > Add a Library or Edit Library Information > Contact Information tab. This is taken from the address configured as the Preferred address. The label in Alma is Postal code. |
VARCHAR | 200 | |
| Library State Province | The state or province of the library. |
Configuration > General > Add a Library or Edit Library Information > Contact Information tab. This is taken from the address configured as the Preferred address. The label in Alma is State/Province. |
VARCHAR | 320 | |
| Unit Type | The type of organization unit |
Configuration > General > Libraries > Add a Library or Edit Library Information > Libraries tab The label in Alma is Organization Unit Type. |
Values can be Institution/Library | VARCHAR | 20 |
Modification Date
The Modification Date dimension is a dimension table that stores details about the modification date of the DARA recommendation.
| 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 Date Key | Stores the date in the format 2/29/2012 | |
| Modification Date Year-Month | The year and the month in a format such as 2023-1 | |
| 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. |
Modified By
Modified By is a dimension table that stores details relating to who modified the DARA recommendation.
| Field | Description | Additional Information |
|---|---|---|
| Birth Date | The birth date | |
| Campus Code | The campus code | |
| Cataloger Level | The cataloger level of the user | |
| Creation Date | The creation date | |
| Creator | The creator | |
| Expiry Date | The expiry date | |
| External ID | The external ID | |
| First Name | The first name | |
| Full Name | The full name | |
| Gender (Not in Use) | The gender | |
| 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 | |
| Identifier 1-2 | Identifiers 1-2 | |
| Is Blocked | Indicates if the patron is blocked | |
| Job Category | The job category | |
| Job Description | The job description | |
| Last Activity Date | The last date that a patron made a request or borrowed or returned an item | |
| Last Name | The last name | |
| User – Linked from Institution Code | The linked from institution code | |
| User – Linked from Institution Name | The linked from institution name | |
| User – Linked From Other Institution | Indicates if the user is linked from another institution | Possible values:
|
| Linked to Other Institution | Indicates if the user accessed Primo/Alma for services in another institution. Note that this does not necessarily indicate that the services were actually supplied or that a linked account was created. | Possible values:
|
| Middle Name | The middle name | |
| Modification Date | The modification date | |
| Modified By | The user that modified | |
| 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 | |
| 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. |
| Status | The status | |
| Status Date | The status date | |
| User Group | The user group | |
| 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 |
Status Date
The Status Date dimension is a dimension table that stores details about the status date of the DARA recommendation.
| Field | Description | Additional Information |
|---|---|---|
| Status Date | Stores the date in the format 2/29/2012 | |
| Status Date Start of Week | The date of the first business day of the week | |
| Status Date Week Number | The number of the week of the year | |
| Status Date 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 |
| Status Date Month | Stores the month of the date in month description format such as February | |
| Status Date Full Month | Stores the month and the year of the date in a display format such as Feb 12 | |
| Status Date Quarter | Stores the quarter of the date in a display format such as Q1 | |
| Status Date Year | Stores the year of the date in string format such as 2012 | |
| Status Date Fiscal Month Key | Stores the fiscal month of the date in number format such as 2 for February | |
| Status Date Fiscal Year | Stores the fiscal year of the date in string format such as 2012. | |
| Status Date Filter | Used to filter report results by date | |
| Status Date Date Key | Stores the date in the format 2/29/2012 | |
| Status Date Year-Month | The year and the month in a format such as 2023-1 | |
| Status 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. |
Institution
The shared Institution dimension allows the Network Zone to view reports according to institution. If an analytics report is run from the Network Zone in a collaborative network implementing a Network Zone, all member institutions are included in the report for Institution Code and Institution Name. If an analytics report is run from an institution that is not part of a collaborative network implementing a Network Zone, only the single institution from which the report is run is included in the report for Institution Code and Institution Name.
This dimension is available in every subject area. It contains the following fields:
| Field | Description | Additional Information | Data Type | Data Size |
|---|---|---|---|---|
| Institution Code | The code of the institution. |
Configured from: Configuration > General > Add a Library or Edit Library Information > Summary tab. The label in Alma is Code located on the right pane. |
VARCHAR | 50 |
| Institution Name | The name of the institution. |
Configured from: Configuration > General > Add a Library or Edit Library Information > Summary tab. The label in Alma is Organization unit name. |
VARCHAR | 255 |
| Institution Address Line 1 | The first line of the address of the institution. It usually includes the building number and the street name. |
Configured from: Configuration > General > Add a Library or Edit Library Information > Contact Information tab. This is taken from the address configured as the Preferred address. The label in Alma is Address Line 1. |
VARCHAR | 1000 |
| Institution City | The city of the institution. |
Configured from: Configuration > General > Add a Library or Edit Library Information > Contact Information tab. This is taken from the address configured as the Preferred address. The label in Alma is City. |
VARCHAR | 255 |
| Institution State Province | The state or province of the institution. |
Configured from: Configuration > General > Add a Library or Edit Library Information > Contact Information tab. This is taken from the address configured as the Preferred address. The label in Alma is State/Province. |
VARCHAR | 320 |
| Institution Country | The country of the institution. |
Configured from: Configuration > General > Add a Library or Edit Library Information > Contact Information tab. This is taken from the address configured as the Preferred address. The label in Alma is Country. |
VARCHAR | 320 |
| Institution Postal Code | The postal code of the institution. |
Configured from: Configuration > General > Add a Library or Edit Library Information > Contact Information tab. This is taken from the address configured as the Preferred address. The label in Alma is Postal code. |
VARCHAR | 200 |
| Institution Timezone | The timezone of the institution. | The timezone is set during implementation. | VARCHAR | 255 |
| Data Available As Of | When the institution data became available in analytics. | Displayed at the bottom of the main Analytics menu. | VARCHAR | 255 |
| Data Updated As Of | When the institution data was taken from the Alma database. | Displayed at the bottom of the main Analytics menu. | VARCHAR | 255 |
Page tags: article:topicproduct:almacontent:Documentationlang:english
