Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
|
PtProblemReconcileDetailOid | int | NOT NULL | Object ID of the patients problem reconcile detail instance |
CreatedUserId | int | NULL | Object ID of the User who reconciled the problem information(HSUser table) |
PtProblemReconcileOId | int | NOT NULL | Indicates the object ID of the patient problem reconcile that is related to the reconcile. |
ProblemName | varchar(255) | NOT NULL | Name of the problem to be reconciled |
ProblemStatusCode | varchar(32) | NOT NULL | Status code of the problem being reconciled(e.g. ACTIVE, INACTIVE, COMPLETE, ERRONEOUS) |
ProblemStatus | varchar(254) | NOT NULL | Status of the problem being reconciled |
ProblemOnsetDate | varchar(32) | NULL | Onset date of the problem. Value could be an actual date or 'fuzzy'(e.g. childhood) |
Comments | varchar(254) | NULL | User entered information regarding the problem |
ReconcileCodeType | varchar(32) | NULL | Type sent on the CCD document(eg. SNOMED) |
ReconcileCode | varchar(32) | NULL | Code used to reconcile the problem |
PtProblemOid | int | NULL | Indicates the value stored as a result of a one-to-one relationship between HPtProblemReconcileDetail and HPtProblem |
DocumentRootID | varchar(256) | NULL | Root ID of the CCD document |
DocumentIDExtension | varchar(128) | NULL | Document ID extension of the CCD document |
DocumentIDAssigningAuthority | varchar(256) | NULL | Assigning Authority / Organization that created the CCD document. |
DocumentCreationTime | varchar(32) | NULL | Date and time(Local) the document was created. |
LastCngDtime | datetime | NOT NULL | Date and time(UTC) this information was Inserted |
|
|