GPS Based M-Reporting Documentation - MR

Centaur Pharmaceuticals Pvt Ltd
Mobile number Registration process.

After starting application, first check mobile number from SIM-1 in
centaur_android.android_user_registration table. If number not found then give message “You
are not registered User”.
If number found then check active status=Y, mobile unique ID, SIM ID.
If active status=Y and mobile unique ID, SIM ID fields are blank then ask user to fill registration
form compulsory for first time along with OTP. After saving registration form, save mobile
unique ID and SIM ID in front of that mobile number.
Next time, user’s mobile number from SIM-1, mobile unique ID and SIM ID should match with
above stored values, then only he can move ahead with empcde from
centaur_android.android_user_registration table as Login-ID. Login-ID should be freezed.
Table Name Table Field Name Input Field Remark

srno auto incriment
Centaur IT will enter from
active Y/N
backend
nepal_kashmir Y/N
backend
empcde ragistered employee
backend
empnme employee name
backend
grp group
backend
grp_name group name
backend
centaur_android.androsid_user_regi hq headquarter of employee
backend
stration Centaur IT will enter from
state state of employee
backend
design designation of employee
backend
mobile_no mobile number
backend
app_device_unique_i
mobile unique ID update
d
app_sim_unique_id SIM ID update
app_registration_logi
ragistration date update
n_date
app_registration_logi
ragistration time update
n_time
otp OTP update
Every time user opens the App, one record should be inserted in below table if he is an
authentic user.

srno Auto Incremental
active "Y" Insert
centaur_android.android_user_trans
empcde Logged In User Insert
actions
app_latitude Latitude before login Insert
app_longitude Longitude before login Insert
Confidential Document
app_accuracy GPS Accuracy before login Insert

app_timestamp GPS Timestamp before login Insert
app_converted_times GPS Timestamp which is converted in
Insert
tamp DateTime before login
app_battery_level Battery Level Insert
app_signal_strength Signal Strength Insert
app_installed_app App installed on his mobile Insert
If mock location is enabled, then mock
app_mock_latitude Insert
latitude
app_mock_longitude Insert
longitude
app_mock_accuracy Insert
accuracy
app_mock_location Mock location is Active / In-Active Insert
app_transaction_date Server Date Insert
app_transaction_time Server Time Insert
Sequence No. 1
Screen Name Login
Purpose Login Authentication with users credentials
Determines Based on Login ID MR, MGR, HO is decided
Screen-shot
Input size, type, Login ID: 4 characters Alfa-numeric

validation Password: 4 characters with following controls.
Guidelines for password generation
Length of Password should be minimum & maximum 4 characters with
combination of Alphabet, Numeric and special character.
Alphabet includes capital A-Z or small a-z

Number includes 0 - 9
Special character includes only @ # $ ? & ~

Same character should not be repeated in password.
You cannot repeat previously used password.
Dependency ID and Password does not depend on anything.
But further complete structure of MR and MGR is based on ID entered by the user.
Connectivity In complete process till end ID is used.

Database.Table used Table Name Fields Access
centaurERPmasters.login_id login_id,password, Read
with read,write,view
active, EREPORTING
access
centaur_android.android_user_registration empcde, active Read
centaurERPsndStatistic.statistic_lvl empnme,hq,state, Read
desn_cde,
design,grp,yymm
centaurdata.eallowance_login empcde,date Write/Read
,time
centaurdata.farechart_doctor_relation empcde, yymm, Read
finished
PHP path/file mrepo.php

name,class,function….
Process Flow On clicking login button system first checks whether this ID is available in
centaurERPmasters.login_id table and then checks whether active is=’Y’ and
EREPORTING=’Y’ also validate the password.
Since all users will not be shifted to android application at a time, another table is
used to validate user’s registration done via Android application.
Table name: centaur_android.android_user_registration
Then it moves to centaurERPsndStatistic.statistic_lvl table to check

If abs(desn_cde) >=65 then he is MR else MGR and then display
empnme, hq, state, design, grp, user_type(MR/MGR)
For marking attendance of MR/MGR one record is put in

centaurdata.eallowance_login table once in a day.
Systems also checks whether fare chart doctor relation is saved by MR for current
month and only then proceed further. Applicable only to MR.
Fare chart doctor relation is one time activity manage by MR via separate
Portal.
Details GPS based Application is not applicable to Kashmir & Nepal Field Force (MR,MGR)
NEPAL and KASHMIR will be on web based application and rest of the India will be
on Android application.
Sequence No. 2
Screen Name Background Process one (Applicable to MR and MGR combined)
Purpose To check Report date and password expiry.
Determines Whether current report or previous locked opened report and password expiry.
Screen-shot Not applicable
Input size, type, Not applicable
validation
Dependency Not applicable

Connectivity Whether to activate GPS or not.
centaurERPmasters.login_id pass_changed_date Read
,login_id,active
access
centaurFieldFormats.allow_web_reporting empcde, login_date, Read
dfr_done, from_date
to_date
PHP path/file mobile_urgent_bulletin.php
Process Flow On successful login under screen 1 Background process starts to checks password
expiry date in centaurERPmasters.login_id table field name pass_changed_date
, which is 15 days and forces user to change the password.
Whenever sales Admin Dept. has opened previous day’s report then MR/MGR can
report without GPS as person cannot visit particular location again.
Systems checks empcde, from_date, to_date, login_date from

centaurFieldFormats.allow_web_reporting where login_date should be current date
and from_date and to_date determines how many previous day’s reports are
opened.
Details Not applicable
Sequence No. 3
Screen Name Initial menu
Purpose To bifurcate GPS and Non GPS Activities
Determines
Screen-shot
Input size, type, Click buttons are provided.

validation

Connectivity Not applicable
Database.Table used Not applicable
access
PHP path/file mgrdfr/mobile_menu.php
Process Flow On clicking GPS reporting systems checks for the latest GPS signals by using
timestamp parameters. If timestamp is older than 5 minutes of user’s timestamp and
Centaur’s server timestamp , then system does not allow him to proceed.
On clicking Other Activity, only non GPS related activities are available.
Details
Sequence No. 4
Screen Name Background Process two (Only for MR)
Purpose Systems checks following conditions and do not allow to proceeds if either of the
condition fails :
- Report already submitted.
- Leave applied.
- Tour Plan (TP) for this month is not approved.
- Requested for deviation.
- Planner not entered.
- Sample Consignments not confirmed.
- Todays TP date is locked.
Determines Controls mentioned in “purpose” above.
Screen-shot Not applicable
validation

Connectivity Whether to initiate Call entry.
centaurdata.dfrmain dfrdate,empcde, status Read
centaurdata.mobile_dfrmain dfrdate, empcde,freeze
access Read
centaurdata.tp empl_code,tpdevreq,deviated_from1, Read
deviated_to1,deviated_type1,
deviated_from2,deviated_to2,
deviated_type1,deviated_tpworktype,
tpfrom1,tpto1,tptype1,tpfrom2,
tpto2,tptype2,tpworktype,
locked,tpdate,tpstatus
centaurFieldMatrix.matrix_dr Empcde,month,year Read
centaurERPsamples1819.state_days days Read
centaurdata.promotdata pm_no, empcde, lrdate Read
PHP path/file Mobile_mr_main_class.php
Process Flow Report already submitted: if current date record is found in centaurdata.dfrmain field
name dfrdate table which means report is entered.
Leave applied : if status field in table centaurdata.dfrmain is having “LEAVE” then MR

has applied leave for that particular day.
Tp for this month is not approved : if tpstatus field of centaurdata.tp table is “1” then
MR’S TP is not approved.
Requested for deviation :if tpdevreq field of centaurdata.tp table is >0 and
deviated_tpworktype!=’’ then MR has entered deviation which is not approved by his
Manager.
Planner not entered : if record not found in centaurFieldMatrix.matrix_dr table that

means planner of current month is not entered by MR.
Sample Consignments not confirmed : If consignment found in

centaurdata.promotdata table in the name of concern MR with status field =”0”
Then consignment’s lrdate field from centaurdata.promotdata table and add grace
period days from field days from centaurERPsamples1819.state_days table and checks
with current date. If it exceeds then consignment is due for confirmation.
Today’s TP date is locked : if locked field =”Y” in centaurdata.tp table. Which means
TP for DFR date is locked and MR cannot report for that date.
Details
Sequence No. 5
Screen Name Main Menu
Purpose To select desired activity.
Determines Main Menu
Screen-shot

