Utility Plans & Tariffs Management - (ONB02US05)

Overall Coverage Summary

Total Coverage: 100% (20/20 Acceptance Criteria Covered)

• Total Test Cases: 20 (16 Functional + 4 Non-Functional)
• Total Acceptance Criteria: 20 (Based on user story requirements)
• Coverage Percentage: (20/20) × 100 = 100%

Test Scenario Summary

A. Functional Test Scenarios

Core Functionality:

• Overview Dashboard display and metrics calculation
• Plans Management CRUD operations with 4-step wizard
• Tariffs Management with rate configuration and validation
• Version control and audit trail functionality
• Status management (Active/Inactive/Expired)

Business Rules:

• Plan configuration validation and unique naming
• Tariff overlap prevention and date validation
• Rate configuration rules for different types (Flat/Slab/Seasonal/Time-based)
• Plan-Tariff relationship enforcement
• Service charges and consumer category mapping

User Journeys:

• Utility Administrator: Dashboard monitoring and status management
• Billing Manager: Tariff creation and configuration workflows
• Billing Specialist: Plan explanations and customer support

Integration Points:

• Authentication and authorization system
• Billing calculation engine
• Customer account management system
• Audit logging service

B. Non-Functional Test Scenarios

Performance: Page load times <1 second, dashboard rendering, bulk operations
Security: Role-based access control, data validation, audit trail protection
Usability: Responsive design, guided workflows, contextual help
Reliability: Data integrity, concurrent user handling, error recovery

C. Edge Case & Error Scenarios

Boundary Conditions: Date overlaps, maximum field lengths, rate limits
Invalid Inputs: Malformed data, unauthorized access, invalid date ranges
System Failures: Network timeouts, service unavailability
Data Inconsistencies: Duplicate plans, missing tariff references

---

Test Cases

TEST CASE 1: Overview Dashboard Display with Total Plans, Tariffs and Active Subscribers

Test Case Metadata

• Test Case ID: ONB02US05_TC_001
• Title: Verify Overview Dashboard displays total plans, total tariffs, and active subscribers with growth indicators (AC-1)
• Created By: Arpita
• Created Date: June 03, 2025
• Version: 1.0

Classification

• Module/Feature: Utility Plans & Tariffs Management
• Test Type: Functional/UI
• Test Level: System
• Priority: P1-Critical
• Execution Phase: Smoke
• Automation Status: Manual

Enhanced Tags

• Tags: MOD-Overview, P1-Critical, Phase-Smoke, Type-Functional, Platform-Web, Report-Engineering, Customer-All, Risk-Medium, Business-Critical, Revenue-Impact-Medium, authServices, OnbServices, cxServices, Database, HappyPath, Performance

Business Context

• Customer_Segment: All
• Revenue_Impact: Medium
• Business_Priority: Must-Have
• Customer_Journey: Daily-Usage
• Compliance_Required: Yes
• SLA_Related: Yes

Quality Metrics

• Risk_Level: Medium
• Complexity_Level: Low
• Expected_Execution_Time: 3 minutes
• Reproducibility_Score: High
• Data_Sensitivity: Medium
• Failure_Impact: High

Coverage Tracking

• Functional_Coverage: Status differentiation logic
• UI_Coverage: Visual indicator rendering
• Business_Rule_Coverage: Active/Inactive status rules
• Integration_Coverage: Database status queries
• Accessibility_Coverage: Color-blind friendly indicators

Requirements Traceability

• Related_Requirements: Acceptance Criteria 1
• Related_Bugs: N/A
• Related_Test_Cases: ONB02US05_TC_002, ONB02US05_TC_003

Test Environment

• Environment: Staging
• Browser/Version: Chrome Latest
• Device/OS: Windows 10/11
• Screen_Resolution: Desktop-1920x1080
• Dependencies: Authentication service, Database connection
• Performance_Baseline: <1 second page load

Prerequisites

• Setup_Requirements: Valid user credentials with appropriate permissions
• User_Roles_Permissions: Utility Administrator, Billing Manager, or Billing Specialist (All Roles)
• Test_Data: Existing plans and tariffs in system
• Prior_Test_Cases: User authentication successful

Test Procedure

Step #	Action	Expected Result	Test Data	Comments
1	Navigate to Plans & Tariffs section	Overview tab is selected by default	Valid user credentials	Verify page loads within 1 second
2	Verify Total Plans metric	Shows "12" with "4 active, 8 inactive" breakdown	Sample data from user story	Numbers should match database counts
3	Verify Total Tariffs metric	Shows "25" with "18 active, 7 inactive" breakdown	Sample data from user story	Real-time calculation
4	Verify Active Subscribers metric	Shows "1,284" with "+7.2% from last month" growth indicator	Sample data from user story	Growth percentage calculation
5	Check Recently Updated Plans section	Shows "Residential Basic", "Business Premium", "Summer Special" with timestamps	Recent modification data	Chronological order
6	Check Recently Updated Tariffs section	Shows "Standard Electricity Rate", "Peak Hour Rate", "Winter Discount" with timestamps	Recent modification data	Chronological order
7	Verify "View all plans" and "View all tariffs" links	Links navigate to respective management sections	Navigation functionality	Links should be functional

