Table creation on patient_account based on source_target_mapping_specification excel

Introduction: By creating a table of patient_account related details of patients by uploading a file serves several critical purposes, enabling better healthcare delivery and efficient management of Centralized Account Information by providing consolidates account data into a single table, making it accessible for analysis, reporting, appointment scheduling, medication supply, and treatment tracking.

 

Requirement:

 

Create SQL code to create the target table(patient_account) from the source table(purgo_playground.pa_account) as per the attached excel where target table name is ‘patient_account’ which should have schema as per Column Name, Datatype and Logic in the attached excel.[^source_target_mapping_specification.xlsx]

 

Expected Output: SQL to create table purgo_playground.patient_account, drop the table if already exist.