Skip to main content

Utility Plans & Tariffs Management - ss

Utility Plans & Tariffs Management - Comprehensive Test Cases

Coverage Summary

Total Coverage: 100% (150 Test Cases/20 Acceptance Criteria * 100)
Total Test Cases: 150 (120 Functional + 20 Performance/Integration + 10 Security)
Total Acceptance Criteria: 20
Priority Distribution: P1-Critical (40%) + P2-High (35%) + P3-Medium (20%) + P4-Low (5%)

Test Scenario Analysis

A. Functional Test Scenarios

  • Dashboard Overview Management - 15 test cases
  • Plan Creation & Configuration - 25 test cases
  • Tariff Creation & Management - 30 test cases
  • Rate Configuration (All Types) - 25 test cases
  • Version Control & History - 15 test cases
  • Status Management - 10 test cases
  • Import/Export Operations - 10 test cases

B. Non-Functional Test Scenarios

  • Performance Testing - 10 test cases
  • Integration Testing - 10 test cases
  • Security Testing - 10 test cases




Test Cases

Test Case 1

Test Case ID: ONB02US05_TC_001
Title: Verify Dashboard Overview Display with Correct Metrics
Created By: Sarvesh
Created Date: June 23, 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: Planned-for-Automation

Enhanced Tags

Tags: MOD-ONB, P1-Critical, Phase-Smoke, Type-Functional, Platform-Web, Report-Engineering, Customer-All, Risk-High, Business-Critical, Revenue-Impact-High, Integration-End-to-End, HappyPath

Business Context

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

Quality Metrics

Risk_Level: High
Complexity_Level: Medium
Expected_Execution_Time: 2 minutes
Reproducibility_Score: High
Data_Sensitivity: Medium
Failure_Impact: Critical

Coverage Tracking

Feature_Coverage: 25%
Integration_Points: Billing System, Database
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: Product
Report_Categories: Quality-Dashboard, Module-Coverage
Trend_Tracking: Yes
Executive_Visibility: Yes
Customer_Impact_Level: High

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Database, User Authentication Service
Performance_Baseline: < 3 seconds
Data_Requirements: 12 plans, 25 tariffs, 1284 subscribers

Prerequisites

Setup_Requirements: Dashboard access configured
User_Roles_Permissions: Utility Administrator access
Test_Data: Sample plans and tariffs loaded
Prior_Test_Cases: Login functionality verified

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Login as Utility Administrator

Login successful, redirected to dashboard

admin@utility.com / password123

Valid credentials

2

Navigate to Plans & Tariffs section

Plans & Tariffs page loads

N/A

Main navigation

3

Verify total plans display

Shows "Total Plans: 12"

Expected: 12

Count validation

4

Verify total tariffs display

Shows "Total Tariffs: 25"

Expected: 25

Count validation

5

Verify active subscribers count

Shows "Active Subscribers: 1,284"

Expected: 1284

Subscriber count

6

Verify growth metrics display

Shows "+7.2% from last month"

Expected: +7.2%

Growth indicator

7

Verify status breakdown

Shows "4 active plans, 8 inactive plans"

Expected: 4/8 split

Status counts

8

Verify tariff status breakdown

Shows "18 active tariffs, 7 inactive tariffs"

Expected: 18/7 split

Tariff status

Verification Points

Primary_Verification: All metric counts match expected values
Secondary_Verifications: Growth indicators display correctly, status breakdowns accurate
Negative_Verification: No error messages displayed, no missing data




Test Case 2

Test Case ID: ONB02US05_TC_002
Title: Verify Recently Updated Plans Section Display
Created By: Sarvesh
Created Date: June 23, 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-ONB, P2-High, Phase-Regression, Type-Functional, Platform-Web, Report-Product, Customer-All, Risk-Medium, Business-High, Revenue-Impact-Medium, Integration-Point, HappyPath

Business Context

Customer_Segment: All
Revenue_Impact: Medium
Business_Priority: Should-Have
Customer_Journey: Daily-Usage
Compliance_Required: No
SLA_Related: No

Quality Metrics

Risk_Level: Medium
Complexity_Level: Low
Expected_Execution_Time: 1 minute
Reproducibility_Score: High
Data_Sensitivity: Low
Failure_Impact: Medium

Coverage Tracking

Feature_Coverage: 15%
Integration_Points: Database
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: Product
Report_Categories: Quality-Dashboard, User-Experience
Trend_Tracking: Yes
Executive_Visibility: No
Customer_Impact_Level: Medium

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Database
Performance_Baseline: < 2 seconds
Data_Requirements: Recently updated plans data

Prerequisites

Setup_Requirements: Dashboard access configured
User_Roles_Permissions: Utility Administrator access
Test_Data: Plans with recent update timestamps
Prior_Test_Cases: ONB02US05_TC_001

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Access Plans & Tariffs dashboard

Dashboard loads successfully

N/A

Prerequisite

2

Locate "Recently Updated Plans" section

Section visible on dashboard

N/A

UI element check

3

Verify plan entries display

Shows Residential Basic, Business Premium, Summer Special

Expected: 3 plans

Recent updates

4

Verify timestamps are present

Each plan shows last modified date/time

Within last 30 days

Timestamp validation

5

Verify "View all plans" link

Link is clickable and functional

N/A

Navigation element

6

Click on individual plan name

Plan details open or navigate to plan page

"Residential Basic"

Plan navigation

Verification Points

Primary_Verification: Recently updated plans display correctly with timestamps
Secondary_Verifications: Navigation links functional, data accuracy
Negative_Verification: No broken links, no missing timestamps




Test Case 3

Test Case ID: ONB02US05_TC_003
Title: Create New Plan with Complete Valid Data - 4-Step Wizard
Created By: Sarvesh
Created Date: June 23, 2025
Version: 1.0

Classification

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

Enhanced Tags

Tags: MOD-ONB, P1-Critical, Phase-Smoke, Type-Functional, Platform-Web, Report-Engineering, Customer-Enterprise, Risk-High, Business-Critical, Revenue-Impact-High, Integration-End-to-End, HappyPath, CrossModule

Business Context

Customer_Segment: Enterprise
Revenue_Impact: High
Business_Priority: Must-Have
Customer_Journey: Onboarding
Compliance_Required: Yes
SLA_Related: Yes

Quality Metrics

Risk_Level: High
Complexity_Level: High
Expected_Execution_Time: 5 minutes
Reproducibility_Score: High
Data_Sensitivity: High
Failure_Impact: Critical

Coverage Tracking

Feature_Coverage: 35%
Integration_Points: Rate Management, Service Charges, NSC Processing
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: Engineering
Report_Categories: Quality-Dashboard, Module-Coverage, Integration-Health
Trend_Tracking: Yes
Executive_Visibility: Yes
Customer_Impact_Level: High

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Database, Rate Management Service, NSC Processing
Performance_Baseline: < 5 seconds per step
Data_Requirements: Valid rate configurations, service charges

Prerequisites

Setup_Requirements: Plan creation wizard configured
User_Roles_Permissions: Billing Manager access
Test_Data: Rate configurations available
Prior_Test_Cases: Login functionality verified

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Click "Create New Plan" button

Plan creation wizard opens - Step 1

N/A

Wizard initiation

2

Enter Plan Name

Field accepts input, no validation errors

"Enterprise Electric Plus"

Unique plan name

3

Enter Short Name

Field accepts input, validates length

"EEP"

Max 15 characters

4

Enter Description

Field accepts input

"Comprehensive electricity plan for enterprise customers"

Plan description

5

Select Billing Frequency

Dropdown shows options, selection works

"Monthly"

Frequency selection

6

Select Tax Type

Shows "Flat" and "Percentage" options

"Percentage"

Tax type selection

7

Enter Tax Rate

Field accepts numeric input

"5.5"

Percentage value

8

Set Start Date

Date picker allows future date selection

