Schedule of rates
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.
Material - These are the material items which are required to accomplish a work.
Labour - The skilled and unskilled laborers which are required to accomplish the work.
Machinery - These are the equipment which are required to accomplish the work.
Works - The composition of material, labours, machinery together to form a building block for a work.
Search Schedule of Rates
Home > Schedule of Rates > Search SOR
State: STATE_MUKTA_ADMIN
ULBs: MUKTA_ENG_ADMIN
Search SOR to be provided to list all the SORs.
There are various search parameters to search such a SOR.
#
Field Name
Data Type
Description
1
SOR Type
Drop-down
SOR types, the values from SOR Type Master.
2
SOR Sub Type
Drop-down
SOR sub types, the values from SOR Sub Type Master.
3
SOR Variant
Drop-down
SOR variant, the values from the SOR Variant Master.
4
SOR Code
Text
The system generated unique code of the SOR.
5
Status
Drop-down
Active/ Inactive.
6
Effective From
Date
The rate effective from date, can be a future date too.
7
Effective To
Date
The rate effective from date, can be a future date too.
At least one parameter is required to perform the search.
Consider From Date and To Date as a Date Range single parameter.
Exact search is performed for the values entered/selected.
In case multiple parameters values are supplied AND is applied for searching record.
By default active SORs are searched and currently effective rates are displayed.
#
Field Name
Description
1
SOR Code
It is system generated unique code to identify the SOR uniquely.
2
SOR Description
It is the description of SOR upto 64 characters only and end with a (…) with an option to display the complete text in tool-tip on mouse-click.
3
SOR Type
SOR types, the values from SOR Type Master.
4
SOR Sub Type
SOR sub types, the values from SOR Sub Type Master.
5
Status
The status of SOR, Active/ Inactive.
6
Rate
The current effective rate of the SOR.
Search - To perform the search based on the parameters entered.
Clear - To clear the values entered for search.
SOR Code - Hyperlink to view the SOR detail on mouse click. View SOR display the searched rate with SOR details on View Page.
Search result is displayed.
Option to download search result in excel is provided.
Pagination is provided to displayed 10 record at a time.
Not applicable.
Not applicable.
Not applicable.
Search is provided with the search parameters mentioned and the result is displayed as mentioned.
On click of SOR code, searched rate is displayed with SOR details on View SOR Page.
Pagination and option to download the searched result into Excel is provided.
View Schedule of Rates
Home > Search SOR > SOR Code (Hyperlink) > View SOR
State: STATE_MUKTA_ADMIN
ULBs: MUKTA_ENG_ADMIN
View SOR is provided to view the details of created active/inactive SOR.
Search a SOR using the search SOR and then open to view the details.
The details displayed as given below.
#
Field Name
Description
1
SOR Code
It is system generated unique code to identify the SOR uniquely.
2
SOR Type
SOR types, the values from SOR Type Master.
3
SOR Sub Type
SOR sub types, the values from SOR Sub Type Master.
4
SOR Variant
SOR variant, the values from the SOR Variant Master.
5
Unit of Measurement
The unit of measurement.
6
Rate Defined for Quantity
The quantity of SOR for which rate is provided.
7
SOR Description
It is the description of SOR to describe the SOR.
8
Status
The status of SOR Active/ Inactive. Active means active for usage.
Rate Details
SOR rate, based on the search performed.
9
Effective From
The date from which the rate is effective.
Heads
A grid to select the head which ever applicable is provided.
10
Basic Rate
Basic rate of the SOR, provided by the state PWD.
11
Conveyance
Conveyance cost defined for the unit of quantity given in SOR.
12
Royalty
Royalty defined for the unit of quantity given in SOR.
13
Labour Cess
The amount of labour cess, it is applicable to SOR of type Works only.
14
Rate
The final rate of SOR.
Rate History
History of rates which were effective in the past.
1
Serial No.
Serial number of the record.
2
Effective From
The rate effective from date.
3
Rate/ Unit
The net effective rate.
4
View Details
Button to view the break-up of rate.
5
Actions
Modify SOR - Applicable to all type of SOR. (State Users Only)
Add/ Modify Rate - Applicable to other than Works (State/ ULB Users)
Add/ Modify Rate Analysis - Applicable to Works type of SOR. (State Users Only)
View Rate Analysis - Applicable to Works type of SOR. (State/ ULB Users)
Modify SOR - It is applicable to all type of SOR and enable the user to change of SOR description and status.
Add/ Modify Rate - It is applicable to all type of SOR other than Works and enable the user to add new rate or modify existing rate.
Add/ Modify Analysis - It is applicable to Works type of SOR only and enable the user to add rate analysis or modify existing rate analysis.
View Rate Analysis - It is applicable to Works type of SOR only and enable the user to view the currently linked rate analysis.
Not applicable.
Not applicable.
Not applicable.
SOR details is displayed as per the attribute provided in the story.
Rate is displayed as per the search result.
View history displayed the history of rates.
Add/ Modify SOR Rate
Home > Search SOR > SOR Code (Hyperlink) > View SOR > Add/Modify Rate (action)
ULB: MUKTA_ENG_ADMIN
Add Rate is provided to enable the users add new rate or modify an existing rate.
Add/ Modify rate is allowed to only non works SORs only.
On add new rate, modify page is opened with the existing details and rates.
The attributes which are allowed to modify are as given below table.
In case new rate is added.
A new rate is created with new effective date.
The previous rate is closed with the previous day date.
View SOR Page is displayed with newly added rate.
A success toast message is displayed for new rate creation.
Success Message - New Rate Added
Rate has been added successfully effective from <effective date>.
Success Message - Existing Rate Modified
The rate effective from <effective date> has been modified successfully.
Alert! On Modify
Do you want to update existing rate effective from <effective date>? Please confirm to complete the action.
On Modify (In no change in rate details)
Modification to existing SOR rate is failed as there were no changes done.
Adding new rate to the SOR is failed.
Modification to existing SOR rate is failed.
Effective date should not be a date before current rate effective date.
Effective from time is always start of the day i.e. 00:00. The time in between in the day is not allowed.
Effective to date, the time is always 11:59:59.
Not applicable.
Not applicable.
Modification of existing rate is allowed.
Adding new rate with a new effective date is allowed.
On modification, alert message is displayed.
On successful add/modify rate, success toast message is displayed.
#
Field Name
Data Type
Is Mandatory?
Description
1
SOR Code
Display
Yes
The SOR code.
2
SOR Type
Display
Yes
Material, Labour, Machinery, Works.
3
SOR Sub Type
Display
Yes
Applicable for SOR type Works only.
4
SOR Variant
Display
Yes
Applicable for SOR type Works only.
5
Unit of Measurement
Display
Yes
Unit of measurement for the item.
6
Rate Defined for Quantity
Display
Yes
Quantity of items for which basic rate is defined.
7
Description
Display
Yes
Name of item as per the standard definition of OPWD
8
Status
Display
Yes
The status of SOR, Active/ Inactive.
Rate Details
9
Effective From
Date
Yes
The date from which rate is become effective.
Heads
Grid
Yes
Rate of other than works SORs can only be added.
10
Basic Rate
Numeric
Yes
The basic rate of the item defined by the OPWD.
11
Conveyance
Numeric
No
The conveyance charges applicable.
12
Royalty
Numeric
No
The royalty amount on the items.
13
Rate
Display
Yes
A calculated value.
14
Submit
Button
Yes
It saves the changes into system.
Modify Schedule of Rate
Home > Search SOR > SOR Code (Hyperlink) > View SOR > Modify SOR (action)
State: STATE_MUKTA_ADMIN
Modify SOR is provided to enable the users to make the correction in the existing SOR.
The attributes which are allowed to modify are as given below table.
#
Field Name
Data Type
Is Mandatory?
Description
1
SOR Code
Display
Yes
The SOR code.
2
SOR Type
Display
Yes
Material, Labour, Machinery, Works.
3
SOR Sub Type
Display
Yes
Applicable for SOR type Works only.
4
SOR Variant
Display
Yes
Applicable for SOR type Works only.
5
Is it a basic variant?
Display
Yes
Applicable for SOR type Works only.
6
Unit of Measurement
Display
Yes
Unit of measurement for the item.
7
Rate Defined for Quantity
Display
Yes
Quantity of items for which basic rate is defined.
8
SOR Description
Alphanumeric
Yes
Name of item as per the standard definition of OPWD
9
Status
Drop-down
Yes
The status of SOR, Active/ Inactive.
Submit - On Submit.
SOR detailed gets updated successfully.
View SOR Page is displayed with updated details.
Success toast message is displayed.
In case SOR is getting inactivated.
The status of SOR is get updated inactive in case no other active SOR is referencing it.
Otherwise a validation message is displayed and system doesn’t update the status to inactive.
SOR details has been updated successfully.
Validation message a reference SOR is getting inactivated.
This SOR can not be inactivated as there are active SORs exists referencing it.
Not applicable.
Not applicable.
On successful update, View SOR Page is displayed.
Toast success message is displayed.
System doesn’t allow to change the status to inactive in reference SORs exists.
Create SOR
Home > Schedule of Rate > Search SOR Page > Action (Create SOR)
State: STATE_MUKTA_ADMIN
Create SOR feature is provided to enable the users create a SOR with its rate.
There are 4 types of SOR defined. Material, Labour, Machinery, and Works.
The rates of first 3 type of SORs are directly added by user on creation of SOR.
The rate for the SOR of type Works is calculated using rate analysis and added to SOR.
The attributes defining SOR are given in below table.
Submit - On Submit
Save the details into system and SOR is created with the status active.
Generate a unique code as per given format.
Success page is displayed with the success message and below actions.
a) Create SOR
b) Add Rate Analysis
c) Go To Search SOR
c) Go To Home Page
On Submit and Create Another SOR
Save the details into system and SOR is created with the status active.
Toast success message is displayed.
Create SOR Page is opened to create another SOR.
Success Message
SOR has been created successfully. SOR Code: <>
Duplicate record of same type, sub type, and variant is not allowed.
Effective from time is always start of the day i.e. 00:00.
Effective from date while creating SOR can be any date.
Duplicate Message
This SOR already exists. SOR Code:<code>.
These are the masters which are configured into MDMS to enable SOR creation.
SOR Type
SOR Sub Type
SOR Variant
Unit of Measurement
Heads/ Charges
(Separate tickets are created for each of them to configure into MDMS)
SOR Code format.
Not applicable
SOR can be created without having rate associated with it.
It covers all 4 types of SORs. Works SOR are created without rate.
Effective from time is always 00:00:00.
SOR code is generated as per the format provided.
Sr. No.
Field Name
Data Type
Is Mandatory?
Description
1
SOR Type
Drop-down
Yes
Material, Labour, Machinery, Works.
2
SOR Sub Type
Drop-down
Yes*
Applicable for SOR type Works only.
3
SOR Variant
Drop-down
Yes*
Applicable for SOR type Works only.
4
Unit of Measurement
Drop-down
Yes
Unit of measurement for the item.
5
Rate defined for quantity
Numeric (6,0)
Yes
Quantity of items for which basic rate is defined.
6
Description
Alphanumeric (2048 Chars)
Yes
Name of item as per the standard definition of OPWD
Rate Details
Section
Optional
It is not applicable to Works SOR.
7
Effective From
Date
Yes
The date given rate will become effective, it can be a past and future date. Time is always 00.00
Heads
Grid
Optional
A grid to select the head whichever is applicable.
8
Basic Rate
Numeric (6,2)
Yes
The basic rate of the item defined by the OPWD
9
Conveyance
Numeric (6,2)
No
The conveyance charges applicable based on the distance item is carried.
10
Royalty
Numeric (6,2)
No
The royalty amount on the items as per the state mining department.
11
Labour Cess
Numeric (6,2)
No
It is applicable for works items only and calculated on Basic + Conveyance + Royalty.
12
Rate/ Unit
Display
Yes
A calculated value.
13
Submit and Create Another SOR
Button
Yes
It will allow the user to submit the details and open a new create SOR form.
14
Submit
Button
Yes
It saves the SOR details into system and create SOR record.
Sr. No.
SOR Type
Format
1
Material
LD-<5 digit running sequence>. E.g. LD-00001
2
Labour
LD-<5 digit running sequence>. E.g. LD-00001
3
Machinery
LD-<5 digit running sequence>. E.g. LD-00001
4
Works
<SUBTYPECODE>-<5 digit running sequence>. E.g. EW-00001