Active veteran cases
Active cases
—
Services logged
—
Lifetime total
Outstanding medical debt
—
At cap or over
—
Blocked from new services
All cases
| Case ID | Veteran | BIQ ID | Cap remaining | VA claim | Lien |
|---|---|---|---|---|---|
| Loading veterans… | |||||
🔵 tbl_Veterans
case_idPKVARCHAR(50)
biq_idVARCHAR(50)
first_nameVARCHAR(100)
middle_nameVARCHAR(100)
last_nameVARCHAR(100)
team_leader_idFK→TeamLeadersUUID NOT NULL
ssn_encryptedTEXT
lien_signedBOOLEAN
lien_signed_dateDATE
service_capNUMERIC(10,2)
statusVARCHAR(50)
created_atTIMESTAMPTZ
🟢 tbl_Services
service_idPKUUID
case_idFK→VeteransVARCHAR(50)
service_dateDATE
service_typeVARCHAR(100)
provider_subVARCHAR(64) NOT NULL
provider_nameVARCHAR(100)
costNUMERIC(10,2)
notesTEXT
created_atTIMESTAMPTZ
🟡 tbl_Payments
payment_idPKUUID
case_idFK→VeteransVARCHAR(50)
payment_dateDATE
amountNUMERIC(10,2)
sourceVARCHAR(100)
balance_afterNUMERIC(10,2)
distribution_statusVARCHAR(50)
⚫ tbl_VA_Claims
claim_idPKUUID
case_idFK→VeteransVARCHAR(50)
monday_idVARCHAR(50)
filed_dateDATE
statusVARCHAR(50)
award_amountNUMERIC(10,2)
denial_reasonTEXT
last_checkedDATE
Table Relationships
tbl_Veterans.case_id → tbl_Services.case_id (1:Many)
tbl_Veterans.case_id → tbl_Payments.case_id (1:Many)
tbl_Veterans.case_id → tbl_VA_Claims.case_id (1:1)
tbl_VA_Claims.monday_id → Monday.com (External)
Find a veteran
User Management
Accounts are disabled, never deleted — service history keeps its provider names.Create account
| Name | Role | Status | Active | ||
|---|---|---|---|---|---|
| Loading… | |||||
Service Catalog
The master list of services the clinic offers, grouped by department. Services are never deleted — deactivated, so past records stay intact.
⏱ Durations are placeholders pending confirmation with the doctors (X-ray views: 15 min) — edit any row once real timings are known. Duration drives how long each appointment blocks on the calendar.
Loading…
DBQ Forms
Blank DBQs available to the clinic. Adding a new version of a form supersedes the old one — nothing is ever deleted. Verify every form number against va.gov before loading it.
| Form | VA form no. | Version | Revised | Status | Manage |
|---|---|---|---|---|---|
| Loading… | |||||
Superseded — replaced by a newer version; retained, hidden from the default list.
Inactive — withdrawn by an administrator; retained.