Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PatientProblem
Table Definition Parent Tables Child Tables
Table Definition| Field | Datatype | Default | Null Option | Comment |
|---|---|---|---|---|
| PatientProblemSID | INTEGER | ? | MANDATORY | System generated unique identifier. It is generated using the sequence value for 'Problem'. |
| PracticeID | INTEGER | ? | MANDATORY | FK |
| PatientID | INTEGER | ? | MANDATORY | FK |
| DiagnosisCode | CHARACTER(10) | OPTIONAL | FK | |
| MedcinID | INTEGER | ? | OPTIONAL | Medcin generated unique identifier. |
| SnomedCode | CHARACTER(20) | OPTIONAL | Snomed code that best describes the problem. | |
| OnsetDateString | CHARACTER(8) | OPTIONAL | A string date field that represents the date on which a problem is first noticed. Will be recorded in the form of CCYYMMDD. | |
| ResolvedDate | DATE | OPTIONAL | Date the problem was most recently recorded as resolved in the system. Blank if the problem status is not Resolved. Distinct From ResolvedClinicalDate. | |
| Chronicity | CHARACTER(3) | OPTIONAL | Supported by LookupType ProblemChronicity. Possible values: A - Acute , C - Chronic , ASL - Acute Self-Limiting | |
| ProblemStatus | CHARACTER(1) | OPTIONAL | Supported by LookupType ProblemStatus. Possible values: A - Active , I - Inactive , R - Resolved and E - Entered in Error | |
| Comment | CHARACTER(5000) | OPTIONAL | Free text that describes the problem. | |
| Assessment | CHARACTER(20) | OPTIONAL | System-defined order list. Supported by LookupType ProblemAssessment. | |
| EnteredBy | INTEGER | 0 | OPTIONAL | User who last modified the problem. |
| EnteredOnStamp | CHARACTER(14) | OPTIONAL | TimeStamp of last time problem was modified. | |
| 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. |
| FeatureCode | CHAR(12) | MANDATORY | If a finding is for a specific feature, flag the entry as being for that feature. Current options are OB and empty. | |
| Prefix | CHARACTER(2) | OPTIONAL | System defined. Code representing the Medcin prefix applied to the finding. Allowed values must be defined in this lookup. Field is supported by the lookup types:[MedcinPrefix]. Values are defined in the LookupCode table for the above lookup types. | |
| Severity | INTEGER | 0 | OPTIONAL | The severity of a problem. Valid values are from 0 to 5. Larger values indicate a more severe problem. |
| HighRiskFlag | LOGICAL | Logical_False | OPTIONAL | Indicates if problem is high risk or not |
| SpecialtyCode | CHARACTER(10) | OPTIONAL | FK - Specialty table | |
| CarePlanGoals | CHAR(5000) | Set_To_Empty_String | OPTIONAL | User entered Care Plan Goals for the problem. |
| CarePlanInstructions | CHAR(5000) | Set_To_Empty_String | OPTIONAL | User entered Care Plan Instructions for the problem |
| ResolvedClinicalDate | CHARACTER(20) | OPTIONAL | User entered date when the problem was resolved for the patient. Distinct From ResolvedDate. This is not a date field. It is a 'fuzzy' date field. It will be in the form of 'CCYYMMDD'. The 'DD' and the 'MM' portions are allowed to be zero. | |
| OnsetTime | INTEGER | 0 | OPTIONAL | User entered onset time of problem in seconds starting from midnight. |
| ResolvedClinicalTime | INTEGER | ? | OPTIONAL | User entered time when the problem was resolved for the patient in seconds starting from midnight |
| IsConfidential | LOGICAL | Logical_False | OPTIONAL | Boolean to indicate if the problem is confidential |
| OnsetDateTimeUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off the OnsetDateString and OnsetTime. This field contains the Date, Time and timezone offset. If the OnsetTime is null then the OnsetTime will be set to midnight. | |
| ResolvedClinDateTimeUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off the ResolvedClinicalDate and ResolvedClinicalTime. This field contains the Date, Time and timezone offset. If the ResolvedClinicalTime is null then the ResolvedClinicalTime will be set to midnight. | |
| CreateDateTimeUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off the CreateStamp. This field contains the Date, Time and timezone offset. | |
| EnteredOnStampUTC | DATETIME-TZ | OPTIONAL | This is a denormalized field based off EnteredOnStamp. This field contains the Date, Time and timezone offset. | |
| ConfidentialityLevel | CHAR(2) | OPTIONAL | The field will hold Confidentiality Level of a Problem (based on InteropConfLevel LookupType) | |
| Laterality | CHARACTER(6) | OPTIONAL | Represents the laterality of the Problem Diagnosis. Defined by ProblemLaterality lookup | |
| DateOfDiagnosis | CHARACTER(14) | OPTIONAL | A "fuzzy" timestamp representing the date of the diagnosis of the problem. "Fuzzy" means the timestamp precision is variable. Will be in one the following formats: YYYY, YYYY-MM, YYYY-MM-DD. |
| Parent Table | Join Phrase | When deleting parent record... |
|---|---|---|
| Specialty | PatientProblem.SpecialtyCode = Specialty.SpecialtyCode | SET NULL if PatientProblem exists |
| Diagnosis | PatientProblem.DiagnosisCode = Diagnosis.DiagnosisCode | RESTRICT if PatientProblem exists |
| Patient | PatientProblem.PracticeID = Patient.PracticeID and PatientProblem.PatientID = Patient.PatientID |
CASCADE if PatientProblem exists |
| Child Table | Join Phrase | When deleting PatientProblem record... |
|---|---|---|
| PatientProblemCodeLink | PatientProblemCodeLink.PatientProblemSID = PatientProblem.PatientProblemSID | CASCADE if PatientProblemCodeLink exists |
| PatientProblemHistory | PatientProblemHistory.PatientProblemSID = PatientProblem.PatientProblemSID | CASCADE if PatientProblemHistory exists |