What problem does it solve? Healthcare databases accumulate orphaned records, mismatched user types, invalid credentials, and inconsistent scores after migrations, bulk imports, or seed data loading. This Skill systematically audits patient and provider data across all Django models to detect and optionally fix these integrity issues before they corrupt reports or break the UI. ## Core Features & Use Cases - Orphan Detection: Finds Clients, CareProviders, Appointments, Notes, UserResponses, and StripeUsers missing their required parent records, including string-based room_name links between Notes and Appointments. - Credential & NPI Validation: Runs Luhn checksum validation on NPI numbers and checks license, degree, and NPI year fields for expired, future, or inverted date ranges. - Business Rule Audits: Flags unlicensed providers with scheduled appointments, completed appointments without payment, risk screening score mismatches, and crisis-flagged responses lacking follow-up. - Use Case: After a data migration, run the check with --model all --verbose to get a full report of orphaned records and consistency violations, then rerun with --fix to apply safe remediations like deactivating orphans. ## Quick Start Ask the assistant to run a data integrity check across all patient and provider models and report any orphaned records or invalid credentials.
