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