Verification Points

• Primary_Verification: All metrics display correctly with accurate counts and growth indicators
• Secondary_Verifications: Recent updates show chronologically, timestamps are accurate
• Negative_Verification: No broken links or missing data elements

---

TEST CASE 2: Active and Inactive Plans/Tariffs Differentiation

Test Case Metadata

• Test Case ID: ONB02US05_TC_002
• Title: Verify system clearly differentiates between active and inactive plans/tariffs on overview screen (AC-2)
• Created By: Arpita
• Created Date: June 03, 2025
• Version: 1.0

Classification

• Module/Feature: Utility Plans & Tariffs Management
• Test Type: Functional/UI
• Test Level: System
• Priority: P1-Critical
• Execution Phase: Smoke
• Automation Status: Manual

Enhanced Tags

• Tags: MOD-Overview, P1-Critical, Phase-Smoke, Type-Functional, Platform-Web, Report-Engineering, Customer-All, Risk-Medium, Business-Critical, Revenue-Impact-Medium, authServices, cxServices, Database, HappyPath

Business Context

• Customer_Segment: All
• Revenue_Impact: Medium
• Business_Priority: Must-Have
• Customer_Journey: Daily-Usage
• Compliance_Required: Yes
• SLA_Related: Yes

Quality Metrics

• Risk_Level: Medium
• Complexity_Level: Low
• Expected_Execution_Time: 4 minutes
• Reproducibility_Score: High
• Data_Sensitivity: Medium
• Failure_Impact: High

Coverage Tracking

• Functional_Coverage: Status differentiation logic
• UI_Coverage: Visual indicator rendering
• Business_Rule_Coverage: Active/Inactive status rules
• Integration_Coverage: Database status queries
• Accessibility_Coverage: Color-blind friendly indicators

Requirements Traceability

• Related_Requirements: Acceptance Criteria 2
• Related_Bugs: N/A
• Related_Test_Cases: ONB02US05_TC_001, ONB02US05_TC_003

Test Environment

• Environment: Staging
• Browser/Version: Chrome Latest
• Device/OS: Windows 10/11
• Dependencies: Authentication service, Database connection

Prerequisites

• User_Roles_Permissions: Utility Administrator, Billing Manager, or Billing Specialist
• Test_Data: Mix of active and inactive plans/tariffs in system

Test Procedure

Step #	Action	Expected Result	Test Data	Comments
1	Navigate to Overview dashboard	Dashboard loads successfully	Valid credentials	Access overview
2	Verify active plans display	Shows "4 active" with distinct visual indicator	Active plans data	Green/positive indicator
3	Verify inactive plans display	Shows "8 inactive" with distinct visual indicator	Inactive plans data	Gray/neutral indicator
4	Verify active tariffs display	Shows "18 active" with distinct visual indicator	Active tariffs data	Visual differentiation
5	Verify inactive tariffs display	Shows "7 inactive" with distinct visual indicator	Inactive tariffs data	Status clarity
6	Check status color coding	Active items use different colors than inactive	Color scheme	Visual accessibility

Verification Points

• Primary_Verification: Clear visual distinction between active and inactive items
• Secondary_Verifications: Color coding consistent, counts accurate
• Negative_Verification: No ambiguity in status representation

---

TEST CASE 3: Recently Updated Plans and Tariffs Display

Test Case Metadata

• Test Case ID: ONB02US05_TC_003
• Title: Verify system displays recently updated plans and tariffs with timestamps and categories (AC-3)
• Created By: Arpita
• Created Date: June 03, 2025
• Version: 1.0

Classification

• Module/Feature: Utility Plans & Tariffs Management
• Test Type: Functional/UI
• Test Level: System
• Priority: P2-High
• Execution Phase: Regression
• Automation Status: Manual

Enhanced Tags

• Tags: MOD-Overview, P2-High, Phase-Regression, Type-Functional, Platform-Web, Report-Engineering, Customer-All, Risk-Low, Business-High, Revenue-Impact-Low, auth Services, cx Services, Database, HappyPath

Business Context

• Customer_Segment: All
• Revenue_Impact: Low
• Business_Priority: Should-Have
• Customer_Journey: Daily-Usage
• Compliance_Required: No
• SLA_Related: Yes

Quality Metrics

• Risk_Level: Low
• Complexity_Level: Low
• Expected_Execution_Time: 5 minutes
• Reproducibility_Score: High
• Data_Sensitivity: Low
• Failure_Impact: Medium

Coverage Tracking

• Functional_Coverage: Recent updates display logic
• UI_Coverage: Timestamp formatting and display
• Business_Rule_Coverage: Chronological ordering rules
• Integration_Coverage: Real-time data updates
• Performance_Coverage: Update refresh mechanisms

Requirements Traceability

• Related_Requirements: Acceptance Criteria 3
• Related_Bugs: N/A
• Related_Test_Cases: ONB02US05_TC_001, ONB02US05_TC_002

Prerequisites

