Update the logic in sql script of existing table based on source_target_mapping_specification excel

Introduction: This task is to enhance and update the existing SQL transformation logic for the pat_account table in alignment with the new data mapping rules defined in the source_target_mapping_specifications.xlsx file. This update ensures that all source-to-target field mappings, transformation rules, and conditional logic are consistently applied as per the latest business requirements. The changes will improve data quality, consistency, and downstream reporting accuracy.

 

Requirements: Update the SQL script in the pat_account_sql_script to modify the transformation rules for the columnsprescriber_id, patient_sf_id, and hash_keyonly and remain script unchanged. 3 columns changeable and additionally, implement new logic for the last_modified_date column as per the definitions provided in the excel file. [^source_target_mapping_specifications.xlsx]