Attachment P - Interface Inventory.xlsx
XLSX spreadsheet 32 KB Posted
- Attached to
- Tax System Modernization
- Solicitation number
- Doc1288967193
- Issued by
- North Carolina
About this file
This is an Interface Inventory document (Attachment P) for the North Carolina Department of Revenue's (NCDOR) Tax System Modernization RFP 45-RQ161211. The document details 38 distinct interface requirements between the Integrated Tax System (ITS) and various enterprise, interagency, and third-party systems. The interfaces are categorized into four main types: Enterprise (11 interfaces), External 3rd Party (11 interfaces), Federal (5 interfaces), and Inter-agency (11 interfaces). These interfaces utilize different exchange timing methods including batch, real-time, manual, and TBD, with data primarily exchanged through text files.
The interfaces support various tax-related functions including payment processing, return filing, compliance initiatives, audit processes, and data warehouse operations. The document specifies directional flow of data (inbound, outbound, or both) and involves multiple stakeholders including internal systems (ITAS, PSRM, eServices), banking institutions, payment processors, the Internal Revenue Service, state agencies, and third-party vendors. Notable systems include audit tools, document management systems, and various database applications, with exchanges supporting functions such as tax rate updates, payment reconciliation, notice processing, and compliance monitoring.
View the file
Other files
| File | Type | Posted |
|---|---|---|
| Attachment I - Functional Specifications.xlsx | XLSX spreadsheet | |
| Attachment L - Staffing Plan.xlsx | XLSX spreadsheet | |
| 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 O - Systems 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 P:
Interfaces Inventory
NCDOR RFP 45-RQ161211
Tax System Modernization
Interface Inventory
| Attachment P - Interface Inventory | ||||||
| Below are the requirements for interfaces and/or data exchanges between the ITS and the various systems that interact with the Agency's enterprise, interagency, and 3rd party systems. Interface requirements have been categorized and clustered to assist Vendor with costing and developing their approach and strategy to meeting the requirements. It is expected that the Vendor identify which enterprise interfaces can be satisfied through configurations, consolidate like interfaces, and offer common interface solution(s) in their approach, where feasible. | ||||||
| # | Category | System | Agency / Vendor | Exchange Timing | Interface Description | Direction To / From ITS |
| 1 | Enterprise | Audit Tool | Internal Exchanges | Manual | 1 data exchange of IFTA tax rates (text files) loaded to an Audit Tool. | Inbound |
| 2 | Enterprise | eServices | Internal Exchanges | Batch | 15 data exchanges of tax information such as payments and returns (text files) from eServices systems or applications to an internal system for processing. | Inbound |
| 3 | Enterprise | ITAS and/or PSRM | Internal Exchanges | Both Batch and Realtime | 24 data exchanges of return, payment, account and case information between internal systems, applications, Access databases, and printer to support general operations. | Inbound |
| 4 | Enterprise | ITAS and/or PSRM | Internal Exchanges | Batch | 41 data exchanges of return, payment, account, levy and case information (text files) between internal systems, applications, Access databases, and printer to support general operations. | Outbound |
| 5 | Enterprise | New Tax System | Internal Exchanges | Batch | 2 data exchanges (text files): one for sales tax registries and one for integration with analytical tools | Both |
| 6 | Enterprise | New Tax System | Internal Exchanges | TBD | 1 data exchange for integration with the Document Management System online forms (text files) | Outbound |
| 7 | Enterprise | Other Internal Systems | Enterprise | Batch | 1 data exchange of tax information (AFP and PDFs) for on-site printing. | Both |
| 8 | Enterprise | Other Internal Systems | New Tax System | TBD | 4 data exchanges of tax information (text files) for payment and return reconciliation, automatic transaction update and processing, tracking returned mail and uploading notes from internal systems. | Inbound |
| 9 | Enterprise | Other Internal Systems | Other internal systems | Batch and Manual | 28 data exchanges of tax information (text files) between systems, applications and Access databases to support compliance initiatives, analytics, bankruptcy processing, and eNC3 submissions. | Inbound |
| 10 | Enterprise | PW | Internal Exchanges | Batch and Manual | 6 data exchanges of taxpayer information (text files) between systems, applications and Access databases to support compliance initiatives. | Outbound |
| 11 | Enterprise | PW | Internal Exchanges | Batch | 5 data exchanges for tax information (text files) to support compliance programs and loading data to the data warehouse. | Inbound |
| 12 | External 3rd Party | Audit Tool | External 3rd Party | Manual | 1 data exchange to check in/out audit cases from the data warehouse for audit purposes. | Inbound |
| 13 | External 3rd Party | eServices | Banking Institutions or Payment Processor | Batch | 1 data exchange of payment information (text files) with our eServices systems and application s for revenue collection and accounting. | Inbound |
| 14 | External 3rd Party | eServices | Banking Institutions or Payment Processor | Realtime | 4 data exchanges of payment information (text files) from eServices systems and applications to external payment institution and payment processor. | Outbound |
| 15 | External 3rd Party | ITAS | Banking Institutions or Payment Processor | Batch | 3 data exchanges of payment information (text files) with Banking Institutions or Payment Processor | Inbound |
| 16 | External 3rd Party | ITAS | Banking Institutions or Payment Processor | Batch | 4 data exchanges of payment information (text files) with Banking Institutions or Payment Processor. | Outbound |
| 17 | External 3rd Party | ITAS and/or PSRM | External 3rd Party | Batch | 11 data exchanges of taxpayer information (text files) between 3rd party vendors. | Inbound |
| 18 | External 3rd Party | ITAS and/or PSRM | External 3rd Party | Batch | 4 data exchanges of taxpayer information (text files) between 3rd party vendors. | Outbound |
| 19 | External 3rd Party | New Tax System | External 3rd Party | Batch and Manual | 4 data exchanges of taxpayer information (text files) from external third parties to support Local Government (Property Tax). | Inbound |
| 20 | External 3rd Party | ITAS and/or PSRM | Print Vendor | Batch | 7 data exchanges of tax information (text tiles) for processing of notices, coupon booklets and license renewals by a Print Vendor. | Outbound |
| 21 | External 3rd Party | Other Internal Systems | Banking Institutions or Payment Processor | Batch | 1 data exchange of payment information (text file) with a Banking Institution. | Inbound |
| 22 | External 3rd Party | Other Internal Systems | External 3rd Party | Batch | 1 data exchange for grant program applications (text file) to an Access database for tracking and processing. | Inbound |
| 23 | External 3rd Party | Other Internal Systems | External 3rd Party | Batch | 2 data exchanges of tax information (text files) to support the Financial Institution Reverse Match process. | Outbound |
| 24 | Federal | ITAS and/or PSRM | Internal Revenue Service | Batch | 34 data exchanges of tax information (text files) with the Internal Revenue Service. | Inbound |
| 25 | Federal | ITAS and/or PSRM | Internal Revenue Service | Batch | 4 data exchanges of tax info (text files) to the Internal Revenue Service | Outbound |
| 26 | Federal | ITAS and/or PSRM | Internal Revenue Service | Manual | 13 data exchanges of tax information (text files) to the Internal Revenue Service. | Outbound |
| 27 | Federal | ITAS and/or PW | Internal Revenue Service | Manual | 4 data exchanges of Federal Tax Information (text files) from the IRS. | Inbound |
| 28 | Federal | PW | Internal Revenue Service | Realtime | 12 data exchanges of Federal Tax Information (text files) from the IRS to the data warehouse. | Inbound |
| 29 | Inter-agency | Audit Tool | State Agencies | Manual | 1 data exchange to download IRP data from DMV for audit purposes. | Inbound |
| 30 | Inter-agency | Audit Tool | State Agencies | Manual | 1 data exchange to upload completed IRP audits to DMV. | Outbound |
| 31 | Inter-agency | eServices | State Agencies | Realtime | 1 data exchange of demographic information (text file) from the Secretary of State for use with an eServices application. | Inbound |
| 32 | Inter-agency | ITAS and/or PSRM | State Agencies | Batch | Outbound | |
| 33 | Inter-agency | ITAS and/or PSRM | State Agencies | Batch | 20 data exchanges of tax information (text files) with various State Agencies. | Inbound |
| 34 | Inter-agency | New Tax System | State Agencies | TBD | 1 data exchange of tax information (text files) for reconciliation and accounting purposes. | Both |
| 35 | Inter-agency | Other Internal Systems | State Agencies | Batch | 4 data exchanges of tax information (text files) from other State agencies to support grant programs and examination activities. | Inbound |
| 36 | Inter-agency | Other Internal Systems | State Agencies | Batch | 2 data exchanges of tax information (text files) to other State agencies to support escheats and the Underground Economy Initiative. | Outbound |
| 37 | Inter-agency | PW | Internal Exchanges | Batch | 4 data exchanges to load data to the data warehouse. | Inbound |
| 38 | Inter-agency | USUB | State Agencies | Batch | 2 data exchanges of tax information (text files) to other State Agencies to support Unauthorized Substance processes. | Inbound |
Drop Down List
| Category | Timing | Direction |
| Enterprise | Batch | Inbound |
| Inter-agency | Realtime | Outbound |
| Federal | TBD | Both |
| External 3rd Party | Batch and Manual | |
| Manual |
File details come from the government source that posted it. Updated .