Quality measure syntax fix

Describe your changes

Please include a summary of any changes. removing LEFT from clinical data quality tables and changing to substring changing data type of source date in data quality tables to string to surface potential non date values in data quality dashboard casting date and string concatenation issue in quality measure (athena) casting date in data quality trend table for join to date table in power bi changing eligibility death date flag values from int to string to match field data type

How has this been tested?

Please describe the tests you ran to verify your changes. Provide instructions or code to reproduce output. run in athena enviro ci testing

Reviewer focus

Please summarize the specific items you’d like the reviewer(s) to look into.

Checklist before requesting a review

[ ] I have added at least one Github label to this PR (bug, enhancement, breaking change,...)
[ ] My code follows style guidelines
[ ] (New models) YAML files are categorized by sub folder and models listed in alphabetical order
[ ] (New models) I have added a config to each new model to enable it for claims and/or clinical data
[ ] (New models) I have added the variable tuva_last_run to the final output
[ ] (Optional) I have recorded a Loom to explain this PR

Package release checklist

[ ] I have updated dbt docs
[ ] I have updated the version number in the dbt_project.yml

tuva-health / tuva