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.
The data type is an attribute of data, 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 in the right kind of data for a data field/ column in Excel, the below-given table has different data types with its description.
| S.No. | Data Type | Definition/Description |
|---|---|---|
| Sr. No. | Activity | Example |
|---|---|---|
The common configuration details required for all modules are available in this section. Refer to the list of standard documents required for processing applications across modules, find the standard checklist for filling master data templates, and get the answers to common configuration FAQs.
All content on this page by eGov Foundation is licensed under a Creative Commons Attribution 4.0 International License.
All content on this page by eGov Foundation is licensed under a Creative Commons Attribution 4.0 International License.
| Sr. No. | Activity | Example |
|---|---|---|
| S.No. | Activity | Example |
|---|---|---|
1
RC
Ration Card
ID Proof, Address Proof
This document is used as proof of identity if presented with photo and address proof.
2
AC
Aadhar Card
ID Proof, Address Proof
This document is used as proof of identity as well as address.
3
DL
Driving License
ID Proof, Address Proof
This document is used as proof of identity as well as address.
4
VC
Voter ID Card
ID Proof, Address Proof
This document is used as proof of identity as well as address.
5
PS
Passport
ID Proof, Address Proof
This document is used as proof of identity as well as address.
6
AL
Arms License
ID Proof, Address Proof
This document is used as proof of identity as well as address.
7
CC
Cast Certificate
ID Proof, Address Proof
This document is used as proof of identity if presented with photo and address proof.
8
DC
Domicile Certificate
ID Proof, Address Proof
This document is used as proof of identity if presented with photo and address proof.
9
PC
PAN Card
ID Proof
This document is used as proof of identity.
10
EB
Electricity Bill
Address Proof
This document is used as proof of address only.
11
TB
Telephone Bill
Address Proof
This document is used as proof of address only.
12
WB
Water Bill
Address Proof
This document is used as proof of address only.
13
RSA
Registered Sale Agreement
Address Proof
This document is used as proof of address only.
14
RLA
Registered Lease Agreement
Address Proof
This document is used as proof of address only.
15
VRC
Vehicle Registration Certificate
Address Proof
This document is used as proof of address only.
16
IAO
Income Tax Assessment Order
Address Proof
This document is used as proof of address only.
17
HT
House Tax Slip
Others
These are the documents which are specifically needed to avail a service.
18
FL
Food License
Others
These are the documents which are specifically needed to avail a service.
19
LL
Liquor Licence
Others
These are the documents which are specifically needed to avail a service.
20
GST
GST Registration
Others
These are the documents which are specifically needed to avail a service.
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
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
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
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
Q. What if the mandatory field value is not available and not filled?
The mandatory field value is a must in order to provide, without having those filled into template data can not be accepted.
Q. What if the non-mandatory field value is not available and not filled?
It is fine not to provide the non-mandatory field values. These are the fields which are nice to have.
Q. What if the codes are not readily available for the records?
Code is a must to provide. In case, code is not readily available simple sequencing of numbers can be used as codes.
Q. What if the definition of column header is not clear?
Contact the person who has shared the template with you.
Q. Can the order of the columns be changed while filling in the data?
The order of columns must remain intact and should not be altered.
Q. What if the entities are supposed to be defined at the state level but can not be defined?
In a case where the entities which are suggested to define at the state level do not work. Then those can be defined at the ULB level but then again can not be moved to state-level once configured.
Q. What are the benefits of defining the state level?
The benefits of defining the entity at the state level are given below.
Decision Support System - State-level definition and consolidation of data make data analysis and decision-making easy.
Maintenance of such data is easy and correction can be performed quickly.
Avoids the data duplicity in the configuration for those values which are most common across the ULBs.
Support standardization of process rules across the ULBs.