SELECT S.TOTALFEE,S.DESCRIPTION,S.MBSITEM,S.RECORDSTATUS FROM [BPSPatients].[dbo].[SERVICES] S WHERE S.LOCATIONID = '1' AND S.USERID = '91' AND S.RECORDSTATUS IN (1) AND S.CREATED >= '2026-05-01' AND S.CREATED < '2026-06-01' AND S.MBSITEM ='3'



Array ( [mode] => immediate [siteId] => 52027fdf-b2fe-48e1-a33c-f90df291f430 [integratorId] => c23e75e9-9bd1-40c6-be20-554536b2ded9 [status] => successful [statusTiming] => Array ( [initialising] => Array ( [startTime] => 2026-08-05T21:52:56.419Z ) [executing] => Array ( [startTime] => 2026-08-05T21:52:56.498Z ) ) [maxTimeInQueue] => 60000 [createdAt] => 2026-08-05T21:52:56.428Z [metrics] => Array ( [sqlExecutionDuration] => 37 ) [commandSize] => 273 [requestSize] => 338 [id] => 1c2ddc1e-a1c9-4767-8b4d-f9e9a18e5074 [completedAt] => 2026-08-05T21:52:56.543Z [result] => Array ( [rows] => 65 [size] => 6089 [data] => W3siVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjc1MDAsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOi03NTAwLCJERVNDUklQVElPTiI6IkFkanVzdG1lbnQgLSBTZXJ2aWNlOjU0NDE0OCwgMTYvMDUvMjAyNiAtIFN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfV0= [parameters] => ) [completedDuration] => 115 [resultSize] => 6790 [updatedAt] => 2026-08-05T21:52:56.543Z )
DescriptionTotal Fee
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 375.00
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
Surgery consultation, Level A 320.05
GRAND TOTAL1,338.15