Assignments (Detailed by User) Report

Use the Assignments (Detailed by User) Report to monitor and track your users' assigned content, including when the content was assigned and is due, who assigned the content to the user, and the user's status towards completion.

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 Connect table name: Assignments_Details_AssignmentsByUser

Column Name	Column Description	Enabled by Default	Direct Data Connect 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)
Assignee Employee ID	The unique user identifier for the resource assignee. This may be an email address or a different piece of employee information, such as an SSO username.	Y	ASSIGNEEEMPLOYEEID	VARCHAR(16777216)
Assignee User Name	The full name of the assignee.	Y	ASSIGNEEUSERNAME	VARCHAR(16777216)
Assignee First Name	The first name of the assignee.	Y	ASSIGNEEFIRSTNAME	VARCHAR(16777216)
Assignee Last Name	The last name of the assignee.	Y	ASSIGNEELASTNAME	VARCHAR(16777216)
Assignee Email	The assignee's work email address.	Y	ASSIGNEEEMAIL	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)
Due Date	The date resource is due for completion.	Y	DUEDATE	DATE
Completed Date	The date the user completed the assignment.	Y	COMPLETEDDATE	DATE
Recommendation Type	Indicates if the course is assigned vs required.	Y	RECOMMENDATIONTYPE	VARCHAR(8)
Assignment Status	Indicates the user's completion status for the assignment. Possible values are: Pending Saved for Later Dismissed - The assignee has removed this assignment from their profile.  Completed	Y	ASSIGNMENTSTATUS	VARCHAR(15)
Duration in Minutes	The total estimated time to complete the content, listed in minutes such as 23 or 139.	Y	DURATIONINMINUTES	NUMBER(38,0)
Content URL	The online location of the item.	Y	CONTENTURL	VARCHAR(16777216)
Custom Attributes 1-50	If your organization uses custom attributes, the top 50 fields are displayed in individual columns at the end of the report and listed in order from oldest to newest. Only includes custom attributes for the Assignee.	N