-- CareLite website content.
-- Separate from 02_seed.sql so marketing copy can be reloaded without touching
-- platform data. Every page opens with a direct answer paragraph: answer engines
-- extract the first substantive block, so the question is answered before the
-- pitch begins.

SET NAMES utf8mb4;

-- ------------------------------------------------------------------ FEATURES
UPDATE cms_pages SET content_html = '
<p><strong>CareLite is hospital management software for hospitals and nursing homes of up to 30 beds. It covers patient registration, OPD, IPD, emergency, billing, corporate billing, collections, doctor payouts, reports and audit — the administrative and financial running of a hospital. It does not include pharmacy, laboratory, radiology or clinical records; those are separate modules.</strong></p>

<h2>What each part does</h2>

<h3>Patient registration and UHID</h3>
<p>One unique hospital identification number per patient, issued once and used for every visit and admission thereafter. Registration needs a name and a mobile number; everything else is optional and can be filled in later. If a name and mobile combination already exists the desk is warned and shown the earlier record, so the same person does not end up with three UHIDs and three separate outstanding balances.</p>

<h3>OPD</h3>
<p>Register a visit, choose the department and consulting doctor, add the consultation and any services, apply a discount if the patient qualifies, collect the money and print — without leaving the billing screen. Revisits reuse the same UHID. Corporate patients pick up their company tariff automatically.</p>

<h3>IPD</h3>
<p>Admission with ward, room and bed allocation from a live bed board. Bed charges post automatically for each day of stay, at the rate configured for that ward. Advances are taken at admission and applied against the final bill at discharge, so the patient pays only the shortfall. Transfers, consultant changes, interim bills and final settlement are all recorded with a reason and a user.</p>

<h3>Emergency</h3>
<p>Registration with the minimum data a casualty desk can realistically capture, including a genuinely unknown patient who has no name yet. Identity is filled in later without losing the UHID or any charge already raised. An emergency case converts to OPD or IPD on the same record.</p>

<h3>Billing</h3>
<p>A single billing engine serves OPD, IPD and emergency. Rates come from the applicable tariff and the source is stamped on every line, so a bill raised in April still shows April''s rate after the tariff changes in July. Bill totals are recalculated from the actual charges every time rather than accumulated, so a bill cannot quietly disagree with the lines that make it up.</p>

<h3>Corporate billing</h3>
<p>Company masters with their own tariffs, credit days and billing cycle. Each bill splits into company share and patient share automatically. Company share is gathered into periodic invoices, and outstanding is tracked with an ageing view so a hospital knows which company has been sitting on money for ninety days.</p>

<h3>Doctor payout</h3>
<p>Commission rules by service, service group, all consultations or everything, as a percentage or a fixed amount, calculated on gross, net of discount, or only on what is actually collected. Payout is derived from bill lines, so cancelling a bill reverses its payout without a separate reconciliation. Settlements freeze the entries for a period into a document.</p>

<h3>Reports</h3>
<p>Collection, billing, outstanding, advance, discount, cancellation, doctor and corporate reports, each with date, doctor, department, company and payment-mode filters, exportable to Excel and printable.</p>

<h3>Control and audit</h3>
<p>Role-based access down to the individual screen, discount limits per user with an approval trail above the threshold, and an insert-only audit log carrying who did what, when, to which document, with the value before and after. Nothing financial is ever deleted — bills, receipts and refunds are cancelled with a reason and remain on the register.</p>

<h2>What CareLite does not do</h2>
<p>Phase 1 is deliberately administration and finance. Pharmacy and inventory, laboratory, radiology and PACS, clinical records and e-prescription, nursing documentation, operation theatre, ICU charting, blood bank, dietary, ambulance, HR and payroll, a full accounting ledger, Tally integration, insurance and TPA claim submission, government scheme workflows, patient and doctor mobile apps and telemedicine are all outside it. Saying so plainly is more useful than a feature list that overpromises and disappoints during implementation.</p>
' WHERE slug = 'features';

-- ----------------------------------------------------------------------- OPD
UPDATE cms_pages SET content_html = '
<p><strong>CareLite OPD software takes an outpatient from registration to a printed receipt on one screen: register or find the patient, pick the doctor, add the consultation and services, apply any discount, collect part cash and part card if needed, and print. A returning patient is found by UHID, name or mobile and keeps the same record.</strong></p>

<h2>The counter flow</h2>
<ol>
<li><strong>Find or register.</strong> Search by UHID, name or mobile. A new patient needs only a name and mobile number; a UHID is issued on save. If the same name and mobile already exist, the desk sees the earlier record before creating a duplicate.</li>
<li><strong>Start the visit.</strong> Choose department, consulting doctor and patient type. A corporate patient picks up the company tariff without the clerk having to know which one applies.</li>
<li><strong>Bill.</strong> Services are chosen from the tariff with the rate already filled in. A service that earns a doctor commission cannot be billed without a doctor against it, because the payout is calculated from that line.</li>
<li><strong>Discount, if any.</strong> Each user has a discount ceiling. Below it, a reason is enough; above it, an approver must be named and both are recorded on the bill and in the audit trail.</li>
<li><strong>Collect.</strong> One receipt can carry several payment modes — cash, card, UPI, cheque — and modes that need a transaction reference ask for one.</li>
<li><strong>Print.</strong> Bill and receipt carry the hospital header, and any reprint is marked DUPLICATE and logged.</li>
</ol>

