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
    • Member-patient
    • provider
  • Apovia
    • Encounters
    • E-prescriptions
  • Aventi
    • eligibility
  • CVS Wellpartner
    • Encounter
    • Crosswalk
    • Patient
    • Prescription
    • Provider
  • Par8o
    • Credentialed Provider
    • Patient Status
    • Patient encounter
    • Referrals
  • RxPreferred
    • Entity Encounter
  • RxStrategies
    • EMR
    • ESCRIPT
    • Location
    • Provider
  • Sentry
    • Electronic Prescription
    • Patient encounter
    • Patient registration
    • Credentialed provider
  • Sun Rx
    • eligibility
  • Verity
    • Encounter
    • ePrescription
  • Walgreens
    • Delta
    • Full History
  • MacroHelix* - Please note: MacroHelix may not accept one of our existing formats for new clients. A quote will be provided to create a newly requested MacroHelix file format.
    • Patient Encounter v9.4.1
    • Qualification By Written Location v9.4.1
    • Drug Utilization v9

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.

A quote will be provided to create new file formats for 340B vendors not currently supported.

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.72.3
VERSION:
1.72.3
UPDATED:
June 6, 2023
CATEGORY:
Team Cifuentes
COMPATIBILITY:
1.72.3
June 6, 2023
  • Verity EPrescribe and Encounter reports - Exclude providers without an NPI
1.72.2
May 8, 2023
  • 340Basics Member Patient file - Fixed bug in income and family size fields
1.72.1
September 15, 2022
  • Added pharmacy filter to Sentry RX file format
1.72.0
July 1, 2022
  • Added check box to make including location info optional. This only applies to the CVS enounter file and CVS eprescription file.
1.71.3
June 28, 2022
  • 340Basics reports - Trimmed extra spaces from name and address fields
1.71.2
June 6, 2022
  • 340Basics reports - Added quotation marks around every field in the files
1.71.1
June 1, 2022
  • Apovia Erx report - Fixed bug to pull the correct dates for “Date Prescription Written” and “Date Prescription Sent”
  • MacroHelix Qualification By Written Location report - Fixed bug to ensure pulling correct info for Pharmacy NPI and Pharmacy NCPDP
  • Sentry Electronic Prescription report - Fixed bug to ensure pulling correct info for the pharmacy's NPI, name, and address
  • Verity EPrescribe report - Fixed bug to ensure pulling correct info for Pharmacy name and Pharmacy NCPDP
1.71
May 12, 2022
  • Added check box to make including pharmacy info options. This only applies to files where pharmacy information is among the report fields: CVS E-Prescription and Verity ePrescription..
  • Reorganized some items in Config Export interface to fit the workflow better and to group similar items together better
1.70.1
March 18, 2022
  • Sentry reports - In the staging tables, increased the size of all varchar columns to 255 because of issue with NextGen 6.2021.1
1.70
March 11, 2022
  • Walgreens Delta - Coverage Effective Date field: In cases where a prescription’s start date does NOT match its create date (patient_medication.start_date vs patient_medication.create_timestamp), the field will be populated with the report date that matches either the start date or the create date, when the report is run for a single day of data. If the report is run for a range of dates the start date is used.
1.69
January 14, 2022
  • Enabled setting file extensions for report exports
  • Updated class and files names in \DbAccess\NG\ to follow Db naming convention
1.68.3
January 13, 2022
  • 340Basics member-patient file - Fixed bug where only patients with family info were pulled
1.68.2
December 29, 2021
  • v1.68.2 12/28/2021 * 340Basics provider file - Fixed bug where HRSA ID was cut off at 10 characters
1.68.1
December 28, 2021
  • 340Basics member-patient file - Fixed bug where HRSA ID was cut off at 10 characters
1.68
October 26, 2021
  • Verity files - Fixed file extensions from .dat to .txt
  • Verity files - Fixed bug where HRSA id was not included in file
  • Verity files - Updated to latest specs to include medical record number in encounter and eprescribe files
1.67.3
October 14, 2021
  • 340Basics member-patient file - Fixed the date range for which the patient report pulls (no longer 2 years)
1.67.2
October 13, 2021
  • MacroHelix Patient Encounter v9.4.1 - Now pulling encounters based on bill date instead of encounter date
