Last Updated: 7/22/2025 8:42:49 PM
Intergy Version: 22.00.00.00
PatientProblemHistory
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'. |
| HistoryCount | INTEGER | 0 | MANDATORY | This is a programmatically generated sequence that keeps tracks of the number of updates made to a 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. |
| Severity | INTEGER | 0 | OPTIONAL | The severity of a problem. Valid values are from 0 to 5. Larger values indicate a more severe problem. |
| 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. | |
| EncounterSID | INTEGER | ? | OPTIONAL | FK - From Encounter |
| ActionCode | CHAR(12) | OPTIONAL | PatientProblemAction lookup code. | |
| 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 | Care plan goals for the problem |
| CarePlanInstructions | CHAR(5000) | Set_To_Empty_String | OPTIONAL | Care plan patient 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 |
| 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 | PatientProblemHistory.SpecialtyCode = Specialty.SpecialtyCode | SET NULL if PatientProblemHistory exists |
| Encounter | PatientProblemHistory.EncounterSID = Encounter.EncounterSID | RESTRICT if PatientProblemHistory exists |
| PatientProblem | PatientProblemHistory.PatientProblemSID = PatientProblem.PatientProblemSID | CASCADE if PatientProblemHistory exists |
| Child Table | Join Phrase | When deleting PatientProblemHistory record... |
|---|