<h2>Questions this answers for the hospital</h2>
<ul>
<li>How much did each doctor bill today, and how much of it was collected?</li>
<li>Which discounts were given, by whom, on whose approval, and why?</li>
<li>What did each counter collect in cash, and does it match the drawer?</li>
<li>Which OPD patients still owe money, and how old is it?</li>
</ul>

<h2>Fitting how an OPD actually runs</h2>
<p>The billing screen is built for a queue: dense rows, tabular figures, no navigation between adding a service and taking the money. Rates come from the tariff rather than the clerk''s memory, and the tariff a bill used is stamped on it so a later rate revision does not rewrite last month''s billing. A cancelled bill stays on the register with its reason instead of disappearing, because a bill that vanishes is exactly the one an auditor asks about.</p>
' WHERE slug = 'opd-management';

-- ----------------------------------------------------------------------- IPD
UPDATE cms_pages SET content_html = '
<p><strong>CareLite IPD software manages the inpatient money trail from admission to discharge: bed allocation from a live bed board, automatic daily bed charges at ward rates, advances, transfers, consultant changes, interim bills during the stay, and a final bill at discharge with the advance applied so the patient pays only the balance.</strong></p>

<h2>Admission</h2>
<p>Admit against an existing UHID or register on the spot. The bed board shows every ward and bed with its current state — available, occupied, reserved, blocked or under maintenance — and an occupied bed carries the patient''s name and IPD number. Two counters admitting at the same moment cannot take the same bed: the second is told it has gone and nothing half-saves.</p>

<h2>Bed charges</h2>
<p>Charges post automatically for each day of stay, at the rate set for that ward in the applicable tariff, either on a calendar-day basis or on completed 24-hour blocks depending on how the hospital charges. The job is safe to re-run: charges post from the last charged date, so running it twice never doubles the bill. A transfer posts the stay so far at the old bed''s rate before the patient moves, so a move from general to ICU does not retrospectively reprice the earlier days.</p>

<h2>Money during the stay</h2>
<p>Advances are taken at admission or any time after, and each shows how much has been adjusted and how much is still refundable. Services, procedures and consultations post to a running interim bill that the ward desk or the family can see at any point. A running balance is visible on the admission screen throughout, so nobody discovers a problem at discharge.</p>

<h2>Discharge</h2>
<p>Discharge posts bed charges up to the discharge time, converts the interim bill into a final bill under the IPD number series, applies any unadjusted advance, generates doctor payout on the closed bill, and releases the bed — in one action, all or nothing. The advance appears separately on the printed bill and is never deducted twice. If a balance remains it stays outstanding against the final bill rather than blocking the discharge.</p>

<h2>What is recorded</h2>
<p>Every bed transfer, consultant change, discount, cancellation and refund carries a reason, a user and a timestamp. Discharge type — normal, against medical advice, referred out, or expired — is recorded and reportable.</p>
' WHERE slug = 'ipd-management';

-- ----------------------------------------------------------------- EMERGENCY
UPDATE cms_pages SET content_html = '
<p><strong>CareLite emergency registration is built for a casualty desk that often has no name, no relative and no time. A patient can be registered as unknown, treated and billed immediately, and identified later without losing the UHID or any charge already raised. The case then converts cleanly to OPD or IPD on the same record.</strong></p>

<h2>Registering an unknown patient</h2>
<p>An emergency registration needs almost nothing to proceed. Marking the patient unknown issues a UHID and an emergency number straight away so billing, investigations and admission can all proceed against a real record rather than a scrap of paper to be reconciled later.</p>

<h2>Identifying them afterwards</h2>
<p>When a relative arrives or the patient can speak, the name and mobile are updated from the emergency register. The UHID does not change, and every bill, receipt and admission raised in the meantime stays attached to the same person. The change is recorded in the audit trail with the earlier value, so the transition from unknown to named is itself traceable.</p>

<h2>Converting to OPD or IPD</h2>
<p>An emergency case that ends in admission converts directly: the patient, department, doctor, patient type and company carry over, the visit is marked converted, and the admission records which emergency case it came from. A case treated and released simply closes with its bill.</p>

<h2>Why this matters for a small hospital</h2>
<p>Emergency is where most hospitals lose money and traceability at once, because the desk is improvising under pressure. If the software insists on a complete patient record before it will issue a number, staff work around it — on paper, in a notebook, in their heads — and the charges surface days later, unbillable. Letting the record start incomplete and complete itself later is what keeps emergency revenue on the books.</p>
' WHERE slug = 'emergency-management';

-- ----------------------------------------------------------------- CORPORATE
UPDATE cms_pages SET content_html = '
<p><strong>CareLite corporate billing handles patients whose treatment is paid for wholly or partly by a company: company masters with their own tariffs and credit terms, an automatic split of each bill into company share and patient share, periodic invoices raised against the company, and an ageing view of what is outstanding and for how long.</strong></p>

<h2>Company masters and tariffs</h2>
<p>Each company carries its contact, GSTIN, agreement dates, credit days, billing cycle and credit limit. A company can have its own tariff with its own rates, or derive from the general tariff with a blanket discount. When a corporate patient is registered, the applicable tariff resolves automatically — the clerk does not need to know which company gets which rate.</p>

