Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
|
PtProblemPatientVisitOID | int | NOT NULL | Object ID of the Patient Visit a Problem is associated with(HPatientVisit) |
PatientVisitName | varchar(254) | NOT NULL | Indicates the patient visit name combination of healthcare unit and date/time. |
ChangeDateTime | smalldatetime | NOT NULL | Date and time(local) the Problem association to a Visit was Inserted / Changed |
ChangedByName | varchar(188) | NOT NULL | Name of the User that Inserted / Changed the Problem |
ChangedBy_oid | int | NOT NULL | Object ID of the User who Inserted / Changed the Problem(HSUser) |
LastCngSeqNo | int | NOT NULL | Number of times this problem has been changed(Initial creation value will be 1). Used for Optimistic locking |
PatientVisit_oid | int | NOT NULL | Object ID of the Patient Visit a problem is associated with(HPatientVisit) |
PtProblem_oid | int | NOT NULL | Object ID of the Problem associated with a Patient(HPtProblem) |
IsTreatingComplaint | smallint | NOT NULL | Problem is marked as a treating complaint for the visit |
| | | Allowable Values: |
| | | 1 - yes |
| | | 0 - no |
IsPrimaryTreatingComplaint | smallint | NOT NULL | Problem is marked as a primary treating complaint for the visit |
| | | Allowable Values: |
| | | 1 - yes |
| | | 0 - no |
IsDispositionDiagnosis | smallint | NOT NULL | Problem is marked as a disposition diagnosis for the visit |
| | | Allowable Values: |
| | | 1 - yes |
| | | 0 - no |
LastCngDtime | datetime | NOT NULL | Last date and time the Problem / Visit association was Inserted or Changed(UTC) |
|
|