aurora_standard.chhl7ord
| Field | Type | Null | Default | Key | Extra | Comment |
| sendingapplication | varchar(255) | YES | | | | |
| datetimeofmessage | datetime | YES | | | | |
| messagecontrolnumb | varchar(255) | YES | | | | |
| patientfirstname | varchar(255) | YES | | | | |
| patientlastname | varchar(255) | YES | | | | |
| patientmiddlename | varchar(255) | YES | | | | |
| patienttype | varchar(15) | YES | | | | |
| visitnumber | varchar(255) | YES | | | | |
| postingdatetime | datetime | YES | | | | |
| transactionid | varchar(255) | YES | | | | |
| transactiondate | datetime | YES | | | | |
| transactiontime | varchar(255) | YES | | | | |
| transactiontype | varchar(255) | YES | | | | |
| transactiondesc | varchar(255) | YES | | | | |
| transactioncode | varchar(255) | YES | | | | |
| transactionqty | double | YES | | | | |
| departmentcode | varchar(255) | YES | | | | |
| orderdbycode | varchar(255) | YES | | | | |
| orderdbylname | varchar(255) | YES | | | | |
| orderdbyfname | varchar(255) | YES | | | | |
| procedurecode | varchar(255) | YES | | | | |
| procedurecodedesc | varchar(255) | YES | | | | |
| procedurecodemodifier | varchar(255) | YES | | | | |
| ndccode | varchar(255) | YES | | | | |
| processed_date | varchar(255) | YES | | | | |
| processed_batch | varchar(255) | YES | | | | |
| admissiontype | varchar(255) | YES | | | | |
| readingNPI | varchar(10) | YES | | | | |
| inventorynumber | varchar(20) | YES | | | | |
References