<h2>Splitting the bill</h2>
<p>Every corporate bill divides into company share and patient share. The patient pays only their portion at the counter; the company share accumulates as receivable. Both figures print on the bill so the patient can see what is being claimed on their behalf.</p>

<h2>Invoicing</h2>
<p>Company share sitting on finalised bills is gathered into an invoice for a chosen period. The due date follows that company''s credit days. A bill can appear on one invoice only — the system will not pick it up twice, and running the same period again finds nothing left. Cancelling an unpaid invoice returns its bills to the pending pool so they can be re-invoiced correctly.</p>

<h2>Knowing what is owed</h2>
<p>Outstanding is bucketed by the age of the invoice — 0 to 30, 31 to 60, 61 to 90 and over 90 days — per company, alongside how much has passed that company''s own due date. Agreements approaching expiry are flagged. An invoice with money receipted against it cannot be cancelled until the receipt is dealt with, so the receivable cannot be quietly erased.</p>

<h2>Reports</h2>
<p>Company-wise business showing patients, bills, net billed and the share split; a corporate invoice register; and the ageing view. All exportable, which is usually what the company''s own accounts department asks for.</p>
' WHERE slug = 'corporate-billing';

-- -------------------------------------------------------------------- PAYOUT
UPDATE cms_pages SET content_html = '
<p><strong>CareLite calculates doctor commissions from the bills themselves. You set a rule once — by service, service group, all consultations or everything, as a percentage or a fixed amount — and every matching bill line generates a payout entry. A cancelled bill reverses its own payout, so the monthly figure does not need reconciling against a spreadsheet.</strong></p>

<h2>How a rule is matched</h2>
<p>Several rules can apply to the same charge, so the most specific one wins: a rule for one service beats a rule for a service group, which beats a rule for all consultations, which beats a catch-all. Priority breaks a tie, and a rule written for a particular company beats a general one. Rules carry effective dates, so a revised arrangement applies from the date agreed rather than retrospectively.</p>

<h2>What the commission is calculated on</h2>
<p>A rule can pay on the gross amount, on the net after discount, or only on what has actually been collected. The last is the honest option where a hospital does not want to pay commission on money it has not received, and it is the one most disputes come from when it is handled on paper.</p>

<h2>Why it does not need reconciling</h2>
<p>Payout entries are derived from bill lines rather than accumulated separately. Cancel a bill and its payout reverses on its own; remove a line and only that line''s payout goes. There is no second set of numbers to keep in step with the first.</p>

<h2>Settlement</h2>
<p>Settling a doctor for a period freezes the eligible entries into a settlement document with the gross eligible, any deductions and the net payable. Settled entries leave the eligible pool, so the same period cannot be paid twice. Marking a settlement paid records the date and the payment reference. A rule changed afterwards does not reopen a settlement that has already been made.</p>

<h2>Reports</h2>
<p>Revenue by doctor before commission, payout position showing eligible, settled and reversed side by side, and the settlement history — all filterable by doctor and period, all exportable.</p>
' WHERE slug = 'doctor-payout';

-- ------------------------------------------------------------------- REPORTS
UPDATE cms_pages SET content_html = '
<p><strong>CareLite includes 29 reports across collection, billing, outstanding, advances, discounts, cancellations, doctor performance, corporate accounts and daily operations. Each takes date, doctor, department, company, ward and payment-mode filters as relevant, totals every numeric column, and exports to Excel or prints.</strong></p>

<h2>Collection</h2>
<p>Daily collection summary split by mode; collection by payment mode for reconciling the bank; collection by user for the counter handover; and the full receipt register including cancelled receipts, marked as such.</p>

<h2>Billing</h2>
<p>Bill register; revenue by service, by service group and by department; and a day-wise view of what was billed against what was collected. The last two rarely match — credit and advances sit between them — and seeing the gap is the point.</p>

<h2>Outstanding</h2>
<p>Patient outstanding oldest first; ageing buckets from 0 to 15 days through to over 90; and live balances for everyone currently admitted, which is the list to work before the discharge desk gets busy.</p>

<h2>Control</h2>
<p>Discount register with the reason and the approver on every line — usually the first report an auditor asks for. Cancelled bills and cancelled receipts with who cancelled them and why. Refund register with the approver.</p>

<h2>Doctor and corporate</h2>
<p>Revenue by doctor, payout position, and referral source analysis showing where patients come from and what each source is worth. Company-wise business, corporate ageing and the invoice register.</p>

<h2>Operational</h2>
<p>OPD, IPD and emergency registers; bed occupancy by ward; new patient registrations by day with a sex and corporate split; and user activity taken from the audit trail.</p>

<h2>Day-end reconciliation</h2>
<p>Three checks close a day honestly: cash in the drawer against the cash column of collection by user, card and UPI against the bank statement, and billed less received against outstanding. If those three agree, the day is clean.</p>
' WHERE slug = 'reports';

-- ---------------------------------------------------------------------- ABDM
UPDATE cms_pages SET content_html = '
<p><strong>CareLite captures a patient''s ABHA number and ABHA address, links it to their hospital UHID after OTP verification through the ABDM gateway, can publish visits and admissions as care contexts so they appear in the patient''s own health app, and logs every gateway request and response for NHA review. Live operation depends on the hospital''s own registration with the National Health Authority.</strong></p>

