GPS Based M-Reporting Documentation - MGR

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 Remarks

srno auto incriment
Centaur IT will enter/update 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
stration
headquarter of Centaur IT will enter/update from
hq
employee backend.
state state of employee
backend.
designation of Centaur IT will enter/update from
design
employee backend.
mobile_no mobile number
backend.
app_device_unique_id mobile unique ID Update
app_sim_unique_id SIM ID Update
app_registration_login
ragistration date Update
_date
app_registration_login
ragistration time Update
_time
otp OTP Update
Confidential Document
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
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
Dependency Not applicable

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 MGR)
Purpose Systems checks following conditions and do not allow to proceeds if either of the
condition fails :
- MR selected for Today’s joint work are active (i.e. working with organization)
- Vacancy under him is not filled for more than 40 days.
- TP is not entered.
- Today’s TP is locked.
- Today’s TP is not approved.
- Deviation request is not approved.
- Comments on Subordinate’s report are not entered.
- Sample Consignments not confirmed.
- Company Property Format
- Enter Vacancy Planner
- Update family details for Mediclaim purpose.
- Enter Manager To-Do List
- Red File
Determines Controls mentioned in “purpose” above.
Screen-shot
Input size, type, Not applicable

validation
Dependency If above all conditions are fulfilled then only “Daily Report” option is available for reporting.
Connectivity Whether to initiate Call entry.
centaurERPsndStatistic.statistic_lvl Empcde, yymm, desn_cde Read
with read,write,view centaurFieldFormats.hrd_cases empcde
access Read
centaurERPsndStatistic.statistic_rep_mst Empcde, manager, yymm, Read
grp, desn_cde
centaurERPsndStatistic.statistic_vf Vaccode, fillcode,vacname Read
centaurERPpayroll.candidate repl_empl_cd Read
centaurERPsndStatistic.statistic_emp_mst empcde,empnme,dt_joining Read
centaurdata.tpmgr empl_code,locked, tpdate, Read
tpdevreq,deviated_tpworktype
centaurdata.actuali Empcde, antec_date, comment, Read
antec_other,storedate
centaurdata.dfrmain Dfrdate, comment, empcde, Read
status, storedate
centaurdata.promotdata pm_no,lrdate, empcde, STATUS Read
centaurFieldFormats.leaving_emp login_id Read
centaurFieldFormats.exclude_for_property Empcde Read
centaurERPsnd.empl_status wef_status,empcde Read

centaurFieldMatrix.matrix_br Empcde, MONTH, YEAR Read
centaurFieldMatrix.exclude_for_planner Empcde, vac_code Read
centaurERPleave.GMP_employee_master Empcde, active, login_date Read
centaurERPleave.mediclaim_details empl_cd Read
centaurFieldFormats.mgr_to_do_list empcde,entry_date Read
centaurFieldFormats.hq_weekly_performance login_id, hq, grp, Read
from_date, to_date
centaurERPsndAnalysis.statistic_fieldforce Cumach, emptype, yyyy, Read
empcde, login_id
PHP path/file Mobile_mgr_dfr.php

name,class,function…. Alert_function.php
Main_class.php
Process Flow MR selected for Today’s joint work are active (i.e. working with organization) –
If tpmanager1 or tpmanager2 or deviated_ww1 or deviated_ww2 fields
from centaurdata.tpmgr table for tpdate as DFR date are not blank, then check
these employee codes in centaurERPsndStatistic.statistic_lvl for yymm as current month.
If any code is not found then do not allow manager to proceed further.
Manager has to enter deviation first to remove this employee from joint work
and then only he can proceed further.
Vacancy under him is not filled for more than 40 days. –

If manager is having vacancy under him and if difference between vacancy creation date
(dt_joining from centaurERPsndStatistic.statistic_lvl) and today’s date is more than 40 days
then manager is not allowed to report.
HR/Admin dept. can exclude such cases if required and then Manager is allowed to report
otherwise he has to fill the vacancy first.
TP is not entered. – If record not found in centaurdata.tpmgr table

for tpdate as today’s DFR date.
Today’s TP is locked – If locked from centaurdata.tpmgr is “Y” then TP for that day is locked.
Today’s TP is not approved - if tpstatus field of centaurdata.tpmgr table is “1” then MGR’S TP
is not approved.
Deviation request is not approved : If tpdevreq field of centaurdata.tpmgr table is=1 and
deviated_tpworktype!=’’ then MGR has entered deviation which is not approved by
his Manager.
Comments on Subordinate’s report are not entered – If comment field from

centaurdata.actuali and centaurdata.dfrmain tables is blank for empcde as his subordinates
and dfrdate / antec_date is less than or equal to 2 days before.
Subordinates are taken from centaurERPsndStatistic.statistic_rep_mst table
for yymm as current month. Vacancy codes are excluded.
If subordinate’s designation code (desn_cde field) is <65 then check these
in centaurdata.actuali table and if >=65 then check in centaurdata.dfrmain table.
Sample Consignments not confirmed : If consignment found

in centaurdata.promotdata table in the name of concern MGR with status field =”0”
Then take consignment’s lrdate field from centaurdata.promotdata table
and add 30 days in lrdate and check with current date.
If it exceeds then consignment is due for confirmation.
Company Property Format - Take vacancy codes under manager.

Check these vacancy codes in centaurERPsndStatistic.statistic_vf table and take vaccode
for whom this vacancy code is created. Search this vaccode in
centaurFieldFormats.leaving_emp table. If not found in this table then check in

centaurFieldFormats.exclude_for_property table. If here also not found
then check if he is re-joined in centaurERPsnd.empl_status table for wef_status=’J’.
If he is not re-joined and company property format is not filled then ask to fill company proper
format first.
Enter Vacancy Planner : If planner of vacancy code under him is not found in
centaurFieldMatrix.matrix_br for current month.
Update family details for Mediclaim purpose. – First check Login ID in

centaurERPleave.GMP_employee_master table as empcde. If found means he is eligible for
Mediclaim. Then check whether he has entered family details required for mediclaim in
centaurERPleave.mediclaim_details table.
Enter Manager To-Do List – Check record for Logged in User in

centaurFieldFormats.mgr_to_do_list table for entry_date >= (current date – 8 days)
Red File – Manager’s who are working in organisation for more than 4 months, take
HQ names and subordinates working under him from centaurERPsndStatistic.statistic_rep_mst
Table and then check cumulative %ach from centaurERPsndAnalysis.statistic_fieldforce
table for each HQ & each Manager working under him.
If %Ach for any HQ or subordinate is less than 95% then ask him to enter Red file Details.
Details Only after fulfilling above conditions Manager can enter Daily Report.
Sequence No. 5
Screen Name Main Menu
Purpose To select desired activity
Determines Main Menu
Screen-shot
Input size, type, Not Applicable

validation
Dependency
Connectivity
centaurERPsndStatistic.statistic_lvl empcde,empnme,hq,state, Read
desn_cde,design,grp
access centaurdata.mobile_no mobile_no Read
centaurdata.tpmgr 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
PHP path/file mobile_mgr_dfr.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.tpmgr 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.tpmgr 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.tpmgr 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: tpmanager1,tpmanager2 fields from centaurdata.tpmgr table.
Above all information is only display. After that user will choose option from given
dropdown.
Details
Sequence No. 6
Screen Name Daily Report
Purpose To enter daily report.
Determines Doctor’s call entry
Screen-shot

validation
Dependency
Connectivity
Database.Table used
access
Process Flow Under Daily report there are sub-menus as below.
Manager has to enter details from all sub-menus mentioned below for single Doctor
call entry. First 4 options are compulsory.
 Call Entry
 In-Clinic
 Experience & Lesson
 Today’s Work
 Vacancy
 Gap Observed
 Stockist Details
 For HO
