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
)
| 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 |