Fee Schedule Export

The Fee Schedule Export extracts the payment lines related to CPT/HCPCS Procedures, Charges, and Fees.  Below you will find a detailed definition of possible inputs and outputs.  

Data Location:  Setup>Procedure Codes


Inputs

  • Effective From: Beginning date for the fee schedule
  • Effective To:  Ending date for the fee schedule
  • Amount = $0.00: Include any Procedure codes with a value of $0.00
  • Financial Class:  Codes/Fees associated with a specific Financial Class or Classes
  • Payer: Codes/Fees associated with a specific Payer/Payers
  • Provider: Codes/Fees associated with a specific Provider/Providers
  • Service Location: Codes/Fees associated with a specific Location/Locations

Outputs

  • Code:  Code as created
  • Code_Type: CPT/HCPCS
  • Code_Start_Date: Effective start date of the code
  • Code_End_Date: Effective end date of the code
  • Practice: Practice name associated with a code/fee
  • Payer: Payer associated with a code/fee
  • Provider: Provider associated with a code/fee
  • Financial_Class: Financial Class associated with a code/fee
  • Location: Service Location associated with a code/fee
  • Fee_Start_Date: Effective start date of the fee group associated with a code/fee
  • Fee_End_Date: Effective end date of the fee group associated with a code/fee
  • Fee_Type: Whether a code/fee is priced as a Flat Rate or Per Unit
  • Fee:  Amount charged for a code/fee
  • Allowed:  Allowed amount for a code/fee
  • In_House: In-House Cost of a code/fee
  • Tax:  Tax Amount in %
  • RVU:  Number of RVUs for a code/fee
  • Units: Default number of units for a code/fee
  • Time_Based:  Whether or not a code/fee is time based rather than unit based
  • Minutes_Per_Unit: On a Time Based code, how many minutes make up a single unit
  • Rounding: Will the system round up or round down on a Time Based code/fee when calculating units
  • Billing_Code: Code which is submitted/printed on a claim, which may be different than the created code
  • Billing_Type: Default format under which a code/fee must be billed
  • ASA_Code: Anesthesia code associated with this code/fee
  • Patient_Only_Resp: Whether or not insurance can be filed for a code/fee
  • NOC: Whether or not any NOC information has been added on the Drug tab
  • Strength: The Strength as added for an NOC code on the Drug tab
  • Measure:  Whether or not there any Measurement information on the Drug tab
  • Modifier_1, 2, 3, 4: Any default modifier(s) associated with a code/fee
  • ICD9_1-8: Any default Diagnosis code(s) associated with a code/fee
  • Required_Fields: Any default Required Fields associated with a code/fee
  • Gender: If a code/fee is Gender Based
  • Prior_Auth: Whether or not a code/fee requires Prior Authorization
  • Accept: Whether or not a code/fee requires Assignment
  • TOS: *No longer entered on any Procedure Code created*
  • Narrative: The default Claim Narrative associated with a code/fee
  • Description: The full Code Description for that code/fee