1.67.1
October 4, 2021
  • Added pharmacy filter to Aventi file format
1.67
September 14, 2021
  • In the Config screen, the End Date is now inclusive.
  • In the Config screen, the client ID is no longer required. Not all vendors require a client ID.
1.66
August 4, 2021
  • Walgreens Delta - Now pulling records based on either the medication's create timestamp or start date
  • MacroHelix Patient Encounter v9.4.1 - Now populating facility field with the location's 340B ID
1.65
April 20, 2021
  • Apovia Erx report - Added patient cell phone field
1.64
April 15, 2021
  • Sentry Patient Encounter and Provider reports - Utility now overwrites the export file if it already exists
1.63
March 18, 2021
  • Apovia Erx report - Added prescriber address fields
1.62
March 12, 2021
  • Enabled tracking 340B ID in the location config.
  • Apovia Erx report - Exclude records that have been faxed that don't have status of 'Sent'
  • Apovia Erx report - Added fields for location name and populated 340B ID based on location config
1.61.3
March 1, 2021
  • Apovia Erx report - Exclude records that have been faxed
  • Apovia Erx report - Only include records with an eRx status
  • Apovia Erx report - Added columns for EMR
  • Apovia Encounter report - Added columns for Enterprise, Corporation, and EMR
1.61.2
February 16, 2021
  • Apovia Erx report & Apovia Encounter report - Added person number to report
  • Apovia Erx report - Re-added records with blank diagnosis codes and blank pharmacy NPI
  • Apovia Erx report - Fixed missing Ncpdpid's
1.61.1
February 3, 2021
  • Apovia Erx report - Converted prescriber order number GUID to string and removed dashes
  • Apovia Erx report - Removed quotation marks from medication name, sig desc
  • Apovia Erx report - Converted "N" to blank space from diagnosis code 3
  • Apovia Erx report - Excluded records with blank diagnosis codes and blank pharmacy NPI
1.61
January 6, 2021
  • Added Apovia Encounter report and Apovia Erx report
  • Added GCN to Walgreens Delta report
  • Walgreens Delta/Full History report - Fixed bug with location filter where unchecked locations were still appearing in report
  • In the location config, made the deleted locations more visibly distinct
1.60.1
November 2, 2020
  • Macro Helix exports - Corrected the file extensions to .txt from .dat to match the documentation
1.60
October 12, 2020
  • Added par8o Patient Status file
1.59.4
October 9, 2020
  • SunRx file - Fixed bug with Servicing Facility column
1.59.3
October 7, 2020
  • SunRx file - Populated Patient Class column with "O" for Outpatient
  • SunRx file - Populated Servicing Facility column with the location's Facility Entity ID
1.59.2
October 1, 2020
  • CVS encounter file - Populated Patient Visit ID field with encounter number
1.59.1
September 3, 2020
  • CVS encounter file - Populated visit type field
1.59
August 27, 2020
  • Added filter for visit type
1.58
August 21, 2020
  • Sentry Patient Encounter file format - Updated to Sentry's latest version for columns names
  • Sentry Patient Encounter file format - Updated to Sentry's latest version by populating location name from the encounter
  • Sentry Patient Encounter file format - Updated to Sentry's latest version for file name
1.57.2
August 18, 2020
  • Sentry Presription file format - Vendor (Sentry) requested optional fields contain place holder character.
1.57.1
August 3, 2020
  • Sentry Presription file format - Vendor (Sentry) requested exclusion of records without a pharmacy
1.57
July 29, 2020
  • Upgraded to Class Library v8.0 to v8.2
  • Upgraded Deploy LX v4 to v5
  • Renamed namesspace DBAccess to DbAccess
  • Corrected variable names and public property names
  • Eliminated unused method parameters, redundant code, and unused code
  • Replaced variable constants with enumerated type.
  • Replaced some switch statements with dictionary
1.56.2
July 14, 2020
  • Pointed HRSA ID field on Config view to the new HrsaId column
  • Copied data from old RxStratgiesHrsaId field to new HrsaId
1.56.1
July 10, 2020
  • Increased size of HRSA ID field
  • Set .NET framework to 4.5.2