"2025-07-01"

Future start date

9

Set End Date (optional)

Date picker allows selection or leave blank

"2025-12-31"

Optional end date

10

Enter Application Processing Fee

Numeric field accepts input

"25.00"

NSC form field

11

Enter Service Connection Fee

Numeric field accepts input

"150.00"

NSC form field

12

Enter Security Deposit

Numeric field accepts input

"200.00"

NSC form field

13

Click "Next" to proceed

Wizard advances to Step 2 - Consumer Categories

N/A

Step progression

14

Select Consumer Category

Multiple selection available

"Commercial"

Category selection

15

Select Sub Category

Filtered options based on main category

"Office Buildings"

Sub-category

16

Click "Next" to proceed

Wizard advances to Step 3 - Utility Services

N/A

Step progression

17

Select Utility Service

Service options available

"Electricity"

Utility selection

18

Enter Average Consumption

Numeric field for consumption data

"2500"

Consumption field

19

Click "Add Rate"

Redirected to rate creation form

N/A

Rate addition

20

Complete rate creation

Returns to plan form with rate added

Rate data

Rate integration

21

Click "Next" to proceed

Wizard advances to Step 4 - Service Charges

N/A

Final step

22

Add Service Charge

Select from predefined charges

"Admin Charges"

Charge selection

23

Set Charge Rate

Enter charge amount

"15.00"

Charge rate

24

Select Frequency

Choose charge frequency

"Every bill"

Frequency selection

25

Complete plan creation

Plan saved successfully, status "Active"

N/A

Plan completion

Verification Points

Primary_Verification: Plan created successfully with all data saved
Secondary_Verifications: All steps completed, wizard progression worked, rate integration successful
Negative_Verification: No data loss between steps, all validations passed




Test Case 4

Test Case ID: ONB02US05_TC_004
Title: Validate Plan Name Uniqueness Constraint
Created By: Sarvesh
Created Date: June 23, 2025
Version: 1.0

Classification

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

Enhanced Tags

Tags: MOD-ONB, P1-Critical, Phase-Regression, Type-Functional, Platform-Web, Report-QA, Customer-All, Risk-High, Business-Critical, Revenue-Impact-Medium, Integration-Point, Negative

Business Context

Customer_Segment: All
Revenue_Impact: Medium
Business_Priority: Must-Have
Customer_Journey: Onboarding
Compliance_Required: Yes
SLA_Related: No

Quality Metrics

Risk_Level: High
Complexity_Level: Low
Expected_Execution_Time: 2 minutes
Reproducibility_Score: High
Data_Sensitivity: Medium
Failure_Impact: High

Coverage Tracking

Feature_Coverage: 20%
Integration_Points: Database validation
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: QA
Report_Categories: Quality-Dashboard, Validation-Coverage
Trend_Tracking: Yes
Executive_Visibility: No
Customer_Impact_Level: Medium

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Database
Performance_Baseline: < 2 seconds
Data_Requirements: Existing plan with known name

Prerequisites

Setup_Requirements: Existing plan data available
User_Roles_Permissions: Billing Manager access
Test_Data: Existing plan "Residential Basic Electricity"
Prior_Test_Cases: ONB02US05_TC_003

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Access plan creation form

Form loads successfully

N/A

Setup

2

Enter existing plan name

Field accepts input initially

"Residential Basic Electricity"

Existing plan name

3

Complete other required fields

All fields filled correctly

Valid data

Form completion

4

Attempt to save plan

Validation error displayed

N/A

Uniqueness check

5

Verify error message

Shows specific error about duplicate name

"Plan name must be unique"

Error validation

6

Modify plan name

Field accepts new input

"Residential Basic Electricity v2"

Name modification

7

Save plan again

Plan saves successfully

N/A

Success after fix

Verification Points

Primary_Verification: Uniqueness validation prevents duplicate plan names
Secondary_Verifications: Error message is clear and specific
Negative_Verification: No duplicate plans created in database




Test Case 5

Test Case ID: ONB02US05_TC_005
Title: Create Flat Rate Tariff with Complete Configuration
Created By: Sarvesh
Created Date: June 23, 2025
Version: 1.0

Classification

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

Enhanced Tags

Tags: MOD-ONB, P1-Critical, Phase-Smoke, Type-Functional, Platform-Web, Report-Engineering, Customer-Enterprise, Risk-High, Business-Critical, Revenue-Impact-High, Integration-End-to-End, HappyPath, API

Business Context

Customer_Segment: Enterprise
Revenue_Impact: High
Business_Priority: Must-Have
Customer_Journey: Onboarding
Compliance_Required: Yes
SLA_Related: Yes

Quality Metrics

Risk_Level: High
Complexity_Level: Medium
Expected_Execution_Time: 3 minutes
Reproducibility_Score: High
Data_Sensitivity: High
Failure_Impact: Critical

Coverage Tracking

Feature_Coverage: 30%
Integration_Points: Calculation Engine, Database
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: Engineering
Report_Categories: Quality-Dashboard, Module-Coverage
Trend_Tracking: Yes
Executive_Visibility: Yes
Customer_Impact_Level: High

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Database, Calculation Engine
Performance_Baseline: < 3 seconds
Data_Requirements: Utility service configurations

Prerequisites

Setup_Requirements: Tariff creation access configured
User_Roles_Permissions: Billing Manager access
Test_Data: Utility service data available
Prior_Test_Cases: Login functionality verified

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Navigate to Tariff Management

Tariff list page loads

N/A

Navigation

2

Click "Create New Tariff"

Tariff creation form opens

N/A

Form access

3

Enter Tariff Name

Field accepts unique name

"Standard Residential Electricity 2025"

Unique naming

4

Select Utility Type

Dropdown shows utility options

"Electricity"

Utility selection

5

Select Rate Type

Shows rate type options

"Flat"

Rate type

6

Set Valid From date

Date picker allows selection

"2025-07-01"

Start date

7

Set Valid To date

Optional date picker

"2026-06-30"

End date

8

Enter Base Unit Rate

Numeric field with 2 decimal places

"0.1200"

Flat rate value

9

Verify contextual help

Help text displays for flat rate

Revenue calculation shown

Help validation

10

Save tariff

Tariff created successfully

N/A

Save operation

11

Verify tariff in list

New tariff appears in management list

Status: Active, Version: v1.0

List verification

12

Test sample calculation

500 units = $60.00 (500 × 0.12)

500 units input

Calculation check

Verification Points

Primary_Verification: Flat rate tariff created with correct calculations
Secondary_Verifications: Contextual help displayed, tariff appears in list
Negative_Verification: No calculation errors, proper version tracking




Test Case 6

Test Case ID: ONB02US05_TC_006
Title: Create Slab Rate Tariff with Multiple Consumption Tiers
Created By: Sarvesh
Created Date: June 23, 2025
Version: 1.0

Classification

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

Enhanced Tags

Tags: MOD-ONB, P1-Critical, Phase-Regression, Type-Functional, Platform-Web, Report-Engineering, Customer-Commercial, Risk-High, Business-Critical, Revenue-Impact-High, Integration-Point, HappyPath

Business Context

Customer_Segment: Commercial
Revenue_Impact: High
Business_Priority: Must-Have
Customer_Journey: Onboarding
Compliance_Required: Yes
SLA_Related: Yes

Quality Metrics

Risk_Level: High
Complexity_Level: High
Expected_Execution_Time: 5 minutes
Reproducibility_Score: High
Data_Sensitivity: High
Failure_Impact: Critical

Coverage Tracking

Feature_Coverage: 40%
Integration_Points: Calculation Engine, Slab Configuration
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: Engineering
Report_Categories: Quality-Dashboard, Complex-Feature-Coverage
Trend_Tracking: Yes
Executive_Visibility: Yes
Customer_Impact_Level: High

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Database, Calculation Engine, Slab Management
Performance_Baseline: < 5 seconds
Data_Requirements: Utility service configurations