<h2>What is built</h2>
<ul>
<li>ABHA number and ABHA address on the patient record, captured at registration or added later</li>
<li>Verification by OTP to the mobile registered against the ABHA, through the ABDM M3 gateway</li>
<li>Linking a verified ABHA to the hospital UHID, with one ABHA never sitting on two patient records</li>
<li>Publishing care contexts — visits and admissions — so a patient can see them in their own app</li>
<li>A complete transaction log of every gateway call, successful or failed, with secrets and OTPs masked</li>
<li>Facility (HFR) and practitioner (HPR) identifiers held against the hospital and its doctors</li>
</ul>

<h2>What the hospital has to do</h2>
<p>ABDM participation is the hospital''s own registration, not the software''s. A hospital needs to be listed on the Health Facility Registry and hold client credentials from the National Health Authority. Once those exist they are entered against the hospital and the module is switched on. Moving from the ABDM sandbox to production is a setting, not a software change.</p>

<h2>ABDM never blocks treatment</h2>
<p>If the gateway is unreachable, the credentials are not yet issued, or the patient simply does not want an ABHA, registration and billing carry on exactly as normal. An ABHA can always be recorded by hand and verified later. The UHID remains the hospital''s identity for the patient; ABHA sits beside it. A patient who declines ABDM is not a second-class record.</p>

<h2>What is not claimed</h2>
<p>CareLite is ABDM-ready in the sense described above. Formal certification and milestone approval rest with the National Health Authority and with the hospital''s own application. Health information exchange beyond care-context linking, and clinical document sharing, belong to the clinical modules that sit outside Phase 1.</p>
' WHERE slug = 'abdm';

-- ----------------------------------------------------------------- NABH/SHCO
UPDATE cms_pages SET content_html = '
<p><strong>CareLite is designed around the digital controls a Small Healthcare Organisation is expected to demonstrate: every user has their own identity, access is restricted by role, financial documents are cancelled rather than deleted, and an insert-only audit trail records who did what, when, and to which document.</strong></p>

<h2>Unique user identity</h2>
<p>Every person who touches the system has their own login. Shared accounts are the single most common reason a hospital cannot answer an assessor''s question, because a shared account makes the audit trail meaningless. Passwords are stored hashed, one-time passwords must be changed at first sign-in, and accounts lock after repeated failures.</p>

<h2>Role-based access</h2>
<p>Permissions are granted by role and checked on the server for every screen, not merely hidden in the interface. A blocked attempt is itself written to the audit trail, which is how a misconfigured role gets noticed. Changing a role takes effect within a minute for anyone already signed in, so revoking a right after an incident does not wait until the end of the shift.</p>

<h2>Traceability of financial documents</h2>
<p>Bills, receipts and refunds are never deleted. A cancellation requires a reason, records the user and the time, and the document remains on the register marked cancelled. A refund is its own document rather than an edit to the original receipt. Reprints are counted and marked DUPLICATE.</p>

<h2>Controls on discretion</h2>
<p>Discounts are capped per user; above the threshold an approver must be named and is recorded on the bill. Discount reasons come from a controlled list. The discount register shows every one of them with its reason and approver.</p>

<h2>The audit trail</h2>
<p>Insert-only, with no screen in the hospital application that can edit or remove an entry. Each row carries the user, their role, the activity, the module and screen, the document and its number, the amount, the reason, the approver, the IP address, and the value before and after the change. It is filterable and exportable, which is the form an assessor usually wants it in.</p>

<h2>An honest note on accreditation</h2>
<p>Software supports accreditation; it does not confer it. NABH assessment covers clinical processes, infrastructure, staffing and documentation far beyond any billing system. What CareLite provides is the digital evidence for the access control, traceability and audit elements — not a certificate.</p>
' WHERE slug = 'nabh-shco';

-- ------------------------------------------------------------- WHY CARELITE
UPDATE cms_pages SET content_html = '
<p><strong>A thirty-bed hospital has the same billing problems as a three-hundred-bed one — company tariffs, interim bills, discounts needing approval, doctor commissions, money leaving unrecorded — but not the team to run a two-year software project. CareLite covers the administrative and financial half properly and says plainly what it leaves out.</strong></p>

<h2>Scoped rather than stripped</h2>
<p>Most software for small hospitals is a large system with features switched off, which means paying for complexity you cannot use and navigating screens built for somebody else. CareLite covers administration and finance completely and does not pretend to do pharmacy, laboratory or clinical records. A complete half is more useful than an incomplete whole.</p>

<h2>Live in days</h2>
<p>Masters — doctors, wards, beds, services, companies, tariffs — load from Excel templates with a preview that shows exactly what will be added, updated or skipped before anything is written. A hospital moves from account creation to live billing without a prolonged implementation exercise.</p>

<h2>Built for a queue</h2>
<p>The billing screen is dense and tabular because a counter clerk with eight people waiting needs the numbers legible and the next action on the same screen. There is no walk-through wizard between adding a service and taking the money.</p>

<h2>Financial control by default</h2>
<p>Discount ceilings per user with approval above them. Cancellation with a mandatory reason and no deletion. Refunds as separate documents. Numbers issued under a lock so two counters can never produce the same bill number. Bill totals recalculated from the actual charges rather than accumulated. These are the controls that decide whether the month-end figure can be trusted.</p>

