The features mentioned below are included in the scope of MUKTASoft v2.1.

1. Employee Mobile Application

2. Aadhaar Integration

3. Estimate Template

4. Rate analysis

Scope

The time extension feature allows users to search for time extension requests and view their details.

Details

1. The same Search Work Order feature is used to search for revised work orders.

2. Clicking to view the details of a revised work order will open the "View Revised Work Order Page," showing the following information:

Notifications

Not applicable.

Actions

In Workflow Time Extension - Workflow actions based on roles logged in user has.

For Workflow Completed Time Extension - No Actions

User Interface

https://www.figma.com/file/M2P3O9WlKtxuLCjQKxLLDg/DIGIT-Works?type=design&node-id=8079-45030&t=2LWHgdG69SXIgukk-4

Acceptance Criteria

Revised work details are displayed as per the details provided in the story.

Context

A work order is created for an approved estimate to award the work to CBO. CBO starts the work to complete it within a given period.

In case the organization come to know that they are not in a position to complete the work within the given time frame due to various reasons, they need to inform the same to officer-in-charge of the project and apply for a time extension which is then subject to approval/ cancelling of work order based on the analysis done by the ULB.

Scope

Request for time extension can be directly raised by CBO using the mobile application and by the officer-in-charge of the project on behalf of CBO using a web application. Once a request is raised it goes for verification and approval.

1. The work order inbox is used to complete the revised work order workflow.

2. Workflow is the same as the workflow of the original work order with the same workflow levels (except/ decline are excluded) and actions.

Functional Details

Role (Actors) - Action Mapping

Workflow States

SLAs

Actions

Verify and Forward

The revised work order is forwarded to the approver.

Send Back

A revised work order is sent back to the previous user in the workflow.

Send Back To CBO

The revised work order is sent back to CBO for correction.

Edit/ Re-submit

The revised work order is edited and re-submitted. It goes to the verifier for verification.

Approve

1. The revised work order is approved.

2. The time extension comes into effect and the CBO user is allowed to track the attendance of wage seekers for an extended period.

Reject

The revised work order is rejected.

Notifications

User Interface

1. UI design is going to be the same as the work order workflow. Only the workflow states will be displayed as per the table given above.

2. The workflow pop-up windows for every action are going to be the same as for the work order workflow.

Acceptance Criteria

1. The same work order inbox is used.

2. The workflow pop-up windows are used as per the standard.

3. Actions are configured based on role-action mapping.

4. Workflow states are defined as provided and the state transition is done accordingly.

5. SMS notifications are sent.

Scope

Search project by ULB/ employee users.

Actors

Employee Role: Project Admin, Project_Viewer

Details

1. Search Project action has to be configurable and allow mapping with a role on demand.

2. Search Project is provided to allow the users to search Work and view its details/ create estimates.

Search Criteria

Search Result

1. The search result is shown as given below.

2. Pagination is displayed to handle the big result set. 10 records are displayed per page.

3. The option to download the result set in Excel/ PDF is provided.

Validations

All the actions are displayed based on role action mapping and the user role assignment.

Actions

1. Search - It will perform the search based on the values supplied for search parameters and the logic defined.

2. Clear Search - It will clear the values filled for searched parameters.

3. Project ID - It will take the user to the View Project Details Page.

Notifications

Not applicable.

User Interface

Acceptance Criteria

Context

A work order is created for an approved estimate in order to award the work to CBO. CBO starts the work to complete it within a given time period.

In case the organization comes to know that they are not in a position to complete the work within the given time frame due to various reasons, they need to inform the same to officer-in-charge of the project and apply for a time extension which is then subject to approval/ cancelling of work order based on the analysis done by the ULB.

Scope

Request for time extension can be directly raised by CBO using the mobile application and by the officer-in-charge of the project on behalf of CBO using a web application. Once a request is raised it goes for verification and approval.

Home > Work Orders > Inbox > Search Work Order > View Work Order > Request Time Extension (From Action Menu)

Functional Details

1. Work order to be revised to extend the completion period.