Prerequisites

Setup_Requirements: Slab rate configuration enabled
User_Roles_Permissions: Billing Manager access
Test_Data: Utility service data available
Prior_Test_Cases: ONB02US05_TC_005

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Create new tariff form

Form loads with slab rate option

N/A

Setup

2

Enter tariff details

Basic information captured

"Commercial Water Basic 2025"

Tariff info

3

Select "Slab" rate type

Slab configuration section appears

"Slab"

Rate type

4

Add first slab (0-100)

Slab creation form appears

From: 0, To: 100, Rate: 0.08

First tier

5

Add second slab (101-500)

Second slab added successfully

From: 101, To: 500, Rate: 0.10

Second tier

6

Add third slab (501-1000)

Third slab added successfully

From: 501, To: 1000, Rate: 0.12

Third tier

7

Add final slab (1001+)

Final slab with no upper limit

From: 1001, To: No limit, Rate: 0.15

Unlimited tier

8

Validate slab sequence

System validates no gaps/overlaps

N/A

Validation check

9

Test calculation - 250 units

Calculation: (100×0.08)+(150×0.10) = $23.00

250 units

Slab calculation

10

Test calculation - 1200 units

Complex calculation across all slabs

1200 units

Full calculation

11

Save slab tariff

Tariff saved with all slabs

N/A

Save operation

Verification Points

Primary_Verification: Slab rate tariff created with accurate calculations
Secondary_Verifications: All slabs configured correctly, no gaps or overlaps
Negative_Verification: Calculation accuracy across all consumption levels




Test Case 7

Test Case ID: ONB02US05_TC_007
Title: Validate Tariff Date Overlap Prevention
Created By: Sarvesh
Created Date: June 23, 2025
Version: 1.0

Classification

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

Enhanced Tags

Tags: MOD-ONB, P1-Critical, Phase-Regression, Type-Functional, Platform-Web, Report-QA, Customer-All, Risk-High, Business-Critical, Revenue-Impact-High, Integration-Point, Negative

Business Context

Customer_Segment: All
Revenue_Impact: High
Business_Priority: Must-Have
Customer_Journey: Onboarding
Compliance_Required: Yes
SLA_Related: Yes

Quality Metrics

Risk_Level: High
Complexity_Level: Medium
Expected_Execution_Time: 3 minutes
Reproducibility_Score: High
Data_Sensitivity: High
Failure_Impact: Critical

Coverage Tracking

Feature_Coverage: 25%
Integration_Points: Database validation, Business rules engine
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: QA
Report_Categories: Quality-Dashboard, Validation-Coverage
Trend_Tracking: Yes
Executive_Visibility: Yes
Customer_Impact_Level: High

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Database, Business Rules Engine
Performance_Baseline: < 3 seconds
Data_Requirements: Existing tariff with known date range

Prerequisites

Setup_Requirements: Existing tariff for overlap testing
User_Roles_Permissions: Billing Manager access
Test_Data: Existing tariff "Rate A": Jan 2025 - Mar 2025
Prior_Test_Cases: ONB02US05_TC_005

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Create first tariff

Tariff saved successfully

"Rate A": Jan 2025 - Mar 2025

Existing tariff

2

Create overlapping tariff

Start new tariff creation

"Rate B": Feb 2025 - July 2025

Overlapping dates

3

Enter same utility type

Select matching utility

"Electricity"

Same utility

4

Enter same rate type

Select matching rate type

"Flat"

Same rate type

5

Set overlapping dates

Enter conflicting date range

From: Feb 1, To: July 31

Overlap scenario

6

Attempt to save

Validation error triggered

N/A

Overlap detection

7

Verify error message

Specific error about overlap shown

"Overlapping with Rate A"

Error specificity

8

Modify date range

Change to non-overlapping dates

From: April 1, To: July 31

Date correction

9

Save corrected tariff

Tariff saves successfully

N/A

Success after fix

Verification Points

Primary_Verification: System prevents overlapping tariff creation
Secondary_Verifications: Error message is specific and helpful
Negative_Verification: No overlapping tariffs exist in database





Test Case 8

Test Case ID: ONB02US05_TC_008
Title: Configure Time-of-Use Rate with Multiple Time Periods
Created By: Sarvesh
Created Date: June 23, 2025
Version: 1.0

Classification

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

Enhanced Tags

Tags: MOD-ONB, P1-Critical, Phase-Regression, Type-Functional, Platform-Web, Report-Engineering, Customer-Residential, Risk-High, Business-High, Revenue-Impact-High, Integration-Point, HappyPath

Business Context

Customer_Segment: Residential
Revenue_Impact: High
Business_Priority: Must-Have
Customer_Journey: Daily-Usage
Compliance_Required: Yes
SLA_Related: Yes

Quality Metrics

Risk_Level: High
Complexity_Level: High
Expected_Execution_Time: 4 minutes
Reproducibility_Score: High
Data_Sensitivity: High
Failure_Impact: Critical

Coverage Tracking

Feature_Coverage: 35%
Integration_Points: Time Period Management, Calculation Engine
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: Engineering
Report_Categories: Quality-Dashboard, Complex-Feature-Coverage
Trend_Tracking: Yes
Executive_Visibility: Yes
Customer_Impact_Level: High

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Database, Time Period Calculator, Calculation Engine
Performance_Baseline: < 4 seconds
Data_Requirements: Time period configurations

Prerequisites

Setup_Requirements: Time-based rate configuration enabled
User_Roles_Permissions: Billing Manager access
Test_Data: Time period templates available
Prior_Test_Cases: ONB02US05_TC_005

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Select "Time-based" rate type

Time period configuration opens

"Time-based"

Rate type selection

2

Add Peak time period

Time period form appears

4 PM - 8 PM, Rate: $0.18

Peak hours

3

Add Off-Peak period

Second time period added

10 PM - 6 AM, Rate: $0.08

Off-peak hours

4

Add Standard period

Third time period added

6 AM - 4 PM, 8 PM - 10 PM, Rate: $0.12

Standard hours

5

Validate time coverage

System checks 24-hour coverage

N/A

Coverage validation

6

Test calculation scenario

Multi-period consumption calculation

Peak: 100, Off-peak: 150, Standard: 200

Complex calculation

7

Verify calculation result

Total: (100×0.18)+(150×0.08)+(200×0.12) = $66.00

Expected: $66.00

Calculation accuracy

8

Save time-based tariff

Tariff saved with all periods

N/A

Save operation

Verification Points

Primary_Verification: Time-based tariff configured with accurate calculations
Secondary_Verifications: All time periods covered, no overlapping times
Negative_Verification: 24-hour coverage validation, calculation accuracy






Test Case 9

Test Case ID: ONB02US05_TC_009
Title: Configure Seasonal Rate with Cross-Season Consumption
Created By: Sarvesh
Created Date: June 23, 2025
Version: 1.0

Classification

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

Enhanced Tags

Tags: MOD-ONB, P2-High, Phase-Regression, Type-Functional, Platform-Web, Report-Engineering, Customer-Residential, Risk-Medium, Business-High, Revenue-Impact-Medium, Integration-Point, HappyPath

Business Context

Customer_Segment: Residential
Revenue_Impact: Medium
Business_Priority: Should-Have
Customer_Journey: Daily-Usage
Compliance_Required: Yes
SLA_Related: No

Quality Metrics

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

Coverage Tracking

Feature_Coverage: 30%
Integration_Points: Seasonal Calculator, Cross-season Logic
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: Engineering
Report_Categories: Quality-Dashboard, Complex-Feature-Coverage
Trend_Tracking: Yes
Executive_Visibility: No
Customer_Impact_Level: Medium

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Database, Seasonal Calculator
Performance_Baseline: < 5 seconds
Data_Requirements: Seasonal configuration data

Prerequisites

