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-09-21T11:34:00.550Z ) [executing] => Array ( [startTime] => 2026-09-21T11:34:00.630Z ) ) [maxTimeInQueue] => 60000 [createdAt] => 2026-09-21T11:34:00.558Z [metrics] => Array ( [sqlExecutionDuration] => 13 ) [commandSize] => 273 [requestSize] => 338 [id] => bf986512-f49c-4f19-9bfe-b2a65ccf57c5 [completedAt] => 2026-09-21T11:34:00.651Z [result] => Array ( [rows] => 65 [size] => 6089 [data] => W3siVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjc1MDAsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOjIwMDUsIkRFU0NSSVBUSU9OIjoiU3VyZ2VyeSBjb25zdWx0YXRpb24sIExldmVsIEEiLCJNQlNJVEVNIjozLCJSRUNPUkRTVEFUVVMiOjF9LHsiVE9UQUxGRUUiOi03NTAwLCJERVNDUklQVElPTiI6IkFkanVzdG1lbnQgLSBTZXJ2aWNlOjU0NDE0OCwgMTYvMDUvMjAyNiAtIFN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfSx7IlRPVEFMRkVFIjoyMDA1LCJERVNDUklQVElPTiI6IlN1cmdlcnkgY29uc3VsdGF0aW9uLCBMZXZlbCBBIiwiTUJTSVRFTSI6MywiUkVDT1JEU1RBVFVTIjoxfV0= [parameters] => ) [completedDuration] => 93 [resultSize] => 6790 [updatedAt] => 2026-09-21T11:34:00.651Z )
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