Zaszz of PM Engineers
12/18/2018 - 1:39 PM

Find the transmitter ID

In file maint > payer MSTR > Practice tab > electronic transmitter ID, this field is stored in the practice_payers table, transmitter_id field, so to dig it out you would sub query or join from the payer_mstr and your practice ID. To use this query simply change practice ID and payer name to look up the info.

select transmitter_id from practice_payers
where practice_id ='0001'
and payer_id in (select payer_id from payer_mstr
where payer_name like '%Aetna%')