Use Case 3_ Create new entry if hive entry does not exist for a patient

If the <patient_id> source in the <patient> object is not 'HIVE' and the PATIENT_ID source ('MGH') and value ('123') combination do not exist, then a new PATIENT_NUM with value max (patient_num)+1 will be generated. All the PATIENT_NUMs for this patient will receive this value. The new patient number must also be added to the PATIENT_DIMENSION table
Example:
<pid>
<patient_id source="HIVE">528</patient_id>
<patient_map_id source="MGH">123</patient_map_id>
<patient_map_id source="BWH">777</patient_map_id>
</pid>

The rows in the PATIENT_MAPPING table will appear as follows: