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:
UPDATED:
CATEGORY:
COMPATIBILITY:
1.72.3
- Verity EPrescribe and Encounter reports - Exclude providers without an NPI
1.72.2
- 340Basics Member Patient file - Fixed bug in income and family size fields
1.72.1
- Added pharmacy filter to Sentry RX file format
1.72.0
- Added check box to make including location info optional. This only applies to the CVS enounter file and CVS eprescription file.
1.71.3
- 340Basics reports - Trimmed extra spaces from name and address fields
1.71.2
- 340Basics reports - Added quotation marks around every field in the files
1.71.1
- 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
- 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
- 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
- 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
- Enabled setting file extensions for report exports
- Updated class and files names in \DbAccess\NG\ to follow Db naming convention
1.68.3
- 340Basics member-patient file - Fixed bug where only patients with family info were pulled
1.68.2
- v1.68.2 12/28/2021 * 340Basics provider file - Fixed bug where HRSA ID was cut off at 10 characters
1.68.1
- 340Basics member-patient file - Fixed bug where HRSA ID was cut off at 10 characters
1.68
- 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
- 340Basics member-patient file - Fixed the date range for which the patient report pulls (no longer 2 years)
1.67.2
- MacroHelix Patient Encounter v9.4.1 - Now pulling encounters based on bill date instead of encounter date
1.67.1
- Added pharmacy filter to Aventi file format
1.67
- 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
- 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
- Apovia Erx report - Added patient cell phone field
1.64
- Sentry Patient Encounter and Provider reports - Utility now overwrites the export file if it already exists
1.63
- Apovia Erx report - Added prescriber address fields
1.62
- 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
- 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
- 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
- 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
- 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
- Macro Helix exports - Corrected the file extensions to .txt from .dat to match the documentation
1.60
- Added par8o Patient Status file
1.59.4
- SunRx file - Fixed bug with Servicing Facility column
1.59.3
- 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
- CVS encounter file - Populated Patient Visit ID field with encounter number
1.59.1
- CVS encounter file - Populated visit type field
1.59
- Added filter for visit type
1.58
- 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
- Sentry Presription file format - Vendor (Sentry) requested optional fields contain place holder character.
1.57.1
- Sentry Presription file format - Vendor (Sentry) requested exclusion of records without a pharmacy
1.57
- 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
- Pointed HRSA ID field on Config view to the new HrsaId column
- Copied data from old RxStratgiesHrsaId field to new HrsaId
1.56.1
- Increased size of HRSA ID field
- Set .NET framework to 4.5.2
1.56
- Added Aventi Eligibility file format
- Made HRSA ID field non-specific to file formats
1.55
- Added Sentry Patient Registration file format
1.54.4
- Sentry Presription file format - Fixed medication_qualifier column to display 'NDC'
1.54.3
- Sentry Presription file format - Fixed issue with data columns not matching header columns
1.54.2
- Sentry Presription file format - Removed extra pipe at end of line
1.54.1
- Walgreens Delta file – Coverage_Effective_Date - Fixed format to YYYY-MM-DD
1.54.0
- Added Sentry file format for Sentrex E-Rx Eligibility Check (electronic prescription)
1.53.14
- Walgreens Delta file – For Coverage_Effective_Date use medication start date instead of create timestamp
1.53.12
- 340Basics member-patient file - Removed commas from fields address, city, and state.
1.53.13
- 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
- 340Basics member-patient file - The patient ID column pulls from patient's medical record number now instead of person number
1.53.10
- SunRx file - Changed default value of column "Admit Type" from "OUT" to blank
1.53.8
- CVS encounter file - Fixed bug where sponsor code column displayed only 5 characters.
1.53.9
- CVS eprescription file - Fixed bug where patient identifier field was blank
1.53.7
- Macro Helix: Patient Encounters/Visits v9.4.1 - Pulls diagnosis from patient_procedures table before checking patient_diagnosis table
1.53.5
- 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
- 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
- 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
- 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
- Macro Helix: Qualifications By Written Location - Fixed bug where line break was missing after header row
1.53.1
- par8o referral file: Now including referrals where these fields are blank: receiving_provider_first and receiving_provider_last
1.53
- Added new report formats for Macro Helix: Qualifications By Written Location and Patient Encounters/Visits v9.4.1
1.52.2
- Verity files - Changed date formats to YYYY-MM-DD
1.52.1
- Sentrex Encounter file - Populated Facility Code column with client ID
1.52
- 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
- Added Pharmacy filter to prescription exports for CVS and RxStrategies
- Added pharmacy information to prescription exports for CVS and RxStrategies
1.50
- Walgreens Delta file - Now includes all prescriptions from a given day.
1.49
- Added CVS Patient Data file
- Removed message box asking if user wants to proceed when manually generating file
1.48
- Added Financial Class filter to utility
1.47
- Updated ncs_sql_version with newest version for Rx Strategies EMR file export stored procedure
1.46
- Rx Strategies EMR file export - Used encounter billable timestamp for Admit Date and Discharge Date
1.44
- Rx Strategies EMR file export - Updated to vendor specs v4.2
- Rx Strategies ERX file export - Added this new export
1.45
- Rx Strategies EMR file export - Fixed bug in stored procedure
1.43
- Par8o Encounter file export - Fixed bug where gender filter was applied to incorrect staging table
1.42
- 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
- File exports that do not have the Enabled box checked will not export files through a scheduler.
1.40
- 340Basics files: Removed commas from patient and provider names
1.39
- Walgreens Rx file: Modified location filter to apply to patient_medication location as well as patient_encounter location
1.38
- 340Basics files: Removed quotation marks from reports
1.37
- Par8o Referral export - Column referral_status populated depending on referral's "Received" checkbox AND "Completed" checkbox.
1.36
- CVS Wellpartner Location file exports added
1.35
- 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
- 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
- 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
- Par8o Referral and Encounter exports - If patient's cell phone is blank, then the home phone is pulled
1.31
- Par8o Referral file export - Changed the column from which the diagnosis is pulled back to the order_ table
1.30
- CVS Wellpartner provider file export - Included only rendering providers and sorted by name.
1.29
- 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
- Par8o Referral file export - Omitted blank values from diagnoses
- MacroHelix Encounter/Visit report - Reverted file format back to original
1.27
- 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
- MacroHelix Encounter/Visit report - The data now pulls primarily from the patient_medication table rather than the patient_encounter table.
1.25
- Par8o Referral file export - Removed carriage returns and line feeds Notes column
1.24
- 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
- Added report for SunRx Eligibility file export
1.22
- Rx Strategies Location file export - Added HRSA ID field
- Par8o Referral file export - Added specialty and refer to physician fields
1.21
- Added Rx Strategies Location file export
1.19
- Added reports for par8o: encounters, providers, and referrals
- Another fix for the ribbon control
1.20
- Restored Class Library back to v7.21 to resolve Ribbon control issue
1.18
- Rx Strategies EMR file export - Made NPI and location fields required
1.16
- 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
- Fixed reference to Ribbon Controls Library
1.15
- Rx Strategies Provider file: Made NPI field is required. Hard coded prescriber status to Exclusive.
1.14
- Where applicable, replaced references to person.current_gender column with person.sex column for clients on older versions of NextGen
1.12
- Added 340Basics file formats: Member-Patient, and Provider.
1.13
- 340Basics Provider file: Provider Exclusivity field populates with YES
1.11
- Added Wellpartner (CVS) file formats: Encounter, E-Prescription, and Provider.
1.9
- Added Walgreens Prescriber Automation file export
1.10
- Walgreens Prescriber Automation file export - Only providers with NPI are included in the report
1.7
- Added File export scheduling arguments to File export screen for quick reference.
1.8
- 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
- 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
- Changed licensing code to check ncslive.com
- Added application name to title bar
1.5.2
- Fixed bug with licensing
- Updated user guide
1.5.1
- Set Program Files folder name back to original name without spaces.
1.5
- RxPreferred report: Created new columns for Diagnoses 3 through 15, to replace the comma-separated column of field "Diagnosis 3 through 15"
1.4
- Sentrex Provider report: Provider Type and Provider Type Description: Uses Degree under Demographics Tab in Provider info in File Maintenance
1.2.1
- Sentrex Provider report: Fixed bug with field Provider Type Description reading from Taxonomy.taxonomy_desc field.
1.3
- Added file export for RXPREFERRED Entity Encounter File report.
1.2
- 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
- Added file exports for Sentrex Patient Encounter report and Sentrex Provider report.
1.0.3
- In the Walgreens export, the utility now uses the default diagnosis for prescriptions missing a diagnosis
1.0.2
- 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
- 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 - 2023 NXGN Management, LLC. All Rights Reserved.