aurora_standard.chhl7mdd
| Field | Type | Null | Default | Key | Extra | Comment |
| sendingapplication | varchar(20) | YES | | | | |
| datetimeofmessage | varchar(20) | YES | | | | |
| messagecontrolnumb | varchar(10) | YES | | | | |
| patientfirstname | varchar(15) | YES | | | | |
| patientlastname | varchar(15) | YES | | | | |
| patientmiddlename | varchar(1) | YES | | | | |
| visitnumber | varchar(10) | YES | | MUL | | |
| postingdatetime | date | NO | | | | |
| transactionid | varchar(10) | YES | | | | |
| transactiondate | varchar(10) | YES | | MUL | | |
| transactiontime | varchar(20) | YES | | | | |
| transactiontype | varchar(10) | YES | | | | |
| transactiondesc | varchar(30) | YES | | | | |
| transactioncode | varchar(10) | YES | | | | |
| transactionqty | varchar(10) | YES | | | | |
| departmentcode | text | YES | | | | |
| orderdbycode | text | YES | | | | |
| orderdbylname | text | YES | | | | |
| orderdbyfname | text | YES | | | | |
| procedurecode | text | YES | | | | |
| procedurecodedesc | text | YES | | | | |
| procedurecodemodifier | text | YES | | | | |
| ndccode | text | YES | | | | |
| assignedlocation | varchar(20) | YES | | | | |
| staffname | varchar(40) | YES | | | | |
| rx_flag | varchar(1) | YES | | | | |
| processed_date | date | YES | | | | |
| processed_batch | varchar(20) | YES | | | | |
| patienttype | varchar(15) | YES | | | | |
| readingNPI | varchar(10) | YES | | | | |
| inventorynumber | varchar(20) | YES | | | | |
| chs_rowID | bigint(20) unsigned | NO | | PRI | auto_increment | |
References