Checklist

Introduction

The 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

The 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 to fill the right kind of data for a data field/ column in excel, the below-given table has different data types with its description.

Sr. No.	Data Type	Definition/ Description
1	Alphanumeric	It contains 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

State Level: These activities are applicable to state-level entities only

Sr. No.	Activity	Example
1	The entity is to be decided to be defined at the 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

Sr. No.	Activity	Example
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 is not acceptable. RES - Residential RES - Non-residential
6	All the columns marked with an 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 charset only.	NA

Data Type Based: These activities are applicable to all entities

S.No.	Activity	Example
12	Values of data type alphanumeric consist of the 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 a 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