Preetech's SSS Integration - Support

Step 1: Login to Control Hub

Step 2: Navigate to Configuration

Step 3: Select SSS from the Product and click display.

Step 4: Click on "Select" button on rown where attribute name is "SSS_START_DATE"

Step 5: Enter the value in format YYYY-MM-DD (e.g.,2025-01-01) to pull SSS reports from 01st Jan 2025

Step 6: Click on "Select" button on rown where attribute name is "SSS_END_DATE"

Step 7: Enter the value in format YYYY-MM-DD (e.g.,2025-01-10) to pull SSS reports to 10th Jan 2025

Important Notes:
  • Once missing or historical requests are pulled, update these attribute values to NULL(i.e., REMOVE THE DATE).
  • This change does not require a restart of the Preetech solution.

Incident Type mapping is controlled in a table "SSS_INCIDENT_TYPE_TO_CRM_REQUEST_TYPE".

Step 1: Connect to Preetech Database.

Step 2: Open new query window.

Step 3: Update the table SSS_INCIDENT_TYPE_TO_CRM_REQUEST_TYPE as per requirement.

INSERT INTO SSS_INCIDENT_TYPE_TO_CRM_REQUEST_TYPE
(SSS_INCIDENT_TYPE, CRM_REQUEST_TYPE, MAP_CUSTOMER_NAME, MAP_PROPERTY_ADDRESS, MAP_STREET_SUBURB, CRM_QUESTIONNAIRE_CODE)
VALUES
('INCIDENT_TYPE_ID','CRM_REQUEST_TYPE_CODE','TRUE OR FALSE DEPENDING ON IF MAPPING CUSTOMER NAME','TRUE OR FALSE DEPENDING ON IF MAPPING PROPERTY ADDRESS'
,'TRUE OR FALSE DEPENDING ON IF MAPPING STREET/SUBURB','QUESTIONNAIRE CODE IF QUESTIONS ARE MAPPED')

Example: 

INSERT INTO SSS_INCIDENT_TYPE_TO_CRM_REQUEST_TYPE
(SSS_INCIDENT_TYPE, CRM_REQUEST_TYPE, MAP_CUSTOMER_NAME, MAP_PROPERTY_ADDRESS, MAP_STREET_SUBURB, CRM_QUESTIONNAIRE_CODE)
VALUES
('CI_1655','DUMPRUB',1,1,0,'Q1')

To enable this, councils need to map the question descriptions and answers between SSS and Pathway. The questionnaire code must then be configured in the SSS integration configuration, as the solution uses this code to match the question descriptions and populate the corresponding answers in the Pathway request.
← Back to Support