• Setup_Requirements: Valid user credentials, Recent tariff/plan modifications in system
• User_Roles_Permissions: Utility Administrator, Billing Manager, or Billing Specialist
• Test_Data: Recently modified plans and tariffs with timestamps
• Prior_Test_Cases: ONB02US05_TC_001 (Dashboard access), Recent modifications completed

Test Procedure

Step #	Action	Expected Result	Test Data	Comments
1	Access Overview dashboard	Dashboard displays recent updates sections	Navigation	Recent data visibility
2	Verify Recently Updated Plans section	Shows plan names with timestamps	"Residential Basic", "Business Premium", "Summer Special", "Today, 10:30 AM"	Chronological order
3	Check plan timestamps	Displays accurate modification times	Recent modification data	Time accuracy
4	Verify Recently Updated Tariffs section	Shows tariff names with timestamps	"Standard Electricity Rate", "Peak Hour Rate", "Winter Discount" "Today, 9:45 AM"	Recent updates
5	Check tariff timestamps	Displays accurate modification times	Recent modification data	Chronological display
6	Verify categories display	Shows utility type/category for each item	Plan/Tariff categories	Category identification

Verification Points

• Primary_Verification: Recent updates display with accurate timestamps and categories
• Secondary_Verifications: Chronological order maintained, categories clearly shown
• Negative_Verification: No missing timestamps or category information

---

TEST CASE 4: Multiple Rate Types Support

Test Case Metadata

• Test Case ID: ONB02US05_TC_004
• Title: Verify system supports at least four different rate types: Flat, Slab, Fixed, and Seasonal (AC-4)
• Created By: Arpita
• Created Date: June 03, 2025
• Version: 1.0

Classification

• Module/Feature: Utility Plans & Tariffs Management
• Test Type: Functional
• Test Level: System
• Priority: P1-Critical
• Execution Phase: Regression
• Automation Status: Planned-for-Automation

Enhanced Tags

• Tags: MOD-Tariffs, P1-Critical, Phase-Regression, Type-Functional, Platform-Web, Report-Product, Customer-All, Risk-High, Business-Critical, Revenue-Impact-High, bx Services, mx Services, Database, HappyPath, Performance

Business Context

• Customer_Segment: All
• Revenue_Impact: High
• Business_Priority: Must-Have
• Customer_Journey: Configuration-Setup
• Compliance_Required: Yes
• SLA_Related: Yes

Quality Metrics

• Risk_Level: High
• Complexity_Level: Medium
• Expected_Execution_Time: 8 minutes
• Reproducibility_Score: High
• Data_Sensitivity: High
• Failure_Impact: Critical

Requirements Traceability

• Related_Requirements: Acceptance Criteria 4
• Related_Bugs: N/A
• Related_Test_Cases: ONB02US05_TC_007, ONB02US05_TC_008

Test Environment

• Environment: Staging
• Browser/Version: Chrome Latest
• Device/OS: Windows 10/11
• Screen_Resolution: Desktop-1920x1080
• Dependencies: Authentication service, Database connection, Tariff configuration module
• Performance_Baseline: <3 seconds for rate type selection

Prerequisites

• Setup_Requirements: Valid user credentials with tariff creation permissions, Clean test environment
• User_Roles_Permissions: Billing Manager or Utility Administrator
• Test_Data: Rate type configuration data (Flat: $0.12/unit, Slab: multiple tiers, Fixed: $50/month, Seasonal: summer/winter rates)
• Prior_Test_Cases: ONB02US05_TC_001 (Dashboard access), User authentication successful

Test Procedure

Step #	Action	Expected Result	Test Data	Comments
1	Navigate to Add Tariff form	Tariff creation form opens	Navigation	Access rate configuration
2	Check Rate Type dropdown	Shows Flat, Slab, Fixed, Seasonal options minimum	Rate type options	Required rate types
3	Select Flat rate type	Flat rate configuration interface displays	"Flat" selection	Single rate input
4	Select Slab rate type	Slab configuration with tier options	"Slab" selection	Multiple tier interface
5	Select Fixed rate type	Fixed rate configuration interface	"Fixed" selection	Fixed rate setup
6	Select Seasonal rate type	Seasonal date range configuration	"Seasonal" selection	Date-based rates
7	Verify Time-based option	Time-based rate type available	Additional rate type	Peak/off-peak rates

Verification Points

• Primary_Verification: All four required rate types available and functional
• Secondary_Verifications: Each rate type shows appropriate configuration interface
• Negative_Verification: No missing rate type options

---

TEST CASE 5: Multiple Utility Types Support

Test Case Metadata

• Test Case ID: ONB02US05_TC_005
• Title: Verify system supports at least three utility types: Water, Gas, and Electricity (AC-5)
• Created By: Arpita
• Created Date: June 03, 2025
• Version: 1.0

Classification

• Module/Feature: Utility Plans & Tariffs Management
• Test Type: Functional
• Test Level: System
• Priority: P1-Critical
• Execution Phase: Regression
• Automation Status: Manual

Enhanced Tags

• Tags: MOD-Utilities, P1-Critical, Phase-Regression, Type-Functional, Platform-Web, Report-Product, Customer-All, Risk-Medium, Business-Critical, Revenue-Impact-High, bx Services, mx Services, Database, HappyPath, Performance

