Premium Retail Services

You will see this in a few places that will be addressed shortly (it won't fully eliminate the possibility but should drastically reduce the occurrence)...

SELECT NIT.[Id] AS NewItemTrackingId ,NIT.[SubBannerId] ,NIT.[ProductSkuId] ,NIT.[BeginDate] ,NIT.[EndDate] ,NIT.[Source] ...

SELECT LRS.[RequestSourceId] AS RapAlertId, LPS.ProductSourceKey1 AS ProductSku, C.ClientName , SA.MdmStoreId , S.[SName], S.[SStoreNo], SR.* FROM [rap]...

As of now, a Service request contains parts from 4 tables (ServiceRequest, ServiceRequestAttribute, LinkedRequestSource, LinkedProductSource). A Servi...

If you ever need to find why something failed to create an alert but you know it was sent by the systems in question. Look at the tables below based on the ...

If for any reason, you ever need to reset NewItemTracking to create alerts. Just update the status on newitem.NewItemTracking back to Pending and it will ru...

Adjust date and other criteria but this will help easily identify NewItem tracking records. SELECT NIT.[BeginDate], NIT.[EndDate], NIT.[Source], NIT.[...

SELECT COUNT(*) FROM [coordinator].[ServiceRequest] WHERE [Status] = 'Complete' AND [CompletionReason] IN ('Answered', 'AutoAnswered...

SELECT DA.[Id] AS DmcAlertId ,DA.[Upc] ,DA.[CountryId] ,DA.[StoreAssociationId] ,SR.[Id] AS ServiceRequestId ,SR.[ClientId] ,SR.[Activ...