Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
ClinicalCase
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| ClinicalCaseSID | INTEGER | ? | MANDATORY | System generated unique for the records on this table. |
| RecordStatus | CHARACTER(1) | MANDATORY | Record Status: Active (A), Inactive (I) | |
| CaseType | CHAR(15) | OPTIONAL | Case Type: Pregancy | |
| PracticeID | INTEGER | ? | MANDATORY | FK - Practice table. |
| PatientID | INTEGER | ? | MANDATORY | FK - Patient Table |
| ManagedByPracticeFlag | CHARACTER(1) | OPTIONAL | Y - Practice managed this case N - Practice did not manage this case Example: One type of case is an OBPregnancy. When we record past pregancies, we want to record pregnancies not managed by this practice. In those cases, the value will be 'N'. | |
| StartDate | DATE | OPTIONAL | Date of registeration of this case. This date can be blank if the pregnancy was not handled in this practice. I.e., if this was just a reported past pregnancy. | |
| EndDate | DATE | OPTIONAL | End Date is the date when this case was finally signed off. This date can be blank if the pregnancy was not handled in this practice. I.e., if this was just a reported past pregnancy. | |
| 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... |
|---|---|---|
| Patient | ClinicalCase.PracticeID = Patient.PracticeID and ClinicalCase.PatientID = Patient.PatientID |
RESTRICT if ClinicalCase exists |
| Child Table | Join Phrase | When deleting ClinicalCase record... |
|---|---|---|
| OBPregnancy | OBPregnancy.ClinicalCaseSID = ClinicalCase.ClinicalCaseSID | CASCADE if OBPregnancy exists |