Assignments (Detailed by User) Report – Zendesk

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)
Assignee User Status	Indicates the user's status of the assignee within Degreed. Values include: Enabled Disabled	Y		STRING
Assignee Manager ID	The unique ID of the assignee's manager.	Y		STRING
Assignee Manager Name	The full name of the assignee's manager.	Y		STRING
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)
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
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