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)
Verified Learning Minutes	The actual learning time, as verified by the content provider, the user spent in the content.	Y		NUMBER
Estimated Learning Minutes	The estimated number of minutes needed to complete the content.	N		NUMBER