Attachment O - Systems Inventory.xlsx
XLSX spreadsheet 34 KB Posted
- Attached to
- Tax System Modernization
- Solicitation number
- Doc1288967193
- Issued by
- North Carolina
About this file
This is a Systems Inventory attachment for the North Carolina Department of Revenue (NCDOR) RFP 45-RQ161211 Tax System Modernization project. The document details 26 existing systems that will either be replaced by or required to interface with the new Integrated Tax System (ITS). Key systems to be replaced include the Integrated Tax Administration System (ITAS), Public Sector Revenue Management System (PSRM), Modernized eFile Application (MeF), Online Filing and Payments Applications (OFP), Portfolio Warehouse (PW), and various tax-specific systems like the Fuel Tracking System and IFTA System.
The current environment consists of a mix of mainframe, server-based, and web applications handling tax administration functions including registration, correspondence, payment processing, financial management, audit, collections, and reporting. Several third-party systems are involved, including payment processors, document management systems (Hyland OnBase), and identity management through NC Department of Information Technology's NCID system. The inventory also notes approximately 100 Microsoft Access databases containing various tax-related data that may need to be incorporated into the new ITS. Many of the existing systems require complex data exchanges and interfaces with both internal and external entities.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment J - Technical Specifications.xlsx | XLSX spreadsheet | |
| Attachment M - Tax Schedule Matrix.xlsx | XLSX spreadsheet | |
| Attachment N - Forms Inventory.xlsx | XLSX spreadsheet | |
| RFP 45-RQ161211 NCDOR Tax System Modernization.pdf | ||
| Revised Attachment i - Functional Specifications.xlsx | XLSX spreadsheet | |
| Attachment I - Functional Specifications.xlsx | XLSX spreadsheet | |
| Attachment L - Staffing Plan.xlsx | XLSX spreadsheet | |
| Attachment P - Interface Inventory.xlsx | XLSX spreadsheet | |
| Attachment D - Cost Form.xlsx | XLSX spreadsheet | |
| Attachment Q - Implementation Roles & Responsibilities.xlsx | XLSX spreadsheet | |
| Attachment V - Statutory References.xlsx | XLSX spreadsheet | |
| Addendum 1 RFP 45-RQ161211-State Response to Vendor Questions.pdf | ||
| Revised Attachment D - Cost Form.xlsx | XLSX spreadsheet | |
| Revised Attachment H.pdf |
Show all 14
On GovTribe
Work with this file
- Download the original file
- Contacts named in this file
- Similar government files
- Ask GovTribe AI about this file
Text version
Cover Sheet Attachment O:
Systems Inventory
NCDOR RFP 45-RQ161211
Tax System Modernization
Systems Inventory
| Attachment O - Systems Inventory | |||||
| Below are the systems that will be replaced by the proposed ITS, or will be required to interface with it. | |||||
| # | System | Description | Replace | Interface | |
| 1 | Integrated Tax Administration System (ITAS) | Mainframe system for full lifecycle of tax accounts with online (CICS) and batch processes. Includes capabilities for registrations; correspondence; posting (batch and online) returns, schedules, reports, and payments; financial processing such as billing, refunds, fees, penalties, interest; audit and collection actions using case management work flows; reporting and exporting data. There are many data exchanges related to these capabilities with other internal systems and external entities. | Yes | No | |
| 2 | Public Sector Revenue Management System (PSRM) | Server based system for selected tax account types with online and batch processes. Includes capabilities for registrations; correspondence; posting returns, reports, and payments; financial processing such as billing, refunds, fees, penalties, interest; reporting and exporting data. There are some data exchanges related to these capabilities with other internal systems and external entities. | Yes | No | |
| 3 | Modernized eFile Application (MeF) (RSI) | Gateway application with the IRS MeF to enable receiving NC returns and federal return information, reports, payments, and other documents defined for the tax type. Provides the ability to view these documents in a formatted manner. Payments are sent to OFPi to be processed. Returns are formatted and sent to the Common Interface for ITAS. Selected data is sent to PW. | Yes | No | |
| 4 | Online Filing and Payments Applications (OFP) (eServices) | Online applications that allow taxpayers to submit electronic tax returns and payments. Some validations are done on selected applications requiring an interface with a database that is refreshed with the needed data regularly. Payments for both ACH debit and credit card are processed with a 3rd Party Payment Processor. Sales and Use Tax includes an upload ability to taxpayers using EDI X12 coded file specifications. All online transactions are loaded to OFPi. | Yes | No | |
| 5 | Online Filing and Payments Internal Application (OFPi) (eServices) | Internal application to receive electronic file and pay transactions from the OFP online web applications, MeF payments, IFTA, FTS, Streamlined Sales Tax (SST), OBR (reports only), ITAS scheduled installment payments, eBusiness, and eNC3 payments. Provides the capability for payments to be certified as deposited in the NCDOR bank account. All transactions are formatted as defined for the posting tax system (ITAS, PSRM) and exported via a data exchange. Payment transactions are summarized and exported to the RCA system. Functionality also includes search and view, reporting, printing of formatted returns and payments. | Yes | No | |
| 6 | Online Filing and Payments eBusiness Center (and eAssistance Center) (OFPe) (eServices) | The e-Business Center provides taxpayers for some business tax types the ability to file and pay online, view their filing and payment history, grant a representative access to their account, set up payment method data. The e-Business Center requires the taxpayer to register with NCDOR and create an NCID user ID and password. Also included is an internal application, eAssistance Center, that provides NCDOR staff to access accounts and functions in eBusiness to support taxpayers needing help. | Yes | No | |
| 7 | Online Business Registration Application (OBR) | OBR provides real-time registration in ITAS for selected business tax types. Interfaces directly with ITAS to add the account. Also interfaces with NC Secretary of State for validation. Sends reports to OFPi. | Yes | No | |
| 8 | eNC3/eNC5Q Electronic Filing Services | Online web application for taxpayers or their representatives to file annual and quarterly withholding tax reconciliation reports and wage and income statements (e.g. W2s and 1099s) via manual entry or bulk upload via .txt files. eNC3 allows taxpayers to provide payments that are sent to OFPi for batch processing to a payment processor and to ITAS. eNC3 includes a server to server submission capability. Reports are exported and formatted for the ITAS Common Interface for posting. Data is also provided to PW. | Yes | No | |
| 9 | Information Reporting Electronic Filing Service (NCIR) | Online web application for taxpayers or their representative to file annual Beer and Wine Wholesaler, ABC Board, or Occupational License Board reports. Reports are uploaded using .txt, .csv, or .xlsx format. Reporting data is also provided to the SAS Analytics environment. | Yes | No | |
| 10 | eNC3 and Information Reporting Viewer | Internal application to view reports submitted through the eNC3, eNC5Q, and NCIR web applications. Users can search for submissions using various search criteria. User roles determine the data that can be viewed. | Yes | No | |
| 11 | Electronic Funds Transfer (EFT) | Mainframe application that accepts electronic ACH payment transactions in standard NACHA formats and processes these to RCA, ITAS, and PSRM. Current system has a registration process that is needed to accept payments. Online (CICS) and batch processes. Includes ability to enter 'wire' payments; reports to support the processes. | Yes | No | |
| 12 | Revenue Collection and Accounting Application (RCA) | Receives all financial transactions for collection (AR) and distribution (AP) activity. Utilizes a structure of budget/function/section codes similar to a chart of accounts. Functionality includes online search/view, journal entries, reporting, and month end and year end close out processes. | Yes | No | |
| 13 | NC Identity Management System (NCID) (External Users) | Central identity management system provided by the NC Department of Information Technology (NCDIT). NCID provides the credentials for the general public and local governments to access state resources and services online. | Yes | No | |
| 14 | NC Identity Management System (NCID) (Internal NCDOR staff) | Central identity management system provided by the NC Department of Information Technology (NCDIT). NC state employees are required to have an NCID account. NCID credentials are used in NCDOR Active Directory to authorize system accesses for staff. NCDOR will manage the authentication for internal NCDOR staff. | No | Yes | |
| 15 | Data Capture Imaging and Payment Processing System (DCS) | Paper tax returns received and checks for payments are scanned and digitized using the Data Capture System (DCS). Paper forms must be trained for scanning and queues created for the output of the process. Current processing includes taking the output (tax returns and payment) from DCS and reformatting to suit the requirements of the receiving system (ITAS, PSRM). Components of DCS include verification against a table extracted from ITAS and loaded to DCS for name, IDs, addresses. Systems that issue billing must produce a voucher for the payment that can be returned with a paper check if that is the payment method the taxpayer selects. This voucher must be created to meet DCS requirements and trained for processing. Check payments are processes through DCS to the bank using an electronic file (Check21). These payments are also uploaded to a mainframe process that combines DCS, EFT, and ITAS payment information, this is summarized and downloaded to RCA for nightly processing. DCS includes the DocQuery tool that allows staff to view documents scanned into DCs. | No | Yes | |
| 16 | 3rd Party Payment Processor | 3rd Party Payment Processor NCDOR uses for electronic payments to transmit to the ACH Clearinghouse network. This includes both ACH Debt and Credit Card payments from Online Filing and Payments Applications, e-Business Center, IFTA, FTS, and OFP Internal. | No | Yes | |
| 17 | Pay Courier | BancTec PayCourier remittance System is the part of the Data Capture System (DCS) used to process the paper checks received. The PayCourier system includes validation and correction processes, work flows, and reporting. This system generates the image exchange file for Check21 processing with the bank. | No | Yes | |
| 18 | SAS Analytics | SAS Analytics environment uses SAS software to perform advanced analytics and modeling for refund fraud and identity theft identification as well as tax compliance issues and projects. In addition, the environment supports enterprise reports using the SAS Information Delivery Portal. Data from Portfolio Warehouse, ITAS, PSRM, eNC3/eNC5Q/NCIR web applications, several Access database applications, and miscellaneous spreadsheets is loaded to this environment for analytics and reporting. | No | Yes | |
| 19 | Portfolio Warehouse (PW) (RSI) | Audit selection tool for initiatives such as non-filer, refund fraud, and tax auditing. Includes data analytic tools. Receives substantial download files from ITAS, IRS, and other sources. Interfaces with ITAS for refund fraud, sends substitute returns for posting to ITAS for non-filer initiatives. | Yes | No | |
| 20 | Document Management System (DMS) | ||||
| (Hyland Onbase) | System for digital document storage. Scanning interfaces provide documents that are imported to the system and indexed (manually and programmatically) for organization and search criteria. Solution also provides capability to create online web forms for external users. Taxpayer requests are submitted using these forms, NCDOR staff take action as needed and submissions are stored in the DMS. New ITS should manage tax related documents. The current DMS will be retained for non tax account documents and may require an interface to the new ITS. | Yes | Yes | ||
| 21 | Doc Query | System that allows users to search for scanned paper documents received from taxpayers such as tax returns, payment documents, checks, business registrations, and miscellaneous correspondence. Search capabilities include Document Locator Number (DLN), taxpayer ID, tax type, amount paid, period, process date, and receive date. | No | Yes | |
| 22 | Static Website | The current website is on the Drupal platform and supported by the NCDIT. NCDOR staff have the ability to add, update, review/approve and remove content based on roles. It is expected that the new ITS will have an eServices portal capability that can be hosted on our website and also accessed through links on the static website. | No | Yes | |
| 23 | Fuel Tracking System (FTS) | ||||
| (Avalara) | Online web application for taxpayers to file and pay all Motor Fuels tax types. Taxpayers can enter the return information directly or upload their electronic data interchange (EDI) formatted return. The EDI option is available to Terminal Operators, Suppliers, and Transporters only. Payments are by ACH Debit sent to a 3rd Party Payment Processor. Credit card capability is desired. Also includes an internal application for manual entry of tax returns received by paper. | Yes | No | ||
| 24 | International Fuel Tax Agreement (IFTA) System | ||||
| IFTA Processing Consortium/Motor Carrier Connect (IPC/MCC) | Motor Carrier Connect (MCC) for IFTA and IRP Audits is a vendor hosted solution that provides online services to taxpayers for file and pay, account services; provides NCDOR staff with full lifecycle tax processing system. Includes capabilities for registrations; correspondence; posting (batch and online) returns, schedules, reports, and payments; financial processing such as billing, refunds, fees, penalties, interest; audit and collection actions using work flows; reporting and exporting data. There are many data exchanges related to these capabilities with other internal systems and external entities. | Yes | No | ||
| 25 | TaxMaster Audit Application (RSI) | RSI software product used for IFTA tax audits. | Yes | No | |
| 26 | Microsoft Access Databases | 100 various Microsoft Access Databases that may or may not be replaceable by the ITS. It is expected that the data contained in most of these databases will be included in and available from the ITS. Currently the data is manually entered or uploaded from files provided by internal systems or external parties. |
Examples include: Databases tracking bankruptcies, low volume tax schedules not in ITAS or PSRM, returned checks, amended returns, garnishments, levy related data, county and municipality data, real estate exemption and exclusion information, county appraisal information, collections related data, use tax related data to create assessments, appeals data, payment plan data, audit related inventories and statistics, correspondence, dashboards for various business groups, identity theft tracking, IRS related data, etc. Yes No
Drop Down List
| Yes / No | Timing | Direction |
| Yes | Batch | Inbound |
| No | Realtime | Outbound |
| TBD | TBD | Both |
File details come from the government source that posted it. Updated .