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.

To purchase the TCS Prescription Export Utility, please reach out to your Sales Exec / Acct Mgr 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 R&D
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