Re: BC billing data source was Re: [Gnumed-devel] slave mode scripts

[Karsten Hilbert]

On Tue, Aug 03, 2010 at 10:55:05AM -0700, Jim Busser wrote:

> >>> FIRSTNAME           XXLASTNAME                 912345677300BC    
> >>> 196012251234512345M6       
> >>> ADDRESS_LINE_1_XXXXXXXXXXADDRESS_LINE_2_XXXXXXXXXXCITY_XXXXXXXXXXXXXXXXXXXXBCA2A
> >>>  2A2 604124456760489012340000000002009071307801
> >>> 
> >>> - "PHN" + "Dependent #" + "Carrier ID" (in the above example 
> >>> "9123456773", "00", BC") work together as an identifier
> > 
> > So, "PHN" can be non-unique across either of
> > 
> > - different provinces ?
> > - mother and child ?
> 
> I would ignore (not process) this "Dependent#" field.
> 
> I did some checking, and it seems in BC a corner case about the "00" being 
> instead "66". The provision to designate newborns (as dependent "66" and, in 
> the case of multiple births, "64" ... "63") seems now obsoleted by the 
> ability of the hospital to log into the provincial system and generate a new 
> Personal Health Number. Any such legacy values in Medical Manager would not 
> be to drive the slave.
> 
> The PHN can therefore be taken as unique *within* carrier ID. While the 
> following may be bar fetched, there is no agreement between Canada's 
> provinces to avoid collisions, so it could be possible to exist
> 
>       BC.CA MOH |  Personal Health Number | 90123456780
>       ON.CA MOH | Personal Health Number | 90123456780

So this is what the MSVA parser does to the above record now:

address@hidden:~/Projekte/gm-git/gnumed/gnumed/client/business$ python 
gmCA_MSVA.py ../../data/other/CA-MSVA.txt.test
reading patient data from MSVA file [../../data/other/CA-MSVA.txt.test]
Please enter the required login parameters:
host ['' = non-TCP/IP]:
database [gnumed_v14]:
user name: any-doc
password for "any-doc" (not shown):
port [5432]:
DTO: <cDTO_person @ 151600172: Firstname Xx Lastname (m) 1960-12-25 
00:00:00+02:00>
dto.dob: 1960-12-25 00:00:00+02:00 <type 'datetime.datetime'>
dto.dob.tz: psycopg2.tz.FixedOffsetTimezone(offset=120, name='02:00:00.00')
dto.zip: A2A 2A2
dto.urb: CITY_XXXXXXXXXXXXXXXXXXXX
dto.region: BC
dto.street: ADDRESS_LINE_1_XXXXXXXXXX // ADDRESS_LINE_2_XXXXXXXXXX
{'context': 'p', 'name': u'PHN (BC.CA)', 'value': u'9123456773', 'issuer': 
u'MOH (BC.CA)'}
{'context': 'p', 'name': u'MM (CA) Chart #', 'value': u'6', 'issuer': 'Medical 
Manager (CA) application'}
{'homephone': u'6041244567'}
{'workphone': u'6048901234'}


... where the "BC." part in the PHN name/issuer is taken
from the Carrier ID field of the record.

Karsten
-- 
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346