Introduction
Sub -scheme means a scheme which forms part of a split scheme and which is being treated as a separate pension scheme under and for the purposes set.Schemes and sub schemes defined schemes are defined under the schemes by the Centre or state government to be associate with a fund and for a time. Similar The Sub scheme shall be defined under a scheme.
Data Table
Sr. No. | Scheme Code* | Sub Scheme Name * | Sub Scheme Code * | Fund* | Valid From * | Valid To * | Department Code | Initial Estimate Amount | |||||
1 | Swachh Bharat Mission | Solid Waste Management- SWM | SBM02 | Grant Fund10 | Storm Water Drains | 1003 | 01/0205/20152018 | 3001/06/2018 | Water Supply & Sewerage | 10000002021 | PHS | 2500000 | |
2 | AMRUT | Storm Water Drains | 1003 | Grant Fund | 0320 | Solid Waste Management- SWM | SBM02 | 01/06/20162017 | 2001/0807/2019 | Water Supply & Sewerage | 25000002020 | TP | 1000000 |
3 | Finance Commission30 | Street Lights | 5001Grant Fund | 01/0503/20142016 | 30/604/20172019 | Street LightTP | 2000000 |
Note: Data given in the table is a sample data.
Procedure
Data Definition
Sr No | Column Name | Data Type | Data Size | Is Mandatory? | Definition/ Description | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Scheme Code | Alphanumeric | 50 | Yes | A unique code assigned to individual Scheme, this will facilitate the user to assign the sub scheme under the individual scheme and also helps in tracking the utilization of the Scheme. Click on Schemes to view the scheme master data. | ||||||
2 | Sub Scheme Name | Text | 50 | Yes | The Sub Scheme Name will facilitates the user to record the transaction against the individual sub scheme and also helps in tracking the utilization of the sub scheme. | ||||||
3 | Sub Scheme Code | Alphanumeric | 50 | 4 | Fund | 5Yes | A unique code assigned to individual Sub Scheme | ||||
4 | Valid From | 6 | Valid To | 7 | Department | 8 | Initial Estimate Amount | Date | N/A | Yes | The Date on which the Scheme Started, this will help to facilitate the receive of funds from Central Sponsored Schemes and State Sponsored Schemes. |
5 | Valid To | Date | N/A | Yes | The Date on which the Scheme will End, this will help to facilitate the end date by when the funds from Central Sponsored Schemes and State Sponsored Schemes need to be utilized. | ||||||
6 | Department Code | Text | 250 | No | The sub scheme can be linked to the individual department, so user while recording the transaction can assign the department. Click ULB's Departments for the master data. | ||||||
7 | Initial Estimate Amount | Numeric | 50 | No | The initial Estimate Amount approved amount under the sub scheme can be updated while creating the sub scheme master record. This will facilitate the user in utilizing the amount within the estimated amount. |
Steps to fill data
Download the workflow template attached to this page.
Have it open and go through all the headers and understand the meaning of them by referring 'Data Definition' section.
Make sure all the headers, its data type, field size and its definition/ description is understood properly. In case of any doubt, please reach out to the person who has shared this document with you to discuss the same and clear out the doubts.
Identify all sub schemes with the State..
Start filling the data starting from serial no. and complete a record at once. repeat this exercise till the entire data is filled into a template.
Verify the data once again by going through the checklist and taking care of each and every point mentioned in the checklist.
Checklist
The checklist is a set of activities to be performed once the data is filled into a template to ensure data type, size, and format of data is as per the expectation. These activities have been divided into 2 groups as given below.
Common Checklist
This checklist covers all the activities which are common across the entities.
Sr. No | Checklist Parameter | Example |
|---|---|---|
1 | Make sure that each and every point in this reference list has been taken care of. |
Entity Specific Checklist
This checklist covers the activities which are specific to the entity.
Sr. No. | Activity | Example |
1 | The date format should be as per example and the Start date should be greater than the current date and end date. | DD/MM/YYYY : [Allowed] YYYY/DD/MM : [Not allowed] |
2 | The name should be unique and should not contain any special characters | AMRUT : [Allowed] #AMRUT! : [Not allowed] |
3 | The scheme name mapped should be as per the scheme master entity | AMRUT, SWM |