Report ยท Chapter 13

RFI register

The fourth Power BI page: search one RFI, or filter the register by status, discipline, submitter, and document impact.

Page: Search, filter, and investigate 107 rows, 8 open 8 October 2026
A construction site at dusk, with the building frame still visible.

Section 1The page

The page title is Search, Filter & Investigate Individual RFIs. The question on the header is which RFIs require review, follow-up, or document action. The first three pages count the project, the document changes, and the parties. This page is the row behind each count.

Filters sit on the left: an RFI number search, a party list, status, discipline, and document impact. Four cards sit across the top. The register table fills the rest of the page. It is sorted by RFI number. Question Summary is the start of fact_rfi.question, shortened so the row stays one line. The full question and the response stay in the fact table.

Section 2Live report

The published report is rif_vis. The bar under the frame switches pages: executive, Drawing & Specification Change Analysis, COORDINATION & RESPONSIBILITY, and RFI Register.

Live rif_vis report. Open the report.

This chapter is dashboard 4. Use the arrows beside 4 of 4 to open the RFI Register. Page 1 is the executive dashboard. Page 2 is Drawing & Specification Change Analysis. Page 3 is COORDINATION & RESPONSIBILITY.

Section 3KPI cards

The four cards match the earlier pages, and they recount whatever the filters leave in view.

CardUnfilteredMeaning
Total RFIs107Rows left after the current filters
Open RFIs8Those rows with a blank response
Response Rate92.52%Answered rows divided by the rows in view
Document Update RFIs19Rows whose document-update flag is Yes

Setting status to Open leaves eight rows. All eight are unanswered, so the response rate becomes 0%. All eight have document impact Unknown, so the document-update card becomes 0.

Section 4Filters

The RFI number box searches fact_rfi.rfi_id. Typing RFI-008 leaves that one row: Architectural, Specification Clarification, submitted by DAVID BOLAND, INC, tasked to AE, document impact Both.

Status is Answered or Open. Discipline is the ten names from dim_discipline. Document impact is five labels built from the drawing flag and the specification flag.

Document impactRFIsFlags
Both16Drawing Yes and specification Yes
Drawing only2Drawing Yes and specification Unknown
Specification only1Specification Yes and drawing Unknown
No update51Both flags No
Unknown37Both flags Unknown
Total107

The party slicer is titled party_name and lists all 16 names in dim_party. The filter uses the active relationship, from_party_key, so it keeps the submitter. Six names return rows: DAVID BOLAND, INC (71), Carbon Recall Chattanooga (11), and Willdan, Dobco, Inc., and Richard Group LCC (8 each), plus Schweitzer Engineering Laboratories, Inc. (1). The other ten names are tasked parties. Selecting AE, CT, JBMDL, PM, or USACE DB leaves the register empty.

The received date is on every row, shown as year, month, and day. There is no answered date, so this page does not show days open or a response-time target.

Section 5The register

Each row is one RFI. The columns are the RFI number, the received date split into year, month, and day, status, discipline, issue type, originating party, responsible party, the question preview, and document impact. The table below is the first 10 of 107, in RFI number order.

RFIReceivedStatusDisciplineIssue typeSubmitterTaskedImpact
RFI-0011 Sep 2026AnsweredElectricalMaterial RequirementSchweitzer Engineering Laboratories, Inc.JBMDLUnknown
RFI-0022 Sep 2026AnsweredElectricalDrawing ConflictWilldanAEBoth
RFI-0032 Sep 2026AnsweredOtherCompliance RequirementWilldanCTUnknown
RFI-0042 Sep 2026AnsweredOtherDesign ClarificationWilldanCT/PMUnknown
RFI-0052 Sep 2026AnsweredControls / SCADAInterface CoordinationWilldanAE/JBMDLNo update
RFI-0062 Sep 2026AnsweredCybersecurityCompliance RequirementWilldanAE/JBMDLNo update
RFI-0072 Sep 2026AnsweredOtherCompliance RequirementWilldanCTUnknown
RFI-0084 Sep 2026AnsweredArchitecturalSpecification ClarificationDAVID BOLAND, INCAEBoth
RFI-0094 Sep 2026AnsweredQuality / InspectionInspection / QualityDAVID BOLAND, INCAEUnknown
RFI-0104 Sep 2026AnsweredStructuralSpecification ClarificationDAVID BOLAND, INCAENo update

The question preview for RFI-001 starts with the approved electric meter models for AMRS integration. RFI-002 starts with the battery energy storage system capacity discrepancy. RFI-008 starts with the finishes schedule and the paint specification.

Section 6The eight open RFIs

Filtering status to Open leaves these eight rows. All eight are discipline Other, all eight are tasked to CT, and all eight are document impact Unknown.

RFIReceivedIssue typeSubmitterQuestion preview
RFI-08614 Sep 2026Compliance RequirementWilldanFAR liquidated damages
RFI-09216 Sep 2026Missing InformationDobco, Inc.Award date and notice to proceed
RFI-09316 Sep 2026Compliance RequirementDobco, Inc.New Jersey prevailing wage
RFI-09516 Sep 2026Compliance RequirementDobco, Inc.Tax-exempt certificate
RFI-09616 Sep 2026Scope GapDobco, Inc.Percentage of work the contractor performs
RFI-10021 Sep 2026Design ClarificationRichard Group LCCHand delivery of the bid
RFI-10621 Sep 2026Missing InformationRichard Group LCCTarget date for funding
RFI-10721 Sep 2026Material RequirementRichard Group LCCAdjusting the bid for material prices

Section 7How to read it

Use the earlier pages to see the pattern, then use this page to find the row. Status Open is the eight-RFI backlog, all with CT. Document impact Both is the 16 RFIs that change a drawing and a specification. An RFI number in the search box opens that one record, with its submitter, its tasked party, and the start of the question.

The party list looks like every organisation on the project. It filters the submitter. A tasked party such as AE or CT has to be read from the Responsible Party column, or from the coordination page.