Requirements Traceability MatrixTemplate.xlsx

XLSX spreadsheet 16 KB Posted

Attached to
Motor Pool Management System
Solicitation number
300000163189827
Issued by
Missouri

About this file

This is a Requirements Traceability Matrix (RTM) template document used for tracking and managing software requirements and their associated testing activities. The document serves as a project management tool for the Missouri Department of Mental Health's PPS (Psychiatric Patient Services) system, facilitating coordination between business analysts, product owners, testers, and developers.

The RTM tracks four primary requirements across user registration and login functionality, with each requirement mapped to specific test cases, testers, and testing phases including Unit, QA, UAT, and Production environments. Three of the four requirements (REQ001 variants) are marked as Complete with identified defects, while REQ002 remains in Not Started status. Defects are tracked through an Azure DevOps (ADO) system with severity ratings ranging from Critical to Low, including defect IDs, assignment details, and resolution dates. As of the document date in October 2019, two defects were resolved, one remains in progress, and one has not been addressed. The matrix indicates that Critical and High severity defects prohibit production deployment, Medium severity defects require stakeholder discussion regarding workarounds, and Low severity defects may proceed to production with planned remediation.

View the file

Other files

File Type Posted
OA ITSD-FY25-0020-SL_1_SUPPLIER.pdf PDF
ITSD Project Status Report Template.pptx PPTX presentation
OA ITSD-FY25-0020-SL Fleet Motor Pool Mgt System.docx DOCX document

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

RTM

RequirementsTestingDefectsStatus
Requirement IDReq. location in PAQRequirement DescriptionRequirement SourceWBS DeliverablesTest Case IDTest DescriptionTesterUNITQA in TESTUATPRODDefectiveDefect ID from ADOPrioritySeverityCreated DateDefect DescriptionAssigned ToResolved DateRequirement STATUS
REQ0011.1User registration functionalityBusiness Analyst1.1TC001Verify user can successfully register an accountAmy KPassPassPassFailNo4482711-Critical10/8/19 15:03-Jason10/16/19 15:19Complete
REQ0011.1.1User registration functionalityBusiness Analyst1.1TC002Verify error message is displayed for invalid inputsKateN/AFailPassFailYes4493712-High10/17/19 18:34Invalid email formatSteveComplete
REQ0011.1.1User registration functionalityBusiness Analyst1.3TC003Verify user receives a confirmation emailBobPassN/AFailN/AYes4495523-Medium10/21/19 12:55Email not sentSusanIn progress
REQ0022.1Login functionalityProduct Owner2.1TC004Verify user can log in with valid credentialsBobFailPassN/AN/ANo4496334-Low10/21/19 19:10-Not Started

https://mo-dmh.visualstudio.com/PPS/_workitems/edit/44827https://mo-dmh.visualstudio.com/PPS/_workitems/edit/44937https://mo-dmh.visualstudio.com/PPS/_workitems/edit/44955https://mo-dmh.visualstudio.com/PPS/_workitems/edit/44963 Legend

Severity
CriticalCannot go to Prod with any of these
HighCannot go to Prod with any of these
MediumMust discuss if can go to prod if functionality still works or has work around but will be fixed later
Lowcan go to prod if it will be fixed later

File details come from the government source that posted it. Updated .