All pages
Powered by GitBook
1 of 5

Loading...

Loading...

Loading...

Loading...

Loading...

ULB Level Setup

ULB level setup involves the configuration of ULB specific data parameters such as ULB boundaries, ULB bank accounts, and hierarchy details.

  • Boundary Hierarchies

  • Boundary Data

  • Cross Hierarchy Mapping

All content on this page by is licensed under a .

ULB Bank Accounts
​
eGov Foundation
Creative Commons Attribution 4.0 International License

Boundary Hierarchies

Introduction

A ULB is divided into certain categories of boundaries by ULB administrative authorities in order to carry out ULB’s functions better. A ULB/City could be divided by a different set of delimitation of boundaries based on functions as given below.

  1. Revenue - Delimitation of ULB into boundaries to perform the target setting and collection of revenue.

  2. Administration - Delimitation of ULB into boundaries for the better administration of ULB.

  3. Locality/ Location - Delimitation of ULB into boundaries based on the places known to citizen with names and easily identifiable by the common person.

All these authorities have designated certain levels of boundary classification for a certain ULB.

Data Table

The below mention table is used to collect data for the types of hierarchy being followed:

Sr. No.
Code*
Boundary Hierarchy Type*
Description

The above-mentioned data for the boundary hierarchy is sample data.

Procedure

Data Definition

Sr. No.
Column Name
Data Type
Data Size
Is Mandatory?
Definition/ Description

Steps to fill data

  1. Download the data template attached to this page.

  2. Get a good understanding of all the headers in the template sheet, their data type, size, and definitions by referring to the ‘Data Definition’ section of this document.

  3. In case of any doubt, please reach out to the person who has shared this template with you to discuss and clear your doubts.

  4. Identify all the types of boundaries which are being used in the state in order to carry out various administrative/revenue functions.

Checklist

The checklist is a set of activities to be performed one 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

Entity Specific Checklist

This checklist covers the activities which are specific to the entity.

Sr. No.
Checklist Parameter
Example

Attachments

All content on this page by is licensed under a .

Locality

Location-based classification could be done in order to identify a certain place. For example, Locality of a house of a citizen could follow the below hierarchy:

  1. House no.

  2. Mohalla

  3. Area

Alphanumeric

256

Yes

The meaningful name to define one group of boundaries defined to perform one function

3

Description

Alphanumeric

256

Yes