Details
Sequence No. 6 continue….

Screen Name Daily Report – Call Entry – STATUS = W O R K I NG
Purpose To enter call entry details from daily report.
Determines Doctor’s call entry
Screen-shot Image-1 Image-2 Image-3
Subordinates’ Combo – Employee code (char 4) + Employee Name (char 30) + Designation (char 4) + HQ
Input size, type, (char 15)
validation Text Box (Size 10) for entering Doctor name for searching
Search Dr. – Button
Doctor Combo – Doctor Name (Char 151) + right 5 char of Doctor Code + “[ Geotagged ]“ (If Geo
tagging is already done)
Whether Corporate Dr.( Y/N ) – Check Box
Detailing Through PCC (Y/N) ? – Combo Box (Yes , No)
Input – Combo (Promoional Input Name Char 40) + Stock Units (Int 20)
Units – Text Box (Size 5)
If Non Rxers then Whether Dr. is Visited >25 Times and There is no Responce ( Y/N )- Check box
Reason – Textarea
Auto Mail – Combo Box (PMT / CRM / Medical)
P3 Brand Approval – Combo (Approve / Reject)
P3 Brand Remark - Textarea
Dependency GPS needs to be active
Connectivity With next screen of report entry.

Database.Table Table Name Fields Access
centaurERPsndStatistic.statistic_rep_m Empcde,yymm, Read
used with
st grp,desn_cde, manager
read,write,view centaurERPsndStatistic.statistic_lvl empcde,empnme,design,hq Read
access centaurdata.mobile_mgr_drs_combo mr_reporting_drs, active, Read
time_from, time_to
centaurdata.mobile_actuali_drs Drcode, empcde, Read/Writ
antec_date e
centaurdata.drchart empcde,drcode,drname Read
centaurERPcrm.rectify_latitude_longit Drcode,empcde, login_by, Read

ude login_date
centaurERPcrm.doctors_address drcode,latitude,longitude, Read
empcde
centaurdata.detailing_products empcde,drcode,p_cde,dfrd Read
ate,
dr_type,m5_rx_qty, app_rej
centaurERPmasters.prod_mst p_shrt,p_cde Read
centaurFieldMatrix.matrix_br p_cde,p_shrt,opportunity_op Read

en, MONTH,YEAR,
empcde,drcode

name,class,functio mgr_call_combo.php
mgr_geotagging_repo_sub.php
n…. mgr_geotagging_repo_sub_search.php
mgr_call_entry_drs.php
mgr_call_entry_gps.php
call_class.php
Process Flow On selecting call entry, subordinate’s combo will appear which shows subordinate’s
codes with name who are selected for joint work.
On selecting subordinate, full doctor list will appear of selected subordinate. If

particular letter is entered in search doctor text box then doctorss having that letter
in name will only appear.
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 MGR 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.
GPS Functionality :
As we are having multiple divisions and MGR 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 selected 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 1.
Input : 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 MGR cannot enter Quantity more than closing stock.
P3 Brand Approval/Rejection Screen : Conversions or Defection mentions by any

subordinates in his reporting three days before will appears for Apporval or Rejection.
Manager will approve or Reject with Remark.
In this entry screen Automail selection is compulsory.
Tables along with field names which are used for saving data are given below
Table Name Table Field Name Input Field Remark
empcde Login ID Insert

mrcode Selected Subordinate Insert
antec_date reporting Date Insert
drcode selected Doctor code Insert
If user is saving Doctor Call