1.56
July 7, 2020
  • Added Aventi Eligibility file format
  • Made HRSA ID field non-specific to file formats
1.55
June 8, 2020
  • Added Sentry Patient Registration file format
1.54.4
June 4, 2020
  • Sentry Presription file format - Fixed medication_qualifier column to display 'NDC'
1.54.3
June 2, 2020
  • Sentry Presription file format - Fixed issue with data columns not matching header columns
1.54.2
June 1, 2020
  • Sentry Presription file format - Removed extra pipe at end of line
1.54.1
May 28, 2020
  • Walgreens Delta file – Coverage_Effective_Date - Fixed format to YYYY-MM-DD
1.54.0
May 22, 2020
  • Added Sentry file format for Sentrex E-Rx Eligibility Check (electronic prescription)
1.53.14
May 5, 2020
  • Walgreens Delta file – For Coverage_Effective_Date use medication start date instead of create timestamp
1.53.12
May 4, 2020
  • 340Basics member-patient file - Removed commas from fields address, city, and state.
1.53.13
May 4, 2020
  • 340Basics member-patient file - Distinct patients are pulled into the file. Duplicates appeared when a patient's most recent encounter occurred on the same day.
1.53.11
April 30, 2020
  • 340Basics member-patient file - The patient ID column pulls from patient's medical record number now instead of person number
1.53.10
April 27, 2020
  • SunRx file - Changed default value of column "Admit Type" from "OUT" to blank
1.53.8
March 11, 2020
  • CVS encounter file - Fixed bug where sponsor code column displayed only 5 characters.
1.53.9
March 11, 2020
  • CVS eprescription file - Fixed bug where patient identifier field was blank
1.53.7
February 12, 2020
  • Macro Helix: Patient Encounters/Visits v9.4.1 - Pulls diagnosis from patient_procedures table before checking patient_diagnosis table
1.53.5
February 5, 2020
  • Macro Helix Qualifications By Written Location and Patient Encounters/Visits v9.4.1 files - Fixed bug with PREV parameter where no number passed.
1.53.6
February 5, 2020
  • Macro Helix: Qualifications By Written Location v9.4.1 - removed condition on Unbilled status
  • Macro Helix: Patient Encounters/Visits v9.4.1 - removed join with patient_medication table so that encounters will be pulled whether a prescription was written or not
1.53.4
February 4, 2020
  • Macro Helix Qualifications By Written Location and Patient Encounters/Visits v9.4.1 files - Modified PREV parameter to use a date range
1.53.3
January 31, 2020
  • Macro Helix: Qualifications By Written Location v9.4.1 - Fixed format for dob to MM/DD/YYYY
  • Macro Helix: Qualifications By Written Location v9.4.1 - Removed quotation marks from these fields: ndc, drug_description, drug_quantity, drug_ndc
  • Macro Helix: Qualifications By Written Location v9.4.1 - Excluded encounters with status of Unbilled
  • Macro Helix: Patient Encounters/Visits v9.4.1 - Excluded encounters with status of Unbilled
1.53.2
January 29, 2020
  • Macro Helix: Qualifications By Written Location - Fixed bug where line break was missing after header row
1.53.1
January 28, 2020
  • par8o referral file: Now including referrals where these fields are blank: receiving_provider_first and receiving_provider_last
1.53
January 27, 2020
  • Added new report formats for Macro Helix: Qualifications By Written Location and Patient Encounters/Visits v9.4.1
1.52.2
January 23, 2020
  • Verity files - Changed date formats to YYYY-MM-DD
1.52.1
January 20, 2020
  • Sentrex Encounter file - Populated Facility Code column with client ID
1.52
January 16, 2020
  • Added new report formats for Verity Encounters and Verity ePrescriptions
  • Added Pharmacy filter to exports for MacroHelix Encounter file and Walgreens Delta file
1.51
January 14, 2020
  • Added Pharmacy filter to prescription exports for CVS and RxStrategies
  • Added pharmacy information to prescription exports for CVS and RxStrategies
1.50
December 30, 2019
  • Walgreens Delta file - Now includes all prescriptions from a given day.
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.

Privacy Policy | Legal Notices | © 2009 - 2024 NXGN Management, LLC. All Rights Reserved.

Technical Consulting Admin Login