Integrity certificate for Hospital encounters, diagnoses and claims
Re-run against these exact files.

Every line below was measured, not asserted. The CSVs are right here and the checks are ordinary joins.

  PASS  patients.patient_id: 0 duplicate(s), 0 null(s)
  PASS  providers.provider_id: 0 duplicate(s), 0 null(s)
  PASS  encounters.encounter_id: 0 duplicate(s), 0 null(s)
  PASS  encounters.patient_id -> patients.patient_id: 0 orphan(s) of 4,737 rows
  PASS  encounters.provider_id -> providers.provider_id: 0 orphan(s) of 4,737 rows
  PASS  diagnoses.diagnosis_id: 0 duplicate(s), 0 null(s)
  PASS  diagnoses.encounter_id -> encounters.encounter_id: 0 orphan(s) of 8,427 rows
  PASS  diagnoses.patient_id -> patients.patient_id: 0 orphan(s) of 8,427 rows
  PASS  prescriptions.prescription_id: 0 duplicate(s), 0 null(s)
  PASS  prescriptions.diagnosis_id -> diagnoses.diagnosis_id: 0 orphan(s) of 5,539 rows
  PASS  prescriptions.encounter_id -> encounters.encounter_id: 0 orphan(s) of 5,539 rows
  PASS  prescriptions.patient_id -> patients.patient_id: 0 orphan(s) of 5,539 rows
  PASS  lab_results.lab_id: 0 duplicate(s), 0 null(s)
  PASS  lab_results.encounter_id -> encounters.encounter_id: 0 orphan(s) of 14,946 rows
  PASS  lab_results.patient_id -> patients.patient_id: 0 orphan(s) of 14,946 rows
  PASS  claims.claim_id: 0 duplicate(s), 0 null(s)
  PASS  claims.encounter_id -> encounters.encounter_id: 0 orphan(s) of 4,737 rows
  PASS  claims.patient_id -> patients.patient_id: 0 orphan(s) of 4,737 rows
  PASS  no row is dated before the row it belongs to

19 checks, 19 passing.
Generated by Misata Studio -- https://www.misata.studio