validation
Dependency
Connectivity
centaurERPsndStatistic.statistic_lvl empcde,empnme,hq,state, Read
desn_cde,design,grp
access centaurdata.mobile_no mobile_no Read
centaurdata.tp empl_code,tpdevreq,deviated_from1, Read
deviated_to1,deviated_type1,
deviated_from2,deviated_to2,
deviated_type1,deviated_tpworktype,
tpfrom1,tpto1,tptype1,tpfrom2,
tpto2,tptype2,tpworktype,
tpdate,tpstatus,tpdevreq
centaurdata.tpmgr empl_code, tpdate, tpmanager1, Read
tpmanager2
PHP path/file mobile_mr_menu.php
Process Flow Employee’s code, name, designation, HQ, Division shown at the top of the screen
are taken from centaurERPsndStatistic.statistic_lvl table fields are empcde, empnme,
hq, state, design, grp
DFR Date : Please refer sequence 2, process flow para 2 and 3.
Status (W O R K I N G) : is taken from centaurdata.tp table fields tpworktype or

deviated_tpworktype where tpdate is equal to above DFR date. Status from
deviated_tpworktype is considered only when tpdevreq=2 that is approved
deviation.
Mobile : mobile_no field from centaurdata.mobile_no table
From – To Place: is taken from centaurdata.tp table fields tpfrom1 & tpto1/
deviated_from1 & deviated_to1 where tpdate is equal to above DFR date.
Places (from-to) from deviated_from1 & deviated_to1 is considered only when

tpdevreq=2 that is approved deviation.
From – To Place (interior) : is taken from centaurdata.tp table fields tpfrom2 & tpto2/
deviated_from2 & deviated_to2 where tpdate is equal to above DFR date.
Places (from-to) from deviated_from2 & deviated_to2s is considered only when
tpdevreq=2 that is approved deviation.
JT Work 1 and 2: empl_code field from centaurdata.tpmgr table is checked for

whether logged in MR is found in tpmanager1 or tpmanager2 fields and for DFR
date. If Manager has selected logged in MR as joint work then it will be displayed
Above all information is only display. After that user will choose option from given
dropdown.
Only message is displayed as

"Submit & Freeze" Button will be displayed only after entry of 5 chemist. Please Freeze
DFR before 12:00 (midnight).
Details
Sequence No. 6
Screen Name Call Entry
Purpose Daily Field Report (DFR)
Determines Daily Doctor’s Calls Entry
Screen-shot Image 1 Image 2
Input size, type, Doctor selection is drop down list.

validation Doctor code is 10 character Alfa-numeric e.g. MUMGP00001.
Doctor Name is 51 character (name -25 , initial – 1 , lastname - 25)
Doctor Speciality 20 character.
Doctor Tagged 15 character display after checking latitude , longitude from
centaurERPcrm.doctors_address table. If not empty then “-[ Geotagged ]” is displayed.
Osnly last 5 character are displayed in drop don list.
Dependency GPS needs to be active.

Connectivity With next screen of report entry.
Database.Table used Fields Access
centaurdata.mobile_dfrdrs drcode, empcde,dfrdate, Read/
latitude, Write
access longitude,device_type
centaurdata.mobile_dfrchemist Chemist, stkcde Read/
Write
centaurERPcrm.doctors_address drcode,empcde,latitude, Read
longitude,multiple_clinic,
hospital_doctor, uid,
second_clinic_lat,
second_clinic_lng
centaurdata.drchart drname,drcode,speciality, Read
empcde
centaurFieldMatrix.matrix_br p_cde Read
centaurdata.farechart_doctor_relation Drcode,basetown, Read
desttown,yymm
centaurERPcrm.rectify_latitude_longitude Drcode,login_date,empcde Read
PHP path/file mobile_mr_call_selection.php
name,class,function mobile_mr_dr_selection.php
…. mobile_mr_dfr.php
mgrdfr/geotaging_validation_class.php
mgrdfr/circle_class.php
Process Flow On selecting call entry from dropdown and then clicking on doctor button doctors list
related to MR who has logged in is displayed based on fare chart doctor relation.
centaurdata.drchart and centaurdata.farechart_doctor_relation.
System checks, once doctor call is saved successfully then again same doctor will not be
displayed in drop down list as shown in Image 1.
If doctors latitude, longitude are rectified for correct geo position then system does not
display those doctors in drop down list, because we expect MR to visit same location 3
times and also rectify 3 times which we call it as three iteration after which IT HELP DESK
Confirms doctors new geo position.
On saving doctor call number of calls count is displayed below doctor button.
count taken from centaurdata.mobile_dfrdrs. Field drcode
GPS Functionality :
As we are having multiple divisions and MR from each division visit same doctor at different places that means
there is overlap in Doctors.
Systems keeps on attempting for almost 60 seconds to get accurate GPS signal and accuracy of signal which
should be less than 25 otherwise system display message that he is not within the desired accuracy.
If timestamp that is last GPS signal fetched by users handset is greater than 5 minutes older, then system diverts user
to JavaScript google map from licensed google maps API. We also show overlay transparent circle indicating 100
meters radius for clinic and 220 meters radius in case of hospital. We also show red colour pointer indicating user’s
current position.
On successful signal of GPS, system try to match User’s lat-lon as follows :
System checks logged in MR’s code in empcde field from centaurERPcrm.doctors_address table and read
latitude, longitude field in front of MR code. In case of multiple_clinic=’Y’, system checks lat-lon in front of MR code
first and then it checks for rest of the divisions assuming Doctor is having multiple clinics.
Then system checks for second clinic if available in front of logged in MR’s code.
Ultimately, system tries to find out user’s nearest matching location as per conditions given below.
Example of multiple_clinic=’Y’ : If logged in MR is ‘SQ82’ then, all lat-lon will be matched. If logged in MR is ‘AE06’
then, all lat-lon and only his second clinic will be matched. If logged in MR is ‘SI07’ then, only lat-lon in front of MR
code will be matched and since this is hospital doctor he will get 220 meters radius for reporting.
Example of multiple_clinic=’N’ and second clinic that is second_clinc_lat and second_clinic_lng are not empty : If
logged in MR is ‘B239’ then, only lat-lon will be matched and if logged in MR is ‘P908’ then, lat-lon and second
clinic lat-lon will be matched.
If user’s current location is not matched with any of the above combination then system will give the message as
shown in Image 2.
Details
Sequence No. 6 Continue…..

Purpose Daily Field Report (DFR)
Determines Daily Doctor’s Calls Entry
Screen-shot
Input size, type, validation Work Type is drop down list. Values are hardcoded.
Rx Type is a drop down list. Values are hardcoded.
Rx Brand is drop down list of character 60.
Rx Units is a numeric Text box of size 5.
Brands Detailed /Promoted is drop down list of character 5.
Samples / Inputs Given is consist of product name (60 characters) from
centaurERPmasters.prod_mst for Samples and from centaurERPmasters.prom_mst
for promotional material plus total units in hand (int 20) calculated from
centaurdata.samples_stock for each product.
Qty : Text Box (Int 20)
SAVE Button.
Dependency Rx Brand combo depends on Rx Type.
Save button will only appear after selection of Doctor,
Rx Type and Work Type.s
Connectivity
Database.Table used with Fields Access
centaurdata.mobile_hqprd mktg_p_cde, grp, hq Read
read,write,view access centaurERPmasters.prod_mst p_name,p_shrt, p_cde Read
centaurFieldMatrix.matrix_br p_cde, Read
empcde,month,year,drcod
e, opportunity, app_rej
centaurERPcrm.doctors_brands Product_Code, drcode, Read
Units_Per_Month
centaurdata.samples_stock Empcde,p_cde, units, Read/Write
yymm
centaurERPmasters.prom_mst show_in_ereporting, Read
ls_cde, closed
centaurdata.mobile_dfrmain empcde,dfrdate, Read/ Write
storedate,ww1,
ww2,from1,from2,to1,to2,
type1,type2,status,
from_mobile
centaurdata.mobile_dfrdrs empcde,dfrdate, Read/ Write
drcode,me,yn,
ww_mgr,dfrtime,
device_type,
device_details,
storedate,
sankalp_activity,
latitude,longitude,
dr_adr_correct,
dr_adr_remark,
meter_diff_matched_with,
accuracy,
altitude,
altitudeaccuracy,
heading,speed,
timestamp,
timestamp_datetime
centaurERPcrm.doctors_address lat_lon_confirmed, Write
drcode, uid
centaurdata.mobile_dfrbrands empcde,dfrdate, Read/ Write
drcode,p_cde,
sampled,storedate
centaurdata.mobile_detailing_pr empcde, Read/ Write
oducts dfrdate,p_cde,
p_name,
drcode,dr_type,
m5_rx_qty,hq,
state
PHP path/file mobile_mr_dfr.php
name,class,function…. mobile_mr_combo_class.php
mobile_mr_savedfr.php
mobile_save_class.php
Process Flow Work Type : Values are Independent or Joint. Mr can work in field independently
or jointly with Manager. If joint working is selected by MR then managers displayed
above in joint work will be shown to MR to select. He can either select one or two
at a time that means he can work with two senior managers.
Refer process from sequence no. 5.
RX Type :
Values are as follows : Based on this Rx brand combo will be displayed.
1. Existing Rxer – Doctor who is already prescribing Centaur brand derived from
centaurdata.mobile_hqprd (key : hq,grp) and centaurFieldMatrix.matrix_br
(key : empcde,month,year,drcode,ooprtunity,app_rej).
We disable opportunity brands from RX Brand combo
from centaurFieldMatrix.matrix_br for ooprtunity=’Y’ and app_rej!=’A’
2. Converted – MR mentions in his monthly doctor brand planner that he

