Question

Optum
IN
Last activity: 17 Mar 2021 0:45 EDT
Want only specific set of columns from pc_assign_workbasket/list tables to be in a Data Set to be sent for further processing
My requirement is to send all the existing assigments data to some another external system XYZ. But not necessarily all the info about the assignments. I only require following data to be sent to XYZ :
My requirement is to send all the existing assigments data to some another external system XYZ. But not necessarily all the info about the assignments. I only require following data to be sent to XYZ :
Parameter | Type | Required [Y/N] | Description | Sample allowed data | Questions/Comments |
WorkList | array | Y | Mandatory block. Contains all the parameters below. | ||
WorkID | string | Y | Any kind of Work object ID(Interaction, Service Case, Ticket) | "I-123", "S-123", "T-123" | |
Active | boolean | Y | Specifies whether XYZ should consider this case for routing. eg. Pega will send false for Resolved- so XYZ can remove its record from active routing DB. | true (or) false | |
AssignedID | string | N (Y when Active is set to true) | Workbasket ID when work is in Workbasket Agent ID when work is in Agents Work List | TechnicalServiceCenterWB (or) JOHNDOE | |
AdvisorAction | string/enum? | N | Specifies Agent Action. Pega will only send this when an agent has performed an action. Internal processes like auto-resolving cases will not be able to supply this. | "open" (or) "close" | |
Application | string | N (Y when Active is set to true) | Specifies the application in which assignment is created | "1.2" (or) "2.1" | |
Urgency | integer | N | Urgency of the Work item | 60 | |
IsFromWorkBasket | boolean | N | Specifies whether Assignment Information is from Work basket or Work list true - Assignment is in Work basket false - Assignment is in Work list | true (or) false | |
CaseOwner | string | N | Holds AgentID if Case ownership applicable to Case and Assignment is in Work basket | "JOHNDOE" | |
Skills → Value | array | N | Holds Skills associated to the Assignment when sharing info from Workbasket | AB,CD,EF ... ... | |
ActiveSince | string | N | The datetime that the case was first sent to XYZ for routing. This is for XYZ to determine urgency of the case. | "20211231T120000Z" | |
MediaType | string/enum? | N | XYZ media type for the case - correlate to generic Pega case type. Can extend this in future. | "Service", "Ticket", "Interaction" |
|
I have identified the solution using Data sets and Data flows. So I need a Data set with only above data. If someone can help me on how to create a Data set like that it would be appreciated.
Thanks & Regards
Sourav Dwivedi