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:
|
Y | OPPORTUNITYTYPE | VARCHAR(16777216) |
| Opportunity Status |
The current availability of the Opportunity. Possible values include:
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) |