is having opportunity to convert this Doctor for prescribing Centaur brand
derived from centaurdata.mobile_hqprd (key : hq,grp)
and centaurFieldMatrix.matrix_br
(key : empcde,month,year,drcode,ooprtunity,app_rej)
3. Non Rxers – System does not allow to select and enter RX brand and RX units.
4. Defection – Doctor who stops prescribing Centaur brand derived from

centaurdata.mobile_hqprd (key : hq,grp) and centaurERPcrm.doctors_brands
(key : drcodes).
We enable only those brands whose Units_Per_Month value derived from
centaurERPcrm.doctors_brands (key : drcode) table is more than zero.
RX Brand and Units : Rx brand drop down is derived from centaurdata.mobile_hqprd

having Hq wise product list. (Key Hq,Grp) and from
centaurFieldMatrix.matrix_br (key : empcde,month,year,drcode,ooprtunity,app_rej).
Selection of Rx Brand and entry of Rx Units depends on selection of Rx Type.
Brands Detailed /Promoted : This drop down is derived from centaurdata.mobile_hqprd

having Hq wise product list. (Key Hq,Grp)
Product short name is taken from centaurERPmasters.prod_mst (key p_cde).
At leasts one brand is compulsory.
Samples / Inputs Given and Qty. : First 3 drop down lists are of samples
with closing stock of logged in MR.
Product name is taken from centaurERPmasters.prod_mst (key : p_cde)
And closing stock is derived from centaurdata.samples_stock
(key : yymm,empcde,p_cde,units).
Logged in MR cannot enter Quantity more than closing stock.
Last 2 drop down lists are of promotional inputs with closing stock of logged in MR.
Promotional Input name is taken from centaurERPmasters.prom_mst (key : ls_cde)
And closing stock is derived from centaurdata.samples_stock
(key : yymm,empcde,p_cde,units). Only those promotional inputs are shown
for whom show_in_ereporting flag is ’Y’ in centaurERPmasters.prom_mst (key : ls_cde)s
SAVE Button :
While saving, system again checks GPS signal. If GPS signal not found
then user will not be able to save the report.
Validations before saving are as follows :

 If Work Type is selected as ‘Joint Work’ then user must select
Manager with whom he is doing joint call.
 User must select Doctor Type
 Rx Brand & units depends on selection of Doctor Type.
Rx Brand is compulsory for Existing Rxer, Converted & Defection Doctor.
And Rx Units are compulsory for doctor type Existing Rxer, Converted.
 At least one Brands Detailed / Promoted is compulsory.
 If Sample / Promotional input is selected then, user must enter units given
and given units must be less than or equal to stock in hand.
Tables along with field names which are used for saving data are given below
Doctor's Entry
Table Field
Table Name Input Field Remark
Name
empcde Login ID Insert
dfrdate DFR Date Insert
storedate Server Date Insert
ww1 Joint Work with MGR 1 Insert
ww2 Joint Work with MGR 2 Insert
from1 From Place Insert

from2 To Place Insert
centaurdata.mobile_dfrmain to1 Interior From Place Insert
to2 Interior To Place Insert
type1 Type (Ex,OS) Insert
type2 Interior Type (Ex,OS) Insert
status Status (Working, Meeting) Insert
from_mobile Save value as "Y" Insert

drcode Doctor Code Insert
If user is saving Doctor Call
Insert
me befor 1 pm then
value is "M" other wise "E" Insert
Work Type (Independent=Y,

yn Insert
Joint=N)
Joint Work with. If more

Insert
than one manager
ww_mgr
centaurdata.mobile_dfrdrs
is selsected then store
values by separating with Insert
comma.
Server Time while saving

dfrtime Insert
entry.
device_type Insert
device_detai
Insert
ls
sankalp_acti
Insert
vity
latitude User's current Latitude Insert
longitude User's current Longitude Insert
dr_adr_corre
Insert
ct
dr_adr_rema
Insert
rk
Meter difference between Insert
meter_diff_ current location Insert
matched_wit
h and Docotrs address found Insert
in database Insert
Accuracy GPS Accuracy Insert
altitude GPS Altitude Insert
altitudeaccur
GPS Altitudeaccuracy Insert
acy
heading GPS Heading Insert
speed GPS Speed Insert
timestamp GPS Timestamp Insert
timestamp_ Convert GPS timestamp Insert

datetime into Date-Time format Insert
If Current lat-lon matched

with main clinic then
Update value as "Y" for key
Drcode
lat_lon_confi
centaurERPcrm.doctors_address Update
rmed
If Current lat-lon matched
with other than main clinic
then Update value as "Y"
using key Uid
Samples /Inputs Given

Table Field
Name
Current Year+Month (e.g.
Yymm
201902) Insert
Empcde Login Id Insert
Sample Code /
p_cde
Promotional Input Insert
p_shrt Product Short Name Insert
Latest Transaction No.
centaurdata.s which is unique and taken
amples_stock trn_no from
centaurdata.samples_stoc
k file Insert
stock_type Update value as "IS" Insert
Type Update value as "ToDrs" Insert
drcode Doctor Code Insert
Units Units mentioned by MR Insert
If Sample, then take

cost_rate from
centaurERPmasters.prod_
mst Insert
Cost and if promotional input Insert
then take ls_cost Insert
from
centaurERPmasters.prom_
mst Insert
Value Units*cost Insert
login_id Login ID Insert
login_date Server Date Insert
login_time Server Time Insert
pass_used Login Password Insert

centaurdata. drcode Doctor Code Insert
mobile_dfrbr
ands p_cde Sample/Promotional Unit Insert
sampled Units mentioned by MR Insert
Rx Information
Table Field
Name
empcde Login ID Insert/update
dfrdate DFR Date Insert/update
centaurdata.
mobile_dfrbr drcode Doctor Code
Insert/update
ands
p_cde Rx Brand Insert/update
rx Rx Units Insert/update

p_cde Rx Brand Insert/update
p_name Brands Name
Insert/update
drcode Doctor Code
centaurdata. Insert/update
mobile_detail
ing_products
Doctor Type (e.g. Existing /
dr_type
Converted etc.)
Insert/update
m5_rx_qty Rx Units Insert/update
hq MR's HQ Insert/update
state MR's State Insert/update
Brands Detailed / Promoted

Table Field
Name
drcode Doctor Code
centaurdata. Insert/update
mobile_dfrbr
ands p_cde Brands Detailed / Promoted
Insert/update
detailed Save value as "Y"

Insert/update
Details
After saving Doctor call, system checks meter difference in Km and
time difference between previous doctor call entry
and current doctor call. If KM travelled per hour is more than 35 then
Centaur IT will receive below automail.
On clicking Google Map, previous doctor’s location

and current doctor’s location appears with road map.
Sequence No. 7
Purpose Chemist
Determines Daily Chemist Visit details
Screen-shot
Input size, type, Chemist Name : Text Box (CHAR 255)

validation POB : Text box (INT 11)
RCPA : Drop down list with Doctor Name (60 CHAR) + Doctor Code (10 CHAR)
Competitor Brand : Text Box (Long Text)
Competitor Units : Text Box (INT 4)
New Product Availability : Drop down of product names (CHAR 60)
Dependency
Connectivity
centaurdata.mobile_dfrdrs Drcode, empcde, dfrdate Read
centaurdata.farechart_doctor_relation Drcode, empcde, yymm, Read
access basetown, desttown,drname
centaurdata.drchart Drname, speciality, drcode Read
centaurERPmasters.prod_mst p_cde,p_name,dt_launching,gr Read
oups
centaurdasta.mobile_dfrchemist empcde,dfrdate,chemist,pob,n Read /
ewbrand,rcpa_drcode, Write
rcpa,rcpa_units,
dfrtime,device_type,storedate
PHP path/file mobile_mr_chemist.php
name,class,function mobile_mr_savechemist.php
…. mobile_save_class.php
Process Flow Chemist Name & POB : MR will enter chemist name to whom he has visited. POB (i.e.
Purchase Order Booking) are the units.
RCPA (Retailer Chemist Prescription Audit): This drop down will contain Doctor’s name &
code. If Doctor’s details are already saved by MR then those saved doctors will appear
which are derived from centaurdata.mobile_dfrdrs (key : empcde, dfrdate) and
centaurdata.drchart (key : Drcode,empcde) otherwise from
centaurdata.farechart_doctor_relation (key : empcde, yymm, basetown, desttown) and

