Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
|
PtProblemOID | int | NOT NULL | Object ID of Patient's Problem |
ProblemCVEId | varchar(32) | NOT NULL | Common Vocabulary Engine(CVE) ID for the Problem |
AssignedDateTime | smalldatetime | NOT NULL | Date and time(local) Problem was assigned to a patient |
AssignedByName | varchar(188) | NOT NULL | Name of the User that Assigned the Problem(Format First Last, Title) |
ChangeDateTime | smalldatetime | NOT NULL | Date and time(local) the Problem was changed |
ChangedByName | varchar(188) | NOT NULL | Name of the User that Changed the Problem(Format First Last, Title) |
ClosedDateTime | smalldatetime | NULL | Date and time(local) the Problem was closed |
ClosedByName | varchar(188) | NULL | Name of the User that Closed the Problem(Format First Last, Title) |
DisplayName | varchar(254) | NOT NULL | Name of the Problem - used for display on the UI and Reports |
HasClinNotes | smallint | NOT NULL | Are there Clinical Note(s) associated with this Problem |
| | | Allowable Values: |
| | | 0 - False |
| | | 1 - True |
Status | varchar(254) | NOT NULL | Patient Problem Status |
StatusCd | varchar(32) | NOT NULL | Status Code for the Patient Problem Status |
| | | Allowable Values: |
| | | ACTIVE |
| | | ERRONEOUS |
| | | INACTIVE |
| | | RESOLVED |
RankValue | varchar(254) | NULL | Ranked value for the Patient Problem(NULL allowed) |
HasHistory | smallint | NOT NULL | This Problem has a history / has been updated |
| | | Allowable values: |
| | | 0 - False |
| | | 1 - True |
LastCngSeqNo | int | NOT NULL | Number of times this problem has been changed(Initial creation value will be 1) |
Patient_oid | int | NOT NULL | Object ID of the Patient(HPatient) the Problem is assigned to |
AssignedBy_oid | int | NOT NULL | Object ID of the User who Assigned the Problem(HSUser) |
ClosedBy_oid | int | NULL | Object ID of the User who Closed the Problem(HSUser) |
ChangedBy_oid | int | NOT NULL | Object ID of the User who Changed the Problem(HSUser) |
IsPastMedicalHistory | smallint | NULL | Is Past Medical History Problem |
| | | Allowable Values: |
| | | 0 / Null - False |
| | | 1 - True |
SnomedCode | varchar(18) | NULL | SNOMED Code for this Problem |
SnomedDescription | varchar(256) | NULL | SNOMED Description for this Problem |
ImoCode | varchar(15) | NULL | Intelligent Medical Objects(IMO) Code for this Problem(IMO is third party vendor used to look up problems and reutrn SNOMED/ICD10 codes and descriptions) |
IsChronic | bit | NULL | Problem is a Chronic Problem |
| | | Allowable Values: |
| | | 0 / Null - False |
| | | 1 - True |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|
|