The Payer Export extracts data related to the practice's payer table. Below you will find a detailed definition of possible inputs and outputs.
Data Location: Setup > Payers
Inputs
- Payers: No limitations. Pulls all payers from the payer table.
Outputs
- sys_id: System assigned unique identifier
- payer_name: Name of payer
- active: Payer active flag (yes/no)
- financial_class_1: Primary financial class assigned to payer
- financial_class_2: Reporting financial class (rarely used)
- auth_req_primary: Primary authorization/referral required flag (yes/no)
- auth_req_secondary: Secondary authorization/referral required flag (yes/no)
- auth_req_tertiary: Tertiary authorization/referral required flag (yes/no)
- address_1: Payer address line 1
- address_2: Payer address line 2
- city: Payer city
- state: Payer state
- zip: Payer zip
- source_of_pay: Payer type (Commercial, Medicare, Self Pay, etc.)
- edi_type: Clearinghouse information (only correct value = Proxymed)
- payer_id: Payer ID provided by clearinghouse/payer for claim submission
- send_asa: Send anesthesia flag (yes/no)
- billing_primary: Paper or Electronic when payer is primary
- billing_secondary: Paper or Electronic when payer is secondary
- user_npi: Use NPI flag (yes/no)
- secondary_ei: EIN flag
- secondary_1d: Medicaid Number flag
- secondary_1a: Blue Cross Provider Number flag
- secondary_1b: Blue Shield Provider Number flag
- secondary_1h: CHAMPUS Identification flag
- secondary_fh: Clinic Number flag
- secondary_1j: Facility ID Number flag
- secondary_bq: Health Maintenance flag
- secondary_lu: Location Number flag
- secondary_lc: LC Number flag
- secondary_b3: PPO flag
- secondary_g2: Provider Commercial Number flag
- secondary_g5: Provider Site Number flag
- secondary_1g: Provider UPIN flag
- secondary_sy: SSN flag
- secondary_x5: State Industrial Accident flag
- secondary_0b: State License Number flag
- secondary_u3: Unique Supplier Identification flag
- field_17a: CMS-1500 override default field values
- field_24j: CMS-1500 override default field values
- field_32b: CMS-1500 override default field values
- field_33a: CMS-1500 override default field values
- field_33b: CMS-1500 override default field values
- contract_info: Send Contract Information flag (yes/no)
- primary_2310: Send loop 2310 payer primary identifiers flag (yes/no)
- primary_other: Send other payer primary identifiers flag (yes/no)
- legacy_other: Send Other payer primary identifiers (legacy) flag (yes/no)
- inq_address_1: Inquiry address (Demographics tab)
- inq_address_2: Inquiry address (Demographics tab)
- inq_address_city: Inquiry city (Demographics tab)
- inq_address_state: Inquiry state (Demographics tab)
- inq_address_zip: Inquiry zip (Demographics tab)
- ref_address_1: Refund address (Demographics tab)
- ref_address_2: Refund address (Demographics tab)
- ref_address_city: Refund city (Demographics tab)
- ref_address_state: Refund state (Demographics tab)
- ref_address_zip: Refund zip (Demographics tab)
- primary_name: Primary payer contact name
- primary_phone: Primary payer contact phone number
- primary_fax: Primary payer contact fax number
- primary_email: Primary payer contact email
- secondary_name: Secondary payer contact name
- secondary_phone: Secondary payer contact phone number
- secondary_fax: Secondary payer contact fax number
- secondary_email: Secondary payer contact email