centaurdata.drchart (key : Drcode,empcde)
Competitor Brand & Units : Information of competitor brands for Centaur Brands and their
units.
New Product Availability : This drop down is of Centaur’s Newly launched brands derived
from centaurERPmasters.prod_mst (key : groups ) where difference of current date &
launching date of product is less than or equal 180 days.
SAVE Button : Will appear only after entry of Chemist Name , Competitor Brand & units and
Selection of RCPA Doctor.
Following entry is compulsory before saving chemist entry :

 Chemist name
 RCPA Doctor
 Competitor Brand
 Competitor Units
Tables along with field names which are used for saving data are given below
Chemist Details
empcde Login Id Insert

chemist Chemist Name
Insert
pob POB Insert
New product
newbrand
Availability
Insert
centaurdasta. rcpa_drcode RCPA Doctor
mobile_dfrch Insert
emist rcpa Competitor Brand
Insert
rcpa_units Competitor Units
Insert
dfrtime Server Time
Insert
device_type Save Value as "M"

Insert
storedate Server Date
Insert
Details
Sequence No. 8
Purpose Stockist
Determines Stockists Visited
Screen-shot
Input size, type, Stockist : Drop down list of Stockist Name (40 CHAR) + Stockist Code (4 CHAR)
validation
Dependency
Connectivity
centaurERPsndStatistic.statistic_dmr distcde,empcde Read
centaurFieldFormats.sss_closed Distcde,grp Read
access centaurERPmasters.dist_mst Distnme, distcde Read
centaurdata.mobile_dfrchemist empcde,dfrdate,stkcde,stockist,df Read /
rtime,device_type,storedate Write
PHP path/file mobile_mr_stockist.php

name,class,function mobile_mr_savestockist.php
…. mobile_save_class.php
Process Flow Stockist : Stockist details are derived from centaurERPsndStatistic.statistic_dmr (key :
empcde), centaurFieldFormats.sss_closed (key : distcde,grp), centaurERPmasters.dist_mst
(key : distcde)
Only after selection of Stockist SAVE button will appear.
Stockist Details
empcde Login Id Insert

centaurdata.
mobile_dfrc stkcde Stockist Code
Insert
hemist
stockist Save Value as "1"
Insert
dfrtime Server Time

Insert
device_type Save Value as "M"

Insert
Insert
Details
Sequence No. 9
Purpose To Freeze DFR Entry
Determines
Screen-shot
Input size, type, Remark : Text box CHAR 230

validation Submit & Freeze Button
Dependency
Connectivity
centaurdata.mobile_dfrmain freeze,remark,empcde,dfrdate Read /
Write
access centaurdata.dfrmain empcde,dfrdate,storedate, Read /
ww1,ww2,from1,from2, Write
to1,to2,town,city,days,planday,
uerycombo,STATUS,empgroup,
remark,type1,type2,COMMENT,
commentby,commentdt,
commentstatus,mgrlearning,
secsales,competitive_info,
dfrkm1,dfrkm2,taken_for_CGA ,
remark1,remark2,remark3,
remark25,from_mobile,freeze,
conv_automail,m5brand_automail,
freeze_by_system
centaurdata.dfrdrs empcde,dfrdate,drcode, Read /
me,yn,ww_mgr,cmd, Write
cmd_brand,
cmd_rx,cmd_remarks,dfrtime,
week_day,plan_no,
plan_day,dr_activity,
device_type,device_details,
storedate,sankalp_activity,
jw_assigned,jw_date,
jw_time,latitude,
longitude,altitude,
altitudeaccuracy,
heading,speed,accuracy,
TIMESTAMP,
timestamp_datetime,
meter_diff_matched_with,
dr_adr_correct,dr_adr_remark,
dr_remark
centaurdata.dfrchemist empcde,dfrdate, Read /
stkcde,stockist, Write
chemist,me,pob,
newbrand,rcpa_drcode,
rcpa,rcpa_units,
dfrtime,device_type,
storedate,
pob_includes_sint_new
centaurdata.dfrbrands empcde,dfrdate,drcode, Read /
p_cde,rx,detailed, Write
sampled,othbrand,
othqty,p2,campaign_code,
converted,conversion_remark,
rx_approved_by,rx_approved_on,
p_snp,rx_value,
primary_detailed,storedate
centaurdata.detailing_products empcde,dfrdate,p_cde, Read /
p_name,drcode,dr_type, Write
started_m5_rx,m5_rx_qty,
hq,state,m5brand_automail,
opportunity_closed,app_date,
app_rej_by,app_rej,mgr_remark,
mail_sent,conv_to_president,
conv_to_president_remark,
conv_to_president_by
centaurFieldFormats.allow_web_repor dfr_done,empcde,from_date, Write
ting to_date
centaurdata.farechart_doctor_relatio Empcde, login_date, Read/Wr

n_action only_for_today, ite
from_patch,to_patch,drcode,
login_id,login_time
centaurdata.farechart_doctor_relatio Basetown, desttown, yymm, Write
n empcde, drcode
PHP path/file mobile_save_class.php
name,class,function
….
Process Flow Submit & Freeze Button and remark text box will appear only after saving 1 docotr call and
5 chemists.
Remark is compulsory for freezing DFR entry.
After clicking on submit & freeze button all records from temporary tables will get copied to
main tables as follows :
Temporary Table Main Table

centaurdata.mobile_dfrmain centaurdata.dfrmain
centaurdata.mobile_dfrdrs centaurdata.dfrdrs
centaurdata.mobile_dfrbrands centaurdata.dfrbrands
centaurdata.mobile_dfrchemist centaurdata.dfrchemist
centaurdata.mobile_detailing_products centaurdata.detailing_products
Table Field
Name
centaurFieldFormat
Save value
s.allow_web_repor dfr_done
as "Y"
ting Update
Replace
Basetown with From
centaurdata.farech place Update
art_doctor_relation Replace
desttown with To
Place Update
Today's
from_patch
From Place
Insert
Original
to_patch
centaurdata.farech From Place
Insert
art_doctor_relation
Doctor
_action drcode
Code Insert
login_date Server Date
Insert
Server
login_time
Time Insert
Details
Sequence No. 10
Purpose To Enter Non – Working Report (e.g. Training at HO, Meeting etc.)
Determines
Screen-shot
Input size, type, Stockist : Drop down list of Stockist Name (40 CHAR) + Stockist Code (4 CHAR)
validation SAVE Button
Remark : Text box CHAR 230
Submit & Freeze Button
Dependency
Connectivity
centaurERPsndStatistic.statistic_dmr distcde,empcde Read
centaurFieldFormats.sss_closed Distcde,grp Read
access centaurERPmasters.dist_mst Distnme, distcde Read
centaurdata.mobile_dfrchemist empcde,dfrdate,stkcde,stockist Read /
,dfrtime,device_type,storedate Write
centaurdata.mobile_dfrmain empcde,dfrdate,storedate,ww1 Read /
,ww2,from1,from2,to1,to2,type1, Write
type2,status,remark,from_mobil
e
PHP path/file mobile_mr_stockist.php
name,class,function mobile_mr_savestockist.php
…. mobile_mr_freeze.php
Process Flow Non Working Report Entry :
For Non-Working reporting, only stockist button is visible. MR can save stockist which is not
compulsory.
For non-working reports Submit & Freeze button and Remark text box will appear
automatically. After clicking Submit & Freeze data will be saved in below table.
Validations : Remark is compulsory.
Non Working Report
Empcde Login ID Insert

Dfrdate DFR Date Insert
Storedate Server Date
Insert
Joint Work with
ww1
MGR 1
Insert
Joint Work with
ww2
MGR 2
Insert
from1 From Place
Insert
from2 To Place Insert
Interior From
to1
Place
Insert
centaurdata.mobile_dfrmain to2 Interior To Place
Insert
type1 Type (Ex,OS)
Insert
Interior Type
type2
(Ex,OS)
Insert
Status (Working,
status
Meeting)
Insert
Remark entered
remark Insert
by MR
from_mobile Save value as "Y"

Insert
Freeze Save value as "Y"

Insert
Details
Sequence No. 11
Screen Name Geocoding Addresses (MR/MGR)
Purpose To tag doctors geo-position
Determines DFR entry
Screen-shot
Input size, type, Employee combo employee name(150) and right(5) char of drcode
validation Cick to save Geo-Position Button
Dependency Rectify geocoded position and update second clinic geo-position

