Pocket Personal Health Record

Insert into MasterCodes (CodeGroup, Code, Description) Values('GENDER','A','Ambiguous')
Insert into MasterCodes (CodeGroup, Code, Description) Values('GENDER','F','Female')
Insert into MasterCodes (CodeGroup, Code, Description) Values('GENDER','M','Male')
Insert into MasterCodes (CodeGroup, Code, Description) Values('GENDER','N','Not applicable')
Insert into MasterCodes (CodeGroup, Code, Description) Values('GENDER','O','Other')
Insert into MasterCodes (CodeGroup, Code, Description) Values('GENDER','U','Unknown')
Insert into MasterCodes (CodeGroup, Code, Description) Values('MARTIAL','A','Separated')
Insert into MasterCodes (CodeGroup, Code, Description) Values('MARTIAL','B','Unmarried')
Insert into MasterCodes (CodeGroup, Code, Description) Values('MARTIAL','C','Common law')
Insert into MasterCodes (CodeGroup, Code, Description) Values('MARTIAL','D','Divorced')
Insert into MasterCodes (CodeGroup, Code, Description) Values('MARTIAL','E','Legally Separated')
Insert into MasterCodes (CodeGroup, Code, Description) Values('MARTIAL','G','Living together')
Insert into MasterCodes (CodeGroup, Code, Description) Values('MARTIAL','I','Interlocutory')
Insert into MasterCodes (CodeGroup, Code, Description) Values('MARTIAL','M','Married')
Insert into MasterCodes (CodeGroup, Code, Description) Values('MARTIAL','N','Annulled')
Insert into MasterCodes (CodeGroup, Code, Description) Values('MARTIAL','O','Other')
Insert into MasterCodes (CodeGroup, Code, Description) Values('MARTIAL','P','Domestic partner')
Insert into MasterCodes (CodeGroup, Code, Description) Values('MARTIAL','R','Registered domestic partner')
Insert into MasterCodes (CodeGroup, Code, Description) Values('MARTIAL','S','Single')
Insert into MasterCodes (CodeGroup, Code, Description) Values('MARTIAL','T','Unreported')
Insert into MasterCodes (CodeGroup, Code, Description) Values('MARTIAL','U','Unknown')
Insert into MasterCodes (CodeGroup, Code, Description) Values('MARTIAL','W','Widowed')
Insert into MasterCodes (CodeGroup, Code, Description) Values('ADDRTYPE','B','Business')
Insert into MasterCodes (CodeGroup, Code, Description) Values('ADDRTYPE','H','Home')
Insert into MasterCodes (CodeGroup, Code, Description) Values('ADDRTYPE','M','Mailing')
Insert into MasterCodes (CodeGroup, Code, Description) Values('ADDRTYPE','P','Permanent')
Insert into MasterCodes (CodeGroup, Code, Description) Values('NATION','IND','Indian')
Insert into MasterCodes (CodeGroup, Code, Description) Values('NATION','SG','Singapore')
Insert into MasterCodes (CodeGroup, Code, Description) Values('NATION','THI','Thailand')
Insert into MasterCodes (CodeGroup, Code, Description) Values('NATION','CH','China')
Insert into MasterCodes (CodeGroup, Code, Description) Values('NATION','US','US')
Insert into MasterCodes (CodeGroup, Code, Description) Values('NATION','UK','England')
Insert into MasterCodes (CodeGroup, Code, Description) Values('NATION','IR','Ireland')
Insert into MasterCodes (CodeGroup, Code, Description) Values('NATION','FR','France')
Insert into MasterCodes (CodeGroup, Code, Description) Values('VISITTYP','B','Obstetrics')
Insert into MasterCodes (CodeGroup, Code, Description) Values('VISITTYP','E','Emergency')
Insert into MasterCodes (CodeGroup, Code, Description) Values('VISITTYP','I','Inpatient')
Insert into MasterCodes (CodeGroup, Code, Description) Values('VISITTYP','N','Not Applicable')
Insert into MasterCodes (CodeGroup, Code, Description) Values('VISITTYP','O','Outpatient')
Insert into MasterCodes (CodeGroup, Code, Description) Values('VISITTYP','P','Preadmit')
Insert into MasterCodes (CodeGroup, Code, Description) Values('VISITTYP','R','Recurring patient')
Insert into MasterCodes (CodeGroup, Code, Description) Values('VISITTYP','U','Unknown')