Business Context

• Customer_Segment: All
• Revenue_Impact: High
• Business_Priority: Must-Have
• Customer_Journey: Configuration-Setup
• Compliance_Required: Yes
• SLA_Related: Yes

Quality Metrics

• Risk_Level: Medium
• Complexity_Level: Low
• Expected_Execution_Time: 5 minutes
• Reproducibility_Score: High
• Data_Sensitivity: Medium
• Failure_Impact: High

Requirements Traceability

• Related_Requirements: Acceptance Criteria 5
• Related_Bugs: N/A
• Related_Test_Cases: ONB02US05_TC_004, ONB02US05_TC_006

Test Environment

• Environment: Staging
• Browser/Version: Chrome Latest
• Device/OS: Windows 10/11
• Screen_Resolution: Desktop-1920x1080
• Dependencies: Authentication service, Database connection, Utility configuration module
• Performance_Baseline: <2 seconds for utility type selection

Prerequisites

• Setup_Requirements: Valid user credentials with tariff creation permissions, Utility types configured in system
• User_Roles_Permissions: Billing Manager or Utility Administrator
• Test_Data: Utility type options (Electricity, Water, Gas), Utility-specific rate configurations
• Prior_Test_Cases: ONB02US05_TC_001 (Dashboard access), User authentication successful

Test Procedure

Step #	Action	Expected Result	Test Data	Comments
1	Navigate to Tariff creation	Access utility type selection	Navigation	Utility configuration
2	Check Utility Type dropdown	Shows Water, Gas, Electricity minimum	Utility options	Required utility types
3	Select Electricity utility	Electricity-specific options display	"Electricity" selection	Utility-specific settings
4	Select Water utility	Water-specific configuration shows	"Water" selection	Water utility settings
5	Select Gas utility	Gas-specific options available	"Gas" selection	Gas utility configuration
6	Verify utility-specific rates	Rate names filtered by utility type	Utility-rate mapping	Dynamic filtering

Verification Points

• Primary_Verification: All three required utility types supported
• Secondary_Verifications: Utility-specific configurations available
• Negative_Verification: No missing utility type options

---

TEST CASE 6: Tariff Overlap Validation Prevention

Test Case Metadata

• Test Case ID: ONB02US05_TC_006
• Title: Verify system prevents overlapping validity periods for tariffs of same utility and rate type (AC-6)
• Created By: Arpita
• Created Date: June 03, 2025
• Version: 1.0

Classification

• Module/Feature: Utility Plans & Tariffs Management
• Test Type: Functional
• Test Level: System
• Priority: P1-Critical
• Execution Phase: Regression
• Automation Status: Manual

Enhanced Tags

• Tags: MOD-Tariffs, P1-Critical, Phase-Regression, Type-Functional, Platform-Web, Report-Product, Customer-All, Risk-High, Business-Critical, Revenue-Impact-High, bx Services, mx Services, Database, Negative, EdgeCase

Business Context

• Customer_Segment: All
• Revenue_Impact: High
• Business_Priority: Must-Have
• Compliance_Required: Yes

Requirements Traceability

• Related_Requirements: Acceptance Criteria 6
• Related_Bugs: N/A
  
  Quality Metrics
• Risk_Level: High
• Complexity_Level: Medium
• Expected_Execution_Time: 6 minutes
• Reproducibility_Score: High
• Data_Sensitivity: High
• Failure_Impact: Critical

Coverage Tracking

• Functional_Coverage: Date overlap validation logic
• Business_Rule_Coverage: Tariff uniqueness constraints
• Integration_Coverage: Database constraint validation
• Error_Handling_Coverage: Validation error messaging
• Edge_Case_Coverage: Boundary date conditions

Test Environment

• Environment: Staging
• Browser/Version: Chrome Latest
• Device/OS: Windows 10/11
• Screen_Resolution: Desktop-1920x1080
• Dependencies: Authentication service, Database connection, Validation service
• Performance_Baseline: <2 seconds for validation check

Prerequisites

• User_Roles_Permissions: Billing Manager or Utility Administrator (All Roles)
• Test_Data:
  • Existing Tariff: "Electricity Standard" (Jan 1, 2025 - Mar 31, 2025)
  • New Tariff: "Electricity Premium" (Feb 1, 2025 - Jul 31, 2025)

Test Procedure

Step #	Action	Expected Result	Test Data	Comments
1	Navigate to Tariff Management	Tariff listing page displays	Navigation	Access tariff section
2	Click "Add Tariff" button	Tariff creation form opens	Form access	Modal or new page
3	Enter tariff name	Field accepts unique name	"Electricity Premium"	Name validation
4	Select Utility Type	Dropdown selection	"Electricity"	Same as existing tariff
5	Select Rate Type	Dropdown selection	"Flat"	Same as existing tariff
6	Set validity period (overlapping)	Date fields with overlapping period	Start: Feb 1, 2025, End: Jul 31, 2025	Overlaps with existing
7	Attempt to save tariff	System displays overlap validation error	Save action	Error message with conflicting tariff name
8	Modify dates to non-overlapping	Adjust start date to after existing tariff	Start: Apr 1, 2025, End: Jul 31, 2025	Non-overlapping period
9	Save tariff	Tariff created successfully	Modified dates	Validation passes