befor 1 pm then
value is "M" other wise
me "E" Insert
dfrtime Server time Insert
corporate_drs Entered by User(Y/N) Insert
response Entered by User(Y/N) Insert
reason Entered by User Insert
Entered by
automail_dept User(PMT/CRM/MEDICAL) Insert
device_type "M" Insert
input Input code Insert
input_units input units Insert
centaurdata.mobile_actua
li_drs storedate Server Date Insert
If user is saving Doctor Call
befor 11 pm then
value is
"reporting_doctors" other
drs_from wise "patch_doctors" Insert
$_SERVER['HTTP_USER_A
device_details GENT'] Insert
call_time not is use Insert
latitude User's current Latitude Insert
longitude User's current Lomgitude Insert
Meter difference between

current location
meter_diff_matched_ and Docotrs address found
with in database Insert
time_srno not in use Insert
remark not in use Insert
dr_address not in use Insert
detailing_ppc not in use Insert
accuracy User's current Accuracy Insert

altitude User's current Altitude Insert
User's current
altitudeaccuracy altitudeaccuracy Insert
heading User's current heading Insert
speed User's current speed Insert
TIMESTAMP User's current timestamp Insert
current timestamp into
timestamp_datetime current date and time Insert
ocupol_oint not in use Insert

opportunity_close
d Server date update
app_date Server date update
centaurFieldMatrix.matrix_b
app_rej_by loging ID update
r
If Approve "Y".Rejected
app_rej "R" update
mgr_remark Entered by user update

opportunity_clos
ed Server date update
centaurFieldMatrix.matrix_br_t
app_rej_by loging ID update
mp
app_rej "R" update

opportunity_clos
ed server date update
centaurdata.detailing_products app_rej_by login ID update
app_rej "R" update
Details

Screen Name Daily Report –In Clinic
Purpose
Determines
Screen-shot
Input size, type, Doctor combo: Doctor Name (Char 151) + right 5 char of Doctor Code
validation Activity Combo : char 35
In-Clinic Intaraction : text area
Dependency
Connectivity
Database.Table used
Table Name Fields Access
centaurdata.mobile_inclinic Drcode,antec_date, Read/Write
access empcde
centaurdata.mobile_actuali_drs Drcode,antec_date,drcode Read
centaurdata.drchart Drname,drcode,empcde Read
PHP path/file Inclinic.php

name,class,function…. save_inclinic.php
inclinic_class.php
Process Flow Doctor combo: Only those doctors are visible, to whom manager has already
reported for today.
IF doctor is already saved in centaurdata.mobile_inclinic table then those doctors
are not visible.
Following tables are use
Table Field
Table Name Input Field Remark
Name
empcde Login id Insert
antec_date dfrdate Insert
selected doctor
drcode code Insert
centaurdata.mobile_inclinic activity selected activity Insert
inc_int entered by user Insert
storedate server date Insert
TIME server time Insert
Details

Screen Name Daily Report –Experience & Lesson
Purpose
Determines
Screen-shot
Input size, type, MR combo : work with 1 and work with 2 MR visible for selection
validation At : char (50)
We made : char (2)
Remark : text area.
Dependency
Connectivity
Database.Table used
centaurERPsndStatistic.statistic_rep_mst Empcde, yymm, grp, Read
access desn_cde
centaurERPsndStatistic.statistic_lvl empcde,empnme,design,hq, Read
yymm
PHP path/file Mgr_experience.php
name,class,function…. Save_mgr_experience.php
Call_class.php
Process Flow
Following tables are used

selected employee
empcde code Insert
dfrdate DFR date Insert
place entered by user Insert
centaurdata.mobile_mgr_experience total_calls entered by user Insert
experience_box entered by user Insert
login_id login ID Insert
login_time server time Insert
login_date server date Insert
Details

Screen Name Daily Report –Todays Works
Purpose RCPA details
Determines
Screen-shot
Input size, type, Chemist name :char (25)

POB Rx: char (5)
validation Whether POB (Rs.) includes SINT New (Y/N): char (1)
Monthly Business from his counter: char(8)
Centaur monthly Business: char(8)
Doctor combo: char (151) + right drcode char (5)
Market Feedback : text areas
Dependency Doctor Call Entry
Connectivity
Database.Table used
centaurdata.mobile_actuali_drs Drcode, antec_date, Read
access empcde
centaurdata.drchart Drname,drname Read
centaurdata.mobile_todays_work Drcode,empcde,antec_date Read
PHP path/file Todays_work_class.php
name,class,function…. Todays_work.php
save_todays_work.php
Process Flow In doctor combo only those doctors are visible which is entered by manager thru
call entry. If today’s work already done, then those doctors are not visible for
selection.
Following tables are used

empcde login ID Insert

antec_date DFR date Insert
chemist_name entered by User Insert
chemist_pob entered by User Insert
chemist_mth_business
entered by User Insert
centaur_mth_business
entered by User Insert
centaurdata.mobile_todays_work Selected by
drcode User Insert
mktg_feedback entered by User Insert
time server time Insert
pob_includes_sint_new entered by user Insert
Details

Screen Name Daily Report –Vacancy
Purpose
Determines
Screen-shot
Input size, type, Vacancy Combo char(35)

validation Status text area
Planning to fill text area
Dependency
Connectivity
Database.Table used
centaurdata.mobile_vacancy Vaccode, antec_date,empcde, Read
access status, plan_fill
centaurERPsndStatistic.statistic_lvl yymm,empcde,empnme,design, Read
dt_joining,hq,grp,dt_joining
centaurERPsndStatistic.statistic_vf vaccode Read
centaurERPpayroll.candidate repl_empl_cd, Read
PHP path/file Vacancy_class.php
name,class,function…. Vacancy.php
Save_vacancy.php
Process Flow
Vacancy under manager which are not yet filled are shown in combo.
Summary of vacancy is also shown.
Details are save in following table.
empcde login id Insert

vaccode Vacancy code Insert
status Entered by user Insert
centaurdata.mobile_vacancy
plan_fill Entered by user Insert
time server time Insert
Details

Screen Name Daily Report –Gap Observed
Purpose
Determines
Screen-shot
Input size, type, Select combo

validation Step taken by manager on evidence: text area
Your Decision: text area
Work mirror of the SCE checked Signed: combo
Listened to the detailing of SCE : Combo
Dependency
Connectivity
Database.Table used
access
PHP path/file Gap_observed.php
name,class,function…. Gap_obsertved_class.php
Save_gap_observed.php
Process Flow Work mirror of the SCE checked Signed & Listened to the detailing of SCE
Combos are for SAKSHAM & SANKALP division only.
Following table is used to save a Records.

sele_req selected by useer Insert
step_taken entered by user Insert
your_decision entered by user Insert
centaurdata.mobile_gap_observed
storedate system date Insert
time system time Insert
work_mirror entered by user Insert
listening_detailing entered by user Insert
Details

Screen Name Daily Report –Stockists Details
Purpose
Determines
Screen-shot
Input size, type, Stockist : combo code (4 char), name (40 char)
validation Near expairy brand : combo product Name (60 char)
High Inventary Product : combo product Name (60 char)
Plan for the Month : text area
Dependency
Connectivity
Database.Table used
centaurERPsndStatistic.statistic_sm stock_cde, distcde, yymm, Read
access empcde,
centaurERPsndStatistic.statistic_dmr Distcde, yymm, empcde, Read
centaurERPmasters.statistic_superstk Distcde, stock_cde, stockist, Read
centaurERPmasters.dist_mst Distcde, distnme Read
centaurERPsndStatistic.statistic_lvl Yymm, grp,hq, empcde Read
centaurdata.mobile_hqprd mktg_p_cde, hq, grp, Read
centaurERPmasters.prod_mst p_cde,p_name Read
PHP path/file Stockist.php
name,class,function…. Save_stockist.php
Stockist_class.php
Process Flow
Only those stockist are visible which are attached to the work with 1, work with 2
MR.
If state = NEPAL then stockists are shown from centaurERPsndStatistic.statistic_smr
table
else stockists are shown from centaurERPsndStatistic.statistic_dmr table.
Near expairy brands and High inventory brands are taken from
centaurdata.mobile_hqprd tables.
Data stored in below table.
empcde loggin ID Insert

selected by
stk_name user Insert
selected by
near_expairy user Insert
centaurdata.mobile_stockist selected by
high_inventary user Insert
plan_month entered by user Insert
storedate Sytem date Insert
Details

Screen Name Daily Report –For HO
Purpose
Determines
Screen-shot
Input size, type, Recommendation for HO followup give DR details : text area
validation Campaign/support from HO : Text area
Auto Mail : COMBO
Dependency
Connectivity
Database.Table used
access
PHP path/file for_ho.php
name,class,function…. for_ho_class.php
fave_for_ho.php
Process Flow Tada stored in following table

recommendation Entered by user Insert
campain_details Entered by user Insert
centaurdata.mobile_for_ho selected by
auto_mail user Insert
storedate system date Insert
Details

Screen Name Daily Report –Submit & Freeze
Purpose
Determines
Screen-shot
Input size, type, Submit & freeze button

validation
Dependency
Connectivity
Database.Table used
access
PHP path/file
Process Flow
Following entries are compulsory for Submit & freeze Report
 Call Entry
 In-Clinic
 Experience & Lesson
 Today’s Work
Records are save in following table
copy data from centaurdata.mobile_actuali_drs to centaurdata.actuali_drs

centaurdata.actuali_drs selected
mrcode subordinate Insert

selected doctor
drcode code Insert
Morning ,Evening
based in server
me time Insert
dfrtime server time Insert
count_rxers entered by user Insert
rx_details entered by user Insert
corporate_drs entered by user Insert
tgt_brand entered by user Insert
rxs_brand entered by user Insert
rxs_units entered by user Insert
conv_details entered by user Insert
response entered by user Insert
reason entered by user Insert
automail_dept entered by user Insert
call_time Insert
latitude GPS latitude Insert
longitude GPS Longitude Insert
time_srno Insert
remark entered by user Insert
dr_address Insert
diffrence
between
current position
and
meter_diff_matched_with tagged lat,lng Insert
detailing_ppc entered by user Insert
accuracy GPS accuracy Insert
altitude GPS altitude Insert
GPS
altitudeaccuracy altitudeaccuracy Insert
heading GPS heading Insert
speed GPS speed Insert
TIMESTAMP GPS timestamp Insert
GPS timestamp
convert
into date and
timestamp_datetime time Insert
ocupol_oint entered by user Insert
copy data from centaurdata.mobile_actuali_brand to centaurdata.actuali_brand
Table Field
Name
p_cde product code Insert
centaurdata.actuali_brand drcode doctor Code Insert
ww work with Subordinate Insert
sampled sample qty Insert
Table Field
Name
freeze "Y" Update
centaurdata.mobile_actuali
remarks Entered by user Update
copy data from centaurdata.mobile_actuali to centaurdata.actuali
Table Field
Name
antec_date Dfrdate Insert
antectype1 work type 1 as per TP Insert
antectype2 Work type 2 as per TP Insert
workedwith1 working with 1 as pe TP Insert
workedwith2 working with 2 as pe TP Insert
from1 from 1 as per TP Insert
from2 from 2 as per TP Insert
to1 to1 as per TP Insert
centaurdata.actuali
to2 to2 as per TP Insert
STATUS status as per TP Insert
empcde login Id Insert
antec_other Working status Insert
from_mobile "Y" Insert
freeze "Y" Insert
remarks Entered by user Insert
Table Field
Name
centaurFieldFormats.allow_web_reporting dfr_done "Y" Update
Details

Screen Name Daily Report –status = INDUCTION
Purpose
Determines
Screen-shot
Input size, type, Name of FF : char(30)

validation Name Of HQ : char(20)
Date of Induction: char (10)
HO offer letter Date :char(10)
Remark : Text area
Submit & Freeze : Button
Dependency
Connectivity
Database.Table used
centaurFieldFormats.allow_web_reporting dfr_done,empcde, Read
access from_date,to_date
Process Flow
This screen is available for MGR if he select INDUCTION on Tour plan status.
empcde Login ID Insert

dfrdate DFR date Insert
Entered by
ind_name user Insert
Entered by
ind_hq user Insert
centaurdata.mobile_induction_details
Entered by
ind_date user Insert
Entered by
ind_offerdate user Insert
login_date server date Insert
login_time server time Insert
antec_date Dfr Date Insert

antectype1 Selected as per TP Insert
workedwith1 Selected as per TP Insert
from1 Selected as per TP Insert
to1 Selected as per TP Insert
STATUS Selected as per TP Insert
antec_other Selected as per TP Insert
freeze Blank Insert
remarks Entered By user Insert
antec_date DFR date

centaurdata.actuali from2 Selected as per TP Insert
status Selected as per TP Insert

freeze Blank Insert

centaurFieldFormats.allow_web_reporting dfr_done "Y" Update
Details

Screen Name Daily Report –status other than INDUCTION and W OR R K I N G
Purpose
Determines
Screen-shot
Input size, type, Remark : Text area

validation
Dependency
Connectivity
Database.Table used
access
Process Flow
Record save in following table
antec_date Dfr Date Insert

STATUS Selected as per TP Insert
freeze Blank Insert
antec_date DFR date

centaurdata.actuali
status Selected as per TP Insert
freeze Blank Insert
Details
Sequence No. 7
Screen Name Saved Calls
Purpose Display Call Details
Determines
Screen-shot
Input size, type,

validation
Dependency
Connectivity
Database.Table used
with read,write,view Table Name Fields Access
centaurERPmasters.statistic_runctl yymm Read
access
centaurERPsndStatistic.statistic_lvl desn_cde,empcde, Read
empnme,design
centaurdata.mobile_actuali empcde,antec_date Read
centaurdata.dfrmain Empcde, dfrdate, Read

from1,to1,from2,to2,type1,
type2,STATUS,remark,secsales,
mgrlearning,competitive_info,
astoredate,from_mobile
centaurdata.mobile_induction_details ind_name, ind_hq, ind_date, Read
ind_offerdate
centaurdata.mobile_actuali_drs empcde,mrcode,antec_date, Read
drcode,me,dfrtime,
count_rxers,rx_details,
corporate_drs,tgt_brand,
rxs_brand,rxs_units,
conv_details,response,
reason,automail_dept,
device_type,input,
input_units,storedate,
drs_from,device_details,
call_time,time_srno,
latitude,longitude,
altitude,altitudeaccuracy,
heading,speed,
accuracy,TIMESTAMP,
timestamp_datetime,
meter_diff_matched_with,
app_latitude,app_longitude,
remark,dr_address,
detailing_ppc,ocupol_oint
centaurERPcrm.rectify_latitude_longitude Drcode, login_date, login_by, Read
updated_in_dfr,reason, active
centaurdata.mobile_dfrdrs Drcode, dfrdate,empcde, Read
drcode,yn
centaurdata.mobile_actuali_brand p_cde,sampled, Read
drcode,antec_date
centaurERPmasters.prom_mst ls_name Read
entaurERPmasters.prod_mst p_shrt, p_cde Read
centaurdata.drchart Drname,drcode Read
centaurERPcrm.doctors_address drcode,town,cityordist,empcde Read
centaurERPcrm.doctors_main drcode,name,initial, Read

lastname,speciality
centaurdata.mobile_inclinic Drcode, activity, inc_int Read
centaurdata.mobile_mgr_experience Empcde, empnme, Read

total_calls, place
centaurdata.mobile_todays_work chemist_name, chemist_pob, Read
chemist_mth_business,
centaur_mth_business, drname
mktg_feedback
centaurdata.mobile_vacancy antec_date, empcde, Read
vaccode, status, plan_fill
centaurdata.mobile_gap_observed antec_date,empcde, sele_req Read
step_taken, your_decision
centaurdata.mobile_stockist antec_date,empcde, Read
stk_name, , plan_month
centaurdata.mobile_for_ho antec_date,empcde, time, Read
recommendation,
campain_details, auto_mail
PHP path/file Mgr_saved_calls.php
Process Flow
Call Entry: Todays doctors calls are shown from centaurdata.mobile_dfrdrs table
chemist/Stockist details are shown from centaurdate.mobile_dfrchemist table
In Clinic: Todays In Clinic details are shown from centaurdata.mobile_inclinic table
Experience & Lesson: Todays Experience & lesson shown from

centaurdata.mobile_mgr_experience table
Today’s Work: Todays work shown from centaurdata.mobile_todays_work table.
Vacancy: Todays vacancy entries are shown from centaurdata.mobile_vacancy table.
Gap Observed: Todays gap observed are shown from

centaurdata.mobile_gap_observed table.
Stockists Details: Todays stockist details are shown from centaurdata.mobile_stockist

table.
For HO: Todays For HO details are shown from centaurdata.mobile_for_ho table.
Details
Sequence No. 8
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
Database.Table used Fields Access
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.
doctors_address empcde logged in ID Read
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. 9
Screen Name Comments on Subordinates
Purpose DFR entry
Determines
Screen-shot Manager Comments on MR Report Manager comments on Manager Report
Input size, type, Employee: combo employee code (char 4), employee name (30)
validation Select Date: combo employee code (char 4), dfrdate (date DD/MM/YYYY)
Comments : text area
RCPA and competitor information: text area.
In clinic interaction as remarsk by MR : text area.
Opportunity identified being right or wrong : text area.
Biggest rxer and opportunity every day : text area.
Dependency
Connectivity Call entry
Database.Table used
centaurdata.actuali empcde,antec_date, Read
access
antec_other
centaurdata.dfrmain empcde,dfrdate,status Read
centaurERPsndStatistic.statistic_lvl desn_cde Read

,Design,yymm,empcde,
empnme,design,hq, desn_cdes
centaurdata.samples_stock p_cde,units,value, Read
yymm,empcde
centaurERPmasters.prom_mst show_in_ereporting, Read
ls_cde
centaurERPmasters.statistic_runctl yymm Read
centaurdata.actuali empcde,antec_date Read
centaurdata.dfrmain Empcde, dfrdate, Read

from1,to1,from2,to2,type1,
type2,STATUS,remark,secsales,
mgrlearning,competitive_info,
astoredate,from_mobile
centaurdata.mobile_induction_details ind_name, ind_hq, ind_date, Read
ind_offerdate
centaurdata.actuali_drs empcde,mrcode,antec_date, Read
drcode,me,dfrtime,
count_rxers,rx_details,
corporate_drs,tgt_brand,
rxs_brand,rxs_units,
conv_details,response,
reason,automail_dept,
device_type,input,
input_units,storedate,
drs_from,device_details,
call_time,time_srno,
latitude,longitude,
altitude,altitudeaccuracy,
heading,speed,
accuracy,TIMESTAMP,
timestamp_datetime,
meter_diff_matched_with,
app_latitude,app_longitude,
remark,dr_address,
detailing_ppc,ocupol_oint
centaurERPcrm.rectify_latitude_longitude Drcode, login_date, login_by, Read
updated_in_dfr,reason, active
centaurdata.dfrdrs Drcode, dfrdate,empcde, Read
drcode,yn
centaurdata.actuali_brand p_cde,sampled, Read
drcode,antec_date
centaurERPmasters.prom_mst ls_name Read
entaurERPmasters.prod_mst p_shrt, p_cde Read
centaurdata.drchart Drname,drcode Read
centaurERPcrm.doctors_address drcode,town,cityordist,empcde Read
centaurERPcrm.doctors_main drcode,name,initial, Read

lastname,speciality
centaurdata.mobile_inclinic Drcode, activity, inc_int Read
centaurdata.mobile_mgr_experience Empcde, empnme, Read

total_calls, place
centaur_mth_business, drname
mktg_feedback
centaurdata.mobile_vacancy antec_date, empcde, Read
vaccode, status, plan_fill
centaurdata.mobile_gap_observed antec_date,empcde, sele_req Read
step_taken, your_decision
centaurdata.mobile_stockist antec_date,empcde, Read
stk_name, , plan_month
centaurdata.mobile_for_ho antec_date,empcde, time, Read
recommendation,
campain_details, auto_mail
PHP path/file Mgr_comments_mobile.php
Process Flow Call Entry: doctors calls are shown from centaurdata.dfrdrs table for mr
And centaurdata.actuai_drs table for Manager
chemist/Stockist details are shown from centaurdate.dfrchemist table
In Clinic: In Clinic details are shown from centaurdata.mobile_inclinic table
Experience & Lesson: Experience & lesson shown from

centaurdata.mobile_mgr_experience table
Today’s Work: work shown from centaurdata.mobile_todays_work table.
Vacancy: vacancy entries are shown from centaurdata.mobile_vacancy table.
Gap Observed: gap observed are shown from centaurdata.mobile_gap_observed table.
Stockists Details: stockist details are shown from centaurdata.mobile_stockist table.
For HO: For HO details are shown from centaurdata.mobile_for_ho table.
Balance unit of sample and gifts is show here to know qty in hand from
centaurdata.samples_stock table
System will not allow manager to report if two day’s back report are pending for
comments.
If subordinate’s comments are pending Call entry option is not visible to manager.
After click on save comments button system sent mail to subordinate with comments
details.
Comments are save in following table
For MR
Table Field
Name
comment Entered by user Update
remark5 Entered by user Update
centaurdata.dfrmain
commentby login id Update
commentdt server date Update
commentstatus "1" Update
For MGR
Table Field
Name
comment entered by user update
commentby login Id update
centaurdata.actuali
commentdt server date update
commentstatus "1" update
Details
Sequence No. 10
Screen Name Alerts for You
Purpose Give message regarding activities.
Current activities are mentioned blow. These may stop or new activities may come.
- Projection for the month

- Traning Recommendation Form not filled
- Post CME not done
- Submit MR Appraisal
- Subordinate's TP is not approved
- Subordinate's comments on report not entered
- Post OPD Not Done
Determines -
Screen-shot

validation
Dependency -
Connectivity -
centaurdata.tpmgr empl_code, tpdate, Read
tpdevreq
access
centaurFieldFormats.mgr_for_indent mgr_code Read
centaurERPmasters_new.month_close yymm Read
centaurFieldFormats.mgr_projection mgr_code,yymm Read

centaurERPsndStatistic.statistic_rep_mst empcde,empnme, Read
yymm, manager,
desn_cde
centaurERPsndStatistic.statistic_lvl dt_joining, Read
empcde,yymm,empnme
centaurFieldFormats.induction_feedback Empcde, induction_date Read
centaurFieldFormats.training_reommendation empcde Read
centaurFieldFormats.precme_main cme_id, mgr_code, Read

post_cme, approval3,
crm_rejected, cme_date
centaurERPmasters.statistic_runctl Yyyy, yymm Read
centaurERPadmin1819.cycle_cme_advance cme_id,cme_date, Read
empcde,
export_to_finance,
cme_id, cancel_tour,
entry_type
centaurFieldFormats.new_mr_apprisal Empcde, manager, Read
filled,yymm
centaurERPsndStatistic.statistic_emp_mst dt_joining, empcde Read
tpstatus
centaurdata.tp empl_code, tpdate, Read
tpstatus, empl_code
centaurdata.actuali empcde,antec_date, Read
comment, antec_other,
storedate
centaurdata.dfrmain empcde,dfrdate, Read
comment, status,
storedate
centaurFieldFormats.opd_details opd_code, post_opd, Read
opd_date, mgr_code,
deleted_opd,
ho_approved_by
PHP path/file Mgr_alerts.php

name,class,function…. Alert_function.php
Process Flow
Projection for the smonth – Check projection entry from
centaurFieldFormats.mgr_projection
table for mgr_code as Logged in user and yymm as indent month which is derived
from
centaurERPmasters_new.month_close table for yymm>current month.
Training Recommendation Form not filled – Check newly joined subordinate’s

training details are filled or not in tables centaurFieldFormats.induction_feedback,
centaurFieldFormats.training_reommendation
Post CME not done – If post CME details are not found in cycle_cme_advance
Table for cme id from centaurFieldFormats.precme_main for mgr_code as Logged in
User.
Submit MR Appraisal – Check in centaurFieldFormats.new_mr_apprisal table

for mgr_code as logged in user and empty field “filled”.
Subordinate's TP is not approved – If tpstatus field from TP file is zero then TP is not
approved.
If subordinate is MR then TP file is centaurdata.tp and if manager then TP file is
centaurdata.tpmgr
Subordinate's comments on report not entered – If comment field from

centaurdata.actuali
(For manager) and from centaurdata.dfrmain (For MR) is blank.
Post OPD Not Done - post_opd=’N’ from centaurFieldFormats.opd_details table

for mgr_code as logged in user and deleted_opd='' and ho_approved_by!='' and
opd_date <=s today’s date.
Details
Sequence No. 11
Screen Name Team Status
Purpose To View today’s working status of subordinates.
Determines Work started by every subordinates, number of calls done.
Screen-shot

validation
Dependency -
Connectivity -
centaurERPsndStatistic.statistic_lvl Empcde, Read
desn_cde,design,
access yymm
centaurdata.farechart_doctor_relation Finished, empcde, yymm Read
centaurdata.tp empl_code,tpfrom1,tpto1, Read
tpfrom2,tpto2

tpstatus, tpmanager1,
tpmanager2, tpdevreq,
deviated_ww1,
deviated_ww2
centaurdata.farechart_doctor_relation Drcode, yymm, empcde, Read

basetown, desttown
centaurdata.mobile_dfrmain Empcde,dfrdate Read
centaurdata.mobile_dfrdrs Drcode,empcde, dfrdate Read
centaurdata.mobile_actuali Empcde,antec_date Read
centaurdata.mobile_actuali_drs Drcode, empcde, Read
antec_date
centaurdata.mobile_dfrchemist Chemist, empcde, Read
dfrdate, stkcde
PHP path/file team_status.php

Process Flow Code – Subordinates Code derived from from centaurERPsndStatistic.statistic_lvl for
current month
Name – Subordinates Name from centaurERPsndStatistic.statistic_lvl
Desg – Subordinates Designation from centaurERPsndStatistic.statistic_lvl
Mobile Repo - Not required now.
From –To – Subordinates current working patch derived from centaurdata.tp for MR
and from centaurdata.tpmgr for managers.
Patch Drs. – Count of doctors in above patch taken from

centaurdata.farechart_doctor_relation.
Day Started – If atleast one doctor call is saved then day is started.
Total POB – Total sum of POB from centaurdata.mobile_dfrchemist table
Dr. Call done – Total count of doctors count from centaurdata.mobile_dfrdrs if

subordinate is MR and from centaurdata.mobile_actuali_drs if subordinate is
manager.
Chemist calls - Total count of chemist from centaurdata.mobile_dfrchemist for not

empty chemist.
Stockist Calls- Total count of stockist from centaurdata.mobile_dfrchemist for not

empty stkcde.
Details
Sequence No. 12
Screen Name Team’s Today’s Report View
Purpose To View today’s whole report of subordinates.
Determines Doctor wise details.
Screen-shot MR’s Report Manager’s Report
Input size, type, Subordinate’s combo – Code (char 4) +’-‘+ name (char 30) + ‘-
validation ‘+designation (char 4)
Dependency -
Connectivity -
centaurERPsndStatistic.statistic_rep_mst Yymm,manager,empcde,grp Read
access
centaurERPsndStatistic.statistic_lvl Empcde,yymm, Read
grp,empnme,desn_cde,state,design
centaurdata.samples_stock p_cde,units,value,empcde,yymm Read
centaurERPmasters.prom_mst show_in_ereporting, ls_cde,ls_name Read
centaurERPmasters.prod_mst P_cde,p_name Read
centaurdata.mobile_dfrmain empcde,dfrdate, Read
ww1,ww2,from1,from2,
to1,to2,STATUS,type1,type2,
centaurdata.mobile_dfrdrs empcde,dfrdate, Read
drcode,me,yn,
ww_mgr,dfrtime,
dr_activity,
centaurdata.mobile_dfrbrands Dedtailed,dfrdate,empcde,drcode Read
centaurdata.mobile_detailing_products dr_type, dfrdate,empcde,drcode Read
centaurdata.mobile_dfrchemist Dfrtime, chemist, stkcde, Read
rcpa_drcode,dfrdate,empcde
centaurERPmasters.dist_mst Distnme,distcde Read
centaurdata.mobile_actuali workedwith1, workedwith2, Read
antec_other, from1,to1, from2,to2,
antectype1
centaurdata.mobile_actuali_drs drcode, dfrtime, corporate_drs, Read

detailing_ppc, input, input_units,
reason, automail_dept
centaurdata.mobile_inclinic drcode, activity, int Read
centaurdata.mobile_mgr_experience experience Read

centaur_mth_business, drcode,
mktg_feedback
centaurdata.mobile_vacancy vaccode, status, plan_fill Read
centaurdata.mobile_gap_observed sele_req, step_taken, your_decision Read
centaurdata.mobile_stockist stk_name, near_expairy, Read

high_inventary, plan_month
centaurdata.mobile_for_ho recommendation, campain_details, Read

auto_mail
PHP path/file mgr_comments.php

name,class,function…. main_class.php
mgr_comments_frame.php
mgr_comments_mobile.php
Process Flow MR’s REPORT :
Subordinates: Are derived from centaurERPsndStatistic.statistic_rep_mst for yymm as

current month and manager as logged in user. Exclude vacancy codes.
Sample Units : Sum of units from centaurdata.samples_stock where yymm = current month
and empcde= selected subordinate and left(p_cde,1) not equal to “S” and “L” and “G”.
Gift Units : Sum of units from centaurdata.samples_stock where yymm = current month and
empcde= selected subordinate and left(p_cde,1) equal to “G”
DFR Date : Report Date which is entered today.
Entered on : Today’s Date
WK1: ww1 field from centaurdata.mobile_dfrmain table.
WK2: ww2 field from centaurdata.mobile_dfrmain table.
Status: status field from centaurdata.mobile_dfrmain table.
From: from1-to1 fields from centaurdata.mobile_dfrmain table.
To : from2-to2 fields from centaurdata.mobile_dfrmain table.
Type : Type1 field from centaurdata.mobile_dfrmain table.
Each doctor code wise entry details are shown
Doctor Name: Take drcode from centaurdata.mobile_dfrdrs table for above dfrdate.
Take drname FROM centaurdata.drchart table for drcode. Check if this doctor’s geo
location is rectified in centaurERPcrm.rectify_latitude_longitude table. If record found then
show message “Rectified Entry updated by system”.
Morn Even: me field from centaurdata.mobile_dfrdrs table. M=Morning and E=Evening.
Indep.Work: yn, ww_mgr field from centaurdata.mobile_dfrdrs table. Y=Independent and

n=Joint work. ww_mgr field contains manager’s employee code with whom joint work is
done.
Time: dfrtime field from centaurdata.mobile_dfrdrs table for key drcode.
Activity: dr_activity field from centaurdata.mobile_dfrdrs table
Product wise details are shown for each doctor from centaurdata.mobile_dfrbrands
Table using key empcde+dfrdate+drcode
Brand Name: p_cde field from centaurdata.mobile_dfrbrands.

If first character of p_cde is “L” or “S” or “G” then take ls_name product name from
centaurERPmasters.prom_mst else take p_name from centaurERPmasters.prod_mst
RX Type: dr_type from centaurdata.detailing_products.
RX: rx from centaurdata.mobile_dfrbrands.
Sample: sampled from centaurdata.mobile_dfrbrands.
Detailed: detailed from centaurdata.mobile_dfrbrands.
After product wise details chemist and stockist details are shown.
Chemist / Stockist Name: Chemist field from centaurdata.mobile_dfrchemist.

Take stkcde from same table and take stockist name from centaurERPmasters.dist_mst
Table.
POB: pob field from centaurdata.mobile_dfrchemist.
RCPA: rcpa field from centaurdata.mobile_dfrchemist.
RCPA Units: rcps_units field from centaurdata.mobile_dfrchemist.
MANAGER”S REPORT
Subordinates: Are derived from centaurERPsndStatistic.statistic_rep_mst for yymm as

current month and manager as logged in user. Exclude vacancy codes.
Sample Units : Sum of units from centaurdata.samples_stock where yymm = current month
and empcde= selecsted subordinate and left(p_cde,1) not equal to “S” and “L” and “G”.
Gift Units : Sum of units from centaurdata.samples_stock where yymm = current month and
empcde= selected subordinate and left(p_cde,1) equal to “G”
DFR Date : Report Date which is entered today.
Entered on : Today’s Date
WK1: workedwith1 field from centaurdata.mobile_actuali table.
WK2: workedwith2 field from centaurdata.mobile_ actuali table.
Status: antec_other field from centaurdata.mobile_ actuali table.
From: from1-to1 fields from centaurdata.mobile_ actuali table.
To : from2-to2 fields from centaurdata.mobile_ actuali table.
Type : antectype1 field from centaurdata.mobile_ actuali table.
Call Entry : Doctor wise details are shown from centaurdata.mobile_actuali_drs table.
Rectified entries are shown from centaurERPcrm.rectify_latitude_longitude table. Fields
taken are as follows:
Doctor Name – code : Field drcode . Take drname from centaurdata.drchart for doctor
name
DFR Time : dfrtime
CorpoDr : corporate_drs
Detailing PCC : detailing_ppc
Input Name : input. Take product name from centaurERPmasters.prom_mst table.
Unit Given : input_units
Non Rxers Reason : reason
Non Rxers Automail : automail_dept
In Clinic : In clinic details are shown from centaurdata.mobile_inclinic table. Fields taken
are as follows:
Doctor Name – code – Field drcode . Take drname from centaurdata.drchart for doctor
name
Activity- activity
In Clinic Interaction- inc_int
Experience & Lesson : experience_box field from centaurdata.mobile_mgr_experience

Table.
Today's Work : Details are taken from centaurdata.mobile_todays_work table. Field names
are as follows:
Chemist Name : chemist_name
Pob : chemist_pob
Mthly Business of Counter : chemist_mth_business
Centaur Monthly Business : centaur_mth_business
RCPA Doctor : drcode Take drname from centaurdata.drchart for doctor name
MKTG Feedback : mktg_feedback
Vacancy : Details are taken from centaurdata.mobile_vacancy table. Fields used are as
follows:
vacancy Code & Name : vaccode
Status : status
Planning to Fill : plan_fill
Gap Observed : Details are taken from centaurdata.mobile_gap_observed Table. Fields

used are as follows:
Details : sele_req
Stapes taken by Manager on evidence: step_taken
Your Decision: your_decision
Stockiest Details : Details are taken from centaurdata.mobile_stockist Table. Fields used
are as follows:
Stockist Name : stk_name
Near Expairy Brand: near_expairy. Take product short name from
centaurERPmasters.prod_mst table.
High Inventory Product: high_inventary. Take product short name from
centaurERPmasters.prod_mst table.
Plan for the month : plan_month
For HO : Details are taken from centaurdata.mobile_for_ho table. Fields used are as
follows:
Recommendation for HO followup give DR details : recommendation
Campaign/support from HO : campain_details
Auto Mail : auto_mail
Details
Sequence No. 13
Screen Name TP Approval & View (MR)
Purpose To approve MR’s tour plan
Determines
Screen-shot
Input size, type, Select employee: combo employee code (char 4) , employee name (char
validation 30),year/month (char 6),cummulatiove achievement (int 12.00)
Date combo (DD/MM/YYYY)
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
Type combo (char 4)
Aimed for Conversion text box integer 2
Prev button
Next button
Save button
Approve button
Dependency Dfr Entry

Connectivity
Database.Table used
centaurERPsndStatistic.statistic_lvl Empcde,empnme,yymm, Read
access
desn_cde,design, state
centaurdata.tp Empl_code, tpdate, tpstatus, Read
tpfrom1,tpto1,
tptype1,tpfrom2,
tpto2,tptype2,
tpmanager1,tpmanager2,
tpworktype,
aimedconv,locked
centaurERPmasters.statistic_runctl yyyy,chr_month Read
centaurERPsndAnalysis.statistic_fieldforce Cumach, yyyy,empcde, Read

login_id
centaurERPsndStatistic.statistic_emp_mst dt_joining,empcde, Raad
centaurERPadmin1819.holiday Holidate, state Read
centaurERPleave.leave_transactions empl_cd,applied_date, Read

leave_from, leave_to,
application_type,
late_mark_entry,
encashment_entry
centaurdata.farechart Empcde,basetown,desttown, Read
dist_km
centaurERPsnd.month_close Yyyy Read
centaurdata.km_for_tp Km_1,showkm,hqworking, yyyy Read

empcde
centaurdata.users_status statustype Read
centaurERPsndStatistic.statistic_rep_mst manager,grp, yymm,empcde Read

tpmanager1, tpmanager2,
tpstatus
PHP path/file tp_mgr_screen.php

name,class,function…. tp_mgr_frame.php
mobile_mgr_tpapprove.php
Process Flow If MR tour plan is approved by manager then only View is available to manager.
Before approve MR Tour Plan Manager can make necessary changes in MR tour plan
If Manager made changes in MR tour plan then same process/logic applicable which
is shown in MR tour plan in GPS based M-reporting Documentation – MR.doc sequence
No. 14
If Manager clicks on Approve button records are saved in following table.

tpstatus "1" Update
centaurdata.tp tpapprovedby login id Update
tpapproveddate server date Update
Details
Sequence No. 14
Screen Name TP Entry, Approval & View (MGR)
Purpose
Determines
Screen-shot Screen 1 Screen 2
Input size, type, Select Month combo yyymm (char 6)

validation Select employee combo empcde(char 4), employee name (char 30),designation (char 4)
[Edit] button
Status combo
Plan with 1 combo
Plan with 2 combo
Place from 1  to 1 combo
Place from 2  to 2 combo
Search DR Name 1 text box (char 10)
Search doctor name 1 combo doctor name (char 151), doctor code (char 10), empcde
(char 4)
Remark 1 text box (char 200)
Search DR Name 2 text box (char 10)
Search doctor name 2 combo doctor name (char 151), doctor code (char 10), empcde
(char 4)
Remark 2 text box (char 200)
Type combo (char 10)
Save Button
Dependency MGR Tour Plan.

Connectivity DFR entry
Database.Table used
centaurERPsndStatistic.statistic_lvl empcde,grp,design, yymm, Read
access
empnme,hq, desn_cde
centaurERPmasters_new.month_close Yymm, to_dates Read
centaurdata.farechart Empcde,basetown,desttown, Read

Fw_nfw
centaurERPpayroll.candidate repl_empl_cd,empl_cd Read
centaurERPsndStatistic.statistic_vf Fillcode, vaccode, yymm Read
centaurdata.tpmgr tpstatus,tp_submited, Read

empl_code, tpdate,
tpapprovedby,
tpapproveddate,
tpstoredate,
tp_submited_date,
tpworktype, tpmanager1
ww1, tpfrom1, tpto1, $from1
$to1, tpmanager2, ww2,
tpfrom2
tpto2, $from2, $to2, tptype1
tptype2, tpdevapvdate
drcode1, drcode2
dr1_remark,dr2_remark,
deviated_to1,deviated_type1
deviated_from2,deviated_to2
deviated_type1,
deviated_tpworktype
deviated_ww1,deviated_ww2
dev_ww1,dev_ww2
centaurERPmasters.statistic_runctl Yymm, chr_months Read
centaurERPadmin1819.holiday holidate,state Read
centaurERPleave.leave_transactions empl_cd,applied_date, Read

leave_from, leave_to,
application_type,
late_mark_entry,
encashment_entry
centaurdata.drchart drname,drcode Read
entaurdata.users_status statustype Read
centaurERPsndStatistic.statistic_vf Fillcode, vaccode, yymm Read
centaurERPsndAnalysis.statistic_fieldforce Cumach, yyyy,empcde,

login_id
PHP path/file tp_class.php
name,class,function…. mobile_mgr_tp.php
Process Flow Manager can enter his tour plan or approve his subordinates Tour plan.
Self and direct reporting subordinates are shown in employee combo for selection.
SUNDAY and HOLIDAY‘s are freeze in Tour Plan.
HOLIDAY are derived from holiday master . State wise holiday list
available in centaurERPadmin1819.holiday table
if tpstatus=0 in centaurdata.tpmgr table then system should not allow to approve the
Tour Plan. Alert message (“TP Not Yet Submitted”);
If tp_submited=’N’ in centaurdata.tpmgr table then system should not allow to approve the
Tour Plan. Alert message (“TP Not Yet Submitted”);
If tpstatus=1 in centaurdata.tpmgr table then message to subordinate “ TP Not Approved”
If tpstatus=2 in centaurdata.tpmgr table then message to subordinate

“TP Approve by ___ Name _______on ______”
After approving tour Plan or Submission of Tour Plan automail goes to upper manager.
Data store in following table.

s
if SUNDAY or HOLIDAY, Record insert into centaurdata.actuali
Table Field
Name
empcde login id Insert/Update
antec_date dfr date Insert/Update
storedate server date Insert/Update
antec_other SUNDAY or HOLIDAY Insert/Update
centaurdata.actuali
remarks "'Entered through TP" Insert/Update
antectype1 “HQ” Insert/Update
antectype2 “HQ” Insert/Update
STATUS "1" Insert/Update
Table Field
Name
empl_code Selected employee Insert
tpdate selected by user Insert
tpfrom1 selected by user Insert
tpto1 selected by user Insert
tpfrom2 selected by user Insert
tpto2 selected by user Insert
tptype1 selected by user Insert
tptype2 selected by user Insert
tpmanager1 selected by user Insert
centaurdata.tpmgr
tpmanager2 selected by user Insert
tpworktype selected by user Insert
tpstoredate selected by user Insert
locked if late TP entry then "Y" Insert
tpanalysis_over Insert
drcode1 selected by user Insert
drcode2 selected by user Insert
dr1_remark selected by user Insert
dr2_remark selected by user Insert
Details
Sequence No. 15
Screen Name TP Deviation – Under Process
Purpose
Determines
Screen-shot
Input size, type,
validation
Dependency
Connectivity
Database.Table used
access
PHP path/file
Process Flow
Details
Sequence No. 16
Screen Name TP Deviation Approval (MR)– Under Process
Purpose
Determines
Screen-shot
Input size, type,
validation
Dependency
Connectivity
Database.Table used
access
PHP path/file
Process Flow
Details
Sequence No. 17
Screen Name TP Deviation Approval (MGR)– Under Process
Purpose
Determines
Screen-shot
Input size, type,
validation
Dependency
Connectivity
Database.Table used
access
PHP path/file
Process Flow
Details
Sequence No. 18
Screen Name Dr Info.
Purpose To view doctor details and activity related information.
Determines High/low potential doctors
Screen-shot
Input size, type, Doctor combo char(150)

validation
Dependency
Connectivity
Database.Table Fields Access
centaurdata.farechart_doctor_relation empcde,yymm,drcode,baset Read
used with
own,desttown
read,write,view centaurdata.drchart drcode,drname,hcname,hca Read
access ddline1,hcaddline2,hcaddline
3.dr_town,dr_city,patients,stat
e,pin,
birth_day,birth_mth,birth_year,
anniv_day,anniv_mth,anniv_y
ear,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_booki guest_house,bookdt_from,bo Read

ng okdt_to, drcode,
approval3_by, reject_yes_no,
cancel_booking
PHP path/file doctor_screen.php

name,class,function doctor_screen_display.php
….
Process Flow On selecting DR.Info from dropdown and then clicking on doctor combo doctors list
related to MGR who has logged in is displayed based on centaurdata.drchart.
All doctor related information shown here e.g. p1,p2,p3,CME,CPR,DR.Activitis,Last three

visits,Opportunity brands,etc…
Add : hcname, hcaddline1, hcaddline2, hcaddline3, dr_town, dr_city

DOB : birth_day,birth_mth,birth_year
DOA : anniv_day,anniv_mth,anniv_year
P1: patients
P2: value_pm
Rx:
L3 Visits: dfrdate
CME: cme_id,cme_date
Act: activity_id,pre_entered_date
CPR: cpr_id, conf_fdate
Visit: v_pattern
Opportunity:p_shrt
Guest House Booking : guest_house,bookdt_from,bookdt_to
Details
Sequence No. 19
Screen Name Conversions Under You
Purpose To view conversion details.
Determines Doctor Started Prescribing Centaur’s Brand
Screen-shot

validation
Dependency -
Connectivity -
Database.Table Fields Access

centaurERPsndStatistic.statistic_rep_ empcde,hq,manager, grp Read
used with
mst
read,write,view centaurdata.detailing_products empcde,drcode,p_cde,dfrdate, Read
access dr_type,m5_rx_qty, app_rej
centaurERPsndStatistic.statistic_lvl Empnme Read
centaurdata.drchart drname Read
centaurdata.detailing_products p_cde,empcde, Read
dfrdate,drcode, dr_type
centaurERPmasters.prod_mst p_shrt,p_cde Read
centaurFieldMatrix.matrix_br p_cde,p_shrt,opportunity_open, Read
MONTH, YEAR, empcde,
drcode, p_cde
PHP path/file mgr_conversion.php

name,class,function
….
Process Flow By selecting this option, manager can view conversions mentioned by his subordinates
in their reports in last 3 days and which are still not approved by mangers.
Take subordinates from centaurERPsndStatistic.statistic_rep_mst table and then show

conversion details of these subordinates from centaurdata.detailing_products as
follows :
DFR dt : day/month of dfrdate

Name : empcde
Dr.Name & P3 Brand : drcode & p_cde
Opp Oppnd on : opportunity_open
Conv/Defc : dr_type
Brand Selected By MR : p_cde
Need To Confirm by Date : dfrdate + 3 days
Details
Sequence No. 20
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_mgr_stock.php
name,class,function
….
Process Flow Show Product wise Units in stock.
Details
Sequence No. 21
Screen Name Expense Details
Purpose To View monthly expense details.
Determines Monthly expenses
Screen-shot

validation
Dependency -
Connectivity -
Database.Table used Tables Fields Access
centaurERPmasters.statistic_runctl Yymm,chr_month Read
centaurERPadmin1819.expmandt ext_cde, received_date Read
access centaurERPadmin1819.expenses Empcde,yymm, ext_cde, Read
entry_type, month,year,
approveddate, clexpenses,
mgrexpenses, fin_exp, touradv,
hopmt_tadvance, pay_mark,
chqddno, chqdddt
PHP path/file mobile_mgr_expense.php

name,class,function
….
Process Flow Last 5 months expense details are shown with HO approved amount, cheque/DD number
and date.
Details
Sequence No. 22
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.
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.
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. 23
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 - MGR

Uploaded by

Copyright:

GPS Based M-Reporting Documentation - MGR

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 - MGR

Uploaded by

Copyright:

Centaur Pharmaceuticals Pvt Ltd

Mobile number Registration process.

Table Name Table Field Name Input Field Remarks

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

Details Not applicable

Input size, type, Click buttons are provided.

Dependency Not applicable

Input size, type, Not applicable

centaurERPsnd.empl_status wef_status,empcde Read

PHP path/file Mobile_mgr_dfr.php

Vacancy under him is not filled for more than 40 days. –

TP is not entered. – If record not found in centaurdata.tpmgr table

Comments on Subordinate’s report are not entered – If comment field from

Sample Consignments not confirmed : If consignment found

Company Property Format - Take vacancy codes under manager.

centaurFieldFormats.leaving_emp table. If not found in this table then check in

Update family details for Mediclaim purpose. – First check Login ID in

Enter Manager To-Do List – Check record for Logged in User in

Input size, type, Not Applicable

PHP path/file mobile_mgr_dfr.php

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

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

Mobile : mobile_no field from centaurdata.mobile_no table

JT Work 1 and 2: tpmanager1,tpmanager2 fields from centaurdata.tpmgr table.

Input size, type, Not Applicable

Sequence No. 6 continue….

Dependency GPS needs to be active

Connectivity With next screen of report entry.

centaurERPcrm.rectify_latitude_longit Drcode,empcde, login_by, Read

centaurFieldMatrix.matrix_br p_cde,p_shrt,opportunity_op Read

PHP path/file mobile_mgr_dfr.php

On selecting subordinate, full doctor list will appear of selected subordinate. If

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

Input : Product name is taken from centaurERPmasters.prod_mst (key : p_cde)

P3 Brand Approval/Rejection Screen : Conversions or Defection mentions by any

In this entry screen Automail selection is compulsory.

Table Name Table Field Name Input Field Remark

empcde Login ID Insert

If user is saving Doctor Call

Meter difference between

accuracy User's current Accuracy Insert

Table Name Table Field Name Input Field Remark

Table Name Table Field Name Input Field Remark

Table Name Table Field Name Input Field Remark

Sequence No. 6 continue….

PHP path/file Inclinic.php

Following tables are use

Sequence No. 6 continue….

Table Name Table Field Name Input Field Remark

Sequence No. 6 continue….