The tables behind Clinical Trial Management

Use the patient number for human identity checks and the record references for relationships. An encounter belongs to one patient and names one clinician. The attached clinical evidence belongs to its encounter, while consent, care tasks and payments belong directly to the patient. People connects to Users for account identity; the effective dates on privileges and care-team assignments add timing to those relationships.

1. Users and People. Establish accounts and staff records before assigning clinicians or task owners.
2. Patients. Bring patient numbers and assigned clinicians into the registry, checking duplicates before visits are linked.
3. clinical privileges and care team assignments. Enter professional standing and patient-specific access with evidence and effective dates.
4. Consents and Encounters. Bring purpose-specific documents and visit history against known patients.
5. clinical notes, Observations, Specimens and pharmacy dispensations. Link clinical evidence to the correct encounter.
6. care tasks, Charges and Payments. Add follow-up and financial records after their parent patient or encounter is present.