Verification Points

• Primary_Verification: System prevents overlapping tariffs and shows specific error message
• Secondary_Verifications: Error message identifies conflicting tariff, non-overlapping dates work
• Negative_Verification: Cannot save overlapping tariffs

---

TEST CASE 7: Guided Step-by-Step Tariff Creation Form

Test Case Metadata

• Test Case ID: ONB02US05_TC_007
• Title: Verify system provides guided, step-by-step form for creating new tariffs (AC-7)
• Created By: Arpita
• Created Date: June 03, 2025
• Version: 1.0

Classification

• Module/Feature: Utility Plans & Tariffs Management
• Test Type: Functional
• Test Level: System
• Priority: P1-Critical
• Execution Phase: Regression
• Automation Status: Planned-for-Automation

Enhanced Tags

• Tags: MOD-Tariffs, P1-Critical, Phase-Regression, Type-Functional, Platform-Web, Report-Product, Customer-All, Risk-Medium, Business-Critical, Revenue-Impact-High, bx Services, Onb Services, Database, HappyPath, Performance

Business Context

• Customer_Segment: All
• Revenue_Impact: High
• Business_Priority: Must-Have
• Customer_Journey: Configuration-Setup
• Compliance_Required: Yes
• SLA_Related: Yes

Quality Metrics

• Risk_Level: Medium
• Complexity_Level: Medium
• Expected_Execution_Time: 10 minutes
• Reproducibility_Score: High
• Data_Sensitivity: High
• Failure_Impact: High

Requirements Traceability

• Related_Requirements: Acceptance Criteria 7
• Related_Bugs: N/A
• Related_Test_Cases: ONB02US05_TC_004, ONB02US05_TC_008

Test Environment

• Environment: Staging
• Browser/Version: Chrome Latest
• Device/OS: Windows 10/11
• Screen_Resolution: Desktop-1920x1080
• Dependencies: Authentication service, Database connection, Form validation service
• Performance_Baseline: <3 seconds for step transitions

Prerequisites

• Setup_Requirements: Valid user credentials with tariff creation permissions, Clean test environment, Form wizard enabled
• User_Roles_Permissions: Billing Manager or Utility Administrator
• Test_Data: Complete tariff data (Name: "Premium Business Electric", Utility: Electricity, Rate Type: Slab, Validity: 01/01/2025-12/31/2025)
• Prior_Test_Cases: ONB02US05_TC_001 (Dashboard access), ONB02US05_TC_004 (Rate types available)

Test Procedure

Step #	Action	Expected Result	Test Data	Comments
1	Click "Add Tariff" button	Guided form wizard opens	Navigation	Step-by-step interface
2	Verify form steps/sections	Clear indication of multiple steps	Form structure	Guided workflow
3	Complete basic tariff details	Progress to next step enabled	Tariff name, utility type	Step progression
4	Verify contextual help	Help text and tips displayed	Help indicators	User guidance
5	Complete rate configuration	Guided rate setup interface	Rate type selection	Configuration guidance
6	Verify validation messages	Clear error messages for invalid inputs	Invalid data	Error guidance
7	Complete tariff creation	All steps completed successfully	Complete tariff data	End-to-end workflow

Verification Points

• Primary_Verification: Guided workflow with clear step progression
• Secondary_Verifications: Contextual help available, validation guidance provided
• Negative_Verification: Cannot skip required steps

---

TEST CASE 8: Slab-Based Rate Configuration with Multiple Consumption Tiers

Test Case Metadata

• Test Case ID: ONB02US05_TC_008
• Title: Verify system allows configuration of slab-based rates with multiple consumption tiers (AC-8)
• Created By: Arpita
• Created Date: June 03, 2025
• Version: 1.0

Classification

• Module/Feature: Utility Plans & Tariffs Management
• Test Type: Functional
• Test Level: System
• Priority: P2-High
• Execution Phase: Regression
• Automation Status: Planned-for-Automation

Enhanced Tags

• Tags: MOD-Tariffs, P2-High, Phase-Regression, Type-Functional, Platform-Web, Report-Product, Customer-All, Risk-High, Business-Critical, Revenue-Impact-High, bx Services, mx Services, Database, HappyPath, Performance, EdgeCase

Business Context

• Customer_Segment: Commercial
• Revenue_Impact: High
• Business_Priority: Must-Have
• Customer_Journey: Configuration-Setup
• Compliance_Required: Yes
• SLA_Related: Yes

Quality Metrics

• Risk_Level: High
• Complexity_Level: High
• Expected_Execution_Time: 12 minutes
• Reproducibility_Score: High
• Data_Sensitivity: High
• Failure_Impact: Critical

Requirements Traceability

• Related_Requirements: Acceptance Criteria 8
• Related_Bugs: N/A
• Related_Test_Cases: ONB02US05_TC_004, ONB02US05_TC_009

Test Environment

