aurora_standard.chhl7eud
| 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 | | | | |
| transactiondate | date | YES | | | | |
| transactiontime | varchar(20) | YES | | | | |
| transactiontype | varchar(10) | YES | | | | |
| transactiondesc | varchar(30) | YES | | | | |
| transactioncode | varchar(10) | YES | | | | |
| transactionqty | varchar(10) | YES | | | | |
| processed_date | date | YES | | | | |
| processed_batch | varchar(10) | YES | | | | |
| chs_rowID | bigint(20) unsigned | NO | | PRI | auto_increment | |
References