🏥HBP Portal
Ayushman Bharat
Case Workflow
Registration se claim tak, har case ka kaam ek jagah — documents, queries, OT papers aur billing.
📋
Case trackingRegister, ward census, discharge — roz ka kaam
📎
Documents & queriesMEDCO check, query reply, OT papers
💳
Claims & billingPreauth, enhancement, final bill, refund
Hospital staff ke liye
Log in
Apna username aur password daalein
🖥 Hospital ka fixed PC register karein
Hospital Admin se 8-digit code lo (Setup → Hospital PCs). Ye PC 30 din tak bina GPS ke login kar sakega; uske baad Admin ko "Renew" karna hoga.
All Hospitals — Overview (super_admin)
Every hospital's key numbers side by side, so you don't have to "Act as" each one just to check how it's doing. Click "Act as" on a row to switch into that hospital directly.
| Hospital | Status | Staff | Total Cases | Active Cases | Open Queries | Pending Docs | Enhancement Pending | Discharged Today | Claimed Today |
|---|
Hospitals (super_admin)
| ID | Hospital | Account | Pincode Dashboard | AI-Assist | AI Training | Login location |
|---|
Possible Duplicate Documents
Jo document kisi DOOSRE case ke document jaisa mila (bilkul same file ya bahut milti-julti photo). Har row me dono taraf dikhta hai: kisne attach kiya, kisne Right/Wrong kiya, case ka status. System sirf flag karta hai — faisla aapka hai: Theek hai (coincidence) / Galat case (action liya).
Is tab me koi duplicate nahi — kuch review karne ko nahi.
📄 Common / Template files (Super Admin)
Jo file har patient ke saath aati hai (hospital ka blank form, consent template) use yahan daal dein — wo kabhi duplicate ginti me nahi aayegi. Kisi row me "Template list me daalo" se jodein.
🤖 Apne aap hataye gaye "Very similar" flags (Super Admin)
Paper par naam / umar / gender dekhkar jab saaf laga ki dono papers alag patient ke hain, to flag apne aap hata diya gaya. Yahan record rehta hai — galti lage to us case me jaakar dekh lo.
📊 Galat-patient documents — kis ke haath se (coaching ke liye)
Kitne documents baad me "galat patient ka" nikle: kisne attach kiye aur kisne approve kiye. Sirf training/samjhane ke liye — sazaa ke liye nahi.
Database Backup (super_admin)
Downloads a complete, safe snapshot of the entire database (every hospital's data) as one file, straight to your browser's Downloads folder. Do this regularly and move the file somewhere off this PC (a USB drive, cloud storage, email to yourself) — it's the only way to recover everything if this PC's copy is ever lost or accidentally deleted.
Automatic backups
The server also takes a backup by itself once a day (kept on the server, last 14 backups). You can download any of these anytime, or take an extra one right now.
| File | Size | Created |
|---|
Third-Party Staff (super_admin)
For a MEDCO, Ayushman Mitra, or MIS who isn't employed by any one hospital — e.g. a 3rd-party MEDCO or MIS covering several hospitals, or a 3rd-party Ayushman Mitra who by default only does Enhancement-confirm + Claim. Create the account here, then grant it access to whichever hospitals it should work in — only Super Admin can grant or revoke access. For a 3rd-party Ayushman Mitra whose own team runs the whole case workflow for a hospital (register, share documents, discharge — not just claim), tick "Full access" on that specific hospital's grant.
Status Tags — All Hospitals (super_admin)
Every claim status seen across ANY hospital's Case Tracker data, resolved against the SHARED default only — so when a new status shows up anywhere, it can be tagged once here instead of needing to log into that specific hospital's account. This sets the shared default only; a hospital's own MIS/Admin can still override it just for their hospital from their Case Tracker tab.
| Claim status | Level | Group | Payment Status | TMS me discharge ho chuka? | Source |
|---|
Staff (hospital_admin / super_admin)
Super Admin: pick a hospital from "Acting as" at the top to manage its staff.
| ID | Name | Username | Role | Status |
|---|
MIS Permissions (hospital_admin / super_admin)
Off by default — turn these ON to let this hospital's MIS staff do these two things too.
Analytics (hospital_admin / super_admin)
This hospital's numbers — who's processing cases and how fast, and where pending work is piling up by floor. Pick a hospital from "Acting as" at the top first if this is empty.
Staff speed
"Avg days Register→Discharge" / "Discharge→Claim" are attributed to whoever completed that later step — e.g. Register→Discharge counts against the staff member who marked the case Discharged, not whoever registered it.
Column ke naam par click karke sort karein (A→Z / bada→chhota).
| Staff | Role | Registered | Discharged | Claimed | Avg days Register→Discharge | Avg days Discharge→Claim | Actions (7 days) |
|---|
Floor-wise pending (active cases only)
| Floor | Active Cases | Pending Docs Today | Open Queries | Enhancement Pending |
|---|
🤖 AI vs MEDCO report (training data)
Jab MEDCO "AI se check karao" chalata hai, AI ka verdict aur MEDCO ka final verdict yahan milaye jaate hain — kahan AI sahi tha, kahan chook gaya, aur MEDCO ne kya likha. Isi se tay hoga ki AI par kitna bharosa karein.
🏠 Ghar se kaam (sirf Super Admin)
Hospital ke apne staff pe abhi hospital-location rule lagta hai. Jis staff ko ghar se kaam karna hai uska switch ON karein — wo kahin se bhi login kar sakega (third-party staff jaisa). Uska login kab/kahan se hua wo Super Admin ko dikhta rahega, ek ID ek hi device pe chalegi, aur idle hone par auto-logout hoga. Switch OFF karte hi uska session band ho jata hai aur wapas hospital se hi login hoga.
🖥 Hospital PCs & Sessions (Admin / Super Admin)
Hospital ke fixed PC ko ek baar code se register karein — wo 30 din bina GPS ke chalega, phir yahan se Renew karein. Baaki sab device (mobile / laptop) ko har ~10 min me hospital ke andar se GPS confirm karna padta hai, chahe wo kisi bhi WiFi ya mobile data par ho.
📍 Location Log (kaun, kahan se, kab)
Staff ke login / GPS check ka record apne aap banta hai aur 90 din baad apne aap saaf ho jata hai. Third-party staff kahin se bhi login kar sakta hai — uski location yahan sirf record hoti hai.
Abhi kahan (last seen)
Log
👥 Shak wale logins (ek ID, kai device)
Ek ID ek hi device par chalti hai — naya login hote hi purana device logout ho jata hai. Agar purana device abhi 10 min ke andar kisi insaan ne use kiya tha aur login doosre device se aaya, to yahan ginti badhti hai. Ye list apne aap banti hai aur 90 din baad saaf ho jati hai. Shak = 24 ghante me 3+ baar.
➕ Extra documents (code / package / specialty / sabhi main codes)
Official HBP list me jo document nahi hai (jaise MG072D me Dialysis Chart) use yahan jodo — Pre ya Post checklist me aa jayega aur Ayushman Mitra use attach bhi kar sakega. Official list ko ye chhedta nahi, master dobara import hone par bhi bana rehta hai. Ye sirf main procedure code par lagta hai, add-on par nahi. Patient Photo, Ayushman Card, Discharge Summary, Operative Notes pehle jaise built-in hain.
Jude hue extra documents
🏷 Investigation / Sub-type naam (sab hospitals ke liye ek list)
Document ke Sub-type dropdown me jo naam dikhte hain wo yahan se aate hain. Naya naam Admin / MIS jodte hain (prastav), Super Admin approve karta hai aur tab wo sab hospitals me aa jata hai. Approve hone tak naya naam sirf bhejne wale hospital me ⏳ ke saath dikhta hai.
"Other" me MEDCO / AM ne ye naam likhe (sabse zyada wale upar)
Prastav
Floors & Wards (MIS / hospital_admin / super_admin)
This hospital's own Floor and Ward lists — used to fill the Floor/Ward pickers at registration, and to drive the Dashboard's "By floor" summary. Add exactly the floors/wards this hospital actually has.
| Floor |
|---|
Floor Access — Ward assignment aur Floor duty (MIS / hospital_admin / super_admin)
Ward assignment = AM kaunse wards dekhega (round, census, kaam strip). Floor duty = floor par Registration / Discharge request kaun dekhega aur accept karega. Dono alag hain — ward dene se floor duty nahi milti.
1) Ward assignment — kisi bhi floor ke ward tick karo
2) Floor duty — Registration / Discharge requests
Jis floor par tick hoga, uske requests is staff ki "Requests to Review" list me aayenge. Ward ka isse koi lena-dena nahi.
Kaun kya dekhta hai
Task Access — which Ayushman Mitra can do which task (MIS / hospital_admin / super_admin)
By default every Ayushman Mitra can do all of these. Turn ON "Restrict" for a task to limit it to only the AM(s) checked below — everyone else stays unaffected, and every OTHER task keeps working for everyone as before. Turning a task's restriction back OFF opens it back up to everyone immediately. If this hospital also uses Floor Access (above), a checked AM must additionally be assigned there to a restricted case's own Floor/Ward to actually perform it — both need to line up.
Case Tracker & Reports (MIS / Admin / Super Admin only)
Case Tracker import
Upload the hospital's Excel export directly — .xlsx or .csv both work, no need to convert. Select several files at once (Ctrl+click / Shift+click) to import them all in one go. Header row needed: regId, procedureName, procedureCode, amount, claimStatus (column order doesn't matter, extra columns are ignored).
Or paste CSV text instead
Browse imported rows
80k+ rows won't render at once — search narrows it down, and Export downloads whatever the search currently matches.
"Complete sheet" ignores the search box above — always the FULL dump for this hospital, plus IPD Number, UHID, this app's own Registration Date, Discharge Date, Discharge Type (Discharge/LAMA/DAMA/Death/Abscond), and Claim Date, pulled in from this app's own case records (Case Tracker itself has no place for these). A row whose Reg ID was never registered in the app still shows up, marked "Registered = No", with those extra columns blank. MIS / Hospital Admin / Super Admin only — same access as the rest of Case Tracker.
| Reg ID | Patient | Card ID | Procedure | Code | Preauth Approved | Claim Initiated | Claim Approved | Claim Paid | Claim status | UTR | Payment date |
|---|
Daily Status Report
Compares the most recent Case Tracker import's status counts against the import before that — captured automatically every time an import completes, so this always shows what changed since the last upload.
Actual Payment Received
Money that has actually landed for these cases — a SEPARATE view from the Group table above (which tracks WHERE a claim currently sits, not whether it's been paid). A "Payment with Deduction" case still shows under its own status group above too (e.g. Query-Pending) — that's correct, it's still being tracked there; this section additionally counts it as money received, using the same Right/Wrong reconciliation already recorded in Claim Review. Click any number below to see the cases behind it.
| Reg ID | Patient | Claim status | Payment | Approved | Paid | Deducted | Claim Review Verdict | Follow-up |
|---|
Status Tags
Every claim status this hospital's Case Tracker data has used, tagged with its "Pending at level" and report group — untagged ones (shown first, highlighted) are new statuses the report can't group correctly until tagged. Level/Group here override the shared default for THIS hospital only; a Super Admin can also update the shared default itself. "TMS me discharge ho chuka?" — Haan = TMS is status par patient ko discharged maanta hai (isse jo case app me abhi Active hai wo "App me discharge baaki" list me aata hai). Nahi = abhi pre-discharge / cancelled. Jab tak koi naya status tag nahi hota use "discharge nahi" maana jaata hai (sirf warning dikhti hai) — naya status aate hi yahan tag kar do. Ye choice sirf is hospital ke liye hai; Super Admin ka shared default sab hospitals ke liye hai.
| Claim status | Level | Group | Payment Status | TMS me discharge ho chuka? | Source |
|---|
Daily Admission Import
Upload the hospital's daily admission register (.xlsx) — UHID, IPD No, Patient Name, Admission Date, Ward, Department columns. Every admission is kept (never overwritten) so a returning patient's older admissions stay available too — this is what powers the UHID picker on the registration form.
Corrections
Override an already-set case field or document status — bypasses the normal one-way flow. Every change is logged below.
🚩 Flagged for Correction
Documents MEDCO (or an admin) has flagged for a second look, newest last — no need to search case-by-case, "Fix" jumps straight into that case's correction form below.
| Patient | Reg ID | Document | Flagged by | Reason | Note |
|---|
Nothing currently flagged.
| Patient | Reg ID | TMS status |
|---|
Correction history
| When | Type | Field | Old | New | By | Note |
|---|
Rejected documents (oversight)
Every document ever marked Wrong, hospital-wide, with the reason if one was given. "Since fixed" means a response to it has since been approved.
| Patient | Reg ID | Item | File | Reason | Remark | Marked by | Rejected by | Status |
|---|
Custom ("Other") Reasons — review & normalize
Every document where MEDCO (or whoever flagged it) picked "Other" and typed their own reason instead of using the fixed list. Read what they wrote, and if it's really one of the listed reasons, re-file it as that — this is what keeps the reason data clean and comparable over time instead of drifting into free text again.
| Patient | Reg ID | Item | Type | What they typed | By | Re-file as |
|---|
Nothing on "Other" right now — every Wrong/Query/Flag reason picked so far matched the fixed list.
Amount Check — app vs TMS Preauth Approved
Per case, what the app expects the claim to be (package price — or, when the code is bed-category stratified, whatever the case's confirmed bed type maps to — plus every add-on the Ayushman Mitra has actually confirmed) versus what the latest Case Tracker import shows Preauth Approved. "Over Expected" means the app expects more than TMS approved — worth checking whether the enhancement/add-on was actually filed, or got cut down. "Not in Tracker" means the case hasn't shown up in a Case Tracker import yet at all.
| Reg ID | Patient | Code | App Expected | Preauth Approved | Gap | Status |
|---|
TMS Mismatch — confirmed in app, not seen on TMS
Two kinds of gap this catches: (1) an add-on procedure MEDCO confirmed, whose code still doesn't show up in this case's TMS procedure code after 24 hours; (2) a bed-category enhancement Ayushman Mitra confirmed was filed, but TMS's own Preauth Approved amount never rose above what it was right before the enhancement, 24 hours on. A later Case Tracker import that actually reflects it clears the row on its own — nothing to dismiss by hand.
| Reg ID | Patient | Type | Details | Confirmed |
|---|
🧪 Procedure Report
Registration date chuno → procedure ka naam ya code likho → Search. Pehle count aur amount (Preauth / Claim / Approved / Erroneous), phir cases ki list; list Excel (CSV) me download ho sakti hai. Main procedure aur add-on dono ek hi search me aate hain.
Reports
Date range + Floor filter below apply to whichever report tab is open. Storage & Volume and Wrong Discharge/Claim default to the last 90 days if you don't pick a range — a wide range on a hospital that's been live a long time can take a moment.
📊 AM Performance
Har Ayushman Mitra ka kaam ek jagah — kisne kitna kiya, kiska kaam atka hai aur kaun kam kaam kar raha hai. Upar wale From/To/Floor yahan lagu nahi hote — is report ka apna filter neeche hai.
–
–
Total Documents Till Date
–
Total Storage Used (this hospital's documents)
–
Avg Weekly Growth (selected range)
| Period | New Cases | New Documents | Avg Docs/Case | Data Uploaded | Avg File Size | Running Total Storage |
|---|
Only Ayushman Mitra / Hospital Admin counted (the only roles with an actual document-upload screen). Correct/Rejected/Query % are of VERIFIED documents only — a still-pending upload doesn't count against anyone yet. A flag needs at least 10 documents to be eligible, so a new staff member's small sample never gets unfairly singled out.
| Staff Name | Role | Total Docs | Correct % | Rejected % | Query % | Avg Docs/Case | Flag |
|---|
Cases Registered/Discharged/Claimed within the selected date range and floor. Top performer in each column gets a 🏆.
| Staff Name | Role | Cases Registered | Cases Discharged | Cases Claimed |
|---|
"Avg Time to Resolve" only counts requests actually REVIEWED by someone else — a self-assigned request (raised on your own floor) resolves instantly and would otherwise make the average meaningless. The second table below is the flip side: how fast whoever reviews OTHER people's pending requests responds.
| Staff Name | Role | Requests (Register) | Requests (Discharge) | Accepted | Rejected | Self-Assigned | Avg Time to Resolve |
|---|
Reviewer speed (reviewing others' requests)
| Staff Name | Role | Requests Reviewed | Avg Time to Resolve |
|---|
| MEDCO Name | Total Flags Raised | Still Open | Resolved |
|---|
| Reg ID | Patient | Field Corrected | Old Value | New Value | Original Actor | Corrected By | Corrected At |
|---|
| Staff Name | Wrong Discharge Entries | Wrong Claim Entries | Total |
|---|
Patient History (MEDCO / MIS / Admin / Super Admin)
Search by Card ID, UHID, or IPD Number — shows every case this patient has ever had at this hospital, even ones registered under a different IPD, by auto-connecting through the Card ID/UHID found on the first match. Package/Amount/Claim Status come from the Case Tracker import where available. A row with no matching case yet (imported into Case Tracker but never registered here) shows as "Not registered" — click it to register it directly, same as anywhere else in the app.
| Reg ID | Date | Floor/Ward | Package | Amount | Claim Status | Status |
|---|
Claim Review (MEDCO / MIS / Admin / Super Admin)
Cases flagged from the latest Case Tracker import. A case with no verdict yet is new — mark it Right or Wrong (a remark is required either way).
📁 File Tracking
Discharge hone ke baad case ki physical file yahan aati hai: File mili → Arrange hui → Scan ho gayi → MRD ko bheji. Scan ho jaane ke baad hi claim team claim mark kar sakti hai. Sabse purana discharge sabse upar; Death / LAMA / DAMA / Abscond ko 24 ghante me claim karna hota hai, isliye wo hamesha upar rehte hain.
Is hospital me File Tracking abhi chalu nahi hai — Super Admin se chalu karwao (Setup → Hospitals → Manage).
📋 Reg ID paste karke ek saath mark karo
| Reg ID | Patient | IPD / UHID | Discharge | Claim deadline | File ki sthiti |
|---|
Pharmacy
Billing
Search a case
Look up any case by Reg ID, IPD Number, UHID, or Card ID — including ones already closed out, or still Active.
| Reg ID | Patient | IPD | UHID | Status | TMS status |
|---|
| Reg ID | Patient | IPD | UHID | Status | Day Count |
|---|
💰 Refund
Ayushman patient se jo paise liye gaye (AM ne case me mark kiye), unka refund yahan banta hai: Refund baaki → Refund process (format print hote hi poora). Patient kholo, "Refund Procedure" format check / edit karo aur PDF nikalo. Paisa dena / UTR ka kaam Management / Accounts karte hain — app me nahi.
| Patient | Floor / Ward | Paise liye | Status |
|---|
👤 Mera atka kaam
Today's summary
"Pending" numbers (Has open query, Go for Enhancement, Documents Due) always show the full current backlog/running total — a case marked yesterday and still not resolved stays counted. "Today" numbers (including the floor/ward table's "Enhancement Taken (Today)") reset every day and only count what actually happened today. "Pending Documents" / "Have pending docs" is also daily — every active case counts as pending unless at least one document has been shared for it today; it resets each day and stops counting only once the case is discharged.
🔔 Alerts / Action centre
By floor / ward (active cases only)
Click a floor's name to expand it into its own wards, or switch to "By ward" to see every floor + ward at once.
| Floor | Active cases | Have pending docs | Have open query | Go for Enhancement | Enhancement Taken (Today) | OK Documents (Today) | Add-on Pending | Preauth Pending | Registered today | OT Papers Pending |
|---|
| Floor | Ward | Active cases | Have pending docs | Have open query | Go for Enhancement | Enhancement Taken (Today) | OK Documents (Today) | Add-on Pending | Preauth Pending | Registered today | OT Papers Pending |
|---|
🔩 Implant Bill / Barcode
Jaise hi MEDCO "implant laga hai" bole, patient yahan aata hai. Implant bill aur barcode (sticker ki photo) yahan se attach karo — dono aate hi patient "Aaya" me chala jata hai. Sabse purana pehle dikhta hai; din = MEDCO ke faisle se.
| Patient | IPD / UHID | OT | Implant / Package | Bill | Barcode | Kab se |
|---|
🧾 Final Bill
Patient ka TMS se discharge hone ke baad Accounts Final Bill banata hai. Final Bill aur file scan alag hain — Final Bill banne se scan ya Billing Discharge nahi rukta. CMCH aur CCH — dono Units ke naye discharges.
Is hospital me Final Bill abhi chalu nahi hai — Super Admin Setup me ON karega.
Aaj ka report
Accounts staff-wise (sirf aaj)
Ye report sirf AAJ (IST) ke bills dikhata hai — bill ki date aaj ki. "Bill baaki" abhi ki sthiti hai. Purane din ka data chahiye to "Bill ho gaye" me From–To lagakar ⬇ Excel lo.
HBP Guidelines
Search by code (e.g. "MG040C"), old code, or keyword (e.g. "bronchoscopy", "hernia") — full guideline detail from the same 2,054-code HBP Package Master used to resolve procedure codes everywhere else.
| Code | Package | Name | Specialty |
|---|
🏥 Ward Census
Ward-wise saare patient ek jagah — Ayushman patient app se apne aap aate hain; Cash / Other scheme wale patient department team (Ayushman Mitra) round ke baad yahan naam + bed + category se jodti hai. Ward par click karo to bed category (General Ward / HDU / ICU / ICU with Ventilator) aur payer (Ayushman / Cash / Other scheme) ke hisaab se list dikhegi.
👨⚕️ Doctor-wise: registration ruka hua (MIS / Admin)
| Round | Patient / Procedure | Payer | Bed | Aaj ki category (actual) | IPD / UHID | Reg. date · Din | Consent |
|---|
Register a case
TMS ke case-view page se patient-detail block (aur Package Code wali row) copy karke yaha paste karo — Registration ID, Patient name, Card ID, Registration Date, Pincode aur Procedure Code khud bhar jayenge. IPD/UHID/Floor/Ward manually bharne honge.
Rang ka matlab:narangi = zaroori, abhi khaalihara = bhar diya
1 · TMS se aaya — ek nazar dekh lo
TMS text paste karoge to wallet apne aap aa jayega.
2 · Ye aapko bharna hai
📋 "Sirf registration" case i
Is hospital ke floors/wards abhi set nahi hain — MIS/Admin se Setup me add karwa lo. Tab tak Floor/Ward khaali chhod kar bhi register kar sakte ho; baad me case ke Ward & Bed section se set ho jayega.
⚠ Only a designated Ayushman Mitra can register cases for this hospital — ask your Hospital Admin for access.
Looking for an existing case? Go to Dashboard → Total Cases (or any other number there) — search, floor/ward filters, and Open all live there now.
🧾 Bills & Accounts
💰 Month Report
Registration date ke hisaab se mahina-wise: har mahine ke saare status aur unka paisa — kitna aa gaya (Paid), kitna baaki, kitna kata (Deduction), kitna Rejected. Sab kuch Case Tracker sheet se aata hai, nayi entry nahi karni.
Hisaab: Claim amount = Claim Approved (nahi hua to Claim Initiated), Rejected chhodke. Deduction = Claim − Paid (sirf jin cases me paisa aa chuka). Baaki = jin cases me paisa abhi nahi aaya. Rejected alag dikhta hai, baaki me nahi judta. Status = tumhare tracker ka status group.
🏖 Leave
💰 Enhancement
🔁 Follow-up
Jin patients ka agla cycle / visit package ke rule se aana hai — Chemo pehle. Date master ke rule se banti hai (D1 se), doctor ki sheet se nahi; sheet sirf mel dekhne ke liye hai.
Area & Disease Analytics
Patient kahan se aa rahe hain, kaunsi bimari zyada hai, aur mahine ka trend — TMS address se.
By Area (Address)
TMS address se: District → Block / Post area → Gaon. LOS sirf discharge ho chuke cases ka (kam se kam 1 din). Amount: claim approved, nahi to claim initiated, nahi to preauth approved (tracker data wale cases ka).
Rajya
| District | Rajya | Cases | Active | LOS (din) | Claim amount (₹) | Sabse zyada bimari | ||||
|---|---|---|---|---|---|---|---|---|---|---|
| Low | Avg | High | Low | Avg | High | |||||
Pehle bimari, phir kaun-kaun se district / rajya se patient aaye. Bimari par click karo.
| Bimari | Cases | LOS (din) | Claim amount (₹) | ||||
|---|---|---|---|---|---|---|---|
| Low | Avg | High | Low | Avg | High | ||
| Mahina | Cases | Pichle mahine se | Avg LOS | Avg amount |
|---|
Mahina = registration ki date ke hisaab se. LOS sirf discharge ho chuke cases ka.
Area report load ho rahi hai. Agar kuch nahi dikhta, to is hospital ke liye "Pincode Dashboard" switch band hai — Super Admin se on karwayein.
⬇ Saare cases download karo
Poore hospital ke saare cases ek file mein (CSV ya Excel).
📥 Data Hub
⬆️
Yahan file drop karo ya chuno
TMS ki CSV (kisi bhi separator me) ya Excel — ek saath kai file chun sakte ho.
Hospital ka naam / HOSP code aur tile ka naam paste me mil jaye to app khud pehchan leta hai. Na mile to upar dropdown se chuno.
Tile-wise last load
🕘 Import history
🧹 Purani (stale) rows
TMS ne jab kisi claim ko nayi Reg ID de di, to purani Reg ID wali row ab file me nahi aati par tracker me padi rehti hai aur cases / ₹ double ginwati hai. Ye tool wo rows alag table me bhej deta hai (delete nahi) — "Wapas lao" se laut bhi sakti hain. Pehle hospital chuno.
⚙️ Tiles aur hospital-naam links
TMS Unregistered
Data Audit — galat Reg ID / IPD-UHID nahi
Ye wo cases hain jinki Reg ID card/IPD number jaisi lagti hai (ya 16 ank ki nahi hai), ya jinme IPD aur UHID dono nahi hain. Sahi Reg ID TMS se hi aati hai — jahan Case Tracker me wahi Card ID mila wahan "Suggested" dikhega. Kuch bhi apne aap nahi badalta; aap confirm karoge tabhi.
Cash / Other list me bhi, Ayushman me bhi (ek patient 2 baar)
Wahi IPD / UHID Cash-Other list me chal raha hai aur Ayushman case ke roop me bhi. Zyada tar Ayushman case sahi hota hai — to Cash wali entry "galat entry" mark karke band karo. Dono sahi alag patient hain to chhod do.
| Cash / Other entry | IPD / UHID | Ayushman case | Sudhaar |
|---|
| Reg ID | Patient | Card / IPD / UHID | Floor / Ward | Kya galat hai | Sudhaar |
|---|
IPD Check
IPD Conversion Report
Cases needing IPD/UHID fix (Ayushman Mitra / Admin / Super Admin)
Cases with a blank IPD, or an IPD that looks like a UHID got typed in by mistake (contains letters). Type/confirm the correct UHID for a case, then pick the right IPD from its admission history — same picker as on the registration form.
Pending documents (Verification Queue)
Every case waiting for MEDCO, sorted into buckets — each bucket shows how many cases are waiting and how long the oldest one has been waiting, so you can pick what to do first.
| Patient | Reg ID | Pending documents |
|---|
Discharge confirmations
Cases jinke discharge type + date Ayushman Mitra ne submit kiye hain aur MEDCO ki confirmation baaki hai, longest-waiting pehle. Open karo — paper wahi khulta hai, date/type paper se milao (galat ho to wahin sudhaar do) aur confirm karo.
| Patient | Reg ID | Type | Date | Paper | Submitted by |
|---|
Open queries
Cases where MEDCO has queried a document and no reply has been attached yet, oldest first — open one to see the message and attach a response right there. A case leaves this list as soon as the reply is attached (MEDCO then verifies it in MEDCO Review).
| Patient | Reg ID | Floor / Ward | Open queries |
|---|
Documents Due
Every case MEDCO has flagged as waiting on a document that isn't part of the normal checklist yet, whose due date has arrived (or already passed) and hasn't been cleared — this works the same whether the case is still active or already discharged/claimed. Open a case to see the full note, flag it, attach the document, or clear it.
| Patient | Reg ID | Due date | Note |
|---|
OT Papers Pending
Every case with OT Done marked but not yet confirmed by MEDCO — search case-wise just like Documents Due; mark OT Done from a case, then attach the OT sheet and get it verified Correct here to clear it. A case with an open query still shows separately in Queries even while it's on this list.
Ward:
| Patient | Reg ID | Ward | OT Done marked | Pending | Kya baaki hai | Marked by |
|---|
Special Cases
Every case MEDCO has flagged as needing extra attention — visible only to MEDCO/MIS/Hospital Admin/Super Admin. Once marked, MEDCO can't unmark it themselves; only a Hospital Admin/Super Admin can clear it. A claimed case leaves this list automatically (the mark stays in its history) — use "Show claimed" to see it again.
| Patient | Reg ID | Floor / Ward | Category | TMS Status | Procedure | Marked by | Marked at | Deadline / POD |
|---|
Ready to Claim
5 worklists in one place, split into tabs so a long list (App Discharge Pending especially) doesn't push the others far down the page — pick a tab, the number on it tells you how many cases are waiting there.
Ready
Cases whose latest Case Tracker import shows TMS status "Discharge date updated by Medco" — TMS's own signal that the patient is discharged and the claim can be filed. MIS/Admin/Super Admin see every case, oldest-discharged first (that's the priority order — claim these first), tagged with the Ayushman Mitra who registered each one. An Ayushman Mitra logging in here instead sees just their own cases, as their personal reminder list.
| Reg ID | Patient | Procedure | IPD / UHID | Floor/Ward | Unit | Discharge Date ▲ | Current Status | File | TMS Amount | Day Count | Ayushman Mitra |
|---|
App Discharge Pending
TMS in cases ko already discharged maanta hai (status "TMS me discharge ho chuka" tag wala — Discharge date updated se lekar Claim/Payment tak), par app me ye abhi Active hain. Sabse purana pehle. App me band karne ke liye Open karo: Discharge Summary / Death / LAMA / DAMA / Abscond paper attach → MEDCO verify + type/date confirm → Discharge (koi shortcut nahi — TMS pe discharge date nahi milti, isliye type aur date paper se hi aate hain). Jis case ka TMS status claim-stage me hai (Claim TMS pe ho chuka), uska Claim bhi discharge karte hi "TMS ke hisaab se Claim ho chuka" mark ho jaata hai. "Not registered in app yet" wale case ek-click "Register this case now" se khulte hain.
| Reg ID | Patient | Procedure | IPD / UHID | Floor/Ward | Registered | TMS Status | TMS pe kab se | App me kahan tak | Ayushman Mitra |
|---|
Discharge Mismatch
Cases already discharged in this app (not yet claimed) whose Case Tracker record doesn't show TMS status "Discharge date updated by Medco" — either it shows a different status, or this Reg ID hasn't been imported into Case Tracker at all yet. 🔁 wale cases TMS me wapas pre-discharge status (jaise PPD Approved) par aa gaye hain — TMS pe dobara discharge date aur claim karni hai (app me case reopen nahi hota, status wapas claim-stage par aate hi ye list se hat jaata hai). ✅ wale cases TMS pe claim-stage me hain — bas app me Claim mark karna baaki hai. Visible to everyone, same as Claim Mismatch. Rang: laal = galat process, TMS pe theek karna hai orange = sirf app me Claim mark baaki
| Reg ID | Patient | Procedure | IPD / UHID | Floor/Ward | Discharged By | Discharge Date | Days Since Discharge | Current TMS Status |
|---|
Claim Mismatch
Cases someone marked "Claim Done" in the app (ya "TMS ke hisaab se" auto-claim), but the latest Case Tracker import (taken AFTER that claim was marked) still shows TMS status "Discharge date updated by Medco" — TMS itself never moved forward (claim galat mark hua ya TMS pe file hi nahi hua). 🔁 = TMS me status wapas PPD Approved jaisa pre-discharge ho gaya — TMS pe dobara discharge date + claim karni hai. Status claim-stage par wapas aate hi ye apne aap hat jaata hai. Visible to everyone so it's easy to see who marked which case. Rang: laal = galat process (claim mark hua par TMS aage nahi badha / wapas pre-discharge)
| Reg ID | Patient | Procedure | IPD / UHID | Floor/Ward | Claimed By | Claim Date | Days Since Claim | Current TMS Status |
|---|
TMS Cancelled — Needs Closure
Cases still Active here whose latest Case Tracker import already shows a Cancelled/Rejected TMS status (PPD Rejected, Preauth Cancelled, and similar) — the case is effectively dead on TMS's side and will never get a claim, so it just needs an ordinary Discharge to stop sitting in Active forever. Click Open, then use the normal Discharge button there (no claim needs to follow it). If this is really a genuine re-registration under a fresh Reg ID for the same admission, that still has to go through MIS/Admin's Case Correction, same as any other same-IPD re-registration — this list only helps you notice it needs handling, not decide how.
| Reg ID | Patient | IPD / UHID | Floor/Ward | Registered | Ayushman Mitra | TMS Status |
|---|
CPD Query
Cases whose latest Case Tracker import shows TMS status "Claim Kept Pending by CPD" — the hospital's own "CPD Query" cases, which need a quick response or the claim stalls. Day Count counts from whichever is set — the query date MEDCO enters below, or the date it first showed up here if nothing's entered yet — and keeps climbing every day it's left untouched, so an old query can't quietly get lost.
| Reg ID | Patient | Procedure | Current Status | IPD / UHID | Unit | Query Date | Day Count | Remark | Last updated by | Reverted |
|---|
Meri requests
Raise a Register or Discharge/LAMA/DAMA/Abscond request — if you're assigned to that Floor yourself, it happens immediately; otherwise it waits for that Floor's Ayushman Mitra (or an admin) to accept it. Every request you've raised, and its status, shows below.
Patient ward me admit hai par Ayushman me abhi register nahi hua? Reg ID khali rakhkar Floor + Ward ke saath request raise karo — jab tak register nahi hota, patient us ward ki list me "⏳ Ayushman registration baaki" dikhega (24 ghante baad laal).
Desk = Discharge team karegi (floor se matlab nahi). Ward = us floor ka responsible Ayushman Mitra. Paper baad me bhi attach ho sakta hai — request abhi raise ho jaayegi, Ready tab hogi jab paper verify + MEDCO confirm ho jaaye.
| Type | Patient / IPD | Reg ID | Floor/Ward | Status | Time |
|---|
Review karni hain
Pending Register/Discharge requests for the Floor(s) you're assigned to (or every Floor, for an admin) — oldest first, so the longest-waiting one is easiest to spot.
| Type | Details | Floor/Ward | Requested by | Pending |
|---|
Aaj ki Requests
Floor ki Register aur Discharge requests: kisne raise ki, kisne complete ya reject ki, aur raise karne wale ne dekh li ya nahi. Aaj ki aur abhi chal rahi sab dikhti hain.
Document Review
Every case with at least one Approved or Rejected document — one row per case. Search matches Reg ID, patient, floor, ward, or procedure name/code (partial match — finds a code even inside a longer pipe-separated list).
| Patient | Reg ID | Floor | Ward | Bucket | Approved | Rejected |
|---|
Add a new procedure
First find and select the case this procedure belongs to, then name it and attach its documents.
| Patient | Reg ID | IPD / UHID | TMS status |
|---|
Awaiting your confirmation
Add-on procedure ke files attach ho gaye — Ayushman Mitra (ya admin) confirm karta hai ki procedure sach me hui. MEDCO add-on files check nahi karta.
| Patient | Reg ID | Procedure | Files | Added by |
|---|
Confirmed history
| Reg ID | Procedure | Count | Files | Added by | Confirmed by |
|---|
Daily Investigation Import (CT/MRI/Blood sheet)
Upload the daily CT/MRI/Blood register (.xlsx) — IPD is matched to a registered case; CT/MRI and blood-product columns turn into add-on suggestions in the review list below. Nothing is added automatically — every match still needs a MEDCO Add or Skip.
Unmatched — waiting for a case
These rows' IPD didn't match any registered case at import time — nothing here is lost. The moment a case with this IPD gets registered (or has its IPD corrected), it's picked up automatically. Use Recheck now if you've just fixed a case's IPD by hand, or a case came in some other way (e.g. a bulk import) instead of through Register Case.
| IPD | Patient | Date | Test | Imported |
|---|
Review daily investigation suggestions
Every CT/MRI or blood-product match still waiting for a decision, grouped by case — Add creates a real add-on procedure (goes through the usual MEDCO check, same as adding one by hand); Skip leaves it out.
Case
Add a new procedure
No documents attached yet.
Attach a document
⚠ Set the bed type above before attaching any documents.
Request a document
MEDCO asks for something that was never attached at all — becomes a query for Ayushman Mitra to respond to.