Import Government Fee Schedules

Use this procedure to import fee schedule updates from a .csv or .txt file into the government fee schedule database tables. The fields that display are determined by the types of fee schedules you are authorized to import, such as Medicare, Medicaid, Physician, or TRICARE.

Note: If you are importing a fee schedule in a test facility, a message displays to indicate that your import will update the test version of the database table (CBO_Global). You cannot later use this same import to update the production version of the CBO_Global table.

  1. Access the Government Fee Schedule Import page.
    • Select Go To > Contract Loading > Support Functions > Government Fee Schedule Management. The Government Fee Schedule Management page opens.
    • Click Import New Fee Schedule at the top of the page. The Government Fee Schedule Import page opens.The URL is gpfeesched_table_import.asp.
  2. Select the state you want to update from the State list. The fee schedules for the selected state become accessible in the Table Name list.
  3. Select the fee schedule you want to update from the Table Name list.
  4. Select the upload type.
    • Select Full to insert new values for every code in the fee schedule.
    • Select Partial to update selected codes in the fee schedule.
  5. Click Select File. The Uploader dialog box opens.
  6. Click Browse. The Windows Choose File window opens.
  7. Locate and select the .csv or .txt file you want to import to update the fee schedule.
  8. Click Open. The filename is loaded into the Upload File field on the Uploader box.
  9. Click Select. The file preview displays.
  10. Review the file preview to confirm that it is formatted correctly.
    • Validation errors display below the preview and identify the column number where the error occurred, a description of the column, and a description of the error.
    • A common validation error occurs when the validation logic is applied to a file with column headers. To turn off the validation logic for the first row in the file, select the First row has column names check box. The page automatically refreshes.
    • Another common validation occurs when the imported file uses a different delimiter than the standard template. For example, you can import a file with tab delimiters, but the default is a comma delimiter. To change delimiters, select the appropriate delimiter from the Comma Delimiter list. The page automatically refreshes.
    • All other validation errors must be corrected in the original .csv or .txt file and then uploaded again.
  11. Click Import. The Government Fee Schedule Management page opens and displays your table update in the Fee Schedule Table(s) Pending section. For more information about this page, refer to Manage Government Fee Schedules.

    12. Note: The Import button is not enabled until all validation errors are resolved.

The following table describes the fields on the Government Fee Schedule Import page.

Field

Description

Column Description

Description of the column in the selected file where a validation error occurred

Column Number

The column number in the selected file where a validation error occurred

Comma Delimiter

The delimiter used in the selected file; options include the following:

  • Comma
  • Semicolon
  • Tab
  • Vertical Bar

Note: Comma is the default selection

File Name

The name and path of the file selected to import

File Size

The size of the selected file in KB

Message

Description of the validation error that occurred

Program Name

The program that you are authorized to update; options include Medicaid, Medicare, Physician, and TRICARE

State

The state for the Medicaid fee schedule you want to update

Table Name

The name of the database table/fee schedule you want to update