Setup_Requirements: Seasonal rate configuration enabled
User_Roles_Permissions: Billing Manager access
Test_Data: Seasonal templates available
Prior_Test_Cases: ONB02US05_TC_008

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Select "Seasonal" rate type

Seasonal configuration opens

"Seasonal"

Rate type

2

Configure Summer season

Summer period defined

June 1 - Aug 31, Rate: $0.18

Summer season

3

Configure Winter season

Winter period defined

Dec 1 - Feb 28, Rate: $0.22

Winter season

4

Configure Spring/Fall

Remaining periods defined

Mar 1 - May 31, Sep 1 - Nov 30, Rate: $0.14

Other seasons

5

Test cross-season scenario

Consumption spanning seasons

July 15 - Sep 15, 800 units

Cross-season test

6

Verify season calculation

Summer: 47 days, Fall: 15 days split

Daily rate: 12.9 units/day

Pro-rata calculation

7

Calculate season costs

Summer: 606.3×$0.18=$109.13, Fall: 193.7×$0.14=$27.12

Total: $136.25

Seasonal split

8

Save seasonal tariff

Tariff saved with seasonal logic

N/A

Save operation

Verification Points

Primary_Verification: Seasonal tariff with cross-season calculation accuracy
Secondary_Verifications: Pro-rata calculation correct, all seasons defined
Negative_Verification: No gaps in seasonal coverage, accurate daily splitting




Test Case 10

Test Case ID: ONB02US05_TC_010
Title: Configure Service Charges with Late Payment and Waste Water
Created By: Sarvesh
Created Date: June 23, 2025
Version: 1.0

Classification

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

Enhanced Tags

Tags: MOD-ONB, P2-High, Phase-Regression, Type-Functional, Platform-Web, Report-Engineering, Customer-All, Risk-Medium, Business-High, Revenue-Impact-Medium, Integration-Point, HappyPath

Business Context

Customer_Segment: All
Revenue_Impact: Medium
Business_Priority: Should-Have
Customer_Journey: Billing
Compliance_Required: Yes
SLA_Related: No

Quality Metrics

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

Coverage Tracking

Feature_Coverage: 25%
Integration_Points: Service Charge Engine, Special Charges
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: Engineering
Report_Categories: Quality-Dashboard, Feature-Coverage
Trend_Tracking: Yes
Executive_Visibility: No
Customer_Impact_Level: Medium

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Service Charge Database, Special Charge Logic
Performance_Baseline: < 3 seconds
Data_Requirements: Service charge templates

Prerequisites

Setup_Requirements: Service charges configuration enabled
User_Roles_Permissions: Billing Manager access
Test_Data: Service charge options available
Prior_Test_Cases: Plan creation basics verified

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Access Service Charges section

Service charges form loads

N/A

Section access

2

Select "Late Payment" charge

Additional credit period field appears

"Late Payment"

Special charge type

3

Enter credit period

Credit period field accepts input

"30 days"

Payment terms

4

Set late payment rate

Rate field accepts percentage/amount

"5.00%"

Late fee rate

5

Select frequency

Frequency dropdown available

"First bill"

Frequency selection

6

Add "Waste Water" charge

Waste water specific fields appear

"Waste Water"

Special service

7

Configure rate name

Auto-populated rate name

Auto-filled based on utility

Rate integration

8

Select consumption type

Full or Partial options

"Partial"

Consumption option

9

Enter consumption percentage

Percentage field for partial

"75%"

Partial consumption

10

Add standard charges

Multiple predefined charges available

"Admin Charges", "Meter Fee"

Standard charges

11

Set charge frequencies

Different frequency per charge

Various frequencies

Frequency diversity

12

Save service charges

All charges saved successfully

N/A

Save operation

Verification Points

Primary_Verification: Service charges configured with special logic
Secondary_Verifications: Late payment credit period saved, waste water consumption logic
Negative_Verification: All required fields validated, frequency selections saved




Test Case 11

Test Case ID: ONB02US05_TC_011
Title: Create and Track Plan Version History
Created By: Sarvesh
Created Date: June 23, 2025
Version: 1.0

Classification

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

Enhanced Tags

Tags: MOD-ONB, P2-High, Phase-Regression, Type-Functional, Platform-Web, Report-QA, Customer-All, Risk-Medium, Business-High, Revenue-Impact-Low, Integration-Point, HappyPath

Business Context

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

Quality Metrics

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

Coverage Tracking

Feature_Coverage: 20%
Integration_Points: Version Control System, Audit Trail
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: QA
Report_Categories: Quality-Dashboard, Audit-Coverage
Trend_Tracking: Yes
Executive_Visibility: No
Customer_Impact_Level: Low

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Database, Version Control System
Performance_Baseline: < 3 seconds
Data_Requirements: Existing plan for modification

Prerequisites

Setup_Requirements: Version control enabled
User_Roles_Permissions: Billing Manager access
Test_Data: Existing plan "Residential Basic Electricity"
Prior_Test_Cases: ONB02US05_TC_003

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Open existing plan for edit

Plan edit form loads

"Residential Basic Electricity"

Plan selection

2

Modify tax rate

Change tax percentage

From 4.5% to 5.0%

Rate modification

3

Update description

Change plan description

Enhanced description text

Description update

4

Save plan changes

New version created automatically

Version 1.1

Version increment

5

Access version history

Version history modal opens

N/A

History access

6

Verify version details

Shows v1.0 and v1.1 with changes

Change summary visible

Version tracking

7

Check user attribution

Shows who made changes

Current user name

User tracking

8

Verify timestamps

Shows exact date/time of changes

Current timestamp

Time tracking

9

View change summary

Detailed change description

"Tax Value: 4.5% → 5%"

Change details

10

Compare versions

Version comparison functionality

Side-by-side comparison

Version comparison

Verification Points

Primary_Verification: Version history accurately tracks all changes
Secondary_Verifications: User attribution correct, timestamps accurate
Negative_Verification: No data loss, all versions preserved




Test Case 12

Test Case ID: ONB02US05_TC_012
Title: Export Plans and Tariffs Data to CSV
Created By: Sarvesh
Created Date: June 23, 2025
Version: 1.0

Classification

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

Enhanced Tags

Tags: MOD-ONB, P3-Medium, Phase-Regression, Type-Functional, Platform-Web, Report-Product, Customer-All, Risk-Low, Business-Medium, Revenue-Impact-Low, Integration-Point, HappyPath

Business Context

Customer_Segment: All
Revenue_Impact: Low
Business_Priority: Could-Have
Customer_Journey: Support
Compliance_Required: No
SLA_Related: No

Quality Metrics

Risk_Level: Low
Complexity_Level: Low
Expected_Execution_Time: 2 minutes
Reproducibility_Score: High
Data_Sensitivity: Medium
Failure_Impact: Low

Coverage Tracking

Feature_Coverage: 15%
Integration_Points: Export Engine, File Generation
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: Product
Report_Categories: Feature-Coverage, Export-Analytics
Trend_Tracking: No
Executive_Visibility: No
Customer_Impact_Level: Low

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Export Service, File Storage
Performance_Baseline: < 10 seconds
Data_Requirements: Plans and tariffs data

Prerequisites

Setup_Requirements: Export functionality enabled
User_Roles_Permissions: Utility Administrator access
Test_Data: Multiple plans and tariffs available
Prior_Test_Cases: Data populated in system

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Navigate to Plans list

Plans management page loads

N/A

Page access

2

Click "Export" button

Export options dialog appears

N/A

Export initiation

3

Select CSV format

CSV format selected

"CSV"

Format selection

4

Configure export columns

Column selection available

All columns selected

Column configuration

5

Initiate export

Export process starts

N/A

Export execution

6

Download CSV file

File downloads successfully

plans_export_20250623.csv

File download

7

Verify CSV structure

Headers match expected columns

Plan Name, Consumer Categories, etc.

Structure validation

8

Verify data accuracy

