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

  • Release version: Zurich
  • Updated July 31, 2025
  • 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 Zurich release provides a structured framework for managing opportunities such as gigs, projects, and volunteer roles. It includes configurable forms where users can personalize visible columns to better manage and track opportunity data. The platform integrates with the Hiring Core application, which supports comprehensive hiring processes by storing applicant and recruitment data.

    Show full answer Show less

    Opportunity Marketplace Roles and Tables

    OPM includes specific roles and tables that enable detailed management of opportunities:

    • Roles: The primary role is snoppmarket.admin which grants access to administrative modules and includes roles for shared library admin, flow designer, and user criteria admin.
    • Tables: Key tables track various aspects of the opportunity lifecycle:
      • snoppmarketopportunity: Stores core opportunity details like title, type, state, owners, and location.
      • snoppmarketm2mopplocation: Tracks opportunity location details such as city and country.
      • snoppmarketopportunityposition: Contains job-specific information including title, description, location, employee levels, and opportunity type.
      • snoppmarketopportunitytypeaux: Holds approvers related to opportunity types.
      • snoppmarketuseropportunitypreference: Manages applicant user preferences linked to configuration items.
      • snoppmarketopportunitypreferenceconfig: Defines preference configurations, including display names and types.
      • snoppmarketopportunitytype: Defines opportunity types (Gig, Project, Volunteer) with details such as title, description, icon, and status.
      • snoppmarketpositionapplication: Tracks applications for roles with details like applicant, role, state, message, and creation date.
      • snoppmarketopportunitypositionskill: Associates skills with roles, including skill level.
      • snoppmarketquicklink: Stores quick link details shown on application forms.
      • snoppmarketsharedopp: Manages opportunities shared between employees with metadata on sender, recipient, and creation date.

    Hiring Core Integration

    OPM relies on the Hiring Core application (sntahiringcore), which is installed automatically with OPM. This dependency supports extended talent acquisition capabilities by managing applicant and recruitment data across multiple tables and roles:

    • Key Hiring Core tables include: applicant certifications, education, work experience, extracted skills, interview attendees and slots, job applications, job boards, hiring teams, job interviews, job postings, job requisitions, profile links, and recruitment tasks. Each table stores detailed information essential for tracking candidates and recruitment workflows.
    • Hiring Core roles:
      • Admin (sntahiringcore.admin)
      • Applicant (sntahiringcore.applicant)
      • External Applicant (sntahiringcore.externalapplicant) – includes external and external community roles
      • Hiring Manager (sntahiringcore.hiringmanager)
      • Internal Applicant (sntahiringcore.internalapplicant) – includes internal and internal community roles
      • Interviewer (sntahiringcore.interviewer)
      • Recruiter (sntahiringcore.recruiter)
      • Recruitment Coordinator (sntahiringcore.recruitmentcoordinator)

    Practical Application for ServiceNow Customers

    ServiceNow customers leveraging Opportunity Marketplace can expect a comprehensive and configurable environment for managing diverse opportunity types, applications, and associated skills. The integration with Hiring Core enriches this by enabling detailed talent acquisition workflows.

    Administrators can assign the snoppmarket.admin role to manage OPM settings and modules. Form personalization via the gear icon allows tailoring the user interface to display relevant fields, improving usability.

    Understanding the structure of tables and roles facilitates effective customization, reporting, and integration with other ServiceNow modules or third-party talent acquisition systems.

    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
    Opportunity Type Auxiliary [sn_opp_market_opportunity_type_aux] Holds the names of approvers for an opportunity type
    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 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