Column Name |
Column Datatype |
Column Null Option |
Column Comment |
|
|
XMLDocStorageOid | int | NOT NULL | Primary key to XMLDocStorage table |
LastCngDTime | datetime | NOT NULL | Last Updated Date Time( EA/DSS(UTC) - Current Universal Time Coordinate or Greenwich Mean Time) |
Patient_OID | int | NOT NULL | Foreign key to HPatient(References to HPatient table Object ID column) |
PatientVisit_OID | int | NOT NULL | Foreign key to HPatientVisit(References to HPatientVisit table Object ID column) |
DocumentType | varchar(5) | NOT NULL | Indicates type of document(possible values: AMR - Admission Medication Reconciliation, HML-Home Med List, DMR -Discharge Med Reconciliation) |
DocumentAuthorStaff_OID | int | NOT NULL | Foreign key to HStaff(References to HStaff table Object ID column) |
DocumentAuthor | varchar(187) | NOT NULL | Name of the staff who created or updated the document. |
DocumentStatusCd | smallint | NOT NULL | Indicates status code of the document(example: 1,0) |
DocumentStatus | varchar(25) | NOT NULL | Indicates Status of the document(example: InProgress, Complete) |
DocumentXMLVersionNo | smallint | NOT NULL | XML Version number, indicates version of the schema used |
Comments | varchar(255) | NULL | Comment entered for the list |
DocumentXML | xml | NOT NULL | The XML document which is a snapshot of the state of the widget at the time the medication list was signed |
CollectedDTime | datetime | NOT NULL | DateTime the information was collected |
DocumentDTime | datetime | NOT NULL | DateTime the document was saved |
PrintCounter | int | NOT NULL | Indicates how many times the record was printed(not used at this moment) |
LastPrintedUserOid | int | NULL | HStaff table Object ID of user that last printed the document(not used at this moment) |
LastPrintedDTime | datetime | NULL | DateTime the document was last printed(not used at this moment) |
Suppress | int | NULL | Column indicating if the document needs to be suppressed during new home med list creation. Allowable values: 0 - not suppressed; 1 - suppressed |
HM_XMLDocStorageOid | int | NULL | Column holding the key in the XMLDocStorage table for the Home Med document |
Context | varchar(20) | NULL | Column holding information under which calling Context the document was created. |
EPrescriberSAMLSignature | xml | NULL | Column holding the digital signature in case this document contains electronically prescribed controlled substances |
EntityOID | int | NULL | Entity ID of the user who stored the document |
LastCngDtime | DATETIME | NOT NULL | Current Universal Time Coordinate or Greenwich Mean Time |
|