Connectivity DFR entry
centaurERPcrm.doctors_address drcode,multiple_clinic, Read/Wr
lat_lon_confirmed,latitude,longit ite
access ude,tagged,empcde
centaurERPcrm.rectify_latitude_longitude Drcode, login_by, empcde Read/Wr
ite
centaurERPcrm.request_for_second_clini Drcode,empcde Reads
c
PHP path/file Mgrdfr/geotaging_class.php
name,class,function…. Mgrdfr/mgr_doctors_cordinates.php
Mgrdfr/Circle_class.php
Process Flow Lat long mapped are not correct and rectify: if wrong tagging found by MR/MGR then he
can three time tag this dr by selecting Lat long mapped are not correct and rectify option.
This option is available in drop down till three iteration done by MR/MGR. IF doctors Geo-
position confirmed by MR/MGR then this option is not visible.
Same MR is visiting Doctor at two places. Tag this place. : If MR visiting to doctor at his
second clinic then Mr/MGR requested our GPS HELP-DESK help desk investigate the clinic
photo and doctor name on WhatsApp and push one entry in
centaurERPcrm.request_for_second_clinic table if employee code and today’s date
available in centaurERPcrm.request_for_second_clinic table then Same MR is visiting Doctor
at two places. Tag this place option is available for MR/MGR for tagging second clinic.
MAP: geocoded area of the doctor 100 meters for clinic and 220 for hospital is shown in
form of circle and MR/MGR’S current position shown in form of Red Pointer.s
Click to save Geo-Position: if main clinic latitude , longitude not found in

centaurERPcrm.doctors_address table then system allow to tag doctor’s Geo-position.

drcode selected doctor Read
multiple_clinic enum (Y/N) Read
lat_lon_confirmed enum (Y/N) Read
Geo-position
latitude
Latitude Read/Update
Geo-position
longitude
Longitude Read/Update
"reporting /
tagged
Rectify" Update
centaurERPcrm.
empcde logged in ID Read
doctors_address
second_clinic_add
cureent address
ress Update
second_clinic_lat current latitude Read/Update
second_clinic_lng current longitude Read/Update
Diff.between
Current geo
meter_diff position and Update
tagged
latitude,longitude.

empcde logged in ID Insert
centaurERPcr
Selected Doctor
m.rectify_latit drcode
code Insert
ude_longitude
login_by Logged in ID Insert

centaurERPcr selected
drcode
m.request_for doctor Read
_second_clinic empcde logged in Id Read
Details
Sequence No. 12
Screen Name New DR Addition with Geocoding (Only for MR)
Purpose To take geo-position of doctor
Determines Latitude,longitude of Doctor’s Clinic/Hospital
Screen-shot
Input size, type, Employee combo employee name , employee code

validation Display current GPS address
Title : char (10)
Name : char (25)
Initial : char (1)
Lastname : char (25)
Gender : char (10)
Qualification : char (50)
Qualification from : char (30)
Practicing as : char(30)
Speciality : combo char(20)
mbbs(Y/N) : enum (Y/N)
mbbs (C/D) : char (6)
Religion : combo char(20)
Date of Birth : day char(2), month char(2), year char(4)
Marriage Anni Dt : day char(2), month char(2), char(4)
E-mail-ID : char(40)
P1 : int(5)
visiting card : Button to select file from mobile gallery or to take picture.s
Click to save DIF & Geo-Position is button.s
Dependency
Connectivity Daily field work.
centaurERPcrm.speciality_master Speciality, spcl_shrt Read
access
centaurERPcrm.dif_entry empcde, Read/Wr

srno,drcode,title,name,initial,last ite
name,gender,qualification,qual
ified_from,practicing_as,speciali
ty,speciality_code,hq_code,mb
bs,mbbs_cd,religion,bday,
bmth,byear,aday,amth,ayear,e
mail,p1,visiting_card,google_ad
dress,latitude,longitude,accura
cy,timestamp_det,timestamp_d
ate,login_id,login_date,login_ti
me
centaurERPsndStatistic.statistic_lvl Hq,yymm,empcde Read
centaurERPmasters.statistic_runctl Yyyy, yymm Read
centaurERPsndStatistic.statistic_hq_mst hq_shrt, hq, yyyy Read
PHP path/file add_doctors_cordinates.php

name,class,function add_save_geolocation.php
geotaging_class.php
….
Process Flow Entry screen provided to MR to collect information about new doctor and tag doctors Geo
position.
Details are saved in centaurERPcrm.dif_entry table.
Photo of the visiting card is stored in
/home/vftp/cnterp2.com/webftp/crm_gif/doctor_visiting_cards/ directory only.
Doctor code: System replace doctor code with srno
Data is stored in following table.

Table Field
Name
Auto
srno incrimental value
Incremental
empcde logged in empcde Insert
drcode to be replace with srno Insert
title entered by user Insert
name entered by user Insert
initial entered by user Insert
lastname entered by user Insert
gender entered by user Insert
centaurEsRPcr qualification entered by user Insert
m.dif_entry qualified_from entered by user Insert
practicing_as entered by user Insert
speciality entered by user Insert
speciality_code speciality short name Insert
left three digits if
hq_code
headquarter of MR Insert
mbbs entered by user Insert
mbbs_cd entered by user Insert
religion entered by user Insert
bday entered by user Insert
bmth entered by user Insert

byear entered by user Insert
aday entered by user Insert
amth entered by user Insert
ayear entered by user Insert
email entered by user Insert
p1 entered by user Insert
uploaded visiting card
visiting_card
file name. Insert
google address of
google_address
doctors position Insert
Doctor clinic/hospital
latitude
GPS latitude Insert
longitude
GPS longitude Insert
accuracy
GPS accuracy Insert
timestamp_det
GPS timestamp Insert
timestamp_dat convert timestamp into
e date and time Insert
login_id logged in empcde Insert
login_date system date Insert
login_time system time Insert
Details
Sequence No. 13
Screen Name Transfer DR.
Purpose To transfer doctor from any other patch to today’s patch
Determines
Screen-shot
Input size, type, From Patch is a drop down list consist of from place char(30) & to place char (30),
validation Doctor drop down list is of 150 character and right 5 digits of doctor code.
To patch is a drop down list consist of from place char(30) & to place char (30),
“Is this transfer only for today?” is a check box.
Transfer button
Dependency Doctor drop down list is depend on from patch selection.
Connectivity This Transferred Doctor is visible in Doctor drop down list of Call Entry.
centaurdata.farechart_doctor_relation basetown,desttown,yymm,emp Read/Wr
cde,drcode,drname,login_id, ite
access login_date,login_times
centaurdata.drchart Empcde,drcode, Read
centaurdata.farechart_doctor_relation_ empcde,from_patch,to_patch, Write
action drcode,only_for_today,login_id,l
ogin_date,login_time
PHP path/file Mobile_mr_transfer_dr.php
name,class,function Mobile_mr_savetransferdr.php
Mobile_save_class.php
….
Process Flow From Patch : Derived from centaurdata.farechart_doctor_relation (Key :yymm,empcde) of
logged in MR.
Doctor : Derived from centaurdata.farechart_doctor_relation(key :

yymm,basettown,desttown,empcde) and centaurdata.drchart (key : drcode,empcde).
This dropdown list changes as per the selection of from patch.
To Patch : Today’s patch as per Tour plan. For details please refer sequence no 5 (Process
flow  From – To Place).
Is this transfer only for today ? : On click of this transfer will be reversed back to the
original patch after submission of DFR.
After selection of from patch & Doctor , Transfer Button will appear.
Validations before saving this entry.

 From patch, Doctor and to patch is compulsory.
After clicking Transfer Button data will be saved in below tables.
Table Field
Name
Replace with
basetown
Today's From place
centaurdata.fare
chart_doctor_rel Update
ation
Replace with
desttown
Today's To place
Update
from_patch Today's From Place

Insert
to_patch Original From Place

Insert
drcode Doctor Code
centaurdata.fare Insert
chart_doctor_rel
ation_action Save as "Y" is user
only_for_today clicks the question
asked.
Insert
login_date Server Date
Insert
login_time Server Time
Insert
Details Every MR defines his patch through fare chart – doctor relation. In each patch there can be
more than one doctors attached.
In tour plan, MR selects this patch as from – to place (where he will visit) for
every day.
While doing call entry, doctor’s drop down list is derived from this patch
which is mentioned in tour plan against DFR date.
But if MR wants to meet another Doctor who is not in today’s patch, he can
transfer that doctor to today’s patch through this entry.
He can permanently or temporarily shift that doctor to today’s patch by

