where is the SLA information stored?

General
, , , , ,
1

What database query can be used to determine which stage has the SLA set in Pega, and where is the SLA information stored?

2

@NagaRajan M

The SLA events are stored in pegadata.pr_sys_queue_sla.

class name: System-Queue-ServiceLevel

3

Hi @NagaRajan M

Hope you are doing well.

The Stage-level SLAs will be stored here: pyWorkPage.pxFlow(pzInternalStageFlow).

Thank You!

Megha Maji

4

@Megha007 Thanks for your replay. i need to know in the DataBase How can I retrieve the name of the stage where the SLA is set in the Pega database? I found a table called pr_assign, and it seems like the pxstagelabel column might hold that value. Could you confirm if this is the correct column for retrieving the stage name?

Thankyou!

NagaRajan

5

@RameshSangili

Thanks for your replay. i need to know in the DataBase How can I retrieve the name of the stage where the SLA is set in the Pega database? I found a table called pr_assign, and it seems like the pxstagelabel column might hold that value. Could you confirm if this is the correct column for retrieving the stage name?

Thankyou!

NagaRajan

6

@NagaRajan M in clipboard you can view your SLA name, SLA Deadline,SLA GOAL as the pyWorkPage has these properties stored whenever you create a case that has SLA configured.And similar for Stage name as well as you can find from

Megha007 's answer.Just Expand the pyWorkPage and you will be able to see .pxFlow embedded inside it however to query the db for an SLA I feel this is not available yet .As all the details you will be getting from pyWorkPage itself.Hope it helps.

7

@NagaRajan M


1. Join SLA table (pegadata.pr_sys_queue_sla) and Assignment table using pxAssignmentHandle(sla) and pzInsKey(Assignment) --> to get the pzInsKey of Work Instance.
2. Join the Assignment table and Work table using pzInsKey(Work) and pxRefObjectKey(Assignment) -> to get the pxCurrentStageLabel

I hope this helps!