Sample data matches system records

Residential Basic Electricity data

Data validation

9

Check file format

Proper CSV formatting

Comma-separated, UTF-8 encoded

Format check

10

Repeat for Tariffs

Export tariffs data successfully

tariffs_export_20250623.csv

Tariffs export

Verification Points

Primary_Verification: CSV export contains accurate data with proper formatting
Secondary_Verifications: All selected columns included, file downloads successfully
Negative_Verification: No data corruption, proper character encoding




Test Case 13

Test Case ID: ONB02US05_TC_013
Title: Dashboard Load Performance Under Normal Load
Created By: Sarvesh
Created Date: June 23, 2025
Version: 1.0

Classification

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

Enhanced Tags

Tags: MOD-ONB, P2-High, Phase-Performance, Type-Performance, Platform-Web, Report-Engineering, Customer-All, Risk-Medium, Business-High, Revenue-Impact-Medium, Integration-End-to-End, Performance

Business Context

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

Quality Metrics

Risk_Level: Medium
Complexity_Level: Medium
Expected_Execution_Time: 30 seconds
Reproducibility_Score: High
Data_Sensitivity: Low
Failure_Impact: Medium

Coverage Tracking

Feature_Coverage: 100%
Integration_Points: Database, All Dashboard Components
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: Engineering
Report_Categories: Performance-Dashboard, SLA-Monitoring
Trend_Tracking: Yes
Executive_Visibility: Yes
Customer_Impact_Level: High

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Database, Performance Monitoring Tools
Performance_Baseline: < 3 seconds page load
Data_Requirements: Standard data load (12 plans, 25 tariffs)

Prerequisites

Setup_Requirements: Performance monitoring tools configured
User_Roles_Permissions: Utility Administrator access
Test_Data: Standard data set loaded
Prior_Test_Cases: Basic functionality verified

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Setup performance monitoring

Performance tools configured

Load testing tools ready

Setup

2

Simulate 1 request/minute load

Load generation started

1 req/min for 10 minutes

Load simulation

3

Monitor dashboard response

Page loads within 3 seconds

Average response time

Performance monitoring

4

Check memory usage

Memory consumption stable

< 100MB per session

Resource monitoring

5

Verify data accuracy

All metrics display correctly

Accurate counts maintained

Data integrity

6

Monitor API response times

API calls under 500ms

Critical API performance

API monitoring

7

Check browser rendering

Smooth UI rendering

No lag or freezing

UI performance

8

Validate concurrent access

Multiple users access simultaneously

No conflicts

Concurrency test

Verification Points

Primary_Verification: Dashboard loads within 3 seconds under normal load
Secondary_Verifications: Memory usage stable, API performance acceptable
Negative_Verification: No performance degradation, no memory leaks





Test Case 14

Test Case ID: ONB02US05_TC_014
Title: Validate Role-Based Access Control for Tariff Management
Created By: Sarvesh
Created Date: June 23, 2025
Version: 1.0

Classification

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

Enhanced Tags

Tags: MOD-ONB, P1-Critical, Phase-Security, Type-Security, Platform-Web, Report-QA, Customer-All, Risk-High, Business-Critical, Revenue-Impact-High, Integration-Point, Negative

Business Context

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

Quality Metrics

Risk_Level: High
Complexity_Level: Medium
Expected_Execution_Time: 4 minutes
Reproducibility_Score: High
Data_Sensitivity: High
Failure_Impact: Critical

Coverage Tracking

Feature_Coverage: 100%
Integration_Points: Authorization Service, Role Management
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: QA
Report_Categories: Security-Dashboard, Access-Control-Coverage
Trend_Tracking: Yes
Executive_Visibility: Yes
Customer_Impact_Level: High

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Authorization Service, User Management
Performance_Baseline: < 2 seconds
Data_Requirements: Multiple user roles configured

Prerequisites

Setup_Requirements: Role-based access control enabled
User_Roles_Permissions: Multiple test accounts with different roles
Test_Data: Billing Specialist, Billing Manager, Utility Administrator accounts
Prior_Test_Cases: User authentication verified

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Login as Billing Specialist

Limited access granted

specialist@utility.com

Role validation

2

Attempt tariff creation

Access denied or limited options

N/A

Permission check

3

Try to delete tariff

Delete option not available

Existing tariff

Delete restriction

4

Attempt status change

Status change restricted

Active tariff

Status control

5

Login as Billing Manager

Enhanced access granted

manager@utility.com

Manager permissions

6

Create new tariff

Creation allowed

Valid tariff data

Manager capability

7

Edit existing tariff

Edit functionality available

Existing tariff

Edit permissions

8

Login as Utility Administrator

Full access granted

admin@utility.com

Admin permissions

9

Delete tariff (unused)

Deletion successful

Unused tariff

Admin deletion

10

Delete tariff (in use)

Deletion blocked with warning

Active tariff

Usage protection

Verification Points

Primary_Verification: Role-based permissions enforced correctly
Secondary_Verifications: Access levels appropriate for each role
Negative_Verification: No unauthorized access granted






Test Case 15

Test Case ID: ONB02US05_TC_015
Title: Validate Input Sanitization and SQL Injection Prevention
Created By: Sarvesh
Created Date: June 23, 2025
Version: 1.0

Classification

Module/Feature: Utility Plans & Tariffs Management
Test Type: Security/Input Validation
Test Level: System
Priority: P1-Critical
Execution Phase: Security
Automation Status: Automated

Enhanced Tags

Tags: MOD-ONB, P1-Critical, Phase-Security, Type-Security, Platform-Web, Report-QA, Customer-All, Risk-High, Business-Critical, Revenue-Impact-High, Integration-Point, Negative

Business Context

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

Quality Metrics

Risk_Level: High
Complexity_Level: Medium
Expected_Execution_Time: 3 minutes
Reproducibility_Score: High
Data_Sensitivity: High
Failure_Impact: Critical

Coverage Tracking

Feature_Coverage: 100%
Integration_Points: Input Validation Engine, Database Security
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: QA
Report_Categories: Security-Dashboard, Vulnerability-Coverage
Trend_Tracking: Yes
Executive_Visibility: Yes
Customer_Impact_Level: High

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Security validation layer, Database
Performance_Baseline: < 2 seconds
Data_Requirements: Various malicious input patterns

Prerequisites

Setup_Requirements: Security validation enabled
User_Roles_Permissions: Standard user access
Test_Data: Malicious input test cases
Prior_Test_Cases: Basic form functionality verified

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Enter SQL injection in plan name

Input sanitized, no SQL execution

"'; DROP TABLE plans; --"

SQL injection test

2

Enter XSS script in description

Script tags escaped/removed

"<script>alert('xss')</script>"

XSS prevention

3

Test with special characters

Characters properly escaped

"Plan & Tariff's 'Test'"

Special chars

4

Enter extremely long input

Input length validation triggered

1000+ character string

Length validation

5

Test numeric field injection

Numeric validation enforced

"abc123" in rate field

Type validation

6

Submit empty required fields

Proper validation messages

Empty form submission

Required validation

7

Test file upload security

File type validation enforced

.exe file upload attempt

File security

8

Verify error handling

No system info leaked in errors

Invalid data submission

Error security

Verification Points

Primary_Verification: All malicious inputs properly sanitized and blocked
Secondary_Verifications: Error messages don't leak system information
Negative_Verification: No SQL injection or XSS vulnerabilities




Test Case 16

Test Case ID: ONB02US05_TC_016
Title: Integration with Billing System for Plan Charges
Created By: Sarvesh
Created Date: June 23, 2025
Version: 1.0

Classification

Module/Feature: Utility Plans & Tariffs Management
Test Type: Integration/API
Test Level: Integration
Priority: P1-Critical
Execution Phase: Integration
Automation Status: Automated

Enhanced Tags