<h2>Honest about the boundaries</h2>
<p>The list of what Phase 1 excludes is published on this site rather than discovered during implementation. That is deliberate. Most failed hospital software projects fail because scope was implied rather than stated.</p>
' WHERE slug = 'why-carelite';

-- ------------------------------------------------------------- DATA SECURITY
UPDATE cms_pages SET content_html = '
<p><strong>Hospital data in CareLite is separated per hospital, reachable only through role-based access, recorded in an insert-only audit trail, and backed up daily. Integration credentials are encrypted. The application database user cannot alter the schema.</strong></p>

<h2>Separation between hospitals</h2>
<p>Every record carries the hospital it belongs to, and every query filters on it. There is no shared table through which one hospital could read another''s patients, bills or reports. A user''s session is bound to one hospital.</p>

<h2>Access control</h2>
<p>Individual logins, permissions by role, and server-side checks on every screen rather than hidden buttons. Sessions expire on inactivity. Accounts lock after repeated failed attempts. Deactivating a user takes effect on their next action, not at their next sign-in.</p>

<h2>Encryption</h2>
<p>WhatsApp, email and ABDM credentials are stored encrypted with authenticated encryption, keyed from an application key held outside the database. Passwords are hashed, never stored or recoverable. Secrets and one-time passwords are masked before anything is written to a log — a compliance log is still a log.</p>

<h2>Traceability</h2>
<p>The audit trail is insert-only and covers creation, modification, cancellation, discount, refund, export, printing, sign-in and denied access, each with the before and after values. No screen in the hospital application can alter it.</p>

<h2>Backups</h2>
<p>A daily database backup runs on a schedule, is pruned on a retention window, and can be verified by actually restoring it into a scratch database and comparing rather than assuming the dump succeeded. Backups are meant to be copied off the server: a backup living on the machine it protects is not a backup. A failed backup raises an alert inside the application.</p>

<h2>Where responsibility sits</h2>
<p>CareLite provides the application controls above. Server hardening, network security, HTTPS certificates, physical access and the hospital''s own password discipline sit with whoever operates the deployment. Where CareLite hosts, those are ours; where a hospital hosts on its own infrastructure, they are the hospital''s. This is worth settling in writing before go-live rather than after an incident.</p>
' WHERE slug = 'data-security';

-- ---------------------------------------------------------------- ONBOARDING
UPDATE cms_pages SET content_html = '
<p><strong>Onboarding a hospital onto CareLite runs in a set order because each step depends on the last: account and users, then masters, then tariffs, then a parallel run, then go-live. A hospital with its data ready can be billing live within days rather than months.</strong></p>

<h2>1. Account and administrator</h2>
<p>CareLite creates the hospital account with its plan, bed and user limits and enabled modules, and issues one administrator login. That password is shown once and must be changed at first sign-in.</p>

<h2>2. Masters, in dependency order</h2>
<p>Departments and specialities, then doctors; wards, then rooms, then beds; service groups, then services; companies. Each level references the one above it, so loading them out of order produces rows that cannot resolve. Anything over about twenty rows should come in through the Excel template rather than being typed.</p>

<h2>3. Tariffs</h2>
<p>At least one general tariff is required — it is what the counter bills from. Corporate tariffs follow, either with their own rates or derived from the general one with a blanket discount. Bed charges are priced per ward.</p>

<h2>4. Users and roles</h2>
<p>Every person gets their own login with a role matching what they actually do. Discount ceilings are set per user at this point. This is the step hospitals are most tempted to shortcut with shared logins, and the one where that shortcut costs the most later.</p>

<h2>5. Settings</h2>
<p>Bed-charge basis, discount approval threshold, invoice and receipt header lines, and the communication channels — switched on only once credentials exist, otherwise messages queue and then fail.</p>

<h2>6. Parallel run and acceptance</h2>
<p>Run a day of real transactions and reconcile at the end of it: cash against the collection report, card against the bank, billed less received against outstanding. A written acceptance script covering OPD, IPD, emergency, corporate, payout, cancellation and audit is provided and should be signed off before go-live.</p>

<h2>7. Go-live and support</h2>
<p>Cut over during working hours so any problem is found and fixed the same day. Support runs during working hours; issues are raised from inside the application or by email.</p>
' WHERE slug = 'onboarding';

-- --------------------------------------------------------------------- LEGAL
-- Template wording. Have it reviewed by the company''s own legal advisor before
-- publishing — it is a starting point, not advice.
UPDATE cms_pages SET content_html = '
<p>This policy explains how CareLite collects, uses, stores and protects information. It applies to
the CareLite website and to the CareLite hospital management platform.</p>

<h2>Information we handle</h2>
<p><strong>From this website:</strong> the name, hospital, mobile number, email, city and bed count you
provide when requesting a demo, together with the page you submitted from and basic technical
information such as your IP address.</p>
<p><strong>Within the platform:</strong> hospital and user records, and the patient and financial records
that a hospital enters in the course of its own operations.</p>

<h2>Roles and responsibility</h2>
<p>For patient data held in the platform, the hospital is the controller of that information and
CareLite processes it on the hospital''s instructions under its service agreement. CareLite does not
use hospital or patient data for marketing, does not sell it, and does not share it with third
parties except as required to deliver the service or as required by law.</p>

