Published Opportunities (Summary)

Use the Published Opportunities (Summary) Report to view a summary of opportunities including description and number of interested, matched and selected candidates.

Permissions may be required to access some pages in Degreed or perform specific tasks. For more information, see Permissions in Degreed (accessible by Degreed Admins only).

Required Permission: Manage In-App Reporting

Direct Data Connector table name:  Opportunities_Summary_PublishedOpportunitiesSummary

Column Name	Column Description	Enabled by Default	Direct Data Connector Field Name	Data Type
Opportunity Id	The ID of the published Opportunity.	Y	OPPORTUNITYID	VARCHAR(16777216)
Opportunity Title	The Title of the published Opportunity.	Y	OPPORTUNITYTITLE	VARCHAR(16777216)
Opportunity Description	The description of the published Opportunity.	Y	OPPORTUNITYDESCRIPTION	VARCHAR(16777216)
Application URL	The application URL of the published Opportunity.	Y	APPLICATIONURL	VARCHAR(16777216)
Opportunity Visibility	The visibility of the published Opportunity.	Y	OPPORTUNITYVISIBILITY	VARCHAR(16777216)
Groups Visibility	A list of groups with access to the Opportunity.	Y	GROUPSVISIBILITY	VARCHAR(16777216)
Opportunity Type	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	Y	OPPORTUNITYTYPE	VARCHAR(16777216)
Opportunity Status	The current availability of the Opportunity. Possible values include: Open Closed Note: Opportunities that are deleted before being marked as Closed will still appear as Open in this report.	Y	OPPORTUNITYSTATUS	VARCHAR(16777216)
Opportunity Skills	Skills the Opportunity is targeted to.	Y	OPPORTUNITYSKILLS	VARCHAR(16777216)
Created By Employee ID	The ID of the employee who created the Opportunity.	Y	CREATEDBYEMPOYEEID	VARCHAR(16777216)
Created By User Name	The user name of the employee who created the Opportunity.	Y	CREATEDBYUSERNAME	VARCHAR(16777216)
Created Date	The date the Opportunity was created.	Y	CREATEDDATE	DATE
Last Updated	The most recent date the Opportunity was updated.	Y	LASTUPDATED	DATE
Collaborators Employee ID	The ID of each collaborator added to the Opportunity. Values are separated by a | character.	Y	COLLABORATORSEMPLOYEEID	VARCHAR(16777216)
Collaborators User Name	The user name of each collaborator added to the Opportunity. Values are separated by a | character.	Y	COLLABORATORSUSERNAME	VARCHAR(16777216)
Department	The organizational department for the Opportunity, such as HR or Sales.	Y	DEPARTMENT	VARCHAR(16777216)
Location	The geographical location for the Opportunity such as Scottsdale, Arizona, USA.	Y	LOCATION	VARCHAR(16777216)
Duration	The length of time the Opportunity is expected to last.	Y	DURATION	FLOAT
Duration Units	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.	Y	DURATIONUNITS	VARCHAR(16777216)
Start Date	The date the Opportunity starts.	Y	STARTDATE	DATE
Number of Interested Candidates	The total number of candidates who've shown interest in the Opportunity by clicking the Show Interest button.	Y	NUMBEROFINTERESTEDCANDIDATES	NUMBER(13,0)
Number of Selected Candidates	The total number of candidates selected for the Opportunity.	Y	NUMBEROFSELECTEDCANDIDATES	NUMBER(13,0)
Number of Shortlisted Candidates	The total number of candidates shortlisted (marked as a preferred choice) for the Opportunity.	Y	NUMBEROFSHORTLISTEDCANDIDATES	NUMBER(13,0)
Number of Matched Candidates	The number of candidates who are a match for the Opportunity.	Y	NUMBEROFMATCHEDCANDIDATES	NUMBER(18,0)
Number of Shares	Total number of times the Opportunity was shared.	Y	NUMBEROFSHARES	NUMBER(18,0)