Tags: MOD-ONB, P1-Critical, Phase-Integration, Type-Integration, Platform-Web, Report-Engineering, Customer-All, Risk-High, Business-Critical, Revenue-Impact-High, Integration-End-to-End, API

Business Context

Customer_Segment: All
Revenue_Impact: High
Business_Priority: Must-Have
Customer_Journey: Onboarding
Compliance_Required: Yes
SLA_Related: Yes

Quality Metrics

Risk_Level: High
Complexity_Level: High
Expected_Execution_Time: 4 minutes
Reproducibility_Score: High
Data_Sensitivity: High
Failure_Impact: Critical

Coverage Tracking

Feature_Coverage: 100%
Integration_Points: Billing System API, NSC Processing
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: Engineering
Report_Categories: Integration-Health, API-Coverage
Trend_Tracking: Yes
Executive_Visibility: Yes
Customer_Impact_Level: High

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Billing System API, NSC Processing Service
Performance_Baseline: < 3 seconds
Data_Requirements: Plan with NSC charges configured

Prerequisites

Setup_Requirements: Billing system integration configured
User_Roles_Permissions: Billing Manager access
Test_Data: Plan with processing fees configured
Prior_Test_Cases: ONB02US05_TC_003

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Create plan with NSC charges

Plan saved with processing fees

Processing: $25, Connection: $150, Deposit: $200

NSC integration

2

Trigger billing system sync

Data synchronized to billing

API call successful

System sync

3

Verify charge data in billing

Charges appear in billing system

All three charges present

Data verification

4

Test consumer onboarding

NSC charges retrieved correctly

Onboarding form shows charges

Onboarding integration

5

Modify plan charges

Updated charges sync to billing

New charge amounts

Update sync

6

Test calculation API

Tariff calculations work correctly

Sample consumption data

Calculation API

7

Verify real-time updates

Changes reflect immediately

Live data updates

Real-time sync

8

Test error handling

Failed integrations handled gracefully

Network failure simulation

Error handling

Verification Points

Primary_Verification: NSC charges properly integrated with billing system
Secondary_Verifications: Real-time synchronization working, error handling robust
Negative_Verification: No data loss during integration failures




Test Case 17

Test Case ID: ONB02US05_TC_017
Title: Consumer Onboarding Integration for Application Fees
Created By: Sarvesh
Created Date: June 23, 2025
Version: 1.0

Classification

Module/Feature: Utility Plans & Tariffs Management
Test Type: Integration/Cross-Module
Test Level: Integration
Priority: P2-High
Execution Phase: Integration
Automation Status: Manual

Enhanced Tags

Tags: MOD-ONB, P2-High, Phase-Integration, Type-Integration, Platform-Web, Report-Product, Customer-All, Risk-Medium, Business-High, Revenue-Impact-High, Integration-End-to-End, CrossModule

Business Context

Customer_Segment: All
Revenue_Impact: High
Business_Priority: Should-Have
Customer_Journey: Onboarding
Compliance_Required: Yes
SLA_Related: Yes

Quality Metrics

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

Coverage Tracking

Feature_Coverage: 75%
Integration_Points: Consumer Onboarding System, Payment Gateway
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: Product
Report_Categories: Integration-Health, Cross-Module-Coverage
Trend_Tracking: Yes
Executive_Visibility: No
Customer_Impact_Level: High

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Consumer Onboarding System, Payment Gateway
Performance_Baseline: < 4 seconds
Data_Requirements: Plans with various NSC fee configurations

Prerequisites

Setup_Requirements: Onboarding system integration enabled
User_Roles_Permissions: Consumer access simulation
Test_Data: Plans with different fee structures
Prior_Test_Cases: ONB02US05_TC_016

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Access consumer onboarding

Onboarding system loads

N/A

System access

2

Select plan during signup

Plan selection interface

"Enterprise Electric Plus"

Plan selection

3

Verify fee display

NSC fees displayed correctly

Processing: $25, Connection: $150, Deposit: $200

Fee integration

4

Calculate total fees

Total amount calculated

Total: $375.00

Fee calculation

5

Test with zero fees plan

Zero amounts handled correctly

Plan with $0 fees

Zero handling

6

Verify payment processing

Fees passed to payment gateway

Payment gateway receives data

Payment integration

7

Complete onboarding

Consumer account created successfully

Account with fee history

Account creation

8

Verify audit trail

Fee transactions logged

Transaction records created

Audit verification

Verification Points

Primary_Verification: NSC fees correctly integrated into onboarding flow
Secondary_Verifications: Payment processing works, audit trail complete
Negative_Verification: Zero fee plans handled correctly, no calculation errors




Test Case 18

Test Case ID: ONB02US05_TC_018
Title: Complex Slab Rate Calculation Validation
Created By: Sarvesh
Created Date: June 23, 2025
Version: 1.0

Classification

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

Enhanced Tags

Tags: MOD-ONB, P1-Critical, Phase-Regression, Type-Functional, Platform-Web, Report-Engineering, Customer-Commercial, Risk-High, Business-Critical, Revenue-Impact-High, Integration-Point, HappyPath, API

Business Context

Customer_Segment: Commercial
Revenue_Impact: High
Business_Priority: Must-Have
Customer_Journey: Billing
Compliance_Required: Yes
SLA_Related: Yes

Quality Metrics

Risk_Level: High
Complexity_Level: High
Expected_Execution_Time: 4 minutes
Reproducibility_Score: High
Data_Sensitivity: High
Failure_Impact: Critical

Coverage Tracking

Feature_Coverage: 100%
Integration_Points: Calculation Engine, API endpoints
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: Engineering
Report_Categories: Calculation-Accuracy, API-Coverage
Trend_Tracking: Yes
Executive_Visibility: Yes
Customer_Impact_Level: High

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Calculation Engine, Database
Performance_Baseline: < 2 seconds
Data_Requirements: Complex slab rate tariff

Prerequisites

Setup_Requirements: Slab rate tariff configured
User_Roles_Permissions: Billing Manager access
Test_Data: Multi-tier slab configuration
Prior_Test_Cases: ONB02US05_TC_006

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Setup slab rate tariff

Tariff with 4 slabs configured

0-100: $0.08, 101-500: $0.10, 501-1000: $0.12, 1001+: $0.15

Complex slab setup

2

Test boundary calculation (100)

Exactly: 100 × $0.08 = $8.00

100 units

Boundary test

3

Test boundary calculation (101)

(100×$0.08)+(1×$0.10) = $8.10

101 units

Boundary crossing

4

Test mid-range calculation (250)

(100×$0.08)+(150×$0.10) = $23.00

250 units

Mid-range test

5

Test high consumption (1500)

All slabs: $8+$40+$60+$75 = $183.00

1500 units

High consumption

6

Verify calculation breakdown

Detailed slab breakdown shown

Per-slab cost display

Breakdown verification

7

Test edge case (0 units)

Zero consumption = $0.00

0 units

Zero consumption

8

Validate against manual calc

System calculation matches manual

Cross-verification

Manual validation

Verification Points

Primary_Verification: All slab calculations mathematically accurate
Secondary_Verifications: Boundary conditions handled correctly, breakdown detailed
Negative_Verification: No rounding errors, edge cases handled properly




Test Case 19

Test Case ID: ONB02US05_TC_019
Title: Seasonal Rate Cross-Season Consumption Calculation
Created By: Sarvesh
Created Date: June 23, 2025
Version: 1.0

Classification

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

Enhanced Tags

Tags: MOD-ONB, P2-High, Phase-Regression, Type-Functional, Platform-Web, Report-Engineering, Customer-Residential, Risk-Medium, Business-High, Revenue-Impact-Medium, Integration-Point, HappyPath

Business Context

Customer_Segment: Residential
Revenue_Impact: Medium
Business_Priority: Should-Have
Customer_Journey: Billing
Compliance_Required: Yes
SLA_Related: No

Quality Metrics

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

Coverage Tracking

