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
)
| Description | Total Fee |
|---|---|
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 75.00 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| Surgery consultation, Level A 3 | 20.05 |
| GRAND TOTAL | 1,338.15 |