Direct Data Connector Tables

This article provides a comprehensive reference for all the tables (models) available through the Direct Data Connector (DDC), including detailed information about each table's structure, column details, and data lineage. 

• Table Names: A comprehensive list of all tables created through the DDC.
• Column Description: Descriptions of each column in the tables, including data types and any relevant business logic or transformations.
• Lineage: The lineage of each table, showing its dependencies, sources, and relationships with other tables in the DDC ecosystem. Click the image to open it in a new tab and zoom in.

• Content Tables
• Skills Tables
• User Tables
• Opportunities Tables

Content Tables

Table Name	Table Description
CONTENT_DETAILS_CONTENTCATALOG	Data of your organization's internal and external content including Provider information, content type, duration, Pathways and Plans that contain the content, and more.
CONTENT_SUMMARY_CONTENTVIEW	Summary data about content viewed including content type, title, and browser information.
CONTENT_SUMMARY_COMPLETIONSSUMMARYBYUSER	Data about a user’s total completions across all content types, including the latest completion date, the number of items completed, and the total completion points earned.
CONTENT_DETAILS_COMPLETIONSBYUSER	Data about users' completions, including the completion date, information on verification, completion rating, and completion points earned.
CONTENT_DETAILS_PUBLISHEDPATHWAYSDETAILED	Data on content within published Pathways including section and lesson information.
CONTENT_SUMMARY_PATHWAYSUMMARYBYPATHWAY	Data about all Pathways owned by your organization.
CONTENT_SUMMARY_PATHWAYSUMMARYBYUSER	Data about each user following, assigned, or who've previously followed, a Pathway owned by your organization.
CONTENT_DETAILS_PATHWAYDETAILBYUSER	Data about users following or assigned a Pathway, and who've completed content within the Pathway.
CONTENT_SUMMARY_PLANSUMMARYBYPLAN	Data about all Plans owned by your organization.
CONTENT_SUMMARY_PLANSUMMARYBYUSER	Data about each user following or assigned a Plan owned by your organization.
CONTENT_DETAILS_PLANDETAILBYUSER	Data about users who've completed a resource within a Plan, or added a skill to a Plan.
CONTENT_SUMMARY_SEARCHSUMMARY	Data on search terms and the number of times the term was used.
CONTENT_DETAILS_SHAREDDETAILED	Data about shared items, including who shared the item and who was the recipient.
ASSIGNMENTS_DETAILS_ASSIGNMENTSBYUSER	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.

Back to Top

Skills Tables

Table Name	Table Description
SKILLS_SUMMARY_SKILLSUMMARYBYSKILL	Data on the skills your users are following, including the total number of users following a skill, the total number of users who have ratings for the skill, and averages for each rating type for the skill.
SKILLS_DETAILS_SKILLSBYUSER	Data about each rated skill for each user including the skill type, the date the user followed the skill, and the skill ratings.
SKILLS_SUMMARY_SKILLCOACHOVERALL	Data on Skill Coach managers and a summary of aggregated manager activity in the feature.
SKILLS_SUMMARY_SKILLCOACHSUMMARYBYMANAGER	Data on Skill Coach managers and a summary of aggregated manager activity in the feature.
SKILLS_DETAILS_SKILLCOACHDETAILEDBYMANAGER	Data about manager activity in Skill Coach.

Back to Top

User Tables

Table Name	Table Description
USER_SUMMARY_USERSUMMARY	Data about each user including status, permission role, first, last, and total daily logins, total points, and more.
USER_DETAILS_USERGROUPS	About users within groups including employee ID, user email, date joined, and group role.
USER_SUMMARY_LOGINS	User login summary data.
USER_DETAILS_FOLLOWERSDETAILED	Data about the followers and the users being followed.

Back to Top

Opportunities Tables

Table Name	Table Description
OPPORTUNITIES_SUMMARY_PUBLISHEDOPPORTUNITIESSUMMARY	Data on opportunities including description and number of interested, matched and selected candidates.
OPPORTUNITIES_DETAILS_ACTIVEOPPORTUNITIESDETAILED	Data on applicants for active opportunities.
OPPORTUNITIES_DETAILS_OPPORTUNITIESINTERESTEDACTIVITYDETAILED	Data on opportunity interest for both the user and the opportunity.
OPPORTUNITIES_DETAILS_SHAREDOPPORTUNITIESDETAILED	Data on shared opportunities including both the users sharing the opportunity and the users the opportunity was shared with.
OPPORTUNITIES_SUMMARY_OPPORTUNITIESVIEWDATASUMMARY	Data on the number of views per access type, for each opportunity.
OPPORTUNITIES_DETAILS_MENTORINGDETAIL	Data on mentees and mentors and the current status of mentorship.

Back to Top

CONTENT_DETAILS_CONTENTCATALOG

Direct Data Connector Field Name	Column Description	Data Type
TITLE	The name of the content item.	VARCHAR(16777216)
CONTENTTYPE	The type of content such as course or video.	VARCHAR(16777216)
INTERNALID	The unique identifier for the content item, as set by your organization.	VARCHAR(16777216)
SUMMARY	The description of the content item that displays on the content card in Degreed.	VARCHAR(16777216)
URL	The online location of the item.	VARCHAR(16777216)
PROVIDER	The name of the Content Provider.	VARCHAR(16777216)
INTERNALEXTERNALCONTENT	Indicates if the content is Internal or External. For the purposes of this report, External content refers to Provider content that is managed by your organization. This does not include one-click provider or free content. Internal content is all other content managed by your organization.	VARCHAR(8)
DURATIONINMINUTES	The expected length of time, converted to minutes, it takes a learner to complete the content.	NUMBER(38,0)
DURATIONUNITNAME	The unit used to measure the duration. If the field is populated, the value is converted to Minutes.	VARCHAR(16777216)
DURATIONUNITS	This is a legacy field and not enabled by default. If enabled, the numeric values in this column vary based on the content type: Video = number of seconds Course = number of hours Article = number of words Book = number of pages Podcast = number of minutes (if you do not include a value for a Podcast, the duration defaults to 5 minutes)	FLOAT
THUMBNAILURL	The online location of the thumbnail image used for this item's content card in Degreed.	VARCHAR(16777216)
THUMBSUP	The number of users who completed this content and clicked Like. Users whose Profile is set to Private are not counted in the value displayed in the Degreed app. However, they are counted in reports.	NUMBER(13,0)
THUMBSDOWN	The number of users who completed this content and clicked Dislike. Users whose Profile is set to Private are not counted in the value displayed in the Degreed app. However, they are counted in reports.	NUMBER(13,0)
LANGUAGE	The language of the content item. Acceptable values include: two character ISO 639-1 codes (for example, en) regionalized locales for ISO 639-2 (for example, en-ca)	VARCHAR(16777216)
CONTENTID	The unique ID used by Degreed to identify the content.	VARCHAR(16777216)
PLANS	A list of Plans the content is added to.	VARCHAR(16777216)
PATHWAYS	A list of Pathways the content is added to.	VARCHAR(16777216)
SKILLS	Skills associated with the content.	VARCHAR(16777216)
CONTENTOWNER	The name of the Content Owner.	VARCHAR(16777216)
CREATEDBYEMPLOYEEID	The ID of the user who created the content item.	VARCHAR(16777216)
CREATEDBYNAME	The full name of the user who created the content item.	VARCHAR(16777216)
CREATEDBYFIRSTNAME	The First Name of the user who created the content item.	VARCHAR(16777216)
CREATEDBYLASTNAME	The Last Name of the user who created the content item.	VARCHAR(16777216)
CREATEDBYEMAIL	The email of the user who created the content item.	VARCHAR(16777216)
CONTENTCREATEDDATE	The date the content item was published.	DATE
CATEGORY1 - CATEGORY15	Each Category field contains a single Skill associated to the content item. Acceptable values include: Skill Names (for both existing and new skills) NULL This report displays up to 15 Skills for each content item.	VARCHAR(16777216)
GROUP1 - GROUP15	Each of the these fields contains a single Group to which the content item is targeted, or, for restricted content visible only to Administrative Groups, a Group that can view the content. This report displays up to 15 Groups for each content item.	VARCHAR(16777216)

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

