IRS Response to RFI Qus _ MRTS.pdf

IRS Responses to Consolidated Questions received in response to the RFI for:

“Manager Rating and Tracking System (MRTS) Replacement” (051324)

(Note: There was an unexpected delay in posting the IRS responses to the RFI Q&A. Responses were posted on 5/20 and not the referenced time on the RFI document.)

Qu # Docu-ment

Section/

Page Question/Recommendation Government Response

1 RFI

General

Can this project be aligned with the 8(a)

STARS III program?

An acquisition strategy has not been decided. The

GSA 8(a) STARS III will be considered.

2 RFI

Item 1, pgs

2-3

Does the agency possess the necessary

Dataverse, Connectors, and Power BI licenses?

Yes

3 RFI

Are Power BI Premium licenses available to support specific use cases?

4 RFI

What is the annual growth rate of staff, particularly in relation to Taxpayer Services managers?

The average over the past four years has been 5%, but there was an 10% increase from 2022-2023.

5 RFI

Item 1, pg 1

What is the number of columns in the existing SQL tables?

Approximately 150, divided among various tables as documented in MRTS Table Schema.

ment

Section/

Page

6 RFI

Item 1, pg 1

What is the number of rows in the existing

SQL tables?

There are 7 tables in the SQL Server. The number of records for each table are as follows:

Table 1: 127

Table 2: 2796

Table 3: 16

Table 4: 46

Table 5: 62

Table 6 **: 40,581

Table 7 **: 3132

7 RFI

Is there any existing system design documentation provided by the current vendor or staff?

Yes, MRTS will supply.

8 RFI

Is there any sensitive data in these tables, and does the new target system have an

Authority to Operate (ATO) for handling such data?

Yes, GCC cloud has AO 12/2019.

9 RFI

Are there any requirements for document generation, digital signature, workflows, or records management on the solicitation?

10 RFI

Also, are there any requirements for impact level 2, 4 or 5?

We do not have enough information to answer this question.

ment

Section/

Page

11 RFI

Is there an incumbent on this contract? If so, please provide the incumbent name, current contract number, Period of performance, value of the contract.

No, this is a new requirement.

RFI

Item 1, pg 2

The RFI mentions user counts by role, but it does not include the number or managers or regular employees. Will managers and regular employees be using the MRTS system as well?

Managers and Analysts listed in Solution Design document, must be validated by MRTS.

Are the existing user roles and permissions in the current system expected to remain the same in the new system?

Yes, with some additions.

Is TS planning to migrate the existing/historical data from the current

MRTS system to the new platform? If yes, what is the volume and nature of the data.

See Q6 Response. Both tables 6 and 7 contain historical data which does not need to be carried over year to year if we can make a copy for storage in a separate environment.

Do they have detailed documentation of the current system (database schema, workflows, user roles)?

Yes, in the Solution Design document.

Will the new system need to integrate with any other existing systems or databases beyond SharePoint and Dataverse?

No ment

Section/

Page

Are there any existing reports that needs to be enhanced or replicated?

For the Power Automate workflow, is there a detailed description of the current workflows that must be replicated in the new system?

No. there are no workflows in the current system.

The system currently relies on an MS Access Front end to create data entry tables and forms, as well as

MS VBA to automate some of the processes. The

MS Access front end is connected to the SQL server via ODBC drivers linking the tables and views.