Mid Valley My day |
- E01 Bill RegisterBilling · 814 bills · BILLBOOK (all bills + bill listing)
- E02 Billed Revenue by Department / DoctorBilling · 814 bills · BILLBOOK (all bills) · doctor from the bill's consultation line · department = the doctor's sub-specialty
- E02H Department Revenue SummaryBilling · 84 department-days · E02 Billed Revenue by Department / Doctor, summed per department, doctor and day (no patient or bill)
- E03 Revenue by ServiceBilling · 511 service lines · BILLBOOK (all bills, lines) · group > sub-group > service · OP / Day case
- E03S Revenue by Service (summary)Billing · 6 sub-groups · BILLBOOK (all bills, lines) · group > sub-group > service · OP / Day case
- E04 Procedure & Package VolumeBilling · 1247 procedure lines · BILLBOOK (all bills, procedure + package lines) · eye / lens from the line · surgeon from the line or the bill
- E05 Discount RegisterBilling · 266 discounts · BILLBOOK (discounts report) · approver and tier from the book
- E06 Estimate vs ActualBilling · 4 bills · BILLBOOK estimate docs (final version per bill) vs the bill net
- E07 Charges CancellationBilling · 5 cancelled charges · BILLBOOK charge cancellations (voided and omitted lines, one record each)
- E08 Bill CancellationsBilling · 0 cancelled bills · BILLBOOK bill revisions (Cancel bill) + the cancelled run
- E09 Notes Register (CN / DN)Billing · 0 notes · BILLBOOK credit notes and debit notes (docs)
- E21 Patient LedgerBilling · 3755 ledger lines · BILLBOOK bills, receipts, credit and debit notes (derived ledger; opening balance carried from the ledger history)
- A05 Unclosed Visits & Late ChargesBilling · 3 items · BILLBOOK counter queue (ready to bill) and lateCharges of each bill
- E10 Collection RegisterCash office · 840 receipts · BILLBOOK (receipts register)
- E11 Cashier Shift SheetCash office · 88 documents · INSURANCE.AR (till sessions)
- E12 Chief Cashier VerificationCash office · 22 tender lines · INSURANCE.AR (till verifications)
- E13 Receipt CancellationCash office · 0 cancelled receipts · BILLBOOK (receipts register)
- E14 Refund RegisterCash office · 29 refunds · BILLBOOK + INSURANCE.AR (refunds)
- E15 Deposit Register & Roll-forwardCash office · 4 deposits · BILLBOOK + FINVOUCHER (deposits)
- A01 Daily FlashManagement · 13 figures · FINVOUCHER.dayClose · EXEC.kpi · FINBOOK.budgets
- A02 Payer MixManagement · 14 payers · BILLBOOK (all bills + bill listing)
- A03 Package MarginManagement · 529 cases · FINBOOK.caseMargin · THEATRE
- A07 Revenue per Theatre CaseManagement · 131 cases · THEATRE cases · FINBOOK.caseMargin (package revenue)
- A04 Revenue LeakageManagement · 28 items · EXEC leakage rows · BILLBOOK · PLATBOOK.cancellations
- A06 Cancellations by Reason & PersonManagement · 3 cancellations · PLATBOOK.cancellations (charge, bill, receipt, theatre, appointment)
- A10 IOL Usage & ConsignmentManagement · 62 lenses · THEATRE case lens · HISCATALOGUE.EYE.iolStock · FINBOOK.caseMargin
- A12 Report Access & Delivery LogManagement · 1 events · PLATBOOK audit (reports) · PLATBOOK reportSend
- A13 Daily Management ReportManagement · 26 lines · FINVOUCHER.dayClose · EXEC.kpi · PATBOOK · THEATRE · FINBOOK.budgetFor · HISTPY (flagged prior year)
- E17 Outstanding BillsReceivables · 1275 bills · INSURANCE.AR (receivable lines)
- E19 Debtor AgeingReceivables · 15 debtors · INSURANCE.AR (receivable lines, AR.ageing day bands)
- E19M Debtor Ageing by Invoice MonthReceivables · 15 debtors · INSURANCE.AR (receivable lines, by invoice month)
- E16 Payer Bill ListingReceivables · 49 claims · INSURANCE (claims, guarantee letters)
- E18 Payer Settlement & RemittanceReceivables · 22 remittances · INSURANCE.AR (receipts) + remittance history + short-pay ledger
- E20 Statement of AccountReceivables · 16 debtors · INSURANCE.AR.statement (per debtor)
- A08 GL TurnaroundReceivables · 25 letters · INSURANCE.AR.glStampRows (GL timestamps)
- A09 Claims, Rejections & Short-payReceivables · 46 claims · INSURANCE.w1 (claims, short-pay ledger)
- A11 E-invoice Status RegisterFinance · 4 documents · BILLBOOK (e-invoice records, bills, notes)
- A14 Revenue by SegmentManagement · 11 revenue lines · BILLBOOK (bill-analysis by centre) + FINREG (package sessions, profit share, trial visits)
- A15 Package LiabilityManagement · 27 packages · FINREG.pkg (prepaid package register)
- A16 Credit Loss AllowanceReceivables · 12 buckets · INSURANCE.AR (receivable lines) + FINREG.ecl (rate per bucket)
- A46 P&L by Service LineManagement · 7 service lines · FINBOOK.pnlByLine · FINBOOK.pnl · FINBOOK.budgets
- A47 Cash Flow and 13-Week ForecastManagement · 41 lines · FINBOOK.cashFlow · FINBOOK.cashForecast
- A48 Balance Sheet SummaryManagement · 2 lines · FINBOOK.balanceSheet
- A30 Revenue by StreamManagement · 3 revenue lines · BILLBOOK (bill-analysis by centre: services, medicine, optical)
- A31 Receivable ConcentrationReceivables · 14 payers · INSURANCE.AR (open receivable lines by payer)
- A32 Revenue IntegrityManagement · 38 exceptions · BILLBOOK (credit notes, cancelled bills, value edits) + FINBOOK journals (manual revenue entries, reversals)
- A33 Staff Cost RatioManagement · 13 months · FINBOOK.pnl (revenue; 6100 salaries, 6110 EPF, 6120 SOCSO and EIS, 6130 allowances)
- A34 Panel RegisterReceivables · 19 panels · INSURANCE.panels (onboarding date, terms) + BILLBOOK all-bills (day-case surgery bills by payer)
- A35 Campaign ROIManagement · 7 campaigns · QGOV marketing campaigns register (spend, leads, bookings, surgeries) priced at the campaign package price
- A36 Optometrist RatioQuality and people · 23 staff · CORE.eyeStaff (optometrists, orthoptists) + HISDATA.DOCTORS (ophthalmologists) + CORE.eyeQueue (work-ups and consultations per person)
- A37 Doctor FeedbackQuality and people · 9 doctors · PRBOOK feedback (kiosk, patient app, discharge survey) by the doctor of the visit
- A38 Internal AuditQuality and people · 24 audits · QGOV internal audit programme register (area, quarter, findings, follow-up)
- A39 Safety and OSHQuality and people · 11 records · QGOV lost-time-incident, OSH committee and H&S training registers
- A40 Patient OriginQuality and people · 6 countries · Patient record nationality x eye-queue visits and itemised bills + QGOV cross-border referral partners register
- A42 Cataract OutcomesQuality and people · 11 surgeons · THEATRE operation records (done cases, ticked complications) and the laser records by the operating surgeon
- A17 Patient Visits by Segment and YearManagement · 8 visit lines · HIST day ledger (visits by centre) + published Group totals (AR2025 p.01)
- A18 Procedure Register by ClassManagement · 217 procedure lines · THEATRE case book (theatre cases) + HIST day ledger (injections, lasers, imaging studies)
- A19 Procedures by Anaesthesia TypeManagement · 39 anaesthesia lines · THEATRE case book (anaesthesia type per theatre case)
- A20 Clinic Waiting Time by StepManagement · 100 step lines · Visits and step counts from HIST; waits are demo assumptions (settings ops.wait.*): queue timestamps exist for today only
- A21 Revenue by Centre and QuarterManagement · 5 centre quarters · HIST day ledger (Mid Valley) scaled by centre size, like the executive branches; prior year from the growth settings (ops.rev.growth)
- A22 OT Utilisation and Maintenance CostManagement · 65 theatre months · THEATRE case book (booked minutes per theatre) + theatre session hours; maintenance cost is a demo assumption (settings ops.ot.*)
- A23 Procedure Counter by TechnologyManagement · 6 technologies · THEATRE case book + HIST injections since go-live, plus the count before go-live (demo assumption, setting ops.counter.baseline)
- A24 Laser Minutes and Suite ScheduleManagement · 434 laser cases · HISTC laser room cases + SMILE / LASIK theatre cases; suite minutes per code from the setting ops.laser.minutes
- A25 Seasonality and Recall TimingManagement · 12 months · HIST day-ledger run rate per open day, the festival and school-holiday calendar, and the deferral settings (ops.season.*)
- A26 New-Centre Ramp-up and Break-evenManagement · 0 new centres · Opening dates published (AR p.02-04, AGM p.17-19); revenue ramp, cost and capex are demo assumptions (settings ops.ramp.*) on the ledger’s mature month
- A86
- A27 Queue ReportManagement · 56 queue lines · OPSBOOK queue tickets (issued, served, missed, real wait and service minutes); the queue keeps today only, earlier days appear as the ledger fills
- A28 No-shows and ChangesManagement · 947 appointment days · OPSBOOK appointments (booked, attended, no-show, cancelled and rebooked, by day and doctor)
- A41 O-EMRAM AdoptionManagement · 516 measured items · PHYBOOK prescriptions + CLINICAL orders + HISVERBAL (CPOE) · NURSEBOOK doses (eMAR) · PHARMBOOK closed loop · PATBOOK discharges · PORTALBOOK transactions
- A44 Safety and Quality IndicatorsQuality · 18 indicators · QUALBOOK.indicators
- A44I Incident ListingQuality · 3 incidents · QUALBOOK.incidents
- A76 Cataract Surgery OutcomesEye clinical and commercial · 17 surgeons · QUALBOOK.outcomes (signed op notes, OT cases, eye record visits)
- A65 Eye Outcomes FunnelEye clinical and commercial · 82 surgeon points · QUALBOOK.funnel (outcomes against the indicator benchmark; 95% and 99.8% binomial limits)
- A66 Surgeon ScorecardEye clinical and commercial · 17 surgeons · QUALBOOK.surgeonScore (observed vs case-mix expected PCR, CUSUM) · QUALBOOK.outcomes · PRBOOK feedback
- A50 Complaints and Patient ExperienceQuality and people · 3 categories · PRBOOK.complaints · PRBOOK.feedback · PRBOOK.kpi
- A52 Credential ExpiryQuality and people · 174 credentials · HR.credAll (APC, registration, licence)
- A53 Referral SourcesEye clinical and commercial · 7 sources · PATBOOK.episodes (source, referral facility)
- A58 Stock and ConsignmentOperations · 6 stock states · INVENTORY.shelf · INVENTORY.stockValueMap
- A59 Panel UtilisationReceivables and claims · 19 panels · Report A34 (panel register) · report A08 (GL turnaround)
- A60
- A61 Month-End CloseManagement accounts · 8 blockers · FINBOOK.closeCheck
- A62 Clinical AuditsQuality and people · 6 audits · QUALBOOK.audits · QUALBOOK.AUDIT_AREAS
- A63 Equipment UptimeOperations · 19 equipment · FACILITY.allUnits (condition) · FACILITY.DOWN
- A64 Write-off RegisterReceivables and claims · 0 write-offs · BILLBOOK.writeOffRegister
- A56 Myopia ProgrammeEye clinical and commercial · 10 measures · EYEPROG.myopia.kpi (children enrolled, on treatment, progression)
- A57 Refractive OutcomesEye clinical and commercial · 7 measures · EYEPROG.refractive.kpi (candidates, booked, treated, UCVA outcomes)
- A45 Statutory NotificationsCompliance · 0 reportable events · QUALBOOK.reportables (incidents and infection cases, markNotified)
- A72 Readiness by StandardManagement · 12 standards · CMP audit engine (compliance-book.js): rules, vault and score
- A73 Element EvidenceManagement · 266 element rules · CMP audit engine: one row per element and rule with the last run, its SHA-256 and the sampled references (patient identifiers masked)
- A74 Audit CAPA LogManagement · 0 corrective actions · QUALBOOK incidents raised by the audit engine (src Audit)
- A75 Auditor View LogManagement · 0 opens · HISAUDIT view rows written by the auditor portal (one per open, with the grant id)
- A80
- A81
- A82
- A83
- A84
- A85 Deposit ConsumptionCash office · 4 deposits · BILLBOOK deposits, applications and refunds (the E15 deposit register rows) · FINVOUCHER day book
- A89 Day Care CensusOperations · 5 days · PATBOOK Day Care episodes + THEATRE cancelled cases + NURSEBOOK.unplannedStays
- A90 Day Care Length of StayOperations · 4 procedures · PATBOOK Day Care admission time to PATBOOK.dischargeFor stamp, by procedure
- A93 SST-02 SummaryFinance · 12 category rows · BILLBOOK bill lines: taxable (SR) vs exempt (EX) vs zero-rated (ZR) by service category
- A94 Panel Rejection RateFinance · 16 panels · BILLBOOK.panelClaims (claim status and the insurer's reason) by panel / TPA
- A95 Debtor Days by PanelFinance · 16 panels · BILLBOOK.panelClaims: unpaid over raised x days, this window against the window before
- A96 Pharmacy Margin and Top SellersFinance · 21 drugs · PHARMBOOK.utilisation (dispensed revenue, drug master cost) with the stock book's cost change
- A97 New Patients by State and PostcodeOperations · 35 postcodes · Patient book: patients whose first episode falls in the range, by registration address
- A98 National Eye Database ExportOperations · 25 eyes · Cataract registry (CATREG) with the cataract pathway record: one row per operated eye
- A99 Pharmacy Day and MonthPharmacy · 5 days · PHARMBOOK.dispensedByPharmacist (lines, value) · PHARMBOOK.lines (prescriptions, patients, stamps) · w1Queue (today's turnaround) · interventionLog · lotsOf / PROCURE write-offs
- A100 Pharmacy Top ItemsPharmacy · 21 drugs · PHARMBOOK.utilisation (dispensed and partly supplied lines: quantity and billed value per drug)
- A101 Pharmacy Wastage and ExpiryPharmacy · 20 lots · PHARMBOOK.lotsOf (expired and near-expiry lots) · PHARMBOOK.expiryPlan (left over at the date) · PROCURE.ledger WOF (drug write-offs)
- A102 PrescriptionsPharmacy · 49 prescriptions · PHARMBOOK.rxRegister (one row per visit prescription: the order's prescriber, medicines, status) · PHARMBOOK.rxDoctorSheet (the doctor-signed prescription)
- A88 PER-PS 101 Monthly ReturnCompliance · 5 cells · PATBOOK episodes + PATBOOK.dischargeFor; each cell ties to the operating report that lists the same rows