2. The request to revise the work order for the extension of time can be created by the CBO/officer-in-charge.

Validations

On Request Time Extension

1. In case the first muster roll is pending to submit for approval.

Time extension request can not be created. Please ensure that no muster roll is pending for submission.

2. In case the first muster roll itself is not created.

Time extension request can not be created. Please ensure that the first muster roll is submitted for approval.

3. In case a project closure request is already created.

Time extension request can not be created. A closure request has already been created for the selected project.

Notification

Not applicable.

Action

On submit, create and forward workflow pop-up window is displayed.

On Create and Forward,

1. The success page is displayed.

2. The time Extension request number is generated as per the specified format. TE/2022-23/000021.

3. The time extension request is forwarded to the verifier in the workflow.

User Interface

https://www.figma.com/file/M2P3O9WlKtxuLCjQKxLLDg/DIGIT-Works?type=design&node-id=6705-47564&t=8SVsHQhTGuDo3QW4-4

Acceptance Criteria

1. Modification of work order is allowed to extend the time.

2. A time extension request number is generated to identify the request.

3. The link between original and revised work orders is maintained.

Context

A time extension request is created and sent for approval. There should be an option to view all the requests that have been raised so far and the option to edit if a request is sent to CBO for correction.

Solution

Scope

Time Extension Request

Actors

CBO

Role: CBO ADMIN

Details

1. To view the requests, the My Requests feature is provided.

2. My Requests lists all the requests (Closure/ Time Extension) created for the works assigned to logged-in CBO users, and segregated by In Progress and Approved requests.

3. An approved request can not be edited.

4. In Progress closure, the request can be edited only when the request is sent back for correction.

5. The edit time extension request form allows users to change the extra days required for completion of the project and then submit again.

Validations

Field level validations.

Configurations

Not applicable.

Actions

Edit and Submit.

Notifications

Not applicable.

User Interface

The same as create time extension request.

Acceptance Criteria

After changing the extension period, on submit request is again placed to the verifier.

MUKTA Dashboard comes with around 21 KPIs visulization covering the action items, tracking the status of attendance, expendutire and payments.

Projects Delayed

1. Count of Projects where WO start date is in the selected date range and WO end date + X days is less than todays date. Let X be configurable.

2. For ex. Selected time period is Jan 1 to Jan 15. WO start date is Jan 7th, end date is Jan 31, X is 7. From 8Feb onwards if project closure is not done, this project is considered delayed.

3. On Hover show “ Contract created in the selected time period but not closed till date”

Pending Bills

1. Count of Bills that are created (Automatically or manually) in the selected date range and but current status(as of today) is not Paid/Payment done (Whichever is final state of Bill)

2. Considers all types of Bills

3. Show Amount as well of these bills as designed in mockup

4. On Hover show “ Bills created in the selected time period but payment is not done as of today”

Work Orders Not Issued

1. Number of Projects that are created in the selected time period and Work Orders are not yet created. (PS: Both are create dates only though text says issued.)

2. On Hover show text “ Projects created but Work Orders not created”

Muster Rolls Not Created

1. Count of weeks across all work orders that are in progress (Accepted by SHG) but Muster Roll is not created.

2. If Contract start date is Jan1st (Mon) and user hasn't created muster rolls until Jan 31, Number of Muster rolls not created are 4 for this project. If User Submits any 2 of them on Feb 1st, then remaining 2 should be shown.

3. On hover show “Work weeks completed but muster rolls not submitted to ULBs”

SLA Breached

Estimate Approval

1. Number of estimates that are created in the selected time period but have breached their SLA is respective workflow statuses.

2. Ex. Estimate created on Jan 15 (timeline selected is Jan 12-18), SLA is 5 days for one particular state. From Jan 21 on-wards till date this will be counted as SLA breach.

3. Parallel there could be other estimates in other workflow statuses too which have their respective SLA breaches.

4. All these will be accumulated to form SLA breach of Estimates.

5. If estimate is moved to next workflow state, this count will go down until the breach happens again.

6. All SLA breaches below KPIs follow same Logic.

Contract Approval

