select statement
From: Steven R Fuller <srfuller_at_doitnow.com>
Date: 1998/01/24
Message-ID: <6ajffs$680$2_at_usenet48.supernews.com>#1/1
ptc.dispensing_fee_amt_submit,
ptc.contract_dispense_amt_resp,
ptosh.first_date_of_fill,
ptosh.order_status_cd,
ptosh.vials_used,
ptosh.vials_patient_year,
AND ptc.compno = ptm.compno
AND ptc.acctno = ptm.acctno
Steven R Fuller
HDS - Mckesson
Information Systems
9700 N. 91st St.
Scottsdale, AZ 85258
ph. 602-314-7143
fax 602-314-7050
sfuller_at_hdsinc.com
Received on Sat Jan 24 1998 - 00:00:00 CET
Date: 1998/01/24
Message-ID: <6ajffs$680$2_at_usenet48.supernews.com>#1/1
SELECT DISTINCT
/* INDEX (ptc) INDEX (ptosh) INDEX (ptm) INDEX (pcp) INDEX (cyc) INDEX (pyc) INDEX (dep) INDEX (phm) INDEX (bxc) INDEX (ptf) */ ptc.acctno, ptc.adm_cust_no, PTC.ADM_CUST_NO, ptc.bin_no, ptc.cap_cd, ptc.carrier_no, phm.chain_code, ptc.claim_detail_gnrtd_id, ptc.claim_type_cd, pcp.closed_contact_cd_dt, pcp.contact_cd, pcp.contact_cd_status, pcp.contact_date, pcp.contact_reason_cd, ptc.copay_amt_actual, ptc.copay_amt_resp, ptm.curr_card_id, ptc.customer_no, ptm.elig_gnrtd_id, ptc.days_supply_no,
ptc.dispensing_fee_amt_submit,
ptc.contract_dispense_amt_resp,
ptosh.first_date_of_fill,
ptc.groupid, ptc.group_no, ptc.ingredient_cost_amt_actual, ptc.ingredient_cost_amt_resp, ptc.insno||ptc.inssub, ptc.date_of_fill, ptc.nabp_no, ptc.ndc_no, ptm.ophysno,
ptosh.order_status_cd,
ptc.pbm_bin_no, ptc.pbm_card_no, ptc.pbm_group_no, ptc.pbm_pmt_amt, ptc.adm_po_no, ptc.polid, ptc.processor_control_no, ptc.qty_no, ptc.rx_no, ptc.sales_tax_amt_resp, ptc.sales_tax_amt_actual, ptc.sales_tax_dispense_amt_actual, ptc.sales_tax_dispense_amt_resp, PTC.sales_TAX_amt_ACTUAL, ptc.total_amt_paid_actual, ptc.total_amt_paid_resp,
ptosh.vials_used,
ptosh.vials_patient_year,
ptc.xps_entdate, ptc.xps_trans_no, bxc.class_of_trade_cd, dep.med_educ_no, dep.deano, pyc.payer_cont_cd, ptf.form_cd FROM pt_claim_detail ptc, pt_order_status_history ptosh, pt_master ptm, pt_contact pcp, carrier_group cyc, payer_contact pyc, dea_practitioner dep, pt_pharmacy phm, berlex_customer bxc, pt_form ptf WHERE ptc.compno = ptosh.compno AND ptc.acctno = ptosh.acctno
AND ptc.compno = ptm.compno
AND ptc.acctno = ptm.acctno
AND ptc.carrier_no = cyc.carrier_no
AND ptc.group_no = cyc.group_no
AND ptc.compno = pcp.compno AND ptc.acctno = pcp.acctno AND ptc.insno = pyc.insno AND ptc.inssub = pyc.inssub AND ptc.compno = phm.compno AND ptc.acctno = phm.acctno AND ptc.customer_no = bxc.customer_no AND ptc.compno = ptf.compno AND ptc.acctno = ptf.acctno
------------------------
Steven R Fuller
HDS - Mckesson
Information Systems
9700 N. 91st St.
Scottsdale, AZ 85258
ph. 602-314-7143
fax 602-314-7050
sfuller_at_hdsinc.com
Received on Sat Jan 24 1998 - 00:00:00 CET