aurora_standard.chhl7opd
| 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 | | | | |
| visitnumber | 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 | | | | |
| assignedlocation | varchar(255) | YES | | | | |
| staffname | varchar(255) | YES | | | | |
| rx_flag | varchar(255) | YES | | | | |
| processed_date | varchar(255) | YES | | | | |
| processed_batch | varchar(255) | YES | | | | |
References