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.
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:
|
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:
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:
|
Y |
LEARNERSTATUS | VARCHAR(16777216) |
Permission Role |
The user’s permission-based role in your organization, as indicated on the Manage People page. Roles include:
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:
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:
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:
|
Y |
REALTIMEEMAILNOTIFICATION | VARCHAR(5) |
Daily Digest Email |
Indicates whether or not the user receives Daily Digest emails. Values include:
|
Y |
DAILYDIGESTEMAIL | VARCHAR(5) |
Weekly Digest Email |
Indicates whether or not the user receives Weekly Digest emails. Values include:
|
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 |
|