Current Client Logo
Client Details

Add Procedure

Ex. 20610 - ARTHROCENTESIS MAJOR/JOINT

To upload tblData:

  1. The worksheet must be named tblData.
  2. The columns must be named:
    • payeeName: This must be the string name of the payee and must match exactly (case sensative) the names in tblPayee.
    • procedureName: This must be the string name of the procedure and must match exactly (case sensative) the names in tblProcedure.
    • avgCharge
    • avgPayment
    • caseRate

To upload tblPayee:

  1. The worksheet must be named tblPayee.
  2. The columns must be named:
    • name: This must be the string name of the payee and must match exactly (case sensative) the names in tblData.
    • inflatorMultiplier
    • pct1
    • pct2
    • pct3
    • pct4
    • pct5
    • pct6
    • pct7
    • pct8
    • pct9
    • pct10
    • implantPct

To upload tblProcedure:

  1. The worksheet must be named tblProcedures.
  2. The columns must be named:
    • name: This must be the string name of the payee and must match exactly (case sensative) the names in tblData.
    • NOTE: The code is split out of the name. The split occurs on " - " (includes the space before and after. This is used to pull in the professional charges for tblData.

Percent Charged
Add New User
Name Email Role