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

  • Release version: Yokohama
  • Updated January 30, 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 Yokohama release enables organizations to manage various types of opportunities such as gigs, projects, and volunteer roles. It integrates with the dependent Hiring Core application to support recruitment and hiring workflows. Users can personalize form views by selecting visible fields via the gear icon on forms.

    Show full answer Show less

    Opportunity Marketplace Roles

    • OPM Admin ([snoppmarket.admin]): Grants access to OPM administrative modules and includes roles for shared libraries, flow designer, and user criteria management.

    Opportunity Marketplace Tables

    These tables help track and manage opportunities, roles, user preferences, and related information:

    • Opportunity ([snoppmarketopportunity]): Stores core opportunity details such as title, type, location, state, owners, and published date.
    • Opportunity Location Mapping ([snoppmarketm2mopplocation]): Records opportunity location data including city and country.
    • Opportunity Position ([snoppmarketopportunityposition]): Contains job/role-specific information like title, description, location, employee levels, and opportunity type.
    • Opportunity Type Auxiliary ([snoppmarketopportunitytypeaux]): Holds approver names for opportunity types.
    • Opportunity Preference ([snoppmarketuseropportunitypreference]): Tracks applicant preferences tied to configuration items and employee data.
    • Opportunity Preference Configs ([snoppmarketopportunitypreferenceconfig]): Manages opportunity display configurations, including names, active status, and types.
    • Opportunity Type ([snoppmarketopportunitytype]): Defines types of opportunities (e.g., Gig, Project, Volunteer) and their attributes like title, icon, and active status.
    • Role Application ([snoppmarketpositionapplication]): Tracks role applications submitted by employees, including state and submission messages.
    • Position Skill ([snoppmarketopportunitypositionskill]): Associates skills and skill levels to roles.
    • Application Quick Link ([snoppmarketquicklink]): Stores quick links displayed on application forms.
    • Shared Opportunity ([snoppmarketsharedopp]): Manages opportunities shared between employees, detailing sender, recipient, and creation date.

    Hiring Core Integration

    Hiring Core ([sntahiringcore]) is installed with OPM to provide a repository for applicant and hiring data, integrating third-party talent acquisition information.

    Key Hiring Core Tables

    • Applicant Certification, Education, Work Experience: Track applicant qualifications and employment history.
    • Candidate ([sntahiringcorejobapplicant]): Stores basic applicant details.
    • Extracted Skill ([sntahiringcoreextractedskills]): Contains skills data extracted from the Skills Foundation app.
    • Interview Attendee and Interview Slot: Manage interview participants and scheduling details.
    • Job Application: Tracks applications with states, dates, and associated job requisitions.
    • Job Board, Hiring Team, Job Interview, Job Posting, Job Requisition: Manage job posting and hiring team details, requisitions, and interviews.
    • Recruitment Task: Tracks tasks assigned to recruiters related to job requisitions.

    Hiring Core Roles

    • Admin ([sntahiringcore.admin])
    • Applicant ([sntahiringcore.applicant])
    • External Applicant ([sntahiringcore.externalapplicant]): Includes applicant and external roles.
    • Hiring Manager ([sntahiringcore.hiringmanager])
    • Internal Applicant ([sntahiringcore.internalapplicant]): Includes applicant and internal roles.
    • Interviewer ([sntahiringcore.interviewer])
    • Recruiter ([sntahiringcore.recruiter])
    • Recruitment Coordinator ([sntahiringcore.recruitmentcoordinator])

    Practical Implications for ServiceNow Customers

    Understanding the roles and tables in OPM and its integration with Hiring Core enables efficient configuration and customization of opportunity and hiring processes. Customers can tailor form views to display relevant fields, manage opportunity types and applications, and synchronize applicant information with hiring workflows. The defined roles ensure proper access control across administrative, applicant, and recruitment functions.

    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