answering the question “Is this transfer only for today ? “.
If he clicks this question then after final freeze of DFR, again that doctor will
get transfer to original patch otherwise will remain in today’s patch.
Sequence No. 14
Screen Name MR Tour plan
Purpose Daily field work plan
Determines
Screen-shot
Input size, type, Date date format (DD/MM/YYYY)

validation Status combo varchar 100
Place from combo basetown 30 char and desttown 30 char and type 4 char
Place to combo basetown 30 char and desttown 30 char and type 4 char
Aimed for Conversion text box integer 2
Prev button
Next button
Save button
Send For Approval button
Dependency MR field work plan

Connectivity MR daily field work
centaurERPmasters.statistic_runctl yymm,yyyy Read
centaurERPsndStatistic.statistic_emp_mst dt_joining,empcde Read
access
centaurdata.tp empl_code,tpdate,tpfrom1, Read/Wr
tpto1,tptype1,tpfrom2,tpto2, ite
tptype2,tpkm1,tpkm2,tpmanag
er1,tpmanager2,business1,busin
ess2,tpstatus,tpworktype,tpappr
ovedby,tpstoredate,tpapprove
ddate,tpdevreq,tpdevreqdate,
tpdevres,tpdevapvdate,tpdeva
pvres,tpdevapvemp,locked,
locked_open_by,aimedconv,
deviated_tpworktype,deviated
_ww1,deviated_ww2,deviated_
from1,deviated_to1,deviated_ty
pe1,deviated_type2,deviated_f
rom2,deviated_to2,deviated_k
m1,deviated_km2,device_type
centaurFieldFormats.open_locked_tp empcde Read
centaurERPsnd.month_close yyyy Read
centaurdata.km_for_tp $kmfld,showkm,hqworking,yym Read
m,empcde
centaurERPsndStatistic.statistic_lvl empcde,yymm Read
centaurdata.mobile_dfrmain empcde,dfrdate,storedate,STAT Read/Wr
US,remark,type1,from_mobile ite
centaurERPadmin1819.holiday Holidate, state, Read
centaurdata.farechart Empcde,basetown,desttow Read
n,dist_km,type
centaurERPleave.leave_transactions empl_cd,leave_from,leave_to,
application_type,
late_mark_entry,
encashment_entry,
application_type
centaurdata.users_status statustype
centaurERPsndStatistic.statistic_rep_mst manager,grp,yymm,empcde
centaurdata.tpmgr Empcde,tpdate,tpmanageer1,t
pmanager2, tpstatus, tpdevreq,
deviated_ww1, deviated_ww2
PHP path/file mobile_mr_tp.php
name,class,function mobile_mr_tp_details.php
….
Process Flow Status : Derived from centaurdata.users_status
Place From – To : Derived from centaurdata.farechart table.

Type : Type is fixed in centaurdata.farechart table. On basis of type expenses is generated
KM travelled are calculated by following way.

Table showing Option (Type) and Fare calculation
H.Q --> Nil
EX. --> Two way
OS --> One way from H.Q.
OSI (O.S.Interior) --> One way+Interior two way
OSH (O.S.halt) --> Nil
OOR (O.S.O.S.return) --> One way O.S Interior+ One way to H.Q.
OE (OS interior) --> Two way
OIR (OS interior retrun) --> Two way + one way
OR (OS return) --> One way
TM (transit mumbai) --> One way (Manual entry)
MT1 (meeting) --> One way (Manual entry)
MT2 (meeting) --> Two way (Manual entry)
TN (training) --> Nil
BD (business discussion HO)--> Nil
DP (development progr) --> Nil

CF ( conference) --> Nil
For every MR, monthwise kms are fixed in centaurdata.km_for_tp
System should not allow MR to enter tour plan beyond these KMs.
60 KM grace provided to MR if his KM allowed is less than 2400.

e.g if KM Allowed is 1000 then MR having grace 60 KM which means KM allowed = 1060.
e.g. if KM allowed is 2401 which means KM allowed = 2401.
(same formula applied to TP deviation also)
SUNDAY, HOLIDAY and LEAVE dates should freeze while updating a Tour plan.
If tour plan not entered before 25 of every month for the next month system marked MR’S 1
to 12 Days as HQ-HQ and system freeze first 12 days.
For SUNDAY, HOLIDAY and LEAVE system pushed one entry into
centaurdata.mobile_dfrmain table.
After successfully Tour Plan entry MR can press “Send for Approval” which will send automail
to his manager to approve his Tour plan.
yyyy year
centaurERPmasters.statistic_ru Read
nctl yymm month Read
chr_month month in character Read
Following table used to get date of joining of employee

Table Field
Name
empcde Login ID
centaurERPsndStatistic.statistic_em Read
p_mst Login Employee
empnme
Name Read
dt_joining Date of Joining Read
Following table used to checked TP locked open by Admin Dept.
Table Field
Name
empcde Login ID Read
yymm year/month Read
centaurFieldForma
remark Remark Entered by admin dept Read
ts.open_locked_tp
from_date tp locked open from date Read
to_date tp locked open to date Read
Following table used to calculate monthwise fixed KM for Tour Plan

yyyy Year Read
centaurdata.km_
empcde logged in ID Read
for_tp
km_04 KM for April Read
km_05 KM for May Read

km_06 KM for Jun Read
km_07 KM for Jul Read
km_08 KM for Aug Read
km_09 KM for Sep Read
km_10 KM for Oct Read
km_11 KM for Nov Read
km_12 KM for Dec Read
km_01 KM for Jan Read
km_02 KM for Feb Read
km_03 KM for Mar Read
Holiday Master
team logged in MR HQ Read
state logged in MR state Read
centaurERPadmin1819 grp logged in MR grp Read
.holiday Holiday (Diwali,Holi,
holiday
etc….) Read
holidate Holiday Date Read
Farechart Master
empcde Logged in ID Read
basetown place from Read
desttown place to Read
dist_km KM Read
centaurdata.farechart
field work non field
fw_nfw
work area Read
Fare Type
TYPE
(HQ,EX,OS,etc….) Read
Leave dates are taken from following table
Apply,Cancel,Etc…..
application_type Read
centaurERPleave.leav
empl_cd "CH00"+Logged in ID Read
e_transactions
leave_from Leave taken from Read
leave_to Leave taken up to Read
TP Working type taken from following table

Table Remark
Table Name Field Input Field
Name
centaurdata.users status Read
_status type WORKING,MEETING, Etc…
Manager 1 and manager 2 are taken from following table.
Table Field
Name
empl_code Manager code Read
tpdate Tour Plan Date Read
tpmanager1 MR 1 selected for Tour Plan Read
centaurdata. tpmanager2 MR 2 selected for Tour Plan Read
tpmgr tpstatus Tour plan status (WORKING,MEETING,Etc..) Read
tpdevreq Deviation Requested by Manager Read
deviated_ww1 Deviated MR 1 selected for Tour Plan Read
deviated_ww2 Deviated MR 2 selected for Tour Plan Read
Table of MR Tour Plan
Table
Table Field Name Input Field Remark
Name
empl_code Login ID Delete & Insert
tpdate Tour plan Date Delete & Insert
tpfrom1 From Place 1 Delete & Insert
tpto1 To place 1 Delete & Insert
tptype1 TP type (HQ,EX…..) Delete & Insert
tpfrom2 From Place 2 Delete & Insert
tpto2 TO place 2 Delete & Insert
tptype2 TP type Delete & Insert
KM of From place 1+To Delete & Insert
tpkm1
place 1
KM of From place 2+To Delete & Insert
tpkm2
place 2
Manager 1 who have Delete & Insert
tpmanager1
selected him
centaur Manager 2 who have Delete & Insert
data.tp tpmanager2
selected him
business1 Not in use Delete & Insert
business2 Not in use Delete & Insert
Tpstatus=0 means entered Delete & Insert
byMR,Tpstatus=1
tpstatus
means approved by Delete & Insert
manager
tpworktype Working type Delete & Insert
Employee code of TP Delete & Insert
tpapprovedby
approved manager
Storedate when mr save his Delete & Insert
tpstoredate
TP
tpapproveddate Manager TP approved Date Delete & Insert
Tpdevreq=1 means MR Delete & Insert
tpdevreq
enter TP deviation,
Tpdevreq=2 means Delete & Insert

