Confirming Checkout Verifications

How to confirm checkout verifications

If you need to confirm if a technician marked any of the verification options at checkout, you could run the following query on the obtb_appointmentcheckout table:

select CAST('<![CDATA[' + CheckoutData + ']]>' AS XML) from [TechPROAdmin].dbo.CheckoutLog where Service_Call_ID = '201103-0008' and Technician = 'CHET'

Apply the appropriate service call, technician and database.