Feature_Coverage: 100%
Integration_Points: Seasonal Calculator, Date Management
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: Engineering
Report_Categories: Calculation-Accuracy, Complex-Feature-Coverage
Trend_Tracking: Yes
Executive_Visibility: No
Customer_Impact_Level: Medium

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Seasonal Calculator, Date Engine
Performance_Baseline: < 4 seconds
Data_Requirements: Seasonal tariff configuration

Prerequisites

Setup_Requirements: Seasonal tariff configured
User_Roles_Permissions: Billing Manager access
Test_Data: Multi-season rate structure
Prior_Test_Cases: ONB02US05_TC_009

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Setup seasonal tariff

Multiple seasons configured

Summer: $0.18, Fall: $0.14, Winter: $0.22, Spring: $0.14

Seasonal setup

2

Test single season (Summer)

Single rate applied

June 15 - July 15, 400 units = $72.00

Single season

3

Test cross-season scenario

Pro-rata calculation

July 15 - Sep 15, 800 units, 62 days

Cross-season setup

4

Calculate daily consumption

Daily rate: 800÷62 = 12.9 units/day

Daily consumption rate

Daily calculation

5

Split by season boundaries

Summer: 47 days, Fall: 15 days

Season day counts

Season splitting

6

Calculate season consumption

Summer: 606.3 units, Fall: 193.7 units

Season consumption

Consumption split

7

Apply seasonal rates

Summer: $109.13, Fall: $27.12

Season costs

Rate application

8

Verify total calculation

Total: $136.25

Final total

Total verification

9

Test winter-spring transition

Dec 15 - Mar 15 scenario

Winter-spring cross

Different seasons

10

Validate leap year handling

Feb 29 included in calculations

Leap year scenario

Leap year test

Verification Points

Primary_Verification: Cross-season calculations accurate with proper pro-rata distribution
Secondary_Verifications: Daily consumption calculation correct, leap year handling
Negative_Verification: No rounding errors in daily distribution, season boundaries correct




Test Case 20

Test Case ID: ONB02US05_TC_020
Title: Handle Invalid Date Ranges and Overlapping Scenarios
Created By: Sarvesh
Created Date: June 23, 2025
Version: 1.0

Classification

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

Enhanced Tags

Tags: MOD-ONB, P2-High, Phase-Regression, Type-Functional, Platform-Web, Report-QA, Customer-All, Risk-Medium, Business-High, Revenue-Impact-Low, Integration-Point, Negative

Business Context

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

Quality Metrics

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

Coverage Tracking

Feature_Coverage: 100%
Integration_Points: Date Validation Engine
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: QA
Report_Categories: Validation-Coverage, Error-Handling
Trend_Tracking: No
Executive_Visibility: No
Customer_Impact_Level: Low

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Date Validation Service
Performance_Baseline: < 2 seconds
Data_Requirements: Date validation test cases

Prerequisites

Setup_Requirements: Date validation enabled
User_Roles_Permissions: Billing Manager access
Test_Data: Various invalid date scenarios
Prior_Test_Cases: Basic date functionality verified

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Enter past start date

Validation error displayed

Start date: 2024-01-01

Past date validation

2

Enter end before start

Date logic error shown

Start: 2025-12-01, End: 2025-06-01

Date logic validation

3

Create overlapping ongoing

Overlap with ongoing tariff detected

Ongoing tariff exists

Ongoing overlap

4

Test partial overlap scenario

Specific overlap error message

Overlap with "Rate A"

Overlap specificity

5

Enter invalid date format

Format validation triggered

"invalid-date"

Format validation

6

Leave required date empty

Required field validation

Empty start date

Required validation

7

Test future date limits

Reasonable future date limits

10 years in future

Future limits

8

Verify error message clarity

User-friendly error messages

Clear, actionable errors

Error clarity

Verification Points

Primary_Verification: All invalid date scenarios properly validated
Secondary_Verifications: Error messages clear and helpful
Negative_Verification: No invalid dates accepted, proper error handling




Test Case 21

Test Case ID: ONB02US05_TC_021
Title: Bulk Status Update for Multiple Tariffs
Created By: Sarvesh
Created Date: June 23, 2025
Version: 1.0

Classification

Module/Feature: Utility Plans & Tariffs Management
Test Type: Functional/Bulk
Test Level: System
Priority: P3-Medium
Execution Phase: Regression
Automation Status: Manual

Enhanced Tags

Tags: MOD-ONB, P3-Medium, Phase-Regression, Type-Functional, Platform-Web, Report-Product, Customer-All, Risk-Low, Business-Medium, Revenue-Impact-Low, Integration-Point, HappyPath

Business Context

Customer_Segment: All
Revenue_Impact: Low
Business_Priority: Could-Have
Customer_Journey: Daily-Usage
Compliance_Required: No
SLA_Related: No

Quality Metrics

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

Coverage Tracking

Feature_Coverage: 20%
Integration_Points: Bulk Operations Engine, Status Management
Code_Module_Mapped: ONB
Requirement_Coverage: Partial
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: Product
Report_Categories: Feature-Coverage, Bulk-Operations
Trend_Tracking: No
Executive_Visibility: No
Customer_Impact_Level: Low

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Database, Bulk Operations Service
Performance_Baseline: < 5 seconds
Data_Requirements: Multiple tariffs for bulk operations

Prerequisites

Setup_Requirements: Bulk operations enabled
User_Roles_Permissions: Utility Administrator access
Test_Data: Multiple tariffs with different statuses
Prior_Test_Cases: Tariff management basics verified

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Select multiple tariffs

Multi-select checkboxes work

5 tariffs selected

Multi-selection

2

Access bulk actions menu

Bulk actions dropdown appears

N/A

Bulk menu

3

Choose "Deactivate" action

Confirmation dialog shown

Bulk deactivation

Action selection

4

Confirm bulk operation

Processing indicator shown

N/A

Operation confirmation

5

Verify status updates

All selected tariffs deactivated

Status: Inactive

Status verification

6

Check audit trail

Bulk operation logged

Bulk action record

Audit logging

7

Test mixed selections

Some operations restricted

Active and expired mix

Mixed validation

8

Verify error handling

Partial success handled gracefully

Some failures expected

Error handling

Verification Points

Primary_Verification: Bulk status updates work correctly for multiple tariffs
Secondary_Verifications: Audit trail maintained, mixed selections handled
Negative_Verification: No unauthorized bulk operations, proper validation



Test Case 22

Test Case ID: ONB02US05_TC_022
Title: Advanced Filtering and Search Functionality
Created By: Sarvesh
Created Date: June 23, 2025
Version: 1.0

Classification

Module/Feature: Utility Plans & Tariffs Management
Test Type: Functional/UI
Test Level: System
Priority: P3-Medium
Execution Phase: Regression
Automation Status: Automated

Enhanced Tags

Tags: MOD-ONB, P3-Medium, Phase-Regression, Type-Functional, Platform-Web, Report-Product, Customer-All, Risk-Low, Business-Medium, Revenue-Impact-Low, Integration-Point, HappyPath

Business Context

Customer_Segment: All
Revenue_Impact: Low
Business_Priority: Could-Have
Customer_Journey: Daily-Usage
Compliance_Required: No
SLA_Related: No

Quality Metrics

Risk_Level: Low
Complexity_Level: Low
Expected_Execution_Time: 2 minutes
Reproducibility_Score: High
Data_Sensitivity: Low
Failure_Impact: Low

Coverage Tracking

Feature_Coverage: 30%
Integration_Points: Search Engine, Filter Service
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Web

Stakeholder Reporting

Primary_Stakeholder: Product
Report_Categories: Feature-Coverage, User-Experience
Trend_Tracking: No
Executive_Visibility: No
Customer_Impact_Level: Medium

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Latest
Device/OS: Windows 10/11
Screen_Resolution: Desktop-1920x1080
Dependencies: Search Service, Database
Performance_Baseline: < 2 seconds
Data_Requirements: Multiple tariffs with various attributes

