#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 campbell):
Alona, Abel, Mei Liu and I had a discussion yesterday what Northwestern
needs for insurance coverage data from each of our sites for purposes of
the next-D trial. Abel confirmed that a chronological history file by
patient with a list of all insuror policies that have had contracts with
the patient account would be the optimal data for their purposes. This
would mean accessing the billing office records for each patient and
generating a table such as below with mapping to the carrier
classification provided by Alona in the past. I have attached an exemplar
to this ticket and ask Abel to confirm that this indeed is it for their
purpose? I have code for those sites with Epic billing if you would
bnefit from the SQL
Jim
PATIENT_NUM COVERAGE_NAME PAYOR_NAME PAYOR_CLASS
EFFECTIVE_DATE TERMINATION_DATE
NNNNNN EYEMED VISION CARE EYEMED VISION CARE 5 1/1/2008
0:00 (null)
NNNNNN MEDICARE PART A ONLY MEDICARE 1 10/1/2011 0:00
(null)
NNNNNN BC BLUECARD PPO PLAN BCBS 6 1/1/2012 0:00 3/31/2014
0:00
NNNNNN BCBS NETWORK BLUE BCBS 6 4/1/2014 0:00 (null)
--
Ticket URL:
<http://informatics.gpcnetwork.org/trac/Project/ticket/715#comment:26>
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
