#715: NextD request on mapping payer_type variable --------------------------+----------------------- Reporter: afurmanchuck | Owner: nsmith Type: problem | Status: assigned Priority: critical | Milestone: next-d Component: data-stds | Resolution: Keywords: | Blocked By: Blocking: 713 | --------------------------+-----------------------
Comment (by afurmanchuck): After extensive investigation by KUMC team, Prof. James Campbell & NU team it was decided to '''remove insurance information from ENCOUNTER table'''. Insurance information will be extracted for each patient (not each encounter!) form clarity.COVERAGE_MEM_LIST (in Epic). For each patient following elements will be collected: '''PATID, Insurance, MEM_EFF_FROM_DATE, MEM_EFF_TO_DATE''' Those '''will be added to ENROLLMENT table'''. Please, see all details in new data dictionary in drop box: https://www.dropbox.com/home/diabetes%20project%20(working%20docs)/Definitions_StudySamples%26Variables?preview=Definitions_Part2-2018-11-20-af.docx Updates in corresponding SQL extraction codes will be announced separately. -- Ticket URL: <http://informatics.gpcnetwork.org/trac/Project/ticket/715#comment:27> gpc-informatics <http://informatics.gpcnetwork.org/> Greater Plains Network - Informatics _______________________________________________ Gpc-dev mailing list Gpc-dev@listserv.kumc.edu http://listserv.kumc.edu/mailman/listinfo/gpc-dev