CONTENT_SUMMARY_CONTENTVIEW

Direct Data Connector Field Name	Field Description	Data Type
VIEWEDDATE	The date the item was viewed.  This is the date range column located on the Filter dialog.  The column is not included in the report results.	DATE
CONTENTID	The ID of the content item.	VARCHAR(16777216)
CONTENTTYPE	The type of content.	VARCHAR(16777216)
CONTENTTITLE	The title of the content item.	VARCHAR(16777216)
CONTENTURL	The online location of that item.	VARCHAR(16777216)
PROVIDERNAME	The location of the content item such as Internal (catalog), an external website, or a content provider such as Pluralsight.	VARCHAR(16777216)
ViewCountDesktop	The number of times users viewed the content item from a desktop web browser.	NUMBER(13,0)
ViewCountIosBrowser	The number of times users viewed the content item from a browser on their iOS mobile device.	NUMBER(13,0)
ViewCountAndroidBrowser	The number of times users viewed the content item from a browser on their Android mobile device.	NUMBER(13,0)
VIEWCOUNTIOSAPP	The number of times users viewed the content item from the Degreed Mobile App for iOS.	NUMBER(13,0)
VIEWCOUNTANDROIDAPP	The number of times users viewed the content item from the Degreed Mobile App for Android.	NUMBER(13,0)
DURATIONINMINUTES	The total estimated time to complete the content, listed in minutes such as 23 or 139.	NUMBER(38,0)

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

CONTENT_SUMMARY_COMPLETIONSSUMMARYBYUSER

Direct Data Connector Field Name	Column Description	Data Type
COMPLETIONCOMPLETEDDATE	The latest date a user completed any content item, within the report's date range. This is the date range column located on the Filter dialog.  The column is not included in the report results.	DATE
EMPLOYEEID	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.	VARCHAR(16777216)
USERNAME	The user's full name.	VARCHAR(16777216)
USERFIRSTNAME	The user's first name.	VARCHAR(16777216)
USERLASTNAME	The user's last name.	VARCHAR(16777216)
USEREMAIL	The user’s work email address.	VARCHAR(16777216)
USERSTATUS	Indicates the user's status within Degreed.  Values include: Enabled Disabled	STRING
COMPLETIONPOINTS	The total number of points the user earned during the report's time period.	NUMBER(15,2)
VERIFIEDLEARNINGMINUTES	The actual learning time, as verified by the content provider, the user spent in the content.	NUMBER
ESTIMATEDLEARNINGMINUTES	The estimated number of minutes needed to complete the content.	NUMBER

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

CONTENT_DETAILS_COMPLETIONSBYUSER

