ADT is the core module of Hospital Management Software.
The first thing required in ADT is to search for Medical Record Number (MRN) of the patient and if MRN has not been assigned then assign a new MRN.
It is crucial that th same person should not be assigned two MRNs because half the information about medical records will be lost.
To identify MRN for a patient following information should match:
- Given names
- Surname
- Date of Birth
- Address
This information should be stored in following two tables:
MRN_MEDICALRECORDNUMBER with following fields
| MRN_ID |
int |
| MRN_NUMBER |
varchar(12) |
| MRN_GIVENNAMES |
varchar(50) |
| MRN_SURNAME |
varchar(50) |
| MRN_DATEOFBIRTH |
datetime |
| MRN_ADDRESSLINE1 |
varchar(50) |
| MRN_ADDRESSLINE2 |
varchar(50) |
| MRN_ADDRESSLINE3 |
varchar(50) |
| MRN_STATE |
varchar(50) |
| MRN_ZIPCODE |
varchar(10) |
| MRN_DATECREATED |
datetime |
| MRN_DATEUPDATED |
datetime |
| MRN_UPDATEDBY |
int |
The second table will be MRN_HISTORY. It will have same fields and one more field MRN_DATEARCHIVED. Whenever there is change in a record, the current record should be copied to the history table before updating the record in MRN_MEDICALRECORDNUMBER.