• Environment: Staging
• Browser/Version: Chrome Latest
• Device/OS: Windows 10/11
• Screen_Resolution: Desktop-1920x1080
• Dependencies: Authentication service, Database connection, Rate calculation engine
• Performance_Baseline: <5 seconds for slab configuration save

Prerequisites

• Setup_Requirements: Valid user credentials with tariff creation permissions, Slab rate configuration enabled
• User_Roles_Permissions: Billing Manager or Utility Administrator
• Test_Data: Commercial Water Basic slab configuration from user story
• Prior_Test_Cases: ONB02US05_TC_007 (Guided form access), Rate type selection successful

Test Procedure

Step #	Action	Expected Result	Test Data	Comments
1	Create new tariff with Slab rate type	Slab configuration interface displays	Tariff: "Commercial Water Basic"	Rate type selection
2	Configure first slab (0-100 units)	Slab row added with From=0, To=100	Unit Rate: $0.08	First slab starts from 0
3	Add second slab (101-500 units)	New slab row, validates no overlap	Unit Rate: $0.10	Sequential ranges
4	Add third slab (501-1000 units)	New slab row continues sequence	Unit Rate: $0.12	Range continuation
5	Add final slab (1001+ units)	Slab with no upper limit	Unit Rate: $0.15, To: "No limit"	Open-ended range
6	Verify slab validation	System prevents overlapping ranges	Invalid slab data	Range validation
7	Save slab configuration	Tariff saved with complete slab structure	All slab data	Validation successful

Verification Points

• Primary_Verification: Slab rates configured correctly with proper range validation
• Secondary_Verifications: Multiple tiers supported, no gaps in consumption ranges
• Negative_Verification: Cannot create overlapping or gap ranges

---

TEST CASE 9: Automatic Sample Billing Calculations Display

Test Case Metadata

• Test Case ID: ONB02US05_TC_009
• Title: Verify system automatically calculates and displays sample billing amounts for different consumption levels (AC-9)
• Created By: Arpita
• Created Date: June 03, 2025
• Version: 1.0

Classification

• Module/Feature: Utility Plans & Tariffs Management
• Test Type: Functional
• Test Level: System
• Priority: P2-High
• Execution Phase: Regression
• Automation Status: Automated

Enhanced Tags

• Tags: MOD-Tariffs, P2-High, Phase-Regression, Type-Functional, Platform-Web, Report-Product, Customer-All, Risk-Medium, Business-High, Revenue-Impact-Medium, bx Services, cx Services, API, Database, HappyPath, Performance

Business Context

• Customer_Segment: All
• Revenue_Impact: Medium
• Business_Priority: Must-Have
• Customer_Journey: Configuration-Review
• Compliance_Required: Yes
• SLA_Related: Yes

Quality Metrics

• Risk_Level: Medium
• Complexity_Level: Medium
• Expected_Execution_Time: 6 minutes
• Reproducibility_Score: High
• Data_Sensitivity: Medium
• Failure_Impact: Medium

Coverage Tracking

• Functional_Coverage: Automatic calculation engine
• Business_Rule_Coverage: Rate calculation accuracy
• Integration_Coverage: Billing engine integration
• Performance_Coverage: Real-time calculation speed
• Accuracy_Coverage: Mathematical precision validation

Test Environment

• Environment: Staging
• Browser/Version: Chrome Latest
• Device/OS: Windows 10/11
• Screen_Resolution: Desktop-1920x1080
• Dependencies: Authentication service, Database connection, Calculation engine
• Performance_Baseline: <1 second for sample calculations

Prerequisites

• Setup_Requirements: Valid user credentials, Calculation engine operational
• User_Roles_Permissions: Billing Manager or Utility Administrator
• Test_Data: Various rate configurations for calculation testing
• Prior_Test_Cases: ONB02US05_TC_008 (Slab configuration), Rate setup completedBusiness Context
• Customer_Segment: All
• Revenue_Impact: Medium
• Business_Priority: Must-Have
• Customer_Journey: Configuration-Review
• Compliance_Required: Yes
• SLA_Related: Yes

Quality Metrics

• Risk_Level: Medium
• Complexity_Level: Medium
• Expected_Execution_Time: 6 minutes
• Reproducibility_Score: High
• Data_Sensitivity: Medium
• Failure_Impact: Medium

Coverage Tracking

• Functional_Coverage: Automatic calculation engine
• Business_Rule_Coverage: Rate calculation accuracy
• Integration_Coverage: Billing engine integration
• Performance_Coverage: Real-time calculation speed
• Accuracy_Coverage: Mathematical precision validation

Test Environment

• Environment: Staging
• Browser/Version: Chrome Latest
• Device/OS: Windows 10/11
• Screen_Resolution: Desktop-1920x1080
• Dependencies: Authentication service, Database connection, Calculation engine
• Performance_Baseline: <1 second for sample calculations

Prerequisites

• Setup_Requirements: Valid user credentials, Calculation engine operational
• User_Roles_Permissions: Billing Manager or Utility Administrator
• Test_Data: Various rate configurations for calculation testing
• Prior_Test_Cases: ONB02US05_TC_008 (Slab configuration), Rate setup completed

Test Procedure