<h2>How we use website enquiries</h2>
<p>Solely to contact you about CareLite. We do not sell or rent enquiry details.</p>

<h2>Security</h2>
<p>Access is restricted by individual login and role. Integration credentials are stored encrypted,
passwords are hashed, activity is recorded in an audit trail and data is backed up daily. See our
security page for detail. No system is absolutely secure, and we do not claim otherwise.</p>

<h2>Retention</h2>
<p>Hospital and patient records are retained for as long as the hospital''s account is active and
thereafter as required by applicable law and the service agreement. Website enquiry details are
retained while the enquiry is live and for a reasonable period afterwards.</p>

<h2>Your rights</h2>
<p>If you are a patient of a hospital using CareLite, approach that hospital in the first instance,
as it holds the relationship with you. For enquiry details submitted on this website, contact us to
access, correct or delete them.</p>

<h2>Changes and contact</h2>
<p>This policy may be updated; the current version is always the one published here. Questions about
it can be sent to the contact address on this site.</p>
' WHERE slug = 'privacy-policy';

UPDATE cms_pages SET content_html = '
<p>These terms govern use of the CareLite hospital management platform and this website. Specific
commercial terms are set out in the service agreement signed with each hospital; where the two
differ, the service agreement prevails.</p>

<h2>The service</h2>
<p>CareLite is provided as a subscription. Plans differ in bed and user capacity, not in features.
Phase 1 covers administration and finance: registration, OPD, IPD, emergency, billing, corporate
billing, collections, doctor payout, reports and audit. Pharmacy, laboratory, radiology, clinical
records and the other modules listed on this site are not included.</p>

<h2>The hospital''s responsibilities</h2>
<p>Accuracy of clinical and financial data entered, keeping individual user accounts individual,
lawful use of the platform, and compliance with the regulations applying to its own practice.
CareLite is a record-keeping tool and does not make clinical decisions.</p>

<h2>Availability and support</h2>
<p>We work to keep the service available and to support it during working hours, with planned
maintenance notified in advance. Availability commitments, if any, are those stated in the service
agreement.</p>

<h2>Data</h2>
<p>Hospital data belongs to the hospital. On termination, an export can be provided in a standard
format as set out in the service agreement, after which data is removed on the retention schedule
described in our privacy policy.</p>

<h2>Fees</h2>
<p>Subscription fees are as quoted, exclusive of taxes, payable in advance for the agreed term.</p>

<h2>Liability</h2>
<p>The platform is provided without warranty beyond that stated in the service agreement. Liability
is limited as set out there. Nothing in these terms excludes liability that cannot lawfully be
excluded.</p>

<h2>Governing law</h2>
<p>These terms are governed by the laws of India, with jurisdiction as specified in the service
agreement.</p>
' WHERE slug = 'terms';

UPDATE cms_pages SET content_html = '
<p>Talk to the CareLite team about a demonstration, pricing, onboarding or support. The fastest route
to a useful answer is to tell us your bed count and what you run today.</p>
' WHERE slug = 'contact';

-- ------------------------------------------------------------------ PER-PAGE FAQS
-- Four to six per page. These are the blocks answer engines lift, so each is a
-- question a hospital actually asks, answered completely in its own words
-- without needing the surrounding page for context.
DELETE FROM cms_faqs WHERE page_id IN (SELECT id FROM cms_pages WHERE slug <> 'faq');

