User (Summary) Report – Zendesk

Use the User (Summary) Report to view summary data about each user including status, permission role, first, last, and total daily logins, total points, and more.

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

Direct Data Connector table name: User_Summary_UserSummary

Column Name	Column Description	Enabled by Default	Direct Data Connector Field Name	Data Type
Employee ID	The unique user identifier for your Degreed site. This may be an email address or a different piece of employee information, such as an SSO username.	Y	EMPLOYEEID	VARCHAR(16777216)
User Name	The user’s full name.	Y	USERNAME	VARCHAR(16777216)
User First Name	The user’s given name.	Y	USERNFIRSTNAME	VARCHAR(16777216)
User Last Name	The user’s family name or surname.	Y	USERLASTNAME	VARCHAR(16777216)
User Email	The user’s work email address.	Y	USEREMAIL	VARCHAR(16777216)
User Status	Indicates the user's status within Degreed. Values include: Enabled Disabled	Y		STRING
Manager ID	The unique ID of the user's manager.	Y		STRING
Manager Name	The full name of the user's manager.	Y		STRING
Job Role	The user's Job Role	U		STRING
Learner Status	The learner's status. Values include: Active None Inside of Degreed, active learners are denoted with a multi-colored circle around their avatar. To be considered Active, users must meet all of the following requirements: Make 1 Share (or recommendation) Add 5 Completions Add 3 skills to their Profile Logged in during the last 30 days	Y	LEARNERSTATUS	VARCHAR(16777216)
Permission Role	The user’s permission-based role in your organization, as indicated on the Manage People page. Roles include: Technical Admin Admin Career Professional Learning Professional Manager Member See Setting Organizational Permissions for details about each role.	Y	PERMISSIONROLE	VARCHAR(16777216)
Profile Privacy	The user’s profile visibility, as chosen by the user on their Profile Settings page. Visibility options include: Public Organization Private to Organization For more information about each option, see Profile Visibility Options.	Y	PROFILEPRIVACY	VARCHAR(23)
User Created Date	The date the user was created.	Y		DATE
First Login	The date of the user’s first login on Degreed.	Y	FIRSTLOGIN	DATE
Last Login	The date of the user’s most recent login on Degreed as of the Report Date.	Y	LASTLOGIN	DATE
Total Daily Logins	The number of days on which the user has logged in at least once.	Y	TOTALDAILYLOGINS	NUMBER(18,0)
Total Points	The points earned for the following learning types: Events Courses Books Articles Videos Posts Tasks Assessments Experiences Points earned from Degrees, Skills, Accomplishments, Badges, Awards, and Certificates are not included in this field, as this report is meant to give you a snapshot as to how your users are using Degreed. These excluded categories include learning outside of Degreed and are outside of the scope of this report's intentions.	Y	TOTALPOINTS	FLOAT
Real-Time Email Notification	Indicates whether or not the user receives real-time email notifications. Values include: True False	Y	REALTIMEEMAILNOTIFICATION	VARCHAR(5)
Daily Digest Email	Indicates whether or not the user receives Daily Digest emails. Values include: True False	Y	DAILYDIGESTEMAIL	VARCHAR(5)
Weekly Digest Email	Indicates whether or not the user receives Weekly Digest emails. Values include: True False	Y	WEEKLYDIGESTEMAIL	VARCHAR(5)
User Topics	A list of skills the user selected on their Profile page.	Y	USERTOPICS	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.	N