Updated to S/W Version 1.5 Update 1

Contains the first appointment letter.
Updated to S/W Version 1.6

Changes have been made in this version:
1) After second randomization proper message will come
2) SMS text has been changed

SMS will be sent from respective subdivision user
Updated to S/W Version 1.6 Update 1

This program would take only 40 sec , if you pls create two index using the following two scripts.

SQL:
create index asm_dcrc  on grp_dcrc(forassembly,groupid,member);
create index fasm_personnela  on personnela(forassembly,groupid,poststat) ;

Also, sending one file for including in election folder. 
This is related to dcrc tagging in 2nd randomisation.
Updated to S/W Version 1.6 Update 2

This would take care of updating pp data ( both personnel & personnela table) where you can specify personnel code (personcd) . Now updating would be easier.

Also, in  replacement , where person with booked= 'R'   status is replaced , replaced  person would  also have booked='R'
Updated to S/W Version 1.6 Update 3

Replacement Issue:
1) Now in this programme reason for replacement has been added.
2) The newly drafted person will first come from the same subdivision as that of the replaced person. If such record is not available then it will come from other subdivision but of the same forpc.
3) If same venue training is not selected then following things have to be done:
 a. Training requirement from the deployed subdivision is to be run
 i.e. then training requirement for the particular post status is to be run from deploying subdivision (forsubdivision).
 b. Then training allocation is to be done
     From district category user if you are deploying subdivision of pp as the basis of venue selection. If subdivision of pp has not been considered for training allocation earlier then you can do it from subdivision user (forsubdivision).

In this case you should neither run token no creation nor district wise token creation. You have to put the token no manually into training_pp table for the particular pp(s).

It would be better to maximize selection of same venue training while replacement.

run the following sql:
ALTER TABLE  `replacement_log_pregroup` ADD  `reason` VARCHAR( 30 ) NULL AFTER  `forpc`

If there is shortage of pp for a particular subdivision & thus not available for replacement you may enter & populate such pp.
Updated to S/W Version 1.6 Update 4

Fixed subdivision code, office code or person code started with zero(0)