Table 1.

 Pharmacy Data                     Medical Data                      Hospital Data
                                                                                        
   Format:                            Format:                             Format:

    NCPDP                            HCFA 1500                             UB 92
                                                                                          
   Source:                            Source:                             Source:

Retail pharmacies                 Physician offices                      Hospitals
                                                                                           
   Volume:                            Volume:                             Volume:

(# electronic claims 2000)         (# electronic claims 2000)          (# electronic claims 2000)
   1,814,000,000                      789,000,000                         399,000,000
                                                                                         
  Key Data Elements:                 Key Data Elements:                  Key Data Elements:

Encrypted patient ID               Encrypted patient ID                Encrypted patient ID
Patient age                        Patient age                         Patient age
Patient gender                     Patient gender                      Patient gender
Prescription date                  Service date                        Admission date
Prescription name                  Diagnosis (ICD9 code)               Discharge date
Quantity dispensed                 Procedure (CPT4 code)               Diagnosis (ICD9 code)
Days supply                        Physician                           Procedure (CPT4 code)
Refill flag                        Payor                               Diagnosis related group (DRG code)
Prescribing physician              Location of care
Payor                              Amount charged ($)                  Physician
Pharmacy                           Amount paid ($)                     Payor
Amount charged ($)                                                     Location of care
Amount paid ($)                                                        Amount charged ($)
                                                                       Amount paid ($)