katy-sadowski
commented
5 months ago btw I checked the test failures - i was able to fix 3 of them by updating the provider ID datatype in one of the seeds, and NULLing out some 0s they had put in the payer ID foreign key column. the member ID failure seems to be a data issue (i had marked it as an FK due to the note here: https://github.com/synthetichealth/synthea/wiki/CSV-File-Data-Dictionary#claims-transactions). i'll keep looking into this, and if there's no clear solution we can probably just remove the test.
@katy-sadowski I thought it would be easier to get some additional stage models into your branch (incorporating your macro and pre commit requirements) as opposed to a PR directly into main (with those files copied in anyway).
The additional models are conditions, imaging_studies, immunizations, medications, observations, organizations, payer_transitions, payers, procedures, providers and supplies.
The additional models are able to run and pass most tests (with some claims/claims_transaction fk issues on member_id and payer_id) which seem to be FK issues with the seed data as opposed to structural issues. If I goofed something up there and its actually structural let me know :)