Step #	Action	Expected Result	Test Data	Comments
1	Configure slab rate tariff	Slab configuration completed	Commercial Water Basic example	Rate setup
2	Verify sample calculations display	System shows billing examples automatically	Various consumption levels	Auto-calculation
3	Check 100 units calculation	Shows $8.00 (100 × $0.08)	100 units consumption	First slab calculation
4	Check 600 units calculation	Shows $78.00 (100×$0.08 + 400×$0.10 + 100×$0.12)	600 units consumption	Multi-slab calculation
5	Verify flat rate calculations	Shows simple multiplication for flat rates	Flat rate example	Flat rate calculation
6	Check seasonal rate examples	Shows different seasonal calculations	Seasonal rate data	Season-based billing
7	Verify calculation accuracy	All sample calculations mathematically correct	Various scenarios	Math validation

Verification Points

• Primary_Verification: Sample billing calculations display automatically and accurately
• Secondary_Verifications: Different rate types show appropriate examples
• Negative_Verification: No calculation errors or missing examples

---

TEST CASE 10: Complete Version History for Tariffs

Test Case Metadata

• Test Case ID: ONB02US05_TC_010
• Title: Verify system maintains complete version history for all tariffs including who made changes and when (AC-10)
• Created By: Arpita
• Created Date: June 03, 2025
• Version: 1.0

Classification

• Module/Feature: Utility Plans & Tariffs Management
• Test Type: Functional
• Test Level: System
• Priority: P2-High
• Execution Phase: Regression
• Automation Status: Manual

Enhanced Tags

• Tags: MOD-Audit, P2-High, Phase-Regression, Type-Functional, Platform-Web, Report-Product, Customer-All, Risk-Medium, Business-High, Revenue-Impact-Medium, ax Services, rx Services, API, Database, HappyPath

Business Context

• Customer_Segment: All
• Revenue_Impact: Medium
• Business_Priority: Must-Have
• Customer_Journey: Audit-Compliance
• Compliance_Required: Yes
• SLA_Related: Yes

Quality Metrics

• Risk_Level: Medium
• Complexity_Level: Medium
• Expected_Execution_Time: 8 minutes
• Reproducibility_Score: High
• Data_Sensitivity: High
• Failure_Impact: High

Coverage Tracking

• Functional_Coverage: Version control system
• Audit_Coverage: Complete change tracking
• Business_Rule_Coverage: Version increment logic
• Integration_Coverage: Audit service integration
• Compliance_Coverage: Regulatory audit requirements

Requirements Traceability

• Related_Requirements: Acceptance Criteria 10
• Related_Bugs: N/A

Test Environment

• Environment: Staging
• Browser/Version: Chrome Latest
• Device/OS: Windows 10/11
• Screen_Resolution: Desktop-1920x1080
• Dependencies: Authentication service, Database connection, Version control service, Audit logging
• Performance_Baseline: <3 seconds for version history load

Prerequisites

• Setup_Requirements: Valid user credentials with audit access, Version control enabled
• User_Roles_Permissions: Billing Manager, Billing Specialist, or Utility Administrator
• Test_Data: Existing tariff "Standard Residential Electricity" with version history
• Prior_Test_Cases: ONB02US05_TC_007 (Tariff creation), Multiple tariff modifications completed

Test Procedure

Step #	Action	Expected Result	Test Data	Comments
1	Navigate to existing tariff	Tariff details page displays	"Standard Residential Electricity"	Access existing tariff
2	Click "Version History"	Version history modal/page opens	Historical data	Shows all versions
3	Verify version list	All versions displayed chronologically	v1.0, v2.0, v3.0	Reverse chronological order
4	Check version details	Each version shows user, date, changes	Version metadata	Complete audit information
5	Modify tariff unit rate	Edit current version	Change from $0.12 to $0.15	Rate modification
6	Save with change summary	New version created automatically	Version incremented to v4.0	Auto-versioning
7	Verify new version in history	Latest version appears in history	v4.0 with current user and timestamp	Audit trail updated
8	Check user attribution	Shows who made each change	User identification	Change accountability

Verification Points

• Primary_Verification: All changes tracked with complete audit information including user and timestamp
• Secondary_Verifications: Version history complete, change summaries accurate
• Negative_Verification: Cannot modify archived versions directly

---

TEST CASE 11: Tariff Status Display with Visual Indicators

Test Case Metadata

• Test Case ID: ONB02US05_TC_011
• Title: Verify system displays status (Active, Expired, Inactive) of each tariff with appropriate visual indicators (AC-11)
• Created By: Arpita
• Created Date: June 03, 2025
• Version: 1.0

Classification

• Module/Feature: Utility Plans & Tariffs Management
• Test Type: Functional/UI
• Test Level: System
• Priority: P2-High
• Execution Phase: Regression
• Automation Status: Manual

Business Context

• Customer_Segment: All
• Revenue_Impact: Low
• Business_Priority: Must-Have
• Customer_Journey: Daily-Usage
• Compliance_Required: No
• SLA_Related: Yes

Quality Metrics

