Electoral Roll Management System Guide
Electoral Roll Management System Guide
May, 2015
IT Cell
Election Commission of India
---------------------------------------------------------------------------------------------------------------------------------
Nirvachan Sadan, New Delhi
Handbook of Electoral Roll Management System (May, 2011)
1
TABLE OF CONTENTS
3. References 11
14. Constraints 30
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
2
TOPIC Page No.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
3
1
Introduction
Introduction
The Electoral Roll Management System (ERMS) enables the CEO to maintain
the complete electoral roll of state. The intensive & summary revisions i.e. updations,
additions and deletions required in the electoral roll can be easily managed and also
the time and expense on the information storing, sharing and publishing will be
reduced. The application software will reduce the manual work, streamline the
operation and hence increase efficiency, transparency and the productivity. It will also
facilitate in publishing of accurate and timely electoral roll.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
4
Purpose
The purpose of this document is to assist the potential users of State Chief
Electoral Office, and Offices under Election Department, determine if the software
specified meets their needs or how the software must be modified to meet their needs
and also to present the same in a brief and effortlessly comprehended fashion. In
addition, the preparation of this document ensures the rigorous consideration of the
concerned user-groups about their roles, responsibilities and requirements before
design begins and would reduce later redesign, recoding, and retesting. Also, the said
SRS, exclusively prepared for Election Department, will ultimately bring transparency
and efficiency and help the consumers in solving their problems with regards to quality
and quantity. This document will provide a baseline for validation and verification or
later enhancement of the finished product and acts as a proof for resolution of any
conflict arising about the features of the proposed system during testing and delivery
phases of the software system.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
5
Definitions, Acronyms and Abbreviations
Definitions
Application - A program or group of programs designed for end users. Software can
be divided into two general classes: systems software and applications software.
Systems software consists of low-level programs that interact with the computer at a
very basic level. This includes operating systems, compilers, and utilities for managing
computer resources.
Browser - Short for Web browser, a software application used to locate and display
Web pages. The two most popular browsers are Netscape Navigator and Microsoft
Internet Explorer. Both of these are graphical browsers, which means that they can
display graphics as well as text.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
6
DBMS – (Database Management System) -A collection of programs that enables you
to store, modify, and extract information from a database. There are many different
types of DBMS, ranging from small systems that run on personal computers to huge
system.
Internet - A global network connecting millions of computers. More than 100 countries
are linked into exchanges of data, news and opinions.
Unlike online services, which are centrally controlled, the Internet is decentralized by
design. Each Internet computer, called a host, is independent. Its operators can
choose which Internet services to use and which local services to make available to
the global Internet community.
ISP - Short for Internet Service Provider; a company that provides access to the
Internet. For a monthly fee, the service provider gives you a software package,
username, password and access phone number. Equipped with a modem, you can
then log on to the Internet and browse the World Wide Web and send and receive e-
mail.
In addition to serving individuals, ISPs also serve large companies, providing a direct
connection from the company's networks to the Internet. ISPs themselves are
connected to one another through Network Access Points (NAP).
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
7
Program - An organized list of instructions that, when executed, causes the computer
to behave in a predetermined manner. Without programs, computers are useless.
Servers are often dedicated, meaning that they perform no other tasks besides their
server tasks.
WEB - A system of Internet servers that support specially formatted documents. The
documents are formatted in a markup language called HTML (Hypertext Markup
Language) that supports links to other documents, as well as graphics, audio, and
video files. This means you can jump from one document to another simply by clicking
on hot spots. Not all Internet servers are part of the World Wide Web.
There are several applications called Web browsers that make it easy to access the
World Wide Web. World Wide Web is not synonymous with the Internet.
Web Server - At its core, a Web server serves static content to a Web browser by
loading a file from a disk and serving it across the network to a user's Web browser.
The browser and server, talking to each other using HTTP, mediate this entire
exchange.
Booth Level Officer – In order to enhance the fidelity of the electoral roll through a
grass root level feedback mechanism, the Election Commission of India introduced a
system of appointing Booth Level Officers (BLO). The BLOs are election officials
responsible for accuracy of electoral rolls at polling station level. They are responsible
to conduct door-to-door survey and make corrections to Electoral Roll working copy.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
8
Electors' Photo Identity Cards (EPIC) - In an attempt to improve the accuracy of the
electoral roll and prevent electoral fraud, the Election Commission ordered the making
of photo identity cards for all voters in the country in Aug, 1993. To take advantage of
latest technological innovations, the Commission issued revised guidelines for EPIC
Program in May 2000.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
9
Abbreviations & Acronyms
Abbreviation Description
ECI Election Commission of India
CEO Chief Electoral Officer
DEO District Election Officer
RO Returning Officer
ARO Assistant Returning Officer
BLO Booth Level Officer
ERO Electoral Registration Officer
EPIC Electors' Photo Identity Card
AC Assembly Constituency
PC Parliamentary Constituency
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
10
References
Reference
S. No. Document Title / Websites Source of reference
No.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
11
About the Organization
The Constitution of India has vested in the Election Commission of India the
superintendence, direction and control of the entire process for conduct of elections to
Parliament and Legislature of every State and to the offices of President and Vice-
President of India.
At the district and constituency levels, the District Election Officers, Electoral
Registration Officers and Returning Officers, who are assisted by a large number of
junior functionaries, perform election work. They all perform their functions relating to
elections in addition to their other responsibilities. During election time, however, they
are available to the Commission, more or less, on a full time basis.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
12
Organizational Structure of
Office of the Chief Electoral Officer (CEO)
District
Information
Returning Officer Joint Chief
Electoral Officer Electoral
Registration Officer
Officer
District
Assistant Information Deputy
Returning Assistant Chief Electoral
Assistant
Electoral Officer Officer
Registration
Officer
Under
Secretary Assistant
Presiding Chief Electoral
Officer (Election)
Officer
Polling Deputy
Officer Director
Assistant
Director ( IT )
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
13
Aims and Objectives of the Organization
India is a constitutional democracy with a parliamentary system of government,
and at the heart of the system is a commitment to hold regular, free and fair elections.
These elections determine the composition of the government, the membership of the
two houses of parliament, the state and union territory legislative assemblies, and the
Presidency and vice-presidency.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
14
Parliament
The Parliament of the Union consists of the President, the Lok Sabha (House of
the People) and the Rajya Sabha (Council of States). The President is the head of
state, and he appoints the Prime Minister, who runs the government, according to the
political composition of the Lok Sabha. Although the government is headed by a Prime
Minister, the Cabinet is the central decision making body of the government. Members
of more than one party can make up a government, and although the governing
parties may be a minority in the Lok Sabha, they can only govern as long as they have
the confidence of a majority of MPs, the members of the Lok Sabha. As well as being
the body, which determines whom, makes up the government, the Lok Sabha is the
main legislative body, along with the Rajya Sabha.
The members of the Rajya Sabha are elected indirectly, rather than by the
citizens at large. Rajya Sabha members are elected by each state Vidhan Sabha
using the single transferable vote system. Unlike most federal systems, the number of
members returned by each state is roughly in proportion to their population. At present
there are 233 members of the Rajya Sabha elected by the Vidhan Sabhas, and there
are also twelve members nominated by the President as representatives of literature,
science, art and social services. Rajya Sabha members can serve for six years, and
elections are staggered, with one third of the assembly being elected every 2 years.
Nominated members
The president can nominate 2 members of the Lok Sabha if it is felt that the
representation of the Anglo-Indian community is inadequate and 12 members of the
Rajya Sabha, to represent literature, science, art and the social services.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
15
State Assemblies
India is a federal country, and the Constitution gives the states and union
territories significant control over their own government. The Vidhan Sabhas
(legislative assemblies) are directly elected bodies set up to carrying out the
administration of the government in the 28 States of India. In some states there is a
bicameral organisation of legislatures, with both an upper and Lower House. Two of
the seven Union Territories viz., the National Capital Territory of Delhi and
Pondicherry, have also legislative assemblies.
Elections to the Vidhan Sabhas are carried out in the same manner as for the
Lok Sabha election, with the states and union territories divided into single-member
constituencies, and the first-past-the-post electoral system used. The assemblies
range in size, according to population. The largest Vidhan Sabha is for Uttar Pradesh,
with 403 members; the smallest Pondicherry, with 30 members.
The President is elected by the elected members of the Vidhan Sabhas, Lok
Sabha, and Rajya Sabha, and serves for a period of 5 years (although they can stand
for re-election). A formula is used to allocate votes so there is a balance between the
population of each state and the number of votes assembly members from a state can
cast, and to give an equal balance between State Assembly members and National
Parliament members. If no candidate receives a majority of votes there is a system by
which losing candidates are eliminated from the contest and votes for them transferred
to other candidates, until one gain a majority. The Vice President is elected by a direct
vote of all members elected and nominated, of the Lok Sabha and Rajya Sabha.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
16
Product Scope & Objective
The objective of the system is to manage the Electoral roll of the state. The
electoral roll is a list of all people in the constituency who are registered to vote in
Indian Elections. Only those people with their names on the electoral roll are allowed
to vote. The electoral roll is normally revised every year to add the names of those
who are to turn 18 on the 1st January of that year or have moved into a constituency
and to remove the names of those who have died or moved out of a constituency. If
you are eligible to vote and are not on the electoral roll, you can apply to the Electoral
Registration Officer of the constituency, who will update the register. The updating of
the Electoral Roll only stops during an election campaign, after the nominations for
candidates have closed.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
17
2 Overall Description
The ERMS (Electoral Roll Management System) will cover the entire process of
Electoral Roll preparation for the state from Electoral Roll Revision data management
to final Electoral Roll publishing.
An application used to Add, Delete and Update the Electoral Roll. This application is
supported by 4 prescribed formats, namely.
The form designed for data entry at the BLO level would be as prescribed by
ECI. The citizen willing to list as an elector need to fill the form 6 and submit to the
nearest ERO or the BLO. The BLOs carry door to door survey and eligible resident’s
data is collected for inclusion in the electoral roll. After proper scrutiny of the given
details, it will be entered into the client software by the ERO office. The ERO also has
the option to enter the electoral details suo-moto. After the completion of the data
entry the data will be transmitted to the server.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
18
Basic captured details of the Form 6:
Sl.
Data Detail
No.
01. Applicants Details Name, Surname, Sex
02. Age as on date Years, Month
03. Date of Birth Day, Month and Year
04. Place of birth Town, District and State
Father’s/ Mother’s or Husband’s Name and Surname
05.
details
Particulars of ordinary House/
place of Door number,
Street/Area/Locality/Mohalla/Road,
06. residence (Full address)
Town / Village, Post Office,
Tehsil/Taluka/Mandal/Thana,
District, Pin Code
Details of member(s) of applicant's Name, Relationship with applicant,
family already included in the current Part number of the roll of the
07. electoral roll of the Constituency Constituency, Serial number in
that Part, Elector's Photo Identity
and Card Number.
Electors photo identity card details (if Number and date of issue
08.
issued)
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
19
Form 7 - Application for objection to inclusion of name in electoral roll
The form designed for data entry at the BLO level would be as prescribed by
ECI. Certain times objections are received by the citizens or political parties over the
inclusion of names of electors who may not be eligible for inclusion. This objection can
be raised through form 7 and submitted to the nearest ERO or the BLO. The
verification officer appointed carries the verification and submits the report to the ERO.
After proper scrutiny of the given details, the updation will be carried out on the client
software by the ERO office. The ERO also has the option to delete a electoral suo-
moto. After the completion of the data entry the data will be transmitted to the server.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
20
Basic captured details of the Form 7:
Sl.
Data Detail
No.
Details of person whose entry is to be Name and Surname
01.
deleted
Elector roll details of person whose Part number of electoral roll in
entry is to be deleted which his/her name is included,
02. His/her serial number in that part,
Elector's Photo Identity Card (if
issued) Number.
Details of objector Name, Surname, Sex, Part
number of electoral roll in which
03. objector's name is included,
His/her serial number in that part,
Father's or Mother's or Husband’s
Name and Surname (if any)
Particulars of place of ordinary House/ Door number,
residence of objector/person seeking Street/Area/Locality/Mohalla/Road,
04. deletion. (Full address). Town / Village, Post Office,
Tehsil/Taluka/Mandal/Thana,
District, Pin Code
05. Reason(s) for objection / deletion
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
21
Form 8 - Application for objection to particulars entered in electoral roll
The form designed for data entry at the BLO level would be as prescribed by
ECI. The citizen willing to update the personal details can fill the form 8 and submit to
the nearest ERO or the BLO. After proper scrutiny of the given details, it will be
entered into the client software by the ERO office. The ERO also has the option to
update the electoral details suo-moto. After the completion of the data entry the data
will be transmitted to the server.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
22
Basic captured details of the Form 8:
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
23
Form 8A - Application for transposition of entry in electoral roll.
The form designed for data entry at the BLO level would be as prescribed by
ECI. The citizen willing to transposition his/her name to a different polling booth need
to fill the form 8A and submit to the nearest ERO or the [Link] proper scrutiny of
the given details, it will be entered into the client software by the ERO office. The ERO
also has the option to transposition the electoral details suo-moto. After the
completion of the data entry the data will be transmitted to the server.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
24
Basic captured details of the Form 8A:
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
25
2.1.2 ERO Application:
This application for the Elector Registration Officer to approve revisions made
through ‘Summary Revision Data upload Application’. Considering the sensitivity of the
application, it will be provided additional security using Digital signatures for
authentication. Authorized users i.e., the EROs will be provided Digital certificates that
will be verified on logins.
Role of ERO
- Assign Enquiry officer for each parts of the AC for each type of forms
received i.e., Form6, Form7, Form8, Form8A.
- Save report received from Enquiry Officer, i.e., found correct, Found
incorrect or Need further clarification
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
26
2.1.3 Integration and Roll Printing Application:
The electoral rolls for all assembly constituencies are summarily revised every year
except when intensive revision is ordered in any year. In addition the commission
orders intensive revision every alternate year. In any year when an intensive revision
is ordered, there will not be any summary revision. Further, the Commission can also
direct at any time, a special revision for any constituency or part of a constituency.
Integration of rolls has to be done before any revisions.
Once the revision process starts Rolls namely Mother Roll, lists of amendments,
working copies etc has to be generated. The Application software manages both
integration and printing of Rolls.
Role of ERO
- Integrate Rolls of ACs under him one by one.
- Generate Electoral Rolls ie, Mother Roll and Additional Rolls, Working
copy, Top sheet and others using the application.
- Option to generate these Rolls with photo and without photo.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
27
2.1.4 Photo Merging Application:
Photograph of the Elector is used in Elector Roll and also in EPIC to identify the
person. The Application software is used to merge photos of the electors with the
Elector Roll.
Photograph of the Electors in jpeg file format of file size below 20 KB will be selected
and uploaded through this software. Uploaded file will be saved in database. Provision
to delete photos also will be provided for removing incorrect data.
The main function of this application is:
ERO/ Authorized Private Vendor
- Do digital photography of electors in jpeg format of file size less than
20kb.
- Upload these photos corresponding to the elector’s data available at the
data server using the application.
- Option to upload photos for both mother roll and additional rolls.
- Option to delete incorrect data.
ERO can create EPIC for Electors using this application. The main functionalities of
this application are:
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
28
2.2 User Characteristics
Users should have undergone training for the use of application software to be
Access to the system will be through the digital signature provided on a smart
card issued by NICCA. Without the DSC the user will not be allowed to login to
the application or enter the data. The DSC will be issued by name to the RO,
ARO and ERO. The transfer of ownership in case of transfers of the officers or
change in vendor will not be permitted and each person authorized to use the
Users should keep the local system virus free in order to be safe on any
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
29
2.3 Constraints
This subsection will specify the constraints placed on design that will limit the
System shall be able to work on slow client machines (P-III and above) as
The system will be password protected and access rights will be defined for its
Server’s response will be fast enough to provide multiple accesses (30) through
system.
System will have sufficient built-in checks to avoid acceptance of invalid data
System shall update the particular information in all related tables once it is
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
30
2.4 Hardware Requirement
The following table represents the proposed hardware requirement (minimum) for Web
Based MIS System.
Web /
Items Database Server Application Client
Server
Intel Xeon Four Intel Xeon Four Intel Pentium
Processor Dual Processor Dual Dual Core
Core 2.93GHz, Core 2.93GHz, Processor
Processor
and higher and higher
(Latest (Latest
Configuration) Configuration)
RAM 4GB 4GB 1GB
3X72 GB, 10000 3X72 GB, 10000 160 GB 7200 rpm
HDD rpm SAS Hot rpm SAS Hot Serial ATA HDD
Plug Plug
CD-ROM DVD Drive DVD Drive DVD Drive
Floppy 1.44 MB 1.44 MB 1.44 MB
12/24 GB SCSI 12/24 GB SCSI
Tape Drive
Tape Drive Tape Drive
10/100/1000 10/100/1000 10/100/1000 on
board integrated
MBPS Gigabit MBPS Gigabit
Network Port
Ethernet Ethernet with
NIC remote booting
Controller, Controller,
facility remote
remote wake up. remote wake up. system
installation,
remote wake up.
Windows 2003 Windows 2003 Windows XP
Operating
Advance Advance
System
Server/Linux. Server/Linux.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
31
Suitable Web-
Web Server
Server.
The data will be
stored in a
RDMS, which
Other1 provides
adequate
security
provisions.
Anti-virus latest Anti-virus latest Anti-virus latest
Other2
software software software
Above server can be used as Backup Server but it is advisable that separate server
with the same configuration may be used as Backup Server.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
32
2.5 Assumptions & Dependencies
The assumptions declared herein will provide ground for the realization of the
requirements avowed by this SRS. The requirements, therefore, should be well
thought-out as dependent on these assumptions. The assumptions are as stated
below : -
Sufficient number of trained computer staff shall be available in the office to use
the system.
All the prospective users, with the intention of using the developed system, must
be logged on to the Internet/Intranet.
Any security or other issue at the OS level will not be considered as problem of
this system.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
33
2.6 Software System Attributes
Reliability
Business rules, Integrity checks etc. will be put-into-effect in order to curtail the errors
in data entry. Users shall be provided with ample online and manual HELP facilities
and dialog box messages.
Availability
Availability of network is crucial for effective communication and proper working of the
system. This can be ensured through reliable Internet connectivity.
Portability
The client application being browser based remain independent of server platform.
Furthermore, the application software package will be web-based, Unicode enabled,
based on Object Oriented/component paradigm, n-tier client/server architecture,
RDBMS will have features for data storage/manipulation/retrieval/network interface
facility, Multimedia enabled so that updating /maintenance of application software and
data portability is easy and feasible in the future.
Security, Back
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
34
3 Security, Backup & Recovery
Security
Multi-level security is proposed for the application software at each operating level.
The different levels of security are as follows.
DSC shall be provided to all users. Controlled module access and navigation
would give next level of security while using application. The privileges and
authorization shall be delegated designation and cadre-wise. The security shall be
achieved by providing each user with a limited access, only to the functions they are
authorized to use. Whenever a user attempts to login through any given login id and
password, the login details would be verified against those provided and only then the
user shall be allowed to access the application.
This level of security is offered by the DBMS via database user names and
passwords. Proper rights and privileges should be set to tables and procedures. Each
data entity shall have a set of authorized users for data entry and modification.
At this level security is provided by the operating system. Separate user names
and passwords are to be introduced for different users or user-groups. Application
software would have no control on this.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
35
4) Network Level Security
While transmitting information over the wide area network, data should be
secure and free from risk of eavesdropping and alteration from unauthorized person.
There should be strong user authentication and data encryption. Networking System
Software shall provide such security.
5) Audit Trails
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
36
3.2 Backup
There are two types of Backup operations :
Full Backup: Image of complete database is stored on a backup media.
Incremental Backup: Only the changes on the database from a predetermined
point of time are stored.
The operating system and the DBMS should support following Backup Features:
Backing up of entire database (or a subset of the database) should be allowed in
one operation.
Incremental backup should be supported.
Following Periodic Backup operations are proposed
a) Daily Backup
b) Weekly Backup
c) Monthly Backup
At the end of every month, backup of entire database, application software, system
software and all working directories should be taken. Backup of selective print files like
monthly/quarterly/annual progress reports should also be included in the monthly
backup. This type of backup should also be taken before loading any new
version/patches of application/system software.
d) Yearly Backup
At the end of the financial year, complete backup of the current year data should be
taken and stored offline preferably at a safe remote location.
Note: As a means to prevent loss of crucial data due to natural or other types of
disasters or calamities, a copy of the backup of database is to be kept outside the
office e.g. at higher level office or at any safe remote location.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
37
3.3 Recovery
In case of system failure or database crashing, the last full backup of database should
be restored and incremental backups should be applied to bring the database to the
current status.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
38
Introduction to Electoral Roll Management System Applications
For a free and fair election, an accurate and error free electoral roll in most
is has the following major roles to play for the creation and maintenance of electoral
roll : -
8. Printing of Part’s header page, electoral roll and many other MIS reports
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
39
Electoral Roll Management System – WORKFLOW
DE-DUPLICATION
AC_01
UPLOADED
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
40
Understanding work flow of
Summary Revision Data Upload
(With Screen Shots)
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
41
Summary Revision Data Upload
g. To make copy of vendor’s database from local machine, later the same
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
42
Summary Revision Data Upload – Configuration and Execution
1. Create database with a name ECIControlTable and AC’s database as per the
Commission’s guidelines in MS SQL Server 2005 / 2008.
2. Transform / Export your State / UT ‘s data in the above said database
3. Verify the correct linking of various control tables – AC, PC, Districts, Tehsils,
Patwari Circles, Villages, Towns, Metros and Wards etc.
4. Create password protected MS Access file as ClientDB (Password
3upload2008)
5. Export all the ECIControlTable data into [Link].
6. The ClientDB database kept at local machine is used to keep the records at
vendor’s level.
7. Create database with a name UPLOADED in MS SQL Server 2005 / 2008
8. In database UPLOADED must have the following tables ( Eg. for AC001 ) : -
a. AC001_Form6
b. AC001_Form7
c. AC001_Form8
d. AC001_Form8A
e. Login Table: upload_login (Authentication)
9. Using MS Visual Studio 2008 open SummaryRevisionDataUpload solution
from provided ECI software / application
10. The software web services can be hosted in built in server of MS Visual
Studio 2008 or local machine IIS
11. Update web references of the software if required
12. Update [Link] as per the database at your local machine.
13. Build the solution and Run / Execute.
14. Username: 001001 (001 – AC No. and 001 – Part No.) and Password: 1
----------------------------------------------------------------------------------------------------------
Note : Form 6 entries go to local machine in [Link] and Form 7 / Form 8
/ Form 8A go to UPLOADED database at State / UT level
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
43
Process : Authentication
Description : In this login screen, enter Username 001001 as 001 AC No
and 001 Part No, password is 1.
Web Method : allowUploadUserToLogin
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
44
Process : Selection of Part
Description : In this screen, Select AC No and Part No and click button
Select Part No.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
45
Process : Selection of Form 6,7,8 and 8A
Description : For Form 6 /7 / 8 and 8 A,6A,Update Form6A you can select
any option from the menu for respective form to enter
[Link] 6 data goes to [Link] at local machine
Form 7, Form 8 and Form 8A,Form6A,UpdateForm6A go
to UPLOADED database at State level. In this form you can
also see, selected AC No and Part No are displayed.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
46
Process : Form 6 submission and navigation
Description : Data Entry Form for Form 6, you can also navigate between
available records. This form displays records from the local
machine. ClientDB MS Access file is used to keep all the
applications received for Form 6. The password for this file is
3upload2008.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
47
Process : Submission of Form 7
Description : Data Enter Form for Form 7. The data goes to UPLOADED
database at State Level. To view records, enter serial no. of
the voter and this will display the specific record. This form
reads records from the main list or ‘Mother Roll’
Web Method: UpdateForm7Data
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
48
Process : Submission of Form 8
Description : Data Entry Form for Form 8. The data goes to UPLOADED
database at State Level. To view records, enter serial no. of
the voter and this will display the specific record. This form
reads records from the main list or ‘Mother Roll’
Web Method : UpdateForm8Data
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
49
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
50
Process : Submission of Form 6A registration of NRI Voter’s
Description : Data Enter Form for Form 6A. The data goes to UPLOADED
database at State Level. To view records, enter serial no. of
the voter and this will display the specific record. This form
reads records from the main list or ‘Mother Roll’
Web Method : UpdateForm6AData
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
51
Process : Submission of UpdateForm6A for Modification of NRI Voter’s
Description : Data Enter Form for UpdateForm6A. The data goes to
UPLOADED database at State Level. To view records, enter
serial no. of the voter and this will display the specific record.
This form reads records from the main list or ‘Mother Roll’
Web Method : UpdateForm6AData
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
52
Process : Selection of menu option to view uploaded data or to upload
Form 6 data
Description : You can view the brief and detailed report of ‘uploaded’ data.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
53
Process : Uploading of data to ‘UPLOADED’ database
Description : You can upload the Form 6 data from your local machine to
uploaded database kept at the state level. Either you can
export all or specific records. This form reads data from local
machine ‘ClientDB’ file and transfer the records to
‘UPLOADED’ database kept at the State / UT level.
Web Method: SndClientData
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
54
Process : To view brief report on uploaded data
Description : You can view brief report of uploaded data of any Form 6 / 7 /
8 and 8A. This form reads AC No, Part No and select Form
to view the records.
Web Method : selectUploadedDataShortForm
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
55
Process : To view uploaded data detailed report
Description : You can view detailed report of uploaded data for any Form 6
/ 7 / 8 and 8A. This form takes AC No, Part No and Form
type to display detailed report of ‘uploaded’ data from State /
UT level database.
Web Method : selectUploadedData
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
56
Process : Deletion of uploaded data
Description : You can delete any record of uploaded data for any Form 6 /
7 / 8 and 8A if required using this form. Select AC No, Part No
and select form type, the select all or specific records, then
click on ‘delete uploaded data’ button to delete the records
from State / UT level database.
Web Method : deleteUploadedData
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
57
Process : To view duplicate records in database
Description : To check duplicate records in database, select the menu
option
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
58
Process : View duplicate records
Description : Choose AC No and desired language then click on
‘Show Duplicate Data’ button
Web Method: selectDuplicateRecordwithoutPhoto
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
59
Process : View duplicate records with photos
Description : Choose AC No and desired language then click on
‘Show Duplicate Data’ button
Web Method: selectDuplicateRecord
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
60
Process : BLO’s can get checklist of those forms in which ERO has appointed
his/her as an enquiry officer.
Description : Select Blo’s Name,Form Type and form receiving date then click
Show button.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
61
Process : If BLO want to get some changes in forms data then he/she will be
informed to operator and operator will change the forms data thorugh
the help of this form.
.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
62
Process : Through this form Operator can update only Mobile No and Email Id
of the [Link] would be directly reflected in main database
.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
63
Process : Through this form Operator can enter service elector’s [Link] the
help of this single form we can generate addition, modification,
deletion supplement of service electors.
.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
64
Process : Copying of database
Description : To copy [Link] database at any specific location,
select the menu option
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
65
Process : Selection of location
Description : Select the location, where you want to keep the copy of
[Link].
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
66
Process : View MS Access database - Client DB
Description : [Link] is created at the specified location. If you wants
to transfer the records from one machine to another where
internet connectivity is available, to further transfer it to State / UT.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
67
Understanding work flow of
ERO / AERO Software
( With Screen Shots)
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
68
ERO / AERO Software
4. The uploading of data in the database kept at State / UT level with digital
card authentication
officers
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
69
ERO / AERO Software – Configuration and Execution
--------------------------------------------------------------------------------------------
Note 1 : State / UT are requested to make ‘clean’ control tables as per the
guidelines of ECI in order to execute the said application / software
successfully
Note 2 : In database change data Admin to ERO in table LOGIN for field ULEVEL
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
70
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
71
Process : Authentication
Description : In this login screen, login with username Admin and
password 123.
Web Method : allowEROUserToLogin
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
72
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
73
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
74
Process : Enquiry Officer Details
Description : Select menu option ‘MastersEnquiry Officer Details’ for
maintaining Enquiry Officer master
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
75
Process : Recommendation Reason
Description : Select menu option ‘Masters Recommendation Reason
for maintaining Recommendation Reason master
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
76
Process : Upload ERO Signature
Description : Select menu option ‘Upload ERO Signature’ for uploading
ERO’s signature for PVC epic card.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
77
Process : Appointing Enquiry Officer
Description : Select menu option ‘Appoint Enquiry Officers’ for assigning
duties to BLOs for field verification
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
78
Process : Appointing Enquiry Officers
Description : For Form 6 / 7 / 8 and 8 A, ERO or AERO can assign
enquiry officers for field verification along with date of
submission of their reports after verification.
Web Method : appointEnqOfcer
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
79
Process : Filling Enquiry Officers’ Report
Description : After receiving reports from enquiry officers, this form is
used by ERO and AERO to submit the reports given by
enquiry officers after their field verification.
Web Method : saveEnqOfcerReport
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
80
Process : Issuing order after appointing Enquiry Officers or without
appointing enquiry officer
Description : Select the given menu option to pass an order by ERO or
AERO with or without appointing enquiry officer.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
81
Process : EROs’ issuing order after appointing enquiry officers or
without appointing enquiry officer
Description : This form is used by ERO and AERO to pass an order such
as approved, rejected or approved with changes for form
applications received from citizens.
Web Method : saveEnqOfcerReport
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
82
Process : Clerical Errors’ correction
Description : Select this menu option to make correction of clerical
errors.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
83
Process : Clerical errors’ correction
Description : Using this data entry form, ERO or AERO can make clerical
corrections in data from the main, supplementary list.
Web Method : ElectorDataUpdateRollWise
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
84
Process : Removal of incorrect approval.
Description : Select this menu option for the removal of
incorrect approvals from the database.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
85
Process : Removal of incorrect approval, when database is not
updated yet.
Description : Select this menu option for the removal of incorrect
approvals from the database.
Web Method :
1. saveDataForReversalBeforeDBUpdate
2. Form6ReversalUpdate
3. Form7ReversalUpdate
4. Form8ReversalUpdate
5. Form8AReversalUpdate
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
86
Process : Deletion of duplicate records
Description : Select this menu option for the removal of
duplicate records from the database.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
87
Process : Deletion of duplicate records
Description : This form is used to view the duplicate records from the
database. The listed duplicate records can be deleted by ERO
or AERO by this form. Select AC No, Part No and type of list,
now select specific records and click on delete button.
Web Method : DeleteInPartWiseTableWiseDuplicateRemoval
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
88
Process : Exporting of approved records.
Description : Select this menu option to export the
approved records to main database.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
89
Process : Exporting of ‘uploaded’ data into ‘main’ database.
Description : This form is used to list the records approved by ERO or
AERO. Now the selected records can be uploaded to the
main database for a particular AC for Form 6,7,8 or 8A.
Enter AC No, Part No, then select approved record to upload
them to main list or ‘Mother Roll’.
Web Method : updateDB
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
90
Process : Exporting of ‘uploaded’ data into ‘main’ database.
Description : This form is used to list the records approved by ERO or
AERO. Now the selected records can be uploaded to the
main database for a particular AC for Form 6,7,8 or 8A. You
can also view current records from the ‘main’ database.
Web Method : updateDB
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
91
Description : After Integration ERO can increase age 1 year or decrease
age one year of all electors in mother roll.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
92
Understanding work flow of
Integration and E-Roll Printing
( With Screen Shots)
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
93
Integration and E-Roll Printing Software
c. Supplementary ist
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
94
Integration and Roll Printing Software – Configuration and Execution
1. Create database with a name ECIControlTable and AC’s database as per the
guidelines of the Commissions in MS SQL Server 2005 / 2008
2. Transform / Export your State / UT ‘s data in the above said database
3. Verify the correct linking of various control tables – AC, PC, Districts, Tehsils,
Patwari Circles, Villages, Towns, Metros and Wards etc.
4. Using MS Visual Studio 2008 open Integration and Roll Printing solution from
provided ECI software / application
5. The software web services can be hosted in built in server of MS Visual
Studio 2008 or local machine IIS
6. Update web references if required
7. Update [Link] as per the database at your local machine
8. Build the solution and Run / Execute
9. Select District from combo box and password 1
10. You can also login as Admin selecting ‘District option’ and password is 1
---------------------------------------------------------------------------------------------------------
Note 1 : To print Part header page ‘clean’ control tables are required
Note : For integration to more database are required, for eg for AC_01,
AC_01BackUp and AC_01Working is required. The integration process
will automatically create required tables for a particular AC.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
95
Process : Authentication
Description : Select your district and password to login for integration
and printing of electoral roll
Eg. Select District : KORIA and Password : 1
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
96
Process : Integration and Electoral Roll Printing
Description :
1. Backup of Mother Roll, Addition Sup., and Modification Sup. is taken
into AC_01Backup database
2. Makes new ‘ Mother Roll ‘ into AC_01Working
a. Creation of new tables for new ‘Mother Roll‘
b. Backup from ‘Mother Roll’ where mflag=dflag=0
c. Backup of Addition Supplementaries Records
d. Backup of Modified Supplementaries Records
e. Backup into History Table from ‘Mother Roll’ where dflag=1
3. Renumbering
a. Old Serial Nos. are maintained
b. Old Form No are maintained
c. Setting current FormNo to ‘NULL’
d. Renumbering of voters’ Serial No. on the basis of SectionNo,
House No, LastName, Age in descending order
e. Setting mflag=dflag=0 for new ‘ Mother Roll ‘
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
97
Process : To print reports such as electoral roll with or without
photographs
Description :
1. Enter AC No, Part No and click on any specific ‘Report’ button
2. This is form is used to print varieties of reports as per the
Commission guidelines, such as electoral roll with or without
photographs, Parts’ header page, list of service voters,
alphabetically list of voters, list of missing voters, supplementary
lists etc.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
98
Integration and Roll Printing – HINDI INTERFACE
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
99
PART’s HEADER PAGE
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
100
LIST OF VOTERS WITHOUT PHOTOGRAPHS
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
101
LIST OF VOTERS WITH PHOTOGRAPHS
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
102
SUMMARY OF SUPPLEMENTARY LIST
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
103
SUPPLEMENTARY LIST
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
104
LIST OF SERVICE VOTERS
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
105
LIST OF MISSING ELECTORS
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
106
ALPHABETICALLY LIST OF ELECTORS WITHOUT PHOTOGRAPHS
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
107
Understanding work flow of
Photo Merging Software
( With Screen Shots)
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
108
Photograph Merging Software
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
109
Photo Merging Software – Configuration and Execution
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
110
Process : Authentication
Description : To login enter username : Admin and password : 123
Web Method : wmLogin
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
111
Process : Merging of photographs
Description :
1. To view records, select AC and Part and click on Find button.
2. To merge photographs, browse a photograph by clicking browse
button and click on ‘ Upload the Photo‘ button for ‘Supplementary
List‘
Web Method : wmUpdateData
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
112
Understanding work flow of
EPIC Software
( With Screen Shots)
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
113
EPIC Software
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
114
EPIC Software – Configuration and Execution
1. Create database with a name ECIControlTable and AC’s database as per the
guidelines of the Commission in MS SQL Server 2005/2008.
2. Transform / Export your State / UT’s data in the above said database.
3. Verify the correct linking of various control tables – AC, PC, Districts, Tehsils,
Patwari Circles, Villages, Towns, Metros and Wards etc.
4. Create AC wise database. For example if AC no is 1 then Database Name
would be AC_001_EPIC. There should be one SerialBlock Table in each EPIC
database.
5. Using MS Visual Studio 2008 open EPICwsOnline solution from provided ECI
software / application.
6. The software web services can be hosted in built in server of MS Visual Studio
2008 or local machine IIS.
7. Update web references if required.
8. Update [Link] as per the database at your local machine.
9. Build the solution and Run / Execute.
10. Enter Username : Admin and Password : 123
11. Digital Signature Authentication is required ( Current Status : Disabled )
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
115
Process : Authentication
Description : To login enter Username : Admin and Password : 123
Web Method : wmLogin
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
116
Process : EPIC Printing.
Description : Selection from menu option to print New EPIC Card and Duplicate
EPIC [Link] reports.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
117
Process : To search voter detail’s.
Description : To View records, select AC, Part,Roll type,EPIC type,Serial no and
Language and click on Show Voters List button.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
118
Process : Create New EPIC Cards
Description :
1. To view records, select AC, Part and Language and click on Find button.
2. To create new EPIC card, select a particular record or click on Above all to select all
the records in the grid and click on ‘Create New EPIC ’.
Web Method : wmAllotEPICNo, wmGetEPICs
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
119
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
120
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
121
New PVC EPIC Card Printing
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
122
Old EPIC Card (Paper based)
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
123
Process : Create Duplicate EPIC
Description : To View records, select AC, Part and Language and click on
Show Voters List button.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
124
Process : Create Duplicate EPIC
Description :
1. To print duplicate EPIC, select the serial number and select the reason for
Duplicate and click on Added to the Roll button.
2. Select the record from the grid and click on Create Duplicate EPIC button.
Web Method : wmAllotEPICNo and wmGetEPICs
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
125
Process : Reports on Counting of EPIC prepared by Vendor
Description : To view report, click on Report Menu and click on Counting of EPIC
prepared by Vendor.
Web Method : wmVendorEpicCount
Duplicate EPIC Printing
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
126
Process : Printing Outward Register/Issue Register.
Description : Select AC, Part, Select Date and click on Show button.
Web Method : wmGetData
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
127
Outward Register / Issue Register
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
128
Process : MIS Reports.
Description : Select AC, Part, Report type.
Web Method : wmEPICreport
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
129
Process : To search and print already existing EPIC’s(New and Duplicate.
Description : Select AC, Part, Type and Date and click on Show button.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
130
Process : To set the path where we can store EPIC’s
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
131
Setting in the system to print PVC EPIC
1. If the PVC printer is installed in the system, then open the EPIC Printing s/w
and in the crystal report DesignPrinter setup, select the PVC printer as
your printer name and select CR80 as your paper source.
2. If the PVC printer is not installed on your system, then you have to install PDF
Printer software in your system.
3. Then go to Device and printer, then select the pdf printer and click on Printer
Server properties.
4.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
132
5. To create a new form, follow these steps:
Access the Forms tab of the Print Server Properties dialog box.
Use the Forms On list box to select the existing form on which you want to
base the new form.
Select the Create A New Form check box.
Enter a new name for the Form in the Form Description For field. Name as
CR80.
Use the fields in the Measurements area to set the paper size and margins
and specify the width and height as mentioned in the above figure.
Choose the Save Form button to save the form.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
133
6. Go to crystal report DesignPrinter setup
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
134
Process : Login Authentication Window
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
135
Process : It’s a main window
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
136
Process: It’s a common type of interface for all application Summary
revision,ERO application,Epic [Link] can create user for
Summary revision software through this window you can also delete
or disable user through this window.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
137
Process: You can allocate or deallocate AC and parts to any user
from this window.
Database Structure
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
138
Process: You can store ERO digital card information from this
window.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
139
Process: Through this window you can stop All ACs or selected ACs
work process in ERO application
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
140
Electoral Roll Management System
Data Error Finder Module
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
141
ERMS Data error Software
2. The BLO working copy is generated for field verification and error count
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
142
List of Errors in Electoral Roll – database
15. Voter gender is female but relationship is F/O for voter age > 30
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
143
Process:
1. First Select Process i.e. Single AC or Multiple ACs.
2. Then select AC.
3. Then Select Error type i.e. ALL or single.
4. Then click the Get Data Button.
5. Then the report will generate.
6. This report contains all the error type within the part and within
the AC.
7. Error count report button will create the summary report of all
the errors.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
144
Error Count report (Summary):
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
145
BLO working copy report:
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
146
Control Table Management System
(With Screen Shots)
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
147
The main objectives of this software are as follows : -
This software is used to manage the control tables / master tables such as District,
PC, AC, Polling Station, Division, Tehsils & Village etc. User can perform the following
task : -
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
148
Process : Login Authentication Window
Description : The user types for login are CEO, DEO, ERO, SLA,
Vendor
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
149
Main Screen of Control Table Management System
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
150
Part header checklist report
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
151
Process : View/Edit AC details
Description : Choose AC No and then click on ‘EDIT’ button.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
152
Process : Update AC details
Description : Edit the details and then click on ‘Update’ button.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
153
Process : Add/View/Edit/Delete PS Building details
Description : Choose AC No , choose PS building and then click on
‘Add’ button. To add new PS building details.
To delete an existing PS Building details , click on
Delete button.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
154
Process : Add/View/Edit/Delete Section details
Description : Choose AC No , choose Part no., choose section no
and then click on ‘Add’ button. To add new Section
details.
To delete an existing section details, click on ‘Delete’
button.
To edit an existion section details, click on ‘Edit’ button.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
155
Process : Upload AC map
Description : Choose AC No, choose file name to upload and then
click on ‘Update’ button.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
156
Process : Upload Part map
Description : Choose AC No, choose part no., choose file name to
upload and then click on ‘Update’ button.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
157
Process : Print Report
Description : Choose Dist No, choose report type and then click on
‘Show’ button.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
158
Polling Station Rationalization Module
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
159
The main objectives of this software are as follows : -
Note : This exercise is conducted before draft publication to limit the total
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
160
Process : Add new Part
Description : Choose AC No and then click on ‘Select’ button.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
161
Process : Add new Part
Description :
1. Select part no from part drop down list which you want to break.
2. Enter new part name in English and Vernacular.
3. Click Add New Part Button.
After clicking Add New Part button one new part no 5 will be added in new part list table
and rest of parts after 5 will be increased 1 like 5 become 6,6 become 7…N become N+1
[Link] are also maintaining old_part_no log in newpartlist_mapping table.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
162
Process : Section Recreation
Description :
Through this form we can transfer sections from one part to another.
Select main part like 4 and split part like 5.
Now you will see whatever sections will be in part 4 that will be shown in upper grid.
Lower grid would be blank because it’s a like a new part so there would be no section in
this part 5.
Now you can transfer section no 2 from part 4 to part 5 just click Replace the selected
section button
As soon as you click Replace the selected Section button sec_detail table would be
updated and section no 2 electors data from part 4 would be transferred in part 5 and
deleted from part 4.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
163
Process : Section Renumbering
Description :
Through this form you can renumber the section .After transferring section no 2 from part 4
to part 5 only two sections 1 and 3 will remain in Part [Link] you can renumber section in
part 4 like set 3 to 2.
Note-Please do not test this software on original database it’s a trial basis so make a copy
of original database then run it on copy database.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
164
Electoral Roll Search
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
165
The main objectives of this software are as follows : -
This software is used to search elector’s details in the database. This software uses
two types of searches:
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
166
Process : Search in E-Roll
Description : Choose search type. Choose AC wise and choose District and then AC.
Then choose Search by name. After that click on ‘Search’ button.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
167
Process : Search EPIC No. in Electoral Roll
Description : Choose search type. Choose AC wise and choose District and then AC.
Then choose Search by EPIC No. After that click on ‘Search’ button.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
168
Process : Voter Slip
Description: click on ‘Show’ button
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
169
Claims & Objections Application
(Web based)
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
170
The main objectives of this software are as follows : -
This software is used to search application status during the summary revision in the
database. The current status of application can be tracked through this web based
application.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
171
Process : Tracking Status of Application
Description : Choose District, Choose AC, choose Part and then choose form type. Then
choose the from date and To date. After that click on ‘Show’ button.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
172
Process : View Digitized Form
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
173
Process : Search Name
Description : Enter form number. Click on ‘Show’ button.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
174
Auxiliary Polling Station Application
(Window based)
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
175
The main objectives of this software are as follows : -
This software is used to manage auxillary polling station. These polling stations are
temporary in nature. They are created to split electors into
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
176
Creation of Auxiliary Polling Station
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
177
Deletion of Auxiliary Polling Station
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
178
Change or Modify Polling Station Building
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
179
2. Deleting Sections from Auxiliary Polling Station
Note 1 : You are requested to perform all the above operation on dummy database for
testing purpose only.
Note 2 : Integration and Roll Printing s/w has been updated accordingly to print Main
Polling Station and Auxiliary Polling Station Address on ‘Header Page’ and each page
of photo roll ‘Main’ and ‘Auxiliary’ is specified.
Note 3 : Download 26-DEC-IntegrationRollPrinting-AUX and 25-DEC-AUXY-
MANAGER from ECI’s FTP Server for testing purpose.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
180
Google based Map Services
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
181
Google based Map Service is used to provide location of
polling station on Google Map to electors to cast a vote. The
end user can simply find his/her polling station on Google
Map along with polling stations details such as :
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
182
Click link ‘Know your Polling Station and BLO Details’
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
183
After searching pins will be displayed as shown above.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
184
Contact Details of Election Officials
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
185
Part Header Page to get Polling Station Details
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
186
Details of electors without photo will be displayed on the screen.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
187
BLO Register Application
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
188
BLO Register Application
Station
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
189
Steps to generate BLO Register : -
1. Run BLO Register s/w
2. Click ‘Process BLO Register Data’
4. Select Assembly Constituency and Click ‘Process’ to generate BLO Register Data
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
190
Steps to print BLO Register Page :-
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
191
8. Or Save Report in pdf format with following naming convention :-
i. BLO_REG_ [Link]
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
192
BLO Register Report
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
193
Format 1 to 8 Report Application
(ERoll Health Analysis Report)
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
194
Format 1 to 8 Report Application
following parameters : -
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
195
Select AC and Click on Generate Data
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
196
Select Report Option
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
197
Male, Female, Other and Age Cohort Report
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
198
Age Cohort Report
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
199
Photo Coveage and EPIC Coverage
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
200
AC wise Gender Ratio Report
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
201
ERoll Monitoring Dashboard
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
202
The monitoring of electoral roll at national level is done by
this web based application. The State level officials such
as CEO, DEO, ERO can monitor the health of electoral
roll at various level. The parameters to monitor the health
of are listed below : -
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
203
Steps to access : -
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
204
Login with CEOs, DEOs and EROs Username & Password
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
205
ERoll Monitoring Dashboard (Main Screen)
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
206
Population Electors (Male, Female, Others & Total)
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
207
Draft Publication Electors (Male, Female, Others & Total)
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
208
Summary Revision Electors (Male, Female, Others & Total)
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
209
Gender Conversion (Through Form 8)
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
210
Final Publication Electors (Male, Female, Others & Total)
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
211
Photo and EPIC Coverage
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
212
Duplicate and Error Correction
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
213
Photo, EPIC, and EP Ratio
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
214
Gender Ratio (Census & Electoral Roll)
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
215
Polling Station & Polling Station Locations
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
216
To access Graphical Analysis Reports – Click ‘Charts’ button
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
217
Bar Graph – PER and EPIC Coverage
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
218
Line Graph – PER and EPIC Coverage
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
219
Line Graph – Male, Female, Other
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
220
Pie Chart – Electors Contribution (State wise)
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
221
ERoll Monitoring Data Entry – Draft Publication
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
222
ERoll Monitoring Data Entry –Summary Revision
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
223
ERoll Monitoring Data Entry – Gender Modification
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
224
ERoll Monitoring Data Entry – Final Publication
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
225
ERoll Monitoring Data Entry – Photo & EPIC Coveage
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
226
ERoll Monitoring Data Entry – Duplicate & Error Correction
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
227
ERoll Monitoring Data Entry – Polling Station & Location
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
228
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
229
SMS Alerts
for
Tracking Application
SMS Alerts
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
230
In order to track the current status of application SMSs are being sent to
2. Enquiry Officer has been appointed for your enrolment in voter list. Ref. No is
2013BLS26S2001002A0003
2013BLS26S2001002A0003
2013BLS26S2001002A0003
5. Your application has been rejected by ERO. You can appeal to DM within next
6. You are registered in Electoral Roll. You may collect your EPIC from VRC/CSC
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
231
SYNOPSIS FOR
MAINTAINING MULTIPLE
SUPPLEMENTARIES
IN ERMS
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
232
Maintaining Multiple Supplementaries
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
233
4. Now, Maintaining Modification Supplementary
a. New record will have ORG_LIST_NO = 1 means Supplementary List No 1
b. CNG_LIST_NO = NULL
c. Status_Type = ‘M’ means modified record
d. Serial No within Part is same as in Mother Roll
e. Now, new record will contain changes and existing old record’s MFLAG set to
TRUE and CNG_LIST_NO set to 1
The way Mother Roll is linked with Supplementary 1, the same approach can be used
to link Supplementary 2 with Supplementary 1 or with Mother Roll itself. The
Supplementary No. will be maintained on the basis of dates of summary revision and
continuous revision. In fact, now we can maintain records for multiple summary
revisions within the year itself. The identification of supplementary list no. can be
identified by ORG_LIST_NO field. For ‘ Mother Roll’ ORG_LIST_NO is ‘0’ always.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
234
CASE STUDY – MANAGING ADDITIONS
In the given example, voter ‘SUMIT is new addition. The Serial No. allotted to
new elector would be max (serial no.) + 1 and ORG_LIST_NO field will have
supplementary list no and STATUS_TYPE will set to ‘N’ means new record.
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
235
CASE STUDY – MANAGING MODIFICATIONS
In the given example the ‘name’ of the voter has been modified twice, under
revision no. 1 and then again in revision no. 2 as well. Please note that all the
records are stored in the same table with same Serial No, within the part. Also
note that only latest record in all the given record has CNG_LIST_NO set to
NULL, as it can be used to fetch latest updated record.
Original Record :
AMIT 0 1 N TRUE
AMIT SHARMA 1 NULL M FALSE
AMIT 0 1 N TRUE
AMIT SHARMA 1 2 M TRUE
AMIT K
2 NULL M FALSE
SHARMA
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
236
CASE STUDY – MANAGING DELETIONS
In the given record is not deleted but only flagged as a deleted and its duplicate
record is saved within same table along with the ‘reason of deletion’.
Before Deletion
After Deletion
AMIT 0 1 D TRUE
AMIT 1 NULL S TRUE
Reasons of Deletion
1. E : Expired
2. S : Shifted
3. M : Missing
4. Q : Not Qualified
5. R : Repeat / Duplicate Record
---------------------------------------------------------------------------------------------------------------------------------
Handbook of Electoral Roll Management System (May, 2011)
237