Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Generate Visit ID in ZEIR ETL #32

Open
csc5k opened this issue Dec 20, 2017 · 0 comments
Open

Generate Visit ID in ZEIR ETL #32

csc5k opened this issue Dec 20, 2017 · 0 comments
Assignees

Comments

@csc5k
Copy link

csc5k commented Dec 20, 2017

We need to add a column to the ZEIR encounters ETL to generate a visit ID to use as a wrapper around encounters that occurred during the same visit.

The PATH team approved the following three data elements as identifying a visit: ZEIR ID, encounter date, facility ID. I.e. all rows with the same ZEIR ID, encounter date, and facility ID would share a single, unique visit ID.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants