Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
|
PtProblemReconcileOId | int | NOT NULL | Object ID of the patients problem reconcile, PrimaryKey |
PtProblemRawDataOid | int | NOT NUll | Object ID of the raw XML for support to find the source data |
PatientVisitOID | int | NOT NULL | Object ID of the Patient Visit(HPatientVisit) associated with the patient whose Problem(s) were reconciled |
PatientOID | int | NOT NULL | Object ID of the Patient(HPatient) associated with the patient whose Problem(s) were reconciled |
ReconcileSeqNo | int | NOT NULL | Reconciliation Sequence number(Unique for an environment). Used for determining the most recent reconciliation for a Patient / Visit combination. |
ReconcileDateTime | datetime | NOT NULL | Date and Time(local) of when the problem reconciliation occurred |
CreatedUserId | int | NULL | Object ID of the user(HSUser) who reconciled the problems. Always valued. Nullable for Porting / No Downtime requirements when column was added |
CreatedUserName | varchar(188) | NOT NULL | Name of the user(HSUser) who reconciled the problem |
LastCngDtime | datetime | NOT NULL | Date and time(UTC) the Problem was reconciled |
|
|