Grievance Type

Browse details on configuring master data template

Introduction

A grievance is a formal complaint submitted to a ULB. Something wrong or something believed to cause distress in services provided by the ULB is considered grounds for complaint. Grievances that are closely associated with ULB’s functions are classified into different buckets, which different sections of ULB deal with are known as grievance types.

Data Table

Sr. No.	Grievance Type Code*	Grievance Type* (In English)	Grievance Type* (In Local Language)
1	SLS	Street Lights	स्ट्रीट लाइट
2	GBG	Garbage	कचरा
3	DRN	Drains	नाली

The data given in the table is sample data.

Procedure

Data Definition

Sr. No.	Column Name	Data Type	Data Size	Is Mandatory?	Definition/ Description
1	Grievance Type Code*	Alphanumeric	64	Yes	Unique code is given to the grievance type. This code is used to uniquely identify the complaint type and as a reference in the child record. E.g. SLS given above in data table to identify Street Lights complaint type
2	Grievance Type* (In English)	Text	256	Yes	This is the text or string stating grievance type in English
3	Grievance Type* (In Local Language)	Text	256	Yes	This the text or string stating the grievance type in local language like Hindi, Telugu etc. whatever is applicable

Steps to fill in 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, their data type, field size and their definition/ description are 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.

4. Identify all different types of grievances based on ULB’s functions.

5. Start filling in the data starting from the serial number, and complete a record at once. Repeat this exercise until the entire dataset is filled into a template.

6. 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 the data are 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.

Refer Checklist to view the list of all the activities which are to be followed to ensure completeness and quality of data.

Entity Specific Checklist

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

Sr. No.	Activity	Example
1	Grievance type code should not have any special characters other than ‘-', and '_’	SLS - [Allowed] SLS1 - [Allowed] SL#1 - [Not Allowed]
2	Grievance type should be text and should not contain special characters other than ‘-', '_', SPACE	Street Light - [Allowed] Street_Light# -[Not allowed]

Attachments

10KB

Configuration data template - Grievance Type_V1.xlsx

Open