TCS Prescription Export Utility

 

TCS Prescription Export Utility

The TCS Prescription Export Utility is a Windows application that exports 340B export files for the following vendors:

  • 340Basics
  • CVS Wellpartner
  • MacroHelix
  • Par8o
  • RxPreferred
  • RxStrategies
  • Sentry
  • Sun Rx
  • Walgreens

File export configurations are vendor-specific. Daily exports can be automated with Windows Tasks Scheduler. Please refer to the User Guide below for more information.

To purchase the TCS Prescription Export Utility, please submit a NextGen Healthcare Success Community request and we will provide a quote.

If you have purchased the TCS Prescription Export Utility and have not received a license key, please submit a NextGen Healthcare Success Community request and we will provide a license key as soon as possible.


To download and install the latest version on your machine, click the INSTALL link below.

Download Latest Version:  1.49
VERSION:
1.49
UPDATED:
November 15, 2019
CATEGORY:
Team Cianos
COMPATIBILITY:
1.49
November 15, 2019
  • Added CVS Patient Data file
  • Removed message box asking if user wants to proceed when manually generating file
1.48
November 14, 2019
  • Added Financial Class filter to utility
1.47
September 4, 2019
  • Updated ncs_sql_version with newest version for Rx Strategies EMR file export stored procedure
1.46
September 3, 2019
  • Rx Strategies EMR file export - Used encounter billable timestamp for Admit Date and Discharge Date
1.44
August 23, 2019
  • Rx Strategies EMR file export - Updated to vendor specs v4.2
  • Rx Strategies ERX file export - Added this new export
1.45
August 23, 2019
  • Rx Strategies EMR file export - Fixed bug in stored procedure
1.43
August 13, 2019
  • Par8o Encounter file export - Fixed bug where gender filter was applied to incorrect staging table
1.42
August 6, 2019
  • Par8o Referral file export - Filtered out records where these fields are blank: ce_encounter_provider_npi, receiving_provider_first, receiving_provider_last, referral_specialty
  • Par8o Encounter file export - Filtered out records where these fields are blank: patient_gender
1.41
July 30, 2019
  • File exports that do not have the Enabled box checked will not export files through a scheduler.
1.40
July 29, 2019
  • 340Basics files: Removed commas from patient and provider names
1.39
July 15, 2019
  • Walgreens Rx file: Modified location filter to apply to patient_medication location as well as patient_encounter location
1.38
July 1, 2019
  • 340Basics files: Removed quotation marks from reports
1.37
June 7, 2019
  • Par8o Referral export - Column referral_status populated depending on referral's "Received" checkbox AND "Completed" checkbox.
1.36
June 4, 2019
  • CVS Wellpartner Location file exports added
1.35
June 3, 2019
  • Par8o Referral export - referral_consult column: matching on encounter ID instead of person ID to get a more accurate match
  • Par8o Referral export - receiving provider info: Pulling from referral_order_ table only if refer_to_prov_id is empty
1.34
May 31, 2019
  • Par8o Referral export - Removed quotation marks from referral_notes column
  • Par8o Referral export - Included orders with actClass REFR_INIT
  • Par8o Referral export - Excluded patients with last name beginning with ZZ
  • Par8o Referral export - Pull receiving provider's phone and fax from provider_mstr table first
  • Par8o Referral export - Pull patient's contact phone in order of home, day, cell, alt
  • Par8o Referral export - Set referral_consult column to 'Y' if a scanned document exists in a category matching the referral specialty
1.33
May 21, 2019
  • Par8o Referral export - Column ehr_referral_order_identifier now pulls from order_.seq_no (primary key column) instead of the encounter number.
  • Par8o Referral export - Column referral_status populated depending on referral's "Received" checkbox.
  • Par8o Referral export - Columns receiving_provider_phone and receiving_provider_fax now populated.
1.32
May 16, 2019
  • Par8o Referral and Encounter exports - If patient's cell phone is blank, then the home phone is pulled
1.31
May 15, 2019
  • Par8o Referral file export - Changed the column from which the diagnosis is pulled back to the order_ table
1.30
May 13, 2019
  • CVS Wellpartner provider file export - Included only rendering providers and sorted by name.
1.29
May 9, 2019
  • Par8o Provider file export - Included only rendering providers and sorted by name. Removed final comma at end of line.
  • Par8o Encounter file export - Removed final comma at end of line.
  • Par8o Referral file export - Removed final comma at end of line.
  • MacroHelix Encounter/Visit report - Added back Primary Payor column.
  • CVS Wellpartner file exports - Added column headers.
  • CVS Prescription file export - Trimmed trailing white spaces.
  • Set reference to RibbonsControlLibrary back to v4.0
  • Set class library to v8.0.0.0
1.28
May 7, 2019
  • Par8o Referral file export - Omitted blank values from diagnoses
  • MacroHelix Encounter/Visit report - Reverted file format back to original
1.27
May 3, 2019
  • Par8o Referral file export - Changed the column from which the diagnosis is pulled
  • 340 Basics member patient export - Fixed date of birth format from YYYYMMDD to MM/DD/YYYY
  • Reverted reference to RibbonsControlLibrary back to v3.5 from v4.0
