Migrate skills to the Task Skill table

  • Release version: Australia
  • Updated March 12, 2026
  • 1 minute to read

    • Migrate data from the Skills field to the Task Skills table to utilize mandatory skills support for executing tasks in a case or work order.

    Before you begin

    Role required: wm_admin, admin

    About this task

    The Task Skills [task_m2m_skill] table stores skills and mandatory skills.

    In the Customer Service Management application, the assignment workbench uses the Task Skills table instead of the Skills field in the Case table to display agents based on the evaluation criteria for task assignments.

    In the Field Service Management application, the work order task assignments done using auto-assignment, dynamic scheduling, and Dispatcher Workspace use the Task Skills table instead of the Skills field in the Work Order and Work Order Task tables to assign agents for task assignments.

    Procedure

    1. Add a system property with the following settings.
      OptionDescription
      Create a system property for a table in the Customer Service Management application.
      Make sure that you are logged in to the Customer Service Management application.
      Note:
      Configure the System Properties form to display the Suffix field.
      In the Suffix field, enter the name of the system property as follows:

      com.snc.skills_management.<table_name>_migrate_skills, where <table_name> is the name of a case task table from which the skills need to be copied.
      Create a system property for a table in the Field Service Management application.

      Make sure that you are logged in to the Global application.

      In the Name field, enter the name of the system property in the following format:

      com.snc.skills_management.<table_name>_migrate_skills, where <table name> is the name of a work order or work order task table from which the skills need to be copied.
    2. In the Type field, set the value to true.
    3. Click Update.
    4. Navigate to System Definition > Fix Scripts and run the Migrate Skills to Task Skill M2M fix script.
      The skills are copied to the task_m2m_skill table. The name of the table from which the skills are copied gets appended to the com.snc.skills_management.task_skill_migrated_tables system property. When the script is run again, it ignores all tables from which skills have already been migrated.