- prescriptions table: not necessarily taken, just prescribed.
ed = emergency department ds = discharge summary
Each table has patient id (NRIC) or case id, an id for each casevisit.
Use caseid to match tables.
NRIC table header can b idnumber or patientidentificationnumber.
case id table header is caseidenificationnumber
Save data to /Data/common so whole team can share data.