A brief description of the boundary hierarchy

  • Start filling the data starting from serial no. and complete a record at once. repeat this exercise until the entire data is filled into a template.

  • Then fill up the hierarchy types and the codes in the respective columns in the template.

  • Code should be created for the type of boundary being classified.

  • A brief description of the boundary hierarchy type would be helpful.

  • Verify the data once again by going through the checklist and taking care of each and every point mentioned in the checklist.

  • 1

    ADM

    Administration

    Administration level boundary classified on the basis of administrative functions such as scrutinize certain rules and regulations

    2

    REV

    Revenue

    Revenue-based classification of a ULB is done on the basis of revenue collection

    3

    1

    Code

    Alphabet

    64

    Yes

    Code is used to identify a certain classification of the type of boundary hierarchy

    2

    1

    Make sure that each and every point in this reference list has been taken care of

    Checklist

    1

    Make sure that the hierarchies types should be uniform across all the ULB’s /cities in the state

    -

    2

    Only 3 types of boundary hierarchies are allowed

    -

    10KB
    configurable-data-template-boundary-hierachies-v1.xlsx
    Open
    Configuration Data Template
    10KB
    confugurable-sample-data-boundary-hierarchy-v1.xlsx
    Open
    Sample Data Template
    ​
    eGov Foundation
    Creative Commons Attribution 4.0 International License

    LOC

    Boundary Hierarchy Type

    Ward
  • City

  • ULB Bank Accounts

    Introduction

    It is a ULB bank account which is operative at least to receive or deposit the day to day revenue collection done by the ULB. It is used by online payment integrator to disburse the amount in ULBs accounts which have been collected through a payment gateway into a pool account managed by the payment gateway.

    Data Table

    Below given data table represents the excel template attached. Data given in the table is a sample data.

    Sr. No.
    Code*
    ULB Name*
    Bank Name*
    Branch Name*
    Account Number*
    Account Type*
    IFSC*

    Data given in the table is sample data.

    Procedure

    Data Definition

    Sr. No.
    Column Name
    Data Type
    Data Size
    Is Mandatory
    Definition/ Description

    Steps to fill data

    1. Download the data template attached to this page.

    2. Have it open and go through all the headers and understand the meaning of them by referring 'Data Definition' section.

    3. 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.

    Checklist

    The checklist is a set of activities to be performed after 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.

    To see the common checklist refer to the page consisting of all the activities which are to be followed to ensure complete and quality data.

    Entity Specific Checklist

    This checklist covers the activities which are specific to the entity.

    Attachments

    All content on this page by is licensed under a .

    Cross Hierarchy Mapping

    Introduction

    This is the 3rd step that comes after the boundary data collection. Cross hierarchy mapping happens in case a child has a relationship with more than 2 parents. This double relationship between the child and parents could happen between different hierarchies as well.

    For example: In Admin level boundary hierarchy a mohalla M1(child) could be a part of 2 Wards(parent) W1 and W2. In such a case a single Mohalla(child) has to be mapped to 2 Wards(parent).

    Saving

    SBIX0921

    2

    haridwar

    Haridwar Municipal Corporation

    PNB

    Chauk

    XXXX9820XX9

    Saving

    PNBX8320

    Text

    256

    Yes

    Name of Urban Local Body

    3

    Bank Name

    Text

    256

    Yes

    Name of the bank where the account exists

    4

    Branch Name

    Text

    256

    Yes

    Name of the bank branch where the account exists

    5

    Account Number

    Alphanumeric

    64

    Yes

    Bank account number to be used to transfer the amount

    6

    Account Type

    Text

    256

    Yes

    Account type. e.g. Saving, Current etc.

    7

    IFSC

    Alphanumeric

    64

    Yes

    IFS code of branch as per FBI guidelines

    Identify the bank account which is to be used to transfer the amount which is collected online for various services.
  • Start filling the data starting from serial no. and complete a record at once. repeat this exercise until 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 checklist point/ activity mentioned in the checklist.

  • 1

    dehradun

    Dehradun Municipal Corporation

    SBI

    Rajpur

    1

    Code

    Alphanumeric

    64

    Yes

    Unique code is given to the bank detail record e.g. dehradun

    2

    Sr. No.

    Activity

    Example

    1

    Code should not consist of any special characters

    E.g. dehradun is allowed but dehradun@1 is not allowed

    2

    The account number should not consist of any special characters.

    As issued by the bank

    Checklist
    ​
    eGov Foundation
    Creative Commons Attribution 4.0 International License

    XXXX0082XX01

    ULB Name

    Data Table

    Below is the data table for the Boundary:

    Hierarchy Type
    Hierarchy Type 1*
    Hierarchy Type 2*

    Sr.No

    Boundary Type*

    Boundary Code*

    Boundary Type*

    Boundary Code*

    1

    Ward

    W1

    Procedure

    Data Definition

    Sr. No.
    Column Name
    Data Type
    Data Size
    Is Mandatory?
    Definition/ Description

    1

    Hierarchy Type 1

    Text

    256

    Yes

    The type of hierarchy 1 the boundary belongs to which is to be mapped with other boundaries in hierarchy 2. Refer

    2

    Steps to fill data

    1. Download the data template attached to this page.

    2. Get a good understanding of all the headers in the template sheet, their data type, size, and definitions by referring to the ‘Data Definition’ section of this document.

    3. In case of any doubt, please reach out to the person who has shared this template with you to discuss and clear your doubts.

    4. Firstly Identify all the child levels which have a relation with more than 2 parent boundary types and their hierarchy types as well.

    5. Fill up the boundary hierarchy (names/ codes) types in place of boundary type 1/2.

    6. Then along with the codes start filling in one by one with the proper mapping between every child and parent.

    7. The Sr. No should be in an incremental order for every new child level.

    8. Prepare a new table for every different parent-child relation.

    9. 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 one 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. There is no entity-specific checklist activity applicable here.

    Attachments

    ​All content on this page by eGov Foundation is licensed under a Creative Commons Attribution 4.0 International License.

    Boundary Data

    Introduction

    This is the next step after collating all the boundary hierarchies which are being used in the state. In a hierarchy, there are certain types of boundary classification and in all the levels there will be a mapping which we could define as a parent-child mapping in order to link certain levels of the classification.

    For example, a hierarchy could be:

    Administration Hierarchy: City/ULB → Zone → Ward → Locality

    In the above-mentioned hierarchy, a City/ULB is being divided into different into zones followed by zones into wards and at the end wards into the locality.

    Data Table

    Data has to be collected for every boundary hierarchy type and boundary type with a mapping between the boundary code and its parent boundary code. Following is the table which is to be used across all the hierarchy types.

    Sr. No.
    Boundary Code*
    Boundary Name* (In English)
    Boundary Name* ( In Local Language)
    Parent Boundary Code*
    Boundary Type*
    Hierarchy Type Code*

    Data given in the table is a sample data.

    Procedure

    Data Definition

    Following is the definition of the data columns which are being used in the template:

    Sr. No.
    Column Name
    Data Type
    Data Size
    Is Mandatory?
    Description

    Steps to fill data

    Following are the steps which should be used to fill the template:

    1. Download the data template attached to this page.

    2. Get a good understanding of all the headers in the template sheet, their data type, size, and definitions by referring to the ‘Data Definition’ section of this document.

    3. In case of any doubt, please reach out to the person who has shared this template with you to discuss and clear your doubts.

    4. After Identifying all the boundary hierarchy, get the sub-classification of all the hierarchies.

    Checklist

    The checklist is a set of activities to be performed one 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.
    Activity
    Example

    Entity Specific Checklist

    This checklist covers the activities which are specific to the entity.

    Sr. No.
    Activity
    Example

    Attachments

    All content on this page by is licensed under a .

    Creative Commons License

    2

    W2

    Ward no.2

    वार्ड नंबर 2

    Z1

    Ward

    ADM

    3

    W3

    Ward no.3

    वार्ड नंबर 3

    Z2

    Ward

    ADM

    4

    W4

    Ward no.4

    वार्ड नंबर 4

    Z3

    Ward

    ADM

    Text

    256

    Yes

    The name of the boundary that is being defined in the English language

    3

    Boundary Name (In Local Language)

    Text

    256

    Yes

    The name of the boundary that is being defined in the local language of the state e.g. Telugu, Hindi etc.

    4

    Parent Boundary Code

    Alphanumeric

    64

    Yes

    This is the boundary code of the parent which identifies to which parent the child belongs to

    5

    Boundary Type

    Text

    256

    Yes

    The name of the boundary type i.e. Ward, Zone etc.

    6

    Hierarchy Type Code

    Alphanumeric

    64

    Yes

    The code of the for which this particular boundary is defined

  • Figure out the codes for all the sub-classification for a particular city/ULB.

  • Start filling the template from the top of the hierarchy in a drill-down approach.

  • A parent-child mapping code has to be created for every boundary level except for the top level.

  • Follow the steps until you reach the last sub-classification.

  • Verify the data once again by going through the checklist and taking care of each and every point mentioned in the checklist.

  • 1

    W1

    Ward no.1

    वार्ड नंबर 1

    Z1

    Ward

    1

    Boundary Code

    Alphanumeric

    64

    Yes

    This is a code for the sub-classification for a particular boundary. Should be unique across all boundaries defined

    2

    1

    Make sure that each and every point in this reference list has been taken care of

    Checklist

    1

    Every boundary type of data should be filled separately

    -

    24KB
    configuration-sample-data-boundary-data.xlsx
    Open
    Sample Data Template
    ​
    eGov Foundation
    Creative Commons Attribution 4.0 International License

    ADM

    Boundary Name (In English)

    Mohalla

    M1

    Ward

    W2

    Mohalla

    M1

    2

    Ward

    W3

    Mohalla

    M2

    Ward

    W4

    Mohalla

    M2

    Hierarchy Type 2

    Text

    256

    Yes

    The type of hierarchy 2 the boundary belongs to which is to be mapped with other boundaries in hierarchy 1. Refer Boundary Hierarchies

    3

    Boundary Type

    Text

    64

    Yes

    This is the type of boundary from hierarchy 1. Refer Boundary Data

    4

    Boundary Code

    Alphanumeric

    64

    Yes

    This is the code of the boundary for the boundary from hierarchy 1. Refer Boundary Data

    5

    Boundary Type

    Text

    64

    Yes

    This is the type of boundary from hierarchy 2. Refer Boundary Data

    6

    Boundary Code

    Alphanumeric

    64

    Yes

    This is the code of the boundary for the boundary from hierarchy 2. Refer Boundary Data

    Boundary Hierarchies
    Checklist
    Boundary Hierarchies
    Creative Commons License
    Creative Commons License
    Creative Commons License
    Creative Commons License