This request usually comes from COE, Brad Cahillane, or via an email. The sub types first need to be created in NARS where they will be assigned a 4 character alphanumeric code (mostly alphas so far) that uniquely identify the type. We need this code and a good description (if provided) for the new activity sub type.

Example in scripts below: 

Data Led Alerts - Inventory Clean Up DLAI


  1. Insert into QTrax svQuestionActivitySubType table. Afterwards get the Id that you just inserted.

    INSERT INTO [Qtrax].[dbo].[svQuestionsActivitySubType] VALUES ('Data Led Alerts - Inventory Clean Up',1);

SELECT * FROM [Qtrax].[dbo].[svQuestionsActivitySubType] WHERE [DisplayName] = 'Data Led Alerts - Inventory Clean Up';


  2. Insert corresponding 4 character code and id from step 1 into the svQuestionsActivityTypeExternalKeyMapping

    INSERT INTO [Qtrax].[dbo].[svQuestionsActivityTypeExternalKeyMapping] VALUES (@Id, NULL, 'DLAI', 1);


  3. Once this is done, if needed for ServiceRequestGroupConfiguration, you can trigger migration to happen instantly. RE migrates every 30 mins whereas REX migrates once a day. REX is soon to retire.

  4. For RetailEngine - In Azure portal Premium tenant, go to Data Factories -> p-prs-retailengine-datafactory -> Launch Studio (Big blue button in middle of page) -> Author (pencil on left hand menu) -> Pipelines -> 360ToRetailEngineDataExtraction -> click pipeline of the same name -> Trigger -> Trigger now -> make sure to change ExecutionRegion to PROD then OK.

  5. For REX - In Azure portal Premium tenant, go to Data Factories -> p-prs-data-solution-datafactory -> Launch Studio (Big blue button in middle of page) -> Author (pencil on left hand menu) -> Pipelines -> 360ToREXDataExtraction -> click pipeline of the same name -> Trigger -> Trigger now -> make sure to change ExecutionRegion to PROD then OK.

  6. These will insert into the corresponding database in the threesixty.ActivitySubType tables.

  7. In REX and RE, insert into the rap.SubTypeMapping table. There is a story to automate this step soon.

    INSERT INTO [rap].[SubTypeMapping] VALUES ('DLAI', @Id, SYSUTCDATETIME());


  8. If needed, add ServiceRequestGroupConfiguration in RetailEngine to use the sub types. Refer to separate article.