1.26
May 1, 2019
  • MacroHelix Encounter/Visit report - The data now pulls primarily from the patient_medication table rather than the patient_encounter table.
1.25
April 30, 2019
  • Par8o Referral file export - Removed carriage returns and line feeds Notes column
1.24
April 26, 2019
  • Par8o Referral file export - Added referral diagnosis
  • Par8o Referral file export - The date criteria for the report now use the order_ modify_timestamp
  • Par8o Encounter file export - Fixed OPA ID field length
1.23
April 25, 2019
  • Added report for SunRx Eligibility file export
1.22
April 23, 2019
  • Rx Strategies Location file export - Added HRSA ID field
  • Par8o Referral file export - Added specialty and refer to physician fields
1.21
April 22, 2019
  • Added Rx Strategies Location file export
1.19
April 19, 2019
  • Added reports for par8o: encounters, providers, and referrals
  • Another fix for the ribbon control
1.20
April 19, 2019
  • Restored Class Library back to v7.21 to resolve Ribbon control issue
1.18
April 18, 2019
  • Rx Strategies EMR file export - Made NPI and location fields required
1.16
April 11, 2019
  • Walgreens Prescriber Automation file export - Removed the final extra pipe from file
  • Walgreens Prescriber Automation file export - Removed extra white spaces from phone extension field
1.17
April 11, 2019
  • Fixed reference to Ribbon Controls Library
1.15
March 14, 2019
  • Rx Strategies Provider file: Made NPI field is required. Hard coded prescriber status to Exclusive.
1.14
March 12, 2019
  • Where applicable, replaced references to person.current_gender column with person.sex column for clients on older versions of NextGen
1.12
February 28, 2019
  • Added 340Basics file formats: Member-Patient, and Provider.
1.13
February 28, 2019
  • 340Basics Provider file: Provider Exclusivity field populates with YES
1.11
February 22, 2019
  • Added Wellpartner (CVS) file formats: Encounter, E-Prescription, and Provider.
1.9
February 11, 2019
  • Added Walgreens Prescriber Automation file export
1.10
February 11, 2019
  • Walgreens Prescriber Automation file export - Only providers with NPI are included in the report
1.7
January 18, 2019
  • Added File export scheduling arguments to File export screen for quick reference.
1.8
January 18, 2019
  • Added default file names that use the Client ID
  • Changed file export scheduling argument area from label to read-only textbox to allow copying from
  • Made sure file names use current date time stamp rather than previous day
1.6
January 4, 2019
  • Added new check box options for provider erx enrollment in retail and mail order
  • Made sure all reports are using the location filter
  • Fixed bug with default diagnosis in some reports
1.5.3
November 14, 2018
  • Changed licensing code to check ncslive.com
  • Added application name to title bar
1.5.2
November 9, 2018
  • Fixed bug with licensing
  • Updated user guide
1.5.1
September 12, 2018
  • Set Program Files folder name back to original name without spaces.
1.5
September 7, 2018
  • RxPreferred report: Created new columns for Diagnoses 3 through 15, to replace the comma-separated column of field "Diagnosis 3 through 15"
1.4
July 17, 2018
  • Sentrex Provider report: Provider Type and Provider Type Description: Uses Degree under Demographics Tab in Provider info in File Maintenance
1.2.1
June 27, 2018
  • Sentrex Provider report: Fixed bug with field Provider Type Description reading from Taxonomy.taxonomy_desc field.
1.3
June 27, 2018
  • Added file export for RXPREFERRED Entity Encounter File report.
1.2
June 26, 2018
  • Sentrex Provider report: Provider Type and Provider Type Description: Uses Taxonomy code under System Tab
  • Sentrex Provider report: Primary Specialty field: Uses Specialty under Practice tab.
  • Sentrex Provider report: Secondary Specialty field: Will be blank
  • Sentrex Patient Encounter report: Pull encounters that have medications, instead of all encounters
  • Walgreens report: In the location filter if all items are unchecked, then there are no restrictions on the encounter location.
1.1
June 24, 2018
  • Added file exports for Sentrex Patient Encounter report and Sentrex Provider report.
1.0.3
June 11, 2018
  • In the Walgreens export, the utility now uses the default diagnosis for prescriptions missing a diagnosis
1.0.2
June 8, 2018
  • In the Walgreens export, file configurations with "Default Diagnosis" with a blank value will now include in the report prescriptions without diagnoses. A diagnosis of Z00.00 is used in place of blank diagnoses.
1.0.1
June 6, 2018
  • v1.0.1 - Updated ncs_rxexp_wg_patientxdetail_sp for Walgreens export. Removed condition for patient_medication.date_stopped and removed condition for provider_mstr.national_provider_id. These were preventing some prescriptions from showing on the Walgreens report.

Terms & Conditions | Privacy Policy | Legal Notices | © 2014-2016 QSI Management, LLC. All Rights Reserved.

Technical Consulting Admin Login