Deaviation approved by
Manager
Tpdeviation=3 means Delete & Insert
deviation rejected by
Manager.
TP deviation request Delete & Insert
tpdevreqdate
entered Date
tpdevres Reason of TP deviation Delete & Insert
TP deviation approved or Delete & Insert
tpdevapvdate
Rejected date
Reason entered by manager Delete & Insert
while
tpdevapvres
approving/Rejecting TP Delete & Insert
deviation
Employee code who have Delete & Insert
tpdevapvemp
approved TP deviation
locked TP Locked by admin Delete & Insert
TP locked open by admin Delete & Insert
locked_open_by
Dept. Employee code
aimedconv Aim for conversion Delete & Insert
deviated_tpworkty Deviated work type Delete & Insert
pe (WORKING,MEETING etc…)
deviated_ww1 Not in use Delete & Insert
deviated_ww2 Not in uses Delete & Insert
deviated_from1 Deviated from place 1 Delete & Insert
deviated_to1 Deviated to place 1 Delete & Insert
deviated_type1 Deviated type Delete & Insert
deviated_type2 Not in uses Delete & Insert
deviated_from2 Deviated from place 2 Delete & Insert
deviated_to2 Deviated to place 2 Delete & Insert
deviated_km1 Deviated KM 1 Delete & Insert
deviated_km2 Deviated KM 2s Delete & Insert
device_type Entered from mobile or PC Delete & Insert
Details
Sequence No. 15
Screen Name View Tour Plan (TP)
Purpose
Determines
Screen-shot
Input size, type, Month combo

validation
Dependency Daily field work
Connectivity DFR entry
centaurdata.tp empl_code,tpdate,tpfrom1, Read
tpto1,tptype1,tpfrom2,tpto2,
access tptype2,tpkm1,tpkm2,tpmanag
centaurdata.tpmgr empl_code, tpdate, Read
tpmanager1, tpmanager2,
tpstatus, deviated_ww1,
deviated_ww2, tpdevreq
PHP path/file mobile_mr_viewtp_month.php

name,class,function mobile_mr_viewtp.phps
….
Process Flow Last three months Tour Plan show to MR.
Details
Sequence No. 16
Screen Name TP Deviation
Purpose To Deviate tour plan
Determines
Screen-shot
Input size, type, Deviation date combo last 7 days date are visible for Deviation
validation Status combo
From-to combo of basetown char(30) and desttown char(30),KM int(4),type char(10)
Interior From To combo of basetown (30) and desttown(30),KM int(4),type char(10)
Remark : Text area.
Dependency MR field work.

Connectivity
centaurdata.tp empl_code,tpdate,tpfrom1, Read/Wr
tpto1,tptype1,tpfrom2,tpto2, ite
access tptype2,tpkm1,tpkm2,tpmanag
centaurdata.farechart Empcde, basetown,desttown, Read

fw_nfw, type
centaurdata.users_status statustype Read
centaurdata.km_for_tp $kmfld,showkm,hqworking, Read
yyyy,empcdes
centaurERPleave.leave_transactions empl_cd, leave_from, leave_to, Read
application_type
PHP path/file mobile_mr_tpdeviation.php
name,class,function
….
Process Flow System allow MR to enter 7 days TP deviations in advance including todays date.
60 KM grace provided to MR if his KM allowed is less than 2400.

e.g if KM Allowed is 1000 then MR having grace 60 KM which means KM allowed = 1060.
e.g. if KM allowed is 2401 which means KM allowed = 2401.
If already entered Report, then system not allow to put TP Deviation.

Prompt Message “DFR Already entered”;
If entered one doctor and tried to entered TP deviation, system should stop MR to enter TP
deviation.
If already entered TP deviation and his immediate manager not approve then system not
allow MR to enter again TP deviation. Prompt Message “Your Tp for this month is not
approved.Please confirm with your Manager”
if TP date is locked by admin dept then system should not allow MR to put TP deviation.
After saving record is updated in below table.

Deviated work type
deviated_tpwork (WORKING,MEETING
type etc…) Update
deviated_ww1 Not in use Update
deviated_ww2 Not in uses Update
deviated_from1 Deviated from place 1 Update
deviated_to1 Deviated to place 1 Update
centaurdata.tp deviated_type1 Deviated type Update
deviated_from2 Deviated from place 2 Update
deviated_to2 Deviated to place 2 Update
tpdevreq Update value as "1" Update
tpdevreqdate Server Date Update
deviated_km1 Deviated KM 1 Update
deviated_km2 Deviated KM 2 Update
tpdevres Deviation Reason Update
Details
Sequence No. 17
Screen Name Assign as Joint Call
Purpose To mention doctor call entry as Joint call with Manager instead of independent call.
Determines
Screen-shot
Input size, type, Doctor drop down list is of 150 character and right 5 digits of doctor code.
validation Manager Code – Designation is a check box.
“Save & Assign” as button.
Dependency Manager’s call entry Doctor selection depends on this.

Connectivity
centaurdata.mobile_dfrdrs Drcode, empcde, dfrdate,yn Read/
Write
access centaurdata.drchart Drname,drcode Read
centaurdata.tpmgr empl_code, tpdate, Read
tpmanager1, tpmanager2,
tpstatus, tpdevreq,
PHP path/file mobile_mr_assign_jointcall.php

name,class,function mobile_mr_saveasjointcall.php
…. mobile_mr_combo_class.php
Process Flow Doctor: Only those doctors are visible where by mistake MR assign as independent call. By
ticked on checked box MR can assign call as joint call.
After saving update record in below table.
Table
Table Field Name Input Field Remark
Name
centaur yn Y= Independent , N=Joint Work Update

data.m ww_mgr working with Manager Code Update
obile_df jw_assigned Update value as "Y" Update
rdrs jw_date Server Date Update
jw_time Server Time Update
Details
Sequence No. 18
Screen Name Confirm Consignment
Purpose
Determines
Screen-shot
Input size, type, Qty text box int(10)

validation Suggetion/Feedback : char(255)
Save button
Dependency MR sample, inputs stock

Connectivity
centaurERPsamples1819.orders status,cf_newmr, gdnnm, Read
pm_no
access centaurdata.samples_stock yymm,empcde,p_cde,p_shrt,trn Read/Wr
_no,stock_type,type,fromto_em ite
pcde,consignment_no,consign
ment_date,units,cost,value,logi
n_id,login_date,login_time
centaurdata.promotdata pm_no, pm_date, status, pmid, Read/Wr
p_cde, ls_cde, lrdate,qty_recd, ite
emp_qty, suggestion,
storedate, recd_date, mgrcde
centaurERPmasters.prod_mst p_name,p_shrt,cost_rate, Read
p_cde
centaurERPmasters.prom_mst ls_name,ls_shrt,ls_cost, ls_cde Reads
PHP path/file mobile_mr_confirm_consignment.php

name,class,function mobile_mr_saveconsignment.php
….
Process Flow Pending consignments of logged in user with starus=0 from centaurdata.promotdata table
are only visible.
After selecting consignment, products with despatch qty (qty_recd field from
centaurdata.promotdata) are shown.
Qty. received should be less than or equal to despatched qty.
User can enter suggestions if any in Suggestions/Feedback input box.
After clicking on SAVE button, data is stored in following table.
Update emp_qty, suggestion, storedate, recd_date, status, mgrcde fields from

centaurdata.promotdata table
Insert product wise records in centaurdata.samples_stock table.
If received qty. is less than despatched qty. then add one more record in
centaurdata.samples_stock table with empcde = ‘SUSP’ (i.e. suspense account) with
difference of qty. between despatched qty. & received qty.
Sample Consignment
pmid Auto Incremental

Read
pm_no Packing Memo Number

Read
pm_date Packing Date
Read
lrdate LR Date Read
empcde Login ID Read
empname Login Name
Read
centaurdata.promotdata
p_cde Sample Code
Read
p_name Sample Name
Read
p_pack Pack Size Read
p_unit Pack Unit Read
ls_cde Promotional Input Code

Read
ls_name Promotional Input Name

Read
qty_recd Qty Despatched

Read
emp_qty Qty Received by MR

Update
feedback Feedback entered by MR

Update
Read
recd_date Server Date
Update
STATUS Set value as "1" Update
mgrcde Login ID Update
Current
yymm
Year(YY)+Month(mm)
insert
empcde Login ID insert
dfrdate DFR Date insert
Product
p_cde (Sample/Promotional
Input) insert
Product
p_shrt (Sample/Promotional
Input) Short Name
insert
trn_no Transation Number insert
Stock Type (Issue /
stock_type
Receipt / Opening) insert
centaurdata.samples_stock
TYPE Dispatch/ C&F Transfer
insert
fromto_empcde Login ID insert
drcode Doctor Code insert
consignment_no Consignment Number
insert
consignment_date Consignment Date insert
units Qty Received insert
cost Product Cost insert
VALUE Units*Cost insert
login_id Login ID insert
login_date Server Date insert
login_time Server Time insert
pass_used Login Password insert
Details
Sequence No. 19
Screen Name Dr Info.
Purpose To view MR doctor details and activity related information.
Determines High/low potential doctors
Screen-shot
Input size, type, Doctor combo char(150)

