1
Development is completed for all the features that are part of the release.
Yes
Shailesh, Arindam, Nirbhay
Sathish P, Elzan
2
Test cases are documented by the QA team, reviewed by the product owners and test results are updated in the test cases sheet.
Yes
Keerthi, Anuraj
Nirbhay, Shailesh, Arindam
3
The incremental demo of the features showcased during the sprint showcase and feedback incorporated.
Yes
Keerthi, Anuraj
Nirbhay
4
UI/UX Audit review by UX Architect is completed along with feedback incorporation for any changes in UI/UX.
Yes
Arindam
Andrew
5
Incremental demos to the product owners are completed as part of the sprint and feedbacks are incorporated.
Yes
Keerthi, Anuraj
Nirbhay
6
QA signoff is completed by the QA team and communicated to the product owners. All the tickets QA signoff status is updated in the JIRA.
Yes
Keerthi, Anuraj
Shailesh, Arindam
7
UAT promotion and regression testing from the QA team are complete. The QA team has shared the UAT regression test cases with the product owners.
Yes
Keerthi, Anuraj
Nirbhay
8
The API backward compatibility testing is completed.
Yes
Keerthi, Anuraj
Arindam, Shailesh
Tested with existing records and found no issues
9
The communication is shared with the product owners for the completion of UAT promotion and regression by the QA team. The product owners have to give a Product signoff within one week of this communication.
Yes
Anuraj, Keerthi
Nirbhay
QA Sign off given on below dates 12-Jul-2024 and 18-Jul-2024
10
UAT Product Signoff communication is received from the Product owners along with the release notes and User guides (if applicable).
Yes
Nirbhay
Sameer
11
The GIT tags and releases are created for the code changes for the release.
Yes
Shailesh
Sathish P
12
Verify whether the Release notes are updated
Yes
Nirbhay
Arindam
13
Verify whether all UAT Builds are updated along with the GIT tag details.
Yes
Shailesh
Sathish P
14
Verify whether all MDMS, Configs, InfraOps configs updated.
Yes
Tulika, Manas, Lokendra, Shubhang
Arindam, Shailesh
15
Yes
Nirbhay, Shailesh, Keerthi, Anuraj, Arindam, Anjoo
Anjoo
16
Verify whether all test cases are up to date and updated along with necessary permissions to view the test cases sheet. The test cases sheet is verified by the Product owner.
Yes
Keerthi, Anuraj
Nirbhay
17
Verify whether the UAT credentials sheet is updated with the details of new Users and Roles if any
Yes
Keerthi
Arindam
It will be internally shared
18
Verify whether all the localisation data was added in UAT including Hindi and updated in Release Kits.
Yes
Keerthi
Arindam
Hindi is not required. Odiya localization is added in UAT
19
Verify whether the product release notes and user guides are updated and published
Yes
Nirbhay
Sameer
20
The Demo of released features is done by the product team as part of the Sprint/Release Showcase.
Yes
Nirbhay
Release showcase was done on 22-July-2024
21
Technical and Product workshops/demos are conducted by the Engineering and Product team to the implementation team (Impel handover)
Yes
Shailesh
Arindam
As two team work together explicit handover not required
22
Plan for upgrading the staging/demo instance with the release product - within 2-4 weeks based on the period where no demos are planned from staging for the previous version of the released product.
Yes
Arindam, Shailesh
Nirbhay
23
Architect SignOff and Technical Quality Report
Yes
Shubhang, Manas
Shailesh
Issues are documented in Known Issues. Also documenting this in JIRA for tech debt fixes.
24
Success Metrics and Product Roadmap
Yes
Nirbhay
Sameer
25
Adoption Metrics
Yes
Nirbhay
Sameer
26
Program Roll-out Plan
Yes
Sameer
Sameer
27
Impel checklist
Yes
Arindam
Elzan
28
Impel roll-out plan
Yes
Arindam
Elzan
29
Gate 2
In progress
Sameer
Ex co
Gate 2 is scheduled on 26th July 2024
30
The Internal release communication along with all the release artefacts are shared by the Engineering team.
Nirbhay
This will be shared after Gate 2.
ifms-cronjob-pa
ifms-cronjob-pa:vNA-1c0cba31-4
Not Changed
ifms-cronjob-va
ifms-cronjob-va:vNA-1c0cba31-4
Not Changed
ifms-cronjob-pis
ifms-cronjob-pis:vNA-1c0cba31-4
Not Changed
ifms-cronjob-pag
ifms-cronjob-pag:vNA-1c0cba31-4
Not Changed
ifms-cronjob-pd
ifms-cronjob-pd:vNA-1c0cba31-4
Not Changed
ifms-cronjob-fd
ifms-cronjob-fd:vNA-1c0cba31-4
Not Changed
ifms-cronjob-ftps
ifms-cronjob-ftps:vNA-1c0cba31-3
Not Changed
ifms-cronjob-ftfps
ifms-cronjob-ftfps:vNA-1c0cba31-3
Not Changed
Rate Analysis
rate-analysis:UAT-04dc8d29-8
New Service
Works PDF
works-pdf:UAT-5ec7e42d-62
Changed
Muster Roll
muster-roll:UAT-21a2d6f9-8
Changed
Statements
statements:UCEM-579-e71ad6ce-12
New Service
Expense Calculator
expense-calculator-db:UAT-0a384623-23
Changed
Works-UI
works-ui:UAT-99bd312e-296
Rate Analysis & View Statements
Works-SHG
works-shg-app:UAT-ec3eea14-19
Mobile MB
Workbench-UI
workbench-ui:MUKTA-SOR-80d1bb835a-28
Rate Analysis and Customisation
Release kit repo for localisation
The MDMS and other configuration necessary for the Mukta V2.1 upgrade is added here.
Rate analysis persister configs
API
Persister config changes required for rate analysis
Rate analysis Dev-ops changes
API
add values.yaml in helm
Rate analysis Dev-ops helms
API
,
add in helm
Rate analysis mdms config
API
Roles and access add in Mdms. NOTE: In application properties of rate analysis need to change the Labour Cess code based on whatever is present in the environment
Estimate Template mdms config
API
Mdms config changes required for Estimate template.
Statement persister config
API
Persister config for statements.
Statement dev-ops config
API
, , ,
Dev-ops changes required for Statements.
Statement Mdms config
API
Mdms config for Statement.
Role action mapping for above all
API/UI
Role actions for SOR migration, rate analysis,statement.
ID format config
API/UI
Id format config to generate ID.
Statement PDF config
API
, , ,
PDF config required for statement pdf generation.
Statement PDF dev-ops config
API
Dev-ops config required for Statement PDF generation
Mukta v2.1 Test Cases consisting of different UI screens & API's the following are the test cases:
Mukta v2.1 UI & API Test Cases
UI Test Cases
Mobile Employee Login Page & Home Page
Mobile Employee Work Order
Mobile:Measurement Book
Moving Skills dataset into SOR
search & add template to detailed estimate
CBO-Download Analysis
UI & API Test Cases:
Estimate Generate, view and download analysis
MB Generate, view and download analysis statements
Add/Edit, View Rate Analysis
Search SOR
show rate revision jobs
Shedular-Revision of SOR
MUKTASoft v2.1
The MUKTASoft 2.1 release offers multiple new features and enhancements including rate analysis, estimate templates, Kibana dashboard and mobile application.
Rate Analysis - determines the cost of a Schedule of Rates (SOR), a unit of work, and is published by the Public Works Department (PWD).
Estimate Template - a set of SORs required to prepare an estimate for a specific type of work, allowing for easy reuse when preparing estimates for similar projects.
Analysis Statements - break down the estimated costs of all Schedule of Rates (SORs) into labour, material, and machinery - for better planning, budgeting, and resource allocation.
Utilization Statements – break down work costs from the measurement book for all Schedule of Rates (SORs) into labour, materials, and machinery, to validate wages, supervision, and purchase payments.
Mobile Application (Measurement Book) - mobile version of the measurement book, designed to help users capture measurements directly from the site and submit them for verification and approval.
Kibana Dashboard - developed with additional KPIs to help stakeholders track and monitor the progress of the MUKTA scheme.
The MUKTA CBO App has been enhanced with an employee login facility and renamed as the MUKTASoft App.
All the skills (MDMS v1) have been migrated into the Schedule of Rates registry (MDMS v2) as labor SORs.
None
Below are the known issues including Bug-bashes, ULB feedback and ULB-reports.
Data Security and Privacy (New Feature)
Work review and Project Closure (New Feature)
Bulk Purchase: Vendor Invoicing and Payments (Without a purchase order) (New Feature)
JIT Integration: Fund Allocation and Utilization Register (New Feature)
Allow addition of wage seekers after muster roll submission. (Enhancements)
Implement wage seekers search Criteria in the CBO App. (Enhancements)
Carry forward differential amounts of MB in muster roll. (Enhancements)
Reflect revised estimate costs accurately in view work orders details. (Enhancements)
Add CBO search option by various criteria during work order creation by PC MUKTA. (Enhancements)
Dashboard: Remaining KPIs, incorporating drill-down and filerts. (Enhancements)
Project types to be modified, moving from MDMS v1 to v2 (Change Request)
&
&
&
and
Verify whether all docs are published to website by the Technical Writer as part of the release.
&
Mukta Builds
Works Frontend
Localisation
MDMS
Configs
DevOps
Rate Analysis
Handles rate analysis features
Create Rate Analysis
This feature allows users to create rate analyses for given work SORs
View Rate Analysis
Users can search for specific SORs and view the rate analysis associated with it
Edit Rate Analysis
Users can edit the rate analysis
Revision of Rate
Manage functions related to revision of rates
Revise rate for selected
Users can revise the rates for selected SORs
Revise rate for all
Users can revise the rate for all the SORs without selecting any specific SOR
Show Job
Users can view the Job scheduled for rate analysis
Analysis Statements
Allows users to manage analysis statements
View Analysis Statements
Users can view analysis statements from the estimate view details
Download Analysis Statements
It allows the user to download the analysis statements from estimate view details.
Download Analysis Statement (CBO)
It allows the CBO to download the analysis statements from work order view details.
Utilization Statement
It covers the functionality of utilization statements.
View Analysis Statements
It allows the user to view the utilization statements from estimate view details.
Download Analysis Statements
It allows the user to download the utilization statements from estimate view details.
Employee Mobile Application
It covers the functionality of employee mobile application specifically MB.
Employee Login
It allows the user to login into mobile application.
Work Orders
It allows the user to search a work order to create measurement book.
View Details
It allows the user to view the work order details.
Create Measurement Book
It allows the user to create a MB.
Measurement Books
It serves the user as MB inbox.
View Measurement Book
It allows the user to view MB details.
Save as Draft Measurement Book
It allows the user to save MB as draft.
Submit Measurement Book
It allows the user to submit MB for verification.
Verify Measurement Book
It allows the user to verify MB and send for approval.
Approve Measurement Book
It allows the user to approve MB.
Estimate Template
It covers the functionality of estimate template.
Create Template
It allows the user to create template.
Search Template
It allows the user to search template.
View Template
It allows the user to view template.
Modify Template
It allows the user to modify template.
Estimate
Search and Add Template
It allows the user to search a template by code or name and add to estimate.
Overview
Urban Local Bodies
Number of Urban Local Bodies (ULBs) on-boarded
CBOs Registered
Number of Community-Based Organizations (CBOs) on-boarded
CBOs Benefited
Number of Community-Based Organizations (CBOs) that have received at least one work order
Wage Seekers Registered
Number of wage seekers on-boarded
Wage Seekers Benefited
Number of wage seekers who have been paid at least once through MUKTASoft
Onboarded Projects
Number of projects on-boarded
Estimates Submitted
Number of estimates prepared and submitted for verification
Estimates Technically Sanctioned
Number of estimates technically sanctioned
Estimates Administratively Approved
Number of estimates that have received administrative approval
Work orders issued
Number of work orders approved and sent to CBOs for acceptance
Work orders accepted
Number of work orders approved and accepted by CBOs
Upcoming Projects
Number of projects for which work orders accepted by CBOs are pending execution
Ongoing Projects
Number of projects currently in execution with at least one muster roll submitted
Value of work orders issued
Total value of approved work orders sent to CBOs for acceptance
Fund Utilized
Total amount paid for wage, purchase, and supervision bills clearance
Wage Amount
Total amount paid for wages
Purchase Amount
Total amount paid for purchases
Supervision Charges
Total amount paid for supervision charges
Performance
Work orders conversion rate
Percentage of onboarded projects with approved work orders (Projects work order approved/ Onboarded Projects*100)
Project execution rate
Percentage of approved work order value paid to beneficiaries (Total amount paid/ Value of work orders approved * 100)
Payment success rate
Percentage of successful payments out of the total payments processed (Number of successful payments/Total number of payments*100)
Average muster roll approval time (in days)
Average time in days taken to approve a muster roll (Total time taken to approve the muster rolls/Total muster rolls approved)
Average payment disbursal time (in days)
Average time taken to disburse payments to beneficiaries from bill approval (Total time taken for all disbursal / Total number of disbursal)
Urban Local Body
Urban Local Body
Onboarded Projects
Number of projects onboarded
Work orders issued
Number of work orders approved and sent to CBOs for acceptance
Value of work orders issued
Total value of approved work orders sent to CBOs for acceptance
Total amount paid
Total amount paid for wage, purchase, and supervision bills clearance
Work orders conversion rate
Percentage of onboarded projects with approved work orders (Projects work order approved/Onboarded Projects*100)
Project execution rate
Percentage of the approved work order value paid to beneficiaries (Total amount paid/Value of approved work orders * 100)
Average muster roll approval time (in days)
The average time in days taken to approve a muster roll (Total time taken to approve muster rolls/Total number of muster rolls approved)
Average payment disbursal time (in days)
The average time taken to disburse payments to beneficiaries from the approval of bills (Total time taken for all disbursal/Total number of disbursal)
Payment success rate
The percentage of payments successful of the total payments processed (Number of successful payments/Total number of payments*100)
Workflows
Estimates
Workflow status wise break shown in pie chart
Work Orders
Workflow status wise break shown in pie chart
Measurement Books
Workflow status wise break shown in pie chart
Muster Rolls
Workflow status wise break shown in pie chart
Bills
Workflow status wise break shown in pie chart
Payments
Payment status wise break shown in pie chart
Payments
Fund Utilized
Total amount paid towards wages, purchases, and supervision bills clearance
Wage Amount
Total amount paid towards wages
Purchase Amount
Total amount paid towards purchases
Supervision Charges
Total amount paid towards supervision charges
Monthly head wise payments
Monthly breakdown of the total paid amount, categorized by bill types: wage, purchase, and supervision
Weekly head wise payments
Weekly breakdown of the total paid amount, categorized by bill types: wage, purchase, and supervision
Monthly payment success rate
Monthly percentage of payments processed successfully out of the total attempted payments
Weekly payment success rate
Weekly percentage of payments processed successfully out of the total attempted payments
Monthly payment instruction wise payments
Monthly breakdown of total successful payment amount categorised by payment instruction type, i.e., original and revised payment instructions
Weekly payment instruction wise payments
Weekly breakdown of total successful payment amount categorised by payment instruction type, i.e., original and revised payment instructions
Monthly gender wise payments
Monthly breakdown of total successful payment amount processed categorised by the gender of beneficiaries
Weekly gender wise payments
Weekly breakdown of total successful payment amount processed categorised by the gender of beneficiaries
Monthly wage seekers registered vs benefited
Monthly comparison between registered and benefited wage seekers
Weekly wage seekers registered vs benefited
Weekly comparison between registered and benefited wage seekers
Monthly failure reason wise failed payments
Monthly total failed payments categorised by reasons for failure
Weekly failure reason wise failed payments
Weekly total failed payments categorised by reasons for failure
This migration is mukta-specific only.
To convert Labour Skills rates to SOR rates in MDMS-v2, we need to map skill_codes to sorId. We'll use skill_codes to get rates from MDMS v1 and sorId to upload them into MDMS v2. Upload an Excel file in the required format and execute the curl command. Note: The migration script is already present in our earlier build; only the input file will be changed.
To migrate skills rate follow the steps given below:
Create skill_codes and sorId mapping :
An Excel sheet is with fields (heads, rates as total, Sor Id, Valid From, and Valid To). Example:
0
0
0
0
0
0
0
345
0
345
SOR_000290
22-04-2023
30-09-2023
Use the Specific Build:
egovio/bulk-upload:UAT-f91e96b8-18
click here to access the branch and change details
Build and Deploy:
Deploy the build provided above or build and deploy from the code linked above if custom changes are required.
Upload the Excel file in the body.
Use the curl below to migrate the data.
Verification in DB: Query on the eg_mdms_data table and check if the Rates uploaded are present in the data. Example: select * from eg_mdms_data where schemacode ='WORKS-SOR.Rates' and data- >>'sorId' = 'Eg.SOR_000002';
Works SOR requires SOR Composition, for existing SORs it requires uploading data using script.
Clone DIGIT-Works repository in your local https://github.com/egovernments/Digit-works
Checkout to the branch sor-composition-migration
Create an excel file same as below sheet and fill the details https://github.com/egovernments/DIGIT-Works/blob/sor-composition-migration/utilities/sor-composition/Rate_analysis_for_composition.xlsx
Port-forward MDMS-v2
Update these details in .env
MDMS_V2_HOST url
MDMS_v2_SOR_COMPOSITION_CREATE url if it's changed - Make sure that WORKS-SOR.Composition schema is created
Install dependencies on your local
pip3 install -f requirements.txt
Run main.py file