Introduction

Checklist is the set of activities which are there to perform on completion of a task to ensure the fullness and quality of the task.

Data Types

Data type is an attribute of data, is a particular kind of data item, as defined by the values it can take, the computer system used, or the operations that can be performed on it. In order to help filling the right kind of data for a data field/ column in excel, below given table have the different data types with its description.

Sr. No.	Data Type	Definition/ Description
1	Alphanumeric	It contains the alphabets and numbers. And generally used to define the code.
2	Decimal	Floating point number with a fraction value up to 2 decimal places.
3	Integer	Whole number without having a fraction part in it.
4	Text	A string of alphabets, numbers, spaces, and symbols.
5	Date	It represents a date and is captured in the format of ‘DD/MM/YYYY’.
6	Reference	It is a code of a record from the referred entity and having a related record in the prevailing entity.
7	Document	It represents a document which is needed as an attachment with other relevant details in the template.

Checklist

Sr. No.	Activity	Example

Sr. No.	Activity	Example
State Level: These activities are applicable to state level entities only.
1	Entity is to be decided to be defined at state level and all the ULBs are agreed on the same.	NA
2	Data filled into templates should cater to the needs of each and every ULBs.	NA
General: These activities are applicable to all the entities.
3	Order of headers should remain unchanged in the template while filling the data.	NA
4	Value filled into the template doesn’t exceed the given data size limit.	NA
5	Codes filled in the template for all the records are unique. It means no 2 records in the template share the same code.	Below records in code, value pair are not acceptable. RES - Residential RES - Non-residential
6	All the columns marked with asterisk must be filled with the values and not even a single record left without a value.	NA
7	Reference value in the template must also exist in the referred entity template. A value without being present in the referred entity template is invalid.	NA
8	None of the values filled in the template should have a character which is not allowed.	NA
9	Mobile Numbers filled into the template must be 10 digit valid mobile numbers without country code.	NA
10	Email id filled into template should be a valid email ID.	NA
11	Local language values should be Unicode char-set only.	NA
Data Type Based: These activities are applicable to all entities.
12	Values of data type alphanumeric consist of alphabet and numeric values only. All the entity code should follow this.	Allowed - ABC01 Not allowed - ABC#01
13	Values of data type decimal must be a number having fraction part up to 2 places of decimal.	Allowed - 23.87 Not allowed - 12.0982
14	Values of data type integer must be a number which is not a fraction but a whole number.	Allowed - 15 Not allowed - 12.01
15	Values of data type text must be a string of alphabets, numbers, special characters, and spaces.	NA
16	Values of data type date must be a date in the format ‘DD/MM/YYYY’. Here DD means day, MM means month and YYYY means years.	Allowed - 31/12/2019 Not allowed - 12/31/2019, 31/12/19, etc.
17	Values of data type reference must be a reference to another entity referring to a value in that entity. Only the code of the referred record from the referred entity is provided as value here.	NA
18	Value of the data type document must be a document which is to be provided separately as an attachment while submitting the data along with a filled data template.	NA