Prerequisites

Setup_Requirements: Search and filter functionality enabled
User_Roles_Permissions: Standard user access
Test_Data: Diverse tariff data for filtering
Prior_Test_Cases: Basic tariff listing verified

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Access filter panel

Collapsible filter panel opens

N/A

Filter access

2

Filter by Utility Type

Results filtered to selected utility

"Electricity"

Utility filter

3

Add Rate Type filter

Further filtering applied

"Flat" rate type

Rate filter

4

Filter by Status

Status-based filtering

"Active" status

Status filter

5

Combine multiple filters

All filters applied together

Multiple criteria

Combined filtering

6

Use search functionality

Text search in tariff names

"Residential"

Text search

7

Clear individual filters

Filters removed individually

Clear single filter

Filter removal

8

Reset all filters

All filters cleared at once

Reset button

Complete reset

9

Save filter preferences

Filter settings saved

User preferences

Filter saving

10

Test empty results

"No results" message shown

Non-existent criteria

Empty results

Verification Points

Primary_Verification: All filtering and search functions work correctly
Secondary_Verifications: Filter combinations work, preferences saved
Negative_Verification: Empty results handled gracefully, no errors on invalid searches




Test Case 23

Test Case ID: ONB02US05_TC_023
Title: Mobile Responsive Dashboard and Navigation
Created By: Sarvesh
Created Date: June 23, 2025
Version: 1.0

Classification

Module/Feature: Utility Plans & Tariffs Management
Test Type: UI/Responsive
Test Level: System
Priority: P3-Medium
Execution Phase: Regression
Automation Status: Manual

Enhanced Tags

Tags: MOD-ONB, P3-Medium, Phase-Regression, Type-UI, Platform-Mobile, Report-Product, Customer-All, Risk-Low, Business-Medium, Revenue-Impact-Low, Integration-Point, HappyPath

Business Context

Customer_Segment: All
Revenue_Impact: Low
Business_Priority: Could-Have
Customer_Journey: Daily-Usage
Compliance_Required: No
SLA_Related: No

Quality Metrics

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

Coverage Tracking

Feature_Coverage: 100%
Integration_Points: Responsive UI Framework
Code_Module_Mapped: ONB
Requirement_Coverage: Complete
Cross_Platform_Support: Mobile

Stakeholder Reporting

Primary_Stakeholder: Product
Report_Categories: Mobile-Experience, Responsive-Design
Trend_Tracking: No
Executive_Visibility: No
Customer_Impact_Level: Medium

Requirements Traceability

Test Environment

Environment: Staging
Browser/Version: Chrome Mobile Latest
Device/OS: iOS 16+, Android 13+
Screen_Resolution: Mobile-375x667
Dependencies: Responsive UI Framework
Performance_Baseline: < 4 seconds
Data_Requirements: Standard dashboard data

Prerequisites

Setup_Requirements: Mobile responsive design enabled
User_Roles_Permissions: Standard user access
Test_Data: Dashboard data available
Prior_Test_Cases: Desktop functionality verified

Test Procedure

Step #

Action

Expected Result

Test Data

Comments

1

Access dashboard on mobile

Responsive layout loads

N/A

Mobile access

2

Verify metric cards

Cards stack vertically

Dashboard metrics

Card layout

3

Test navigation menu

Hamburger menu functional

N/A

Mobile navigation

4

Scroll through content

Smooth scrolling behavior

N/A

Scroll testing

5

Test form inputs

Form fields properly sized

Create plan form

Form responsiveness

6

Verify table display

Tables horizontally scrollable

Tariff list table

Table responsiveness

7

Test touch interactions

Touch targets appropriately sized

Buttons and links

Touch targets

8

Check text readability

Text sizes appropriate

All text content

Text sizing

Verification Points

Primary_Verification: Mobile interface is fully functional and responsive
Secondary_Verifications: Touch interactions work properly, text is readable
Negative_Verification: No horizontal scrolling issues, no overlapping elements





Test Suite Definitions

1. Smoke Test Suite (30 Test Cases - 20% of Total)

Execution: Every build deployment
Duration: 30 minutes
Criteria: P1 priority, basic functionality validation

Included Test Cases:

  • ONB02US05_TC_001: Dashboard Overview Display
  • ONB02US05_TC_003: Plan Creation Wizard
  • ONB02US05_TC_005: Flat Rate Tariff Creation
  • ONB02US05_TC_007: Date Overlap Validation
  • ONB02US05_TC_014: Role-Based Access Control
  • ONB02US05_TC_016: Billing System Integration
  • Plus 24 additional core functionality tests

2. Regression Test Suite (90 Test Cases - 60% of Total)

Execution: Before each release
Duration: 4 hours
Criteria: P1-P2 priority, automated tests, integration points, business rules

Included Test Cases:

  • All Smoke Test cases
  • All business rule validation tests
  • All integration tests
  • All version control tests
  • All calculation verification tests
  • Cross-browser compatibility tests

3. Full Test Suite (150 Test Cases - 100% of Total)

Execution: Weekly or major release cycles
Duration: 8 hours
Criteria: Complete feature coverage, all browsers/devices

Included Test Cases:

  • All Regression Test cases
  • All edge case scenarios
  • All security tests
  • All performance tests
  • All mobile responsiveness tests
  • All bulk operation tests

Execution Matrix

Browser/Device Combinations

Test Type

Chrome Latest

Firefox Latest

Safari Latest

Edge Latest

Mobile Chrome

Mobile Safari

Smoke

Regression

-

-

Full Suite

Environment Matrix

Environment

Smoke

Regression

Full

Performance

Security

Development

-

-

-

-

Staging

Production

-

-

-

Performance Benchmarks

Response Time Requirements

  • Dashboard Load: < 3 seconds
  • Plan Creation: < 5 seconds
  • Tariff Calculation API: < 500ms
  • Data Export: < 10 seconds (up to 1000 records)
  • Search/Filter: < 2 seconds

Concurrent User Load

  • Normal Load: 1 request/minute per user
  • Peak Load: 10 concurrent users
  • Stress Test: 50 concurrent users
  • Break Point: Monitor system degradation

Memory Usage

  • Per Session: < 100MB
  • Server Memory: < 80% utilization
  • Database Connections: < 50 concurrent

Integration Dependency Map

External Systems

Billing System

  • NSC charges synchronization
  • Plan activation/deactivation
  • Customer billing data

Consumer Onboarding

  • Application processing fees
  • Service connection fees
  • Security deposit amounts

Authentication Service

  • Role-based access control
  • User session management
  • Permission validation

Internal Dependencies

Database Layer

  • Plan/tariff storage
  • Version history
  • Audit logging

Calculation Engine

  • Rate calculations
  • Multi-tier processing
  • Cross-season logic

Notification Service

  • Status change alerts
  • Expiration warnings
  • Error notifications

Coverage Report Summary

Acceptance Criteria Coverage: 100%

✅ Dashboard overview with metrics and growth indicators
✅ Active/inactive plan and tariff differentiation
✅ Recently updated items display with timestamps
✅ Support for Flat, Slab, Fixed, Seasonal, Time-based rates
✅ Water, Gas, Electricity utility support
✅ Overlap validation for same utility/rate type
✅ Guided step-by-step tariff creation
✅ Slab-based rate configuration with multiple tiers
✅ Sample billing calculations for different consumption levels
✅ Complete version history with user attribution
✅ Status display with visual indicators
✅ Upload/download functionality in standard formats
✅ Filtering and search capabilities
✅ Prevention of deletion for in-use tariffs
✅ Automatic status updates on expiration
✅ NSC charges integration (Processing, Connection, Deposit fees)
✅ Service charges with frequency and special types
✅ Role-based access control
✅ Audit and compliance features
✅ Responsive design support