validation
Dependency
Connectivity
centaurdata.farechart_doctor_relation empcde,yymm,drcode,baseto Read
wn,desttown
access centaurdata.drchart drcode,drname,hcname,hcad Read
dline1,hcaddline2,hcaddline3.d
r_town,dr_city,patients,state,pin,
birth_day,birth_mth,birth_year,a
nniv_day,anniv_mth,anniv_year,
product_units,value_pm
centaurdata.dfrdrs dfrdate Read
centaurdata.dfrmain ww1,ww2 Read
centaurERPsndStatistic.statistic_lvl empnme Read
centaurFieldFormats.precme_detail cme_id Read
centaurFieldFormats.precme_main cme_date Read
centaurFieldFormats.precrmact_detail activity_id, drcode Read
centaurFieldFormats.precrmact_detail pre_entered_date, Read
centaurFieldFormats.postcpr_drdetail cpr_id,drcode Read
centaurFieldFormats.precpr_main conf_fdate Read
centaurFieldMatrix.matrix_br v_pattern,p_cde,p_shrt, Read
month,year, drcode,empcde
centaurFieldFormats.guesthouse_bookin guest_house,bookdt_from,book Read

g dt_to, drcode, approval3_by,
reject_yes_no, cancel_booking
PHP path/file mobile_mr_drinfo.php

name,class,function
….
Process Flow On selecting Balance calls from dropdown and then clicking on doctor combo doctors list
related to MR who has logged in is displayed based on fare chart doctor relation.
centaurdata.drchart and centaurdata.farechart_doctor_relation.
System checks, once doctor call is saved successfully then again same doctor will not be
displayed in drop down list.
If doctors latitude, longitude are rectified for correct geo position then system does not
display those doctors in drop down list.
Before enter into doctors cabin MR should have detail information about doctors
All doctor related information shown here e.g. p1,p2,p3,CME,CPR,DR.Activitis,Last three

visits,Opportunity brands,etc…
Details
Sequence No. 20
Screen Name Balance Calls
Purpose To vive MR his todays DFR details.
Determines
Screen-shot
Input size, type,

validation
Dependency
Connectivity
centaurdata.mobile_dfrdrs Dfrtime, empcde, Read
drcode,dfrdate
access centaurdata.drchart drcode,empcde,empnme, Read
farechart_doctor_relation Yymm,basetown,desttown,emp Read
cde,drcode
centaurdata.mobile_dfrchemist chemist,dfrtime, empcde, Read
dfrdate, chemist, stkcde,dfrtime
centaurERPmasters.dist_mst Distnme, distcde Read
PHP path/file mobile_mr_balance_calls.php
name,class,function
….
Process Flow
Doctors call, chemist details and stockists details which are entered by MR for today has
been shown here.
This helps MR to identify pending calls.
Details
Sequence No. 21
Screen Name view Sample Stock
Purpose To view current stock (Sample / Promotional Inputs) in hand.
Determines
Screen-shot
Input size, type,

validation
Dependency
Connectivity Sample stock
centaurdata.samples_stock p_cde, units, value, empcde, Read
yymm
access centaurERPmasters.prod_mst p_name,p_shrt Read
centaurERPmasters.prom_mst show_in_ereporting Read
PHP path/file mobile_mr_stock.php
name,class,function
….
Process Flow Show Product wise Units in stock.
Details
Sequence No. 22
Screen Name Update Drs. Mobile no.
Purpose
Determines
Screen-shot
Input size, type, Dr : combo char(150) + drcode right char(5)

validation Mobile no of doctor : text box char(10)
Email ID of Doctor : text box char(40)
Dependency
Connectivity
centaurERPcrm.doctors_address mobile_no, drcode, Read/wri
te
access centaurERPcrm.doctors_main Email,drcode Read/Wr
ite
centaurERPcrm.doctors_action login_id,date,time,details Read/wri
te
PHP path/file mobile_mr_mob_no.php
name,class,function
….
Process Flow To update doctor mobile no and email id
Mobile No. updated in centaurERPcrm.doctors_address table

Email ID updated in centaurERPcrm.doctors_main table
Details
Sequence No. 23
Screen Name Change Password
Purpose
Determines
Screen-shot
Input size, type, User id char (4)

validation Old Password char (4)
New Password char (4)
Change password button
Dependency
Connectivity
centaurERPmasters.login_id old_password, password, Read/Wr
passdate, pastime, ite
access pass_changed_date,
login_id,active
PHP path/file Changepass.php
name,class,function
….
Process Flow After every 15th day system force to change the password.
Length of Password should be minimum & maximum 4 characters with combination of
Alphabet, Numeric and special character.
lphabet includes capital A - Z or small a – z.

Number includes 0 – 9.
Special character includes only @ # $ ? & ~
Same character should not be repeated in password.
You cannot repeat previously used password.
After saving update record in below table.
login_id User Read
Pressvious
centaurERPmasters.login_id old_password Password Update
password New Password Update

passdate Server Date Update
passtime Server Time Update
pass_changed_date Server Date Update
Details
Sequence No. 24
Screen Name Bulletin
Purpose To flash Bulletin to MR/MGR
Determines
Screen-shot
Input size, type,

validation
Dependency
Connectivity
centaurdata.mobile_bulletine from_date,to_date,grp,bulletine Read
_details
access
PHP path/file We have hardcoded. Now created a table to store a bulletin
name,class,function
….
Process Flow Group wise bulletin stored in centaurdata.mobile_bulletine table. on basis of from_date
and to_date and grp system should flash bulletin
Details

GPS Based M-Reporting Documentation - MR

Uploaded by

Copyright:

GPS Based M-Reporting Documentation - MR

Uploaded by

Document Information

Original Description:

Original Title

Copyright

Share this document

Share or Embed Document

Sharing Options

Did you find this document useful?

Is this content inappropriate?

Copyright:

GPS Based M-Reporting Documentation - MR

Uploaded by

Copyright:

Centaur Pharmaceuticals Pvt Ltd

Mobile number Registration process.

Table Name Table Field Name Input Field Remark

Table Name Table Field Name Input Field Remark

app_accuracy GPS Accuracy before login Insert

Screen Name Login

Purpose Login Authentication with users credentials

Determines Based on Login ID MR, MGR, HO is decided

Input size, type, Login ID: 4 characters Alfa-numeric

Alphabet includes capital A-Z or small a-z

Special character includes only @ # $ ? & ~

Dependency ID and Password does not depend on anything.

Connectivity In complete process till end ID is used.

PHP path/file mrepo.php

Then it moves to centaurERPsndStatistic.statistic_lvl table to check

For marking attendance of MR/MGR one record is put in

Dependency Not applicable

Systems checks empcde, from_date, to_date, login_date from

Input size, type, Click buttons are provided.

Dependency Not applicable

Dependency Not applicable

Leave applied : if status field in table centaurdata.dfrmain is having “LEAVE” then MR

Planner not entered : if record not found in centaurFieldMatrix.matrix_dr table that

Sample Consignments not confirmed : If consignment found in

Input size, type, Not applicable

DFR Date : Please refer sequence 2, process flow para 2 and 3.

Status (W O R K I N G) : is taken from centaurdata.tp table fields tpworktype or

Mobile : mobile_no field from centaurdata.mobile_no table

Places (from-to) from deviated_from1 & deviated_to1 is considered only when

JT Work 1 and 2: empl_code field from centaurdata.tpmgr table is checked for

Only message is displayed as

Input size, type, Doctor selection is drop down list.

Dependency GPS needs to be active.

On successful signal of GPS, system try to match User’s lat-lon as follows :

Sequence No. 6 Continue…..

2. Converted – MR mentions in his monthly doctor brand planner that he

4. Defection – Doctor who stops prescribing Centaur brand derived from

RX Brand and Units : Rx brand drop down is derived from centaurdata.mobile_hqprd

Brands Detailed /Promoted : This drop down is derived from centaurdata.mobile_hqprd

Validations before saving are as follows :

ww1 Joint Work with MGR 1 Insert

ww2 Joint Work with MGR 2 Insert

from1 From Place Insert

centaurdata.mobile_dfrmain to1 Interior From Place Insert

to2 Interior To Place Insert

type1 Type (Ex,OS) Insert

type2 Interior Type (Ex,OS) Insert

status Status (Working, Meeting) Insert

from_mobile Save value as "Y" Insert

empcde Login ID Insert

Work Type (Independent=Y,

Joint Work with. If more

Server Time while saving

timestamp_ Convert GPS timestamp Insert

If Current lat-lon matched

Samples /Inputs Given

If Sample, then take

empcde Login ID Insert

empcde Login ID Insert/update

Brands Detailed / Promoted

detailed Save value as "Y"

On clicking Google Map, previous doctor’s location