Payer Export

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