• Risk_Level: Low
• Complexity_Level: Low
• Expected_Execution_Time: 4 minutes
• Reproducibility_Score: High
• Data_Sensitivity: Low
• Failure_Impact: Low

Coverage Tracking

• Functional_Coverage: Status display logic
• UI_Coverage: Visual indicator consistency
• Business_Rule_Coverage: Status determination rules
• Accessibility_Coverage: Color-blind accessibility
• Performance_Coverage: Status rendering speed

Enhanced Tags

• Tags: MOD-Tariffs, P2-High, Phase-Regression, Type-Functional, Platform-Web, Report-Engineering, Customer-All, Risk-Low, Business-High, Revenue-Impact-Low, cxServices, Database, HappyPath

Requirements Traceability

• Related_Requirements: Acceptance Criteria 11
• Related_Bugs: N/A

Test Environment

• Environment: Staging
• Browser/Version: Chrome Latest
• Device/OS: Windows 10/11
• Screen_Resolution: Desktop-1920x1080
• Dependencies: Authentication service, Database connection, UI rendering service
• Performance_Baseline: <1 second for status display

Prerequisites

• Setup_Requirements: Valid user credentials, Mix of tariffs with different statuses
• User_Roles_Permissions: Any authorized user (Billing Manager, Specialist, Administrator)
• Test_Data: Tariffs with Active, Expired, and Inactive statuses
• Prior_Test_Cases: ONB02US05_TC_001 (Dashboard access), Multiple tariffs created

Test Procedure

Step #	Action	Expected Result	Test Data	Comments
1	Navigate to Tariff Management	Tariff listing displays with status indicators	Navigation	Access tariff list
2	Verify Active tariff indicators	Active tariffs show green/positive visual indicator	Active tariffs	Status visibility
3	Verify Expired tariff indicators	Expired tariffs show red/warning visual indicator	Expired tariffs	Expiry indication
4	Verify pending tariff indicators	Pending tariffs show Yellow/neutral visual indicator	Pending tariffs	Pending status
5	Check status text labels	Clear text labels accompany visual indicators	Status labels	Text + visual clarity
6	Verify status consistency	Same status shows same indicator throughout system	Consistent indicators	UI consistency
7	Test status filtering	Can filter tariffs by status	Filter functionality	Status-based filtering

Verification Points

• Primary_Verification: All tariff statuses display with appropriate visual indicators
• Secondary_Verifications: Visual indicators consistent, text labels clear
• Negative_Verification: No ambiguous status representations

---

TEST CASE 12: Upload and Download Tariff Data in Standard Formats

Test Case Metadata

• Test Case ID: ONB02US05_TC_012
• Title: Verify system allows authorized users to upload and download tariff data in standard formats (AC-12)
• Created By: Arpita
• Created Date: June 03, 2025
• Version: 1.0

Classification

• Module/Feature: Utility Plans & Tariffs Management
• Test Type: Functional
• Test Level: Integration
• Priority: P3-Medium
• Execution Phase: Regression
• Automation Status: Planned-for-Automation

Enhanced Tags

• Tags: MOD-DataOps, P3-Medium, Phase-Regression, Type-Functional, Platform-Web, Report-Product, Customer-All, Risk-Medium, Business-Medium, Revenue-Impact-Low, bx Services, mx Services, API, Database, HappyPath, EdgeCase

Business Context

• Customer_Segment: All
• Revenue_Impact: Low
• Business_Priority: Should-Have
• Customer_Journey: Data-Management
• Compliance_Required: No
• SLA_Related: No

Quality Metrics

• Risk_Level: Medium
• Complexity_Level: Medium
• Expected_Execution_Time: 15 minutes
• Reproducibility_Score: High
• Data_Sensitivity: High
• Failure_Impact: Medium

Requirements Traceability

• Related_Requirements: Acceptance Criteria 12
• Related_Bugs: N/A
• Related_Test_Cases: ONB02US05_TC_013, ONB02US05_TC_019

Test Environment

• Environment: Staging
• Browser/Version: Chrome Latest
• Device/OS: Windows 10/11
• Screen_Resolution: Desktop-1920x1080
• Dependencies: Authentication service, Database connection, File processing service
• Performance_Baseline: <10 seconds for 100 records export/import

Prerequisites

• Setup_Requirements: Valid user credentials with data export/import permissions, File upload capability enabled
• User_Roles_Permissions: Billing Manager or Utility Administrator
• Test_Data: Sample tariff data for export (minimum 5 tariffs), Valid CSV template, Modified CSV for import testing
• Prior_Test_Cases: ONB02US05_TC_001 (Dashboard access), Tariff creation successful

Test Procedure

Step #	Action	Expected Result	Test Data	Comments
1	Export tariffs to CSV	File generated with correct format	Tariff export	Data format validation
2	Verify exported data	All tariff fields included correctly	CSV content	Data completeness
3	Verify CSV format	Standard CSV format with proper headers	Export file	Format compliance
4	Modify exported CSV	Make valid changes to data	Edited CSV	Data preparation
5	Import modified CSV	Data imported successfully	Import file	Bulk operations
6	Verify imported changes	Changes reflected in system	Updated records	Data synchronization
7	Test import validation	Invalid data rejected with errors