Assignment (Summary by Assignment) Report
Use the Assignment (Summary by Assignment) Report to gather general information about content assignments throughout the organization including who assigned the resource, total number of users assigned the resource, and how many users completed the resource.
Permissions may be required to access some pages in Degreed or perform specific tasks. For more information, see Permissions in Degreed.
Required Permission: Manage In-App Reporting
This report includes a required date range column filter with a default date selected. We recommend modifying the dates to extend the date range to include additional data. See Filter an In-app Report for more information.
Direct Data Connector table name: Assignments_Details_AssignmentsByUser*
*The data for this report is extracted from the Assignments_Details_AssignmentsByUser table.
| Column Name | Column Description | Enabled by Default | Direct Data Connector Field Name | Data Type |
| Assigned Date |
The date the resource was assigned. This is the date range column located on the Filter dialog. This column is included in the report results. |
Required | ASSIGNEDDATE | DATE |
| Resource Title | The title of the assigned resource. | Y | RESOURCETITLE | VARCHAR(16777216) |
| Resource ID | The ID of the assigned resource. | Y | RESOURCEID | VARCHAR(16777216) |
| Resource Type | The resource item’s content type (article, video, etc). | Y | RESOURCETYPE | VARCHAR(16777216) |
| Assignor Employee ID | The unique user identifier for the assignor. This may be an email address or a different piece of employee information, such as an SSO username. | Y | ASSIGNEREMPLOYEEID | VARCHAR(16777216) |
| Assignor User Name | The full name of the assignor. | Y | ASSIGNERUSERNAME | VARCHAR(16777216) |
| Assignor First Name | The first name of the assignor. | Y | ASSIGNERFIRSTNAME | VARCHAR(16777216) |
| Assignor Last Name | The last name of the assignor. | Y | ASSIGNERLASTNAME | VARCHAR(16777216) |
| Assignor Email | The assignor's work email address. | Y | ASSIGNEREMAIL | VARCHAR(16777216) |
| Total Assignments |
Total number of users who are assigned this resource. Users who have removed the assignment are still included in this total.
|
Y | Add sum or count (*) to your query. | |
| Assignments Completed | Total number of users who completed the assignment. | Y | ASSIGNMENTISCOMPLETED | NUMBER(1,0) |
| Duration in Minutes | The total estimated time to complete the content, listed in minutes such as 23 or 139. | Y | DURATIONINMINUTES | NUMBER(38,0) |