INSERT INTO cms_faqs (page_id, question, answer, sort_order)
SELECT id, q, a, s FROM cms_pages, (
  SELECT 'features' sl, 'Does CareLite include pharmacy or laboratory?' q,
   'No. CareLite Phase 1 covers administration and finance — registration, OPD, IPD, emergency, billing, corporate billing, receipts, doctor payout, reports and audit. Pharmacy, inventory, laboratory, radiology, PACS and clinical records are separate modules outside Phase 1.' a, 1 s
  UNION ALL SELECT 'features','Can CareLite handle more than 30 beds?',
   'CareLite is designed and priced for hospitals and nursing homes up to 30 beds, and plans enforce a bed limit. A larger hospital is usually better served by a full hospital information system, because its needs extend into pharmacy, laboratory and clinical modules that Phase 1 does not cover.',2
  UNION ALL SELECT 'features','Is CareLite cloud-based or installed on a server in the hospital?',
   'CareLite is a cloud platform accessed through a browser, so there is nothing to install on each counter machine and no local server to maintain. It runs on standard PHP and MySQL infrastructure.',3
  UNION ALL SELECT 'features','How many people can use it at once?',
   'Each plan includes a number of user accounts, and users work simultaneously. Document numbering is issued under a database lock, so two counters billing at the same moment can never receive the same bill or receipt number.',4

  UNION ALL SELECT 'opd-management','How long does it take to bill an OPD patient?',
   'A returning patient is found by UHID, name or mobile, and the visit, services, discount, payment and printed receipt are all completed on one screen without navigating away. A new patient adds a short registration step that needs only a name and mobile number.',1
  UNION ALL SELECT 'opd-management','Can the counter change a rate?',
   'Only if the service is configured to allow it and the user holds the rate-edit permission. Otherwise the tariff rate is applied and the user is told. The tariff a bill used is recorded on it, so a later rate revision does not rewrite past bills.',2
  UNION ALL SELECT 'opd-management','How are discounts controlled?',
   'Each user has a discount ceiling. Below it a reason is required; above it an approver must be named. Both the reason and the approver are stored on the bill and in the audit trail, and appear in the discount register.',3
  UNION ALL SELECT 'opd-management','Can a patient pay partly in cash and partly by card?',
   'Yes. One receipt can carry several payment modes, and modes needing a transaction reference ask for one. The collection reports split cash from non-cash so the drawer and the bank can be reconciled separately.',4

  UNION ALL SELECT 'ipd-management','How are bed charges calculated?',
   'Automatically, for each day of stay, at the rate configured for that ward in the applicable tariff. The hospital chooses whether charging is by calendar day or by completed 24-hour blocks. The posting job is safe to re-run, because charges post from the last charged date and never double.',1
  UNION ALL SELECT 'ipd-management','What happens to the advance at discharge?',
   'Any unadjusted advance is applied against the final bill so the patient pays only the shortfall. It is shown separately on the printed bill and can never be deducted twice. Anything still unused stays refundable.',2
  UNION ALL SELECT 'ipd-management','What happens if a patient moves from a general ward to ICU?',
   'The stay so far is charged at the old bed''s rate before the move, and subsequent days at the new one. The transfer is recorded with its reason, time and user, and both beds update on the bed board.',3
  UNION ALL SELECT 'ipd-management','Can a patient be discharged with money still outstanding?',
   'Yes. The balance remains outstanding against the final bill and appears in the outstanding and ageing reports. Discharge is not blocked, because a billing system should not hold up a clinical decision.',4

  UNION ALL SELECT 'emergency-management','Can we register a patient whose name we do not know?',
   'Yes. An emergency case can be registered as an unknown patient and still receives a UHID and an emergency number immediately, so treatment and billing proceed against a real record. The name is filled in later without losing the UHID or any charge raised in the meantime.',1
  UNION ALL SELECT 'emergency-management','Does converting an emergency case to admission create a new patient?',
   'No. The conversion keeps the same patient and UHID, carries over the department, doctor, patient type and company, and records which emergency case the admission came from.',2
  UNION ALL SELECT 'emergency-management','Is the identification of an unknown patient traceable afterwards?',
   'Yes. The change is written to the audit trail with the previous value, so the transition from unknown to named is itself on record.',3

  UNION ALL SELECT 'corporate-billing','How does CareLite split a corporate bill?',
   'Each corporate bill divides automatically into company share and patient share based on the company''s tariff and terms. The patient pays only their portion at the counter, the company share becomes receivable, and both figures print on the bill.',1
  UNION ALL SELECT 'corporate-billing','Can the same bill be invoiced to a company twice?',
   'No. A bill can appear on one corporate invoice only. Running the same period again finds nothing left to invoice. Cancelling an unpaid invoice returns its bills to the pending pool so they can be invoiced correctly.',2
  UNION ALL SELECT 'corporate-billing','How do we know what a company owes and for how long?',
   'The ageing view buckets outstanding per company at 0 to 30, 31 to 60, 61 to 90 and over 90 days from the invoice date, alongside how much has passed that company''s own credit days. It exports to Excel, which is usually what the company''s accounts department asks for.',3
  UNION ALL SELECT 'corporate-billing','Can each company have its own rates?',
   'Yes. A company can carry its own tariff with its own rates, or derive from the general tariff with a blanket discount. The right tariff resolves automatically when a corporate patient is registered.',4

  UNION ALL SELECT 'doctor-payout','How is doctor commission calculated?',
   'From rules you set once — by service, service group, all consultations or everything, as a percentage or a fixed amount, calculated on gross, on net after discount, or only on what has actually been collected. Every matching bill line generates a payout entry automatically.',1
  UNION ALL SELECT 'doctor-payout','What happens to the commission if a bill is cancelled?',
   'It reverses on its own. Payout entries are derived from bill lines rather than accumulated separately, so there is no second set of numbers to reconcile against the first.',2
  UNION ALL SELECT 'doctor-payout','Which rule applies when several could?',
   'The most specific one: a rule for one service beats a service group, which beats all consultations, which beats a catch-all. Priority breaks a tie, and a rule written for a particular company beats a general one.',3
  UNION ALL SELECT 'doctor-payout','Can the same period be paid to a doctor twice?',
   'No. Settling freezes the eligible entries into a settlement document and removes them from the eligible pool, so a second settlement for the same period finds nothing. A rule changed later does not reopen a settlement already made.',4

  UNION ALL SELECT 'reports','Can reports be exported to Excel?',
   'Yes. Every report exports to CSV, which opens directly in Excel, and prints with the hospital name, period and the user who generated it. Exports are recorded in the audit trail.',1
  UNION ALL SELECT 'reports','Which reports close the day?',
   'Three checks: cash in the drawer against the cash column of collection by user, card and UPI against the bank statement, and billed less received against outstanding. If those agree, the day reconciles.',2
  UNION ALL SELECT 'reports','Can a user be stopped from seeing financial reports?',
   'Yes. Reports are grouped by permission — collection, billing, outstanding, discount, cancellation, doctor, corporate and operational — and a role only sees the groups it holds. The report list itself shows only what that user may open.',3

  UNION ALL SELECT 'abdm','Is CareLite ABDM compliant?',
   'CareLite is ABDM-ready: it captures the ABHA number and address, verifies and links an ABHA to the hospital UHID through the ABDM gateway, can publish visits and admissions as care contexts, and logs every gateway transaction. Formal certification and milestone approval rest with the National Health Authority and with the hospital''s own application.',1
  UNION ALL SELECT 'abdm','What does the hospital need before ABDM will work?',
   'Registration on the Health Facility Registry and client credentials issued by the National Health Authority. Once those exist they are entered against the hospital and the module is switched on. Moving from the ABDM sandbox to production is a setting, not a software change.',2
  UNION ALL SELECT 'abdm','What if a patient does not want an ABHA?',
   'Nothing changes. Registration and billing carry on exactly as normal, and the UHID remains the hospital''s identity for that patient. ABDM is additive and never stands between a patient and treatment.',3
  UNION ALL SELECT 'abdm','Can one ABHA be linked to two patient records?',
   'No. The system refuses it and names the record the ABHA is already linked to, so duplicate patient records are caught rather than created.',4

  UNION ALL SELECT 'nabh-shco','Does CareLite make our hospital NABH accredited?',
   'No. Software supports accreditation but does not confer it. NABH assessment covers clinical processes, infrastructure, staffing and documentation well beyond any billing system. CareLite provides the digital evidence for the access control, traceability and audit elements.',1
  UNION ALL SELECT 'nabh-shco','Can a bill or receipt be deleted?',
   'No. Financial documents are cancelled with a mandatory reason and remain on the register marked cancelled, with the user and time recorded. A refund is a separate document rather than an edit to the original receipt.',2
  UNION ALL SELECT 'nabh-shco','What does the audit trail record?',
   'The user and their role, the activity, the module and screen, the document and its number, the amount, the reason, the approver, the IP address and the values before and after. It is insert-only, and no screen in the hospital application can edit or remove an entry.',3
  UNION ALL SELECT 'nabh-shco','How quickly does removing a permission take effect?',
   'Within a minute for a user already signed in. Revoking a right after an incident should not wait until the end of a shift, so cached permissions are re-read periodically rather than only at sign-in.',4

  UNION ALL SELECT 'why-carelite','How long does it take to go live?',
   'A hospital with its masters ready in Excel can go from account creation to live billing in days. Doctors, wards, beds, services, companies and tariffs load from templates with a preview showing exactly what will be added, updated or skipped before anything is written.',1
  UNION ALL SELECT 'why-carelite','What makes CareLite different from a large HIS with features switched off?',
   'Scope, not size. A large system with modules disabled still charges for complexity you cannot use and presents screens designed for a different hospital. CareLite covers administration and finance completely and publishes what it excludes.',2
  UNION ALL SELECT 'why-carelite','Do our staff need formal training?',
   'The screens are built for a counter with a queue, so the common paths are short and self-explanatory. A walkthrough during onboarding is normally enough; there is no dependency on a lengthy training programme.',3

  UNION ALL SELECT 'data-security','Where is our hospital data stored, and can other hospitals see it?',
   'Every record carries the hospital it belongs to and every query filters on it, so no hospital can read another''s patients, bills or reports. A user session is bound to a single hospital.',1
  UNION ALL SELECT 'data-security','How often is data backed up?',
   'Daily, on a schedule, with a retention window and pruning. Backups can be verified by actually restoring them into a scratch database and comparing rather than assuming the dump worked, and a failed backup raises an alert inside the application. Backups should be copied off the server.',2
  UNION ALL SELECT 'data-security','Are integration credentials safe?',
   'WhatsApp, email and ABDM credentials are stored using authenticated encryption keyed from an application key held outside the database. Passwords are hashed and never recoverable, and secrets and one-time passwords are masked before anything is written to a log.',3
  UNION ALL SELECT 'data-security','Who is responsible for server security?',
   'CareLite provides the application controls. Server hardening, network security, HTTPS certificates and physical access sit with whoever operates the deployment — us where we host, the hospital where it hosts its own. It is worth settling in writing before go-live.',4

  UNION ALL SELECT 'onboarding','What do we need to prepare before onboarding?',
   'Lists of doctors, wards and beds, services with rates, and companies with their tariffs and credit terms. Excel templates are provided for each. Having these ready is the single biggest factor in how quickly a hospital goes live.',1
  UNION ALL SELECT 'onboarding','In what order should masters be loaded?',
   'Departments and specialities, then doctors; wards, then rooms, then beds; service groups, then services; then companies and tariffs. Each level references the one above it, so loading out of order produces rows that cannot resolve.',2
  UNION ALL SELECT 'onboarding','Can we import our existing patient list?',
   'Master data — doctors, services, wards, beds, companies, tariffs — imports from Excel templates. Historical patient and transaction migration is handled case by case, because the shape and quality of the source data vary considerably.',3
  UNION ALL SELECT 'onboarding','What happens on the day we go live?',
   'Cut over during working hours so any problem is found and fixed the same day, run a full day of real transactions, and reconcile at the end of it against the collection reports and the bank before signing off.',4
) f WHERE cms_pages.slug = f.sl;
