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:
UPDATED:
CATEGORY:
COMPATIBILITY:
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 - 2024 NXGN Management, LLC. All Rights Reserved.