person_id in AT and SDS scripts needs moved to after latest_sc_id

Public-Health-Scotland / source-linkage-files

This repo is for the syntax used for the PHS Source Linkage File project

https://public-health-scotland.github.io/source-linkage-files/

Other

4 stars 2 forks source link

person_id in AT and SDS scripts needs moved to after latest_sc_id #924

Closed SwiftySalmon closed 8 months ago

SwiftySalmon commented 8 months ago

person id is a unique identifier of social_care_id and sending_location. This bit of code therfore needs to be after the latest_sc_id function in the script

SwiftySalmon commented 8 months ago

solved in latest pull request when fixing the join in sc AT