L2 Validations · Load & process
L2 Validations · Review evidence
L2 Validations · Codability summary
PCC Connect
Find a patient
Search every facility at once by Patient ID, name, room or MRN. Results are limited to patients on census in the month set in step 2, so widen that month if someone you expect is missing. PointClickCare has no cross-facility search, so each facility is a separate live call — that is why this is a button rather than search-as-you-type. Steps 1 to 3 below still work if you would rather browse.
1. Pick a facility
Or type an ID directly:
2. Choose a month
Shared by everything below — the patient list (step 3) is filtered to this facility's patients whose actual admission/discharge dates overlap this month, and DIRECT, DERIVED and the Patient Record all run against this same month too.
3. Pick a patient
Or type an ID directly:
MARTAR case file
What MARTAR already holds for this Patient ID: the cleansed record built from the filed MAR/TAR PDF, who owns the coding and billing, every document filed against them, and who has looked before. Read straight from MongoDB, so it still answers when PointClickCare is unreachable.
4. DIRECT columns
5. DERIVED columns
6. Patient Record — TAR or MAR
Census renders as a Sun-Sat month calendar (day-status codes A/RA/D/L/H/BH/T/P,
with a legend of counts); treatments render as one card per order with a Daily Schedule grid,
using the Year/Month from step 2 above. TAR shows every /medications order
unfiltered (PCC has no separate treatment-order endpoint). MAR filters to
medication-classified orders (a heuristic — PCC has no real MAR/TAR discriminator field) and
adds a real Immunizations section. Both also show an Other Patient Details section
(Vital Signs, Emergency Contacts, Allergies, Diagnostic Reports) — general clinical/demographic
data that isn't MAR/TAR-specific. Every value comes straight from the live PCC API; fields
PCC doesn't expose at all are shown as N/A rather than guessed.
Dashboard
Uploads
Drop PDFs or a folder of PDFs here
Files picks individual PDFs · Folder pulls every PDF inside (recursive). Drag-and-drop supports both.
Loaded files
| File name | Size | Status | Rows | Actions |
|---|
No files uploaded yet
Drop PDFs above or click Browse to get started.
Results
No extracted data yet
Upload PDFs and run processing from the Uploads tab.
From archive
Views
No patient loaded yet
On the Results tab, click View on any row to open that patient here.
Extraction rules
Each rule runs once per patient block. between grabs text from
start to end. regex uses a regex with
group / flags. fallbackEnd is an optional
list of alternative end markers.
Settings
Archive
When on, the original PDF and its index (patient list + page ranges) are pushed to every enabled SFTP site after processing. Turn off during testing.
SFTP destinations
No SFTP destinations yet. Add one to start archiving.
Index orphan PDFs
Find PDFs on pull-mode SFTP sites that aren't indexed in MongoDB yet, pull each one through the browser, run the same extraction pipeline as manual uploads, and push the resulting index back to the same site.
Purge Document Vault
Deletes every document in the Document Vault — the archived copy on each SFTP destination included (— on file). Organizations, facilities, categories, dictionaries and keyword lists are kept, as is everything outside the Vault. Cleansing and Operations will show no source documents until new files are uploaded. This cannot be undone.
RCM Inferences (Claude)
Configuration for the RCM Inferences button in the
Form View (next to Medical Conditions). Ports the Medicare Billing
Analyzer's prompt to Claude and returns Claim Routing & Bundling,
Part B Rationale, and Part A Rationale. API keys are stored on the
server in data/rcm_settings.json.
Upload files
.XLSX / .XLSSelect one or more Excel workbooks individually. Drag & drop works too.
Upload folder
DIRECTORYPick an entire folder — all Excel files inside will be loaded at once.
Nothing merged yet
Upload at least one Excel file, then click Merge workbooks to see the combined output here.
No inferences yet
Upload and merge your workbooks (including at least scrub, code, and bill), then come back here to run the claim analysis.
Reports
No results yet
Pick filters above and click Run report to query the MongoDB archive.
Summary
Detail
Danger zone
scrub_rows, code_rows, bill_rows, import_batches, and clears the rcm inference payload on every patient document. Intended for dev/test use.Reporting Engine
EDI Analyzer ·
Drag & drop 837 files here
or
Accepted extensions: .837 .txt .edi .dat .x12 — also pasted text bodies.
Uploaded 837 files
| File | Uploaded | Claims | Total $ | Issues | Payers | TOB mix |
|---|
EDI Analyzer ·
Upload an 837 file to see analysis here.
EDI Analyzer ·
Loading inferences…
EDI Analyzer ·
| Claim # | Patient | Payer | TOB | Stmt period | Adm/Disch | Principal Dx | DRG | Billing NPI | Lines | Charge | Issues |
|---|
No claims yet — upload an 837 file.
EDI Analyzer ·
Drag & drop 835 (ERA) files
or
Uploaded 835 files
| File | Uploaded | Payer | Pay date | Method | Payments | Total paid | Trace |
|---|
EDI Analyzer ·
| Patient ctrl # | Patient | Payer claim # | Stmt period | Billed | Paid | Pt resp | Adj | Status | Match |
|---|
Recent postings
| Posted at | Claim # | Patient | Billed | Paid | Pt resp | Match |
|---|
EDI Analyzer ·
Required segments
Format checks
Code-list checks
Balancing
Standard Operating Procedures
| SOP code | Title | Owner | Action | Files | Source | Actions | |
|---|---|---|---|---|---|---|---|
| Loading… | |||||||
Add SOP entry
SOPs · Seed & admin
Document Vault
| Org ID | Document | Organization | Facility | Category | Patient | Month | Size | Uploaded | Actions |
|---|---|---|---|---|---|---|---|---|---|
| Loading… | |||||||||
MARTAR uploads
| Org ID | Monthly file | Sub-facility | Month | Type | Pages | Patients | Filed | Actions |
|---|---|---|---|---|---|---|---|---|
| Loading… | ||||||||
Upload to Document Vault
Bulk upload
File types
Every type is accepted. Click a type to show only those rows.Choose files
Pattern:Category_Organization_Sub-facility_Month.ext
— e.g. Rejected_Foltscare LLC_WeCare at Sycamore
Rehabilitation and Nursing_5-2026.xlsx. Order doesn't
matter; any part the filename omits can be filled in below.
Filing plan
| File | Organization & sub-facility | Category | Month | Patient |
|---|
Upload log
Dictionaries
Organization tree —
Groups sit above organizations for administration only — they do not change what any user can see. Every site carries an Org ID, which bulk upload also recognises in filenames. Codes never change; the tree never deletes — mark a site inactive instead.
Organizations
Facilities
Keywords —
Filename aliases —
How a spelling that appears in filenames maps to an entity — "Foltscare LLC" → We Care (FOLTSCARE, LLC). Bulk upload consults this first, so one entry fixes every future file that spells it the same way. Corrections made in the bulk-upload log land here automatically.
Categories
Cleansing · Billing Workflow patients
Select an organization to begin
Cleaning is scoped to a single organization at a time. Pick one above — the selection stays locked until you click Change, so you can focus on that org through your session.
Patient Lookup
Operations · Coding
Operations · Billing
Payment Tracking Sheets
Sheet
Payment Tracking · Dashboard
Payment Tracking · Reports
Generated for the scope below Not generated yet Generated, but no data in this scope
Which uploaded sheets to read. None selected = all of them.
Sets From/To to that whole month.
Advanced options Which date the period uses, how claims are counted, the estimate rate, and more. Each report sets these itself.
Each report sets this itself.
One row per facility, payer, status…
Adds a column per month, quarter or year.
A column per payer, status… instead of per period.
Needs a period with both ends set.
Lines that share this number count as one claim.
The rest roll into one Other row.
Expected Payment = what is still owed × this rate. It is a guess, not a contracted amount.
Or set a different estimate rate per aging bucket
Live Excel charts under each breakdown, every form a chart can be read as, over one block of numbers. The PDF gets a charting section. Turn it off for tables only.
FACILITIES
FACILITY BREAKDOWN
Claims, Collections & Expected Payment (estimate)
CHARTING
Several readings of the same numbers.
Upload Payment Tracking Sheet
PTS column schema (41 columns)
Coverage & retention
Did it arrive?
Nothing is expected until you say so — an expectation nobody set is not a gap.How long documents are kept
Per category, in months. A MAR does not carry the same obligation as a billing export.Past its retention period
Reported only — nothing here deletes anything.Operations Insights
Time left to file
Measured from date of service against the payer's window. A claim past it can no longer be billed.How long work has been sitting
Time in the current stage.Who is carrying the work
Claims with no facility
Their organisation or facility has been deleted, so no other screen can reach them.Claims Upload
Where these claims belong
Filed in the Document Vault under this site, and stamped on every claim line.The file
.xlsx, .xlsm or .csvResult
Download rejected rowsClaims sources
A source with no field map cannot read a file — upload one export from it and define the map once.Define a claims source from this file
Say which PTS field each column holds. The columns you map become the fingerprint that recognises the next file from the same place.Upload history
Every claims file loaded — who, when, from where, and what it produced.Payment Tracking · Insights
Payment Entry
Claim
Posting history
Nothing is deleted — a reversal is its own entry.Recent postings
Users
| Name | Role | Modules | Organizations | Last login | Actions | |
|---|---|---|---|---|---|---|
| Loading… | ||||||
Add user
Settings · SFTP destinations
| Name | Host · user | Path prefix | Status | Auto-push Vault | Actions |
|---|---|---|---|---|---|
| Loading… | |||||