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?
Star Diagram – DARA
Field Descriptions
The following lists the fields available in DARA
DARA – Field Descriptions
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 | 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 linked to another institution | |
| 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 for Analytics. |
| 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 |
|---|---|---|
| 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. | |
| Modification Date Filter | Used to filter report results by date | |
| Creation Date Year-Month | The year and the month in a format such as 2023-1 | |
| 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. |
Library Unit
The Library Unit table is a dimension table that stores details about the library where the PO Line was created.
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 | 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 linked to another institution | |
| 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 for Analytics. |
| 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. |