Includes only until contract issuance. Contract Acceptance by SHG breach is not counted as SLA breach for this metric.

Muster Roll Approval

Muster roll approval breaches SLA.

Bill Approval

Only for Purchase Bills in V1.

Status

Projects

1. Only three statuses will be shown for projects.

   1. Created - All projects that are created in selected time period

   2. In progress - Number of Projects that are created in the selected time period but Work Order(Contract) is not closed yet (Which means project is officially not closed)

   3. Closed - Projects that are created in the selected time period and Work Order is closed in the past already

2. No Hover Text

Estimates

1. Only three statuses will be shown for Estimates.

   1. Created - All estimates that are created in selected time period

   2. Yet to Approve - Number of Estimates that are created in the selected time period but estimate is not finally approved (Didn't reach final status)

   3. Approved - Number of Estimates that are created in the selected time period and approved in the past

2. No Hover Text

Work Orders

1. Five statuses will be shown for Contracts.

   1. Created - All Contracts that are created in selected time period

   2. Yet to Approve - Number of contracts that are created in the selected time period but contract is not finally approved (Didn't reach final status)

   3. Yet to Accept - Number of contracts that are created in the selected time period but not Accepted by CBO as of Date

   4. In Progress - Number of contracts that are created in the selected time period and Accepted by CBO in the past but not closed yet, irrespective of contract closure date.

   5. Closed - Number of contracts that are created in the selected time period and closed in the past

2. No Hover Text

Muster Rolls

1. Only three statuses will be shown for Muster Rolls.

   1. Submitted - All MRs that are created and Submitted (Combined action) in selected time period

   2. Yet to Approve - Number of MRs that are created in the selected time period but Approval is pending (Didn't reach final status)

   3. Approved - Number of Estimates that are created in the selected time period and approved in the past

2. No Hover Text

Context

This is an Umbrella story for MUKTA Dashboard. Gives high level description details along with standard components.

V1 Dashboard has 25 KPIs - 8 Simple numbers and 17 in Charts Design

Standard components on dashboard

Date Filter

District Filters

1. Should filter the dashboard data by selected District.

2. Multi select should be enabled.

ULB Filters

1. Should filter the dashboard data by selected District.

2. Multi select should be enabled.

3. Should be drilled down from District that is selected.

Denomination

1. Cr, Lac, Unit as per DIGIT standard

2. Share

3. Email, Whatsapp as per DIGIT standard

Download

1. JPEG as per DIGIT Standard

Roles

1. Define a single role called “MUKTA Dashboard Viewer” whoever has that access should have Dashboard link on left navigation menu and home page card links.

2. Use same dashboard Icon as per DIGIT standard.

3. Clicking on link will land user directly on dashboard Home with no filters applied.

User Acceptance

1. All filters, Denominations, Share and Download options to work as standard and expected.

2. All Cards will by default have menu individually(three dots). This will download image or share that card in that visualization to JPEG (Default DIGIT behavior)

The scheduled items for which the works department publishes the rates are known as schedule of rates. There are mainly 4 types of items for which schedules of rates are published.

1. Material - These are the material items which are required to accomplish a work.

2. Labour - The skilled and unskilled laborers which are required to accomplish the work.

3. Machinery - These are the equipment which are required to accomplish the work.

4. Works - The composition of material, labours, machinery together to form a building block for a work.

Expenditure

By Project Type

1. Projects that are created in the selected time period by project type

2. Show total project count within the PIE.

3. Switching to Amount should show same split by Amount instead of Count

4. Default Action on Hover

By Bill Type

1. Amount Billed (created) by Bill Type in the selected time frame. May not be approved or may be rejected also in that time-frame.

2. Show total Amount in the PIE

3. Switching to number should give number of bills the above KPI refers to while calculating amount.

Introduction

Estimate templates aid civil engineers in grouping commonly used Schedules of Rates (SORs) for specific project types or construction works, thereby reducing the time required for estimate preparation.

Functional Details

Create Template

An estimate template allows users to group necessary Schedule of Rates (SORs) for a well-defined piece of work, storing them in the system with a designated name and description. This facilitates their use in preparing estimates for similar projects.

Attributes

Mockups

Search Template

It enables the user to search a template using various parameters and see the result from where the complete detail of template can be seen clicking on the template code.

Search Criteria

Search Result

Mockups

View Template

It allows the user to view the details of the template and make corrections if need be using the action Modify Template.

Attribute

Mockups

Modify Template

It is to enable the users to correct the already created template.

Attributes

Mockups

Introduction

Mukhyamantri Karma Tatpara Abhiyan Yojana ( MUKTA Yojana) is a government scheme and This scheme is helpful for the poor urban people, which leads to the rising of the employment rate of the state. This document is prepared to detail out the specification MUKTASoft v2.0.

MUKTASoft aims to improve the overall scheme efficiency of MUKTA by identifying & providing equal job opportunities to the urban poor, construct environment-friendly projects, develop local communities and slums & plan better for upcoming years.

Purpose

The purpose of this document is to give a detailed description of the requirements for the MUKTASoft v2.0. It will illustrate the purpose and complete declaration for the development of the system. It will also explain system constraints, interface and interactions with other external applications. This document is primarily intended to define the scope of the version v2.0 and propose to the stakeholders for its approval and as a reference for developing the next version of the system for the development team.

Definitions, Acronyms & Abbreviations

Source of Information

1. MUKTA FRS

2. Field Visit to Dhenkanal and Jatni ULBs [21st & 22nd June 2023]

In Scope

1. Schedule of Rates

   1. Material

   2. Machinery

   3. Labour

   4. Works (Includes Material, Machinery, Labour)

2. Detailed Estimate

3. Detailed Measurement Book

4. Muster roll and purchase bill validations

Scope of v2.1, v2.2, v2.3, v2.4 and v2.5

1. Rate Analysis

2. Estimate Template

3. Analysis Statements

   1. Labour Analysis

   2. Material Analysis

   3. Machinery Analysis

4. Revise Estimate

5. Revise Work Order

6. Cancel Work Order

7. Utilization Statements

   1. Labour Utilization Statement (Quantity of Work Completed)

   2. Material Utilization Statement

   3. Machinery Utilization Statement

8. Project Closure

9. Dashboard Enhancements

Functional Details

Actors

Schedule of Rates

labourThe basic rate of material, labour, and machinery is decided by the state public works department which would be the same for a group of ULBs and then the final cost of SORs would vary from ULB to ULB based on the Conveyance and Royalty Charges applicable for the ULB.

Units of Measurement

1. CUM

2. QNTL

3. MT

4. NOs

5. KG

6. LTR

7. SQM

8. HOUR

9. EACH

10. MTR

11. KL

SOR Heads

1. Basic Rate (Material, Labour, Machinery)

2. Conveyance

3. Royalty

4. Labour Cess

SOR Type

There are a total of 4 types of SOR.

SOR Sub Type

sub-typesThe SOR of type works are grouped into various sub-types as given below.

SOR Variants

Schedule of Rates

The scheduled items for which the works department publishes the rates are known as the schedule of rates. There are mainly 4 types of items for which schedules of rates are published.

1. Material - These are the material items which are required to accomplish a work.

2. Labour - The skilled and unskilled labourers who are required to accomplish the work.

3. Machinery - These are the equipment which are required to accomplish the work.

4. Works - The composition of material, labour, and machinery together form a building block for a work.

Create

In MUKTA only a limited set of SORs are being used to estimate a work and initially, only the relevant SOR items are created. The option to create an SOR is provided to help the user take any missing or new SOR into the system as and when needed.

Attributes

Mockups

Search SOR

Search SOR provides the option to the user to search an SOR to see the details and modify it to bring the new rates into effect from a well-defined effective date.

Search Criteria

Search Result

The search result always displays the currently effective rates unless the search is for a different effective period.

Mockups

View SOR

It enables users to display the details of a SOR and then take the required action from there. E.g. Create Rate Analysis, View Rate Analysis, Modify SOR.

Attributes

Mockups

Modify SOR

Modifying SOR enables the user to make the necessary corrections in the details and add the new rate effective from a future date.

Attributes

Mockups

The screen to modify SOR is almost the same as creating SOR with the limitation mentioned in the above table.

Add/ Modify Rate

Add Rate enables the user to add the new rate effective from a future date.

Attributes

Mockups

The screen to modify SOR is almost the same as creating SOR with the limitation mentioned in the above table.

Detailed Estimate

After getting administrative approval on pre-estimation, a detailed estimate is prepared. In this, the estimate is divided into SOR, Non-SOR and Other Expenses and the quantities of various items are calculated individually by recording the detailed measurement of each activity. A detailed estimate is more accurate in terms of predicting the cost, material, labour, and machinery required to complete the work. It is also used for tendering and contracting the work.

Create Estimate

Create estimate enables users to create a detailed estimate using the measurements taken from ground. The options of searching a template, and adding SOR using SOR search is provided on the create estimate page.

Search SOR

1. SOR Type - Drop-down to select a value for SOR type.

2. SOR Sub Type - Drop-down to select a value for the SOR sub type.

3. SOR Variant - Drop-down to select a value.

4. SOR - Drop-down with incremental/ fuzzy search on code or description.

Plus Measurements

These are the measurements which are added to the measurement to calculate the quantity of a particular SOR.

Minus Measurements

These are the measurements which are subtracted from the measurement to calculate the quantity of a particular SOR.

Attributes

Mockups

Workflow

One additional step of adding and saving the estimate as a draft with the creator of the estimate is incorporated.

Measurement Book

The measurement book is the most important record. It is the basis of all accounts of quantities of work done, and purchase made and it must contain such a complete record of facts as to be conclusive evidence in the court of law.

It is the basis of all accounts of quantities whether of works done by Contractors or by labourers employed departmentally, or materials received. It is so written the transactions are readily traceable.

MB Recording

All the measurements for the work completed are measured and recorded in the measurement book against each and every BOQ provided in the estimate. Once the complete quantity of the item mentioned in the estimate is consumed in MB the item is considered completed.

MB Process Flow

Create MB

It enables users to capture the measurement of the completed works item (SOR/ Non-SOR) and create a record which becomes the basis of payment for the wage seekers, suppliers and supervisors (CBOs).

Attributes

Mockups

Workflow

The table below illustrates the steps of workflow followed to approve the revised work order.

Search MB

It enables users to search and MB recordings which are captured for a period and then sent for verification/ approval.

Search Criteria

Search Result

Mockups

View MB

It enables the users to view the details and workflow status of the measurement book.

Attributes

View measurement book displays all the details related to it as given below.

1. MB Reference Number

2. MB Number

3. Work Order Number

4. Project ID

5. Project Sanction Date

6. Project Location

7. Project Name

8. Project Description

9. Measurement History

   1. Sr. No

   2. MB Reference Number

   3. MB Date

   4. MB Period

   5. MB Amount

   6. Status

10. Measurement Period

    1. From Date

    2. To Date

11. SORs/ Non SORs

    1. SOR Category

    2. SOR Code

    3. SOR Description

    4. Unit

    5. Rate

    6. Quantity

    7. Amount

    8. Measurements

       1. Sr. No.

       2. Type

       3. Name

       4. Number (No)

       5. Length (L)

       6. Breadth (B)

       7. Height/ Depth (D)

       8. Quantity

       9. Total

12. Analysis

    1. Material Consumed (₹)

    2. Labour Utilized (₹)

    3. Machinery Utilized (₹)

13. Workflow Timelines

Mockups

The screen is similar to creating MB in the display mode of information including timelines.

Introduction

A mobile application for the employees will be developed to enable the users to take measurements on the ground and capture them in the system.

Functional Details

It will support the below-listed features.

1. Login

2. Home page

3. Search work orders

4. Measurement books

   • Inbox

   • Create and save as a draft

   • Submit for verification

   • Edit measurement book

   • Verify and approve measurement book

   • View measurement book

Login

The login screen enables the users to log into the mobile version of the MUKTASoft application.

Home Page

The home page enables the users to view the service menus and the menu icon to explore them.

Work Orders

The work orders screen lists the accepted and in-progress work orders to initiate the Measurement Book. Closed project work orders are excluded from the view list.

Measurement Books

The mobile version of the measurement book allows the user to record the measurement from the ground.

Inbox

Create

View

The view measurement books are the same screens in read-only mode.

Workflows

Workflow screens are available below.

Context

A closure request is created and send for approval, there should be an option to view all the request which are raised so far and a option to edit if a closure request is sent to creator for the same.

Solution

Scope

Closure Requests/ Time Extension Request

Actors

CBO

Role: CBO ADMIN

Details

1. To be view the closure requests Closure Requests feature is provided.

2. Closure Requests lists all the closure requests which are created for the works assigned to logged-in CBO user and are segregated by In Progress and Approved closure requests.

Attributes

Each closure request card will have below attributes displayed

1. Closure Request No.

2. Work Order No.

3. Work Description

4. Location - Locality + Ward

5. Work Start Date

6. Work End Date

7. Work Amount

8. Status [Submitted, Sent Back, Verified, Approved]

9. View Details/ Edit - Action button to see the muster roll details./ Edit action is enabled when service request is send back for correction.

On View Details, the details of closure request is displayed with the attributes as given below.

1. Project Details

2. Closure Request No.

3. Project ID

4. Project Sanction Date

5. Project Type

6. Project Name

7. Project Description

8. Location

On View Details, the details of time extension request is displayed with the attributes as given below.

1. Request ID

2. Work Order No.

3. Project ID

4. Work Description

5. Completion Days

6. Work Start Date

7. Work End Date

8. Extension required in days

9. Extended End Date

10. Extension Reason

11. Status

Validations

Not applicable

Configurations

Not applicable

Actions

1. View Details - To view the closure request details.

2. Edit - In case closure request is sent back for correction.

Notifications

Not applicable.

User Interface

Acceptance Criteria

1. My service request to list all the request raised for project assigned to him.

2. Details in the card view is displayed as provided.

3. Details for detailed view is displayed as provided.

4. CBO can edit the closure request when it is sent back to CBO.

Introduction

Rate analysis in Public Works Departments (PWD) involves the examination and calculation of rates for various construction activities or works. It is a systematic process carried out to determine the cost of executing a particular work item per unit quantity. Rate analysis typically involves breaking down the cost components associated with a construction activity, including materials, labor, machinery, contractor's profit, overhead costs, and miscellaneous expenses.

The purpose of rate analysis in PWD is to establish fair and accurate rates for different items of work, which helps in estimating the overall cost of a construction project. These rates are often based on prevailing market prices, standard specifications, and historical data. Rate analysis is crucial for budgeting, tendering, and ensuring transparency and accountability in construction projects undertaken by the Public Works Departments.

Scope

1. Schedule of rates

   1. Definition

   2. Rates

   3. Rate analysis

2. Usage of rate analysis

   1. Generation of analysis statements out of estimate

   2. Generation of utilization statements out of measurement book

   3. Revising the rates of works SORs

3. Download of documents

   1. Labour, Material, and Machinery analysis statements from estimate

   2. Labour, Material, and Machinery analysis statements from work order in CBO application

   3. Labour, Material, and Machinery utilization statements from measurement book

Functional Details

Actors

1. State Users

2. ULB Users

Feature - Role Mapping

Add Rate Analysis

It enables the user to add rate analysis for a Works SOR.

To add the rate analysis -

1. Search for the relevant SOR and open it to view the details.

2. Select the Add Rate Analysis option from Take Action - this will open the add rate analysis form with the following attributes:

Attributes

Screen Mock-ups

Search Rate Analysis

Search SOR is used to search a SOR and view the rate analysis associated with it.

Attributes

A SOR is searched to view the SOR details and rate analysis details. The revision of rates can also be scheduled. The search parameters are given below.

1. SOR Type

2. SOR Sub Type

3. SOR Variant

4. SOR Code