Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
|
PtProblemHistoryOID | int | NOT NULL | Object ID of the Problem History |
ProblemName | varchar(254) | NOT NULL | Name of the Problem |
ProblemParameterCVEId | varchar(32) | NULL | Common Vocabulary Engine(CVE) ID for the Problem |
FieldChanged | varchar(254) | NULL | Name of the field changed |
OldValue | varchar(254) | NULL | Value prior to this change |
NewValue | varchar(254) | NULL | New value given for this change |
ChangeDateTime | datetime | NOT NULL | Date and time(Local) a change was made to the problem information for a patient |
ChangedByName | varchar(188) | NOT NULL | Name of the User making a change to the problem information for a patient(Format First Last, Title) |
StatusCd | varchar(32) | NOT NULL | Status value of the problem |
| | | Allowable Values: |
| | | ACTIVE |
| | | ERRONEOUS |
| | | INACTIVE |
| | | RESOLVED |
LastCngSeqNo | int | NOT NULL | Number of times this problem has been changed(Initial creation value will be 1) |
PtProblem_oid | int | NOT NULL | Object ID of the Problem associated with a Patient(HPtProblem) |
ChangedBy_oid | int | NOT NULL | Object ID of the User who made a change to the problem information(HSUser) |
Patient_oid | int | NOT NULL | Object ID of the patient(HPatient) the problem information is associated with |
IsDateField | smallint | NOT NULL | Is the field that was changed a Date |
| | | Allowable values: |
| | | 0 - No |
| | | 1 - Yes |
Action | varchar(32) | NOT NULL | Change action to the problem information |
| | | Allowable Values: |
| | | REVISED |
| | | ADDED |
| | | NOTE |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|
|
|