Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PatientClinicalSummary
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| ClinicalSummarySID | INTEGER | ? | MANDATORY | System-generated unique identifier of the patient clinical summary. Generated using the ClinicalSummary sequence. |
| PracticeID | INTEGER | ? | MANDATORY | FK |
| PatientID | INTEGER | ? | MANDATORY | FK |
| MedcinID | INTEGER | 0 | MANDATORY | Medcin ID that uniquely identifies the finding. Note - may be derived by MedicinFinding table but does not have to exist in that table. |
| FirstFindingSID | INTEGER | ? | MANDATORY | FK - EncounterFinding. Finding associated with first report of clinical summary. |
| CurrentFindingSID | INTEGER | ? | MANDATORY | FK - EncounterFinding. Current encounter finding record. Only one encounter finding record may be current. It will be the encounter finding record associated with the "signed" patient encounter that occurred most recently. |
| RecordStatus | CHARACTER(1) | Record_Status_Active | MANDATORY | Record status of the patient clinical summary. Allowed values must be defined in RecordStatus lookup type. |
| SummaryType | CHARACTER(8) | MANDATORY | Classifies the patient clinical summary by type of history (e.g. medical, surgical, social, family). Allowed values must be defined in ClinicalSummaryType lookup type. | |
| Prefix | CHARACTER(20) | MANDATORY | Prefix which modifies Medcin finding ID. | |
| TimeStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was last written. | |
| LastUser | INTEGER | ? | OPTIONAL | User ID of user that last wrote the record. |
| CreateStamp | CHARACTER(14) | OPTIONAL | System generated date/time stamp record was created. | |
| CreateUser | INTEGER | ? | OPTIONAL | User ID of user that created the record. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| EncounterFinding | PatientClinicalSummary.FirstFindingSID = EncounterFinding.EncounterFindingSID | RESTRICT if PatientClinicalSummary exists |
| EncounterFinding | PatientClinicalSummary.CurrentFindingSID = EncounterFinding.EncounterFindingSID | RESTRICT if PatientClinicalSummary exists |
| Patient | PatientClinicalSummary.PracticeID = Patient.PracticeID and PatientClinicalSummary.PatientID = Patient.PatientID |
CASCADE if PatientClinicalSummary exists |
| Child Table | Join Phrase | When deleting PatientClinicalSummary record... |
|---|---|---|
| EncounterFindingHistory | EncounterFindingHistory.ClinicalSummarySID = PatientClinicalSummary.ClinicalSummarySID | SET NULL if EncounterFindingHistory exists |
| EncounterFinding | EncounterFinding.ClinicalSummarySID = PatientClinicalSummary.ClinicalSummarySID | SET NULL if EncounterFinding exists |