Direct Data Connector Field Name	Column Description	Data Type
COMPLETIONCOMPLETEDDATE	The date the user marked the item complete, or edited the completion date for the item in their collection.	DATE
DATEADDED	The date the user marked the item complete.	DATE
EMPLOYEEID	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.	VARCHAR(16777216)
USERNAME	The user's full name.	VARCHAR(16777216)
USERFIRSTNAME	The user's first name.	VARCHAR(16777216)
USERLASTNAME	The user's last name.	VARCHAR(16777216)
USEREMAIL	The user’s work email address.	VARCHAR(16777216)
CONTENTID	The unique ID for the content item, as set by your organization.	VARCHAR(16777216)
CONTENTTITLE	The title of the completed content item.	VARCHAR(16777216)
CONTENTTYPE	The item’s content type (article, video, etc).	VARCHAR(16777216)
PROVIDER	The provider hosting the content.	VARCHAR(16777216)
COMPLETIONISVERIFIED	Some content completions may be verified by a third party (such as your organization's LMS). Values include: Y: The content completion was verified by the third party, and a green check with the word VERIFIED displays to the learner on the content card in Degreed. N: The content completion is not verified, or verification status is unknown.	VARCHAR(1)
COMPLETIONUSERRATING	The rating (like or dislike), if any, given to the content item by the user.	VARCHAR(16777216)
COMPLETIONPOINTS	The number of points Degreed awarded for completing this item.	NUMBER(15,2)
CONTENTURL	The online location of the item.	VARCHAR(16777216)
VERIFIEDLEARNINGMINUTES	The actual learning time, as verified by the content provider, the user spent in the content.	NUMBER
DURATIONINMINUTES	The estimated number of minutes needed to complete the content.	NUMBER
InternalvsExternalCatalog	External: A catalog of content curated by Degreed.  Internal: A catalog that includes content curated by your organization, and content added to your degreed site by your users.	VARCHAR(16777216)
TOPICS	A pipe-delimited list of skills associated with this content item (for example, Consulting|Integration|Sales). Skills in this field are not related to any skills listed on the user's Profile.	VARCHAR(16777216)
Source	How the user accessed the completed item.  Values include: Desktop Android browser Android app iOS browser iOS app Integrations	VARCHAR(16777216)

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

CONTENT_DETAILS_PUBLISHEDPATHWAYSDETAILED

Direct Data Connector Field Name	Column Description	Data Type
PathwayTitle	The title of the Pathway	TEXT
SectionNumber	A number that denotes the section's sequence in the Pathway. Values include: Numbers: 1, 2, 3, 4, etc. Blank: If blank, the item is not a Pathway section.	NUMBER
SectionTitle	The name of the section.	TEXT
SectionDescription	The description of the section within the Pathway.	TEXT
LessonNumber	A number that denotes the subsection's sequence in the Pathway. Values include: Numbers: 1, 2, 3, 4, etc. Blank: If blank, the item is not a Pathway section.	NUMBER
LessonTitle	The name of the subsection.	TEXT
LessonDescription	The description of the subsection within the Pathway.	TEXT
StepNumber	A number that denotes the content item's sequence in the section or subsection. If the content item is outside of a section or subsection, then this number denotes the content item's sequence within the Pathway. Values include: Numbers: 1, 2, 3, 4, etc. Blank: If blank, the item is not a content item (for example, it could be a title or description).	NUMBER
ContentTitle	The name of the content item.	TEXT
ContentDescription	The description of the content item as it displays on the content card in Degreed.	TEXT
ContentType	The type of content.	TEXT
EstimatedLearningMinutes	The estimated number of minutes needed to complete the content.	NUMBER
ContentDuration	A numeric value that designates the time required to consume the content item. The units represented by this value differ for each content duration type, as in the next column.	NUMBER
ContentDurationType	The unit of measurement for this item's duration. The units represented by this value differ for each content type: Video: number of minutes Course: number of hours Article: number of words Book: number of pages Podcast: number of minutes	TEXT
AdditionalLearning	Additional content items added to the Pathway. Items marked as Optional do not count towards the Pathway completion percentages. Values include: Yes: The content is marked as Optional and does not count toward Pathway completion. No: The content is not marked as Optional, and does count towards Pathway completion.	TEXT
ContentId	The unique ID for the content item.	TEXT
PathwayId	The unique ID for the Pathway, as set by your organization.	TEXT

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

CONTENT_SUMMARY_PATHWAYSUMMARYBYPATHWAY

Direct Data Connector Field Name	Column Description	Data Type
PATHWAYTITLE	The title of the Pathway	VARCHAR(16777216)
PATHWAYID	The unique ID for the Pathway, as set by your organization.	VARCHAR(16777216)
PATHWAYTYPE	Indicates the type of pathway as defined by the catalog where the content in the pathway resides. Values include: External: A catalog of content curated by Degreed Internal: A catalog that includes content curated by your organization, and content added to your Degreed site by your users	VARCHAR(16777216)
PATHWAYCONTENTCOUNT	The total number of content items in the Pathway.	NUMBER(18,0)
PATHWAYREQUIREDCONTENTCOUNT	The total number of content items that are required in order to complete the Pathway.	NUMBER(18,0)
PATHWAYUSERCOUNT	The total number of combined users assigned to or following the Pathway.	NUMBER(18,0)
COMPLETEDCOUNT	The total number of users active in the pathway that have completed 100% of required content within the Pathway.	NUMBER(18,0)
ENDORSED	Indicates if the Pathway is endorsed. Values include: Y (Yes) N (No)	VARCHAR(3)
PathwayVisibility	The Pathway's visibility setting. Values include: Profile Visible: The Pathway's visibility setting is set to My Profile (visible). Visible to Specific Groups Visible to Organization	VARCHAR(16777216)
CreatedBy	The full name of the user who created the Pathway	VARCHAR(16777216)
PathwayCreatedDate	The date this Pathway was created.	Date
LastUpdatedDate	The date the Pathway was last updated.	Date
Collaborators	The full names of each user listed as a collaborator on this Pathway.	VARCHAR(16777216)
PathwayTopic	Skills associated to the Pathway.	VARCHAR(16777216)
PathwayDescription	The description of the Pathway.	VARCHAR(16777216)
PathwayUrl	The URL of the Pathway.	STRING

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

CONTENT_SUMMARY_PATHWAYSUMMARYBYUSER

Direct Data Connector Field Name	Column Description	Data Type
PATHWAYTITLE	The title of the Pathway.	VARCHAR(16777216)
PATHWAYID	The unique ID for the Pathway, as set by your organization.	VARCHAR(16777216)
PATHWAYTYPE	Indicates the type of pathway as defined by the catalog where the content in the pathway resides. Values include: External: A catalog of content curated by Degreed Internal: A catalog that includes content curated by your organization, and content added to your Degreed site by your users	VARCHAR(16777216)
EMPLOYEEID	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.	VARCHAR(16777216)
USERNAME	The user's full name.	VARCHAR(16777216)
USERFIRSTNAME	The user's first name.	VARCHAR(16777216)
USERLASTNAME	The user's last name.	VARCHAR(16777216)
USEREMAIL	The user’s work email address.	VARCHAR(16777216)
PATHWAYPROGRESS	The percentage of items completed based on the "Number of Completed Required Content" for the specific user.	VARCHAR(16777216)
TOTALPATHWAYCONTENT	The total number of content items in this Pathway.	NUMBER(18,0)
TOTALREQUIREDPATHWAYCONTENT	The total number of required content items. This value is Pathway specific and not based on user specific data.	NUMBER(18,0)
COMPLETEDCONTENT	The number of items, both required and optional, the user completed.	NUMBER(18,0)
COMPLETEDREQUIREDCONTENT	The number of required items the user completed.	NUMBER(18,0)
FollowDate	The date the user followed this Pathway.	DATE
LatestCompletionDate	The latest date a user completed any content item in the Pathway.	DATE
VerifiedLearningMinutes	The actual learning time, as verified by the content provider, the user spent in the content.	NUMBER
EstimatedLearningMinutes	The estimated number of minutes needed to complete the content.	NUMBER

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

CONTENT_DETAILS_PATHWAYDETAILBYUSER

Direct Data Connector Field Name	Column Description	Data Type
COMPLETIONCREATEDDATE	The date the user completed the content item. This is the date range column located on the Filter dialog.  The column is included in the report results.	DATE
EMPLOYEEID	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.	VARCHAR(16777216)
FullName	The user's full name.	VARCHAR(16777216)
UserFirstName	The user's first name.	VARCHAR(16777216)
UserLastName	The user's last name.	VARCHAR(16777216)
UserEmail	The user’s work email address.	VARCHAR(16777216)
PathwayTitle	The title of the Pathway.	VARCHAR(16777216)
PATHWAYID	The unique ID for the Pathway, as set by your organization.	VARCHAR(16777216)
CONTENTTITLE	The title of the content item.	VARCHAR(16777216)
CONTENTID	The unique ID for the content item, as set by your organization.	VARCHAR(16777216)
CONTENTTYPE	The item’s content type (article, video, etc).	VARCHAR(16777216)
ISREQUIRED	Indicates if the content item is required for the user. Values include: True False	BOOLEAN
CONTENTURL	The online location of the content item.	VARCHAR(16777216)
DURATIONINMINUTES	The estimated number of minutes needed to complete the content.	NUMBER
VERIFIEDLEARNINGMINUTES	The actual learning time, as verified by the content provider, the user spent in the content.	NUMBER
ESTIMATEDLEARNINGMINUTES	The estimated number of minutes needed to complete the content.	NUMBER

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

CONTENT_SUMMARY_PLANSUMMARYBYPLAN

Direct Data Connector Field Name	Column Description	Data Type
PLANTITLE	The title of the Plan	VARCHAR(16777216)
PLANID	The unique ID for the Plan, as set by your organization.	VARCHAR(16777216)
PLANTYPE	Indicates the type of Plan Values include: Skill Role	VARCHAR(10)
ENDORSED	Indicates if the Plan is endorsed by your organization or a learning professional within your organization.	VARCHAR(3)
TOTALUSERSACTIVE	The total number of unique users who are assigned or following the Plan.	NUMBER(18,0)
USERSCOMPLETINGCONTENT	The total number of unique users who've completed one or more content items from within the Plan.	NUMBER(18,0)
USERSFOLLOWINGPLANS	The total number of unique users following one or more Plans within the Plan.	NUMBER(18,0)
USERSFOLLOWINGPATHWAYS	The total number of unique users following one or more Pathways within the Plan.	NUMBER(18,0)
USERSCOMPLETINGPATHWAYS	The total number of unique users who've completed one or more Pathways within the Plan.	NUMBER(18,0)
USERSADDINGSKILLS	The total number of unique users who've added one or more skills to the Plan.	NUMBER(18,0)
USERSRATINGSKILLS	The total number of unique users who've rated one or more skills within the Plan.	NUMBER
PLANURL	The URL of the Plan.	STRING

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

CONTENT_SUMMARY_PLANSUMMARYBYUSER

Direct Data Connector Field Name	Column Description	Data Type
PLANTITLE	The title of the Plan.	VARCHAR(16777216)
PLANID	The unique ID for the Plan, as set by your organization.	VARCHAR(16777216)
PLANTYPE	Indicates the type of Plan Values include: Skill Role	VARCHAR(10)
EMPLOYEEID	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.	VARCHAR(16777216)
USERNAME	The user's full name.	VARCHAR(16777216)
USERFIRSTNAME	The user's first name.	VARCHAR(16777216)
USERLASTNAME	The user's last name.	VARCHAR(16777216)
USEREMAIL	The user’s work email address.	VARCHAR(16777216)
ContentCompleted	The total number of content items in the Plan the user completed.	NUMBER(18,0)
PlansFollowed	The total number of Plans within the Plan the user is following.	NUMBER(18,0)
PathwaysFollowedAssigned	The total number of Pathways in the Plan assigned to the user, or that the user is currently following.	NUMBER(18,0)
PathwaysCompleted	The total number of Pathways in the Plan the user completed.	NUMBER(13,0)
SkillsAdded	The total number of skills added by the user from within the Plan.	NUMBER(13,0)
SkillsRated	The total number of skills rated by the user from within the Plan.	NUMBER(13,0)
FollowDate	The date the user followed this Plan.	DATE
LastResourceCompletedOrSkillAddDate	The last date the user either completed an item within the Plan, or added a skill to the Plan.	DATE
VERIFIEDLEARNINGMINUTES	The actual learning time, as verified by the content provider, the user spent in the content.	NUMBER
ESTIMATEDLEARNINGMINUTES	The estimated number of minutes needed to complete the content.	NUMBER

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

CONTENT_DETAILS_PLANDETAILBYUSER

Direct Data Connector Field Name	Column Description	Data Type
LastResourceCompletedOrSkillAddDate	The last date the user either completed an item within the Plan, or added a skill to the Plan. This is the date range column located on the Filter dialog.  The column is included in the report results.	DATE
EMPLOYEEID	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.	VARCHAR(16777216)
USERNAME	The user's full name.	VARCHAR(16777216)
USERFIRSTNAME	The user's first name.	VARCHAR(16777216)
USERLASTNAME	The user's last name.	VARCHAR(16777216)
USEREMAIL	The user’s work email address.	VARCHAR(16777216)
PLANTITLE	The title of the Plan.	VARCHAR(16777216)
PLANID	The unique ID for the Plan, as set by your organization.	VARCHAR(16777216)
PLANTYPE	The type of Plan. Possible values include: Skill Plan Role Plan	VARCHAR(10)
RESOURCETITLE	The title of this specific resource.	VARCHAR(16777216)
RESOURCEID	The ID of this specific resource. This field is blank if the resource type is Skill.	VARCHAR(16777216)
RESOURCETYPE	The type of resource. Values can include a skill, or any content type including a Pathway.	VARCHAR(16777216)
RESOURCEURL	The online location of the content item. This field is blank if the resource type is Skill or Pathway.	VARCHAR(16777216)
PATHWAYPROGRESS	If the resource type is Pathway, indicates the completion percentage for the user for the Pathway.	VARCHAR(16777216)
TARGETLEVEL	Indicates the target level for a skill. This field is blank if the resource is not a skill, or the skill has no target level.	NUMBER(38,0)
SKILLLEVELAVERAGE	If the resource is a skill, indicates the average rating for that skill.	FLOAT
VERIFIEDLEARNINGMINUTES	The actual learning time, as verified by the content provider, the user spent in the content.	NUMBER
ESTIMATEDLEARNINGMINUTES	The estimated number of minutes needed to complete the content.	NUMBER

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

CONTENT_SUMMARY_SEARCHSUMMARY

Direct Data Connector Field Name	Column Description	Data Type
DateSearched	The date the search was performed.  This is the date range column located on the Filter dialog.  The column is not included in the report results. For Direct Data Connector, add this field to your query and provide dates.	DATE
SearchTerm	The word or phrase two or more users entered into the search bar.	VARCHAR(16777216)

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

CONTENT_DETAILS_SHAREDDETAILED

Direct Data Connector Field Name	Column Description	Data Type
DATERECOMMENDED	The date the content was shared. This is the date range column located on the Filter dialog.  The column is included in the report results.	DATE
SharedbyEmployeeId	The ID of the employee who shared the content.	VARCHAR(16777216)
SharedByUserName	The user name of the user who shared the content.	VARCHAR(16777216)
SharedByUserFirstName	The first name of the user who shared the content.	VARCHAR(16777216)
SharedByUserLastName	The last name of the user who shared the content.	VARCHAR(16777216)
SharedByEmail	The email of the user who shared the content.	VARCHAR(16777216)
RECIPIENTGROUPNAME	The ID of the employee with whom the content was shared.	VARCHAR(16777216)
RecipientEmployeeId	The unique ID that your Degreed site uses for the user who received the shared content item. This may be an email address or a different piece of employee information, such as an SSO username.	VARCHAR(16777216)
RecipientUserNAme	The user name of the employee with whom the content was shared.	VARCHAR(16777216)
RecipientUserFirstName	The first name of the employee with whom the content was shared.	VARCHAR(16777216)
RecipientUserLastName	The last name of the employee with whom the content was shared.	VARCHAR(16777216)
RecipientEmail	The email of the employee with whom the content was shared.	VARCHAR(16777216)
PATHWAYS	If the item is included in any Pathways, this column lists the Pathway title(s) up to 20k characters.	VARCHAR(16777216)
CONTENTTITLE	The title of the shared content item.	VARCHAR(16777216)
CONTENTURL	The online location of that item.	VARCHAR(16777216)
CONTENTTYPE	The type of content shared.	VARCHAR(16777216)
INTERNALVSEXTERNALCONTENT	The catalog where the content resides. Possible values include: External: A catalog of content curated by Degreed. Internal: A catalog that includes content curated by your organization, and content added to your Degreed site by your users.	VARCHAR(16777216)
CONTENTPROVIDER	The provider hosting the content.	VARCHAR(16777216)
STATUS	The status of the shared item. Possible values include: Pending: The content item has not yet been marked as complete by the recipient Completed: The content item was marked as complete by the recipient	VARCHAR(15)
STATUSCHANGEDATE	The date that the status changed to its current state.	DATE

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

ASSIGNMENTS_DETAILS_ASSIGNMENTSBYUSER

Direct Data Connect Field Name	Column Description	Data Type
ASSIGNEDDATE	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.	DATE
RESOURCETITLE	The title of the assigned resource.	VARCHAR(16777216)
RESOURCEID	The ID of the assigned resource.	VARCHAR(16777216)
RESOURCETYPE	The resource item’s content type (article, video, etc).	VARCHAR(16777216)
ASSIGNEEEMPLOYEEID	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.	VARCHAR(16777216)
ASSIGNEEUSERNAME	The full name of the assignee.	VARCHAR(16777216)
ASSIGNEEFIRSTNAME	The first name of the assignee.	VARCHAR(16777216)
ASSIGNEELASTNAME	The last name of the assignee.	VARCHAR(16777216)
ASSIGNEEEMAIL	The assignee's work email address.	VARCHAR(16777216)
ASSIGNEREMPLOYEEID	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.	VARCHAR(16777216)
ASSIGNERUSERNAME	The full name of the assignor.	VARCHAR(16777216)
ASSIGNERFIRSTNAME	The first name of the assignor.	VARCHAR(16777216)
ASSIGNERLASTNAME	The last name of the assignor.	VARCHAR(16777216)
ASSIGNEREMAIL	The assignor's work email address.	VARCHAR(16777216)
DUEDATE	The date resource is due for completion.	DATE
COMPLETEDDATE	The date the user completed the assignment.	DATE
RECOMMENDATIONTYPE	Indicates if the course is assigned vs required.	VARCHAR(8)
ASSIGNMENTSTATUS	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	VARCHAR(15)
VERIFIEDLEARNINGMINUTES	The actual learning time, as verified by the content provider, the user spent in the content.	NUMBER
ESTIMATEDLEARNINGMINUTES	The estimated number of minutes needed to complete the content.	NUMBER
CONTENTURL	The online location of the item.	VARCHAR(16777216)

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

SKILLS_SUMMARY_SKILLSUMMARYBYSKILL

Direct Data Connect Field Name	Column Description	Data Type
SKILLFOLLOWEDDATE	The date the skill was followed by the user. This is the date range column located on the Filter dialog.  The column is not included in the report results.	DATE
SkillName	The name of the skill.	TEXT
EmployeId	The ID of the employee.	TEXT
UserName	The user's full name.	TEXT
UserFirstName	The user's first name.	TEXT
UserLastName	The user's last name.	TEXT
UserEmail	The email of the user.	TEXT
SkillRatingType	The type of the skill rating.	TEXT
SkillRating	The rating of the skill.	TEXT
InternalSelfRatings	The number of self ratings.	NUMBER
InternalManagerRatings	The number of manager ratings.	NUMBER
InternalSkillReviews	The number of skill reviews.	NUMBER
SkillRatedDate	The date and time the skill was rated.	DATE
SkillsIsFocused	Indicates if the user has the skill set as a Focus Skill.  Values include: Y: Yes N: No, or unknown.	TEXT
SkillFocusedDate	The date the user set the skill as a Focus Skill.	DATE

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

SKILLS_DETAILS_SKILLSBYUSER

Direct Data Connector Field Name	Column Description	Data Type
SKILLFOLLOWEDDATE	The date the user followed the skill, or added it to the profile.	DATE
EMPLOYEEID	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.	VARCHAR(16777216)
USERNAME	The user's full name.	VARCHAR(16777216)
USERFIRSTNAME	The user's first name.	VARCHAR(16777216)
USERLASTNAME	The user's last name.	VARCHAR(16777216)
USEREMAIL	The user’s work email address.	VARCHAR(16777216)
SKILLNAME	The name of the skill the user is following.	VARCHAR(16777216)
SKILLRATINGTYPE	The type of rating for the skill, if any. Values can include Self Rating Manager Rating Skill Review Skill Certification Target Rating Peer Rating	VARCHAR(16777216)
SKILLRATING	The skill rating level.	VARCHAR(16777216)
SKILLRATEDDATETIME	The date the skill was rated. This is the date range column located on the Filter dialog.  The column is included in the report results.	TIMESTAMP_NTZ(9)
SKILLISFOCUSED	Indicates if the user has the skill set as a Focus Skill.  Values include: Y: Yes N: No, or unknown.	VARCHAR(1)
SKILLFOCUSEDDATE	The date the user set the skill as a Focus Skill.	DATE
SKILLRATINGPRIVACY	Indicates the privacy setting for the skill rating is Private or Public.	VARCHAR(7)

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

SKILLS_SUMMARY_SKILLCOACHOVERALL

Direct Data Connector Field Name	Column Description	Data Type
MANAGERCOUNT	Number of managers enabled with Skill Coach.	NUMBER(18,0)
TEAMCOUNT	Average number of users reporting to a manager.	NUMBER(37,0)
AVERAGEOPTOUTCOUNT	Average number of users opting-out, per team.	NUMBER(32,0)
TOTALMANAGERRATINGADDED	Total Manager Ratings added in Skill Coach.	NUMBER(38,0)
AVERAGETOTALMANAGERRATINGSADDED	Average number of Manager Ratings in Skill coach per manager.	NUMBER(38,0)
TotalTargetSkillAdded	Total number of Skill Targets added in Skill Coach.	NUMBER(38,0)
AVERAGETARGETSKILLADDED	Average number of Skill Targets added in Skill Coach per manager.	NUMBER(38,0)
TOTALTEAMFOCUSSKILLS	Total number of Focus Skills added in Skill Coach.	NUMBER(30,0)
AVERAGETEAMFOCUSSKILL	Average number of Focus Skills added in Skill Coach per manager.	NUMBER(37,0)

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

SKILLS_SUMMARY_SKILLCOACHSUMMARYBYMANAGER

Direct Data Connector Field Name	Column Description	Data Type
MANAGERID	The manager's ID.	VARCHAR(16777216)
MANAGERNAME	The manager's name.	VARCHAR(16777216)
MANAGERFIRSTNAME	The manager's first name.	VARCHAR(16777216)
MANAGERLASTNAME	The manager's last name.	VARCHAR(16777216)
MANAGEREMAIL	The manager's email address.	VARCHAR(16777216)
TEAMSIZE	Total number of team members reporting to this manager.	NUMBER(18,0)
OPTOUTCOUNT	Total number of team members who opted out.	NUMBER(13,0)
TOTALMANAGERRATINGADDED	Total number of ratings added by this manager.	NUMBER(30,0)
AVERAGEMANAGERRATING	The average rating given by this manager.	FLOAT
TOTALSELFRATINGADDED	The total number of self ratings added by this manager's team members.	NUMBER(30,0)
AVERAGESELFRATING	The average self rating made by this manager's team members.	FLOAT
TOTALTARGETSKILLADDED	The total number of Skill Targets added in Skill Coach	NUMBER(30,0)
AVERAGESKILLTARGETRATING	The average rating of Skill Targets added by this manager.	FLOAT
TOTALTEAMFOCUSSKILLS	The total number of Focus Skills for the team.	NUMBER(18,0)
TEAMFOCUSSKILLLIST	List of each Focus Skill for the team.	VARCHAR(16777216)

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

SKILLS_DETAILS_SKILLCOACHDETAILEDBYMANAGER

Direct Data Connector Field Name	Column Description	Data Type
MANAGERID	The manager's ID.	VARCHAR(16777216)
MANAGERNAME	The manager's name.	VARCHAR(16777216)
MANAGERFIRSTNAME	The manager's first name.	VARCHAR(16777216)
MANAGERLASTNAME	The manager's last name.	VARCHAR(16777216)
MANAGERMEAIL	The manager's email address.	VARCHAR(16777216)
DIRECTREPORTID	The ID of the manager's direct report.	VARCHAR(16777216)
DIRECTREPORTNAME	The name of the manager's direct report.	VARCHAR(16777216)
DIRECTREPORTFIRSTNAME	The first of the manager's direct report.	VARCHAR(16777216)
DIRECTREPORTLASTNAME	The last of the manager's direct report.	VARCHAR(16777216)
DIRECTREPORTEMAIL	The email address of the manager's direct report.	VARCHAR(16777216)
OPTOUT	Indicates whether or not the user opted out.	VARCHAR(3)
MANAGERRATING	The total number of manager ratings for the user.	NUMBER(18,0)
SELFRATING	Total number of self ratings by the user.	NUMBER(18,0)
SKILLTARGETS	Total number of Skill Targets, by user.	NUMBER(18,0)
TEAMFOCUSSKILLSRATING	Total number of Team Focus Skills rated by the user.	NUMBER(18,0)

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

USER_SUMMARY_USERSUMMARY

Direct Data Connector Field Name	Column Description	Data Type
EMPLOYEEID	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.	VARCHAR(16777216)
USERNAME	The user’s full name.	VARCHAR(16777216)
USERNFIRSTNAME	The user’s given name.	VARCHAR(16777216)
USERLASTNAME	The user’s family name or surname.	VARCHAR(16777216)
USEREMAIL	The user’s work email address.	VARCHAR(16777216)
USERSTATUS	Indicates the user's status within Degreed.  Values include: Enabled Disabled	STRING
MANAGERID	The unique ID of the user's manager.	STRING
MANAGERNAME	The full name of the user's manager.	STRING
JOBROLE	The user's Job Role	STRING
LEARNERSTATUS	The learner's status. Values include: Active None Inside of Degreed, active learners are denoted with a multi-colored circle around their avatar.	VARCHAR(16777216)
PERMISSIONROLE	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.	VARCHAR(16777216)
PROFILEPRIVACY	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.	VARCHAR(23)
FIRSTLOGIN	The date of the user’s first login on Degreed.	DATE
LASTLOGIN	The date of the user’s most recent login on Degreed as of the Report Date.	DATE
TOTALDAILYLOGINS	The number of days on which the user has logged in at least once.	NUMBER(18,0)
TOTALPOINTS	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.	FLOAT
REALTIMEEMAILNOTIFICATION	Indicates whether or not the user receives real-time email notifications. Values include: True False	VARCHAR(5)
DAILYDIGESTEMAIL	Indicates whether or not the user receives Daily Digest emails. Values include: True False	VARCHAR(5)
WEEKLYDIGESTEMAIL	Indicates whether or not the user receives Weekly Digest emails. Values include: True False	VARCHAR(5)
USERTOPICS	A list of skills the user selected on their Profile page.	VARCHAR(16777216)

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

USER_DETAILS_USERGROUPS

Direct Data Connector Field Name	Column Description	Data Type
GROUPNAME	The name of the Group.	VARCHAR(16777216)
EMPLOYEEID	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.	VARCHAR(16777216)
USERNAME	The user’s full name.	VARCHAR(16777216)
USERFIRSTNAME	The user’s given name.	VARCHAR(16777216)
USERLASTNAME	The user’s family name or surname.	VARCHAR(16777216)
USERMEAIL	The user’s work email address.	VARCHAR(16777216)
USERSTATUS	Indicates the user's status within Degreed.  Values include: Enabled Disabled	STRING
MANAGERID	The unique ID of the user's manager.	STRING
MANGERNAME	The full name of the user's manager.	STRING
DATEJOINED	The date the user joined the Group.	DATE
GROUPROLE	The user’s role in the Group, as set on the Group Settings page. Values include: Admin Member	VARCHAR(16777216)

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

USER_SUMMARY_LOGINS

Direct Data Connector Field Name	Field Description	Data Type
LOGGEDINDATE	The date of the login. Multiple logins by the same user display in different rows. This is the date range column located on the Filter dialog.  The column is included in the report results.	DATE
EMPLOYEEID	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.	VARCHAR(16777216)
USERNAME	The user’s full name.	VARCHAR(16777216)
USERFIRSTNAME	The user’s given name.	VARCHAR(16777216)
USERLASTNAME	The user’s family name or surname.	VARCHAR(16777216)
USEREMAIL	The user’s work email address.	VARCHAR(16777216)
USERSTATUS	Indicates the user's status within Degreed.  Values include: Enabled Disabled	STRING
MANAGERID	The unique ID of the user's manager.	STRING
MANAGERNAME	The full name of the user's manager.	STRING

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

USER_DETAILS_FOLLOWERSDETAILED

Direct Data Connector Field Name	Column Description	Data Type
FOLLOWEREMPLOYEEID	Unique user identifier for your Degreed site, for the user who follows another employee. This may be an email address or a different type of employee information, such as an SSO user name.	VARCHAR(16777216)
FOLLOWERUSERNAME	Full name of the user who follows another user.	VARCHAR(16777216)
FOLLOWERFIRSTNAME	First name of the user who follows another user.	VARCHAR(16777216)
FOLLOWERLASTNAME	Last name of the user who follows another user.	VARCHAR(16777216)
FOLLOWERUSEREMAIL	Work email address of the user who follows another user.	VARCHAR(16777216)
FOLLOWERUSERSTATUS	Indicates the follower's status within Degreed.  Values include: Enabled Disabled	TEXT
FOLLOWERMANAGERID	The unique ID of the follower's  manager.	TEXT
FOLLOWERMANAGERNAME	The full name of the follower's manager.	TEXT
BEINGFOLLOWEDEMPLOYEEID	Unique user identifier for your Degreed site, for the user being followed. This may be an email address or a different piece of employee information, such as an SSO user name.	VARCHAR(16777216)
BEINGFOLLOWEDUSERNAME	Full name of the followed user.	VARCHAR(16777216)
BEINGFOLLOWEDFIRSTNAME	First name of the followed user.	VARCHAR(16777216)
BEINGFOLLOWEDLASTNAME	Last name of the followed user.	VARCHAR(16777216)
BEINGFOLLOWEDUSEREMAIL	Work email of the followed user.	VARCHAR(16777216)

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

OPPORTUNITIES_SUMMARY_PUBLISHEDOPPORTUNITIESSUMMARY

Direct Data Connector Field Name	Column Description	Data Type
OPPORTUNITYID	The ID of the published Opportunity.	VARCHAR(16777216)
OPPORTUNITYTITLE	The Title of the published Opportunity.	VARCHAR(16777216)
OPPORTUNITYDESCRIPTION	The description of the published Opportunity.	VARCHAR(16777216)
APPLICATIONURL	The application URL of the published Opportunity.	VARCHAR(16777216)
OPPORTUNITYVISIBILITY	The visibility of the published Opportunity.	VARCHAR(16777216)
GROUPSVISIBILITY	A list of groups with access to the Opportunity.	VARCHAR(16777216)
OPPORTUNITYTYPE	The type of Opportunity. Possible values include: Dynamic Team Assignment Looking for Mentee Looking for Mentor Mentorship Peer Mentoring Pro Bono Project Reverse Mentoring Shadowing Stretch Assignment Volunteer Other	VARCHAR(16777216)
OPPORTUNITYSTATUS	The status of the Opportunity. Possible values include: Open Closed	VARCHAR(16777216)
OPPORTUNITYSKILLS	Skills the Opportunity is targeted to.	VARCHAR(16777216)
CREATEDBYEMPOYEEID	The ID of the employee who created the Opportunity.	VARCHAR(16777216)
CREATEDBYUSERNAME	The user name of the employee who created the Opportunity.	VARCHAR(16777216)
CREATEDDATE	The date the Opportunity was created.	DATE
LASTUPDATED	The most recent date the Opportunity was updated.	DATE
COLLABORATORSEMPLOYEEID	The ID of each collaborator added to the Opportunity. Values are separated by a | character.	VARCHAR(16777216)
COLLABORATORSUSERNAME	The user name of each collaborator added to the Opportunity. Values are separated by a | character.	VARCHAR(16777216)
DEPARTMENT	The organizational department for the Opportunity, such as HR or Sales.	VARCHAR(16777216)
LOCATION	The geographical location for the Opportunity such as Scottsdale, Arizona, USA.	VARCHAR(16777216)
DURATION	The length of time the Opportunity is expected to last.	FLOAT
DURATIONUNITS	The unit of measure for the duration. Combine Duration and Duration Units to determine the total time expected, such as 1 Week, or 3 Months.	VARCHAR(16777216)
STARTDATE	The date the Opportunity starts.	DATE
NUMBEROFINTERESTEDCANDIDATES	The total number of candidates who've shown interest in the Opportunity by clicking the Show Interest button.	NUMBER(13,0)
NUMBEROFSELECTEDCANDIDATES	The total number of candidates selected for the Opportunity.	NUMBER(13,0)
NUMBEROFSHORTLISTEDCANDIDATES	The total number of candidates shortlisted (marked as a preferred choice) for the Opportunity.	NUMBER(13,0)
NUMBEROFMATCHEDCANDIDATES	The number of candidates who are a match for the Opportunity.	NUMBER(18,0)
NUMBEROFSHARES	Total number of times the Opportunity was shared.	NUMBER(18,0)

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

OPPORTUNITIES_DETAILS_ACTIVEOPPORTUNITIESDETAILED

Direct Data Connector Field Name	Column Description	Data Type
OPPORTUNITYID	The ID of the Opportunity.	VARCHAR(16777216)
OPPORTUNITYTITLE	The title of the Opportunity.	VARCHAR(16777216)
OPPORTUNITYTYPE	The type of the Opportunity. Possible values include: Dynamic Team Assignment Looking for Mentee Looking for Mentor Mentorship Peer Mentoring Pro Bono Project Reverse Mentoring Shadowing Stretch Assignment Volunteer Other	VARCHAR(16777216)
OPPORTUNITYDESCRIPTION	The description of the Opportunity.	VARCHAR(16777216)
APPLICATIONURL	The URL for the Opportunity, if applicable.	VARCHAR(16777216)
OPPORTUNITYVISIBLILTY	Indicates the visibility setting for the Opportunity. Possible values include: Private to Collaborators Visible to Specific Groups Visible to Organization	VARCHAR(16777216)
OPPORTUNITYSTATUS	The status of the Opportunity. Possible values include: Open Closed	VARCHAR(16777216)
OPPORTUNITYOWNEREMPLOYEEID	The ID of the employee who owns the Opportunity.	VARCHAR(16777216)
OPPORUTUNITYOWNERUSERNAME	The user name of the employee who owns the Opportunity.	VARCHAR(16777216)
APPLICANTSTAGE	The stage of the application. Possible values include: Shortlisted: Users who are marked as preferred for the Opportunity. Selected: Users who are selected for the Opportunity. Archived: Users who are no longer considered a candidate for the Opportunity.	VARCHAR(16777216)
SelectedUserName	The user name of the applicant.	VARCHAR(16777216)
SelectedUserFirstName	The first name of the applicant.	VARCHAR(16777216)
SelectedUserLastName	The last name of the applicant.	VARCHAR(16777216)
SelectedUserEmail	The email of the applicant.	VARCHAR(16777216)

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

OPPORTUNITIES_DETAILS_OPPORTUNITIESINTERESTEDACTIVITYDETAILED

Direct Data Connector Field Name	Column Description	Data Type
DateUserInterested	The date the user expressed interest in the Opportunity by clicking the Show Interest button. This is the date range column located on the Filter dialog.  The column is included in the report results.	date
InterestedEmployeeId	The ID of the employee interested in the Opportunity.	TEXT
InterestedUserName	The User Name of the employee interested in the Opportunity.	TEXT
InterestedUserFirstName	The First Name of the employee interested in the Opportunity.	TEXT
InterestedUserLastName	The Last Name of the employee interested in the Opportunity.	TEXT
InterestedEmail	The email of the employee interested in the Opportunity.	TEXT
NumberofRequiredSkills	The number of required skills in the Opportunity that a user must have in order to qualify for the Opportunity.	NUMBER
InterestedUserSkillMatch	The number of skills the interested user has that match the required skills in the Opportunity.	TEXT
PercentofSkillsMatched	The percentage of skills the interested user has that match the required skills in the Opportunity. For example, if the Opportunity has 4 required skills, and the user has 2 of the skills, the Percent of Matched skills is 50%.	NUMBER
UnmatchedSkills	The name of the skills the interested user has that match skills in the Opportunity.	TEXT
InterestedUserStage	Indicates the user is interested in the Opportunity. The only value in this field is "Interested."	TEXT
OpportunityId	The ID of the Opportunity the user is interested in.	TEXT
OpportunityTitle	The Title of the Opportunity the user is interested in.	TEXT
OpportunityURL	The URL of the Opportunity the user is interested in.	TEXT
OpportunityType	The Type of Opportunity the user is interested in. Possible values include: Dynamic Team Assignment Looking for Mentee Looking for Mentor Mentorship Peer Mentoring Pro Bono Project Reverse Mentoring Shadowing Stretch Assignment Volunteer Other	TEXT
OpportunityStatus	The Status of the Opportunity the user is interested in. Possible values include: Open Closed	TEXT
CreatedDateofOpportunity	The date the Opportunity was created.	date
LastUpdatedofOpportunity	The most recent date the Opportunity was updated.	date

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

OPPORTUNITIES_DETAILS_SHAREDOPPORTUNITIESDETAILED

Direct Data Connector Field Name	Column Description	Data Type
DateShared	The date the Opportunity was shared. This is the date range column located on the Filter dialog. The column is included in the report results.	date
SharedByEmployeeId	The ID of the employee who shared the Opportunity.	char
SharedByUserName	The user name of the user who shared the Opportunity.	char
SharedbyUserFirstName	The first name of the user who shared the Opportunity.	char
SharedByUserLastName	The last name of the user who shared the Opportunity.	char
SharedByEmail	The email of the user who shared the Opportunity.	char
RecipientEmployeeId	The ID of the employee with whom the Opportunity was shared.	char
RecipientUserName	The user name of the employee with whom the Opportunity was shared.	char
RecipientUserFirstName	The first name of the employee with whom the Opportunity was shared.	char
RecipientUserLastName	The last name of the employee with whom the Opportunity was shared.	char
RecipientEmail	The email of the employee with whom the Opportunity was shared.	char
OpportunityId	The ID of the shared Opportunity.	char
OpportunityTitle	The title of the shared Opportunity.	char
OpportunityURL	The URL of the shared Opportunity.	char
OpportunityType	The type of the shared Opportunity. Possible values include: Dynamic Team Assignment Looking for Mentee Looking for Mentor Mentorship Peer Mentoring Pro Bono Project Reverse Mentoring Shadowing Stretch Assignment Volunteer Other	char
ShareStatus	The status of the shared Opportunity. Possible values include: Pending Completed	char

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

OPPORTUNITIES_SUMMARY_OPPORTUNITIESVIEWDATASUMMARY

Direct Data Connector Field Name	Column Description	Data Type
VIEWEDDATE	The date the Opportunity was viewed. This is the date range column located on the Filter dialog.  The column is included in the report results.	Date
OPPORTUNITYID	The ID of the Opportunity.	String
OPPORTUNITYTITLE	The title of the Opportunity.	String
OPPORTUNITYURL	The URL of the Opportunity.	String
OPPORTUNITYTYPE	The type of the Opportunity. Possible values include Dynamic Team Assignment Looking for Mentee Looking for Mentor Mentorship Peer Mentoring Pro Bono Project Reverse Mentoring Shadowing Stretch Assignment Volunteer Other	String
VIEWCOUNTDESKTOP	The total number of users who viewed the Opportunity on a desktop browser..	Number
VIEWCOUNTIOSBROWSER	The total number of users who viewed the Opportunity from an iOS browser.	Number
VIEWCOUNTANDROIDBROWSER	The total number of users who viewed the Opportunity from an Android browser.	Number
VIEWCOUNTIOSAPP	The total number of users who viewed the Opportunity on an iOS app.	Number
VIEWCOUNTANDROIDAPP	The total number of users who viewed the Opportunity from an Android app.	Number

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top

OPPORTUNITIES_DETAILS_MENTORINGDETAIL

Direct Data Connector Field Name	Column Description	Data Type
LASTUPDATEDATE	The most recent date the status was updated. This is the date range column located on the Filter dialog. The column is included in the report results.	DATE
STATUS	The current status of the mentorship. Possible values include: Pending: The mentorship request is waiting to be accepted or declined. In Progress: The mentorship is still active. Completed: The mentorship is completed. Declined: This mentorship request was declined.	VARCHAR(16777216)
MENTEEUSERID	The employee ID of the mentee.	VARCHAR(16777216)
MENTEEUSERNAME	The user name of the mentee.	VARCHAR(16777216)
MENTEEUSERFIRSTNAME	The first name of the mentee.	VARCHAR(16777216)
MENTEEUSERLASTNAME	The last name of the mentee.	VARCHAR(16777216)
MENTEEEMAIL	The email of the mentee.	VARCHAR(16777216)
MENTORUSERID	The employee ID of the mentor.	VARCHAR(16777216)
MENTORUSERNAME	The user name of the mentor.	VARCHAR(16777216)
MENTORUSERFIRSTNAME	The first name of the mentor.	VARCHAR(16777216)
MENTORUSERLASTNAME	The last name of the mentor.	VARCHAR(16777216)
MENTORUSEREMAIL	The email of the mentor.	VARCHAR(16777216)

Click the lineage chart image below to open it in a new tab and zoom in.

Back to Top