Components, tables, and roles used by Opportunity Marketplace (OPM)

  • Release version: Xanadu
  • Updated August 1, 2024
  • 4 minutes to read
    • Summarize
    Summarized using AI
    This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete.

    Summary of Components, tables, and roles used by Opportunity Marketplace (OPM)

    Opportunity Marketplace (OPM) in ServiceNow enables organizations to manage and track various types of opportunities such as gigs, projects, and volunteer roles. It integrates with the Hiring Core application to support talent acquisition processes by managing applicant information and recruitment workflows. Users can personalize form views by selecting visible columns and formatting options through the gear icon on form headers.

    Show full answer Show less

    Opportunity Marketplace Roles

    • Admin [snoppmarket.admin]: Grants access to OPM administrative modules and includes roles such as shared library admin, flow designer, and user criteria admin.

    Opportunity Marketplace Tables

    OPM uses several key tables to track opportunity and application details:

    • Opportunity [snoppmarketopportunity]: Stores details about opportunities like title, type (Gig, Project, Volunteer), state, owners, published date, and location.
    • Opportunity Location Mapping [snoppmarketm2mopplocation]: Tracks city, country, and location details related to opportunities.
    • Opportunity Position [snoppmarketopportunityposition]: Contains job-specific information such as title, description, location, employee levels, and user preferences.
    • Opportunity Preference [snoppmarketuseropportunitypreference]: Captures applicant preferences linked to configuration items.
    • Opportunity Preference Configs [snoppmarketopportunitypreferenceconfig]: Manages opportunity display configurations including name, type, and active status.
    • Opportunity Type [snoppmarketopportunitytype]: Defines opportunity categories and includes customizable types beyond standard ones.
    • Role Application [snoppmarketpositionapplication]: Records application details including applicant name, role, state, submission message, and creation date.
    • Position Skill [snoppmarketopportunitypositionskill]: Maintains skills associated with roles, including skill level and application linkage.
    • Application Quick Link [snoppmarketquicklink]: Stores quick link information for application forms such as display order, title, and URL.
    • Shared Opportunity [snoppmarketsharedopp]: Tracks opportunities shared between employees including sender, recipient, and creation date.

    Hiring Core Integration

    Hiring Core is a dependent app installed with OPM, providing a repository for talent acquisition data from internal or third-party platforms. It supports detailed tracking of applicants, certifications, education, work experience, skills, interviews, job postings, requisitions, recruitment tasks, and hiring teams.

    Key Hiring Core Tables Used by OPM

    • Applicant Certification, Education, and Work Experience: Manage applicant credentials, education background, and employment history.
    • Candidate [sntahiringcorejobapplicant]: Stores basic applicant information.
    • Extracted Skill: Holds skill data extracted from the Skills Foundation app related to applicants.
    • Interview Attendee and Interview Slot: Track interview participants and schedule details.
    • Job Application, Job Posting, Job Requisition: Manage job application tracking, postings, and requisition workflows.
    • Job Hiring Team: Details on hiring managers, interviewers, recruitment coordinators, and their visibility settings to applicants.
    • Recruitment Task: Tracks tasks associated with job requisitions including priority, state, and assigned recruiter.

    Hiring Core Roles

    • Admin: Full administrative access to Hiring Core functions.
    • Applicant (Internal and External): Roles for both internal and external job applicants; external applicant role includes additional external access.
    • Hiring Manager: Manages hiring processes and approvals.
    • Interviewer: Participates in interview processes.
    • Recruiter and Recruitment Coordinator: Responsible for managing recruitment workflows and coordination.

    Practical Use for ServiceNow Customers

    Understanding the roles and tables used by OPM and its integration with Hiring Core helps you configure and maintain your opportunity and recruitment workflows effectively. Personalizing form views enhances usability by focusing on relevant data fields. The comprehensive data model supports detailed tracking of opportunities, applications, and candidate information, enabling streamlined talent acquisition and employee engagement within your ServiceNow environment.

    Learn about the components used with Opportunity Marketplace.

    Opportunity Marketplace roles and tables

    You can configure which columns are visible in forms. Select the gear icon in the header of the form to personalize which columns you want to see and how they’re formatted.
    Important:
    The descriptions in these tables don’t contain all available fields. Select the gear icon in the header of the form to see all available fields.
    Table 1. Opportunity Marketplace roles
    Role title [name] Description
    Admin [sn_opp_market.admin]

    The OPM admin role enables access to the administrative modules for the app.

    The OPM admin role contains these roles.
    • [sn_egd_shared_lib.admin]
    • [flow_designer]
    • [user_criteria_admin]
    Table 2. Opportunity Marketplace tables
    Table label [name] Description
    Opportunity [sn_opp_market_opportunity] Tracks details about an opportunity, such as
    • Title
    • Opportunity type
      • Gig
      • Project
      • Volunteer
    • State
    • Owners
    • Published date
    Opportunity Location Mapping [sn_opp_market_m2m_opp_location] Tracks details about the location of the opportunity
    • City
    • Country
    • Location
    Opportunity position [sn_opp_market_opportunity_position] Tracks information about the job (opportunity) that is available, such as
    • Title
    • Opportunity
    • Description
    • Location
    • Employee levels
    User Opportunity Preference [sn_opp_market_user_opportunity_preference] Tracks the user preferences of an applicant, such as
    • Configuration item
    • Employee
    • Table: The table that contains details related to the opportunity preference configuration item.
    Opportunity Preference Configs [sn_opp_market_opportunity_preference_config] Tracks the details of the opportunities, such as
    • Display name
    • Name
    • Active
    • Type
    • Table
    • Field
    Opportunity Type [sn_opp_market_opportunity_type] Tracks details about opportunities (Gig, Project, Volunteer), such as
    • Title: The type of opportunity. The standard opportunities provided with OPM are Gig, Project, and Volunteer. You can create your own opportunity types, see Create other opportunities in Opportunity Marketplace.
    • Description
    • Role display
    • Icon
    • Active
    • Updated: The date the opportunity was last updated.
    Role Application [sn_opp_market_position_application] Tracks details of the application for a role by an applicant.
    • Employee: The name of the applicant.
    • Role: The position being applied for.
    • State
    • Submission Message: The message that an applicant created to submit with the application.
    • Created: The date the application was submitted.
    Position Skill [sn_opp_market_opportunity_position_skill] Tracks the skills that are associated with a role, such as
    • Opportunity role
    • Skill
    • Skill level
    Application Quick Link [sn_opp_market_quick_link] Tracks quick link details that are displayed on an application form, such as
    • Application
    • Display order
    • Title
    • URL
    Shared Opportunity [sn_opp_market_shared_opp] Tracks the details of opportunities that have been shared with an employee, such as
    • Created: The date the opportunity was created.
    • Opportunity: The number for an opportunity. An opportunity can be a job posting, an opportunity, or an opportunity role.
    • Recipient: The employee who the opportunity was shared with.
    • Sender: The employee who sent or shared the opportunity with another employee.

    Hiring Core tables and roles

    Hiring Core [sn_ta_hiring_core] is a dependent application that is installed when you install OPM.

    Hiring Core provides a repository where you can store information that you’ve created or received from any third party talent acquisition platform for your hiring requirements.

    The description contains examples of some of the available columns. Select the gear icon to see all the available columns (fields).
    Table 3. Hiring Core tables used by OPM
    Table label [name] Description
    Applicant certification [sn_ta_hiring_core_applicant_certification] Tracks data related to an applicant's certifications, such as
    • Certificate name
    • Issuer name
    • Valid till
    .
    Applicant education [sn_ta_hiring_core_applicant_education] Tracks an applicant's related educational data, such as
    • Institute name
    • Field of study
    • Degree type
    • Location
    Applicant work experience [sn_ta_hiring_core_applicant_work_exp] Tracks an applicant's work experience, such as
    • Company name
    • Start date
    • End date
    • Presently working here (true or false)
    • Location
    Candidate [sn_ta_hiring_core_job_applicant] Tracks an applicant's basic information, such as name and email address.
    Extracted Skill [sn_ta_hiring_core_extracted_skills] Track's details about skills extracted from the Skills Foundation app, including
    • Job applicant
    • Skill
    • Skill name
    Interview attendee [sn_ta_hiring_core_interview_attendee] Track's details about interview participants and the interview process details.
    • Name
    • Hiring role
    • Acceptance status
    • Job interview
    • Job title
    • Type
    Interview slot [sn_ta_hiring_core_interview_slot] Tracks information about the Job interview and the interview start and end dates and time.
    Job Application [sn_ta_hiring_core_job_application] Tracks job applications and related records, such as
    • Number: the application number.
    • Job requisition
    • Job applicant
    • State
    • Applied on: the date an applicant applied for this job.
    Job Board [sn_ta_hiring_core_job_board] Tracks information about related job boards, such as
    • Name: the name of the job board.
    • Logo
    • Active
    Job Hiring Team [sn_ta_hiring_core_job_hiring_team] Tracks information about your hiring team, such as
    • Job requisition
    • Hiring role
      • Hiring manager
      • Interviewer
      • Recruitment coordinator
    • Team Member: The name of the interviewer.
    • Type: The designation of Primary interviewer or Optional interviewer.
    • Visibility to applicant: The flag that determines whether an applicant can see information about the hiring team (true = visible, false = not visible).
    Job interview [sn_ta_hiring_core_job_interview] Tracks key information related to an interview and the interview process, such as
    • Number
    • Interview name
    • Interview type
    • State
    • Interview start
    • Interview end
    Job Posting [sn_ta_hiring_core_job_posting] Tracks job posting details, such as
    • Number: The number used to track a job posting.
    • Title
    • Job requisition: the number of the job requisition associated with a job posting. A job requisition can have more than one associated job posting.
    • Job board
    • Location flexibility
    • State
    • Posting date
    Job Requisition [sn_ta_hiring_core_job_requisition] Tracks your job requisition details, such as
    • Employment type
      • Full-time employee
      • Part-time employee
      • Temporary employee
      • Contingent
      • Contractor
    • Hiring manager
    • Job title
    • Number: The number used to track the job requisition details.
    • Number of headcounts
    • Primary location
    Select the form personalization icon at the top of the form the select which fields are displayed in the form.
    Profile link [sn_ta_hiring_core_profile_link]
    • Site
    • Job Applicant
    • Link
    • Type
    Recruitment Task [sn_ta_hiring_core_recruitment_task] Tracks the tasks that are associated with a job requisition, such as
    • Number: the job requisition number
    • Priority
    • State
    • Assigned to: The name of the recruiter the task is assigned to.
    • Short description
    Table 4. Hiring Core roles
    Role Description
    [sn_ta_hiring_core.admin] Admin
    [sn_ta_hiring_core.applicant] Applicant
    [sn_ta_hiring_core.external_applicant]

    This role is for the external applicants and contains the applicant and the [snc_external] role.
    [sn_ta_hiring_core.hiring_manager] Hiring manager
    [sn_ta_hiring_core.internal_applicant]

    This role is for the internal applicants and contains the applicant and the [snc_internal] role.
    [sn_ta_hiring_core.interviewer] Interviewer
    [sn_ta_hiring_core.recruiter] Recruiter
    [sn_ta_hiring_core.recruitment_coordinator] Recruitment coordinator