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 |
