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

[Jim Busser]

The external identifier (for BC.CA) may as well be handled in a consistent a 
way as was being expected for the BC lab results matching...

http://wiki.gnumed.de/bin/view/Gnumed/LabImporters#Auto_match_to_a_specific_existin

dem.lnk_identity2ext_id external_id     <10-digit value of patient's PHN>
dem.enum_ext_id_types   issuer  "BC MOH"
dem.enum_ext_id_types   name    "Personal Health Number"


On 2010-07-30, at 4:40 PM, Jim Busser wrote:

> - record mockup:
> 
> 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
> 
> - format specification:
> 
> *-- MSVAEX30.TXT format
> *--
> *--------------------------------------------------------------------
> *-- First Name          X(20)  No punctuations ( e.g. John Allen)
> *-- MSP Initials        X(02)  e.g. JA
> *-- Last Name           X(25)
> *-- PHN                 9(10)
> *-- Dependent #         9(02)  66 for newborn, otherwise zeros
> *-- Carrier ID          X(02)  Province providing coverage:
> *--                            BC, AB, SA, MB, ON, PQ, OI, NB, NS, NL, YT, 
> NT, NU
> *-- Exempt              X(01)  "X" for exempt, otherwise blank
> *-- Opted-out           X(01)  "H" for Hard (Send payment to patient address)
> *--                            "S" for Soft (Send paymant to office address)
> *--                            Blank for Opted-in
> *-- Visits Used         9(02)  # of MSP visits used this calendar year, form 
> zero up
> *--                            to 12 0r 15 depending on age.
> *-- Birthdate           9(08)  ccyymmdd
> *-- Payee #             9(05)  
> *-- Practitioner #      9(05)
> *-- Sex                 X(01)  M, F
> *-- Chart #             X(08)
> *-- Street 1            X(25)
> *-- Street 2            X(25)
> *-- City                X(25)
> *-- Province            X(02)
> *-- Postal Code         X(09) A0A'b'0A0 or US Zip Code
> *-- Home Phone          9(10) If no area code use 3 leading zeros
> *-- Work Phone          9(10) If no area code use 3 leading zeros
> *-- SIN                 9(09)
> *-- Last Service Date   9(08) ccyymmdd
> *-- Referral Doctor     9(05)
> *--
> *-- Record size = 220 + <CR><LF> = 222 End-of-Record designated by Carriage 
> Return and Line Feed. 
> *-- File is ASCII text - Named "MSVAEX30.TXT"
> *-- X(n) = Aplhanumeric, left justified, padded with blanks
> *-- 9(n) = Numeric, leading zeros

-- Jim