hrms_masters (4).sql
114 KB
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
-- phpMyAdmin SQL Dump
-- version 4.5.3.1
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Apr 28, 2017 at 09:55 AM
-- Server version: 10.0.28-MariaDB
-- PHP Version: 5.6.29
SET SQL_MODE = "NO_AUTO_VALUE_ON_ZERO";
SET time_zone = "+00:00";
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8mb4 */;
--
-- Database: `fullerton_flexydial`
--
-- --------------------------------------------------------
--
-- Table structure for table `hrms_masters`
--
CREATE TABLE `hrms_masters` (
`mkey` varchar(200) COLLATE utf8_unicode_ci NOT NULL,
`mtype` varchar(100) COLLATE utf8_unicode_ci NOT NULL,
`mvalue` longtext COLLATE utf8_unicode_ci NOT NULL,
`mid` int(11) NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci;
--
-- Dumping data for table `hrms_masters`
--
INSERT INTO `hrms_masters` (`mkey`, `mtype`, `mvalue`, `mid`) VALUES
('Campaign One', 'company', 'monthworkdays~|agencyfeesvalue~|agencyfeefunction~|contractstartdate~|contractenddate~|insurancerequired~|servicedby~|contactname~|contactemail~|contactphone~|hrsendfiles~bnVsbA==|contactnameacct~|contactemailacct~|contactphoneacct~|offerletter~|confirmationletter~|promotionletter~|appraisalletter~|warningletter~|terminationletter~|nocletter~|experienceletter~|endofserviceletter~|yrmeternityleaves~|yrsickleaves~|yrannualleaves~|yemaxcarryleaves~|developerparam~RGlhbGVyRElEPTIyMzA1NTc0MDU6MQ==|trackerfields~|campaignscript~|', 1);
INSERT INTO `hrms_masters` (`mkey`, `mtype`, `mvalue`, `mid`) VALUES
('appvars', 'coreconfig', 'HRFiledsStr=currentstatus:L:Customer Status:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info~1:21:::644::,legalstatus:L:Group Status:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::,firstname:L:Customer Name:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::,clientcode:L:Cust ID:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::664::,clientinternalid:L:Group ID:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::,status:L:Status:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::,priority:L:Priority:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::,ucic_id:L:UCIC ID:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::,Unit:L:Unit:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::,STATUS:L:Status:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::,GROUP_CORR:L:Group Correct:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::,DOB:L:DOB:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::,age:L:Age:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::,mobile:L:Mobile:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::,altphone1:L:Office Phone:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::,altphone2:L:Res Phone:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::,emailid:L:Email:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::,Product1:L:TOP 3 PROD RECO 1:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::,Product2:L:TOP 3 PROD RECO 2:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::,Product3:L:TOP 3 PROD RECO 3:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info~0:21:::644::,DR_CR_TAG:L:DR / CR Status:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Liability~2:22:::644::,TOT_CHQ_IND:L:Total Month Chq Ind:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Liability:22:::644::,TOT_CHQ_NONIND:L:Total Month Chq Non Ind:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Liability:22:::644::,TOT_SELF:L:Total Month Chq Self:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Liability:22:::644::,TOT_CR:L:Total Month Credit:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Liability:22:::644::,TOT_DR:L:Total Month Debit:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Liability:22:::644::,TOT_EMI_OUT:L:Total Month EMI:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Liability:22:::644::,TOT_INVST_OUT:L:Total Month Invest Out:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Liability:22:::644::,TOT_UTL_OUT:L:Total Month Utility Out:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Liability~0:22:::644::,ATM_active:L:ATM Active:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products~2:22:::644::,atm_usage:L:ATM Usage:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products:22:::644::,bp_act_tag:L:Bill Pay Act:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products:22:::644::,BP_REG_ora:L:Bill Pay Reg:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products:22:::644::,Chillr:L:Chillr:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products:22:::644::,db_tag:L:DB Status:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products:22:::644::,dc_offer:L:DC Offers:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products:22:::644::,pos_status:L:DC POS Status:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products:22:::644::,dc_type:L:DC Type:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products:22:::644::,DC_billpay_tag:L:DCBill Pay Act:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products:22:::644::,directpay_billpay_tag:L:Direct Bill Pay Act:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products:22:::644::,FD_Status:L:FD:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products:22:::644::,IVR_active:L:IVR Active:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products:22:::644::,nboff:L:NB Migration:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products:22:::644::,NB_REG:L:NB Reg:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products:22:::644::,NB:L:NB Status:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products:22:::644::,payzap:L:Payzapp Status:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products:22:::644::,wallet:L:Payzapp Wallet:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products:22:::644::,pref_action:L:PDC Eligibilty:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products:22:::644::,Perks:L:Perks:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products:22:::644::,Si:L:SI Status:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products:22:::644::,SSS:L:SSS:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Digital Products~0:22:::644::,AL_CAR_CASH:L:AL CNC:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets~2:22:::644::,AL_PRE_AMT:L:AL Preapproved:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets:22:::644::,al_upgrade:L:AL Upgrade:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets:22:::644::,decile_AL_CA_var:L:AL- CA- High Propen.:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets:22:::644::,decile_AL_CSA_var:L:AL- CSA- High Propen.:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets:22:::644::,decile_AL_SA_var:L:AL- SA- High Propen.:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets:22:::644::,BL_PRE_AMT:L:BL Preapproved:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets:22:::644::,decile_BL_var:L:BL- High Propen.:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets:22:::644::,CE_SEGMENT_var:L:CE- High Propen.:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets:22:::644::,EDU_SEGMENT_var:L:EDU-High Propen.:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets:22:::644::,decile_EEG_var:L:EEG - High Propen.:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets:22:::644::,Jwel:L:GL Basis Spend:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets:22:::644::,decile_GoldLoan_var:L:GL-High Propen.:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets:22:::644::,hl_bt_amt:L:HL BT Preapproved:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets:22:::644::,HL_PRE_AMT:L:HL Preapproved:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets:22:::644::,decile_HL_CSA_var:L:HL- CSA- High Propen.:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets:22:::644::,decile_CVL_var:L:HL- CVL- High Propen.:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets:22:::644::,decile_HL_SA_var:L:HL- SA- High Propen.:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets:22:::644::,LAP_PRE_AMT:L:LAP Preapproved:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets:22:::644::,PL_PAPERLESS_AMT:L:PL Paperless:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets:22:::644::,PL_PRE_AMT:L:PL Preapproved:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets:22:::644::,decile_PL_CSA_var:L:PL- CSA- High Propen.:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets:22:::644::,TWL_PRE_AMT:L:TWL Preapproved:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Assets~0:22:::644::,BLOCK:L:CC Block:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Credit Card~2:22:::644::,prod2:L:CC Holding:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Credit Card:22:::644::,APT:L:CC Holding / Eligible:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Credit Card:22:::644::,ACT_STATUS:L:CC Status:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Credit Card:22:::644::,STATEMENT_DETAILS:L:CC Stmt Details:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Credit Card:22:::644::,COC_ELIGI:L:COC Eligible:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Credit Card:22:::644::,decile_CC_CASA_var:L:HL- CASA- High Propen.:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Credit Card:22:::644::,JET_XSELL:L:JET Eligible:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Credit Card:22:::644::,LAST_TXN_POS_DATE:L:Last POS Txn:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Credit Card:22:::644::,LE_ELIG:L:LE Eligible:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Credit Card:22:::644::,SMPAY_ACTIVE:L:SP Active:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Credit Card:22:::644::,SMPAY_REGD:L:SP Regd:Customer Info:Customer Info - {{client}} {{dialer_flag}}:Credit Card~0:22:::644::,CBDT:L:CBDT:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others~2:22:::644::,NO_OF_SCRIPTS:L:Demat Script Nos:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,SCRIPT_VALUE:L:Demat Value:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,decile_demat_casa_var:L:Demat-CASA-High Propen.:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,rf_offer:L:Forex Eligibity:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,MEdical:L:GI Basis Spend:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,cc_auto:L:GI Motor Basis CC:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,dc_auto:L:GI Motor Basis DC:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,HSL:L:HSL:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,decile_Ins_CASA_var:L:Ins - CASA -High Propen.:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,child:L:Ins - CASA Basis Spend:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,decile_Ins_pen_var:L:Ins - PEN -High Propen.:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,motor_insurance:L:Ins GI Motor:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,LAS_PRE_AMT:L:LAS Preapproved:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,decile_las_mf_var:L:LAS- DEMAT High Propen.:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,decile_LAS_Demat_var:L:LAS- DEMAT High Propen.:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,li_cover:L:Life Ins Cover Suggestion:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,LIFE_INSU_PREMIUM_AMT1:L:Life Ins Prem Amt:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,LI_PLan_Prio:L:Life Ins Propensity:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,decile_MF_var:L:MF:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,mf_isa:L:MF ISA:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,mf_las_limit:L:MF LAS Preapproved:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,MF_LUMSUM_AMT:L:MF Lumpsum Amt:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others:22:::644::,MF_SIP_AMT:L:MF SIP Amt:Customer Info:Customer Info - {{client}} {{dialer_flag}}:TPP & Others~0:22:::644::,genericfilename:L:Generic Upload Name:::::::664::,genericfileselect:F:Generic Upload File:::::::664::,status:L:Record Status:::::::600::,workflowstatus:L:Workflow Status:::::::600::,client:S:PB Code:::::::666::PDH02~PDH05~PDH12~PDH17~PDH18~PDH19~PDL05~PDL20~PDL22~PDL29~PDL30~PDL35~PDL40~PDL41~PDL44~PDL47~PDL51~PDL53~PDL59~PDL69~PDL80~PDL81~PDL87~PDL93~PDL97~PDL99~PDL31~PDL43~XYZ1,dialer_flag:::::::::666::VIP~Normal,id:::::::::666::\n\n\n\n\n\nemprecordScripts=\n\n\n\n\nDEVELOPER=SiddharthUpmanyu\n[email protected]\n\nRequiredFiles=\nRequiredDates=birthdate,joiningdate\nRequiredSelect=client\nRequiredText=firstname,mobile,emailid,salbasic,saltotal\nRequiredExpiry=\nRequiredExpiryTasks=\nRequiredApproval=\nRequiredApprovalDocs=\nmissingSanityReport=Yes\n\ngsmtpserver=smtp.gmail.com\ngsmtpport=465\n[email protected]\ngsmtppass=mlfxrqenwoaoyqxn\n[email protected]\ngfromname=Buzzworks-HR\ngsslstr=ssl\ngpopserver=pop.gmail.com\ngpopport=995\ngpopssl=ssl\n\nappcustomer=Buzzworks\nExternal_URL=http://buzzworks.kstych.com/\ncolorcodes=VIP:blue,BlackListed:red\nhrdocstab=offerletter,confirmationletter,promotionletter,appraisalletter,warningletter,terminationletter,nocletter,experienceletter,endofserviceletter\nDashboardShowOtherEmp=no\n\nhrTriggerHoldStatus=Candidate\nhrlivestatus=Candidate,Absconding,Doc Pending,Drop Out,Hold,New Recruit,Resigned,Terminated,Working\nhrrecruitstatusesNW=Candidate,Doc Pending,Hold,New Recruit\nhrrecruitstatuses=Candidate,Doc Pending,Hold,New Recruit,Working\nhrworkingstatus=Working\nhrdeadstaruses=WF_System_Exit\nhrexitstatuses=Absconding,Drop Out,Resigned,Terminated\nsystemExitStatus=WF_System_Exit\n\nAppOwnerUser=Prakash\nAppOwnerUserName=Prakash\nHRManagerUsers=\nHRManagerUsers2=\nCRMManagerUsers=Prakash\nAccountManager=Prakash\nleavesadmin=Prakash\n[email protected]\nselfservicecc=\n[email protected]\nCRMLeadUpdateMail=\nCRMLicenseUpdateMail=\nRecruitmentMailCC=\nHRExclusiveClients=Buzzworks\n\nHRDailyExitMail=\nRecMonthlyMail=\nCRMBirthdayMail=\n\nextrasalaryheads=Expense,Incentive,Insurance,PayoutAddition,PayDeduction,Extra,Pension,Accrual_Benefits,Annual_Benefits,Airfare,Gratuity,Bonus,Leave_Salary_Accrual,Overheads,Medical_and_Life,EOSB\nacctactive=Working,Resigned,Terminated\nsaloverwritemonths=6\naccountReportHeader=Buzzworks Business Services Private Limited|Door No. 21, First Floor, Balaji Avenue 1st Street, T. Nagar, Chennai - 600017|Tel :044-42629189 www.buzzworks.com|Service Tax NO:AACCB8364PST001, CIN NO: U74999TN2006PTC059363, PAN NO:AACCB8364P\naccountPayoutRMap=srno,Sl no,|buzzworkscode,Buzzworks code,|clientcode,Client Code,|fullname,Name,|city,Work location,|thisnetsalary,Net Salary,sum|ibannumber,Bank Account|bankname,Bank Name|ifsccode,IFSC Code\naccountPayoutIncRMap=srno,SrNo,|id,ID,|clientcode,HR Code,|fullname,Name,|vcompacct,Comp Ac No,|laborcardpersonalid,PersonalID,|bankcode,Bank Code,|bankaccountnumber,Account No,|ibannumber,IBAN Number,|thisincentive,Incentive,sum|thisincentiveremarks,Incentive Remarks,|thisremarks,Remarks,\naccountPayRMap=srno,Sl no,|buzzworkscode,Buzzworks code,|clientcode,Client Code,|fullname,Name,|designation,Designaton,|supervisor,Reporting manager,|city,Work location,|costcentercode,Cost centre code,|joiningdate,DOJ,|currentstatus,Status,|servicestoppeddate,DOL,|thisgross,Gross salary,sum|thisbasic,Basic,sum|thishouse,HRA,sum|saltransport,Conveyance,sum|gross-012,Other,sum|monthtotaldays,Month Total Days,|thisworkdays,Present days,|prorbasic,ProRata Basic,sum|prorhra,ProRata HRA,sum|prorconveyance,ProRata Conveyance,sum|prorgross-012,ProRata Other,sum|prorgross,Earned Gross,sum|pfEmployee,PF Employee Contribution,sum|esicEmployee,Esic Employee Contribution,sum|lwfEmployee,LWF Employee,sum|ptEmployee,Professional Tax,sum|thisdeductions,Total Deductions,sum|thisadditions,Total Additions,sum|thisnetsalary,Net Salary,sum|pfEmployer,PF employer,sum|esicEmployer,ESIC employer,sum|lwfEmployer,LWF Employer,sum|ctcindia,Total CTC,sum|thisagencyfee,Service Fee,sum|india_st,Service Tax,sum|india_stcess,Swach bharath cess,sum|india_gtotal,Grand Total,sum\naccountPayIncRMap=srno,SrNo,|id,ID,|clientcode,HR Code,|fullname,Name,|gender,Gender,|nationality,Nationality,|payrollgroup,Payroll Group,|bankcode,Bank Code,|ibannumber,IBAN Number,|designation,Designation,|joiningdateDMY,Joining Date,|thisincentive,Incentive,sum|thisincentiveremarks,Incentive Remarks,|thisremarks,Remarks,\n\nkAccountRounding=0\n\nsalslip_title=BUZZWORKS BUSINESS SERVICES PVT LTD CRLF#21,1st Floor Thirumalai Pilli Rd T Nagar Chn-17\nsaltoplines=Employee ID|id|Department|department,Name|firstname-lastname|Designation|designation,Bank|bankname|AccountNo|ibannumber,PF No|pfnumber|ESIC No|esicnumber,UAN No|uannumber|Joining Date|joiningdate\nsalslipannll=0\nsalslipsickl=0\nshownonpaydays=0\n\nWF_Candidate=offerletteraccepted\nWF_OfferLetter=currentstatus,firstname,gender,birthdate,mobile,emailid,qualification,client\nWF_DOJ=joiningdate\nWF_Salary=saltotal\nWF_Insurance=insurancetype\nWF_Medical=\nWF_BankAcct=ibannumber\n\nWF_ServiceStop=servicestoppeddate,resigntermletter\nWF_Exit=dateofexit\nWF_Absconding=abscondtype,abscondeddate,abscondednote\n\nWFGroup_OnboardingNW=Candidate,OfferLetter,DOJ,Salary\nWFGroup_Onboarding=Candidate,OfferLetter,DOJ,Salary,Insurance,Medical,BankAcct\nWFGroup_Exiting=ServiceStop,Exit,Absconding\n\n\n\n\nPTSTR_Andhra Pradesh=0-15000|0,15001-20000|150,20001-X|200\nPTSTR_Arunachal Pradesh=\nPTSTR_Assam=0-3500|0,3501-5000|30,5001-7000|75,7001-9000|110,9001-X|208\nPTSTR_Bihar=\nPTSTR_Chhattisgarh=\nPTSTR_Goa=\nPTSTR_Gujarat=0-6000|0,6001-9000|80,9001-12000|150,12001-X|200\nPTSTR_Haryana=\nPTSTR_Himachal Pradesh=\nPTSTR_Jammu and Kashmir=\nPTSTR_Jharkhand=\nPTSTR_Karnataka=0-14999|0,15000-X|200\nPTSTR_Kerala=0-2000|0,2001-3000|20,3001-5000|30,5001-7500|50,7501-10000|75,10001-12500|100,12501-16667|125,16668-20833|167,20834-X|208\nPTSTR_Madhya Pradesh=0-15000|0,15000-X|208\nPTSTR_Maharashtra=0-5000|0,5001-10000|175,10001-X|200-200-300-200-200-200-200-200-200-200-200-200-200\nPTSTR_Manipur=\nPTSTR_Meghalaya=\nPTSTR_Mizoram=\nPTSTR_Nagaland=\nPTSTR_Odisha=0-13333|0,13334-25000|125,25001-X|200-200-200-300-200-200-200-200-200-200-200-200-200\nPTSTR_Punjab=\nPTSTR_Rajasthan=\nPTSTR_Sikkim=0-20000|0,20001-30000|125,30001-40000|150,40001-X|200\nPTSTR_Tamil Nadu=0-3500|0,3501-5000|17,5001-7500|39,7501-10000|85,10001-12500|127,12501-X|183\nPTSTR_Tripura=\nPTSTR_Uttar Pradesh=\nPTSTR_Uttarakhand=\nPTSTR_West Bengal=0-8500|0,8501-10000|90,10001-15000|110,15001-25000|130,25001-40000|150,40001-X|200\nPTSTR_Telangana=\nPTSTR_Pondicherry=301-600|1,601-1200|2,1201-1800|4,1801-3000|6,3001-4800|12,4801-6000|25,6001-9000|50,9001-12000|75,12001-15000|100,15000-X|125\n\n\n\n\nLWFSTRER_Delhi=0-X|0-0-0-0-0-0-2.25-0-0-0-0-0-2.25\nLWFSTRER_Andhra Pradesh=0-X|0-0-0-0-0-0-0-0-0-0-0-0-5\nLWFSTRER_Arunachal Pradesh=\nLWFSTRER_Assam=\nLWFSTRER_Bihar=\nLWFSTRER_Chhattisgarh=0-X|0-0-0-0-0-0-45-0-0-0-0-0-45\nLWFSTRER_Goa=0-X|0-0-0-0-0-0-0-0-0-0-0-0-36\nLWFSTRER_Gujarat=\nLWFSTRER_Haryana=0-X|20\nLWFSTRER_Himachal Pradesh=\nLWFSTRER_Jammu and Kashmir=\nLWFSTRER_Jharkhand=\nLWFSTRER_Karnataka=0-X|0-0-0-0-0-0-0-0-0-0-0-0-12\nLWFSTRER_Kerala=0-X|5\nLWFSTRER_Madhya Pradesh=0-X|0-0-0-0-0-0-30-0-0-0-0-0-30\nLWFSTRER_Maharashtra=\nLWFSTRER_Manipur=\nLWFSTRER_Meghalaya=\nLWFSTRER_Mizoram=\nLWFSTRER_Nagaland=\nLWFSTRER_Odisha=\nLWFSTRER_Punjab=0-X|4\nLWFSTRER_Rajasthan=\nLWFSTRER_Sikkim=\nLWFSTRER_Tamil Nadu=0-X|0-0-0-0-0-0-0-0-0-0-0-0-20\nLWFSTRER_Tripura=\nLWFSTRER_Uttar Pradesh=\nLWFSTRER_Uttarakhand=\nLWFSTRER_West Bengal=0-X|0-0-0-0-0-0-6-0-0-0-0-0-6\nLWFSTRER_Telangana=\nLWFSTRER_Pondicherry=\nLWFSTRER_Chandigarh=0-X|2\nLWFSTREE_Delhi=0-X|0-0-0-0-0-0-0.75-0-0-0-0-0-0.75\nLWFSTREE_Andhra Pradesh=0-X|0-0-0-0-0-0-0-0-0-0-0-0-2\nLWFSTREE_Arunachal Pradesh=\nLWFSTREE_Assam=\nLWFSTREE_Bihar=\nLWFSTREE_Chhattisgarh=0-X|0-0-0-0-0-0-15-0-0-0-0-0-15\nLWFSTREE_Goa=0-X|0-0-0-0-0-0-0-0-0-0-0-0-12\nLWFSTREE_Gujarat=0-X|0-0-0-0-0-0-3-0-0-0-0-0-3\nLWFSTREE_Haryana=0-X|10\nLWFSTREE_Himachal Pradesh=\nLWFSTREE_Jammu and Kashmir=\nLWFSTREE_Jharkhand=\nLWFSTREE_Karnataka=0-X|0-0-0-0-0-0-0-0-0-0-0-0-6\nLWFSTREE_Kerala=0-X|5\nLWFSTREE_Madhya Pradesh=0-X|0-0-0-0-0-0-10-0-0-0-0-0-10\nLWFSTREE_Maharashtra=0-X|0-0-0-0-0-0-12-0-0-0-0-0-12\nLWFSTREE_Manipur=\nLWFSTREE_Meghalaya=\nLWFSTREE_Mizoram=\nLWFSTREE_Nagaland=\nLWFSTREE_Odisha=\nLWFSTREE_Punjab=0-X|2\nLWFSTREE_Rajasthan=\nLWFSTREE_Sikkim=\nLWFSTREE_Tamil Nadu=0-X|0-0-0-0-0-0-0-0-0-0-0-0-10\nLWFSTREE_Tripura=\nLWFSTREE_Uttar Pradesh=\nLWFSTREE_Uttarakhand=\nLWFSTREE_West Bengal=0-X|0-0-0-0-0-0-3-0-0-0-0-0-3\nLWFSTREE_Telangana=\nLWFSTREE_Pondicherry=\nLWFSTREE_Chandigarh=0-X|1\nMINWEDGES_Delhi=HighlySkilled-11986,Skilled-10998,SemiSkilled-10010,UnSkilled-9048\nMINWEDGES_Andhra Pradesh=HighlySkilled-9679,Skilled-8642,SemiSkilled-8224,UnSkilled-7822\nMINWEDGES_Arunachal Pradesh=\nMINWEDGES_Assam=\nMINWEDGES_Bihar=HighlySkilled-7826,Skilled-6422,SemiSkilled-5278,UnSkilled-5044\nMINWEDGES_Chhattisgarh=HighlySkilled-X,Skilled-6299,SemiSkilled-5969,UnSkilled-5787\nMINWEDGES_Goa=HighlySkilled-X,Skilled-7774,SemiSkilled-7488,UnSkilled-7514\nMINWEDGES_Gujarat=HighlySkilled-X,Skilled-7888,SemiSkilled-7654,UnSkilled-7446\nMINWEDGES_Haryana=HighlySkilled-9700,Skilled-8798,SemiSkilled-7980,UnSkilled-7600\nMINWEDGES_Himachal Pradesh=HighlySkilled-5905,Skilled-5568,SemiSkilled-4824,UnSkilled-4420\nMINWEDGES_Jammu and Kashmir=HighlySkilled-X,Skilled-5850,SemiSkilled-4550,UnSkilled-3900\nMINWEDGES_Jharkhand=HighlySkilled-X,Skilled-5910,SemiSkilled-4827,UnSkilled-4645\nMINWEDGES_Karnataka=HighlySkilled-8649,Skilled-8415,SemiSkilled-8025,UnSkilled-6855\nMINWEDGES_Kerala=HighlySkilled-4851,Skilled-4751,SemiSkilled-4601,UnSkilled-4524\nMINWEDGES_Madhya Pradesh=HighlySkilled-10110,Skilled-8814,SemiSkilled-7436,UnSkilled-6578\nMINWEDGES_Maharashtra=HighlySkilled-X,Skilled-8441,SemiSkilled-8041,UnSkilled-7641\nMINWEDGES_Manipur=\nMINWEDGES_Meghalaya=\nMINWEDGES_Mizoram=\nMINWEDGES_Nagaland=\nMINWEDGES_Odisha=HighlySkilled-5330,Skilled-4940,SemiSkilled-4420,UnSkilled-3900\nMINWEDGES_Punjab=HighlySkilled-9557,Skilled-8525,SemiSkilled-7628,UnSkilled-6848\nMINWEDGES_Rajasthan=HighlySkilled-6734,Skilled-5434,SemiSkilled-5174,UnSkilled-4914\nMINWEDGES_Sikkim=\nMINWEDGES_Tamil Nadu=HighlySkilled-6203,Skilled-5891,SemiSkilled-5860,UnSkilled-5776\nMINWEDGES_Tripura=\nMINWEDGES_Uttar Pradesh=HighlySkilled-X,Skilled-8397,SemiSkilled-7496,UnSkilled-6815\nMINWEDGES_Uttarakhand=HighlySkilled-7845,Skilled-7035,SemiSkilled-6555,UnSkilled-6075\nMINWEDGES_West Bengal=HighlySkilled-4656,Skilled-4611,SemiSkilled-4522,UnSkilled-4478\nMINWEDGES_Telangana=\nMINWEDGES_Pondicherry=\nMINWEDGES_Chandigarh=HighlySkilled-9022,Skilled-8615,SemiSkilled-8190,UnSkilled-7940\nIndiaEmpePFContrib=0.12\nIndiaEmprPFContrib=0.1336\nIndiaEmpeESIC=0.0175\nIndiaEmprESIC=0.0475\nIndiaTDSSTR=0-300000|0,300001-500000|0.1,500001-1000000|0.2,1000001-X|0.3\n\n\ndialerDispoList=CB|FollowUp|,Pending For Lead Generation,AIP Status Pending,Call Back-RPC,Call Disconnected by Customer,Call Disconnected by Customer,Call Back-TPC,Language Barrier- Tamil,Language Barrier- Telugu,Language Barrier- Kannada,Need a Call/Visit from SM,Out of Station~IN|Interested|,Top up Interested- No DOCS,Top up Interested- With DOCS,Top up Interested - With KYC~RP|Reprised|,Saved through Tenure reprise offer L1,Saved through Tenure reprise offer L2,Saved through EMI reprise offer L1,Saved through EMI reprise offer L2~NC|No contact|,No contact,Require Extn Number,Call Drop,Wrong Number,Invalid Number,Out Of Service,Not Reachable,Ringing No Response,Switch Off~NE|Not Eligible|,Address changed No Proof,AIP Red,Already Lead Generated,Low Job Stability,Jobless,BPO Profile Sal Not Met,Cash Salary,Contract Employee,Previous Cheque Bounce,Loan Availed Recently,Negative Profile,Latest EMI Cheque Bounce,Latest EMI Cheque Bounce,No Income Proof, Age Criteria Not Met,Profile Changed,Requires parallel PL,Salary below min income norms,Shifted to Non branch location ~NI|Not Interested|,Already Loan applied Competitor,Does not Require loans,Requires High loan Amount,Requires Low Rate of interest,Requires Other loans LAP,Requires Other loans HL,Customer Irrate-DND,Service Issues\n\n\ndialerCustomHTML= <div style__EQ__\'width:49%;float:left\'><fieldset><legend class__EQ__\'new-recruit_legend\'>Lead Taggiing</legend> <p id__EQ__chkboxrelship><input type__EQ__checkbox onclick__EQ__\'enableRelationships();return false;\' id__EQ__relchkboxenable> Click to Tag Lead</p> <p style__EQ__\'clear:both\'> <label class__EQ__label-small_new style__EQ__\'width:25%;\' title__EQ__\'\'>Service 1: </label> <select class__EQ__\'select2multi\' id__EQ__\'dialerdata_service1-{{varid}}\' name__EQ__\'dialerdata_service1-{{varid}}\' style__EQ__\'width:50%\' onchange__EQ__\'customerDispofields_{{varid}}("dialerdata_service1");\' disabled__EQ__disabled> </select> </p> <p style__EQ__\'clear:both\'> <label class__EQ__label-small_new style__EQ__\'width:25%;\' title__EQ__\'\'>Service 2: </label> <select class__EQ__\'select2multi\' id__EQ__\'dialerdata_service2-{{varid}}\' name__EQ__\'dialerdata_service2-{{varid}}\' style__EQ__\'width:50%\' onchange__EQ__\'customerDispofields_{{varid}}("dialerdata_service2");\' disabled__EQ__disabled> </select> </p> <p style__EQ__\'clear:both\'> <label class__EQ__label-small_new style__EQ__\'width:25%;\' title__EQ__\'\'>Service 3: </label> <select class__EQ__\'select2multi\' id__EQ__\'dialerdata_service3-{{varid}}\' name__EQ__\'dialerdata_service3-{{varid}}\' style__EQ__\'width:50%\' onchange__EQ__\'customerDispofields_{{varid}}("dialerdata_service3");\' disabled__EQ__disabled> </select> </p></fieldset></div> <div style__EQ__\'width:49%;float:left\'><fieldset><legend class__EQ__\'new-recruit_legend\'> </legend> <p style__EQ__\'clear:both\'> <label class__EQ__label-small_new style__EQ__\'width:25%;\' title__EQ__\'\'>Service 4: </label> <select class__EQ__\'select2multi\' id__EQ__\'dialerdata_service4-{{varid}}\' name__EQ__\'dialerdata_service4-{{varid}}\' style__EQ__\'width:50%\' onchange__EQ__\'customerDispofields_{{varid}}("dialerdata_service4");\' disabled__EQ__disabled> </select> </p> <p style__EQ__\'clear:both\'> <label class__EQ__label-small_new style__EQ__\'width:25%;\' title__EQ__\'\'>Service 5: </label> <select class__EQ__\'select2multi\' id__EQ__\'dialerdata_service5-{{varid}}\' name__EQ__\'dialerdata_service5-{{varid}}\' style__EQ__\'width:50%\' onchange__EQ__\'customerDispofields_{{varid}}("dialerdata_service5");\' disabled__EQ__disabled> </select> </p> <p style__EQ__\'clear:both\'> <label class__EQ__label-small_new style__EQ__\'width:25%;\' title__EQ__\'\'>Service 6: </label> <select class__EQ__\'select2multi\' id__EQ__\'dialerdata_service6-{{varid}}\' name__EQ__\'dialerdata_service6-{{varid}}\' style__EQ__\'width:50%\' onchange__EQ__\'customerDispofields_{{varid}}("dialerdata_service6");\' disabled__EQ__disabled> </select> </p> </fieldset></div> <div style__EQ__\'clear:both\'></div> <script> if(typeof customerDispofields __EQ____EQ__ \'undefined\')var customerDispofields__EQ__{}; if(typeof customerDispofields[{{varid}}] __EQ____EQ__ \'undefined\') { customerDispofields[{{varid}}]__EQ__{}; customerDispofields[{{varid}}][\'dialerdata_service1\']__EQ__\'\'; customerDispofields[{{varid}}][\'dialerdata_service2\']__EQ__\'\'; customerDispofields[{{varid}}][\'dialerdata_service3\']__EQ__\'\'; customerDispofields[{{varid}}][\'dialerdata_service4\']__EQ__\'\'; customerDispofields[{{varid}}][\'dialerdata_service5\']__EQ__\'\'; customerDispofields[{{varid}}][\'dialerdata_service6\']__EQ__\'\'; } setTimeout(function(){ $(\'#dialerdata_service1-{{varid}}\').select2(\'val\',customerDispofields[{{varid}}][\'dialerdata_service1\']); $(\'#dialerdata_service2-{{varid}}\').select2(\'val\',customerDispofields[{{varid}}][\'dialerdata_service2\']); $(\'#dialerdata_service3-{{varid}}\').select2(\'val\',customerDispofields[{{varid}}][\'dialerdata_service3\']); $(\'#dialerdata_service4-{{varid}}\').select2(\'val\',customerDispofields[{{varid}}][\'dialerdata_service4\']); $(\'#dialerdata_service5-{{varid}}\').select2(\'val\',customerDispofields[{{varid}}][\'dialerdata_service5\']); $(\'#dialerdata_service6-{{varid}}\').select2(\'val\',customerDispofields[{{varid}}][\'dialerdata_service6\']); },1500); function customerDispofields_{{varid}}(key) { customerDispofields[{{varid}}][key]__EQ__$("#"__PLUS__key__PLUS__"-{{varid}}").val(); } function enableRelationships() { if(kstychCall[\'ts_Talk\']<1||Math.ceil(((getNowTS()-kstychCall[\'ts_Talk\'])/1000))<10) { $(\'#relchkboxenable\').removeAttr(\'checked\'); return; } $("#chkboxrelship").hide(); $(\'#dialerdata_service1-{{varid}}\').prop(\'disabled\',false); $(\'#dialerdata_service2-{{varid}}\').prop(\'disabled\',false); $(\'#dialerdata_service3-{{varid}}\').prop(\'disabled\',false); $(\'#dialerdata_service4-{{varid}}\').prop(\'disabled\',false); $(\'#dialerdata_service5-{{varid}}\').prop(\'disabled\',false); $(\'#dialerdata_service6-{{varid}}\').prop(\'disabled\',false); } var relationshiplist__EQ__[\'\',\'Birthday -- Birthday Call -- Birthday Call-NC\',\'Birthday -- Birthday Call -- Birthday Call-Wished the customer\',\'Digital Products -- Aadhaar -- Cust agreed to updt thru NB\',\'Digital Products -- Aadhaar -- Cust agreed to updt thru SMS\',\'Digital Products -- Aadhaar -- Cust agreed to updt thru VB\',\'Digital Products -- Aadhaar -- Cust does not have Aadhaar Card\',\'Digital Products -- Aadhaar -- Cust has already linked Aadhaar\',\'Digital Products -- Aadhaar -- Cust nt willing to do Aadhaar link\',\'Digital Products -- Aadhaar -- Cust prmsd to vst br to lnk Aadhar\',\'Digital Products -- Aadhaar -- Cust updated through NB\',\'Digital Products -- Aadhaar -- Cust updated through SMS\',\'Digital Products -- Aadhaar -- customer promised to link aadhaar thru Netbanking\',\'Digital Products -- Aadhaar -- Send SMS link to cust fr Aadhar\',\'Digital Products -- Chillr -- Already aware and using Chillr\',\'Digital Products -- Chillr -- Customer has other banka/c,will download chillr\',\'Digital Products -- Chillr -- Customer Not interested in using Chillr\',\'Digital Products -- Chillr -- Customer nt tchsavy person/dont have compatible Ph\',\'Digital Products -- Chillr -- Customer promised to download and useChillr\',\'Digital Products -- Mobile Banking Activation -- Billpay Registration and Activation Link to be sent to customer\',\'Digital Products -- Mobile Banking Activation -- Customer already activated MB\',\'Digital Products -- Mobile Banking Activation -- Customer not interested in using MB.\',\'Digital Products -- Mobile Banking Activation -- Customer not tech savvy to use MB.\',\'Digital Products -- Mobile Banking Activation -- Customer promised to login in to MB\',\'Digital Products -- Mobile Banking Activation -- Customer will decide later about MB usage.\',\'Digital Products -- Mobile Banking Activation -- MB Financial Transaction pitched\',\'Digital Products -- Mobile Banking Activation -- MB app download link Sent\',\'Digital Products -- Mobile Banking Activation -- Mobile Banking demo link to be sent\',\'Digital Products -- Net Banking Activation -- Billpay Registration and Activation Link to be sent to customer\',\'Digital Products -- Net Banking Activation -- Cust already activated NB\',\'Digital Products -- Net Banking Activation -- Cust already use NB for Fin txn\',\'Digital Products -- Net Banking Activation -- Cust not intend to use NB\',\'Digital Products -- Net Banking Activation -- Cust not tech savvy to use NB\',\'Digital Products -- Net Banking Activation -- Cust promised to login NB\',\'Digital Products -- Net Banking Activation -- Cust to decide later about using NB\',\'Digital Products -- Net Banking Activation -- Demo Link to be sent\',\'Digital Products -- Net Banking Financial Pitched -- Cust already use NB for Fin txn\',\'Digital Products -- Net Banking Financial Pitched -- Cust not intend to use NB for Fin txn\',\'Digital Products -- Net Banking Financial Pitched -- Cust promised to use Fin txn on NB\',\'Digital Products -- Net Banking Financial Pitched -- Cust to decide later about using NB for Fin txn\',\'Digital Products -- PayZapp -- Already aware and using Pay Zapp\',\'Digital Products -- PayZapp -- Customer don?t have Hdfc Debit/Credit Card\',\'Digital Products -- PayZapp -- Customer Not interested in using Pay Zapp\',\'Digital Products -- PayZapp -- Customer nt tchsavy person/dont have compatible Ph\',\'Digital Products -- PayZapp -- Customer promised to download PayZapp\',\'Digital Products -- Smart Buy Offer Communication -- Smart Buy Offer Shared \',\'Digital Products -- Net Banking Activation Pitched -- BillPay Registration/Payment Communicated\',\'Digital Products -- Net Banking Activation Pitched -- CC Transaction Communicated\',\'Digital Products -- Net Banking Activation Pitched -- Email ID Updation Communicated\',\'Digital Products -- Net Banking Activation Pitched -- Offers(Provogue/Crossetc) Communicated\',\'Digital Products -- Net Banking Activation Pitched -- Statement Download Communicated\',\'Digital Products -- Net Banking Activation Pitched -- Funds Transfer Communicated\',\'Digital Products -- Net Banking Activation Pitched -- PAN Updation Communicated\',\'Digital Products -- Net Banking Activation Pitched -- Aadhar Updation Communicated\',\'Digital Products -- Net Banking Activation Pitched -- IPIN Regeration Communicated\',\'Digital Products -- Net Banking Activation Pitched -- DC Upgrade Communicated\',\'Digital Products -- Net Banking Activation Pitched -- FD Communicated\',\'Digital Products -- Net Banking Activation Pitched -- RD Communicated\',\'Digital Products -- Net Banking Activation Pitched -- Customer NI_Not primary bank\',\'Digital Products -- Net Banking Activation Pitched -- Customer NI_Account closed\',\'Digital Products -- Net Banking Activation Pitched -- Customer NI_Cust not tech savvy to use NB\',\'Digital Products -- Net Banking Activation Pitched -- Customer NI_Service issue with the bank\',\'Digital Products -- Net Banking Activation Pitched -- Customer NI_Left the company\',\'Digital Products -- Net Banking Activation Pitched -- Customer NI_Fear of security\',\'Digital Products -- SMS -- Net Banking\',\'Digital Products -- SMS -- Mobile Banking\',\'Digital Products -- SMS -- TollFree/SMS Banking\',\'Digital Products -- SMS -- Payzapp\',\'Digital Products -- SMS -- Chilr\',\'Digital Products -- SMS -- UPI\',\'Digital Products -- SMS -- IMPS\',\'Digital Products -- SMS -- Aadhar update\',\'Engagement Calls -- Courtesy Call-routine calls -- Had general discussion/Update\',\'Engagement Calls -- Courtesy Call-routine calls -- Had general discussion/update and infd preapprove \',\'Engagement Calls -- Courtesy Call-routine calls -- Others\',\'Engagement Calls -- Courtesy Call-routine calls -- Update/Discuss and Conv.product\',\'Engagement Calls -- Courtesy Call-routine calls -- Update/Discuss and Conv.product and card products\',\'Engagement Calls -- Courtesy Call-routine calls -- Update/Discuss and Conv.product and CASA\',\'Engagement Calls -- Courtesy Call-routine calls -- Update/Discuss and Conv.product and demat/HSL\',\'Engagement Calls -- Courtesy Call-routine calls -- Update/Discuss and Conv.product and pitched assets\',\'Engagement Calls -- Courtesy Call-routine calls -- Update/Discuss and Conv.product and pitched insurance\',\'Engagement Calls -- Courtesy Call-routine calls -- Update/Discuss and Conv.product and RD\',\'Engagement Calls -- Courtesy Call-routine calls -- Update/Discuss and picthed CASA\',\'Engagement Calls -- Courtesy Call-routine calls -- Update/Discuss and picthed NTB\',\'Engagement Calls -- Courtesy Call-routine calls -- Update/Discuss and pitched assets product\',\'Engagement Calls -- Courtesy Call-routine calls -- Update/Discuss and pitched Card products\',\'Engagement Calls -- Courtesy Call-routine calls -- Update/Discuss and pitched demat/HSL\',\'Engagement Calls -- Courtesy Call-routine calls -- Update/Discuss and pitched inurance\',\'Engagement Calls -- Courtesy Call-routine calls -- Update/Discuss and spoke about aadhar card\',\'Engagement Calls -- Courtesy Call-routine calls -- Update/Discuss and took cust complaint\',\'Engagement Calls -- Offers Communication -- Informed offers Available on Credit card\',\'Engagement Calls -- Offers Communication -- Informed offers Available on Debit card\',\'Engagement Calls -- Offers Communication -- Informed offers on Classic Speak\',\'Engagement Calls -- Offers Communication -- Informed other Offers\',\'Liability -- Liab Bal-Attrition Calling -- Buy Car/Vehicle\',\'Liability -- Liab Bal-Attrition Calling -- Foreign/Domestic Travel\',\'Liability -- Liab Bal-Attrition Calling -- Funds booked in FD\',\'Liability -- Liab Bal-Attrition Calling -- Investment in Gold\',\'Liability -- Liab Bal-Attrition Calling -- Investments in MF/Ins/Others\',\'Liability -- Liab Bal-Attrition Calling -- Marriage/Celebrations\',\'Liability -- Liab Bal-Attrition Calling -- Medical Expenses\',\'Liability -- Liab Bal-Attrition Calling -- Move to other banks -High interest rates\',\'Liability -- Liab Bal-Attrition Calling -- Not Disclosed\',\'Liability -- Liab Bal-Attrition Calling -- Not happy with Bank services\',\'Liability -- Liab Bal-Attrition Calling -- Not happy with PB service\',\'Liability -- Liab Bal-Attrition Calling -- Personal Expenses\',\'Liability -- Liab Bal-Attrition Calling -- Prepay of Loan\',\'Liability -- Liab Bal-Attrition Calling -- Purchase of property\',\'X sell Card Products -- LE / Normal Upgrade -- Lead Generated\',\'X sell Card Products -- LE / Normal Upgrade -- Follow Up\',\'X sell Card Products -- LE / Normal Upgrade -- Not Interested\',\'X sell Card Products -- LE / Normal Upgrade -- Document follow up\',\'X sell Card Products -- LE / Normal Upgrade -- Product offer / details communicated\',\'X sell Card Products -- LE / Normal Upgrade -- Need after 15 days\',\'X sell Card Products -- LE / Normal Upgrade -- Need after 1 month\',\'X sell Card Products -- LE / Normal Upgrade -- Need after 2 months\',\'X sell Card Products -- LE / Normal Upgrade -- Others\',\'X sell Card Products -- Regular Credit Card -- Lead Generated\',\'X sell Card Products -- Regular Credit Card -- Follow Up\',\'X sell Card Products -- Regular Credit Card -- Not Interested\',\'X sell Card Products -- Regular Credit Card -- Document follow up\',\'X sell Card Products -- Regular Credit Card -- Product offer / details communicated\',\'X sell Card Products -- Regular Credit Card -- Need after 15 days\',\'X sell Card Products -- Regular Credit Card -- Need after 1 month\',\'X sell Card Products -- Regular Credit Card -- Need after 2 months\',\'X sell Card Products -- Regular Credit Card -- Others\',\'X sell Card Products -- Regular Credit Card STP -- Lead Generated\',\'X sell Card Products -- Regular Credit Card STP -- Follow Up\',\'X sell Card Products -- Regular Credit Card STP -- Not Interested\',\'X sell Card Products -- Regular Credit Card STP -- Document follow up\',\'X sell Card Products -- Regular Credit Card STP -- Product offer / details communicated\',\'X sell Card Products -- Regular Credit Card STP -- Need after 15 days\',\'X sell Card Products -- Regular Credit Card STP -- Need after 1 month\',\'X sell Card Products -- Regular Credit Card STP -- Need after 2 months\',\'X sell Card Products -- Regular Credit Card STP -- Others\',\'X sell Card Products -- SPC - STP -- Online case converted\',\'X sell Card Products -- SPC - STP -- Follow Up\',\'X sell Card Products -- SPC - STP -- Not Interested\',\'X sell Card Products -- SPC - STP -- Product offer / details communicated\',\'X sell Card Products -- SPC - STP -- Need after 15 days\',\'X sell Card Products -- SPC - STP -- Need after 1 month\',\'X sell Card Products -- SPC - STP -- Need after 2 months\',\'X sell Card Products -- SPC - STP -- Others\',\'X sell Card Products -- SPC Fresh -- Lead Generated\',\'X sell Card Products -- SPC Fresh -- Follow Up\',\'X sell Card Products -- SPC Fresh -- Not Interested\',\'X sell Card Products -- SPC Fresh -- Document follow up\',\'X sell Card Products -- SPC Fresh -- Product offer / details communicated\',\'X sell Card Products -- SPC Fresh -- Need after 15 days\',\'X sell Card Products -- SPC Fresh -- Need after 1 month\',\'X sell Card Products -- SPC Fresh -- Need after 2 months\',\'X sell Card Products -- SPC Fresh -- Others\',\'X sell Card Products -- SPC Upgrade -- Lead Generated\',\'X sell Card Products -- SPC Upgrade -- Follow Up\',\'X sell Card Products -- SPC Upgrade -- Not Interested\',\'X sell Card Products -- SPC Upgrade -- Document follow up\',\'X sell Card Products -- SPC Upgrade -- Product offer / details communicated\',\'X sell Card Products -- SPC Upgrade -- Need after 15 days\',\'X sell Card Products -- SPC Upgrade -- Need after 1 month\',\'X sell Card Products -- SPC Upgrade -- Need after 2 months\',\'X sell Card Products -- SPC Upgrade -- Others\',\'X sell Card Products -- Term Product - Insta Loan/COC -- Online case Converted\',\'X sell Card Products -- Term Product - Insta Loan/COC -- Follow Up\',\'X sell Card Products -- Term Product - Insta Loan/COC -- Not Interested\',\'X sell Card Products -- Term Product - Insta Loan/COC -- Product offer / details communicated\',\'X sell Card Products -- Term Product - Insta Loan/COC -- Need after 15 days\',\'X sell Card Products -- Term Product - Insta Loan/COC -- Need after 1 month\',\'X sell Card Products -- Term Product - Insta Loan/COC -- Need after 2 months\',\'X sell Card Products -- Term Product - Insta Loan/COC -- Others\',\'X sell Card Products -- Term Product - Jumbo -- Online case Converted\',\'X sell Card Products -- Term Product - Jumbo -- Follow Up\',\'X sell Card Products -- Term Product - Jumbo -- Not Interested\',\'X sell Card Products -- Term Product - Jumbo -- Product offer / details communicated\',\'X sell Card Products -- Term Product - Jumbo -- Need after 15 days\',\'X sell Card Products -- Term Product - Jumbo -- Need after 1 month\',\'X sell Card Products -- Term Product - Jumbo -- Need after 2 months\',\'X sell Card Products -- Term Product - Jumbo -- Others\',\'X sell Card Products -- Term Product - Smart EMI -- Online case Converted\',\'X sell Card Products -- Term Product - Smart EMI -- Follow Up\',\'X sell Card Products -- Term Product - Smart EMI -- Not Interested\',\'X sell Card Products -- Term Product - Smart EMI -- Product offer / details communicated\',\'X sell Card Products -- Term Product - Smart EMI -- Need after 15 days\',\'X sell Card Products -- Term Product - Smart EMI -- Need after 1 month\',\'X sell Card Products -- Term Product - Smart EMI -- Need after 2 months\',\'X sell Card Products -- Term Product - Smart EMI -- Others\',\'X sell Card Products -- Term Product - Smart Pay -- Online case Converted\',\'X sell Card Products -- Term Product - Smart Pay -- Follow Up\',\'X sell Card Products -- Term Product - Smart Pay -- Not Interested\',\'X sell Card Products -- Term Product - Smart Pay -- Product offer / details communicated\',\'X sell Card Products -- Term Product - Smart Pay -- Need after 15 days\',\'X sell Card Products -- Term Product - Smart Pay -- Need after 1 month\',\'X sell Card Products -- Term Product - Smart Pay -- Need after 2 months\',\'X sell Card Products -- Term Product - Smart Pay -- Others\',\'X Sell Other Products -- CASA -- Lead Generated\',\'X Sell Other Products -- CASA -- Follow Up\',\'X Sell Other Products -- CASA -- Not Interested\',\'X Sell Other Products -- CASA -- Document follow up\',\'X Sell Other Products -- CASA -- Product offer / details communicated\',\'X Sell Other Products -- CASA -- Need after 15 days\',\'X Sell Other Products -- CASA -- Need after 1 month\',\'X Sell Other Products -- CASA -- Need after 2 months\',\'X Sell Other Products -- CASA -- Others\',\'X Sell Other Products -- Demat/HSL -- Lead Generated\',\'X Sell Other Products -- Demat/HSL -- Follow Up\',\'X Sell Other Products -- Demat/HSL -- Not Interested\',\'X Sell Other Products -- Demat/HSL -- Document follow up\',\'X Sell Other Products -- Demat/HSL -- Product offer / details communicated\',\'X Sell Other Products -- Demat/HSL -- Need after 15 days\',\'X Sell Other Products -- Demat/HSL -- Need after 1 month\',\'X Sell Other Products -- Demat/HSL -- Need after 2 months\',\'X Sell Other Products -- Demat/HSL -- Online SIP converted\',\'X Sell Other Products -- Demat/HSL -- Others\',\'X Sell Other Products -- Forex -- Lead Generated\',\'X Sell Other Products -- Forex -- Follow Up\',\'X Sell Other Products -- Forex -- Not Interested\',\'X Sell Other Products -- Forex -- Document follow up\',\'X Sell Other Products -- Forex -- Product offer / details communicated\',\'X Sell Other Products -- Forex -- Need after 15 days\',\'X Sell Other Products -- Forex -- Need after 1 month\',\'X Sell Other Products -- Forex -- Need after 2 months\',\'X Sell Other Products -- Forex -- Others\',\'X Sell Other Products -- Forex Plus Card -- Lead Generated\',\'X Sell Other Products -- Forex Plus Card -- Follow Up\',\'X Sell Other Products -- Forex Plus Card -- Not Interested\',\'X Sell Other Products -- Forex Plus Card -- Document follow up\',\'X Sell Other Products -- Forex Plus Card -- Product offer / details communicated\',\'X Sell Other Products -- Forex Plus Card -- Need after 15 days\',\'X Sell Other Products -- Forex Plus Card -- Need after 1 month\',\'X Sell Other Products -- Forex Plus Card -- Need after 2 months\',\'X Sell Other Products -- Forex Plus Card -- Others\',\'X Sell Other Products -- Gold/Silver -- Sale Closed through Branch\',\'X Sell Other Products -- Gold/Silver -- Follow Up\',\'X Sell Other Products -- Gold/Silver -- Not Interested\',\'X Sell Other Products -- Gold/Silver -- Product offer / details communicated\',\'X Sell Other Products -- Gold/Silver -- Need after 15 days\',\'X Sell Other Products -- Gold/Silver -- Need after 1 month\',\'X Sell Other Products -- Gold/Silver -- Need after 2 months\',\'X Sell Other Products -- Gold/Silver -- Others\',\'X Sell Other Products -- TD/RD -- Online TD / RD Booked\',\'X Sell Other Products -- TD/RD -- Follow Up\',\'X Sell Other Products -- TD/RD -- Not Interested\',\'X Sell Other Products -- TD/RD -- Product offer / details communicated\',\'X Sell Other Products -- TD/RD -- Need after 15 days\',\'X Sell Other Products -- TD/RD -- Need after 1 month\',\'X Sell Other Products -- TD/RD -- Need after 2 months\',\'X Sell Other Products -- TD/RD -- Others\',\'X Sell TPP -- General Insurance-Health -- Lead Generated\',\'X Sell TPP -- General Insurance-Health -- Follow Up\',\'X Sell TPP -- General Insurance-Health -- Not Interested\',\'X Sell TPP -- General Insurance-Health -- Document follow up\',\'X Sell TPP -- General Insurance-Health -- Product offer / details communicated\',\'X Sell TPP -- General Insurance-Health -- Need after 15 days\',\'X Sell TPP -- General Insurance-Health -- Need after 1 month\',\'X Sell TPP -- General Insurance-Health -- Need after 2 months\',\'X Sell TPP -- General Insurance-Health -- Online Lead Generated\',\'X Sell TPP -- General Insurance-Health -- Online Lead Converted\',\'X Sell TPP -- General Insurance-Health -- Others\',\'X Sell TPP -- General Insurance-Motor -- Lead Generated\',\'X Sell TPP -- General Insurance-Motor -- Follow Up\',\'X Sell TPP -- General Insurance-Motor -- Not Interested\',\'X Sell TPP -- General Insurance-Motor -- Document follow up\',\'X Sell TPP -- General Insurance-Motor -- Product offer / details communicated\',\'X Sell TPP -- General Insurance-Motor -- Need after 15 days\',\'X Sell TPP -- General Insurance-Motor -- Need after 1 month\',\'X Sell TPP -- General Insurance-Motor -- Need after 2 months\',\'X Sell TPP -- General Insurance-Motor -- Online Lead Generated\',\'X Sell TPP -- General Insurance-Motor -- Online Lead Converted\',\'X Sell TPP -- General Insurance-Motor -- Others\',\'X Sell TPP -- Life Insurance -- Lead Generated\',\'X Sell TPP -- Life Insurance -- Follow Up\',\'X Sell TPP -- Life Insurance -- Not Interested\',\'X Sell TPP -- Life Insurance -- Document follow up\',\'X Sell TPP -- Life Insurance -- Product offer / details communicated\',\'X Sell TPP -- Life Insurance -- Need after 15 days\',\'X Sell TPP -- Life Insurance -- Need after 1 month\',\'X Sell TPP -- Life Insurance -- Need after 2 months\',\'X Sell TPP -- Life Insurance -- Online Lead Generated\',\'X Sell TPP -- Life Insurance -- Online Lead Converted\',\'X Sell TPP -- Life Insurance -- Others\',\'X Sell TPP -- Mutual Funds -- Lead Generated\',\'X Sell TPP -- Mutual Funds -- Follow Up\',\'X Sell TPP -- Mutual Funds -- Not Interested\',\'X Sell TPP -- Mutual Funds -- Document follow up\',\'X Sell TPP -- Mutual Funds -- Product offer / details communicated\',\'X Sell TPP -- Mutual Funds -- Need after 15 days\',\'X Sell TPP -- Mutual Funds -- Need after 1 month\',\'X Sell TPP -- Mutual Funds -- Need after 2 months\',\'X Sell TPP -- Mutual Funds -- Sales converted Online\',\'X Sell TPP -- Mutual Funds -- others\',\'Assets -- Auto Loan - New Car -- Lead Generated\',\'Assets -- Auto Loan - New Car -- Follow Up\',\'Assets -- Auto Loan - New Car -- Not Interested\',\'Assets -- Auto Loan - New Car -- Document follow up\',\'Assets -- Auto Loan - New Car -- Product offer / details communicated\',\'Assets -- Auto Loan - New Car -- Need after 15 days\',\'Assets -- Auto Loan - New Car -- Need after 1 month\',\'Assets -- Auto Loan - New Car -- Need after 2 months\',\'Assets -- Auto Loan - New Car -- Others\',\'Assets -- Auto Loan - Quick Money -- Lead Generated\',\'Assets -- Auto Loan - Quick Money -- Follow Up\',\'Assets -- Auto Loan - Quick Money -- Not Interested\',\'Assets -- Auto Loan - Quick Money -- Document follow up\',\'Assets -- Auto Loan - Quick Money -- Product offer / details communicated\',\'Assets -- Auto Loan - Quick Money -- Need after 15 days\',\'Assets -- Auto Loan - Quick Money -- Need after 1 month\',\'Assets -- Auto Loan - Quick Money -- Need after 2 months\',\'Assets -- Auto Loan - Quick Money -- Others\',\'Assets -- Auto Loan - Used Car / Car N Cash -- Lead Generated\',\'Assets -- Auto Loan - Used Car / Car N Cash -- Follow Up\',\'Assets -- Auto Loan - Used Car / Car N Cash -- Not Interested\',\'Assets -- Auto Loan - Used Car / Car N Cash -- Document follow up\',\'Assets -- Auto Loan - Used Car / Car N Cash -- Product offer / details communicated\',\'Assets -- Auto Loan - Used Car / Car N Cash -- Need after 15 days\',\'Assets -- Auto Loan - Used Car / Car N Cash -- Need after 1 month\',\'Assets -- Auto Loan - Used Car / Car N Cash -- Need after 2 months\',\'Assets -- Auto Loan - Used Car / Car N Cash -- Others\',\'Assets -- Business Banking - Working Capital -- Lead Generated\',\'Assets -- Business Banking - Working Capital -- Follow Up\',\'Assets -- Business Banking - Working Capital -- Not Interested\',\'Assets -- Business Banking - Working Capital -- Document follow up\',\'Assets -- Business Banking - Working Capital -- Product offer / details communicated\',\'Assets -- Business Banking - Working Capital -- Need after 15 days\',\'Assets -- Business Banking - Working Capital -- Need after 1 month\',\'Assets -- Business Banking - Working Capital -- Need after 2 months\',\'Assets -- Business Banking - Working Capital -- Others\',\'Assets -- Business Loan -- Lead Generated\',\'Assets -- Business Loan -- Follow Up\',\'Assets -- Business Loan -- Not Interested\',\'Assets -- Business Loan -- Document follow up\',\'Assets -- Business Loan -- Product offer / details communicated\',\'Assets -- Business Loan -- Need after 15 days\',\'Assets -- Business Loan -- Need after 1 month\',\'Assets -- Business Loan -- Need after 2 months\',\'Assets -- Business Loan -- Others\',\'Assets -- Commercial Vehicles -- Lead Generated\',\'Assets -- Commercial Vehicles -- Follow Up\',\'Assets -- Commercial Vehicles -- Not Interested\',\'Assets -- Commercial Vehicles -- Document follow up\',\'Assets -- Commercial Vehicles -- Product offer / details communicated\',\'Assets -- Commercial Vehicles -- Need after 15 days\',\'Assets -- Commercial Vehicles -- Need after 1 month\',\'Assets -- Commercial Vehicles -- Need after 2 months\',\'Assets -- Commercial Vehicles -- Others\',\'Assets -- Construction Equipments -- Lead Generated\',\'Assets -- Construction Equipments -- Follow Up\',\'Assets -- Construction Equipments -- Not Interested\',\'Assets -- Construction Equipments -- Document follow up\',\'Assets -- Construction Equipments -- Product offer / details communicated\',\'Assets -- Construction Equipments -- Need after 15 days\',\'Assets -- Construction Equipments -- Need after 1 month\',\'Assets -- Construction Equipments -- Need after 2 months\',\'Assets -- Construction Equipments -- Others\',\'Assets -- Consumer Durable -- Lead Generated\',\'Assets -- Consumer Durable -- Follow Up\',\'Assets -- Consumer Durable -- Not Interested\',\'Assets -- Consumer Durable -- Document follow up\',\'Assets -- Consumer Durable -- Product offer / details communicated\',\'Assets -- Consumer Durable -- Need after 15 days\',\'Assets -- Consumer Durable -- Need after 1 month\',\'Assets -- Consumer Durable -- Need after 2 months\',\'Assets -- Consumer Durable -- Others\',\'Assets -- Education Loan -- Lead Generated\',\'Assets -- Education Loan -- Follow Up\',\'Assets -- Education Loan -- Not Interested\',\'Assets -- Education Loan -- Document follow up\',\'Assets -- Education Loan -- Product offer / details communicated\',\'Assets -- Education Loan -- Need after 15 days\',\'Assets -- Education Loan -- Need after 1 month\',\'Assets -- Education Loan -- Need after 2 months\',\'Assets -- Education Loan -- Others\',\'Assets -- EEG -- Lead Generated\',\'Assets -- EEG -- Follow Up\',\'Assets -- EEG -- Not Interested\',\'Assets -- EEG -- Document follow up\',\'Assets -- EEG -- Product offer / details communicated\',\'Assets -- EEG -- Need after 15 days\',\'Assets -- EEG -- Need after 1 month\',\'Assets -- EEG -- Need after 2 months\',\'Assets -- EEG -- Others\',\'Assets -- Gold Loan -- Lead Generated\',\'Assets -- Gold Loan -- Follow Up\',\'Assets -- Gold Loan -- Not Interested\',\'Assets -- Gold Loan -- Document follow up\',\'Assets -- Gold Loan -- Product offer / details communicated\',\'Assets -- Gold Loan -- Need after 15 days\',\'Assets -- Gold Loan -- Need after 1 month\',\'Assets -- Gold Loan -- Need after 2 months\',\'Assets -- Gold Loan -- Others\',\'Assets -- Health Care Finance -- Lead Generated\',\'Assets -- Health Care Finance -- Follow Up\',\'Assets -- Health Care Finance -- Not Interested\',\'Assets -- Health Care Finance -- Document follow up\',\'Assets -- Health Care Finance -- Product offer / details communicated\',\'Assets -- Health Care Finance -- Need after 15 days\',\'Assets -- Health Care Finance -- Need after 1 month\',\'Assets -- Health Care Finance -- Need after 2 months\',\'Assets -- Health Care Finance -- Others\',\'Assets -- Home Loans -- Lead Generated\',\'Assets -- Home Loans -- Follow Up\',\'Assets -- Home Loans -- Not Interested\',\'Assets -- Home Loans -- Document follow up\',\'Assets -- Home Loans -- Product offer / details communicated\',\'Assets -- Home Loans -- Need after 15 days\',\'Assets -- Home Loans -- Need after 1 month\',\'Assets -- Home Loans -- Need after 2 months\',\'Assets -- Home Loans -- Others\',\'Assets -- KGC -- Lead Generated\',\'Assets -- KGC -- Follow Up\',\'Assets -- KGC -- Not Interested\',\'Assets -- KGC -- Document follow up\',\'Assets -- KGC -- Product offer / details communicated\',\'Assets -- KGC -- Need after 15 days\',\'Assets -- KGC -- Need after 1 month\',\'Assets -- KGC -- Need after 2 months\',\'Assets -- KGC -- others\',\'Assets -- Loan Against Securities ( loan/OD) -- Lead Generated\',\'Assets -- Loan Against Securities ( loan/OD) -- Follow Up\',\'Assets -- Loan Against Securities ( loan/OD) -- Not Interested\',\'Assets -- Loan Against Securities ( loan/OD) -- Document follow up\',\'Assets -- Loan Against Securities ( loan/OD) -- Product offer / details communicated\',\'Assets -- Loan Against Securities ( loan/OD) -- Need after 15 days\',\'Assets -- Loan Against Securities ( loan/OD) -- Need after 1 month\',\'Assets -- Loan Against Securities ( loan/OD) -- Need after 2 months\',\'Assets -- Loan Against Securities ( loan/OD) -- others\',\'Assets -- Paperless Personal Loan -- Lead Generated\',\'Assets -- Paperless Personal Loan -- Follow Up\',\'Assets -- Paperless Personal Loan -- Not Interested\',\'Assets -- Paperless Personal Loan -- Document follow up\',\'Assets -- Paperless Personal Loan -- Product offer / details communicated\',\'Assets -- Paperless Personal Loan -- Need after 15 days\',\'Assets -- Paperless Personal Loan -- Need after 1 month\',\'Assets -- Paperless Personal Loan -- Need after 2 months\',\'Assets -- Paperless Personal Loan -- others\',\'Assets -- Personal Loan -- Lead Generated\',\'Assets -- Personal Loan -- Follow Up\',\'Assets -- Personal Loan -- Not Interested\',\'Assets -- Personal Loan -- Document follow up\',\'Assets -- Personal Loan -- Product offer / details communicated\',\'Assets -- Personal Loan -- Need after 15 days\',\'Assets -- Personal Loan -- Need after 1 month\',\'Assets -- Personal Loan -- Need after 2 months\',\'Assets -- Personal Loan -- others\',\'Assets -- Other Asset Products -- Lead Generated\',\'Assets -- Other Asset Products -- Follow Up\',\'Assets -- Other Asset Products -- Not Interested\',\'Assets -- Other Asset Products -- Document follow up\',\'Assets -- Other Asset Products -- Product offer / details communicated\',\'Assets -- Other Asset Products -- Need after 15 days\',\'Assets -- Other Asset Products -- Need after 1 month\',\'Assets -- Other Asset Products -- Need after 2 months\',\'Assets -- Other Asset Products -- others\',\'Assets -- Two Wheeler Loan -- Lead Generated\',\'Assets -- Two Wheeler Loan -- Follow Up\',\'Assets -- Two Wheeler Loan -- Not Interested\',\'Assets -- Two Wheeler Loan -- Document follow up\',\'Assets -- Two Wheeler Loan -- Product offer / details communicated\',\'Assets -- Two Wheeler Loan -- Need after 15 days\',\'Assets -- Two Wheeler Loan -- Need after 1 month\',\'Assets -- Two Wheeler Loan -- Need after 2 months\',\'Assets -- Two Wheeler Loan -- others\',\'Liability -- Ask for Money -- Less funds in Other bank \',\'Liability -- Ask for Money -- Others\',\'Liability -- Ask for Money -- Promote online transfer \',\'Liability -- Ask for Money -- Property to be purchased\',\'Liability -- Ask for Money -- Service issue\',\'Liability -- Ask for Money -- Will transfer later\',\'Complaint Calls -- Complaints Call -- Call Back\',\'Complaint Calls -- Complaints Call -- Compalint logged\',\'Complaint Calls -- Complaints Call -- Complaint-FUP and solution awaited\',\'Complaint Calls -- Complaints Call -- Informed solution of the complaint\',\'Complaint Calls -- Complaints Call -- more details on his complaint \',\'Complaint Calls -- Complaints Call -- Not contactable\',\'Complaint Calls -- Complaints Call -- Others\',\'Complaint Calls -- Complaints Call -- satisfied about the solution \',\'Convenience Products -- Bill Pay -- Already Registered\',\'Convenience Products -- Bill Pay -- Customer Aware\',\'Convenience Products -- Bill Pay -- Customer educated\',\'Convenience Products -- Bill Pay -- Follow Up\',\'Convenience Products -- Bill Pay -- Got it Registered\',\'Convenience Products -- Bill Pay -- Not interested\',\'Convenience Products -- Credit card Activation -- Customer Aware\',\'Convenience Products -- Credit card Activation -- Customer Educated\',\'Convenience Products -- Credit card Activation -- Customer will use the product\',\'Convenience Products -- E statement -- Already Registered\',\'Convenience Products -- E statement -- Customer Aware\',\'Convenience Products -- E statement -- Customer educated\',\'Convenience Products -- E statement -- Follow Up\',\'Convenience Products -- E statement -- Got it Registered\',\'Convenience Products -- E statement -- Not interested\',\'EBT Triggers -- FD broken before maturity -- Funds Requirement\',\'EBT Triggers -- FD broken before maturity -- Marriage Expenses\',\'EBT Triggers -- FD broken before maturity -- Not contactable\',\'EBT Triggers -- FD broken before maturity -- Others\',\'EBT Triggers -- FD broken before maturity -- Personal Expenses\',\'EBT Triggers -- FD broken before maturity -- Purchased Property\',\'EBT Triggers -- FD broken before maturity -- Reinvestment on new rates\',\'EBT Triggers -- FD maturity -- Educated about renewal of fd\',\'EBT Triggers -- FD maturity -- Informed about maturity date\',\'EBT Triggers -- FD maturity -- Not contactable\',\'EBT Triggers -- FD maturity -- Others\',\'EBT Triggers -- FD maturity -- Promote Invest. for better returns\',\'EBT Triggers -- Inactive 45 days -- Customer is in abroad\',\'EBT Triggers -- Inactive 45 days -- Not contactable\',\'EBT Triggers -- Inactive 45 days -- Others\',\'EBT Triggers -- Inactive 45 days -- Senior citizen customer\',\'EBT Triggers -- Inactive 45 days -- Service issue\',\'EBT Triggers -- Inactive 45 days -- using other bank account\',\'EBT Triggers -- Investment made -- Invested in Mutual Fund\',\'EBT Triggers -- Investment made -- Invested in LIC\',\'EBT Triggers -- Investment made -- Invested in Other insurance comp.\',\'EBT Triggers -- Investment made -- Invested in PPF Account\',\'EBT Triggers -- Investment made -- Not contactable\',\'EBT Triggers -- Investment made -- Others\',\'EBT Triggers -- Investment made -- Promote HDFC poilcy\',\'EBT Triggers -- Large debit -- Marriage at home\',\'EBT Triggers -- Large debit -- Med Emergency\',\'EBT Triggers -- Large debit -- Not contactable\',\'EBT Triggers -- Large debit -- Others\',\'EBT Triggers -- Large debit -- Part payment of any loan\',\'EBT Triggers -- Large debit -- Personal Expenses\',\'EBT Triggers -- Large debit -- Premium Paid against other invest.\',\'EBT Triggers -- Large debit -- Purchased Property\',\'EBT Triggers -- Large debit -- Transferred to other bank\',\'EBT Triggers -- Other bank A/C -- Better service in other bank.\',\'EBT Triggers -- Other bank A/C -- Making payment to loan emi\',\'EBT Triggers -- Other bank A/C -- Not contactable\',\'EBT Triggers -- Other bank A/C -- Other\',\'EBT Triggers -- Other bank A/C -- Service Issue\',\'EBT Triggers -- Other CC -- Not contactable\',\'EBT Triggers -- Other CC -- Others\',\'EBT Triggers -- Other CC -- Promote HDFC credit card\',\'EBT Triggers -- Other CC -- Promote smart pay on credit card\',\'EBT Triggers -- Payment/Bill Due -- Not contactable\',\'EBT Triggers -- Payment/Bill Due -- Others\',\'EBT Triggers -- Payment/Bill Due -- Promote Bill pay\',\'EBT Triggers -- Payment/Bill Due -- Promote smart pay \',\'EBT Triggers -- Stop/irregular salary credit -- Medical Emergency\',\'EBT Triggers -- Stop/irregular salary credit -- Not contactable\',\'EBT Triggers -- Stop/irregular salary credit -- other\',\'EBT Triggers -- Stop/irregular salary credit -- Personal Expenses\',\'EBT Triggers -- Stop/irregular salary credit -- Resigned employee\',\'EBT Triggers -- Stop/irregular salary credit -- Shifted to another company\',\'EBT Triggers -- Transferring salary out of A/C -- Not contactable\',\'EBT Triggers -- Transferring salary out of A/C -- Others\',\'EBT Triggers -- Transferring salary out of A/C -- Partial payment against property\',\'EBT Triggers -- Transferring salary out of A/C -- Payment?Loan emi\',\'EBT Triggers -- Transferring salary out of A/C -- Shifted to another company\',\'EBT Triggers -- Transferring salary out of A/C -- Started a new business\',\'Social Security Schemes -- Social Security Scheme - PMJJBY -- Customer Not Interested\',\'Social Security Schemes -- Social Security Scheme - PMJJBY -- Customer Converted on call\',\'Social Security Schemes -- Social Security Scheme - PMJJBY -- Customer Promised to Enroll\',\'Social Security Schemes -- Social Security Scheme - PMJJBY -- Customer Already Enrolled\',\'Social Security Schemes -- Social Security Scheme - PMSBY -- Customer Promised to Enroll\',\'Social Security Schemes -- Social Security Scheme - PMSBY -- Customer Already Enrolled\',\'Social Security Schemes -- Social Security Scheme - PMSBY -- Customer Not Interested\',\'Social Security Schemes -- Social Security Scheme - PMSBY -- Customer Converted on call\',\'Racing Calls -- Racing Calls -- Customer already raced to Imperia\',\'Racing Calls -- Racing Calls -- Customer already raced to Preferred\',\'Racing Calls -- Racing Calls -- Customer ineligible for classic program as per\',\'Racing Calls -- Racing Calls -- Customer is a senior citizen and NI in maintai\',\'Racing Calls -- Racing Calls -- Customer is a senior citizen and NI in the Pro\',\'Racing Calls -- Racing Calls -- Customer not interested\',\'Racing Calls -- Racing Calls -- Dormat /inoperative a/c and cust NI to activate/\',\'Racing Calls -- Racing Calls -- Family Savings Account\',\'Racing Calls -- Racing Calls -- High debits in the cust a/c and cust NI to maintain balance\',\'Racing Calls -- Racing Calls -- Wrong Number\',\'Racing Calls -- Racing Calls -- Not available\',\'Racing Calls -- Racing Calls -- Number Ringing/no response\',\'Racing Calls -- Racing Calls -- Cust didnt listen to Prog and asked to Call later\',\'Racing Calls -- Racing Calls -- Cust drawing high Sal but NI in the Program\',\'Racing Calls -- Racing Calls -- Cust drawing Low sal and NI in maintain the bal\',\'Racing Calls -- Racing Calls -- Cust listened to Prog and asked to Call later\',\'Racing Calls -- Racing Calls -- Cust. high potential but NI in the Program\',\'Racing Calls -- Racing Calls -- Customer agreed to be raced to Classic\',\'Racing Calls -- Racing Calls -- Customer already raced to Branch Classic\',\'Racing Calls -- Racing Calls -- Customer already raced to CoP\',\'Racing Calls -- Racing Calls -- Customer Not Eligible\']; updateJSSelect(\'dialerdata_service1-{{varid}}\',relationshiplist); updateJSSelect(\'dialerdata_service2-{{varid}}\',relationshiplist); updateJSSelect(\'dialerdata_service3-{{varid}}\',relationshiplist); updateJSSelect(\'dialerdata_service4-{{varid}}\',relationshiplist); updateJSSelect(\'dialerdata_service5-{{varid}}\',relationshiplist); updateJSSelect(\'dialerdata_service6-{{varid}}\',relationshiplist); </script>', 2);
INSERT INTO `hrms_masters` (`mkey`, `mtype`, `mvalue`, `mid`) VALUES
('coretabs', 'coreconfig', '', 3),
('Campaign Two', 'company', 'monthworkdays~|agencyfeesvalue~|agencyfeefunction~|contractstartdate~|contractenddate~|insurancerequired~|servicedby~|contactname~|contactemail~|contactphone~|hrsendfiles~bnVsbA==|contactnameacct~|contactemailacct~|contactphoneacct~|offerletter~|confirmationletter~|promotionletter~|appraisalletter~|warningletter~|terminationletter~|nocletter~|experienceletter~|endofserviceletter~|yrmeternityleaves~|yrsickleaves~|yrannualleaves~|yemaxcarryleaves~|developerparam~RGlhbGVyRElEPTIyMzA1NTc0MDU6MQphdXRvZGlhbGVyY2FtcGFpZ249Mg==|trackerfields~|campaignscript~|', 4),
('Campaign One', 'coreconfig', 'HRFiledsStr=currentstatus:T:Customer Status:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info~1:21:::644::, legalstatus:T:Group Status:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, firstname:T:Customer Name:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, clientcode:T:Folio Number:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::664::, clientinternalid:T:ARN Code:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, status:L:Status:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, priority:T:Priority:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, ucic_id:T:UCIC ID:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, PAN:T:PAN Number:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, Unit:T:Unit:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, DOB:T:DOB:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, age:T:Age:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, mobile:L:Mobile:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, altphone1:T:Office Phone:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, altphone2:T:Res Phone:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, emailid:T:Email:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, address1:T:Address 1:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, address2:T:Address 2:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, city:T:City:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, state:T:State:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, Product1:T:Product 1:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, Product2:T:Product 2:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, Product3:T:Product 3:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Customer Info~0:21:::644::, Fund_Name:T:Fund Name:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Product Info~2:22:::644::, Product_Name:T:Product Name:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Product Info:22:::644::, Product_Type:T:Product Type:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Product Info:22:::644::, Invested_Amount:T:Invested Amount:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Product Info:22:::644::, NAV_Value:T:NAV Value:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Product Info:22:::644::, Total_Amount:T:Total Amount:Cust Info:Customer Info - {{client}} {{dialer_flag}}:Product Info~0:22:::644::, genericfilename:L:Generic Upload Name:::::::664::, genericfileselect:F:Generic Upload File:::::::664::, status:L:Record Status:::::::600::, workflowstatus:L:Workflow Status:::::::600::, client:S:PB Code:::::::666::, dialer_flag:::::::::666::VIP~Normal', 6),
('Campaign Two', 'coreconfig', 'HRFiledsStr=currentstatus:T:Customer Status:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info~1:21:::644::, legalstatus:T:Group Status:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, firstname:T:Customer Name:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, clientcode:T:Folio Number:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::664::, clientinternalid:T:ARN Code:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, status:L:Status:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, priority:T:Priority:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, ucic_id:T:UCIC ID:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, PAN:T:PAN Number:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, Unit:T:Unit:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, DOB:T:DOB:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, age:T:Age:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, mobile:L:Mobile:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, altphone1:T:Office Phone:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, altphone2:T:Res Phone:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, emailid:T:Email:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, address1:T:Address 1:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, address2:T:Address 2:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, city:T:City:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, state:T:State:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, Product1:T:Product 1:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, Product2:T:Product 2:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info:21:::644::, Product3:T:Product 3:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Customer Info~0:21:::644::, Fund_Name:T:Fund Name:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Product Info~2:22:::644::, Product_Name:T:Product Name:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Product Info:22:::644::, Product_Type:T:Product Type:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Product Info:22:::644::, Invested_Amount:T:Invested Amount:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Product Info:22:::644::, NAV_Value:T:NAV Value:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Product Info:22:::644::, Total_Amount:T:Total Amount:Customer Information:Customer Info - {{client}} {{dialer_flag}}:Product Info~0:22:::644::, genericfilename:L:Generic Upload Name:::::::664::, genericfileselect:F:Generic Upload File:::::::664::, status:L:Record Status:::::::600::, workflowstatus:L:Workflow Status:::::::600::, client:S:PB Code:::::::666::, dialer_flag:::::::::666::VIP~Normal', 13),
('BZ101', 'company', 'monthworkdays~|agencyfeesvalue~|agencyfeefunction~|contractstartdate~|contractenddate~|insurancerequired~|servicedby~|contactname~|contactemail~|contactphone~|hrsendfiles~bnVsbA==|contactnameacct~|contactemailacct~|contactphoneacct~|offerletter~|confirmationletter~|promotionletter~|appraisalletter~|warningletter~|terminationletter~|nocletter~|experienceletter~|endofserviceletter~|yrmeternityleaves~|yrsickleaves~|yrannualleaves~|yemaxcarryleaves~|developerparam~|trackerfields~|campaignscript~|campaignCallingMode~|', 17),
('BZ101', 'coreconfig', 'HRFiledsStr=CAMP:L:CAMP:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~1:21:::644::,Application ID:L:Application ID:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Lead ID:L:Lead ID:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,First Entry QDE:L:First Entry QDE:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::664::,Branch Code:L:Branch Code:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Credit State:L:Credit State:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Business State:L:Business State:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Branch City:L:Branch City:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Scheme Group:L:Scheme Group:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Program Type:L:Program Type:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Customer Name:L:Customer Name:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Customer Type:L:Customer Type:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Risk Status:L:Risk Status:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,RO Code:L:RO Code:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Sanction Loan Amount :L:Sanction Loan Amount :Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Effective Rate:L:Effective Rate:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,First Start Date PDOC :L:First Start Date PDOC :Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Last UND-A Timestamp:L:Last UND-A Timestamp:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,FCU Hold Remarks:L:FCU Hold Remarks:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,FCU Sample Remarks:L:FCU Sample Remarks:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,FCU Screen Timestamp:L:FCU Screen Timestamp:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Current Workstep:L:Current Workstep:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,status:L:Status:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Channel:L:Channel:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Source:L:Source:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Referral Code:L:Referral Code:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Mission 24 Eligible:L:Mission 24 Eligible:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,mobile:L:Phone No:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Type:L:Type:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~0:21:::644::,status:L:Record Status:::::::600::,workflowstatus:L:Workflow Status:::::::600::,client:S:campaign name:::::::666::,dialer_flag:::::::::666::VIP~Normal\n\ndialerDispoList=CB|FollowUp|,Call Back-RPC,Call Back-TPC,Out of Station~IN|Interested|,Already Disbursed,Appointment Fixed~NC|No contact|,Number Busy,Require Extn Number,Call Drop,Wrong Number,Invalid Number,Out Of Service,Not Reachable,Ringing No Response,Switch Off~NI|Not Interested|,Already Loan applied Competitor,Does not Require loans,Requires High loan Amount,Requires Low Rate of interest,Requires Other loans LAP,Requires Other loans HL,Service Issues,Requires parallel PL', 19),
('Cibil Watch', 'company', 'monthworkdays~|agencyfeesvalue~|agencyfeefunction~|contractstartdate~|contractenddate~|insurancerequired~|servicedby~|contactname~|contactemail~|contactphone~|hrsendfiles~bnVsbA==|contactnameacct~|contactemailacct~|contactphoneacct~|offerletter~|confirmationletter~|promotionletter~|appraisalletter~|warningletter~|terminationletter~|nocletter~|experienceletter~|endofserviceletter~|yrmeternityleaves~|yrsickleaves~|yrannualleaves~|yemaxcarryleaves~|developerparam~|trackerfields~|campaignscript~|campaignCallingMode~|', 21),
('Cibil Watch', 'coreconfig', 'HRFiledsStr=Eligible_base_segments:L:Eligible_base_segments:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~1:21:::644::,LAN:L:LAN:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,BranchCode:L:BranchCode:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,ReallocatedBrCode:L:ReallocatedBrCode:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,city:L:city:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Cluster:L:Cluster:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,ImputedIncome:L:ImputedIncome:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Gross_monthly_Income:L:Gross_Monthly_Income:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Previous DisbursedAmount:L:Previous DisbursedAmount:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Previous IRR:L:Previous IRR:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Previous Tenor:L:Previous Tenor:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,MOB:L:MOB:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,POS:L:POS:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Eligible_TopUp_Amount:L:Eligible_TopUp_Amount:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Gross_EMI:L:Gross_EMI:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,EB_TopUp_ROI:L:EB_TopUp_ROI:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,impute_liability:L:impute_liability:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~0:21:::644::,Level1MaxLoanAmount:L:Level1MaxLoanAmount:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~2:22:::644::,CustomerPANNumberCAS:L:CustomerPANNumberCAS:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,CustomerPassportNumberCAS:L:CustomerPassportNumberCAS:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,CustomerVoterIDNumberCAS:L:CustomerVoterIDNumberCAS:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,DateOfBirth:L:DateOfBirth:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,STDCode:L:STDCode:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,ResiAddress:L:ResiAddress:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,ResiCity:L:ResiCity:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,ResiState:L:ResiState:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,ResiPostalCode:L:ResiPostalCode:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,OfficeCompanyName:L:OfficeCompanyName:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,OfficeAddress:L:OfficeAddress:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,OfficeCity:L:OfficeCity:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~0:22:::644::,OfficeState:L:OfficeState:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~2:22:::644::,OfficePostalCode:L:OfficePostalCode:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,ROCode:L:ROCode:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,SM Name:L:SM Name:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,Assign to City:L:Assign to City:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,Assign to Branch Code:L:Assign to Branch Code:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,EB FOS Code:L:EB FOS Code:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,mobile:L:Phone1:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,altphone1:L:Phone2:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,altphone2:L:Phone3:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,altphone3:L:Phone4:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,altphone4:L:Phone5:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,Langauage:L:Langauage:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,ResiState:L:ResiState:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,CustomerNameCAS:L:CustomerNameCAS:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~0:22:::644::,Level1MaxEMI:L:Level1MaxEMI:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~2:22:::644::,Level2MaxLoanAmount:L:Level2MaxLoanAmount:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,Level2MaxEMI:L:Level2MaxEMI:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,RiskGrade:L:RiskGrade:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,TopupScore:L:TopupScore:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,Market4Tag:L:Market4Tag:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,PreferredTag:L:PreferredTag:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,WinBackIndTag:L:WinBackIndTag:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,Product:L:Product:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,city:L:city:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,age:L:age:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,Age_Criteria:L:Age_Criteria:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,OMNICustomerID:L:OMNICustomerID:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,BranchName:L:BranchName:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,Tier:L:Tier:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,State:L:State:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,CustomerTitle:L:CustomerTitle:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,FirstName:L:FirstName:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,MiddleName:L:MiddleName:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,LastName:L:LastName:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,ApprefNo:L:ApprefNo:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,CustId:L:CustId:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,ProductCode:L:ProductCode:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,DateofDisbursal:L:DateofDisbursal:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,IRR:L:IRR:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,Tenor:L:Tenor:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,MOB:L:MOB:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,POS:L:POS:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,CurrentDPD:L:CurrentDPD:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,Bouncesinlast2EMIs:L:Bouncesinlast2EMIs:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,BounceInLife:L:BounceInLife:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,LiveorClosed:L:Live or Closed:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,LiveLANsagainstcustid:L:LiveLANsagainstcustid:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,CIBILScore:L:CIBILScore:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,IncrementalTag:L:IncrementalTag:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,PriorityTag:L:PriorityTag:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,IHO_Details:L:IHO_Details:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,ClosureDate:L:ClosureDate:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,CurrentEmi:L:CurrentEmi:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,OmniApprefNo:L:OmniApprefNo:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,LastInstallmentDate:L:LastInstallmentDate:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,PL48_LOAN_AMT_FINAL:L:PL48_LOAN_AMT_FINAL:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,CustomerGrading:L:CustomerGrading:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,CustomerType:L:CustomerType:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,EverDPD:L:EverDPD:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,TopUpPolicy:L:TopUpPolicy:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,Type:L:Type:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,Prospect1:L:Prospect1:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644::,ProductName:L:ProductName:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~0:22:::644::,client:S:Campaign Name:::::::666::,status:L:Record Status:::::::600::,workflowstatus:L:Workflow Status:::::::600::,dialer_flag:::::::::666::VIP~Normal\n\n\ndialerDispoList=CB|FollowUp|,Pending For Lead Generation,AIP Status Pending,Call Back-RPC,Call Disconnected by Customer,Call Disconnected by Customer,Call Back-TPC,Language Barrier- Tamil,Language Barrier- Telugu,Language Barrier- Kannada,Need a Call/Visit from SM,Out of Station~IN|Interested|,Top up Interested- No DOCS,Top up Interested- With DOCS,Top up Interested - With KYC~RP|Reprised|,Saved through Tenure reprise offer L1,Saved through Tenure reprise offer L2,Saved through EMI reprise offer L1,Saved through EMI reprise offer L2~NC|No contact|,No contact,Require Extn Number,Call Drop,Wrong Number,Invalid Number,Out Of Service,Not Reachable,Ringing No Response,Switch Off~NE|Not Eligible|,Address changed No Proof,AIP Red,Already Lead Generated,Low Job Stability,Jobless,BPO Profile Sal Not Met,Cash Salary,Contract Employee,Previous Cheque Bounce,Loan Availed Recently,Negative Profile,Latest EMI Cheque Bounce,Latest EMI Cheque Bounce,No Income Proof, Age Criteria Not Met,Profile Changed,Requires parallel PL,Salary below min income norms,Shifted to Non branch location ~NI|Not Interested|,Already Loan applied Competitor,Does not Require loans,Requires High loan Amount,Requires Low Rate of interest,Requires Other loans LAP,Requires Other loans HL,Customer Irrate-DND,Service Issues\n\n', 22),
('ABND', 'company', 'monthworkdays~|agencyfeesvalue~|agencyfeefunction~|contractstartdate~|contractenddate~|insurancerequired~|servicedby~|contactname~|contactemail~|contactphone~|hrsendfiles~bnVsbA==|contactnameacct~|contactemailacct~|contactphoneacct~|offerletter~|confirmationletter~|promotionletter~|appraisalletter~|warningletter~|terminationletter~|nocletter~|experienceletter~|endofserviceletter~|yrmeternityleaves~|yrsickleaves~|yrannualleaves~|yemaxcarryleaves~|developerparam~|trackerfields~|campaignscript~|campaignCallingMode~VXNlciBhYmxlIHNlbGVjdA==|', 23),
('ABND', 'coreconfig', 'HRFiledsStr=CAMP:L:CAMP:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~1:21:::644::,Application ID:L:Application ID:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Lead ID:L:Lead ID:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,First Entry QDE:L:First Entry QDE:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::664::,Branch Code:L:Branch Code:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Credit State:L:Credit State:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Business State:L:Business State:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Branch City:L:Branch City:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Scheme Group:L:Scheme Group:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Program Type:L:Program Type:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Customer Name:L:Customer Name:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Customer Type:L:Customer Type:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Risk Status:L:Risk Status:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,RO Code:L:RO Code:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Sanction Loan Amount:L:Sanction Loan Amount :Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Effective Rate:L:Effective Rate:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,First Start Date PDOC :L:First Start Date PDOC :Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Last UND-A Timestamp:L:Last UND-A Timestamp:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,FCU Hold Remarks:L:FCU Hold Remarks:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,FCU Sample Remarks:L:FCU Sample Remarks:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,FCU Screen Timestamp:L:FCU Screen Timestamp:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Current Workstep:L:Current Workstep:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,status:L:Status:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Channel:L:Channel:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Source:L:Source:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Referral Code:L:Referral Code:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Mission 24 Eligible:L:Mission 24 Eligible:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,mobile:L:Phone No:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Type:L:Type:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~0:21:::644::,status:L:Record Status:::::::600::,workflowstatus:L:Workflow Status:::::::600::,client:S:PB Code:::::::666::,dialer_flag:::::::::666::VIP~Normal\n\ndialerDispoList=CB|FollowUp|,Call Back-RPC,Call Back-TPC,Out of Station~IN|Interested|,Already Disbursed,Appointment Fixed~NC|No contact|,Number Busy,Require Extn Number,Call Drop,Wrong Number,Invalid Number,Out Of Service,Not Reachable,Ringing No Response,Switch Off~NI|Not Interested|,Already Loan applied Competitor,Does not Require loans,Requires High loan Amount,Requires Low Rate of interest,Requires Other loans LAP,Requires Other loans HL,Service Issues,Requires parallel PL\n', 24),
('Web and online', 'company', 'monthworkdays~|agencyfeesvalue~|agencyfeefunction~|contractstartdate~|contractenddate~|insurancerequired~|servicedby~|contactname~|contactemail~|contactphone~|hrsendfiles~bnVsbA==|contactnameacct~|contactemailacct~|contactphoneacct~|offerletter~|confirmationletter~|promotionletter~|appraisalletter~|warningletter~|terminationletter~|nocletter~|experienceletter~|endofserviceletter~|yrmeternityleaves~|yrsickleaves~|yrannualleaves~|yemaxcarryleaves~|developerparam~|trackerfields~|campaignscript~|campaignCallingMode~VXNlciBhYmxlIHNlbGVjdA==|', 25),
('Web and online', 'coreconfig', 'HRFiledsStr=Camp:L:Camp:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~1:21:::644::,Mass Channel:L:Mass Channel:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,City:L:City:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,City2:L:City2:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::664::,Tier:L:Tier:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Cluster:L:Cluster:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,State:L:State:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Region:L:Region:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Regional Head:L:Regional Head:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Lead Date:L:Lead Date:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Applicant Name:L:Applicant Name:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Loan Amt:L:Loan Amt:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,Send Date:L:Send Date:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,month:L:month:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,mobile:L:Mobile Number:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,client:S:Campaign Name:::::::666::,status:L:Record Status:::::::600::,workflowstatus:L:Workflow Status:::::::600::,dialer_flag:::::::::666::VIP~Normal\n\n\ndialerDispoList=CB|FollowUp|,Pending For Lead Generation,AIP Status Pending,Call Back-RPC,Call Disconnected by Customer,Call Disconnected by Customer,Call Back-TPC,Language Barrier- Tamil,Language Barrier- Telugu,Language Barrier- Kannada,Need a Call/Visit from SM,Out of Station~IN|Interested|, Interested~NC|No contact|,Number Busy,Require Extn Number,Call Drop,Wrong Number,Invalid Number,Out Of Service,Not Reachable,Ringing No Response,Switch Off~NE|Not Eligible|,Address changed No Proof,AIP Red,Already Lead Generated,Customer Expired,Low Job Stability,Jobless,BPO Profile Sal Not Met,Salary paid through Cash,Contract Employee,Previous Cheque Bounce,Loan Availed Recently,Negative Profile,Latest EMI Cheque Bounce,Negative DBR,No Income Proof,Proprietorship Firm,Partnership Firm,Rented bachlor,Beyond Geo Limit,Age Criteria Not Met,Profile Changed,Salary below min income norms,Shifted to Non branch location ~NI|Not Interested|,Already Loan applied Competitor,Does not Require loans,Requires High loan Amount,Requires Low Rate of interest,Requires Other loans LAP,Requires Other loans HL,Customer Irrate-DND,Service Issues,Requires parallel PL', 26),
('RNTCB', 'company', 'monthworkdays~|agencyfeesvalue~|agencyfeefunction~|contractstartdate~|contractenddate~|insurancerequired~|servicedby~|contactname~|contactemail~|contactphone~|hrsendfiles~bnVsbA==|contactnameacct~|contactemailacct~|contactphoneacct~|offerletter~|confirmationletter~|promotionletter~|appraisalletter~|warningletter~|terminationletter~|nocletter~|experienceletter~|endofserviceletter~|yrmeternityleaves~|yrsickleaves~|yrannualleaves~|yemaxcarryleaves~|developerparam~|trackerfields~|campaignscript~|campaignCallingMode~|', 27),
('RNTCB', 'coreconfig', 'HRFiledsStr=camp:L:camp:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~1:21:::644::,APPNO:L:APP NO:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,BRANCHSTATE:L:BRANCH STATE:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,BRANCH CITY:L:BRANCH CITY:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,BRANCH ID:L:BRANCH ID:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,DATE AND TIME OF APPLICATION:L:DATE AND TIME OF APPLICATION:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,CUSTOMER NAME:L:CUSTOMER NAME:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,AIP AMOUNT:L:AIP AMOUNT:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,RO CODE:L:RO CODE:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,CURRENT WORKSTEP:L:CURRENT WORKSTEP:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,status:L:STATUS:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,REJCANCOMMENTS:L:REJ/CAN COMMENTS:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,mobile:L:RESI MOBILE:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,client:L:Campaign Name:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,APP NO:L:APP NO:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644::,BRANCH STATE:L:BRANCH STATE:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::664::,BRANCH CITY:L:BRANCH CITY:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::664::,BRANCH ID:L:BRANCH ID:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::600::,DATE AND TIME OF APPLICATION:L:DATE AND TIME OF APPLICATION:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::600::,CUSTOMER NAME:L:CUSTOMER NAME:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::666::,AIP AMOUNT:L:AIP AMOUNT:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::666::,ROCODE:L:RO CODE:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::::,CURRENTWORKSTEP:L:CURRENT WORKSTEP:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::::,client:S:Campaign Name:::::::666::,status:L:Record Status:::::::600::,workflowstatus:L:Workflow Status:::::::600::\n\n\ndialerDispoList=CB|FollowUp|,Call Back-RPC,Call Back-TPC,Out of Station~IN|Interested|,Appointment Fixed~NC|No contact|,Number Busy,Require Extn Number,Call Drop,Wrong Number,Invalid Number,Out Of Service,Not Reachable,Ringing No Response,Switch Off~NI|Not Interested|,Already Loan applied Competitor,Does not Require loans,Requires High loan Amount,Requires Low Rate of interest,Requires Other loans LAP,Requires Other loans HL,Service Issues,Requires parallel PL', 28),
('EBPL', 'company', 'monthworkdays~|agencyfeesvalue~|agencyfeefunction~|contractstartdate~|contractenddate~|insurancerequired~|servicedby~|contactname~|contactemail~|contactphone~|hrsendfiles~bnVsbA==|contactnameacct~|contactemailacct~|contactphoneacct~|offerletter~|confirmationletter~|promotionletter~|appraisalletter~|warningletter~|terminationletter~|nocletter~|experienceletter~|endofserviceletter~|yrmeternityleaves~|yrsickleaves~|yrannualleaves~|yemaxcarryleaves~|developerparam~|trackerfields~|campaignscript~|campaignCallingMode~|', 29),
('EBPL', 'coreconfig', 'HRFiledsStr=Product:L:Product:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~1:21:::644,Branch_Code:L:Branch Code:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644,Reallocated Br Code :L:Reallocated Br Code :Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644,city:L:city:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644,Customer_Name_CAS:L:Customer Name CAS:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644,STD_Code:L:STD Code:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644,mobile:L:Phone 1:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644,Phone2:L:Phone 2:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644,Phone3:L:Phone 3:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644,Phone 4:L:Phone 4:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644,Phone5:L:Phone 5:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644,Level1_Max_Loan_Amount :L:Level 1 Max Loan Amount :Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644,Level1_Max_EMI :L:Level 1 Max EMI :Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644,Level_2_Max_Loan_Amount :L:Level 2 Max Loan Amount :Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644,Level_2_Max_EMI :L:Level 2 Max EMI :Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644,Risk_Grade:L:Risk Grade:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:21:::644,Top_up_Score:L:Top up Score:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~0:21:::644,Market_4_Tag:L:Market 4 Tag:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~2:22:::644,Preferred_Tag:L:Preferred Tag:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Win_Back_Ind Tag:L:Win Back Ind Tag:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Imputed_Income:L:Imputed Income:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Gross_Monthly_Income:L:Gross_Monthly_Income:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Eligible_TopUp_Amount:L:Eligible_TopUp_Amount:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Gross_EMI:L:Gross_EMI:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,EB_TopUp_ROI:L:EB_TopUp_ROI:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,impute_liability:L:impute_liability:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Eligible_base_segments:L:Eligible_base_segments:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,age:L:age:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Age_Criteria:L:Age_Criteria:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,LAN:L:LAN:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~0:22:::644,OMNICustomerID:L:OMNI Customer ID:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~2:22:::644,Branch Name:L:Branch Name:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Tier:L:Tier:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,State:L:State:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Customer_Title :L:Customer Title :Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,firstname:L:First Name :Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Appref_No :L:Appref No :Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Cust_Id:L:Cust Id:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Product_Code:L:Product Code:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Product_Name :L:Product Name :Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Date_of_Disbursal:L:Date of Disbursal:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Disbursed_Amount :L:Disbursed Amount :Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,IRR:L:IRR:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Tenor:L:Tenor:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,MOB:L:MOB:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,POS:L:POS:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Current_DPD:L:Current DPD:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~0:22:::644,Bouncesinlast2EMIs:L:Bounces in last 2 EMIs :Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~2:22:::644,Bounce_In_Life:L:Bounce In Life:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Live_Closed:L:Live Or Closed:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Live_LANs_against_cust_id:L:Live LANs against cust id:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Date_Of_Birth :L:Date Of Birth :Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Resi_Address :L:Resi Address :Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Resi_City:L:Resi City:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Resi_State:L:Resi State:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Resi_PostalCode:L:Resi PostalCode:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Office_Company_Name :L:Office Company Name :Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Office_ Address:L:Office Address:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Office_City:L:Office City:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Office_State:L:Office State:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Office PostalCode:L:Office PostalCode:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,RO Code:L:RO Code:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,CIBIL Score:L:CIBIL Score:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Incremental Tag :L:Incremental Tag :Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Priority Tag:L:Priority Tag:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,IHO_Details:L:IHO_Details:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Customer_PAN_Number_CAS:L:Customer PAN Number CAS:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Customer_Passport_Number_CAS:L:Customer Passport Number CAS:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Customer_VoterID_NumberCAS:L:Customer Voter ID Number CAS:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Closure_Date:L:Closure Date:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,CurrentEmi:L:Current Emi:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,OmniApprefNo:L:Omni Appref No:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,LastInstallmentDate :L:Last Installment Date :Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,PL48_LOAN_AMT_FINAL:L:PL48_LOAN_AMT_FINAL:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,CustomerGrading:L:Customer Grading:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,CustomerType:L:Customer Type:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,EverDPD:L:Ever DPD:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,TopUpPolicy:L:Top Up Policy:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info:22:::644,Type:L:Type:Customer Info:Customer Info – {{client}} {{dialer_flag}}:Customer Info~0:22:::644,client:S:Campaign Name:::::::666,status:L:Record Status:::::::600\n \ndialerDispoList=CB|FollowUp|,Pending For Lead Generation,AIP Status Pending,Call Back-RPC,Call Disconnected by Customer,Call Disconnected by Customer,Call Back-TPC,Language Barrier- Tamil,Language Barrier- Telugu,Language Barrier- Kannada,Need a Call/Visit from SM,Out of Station~IN|Interested|,Top up Interested- No DOCS,Top up Interested- With DOCS,Top up Interested - With KYC,DNC Sales CB~NC|No contact|,Number Busy,Require Extn Number,Call Drop,Wrong Number,Invalid Number,Out Of Service,Not Reachable,Ringing No Response,Switch Off~NE|Not Eligible|,Address changed No Proof,AIP Red,Already Lead Generated,Low Job Stability,Jobless,BPO Profile Sal Not Met,Cash Salary,Contract Employee,Previous Cheque Bounce,Loan Availed Recently,Negative Profile,Latest EMI Cheque Bounce,Negative DBR,No Income Proof, Age Criteria Not Met,Profile Changed,Requires parallel PL,Salary below min income norms,Shifted to Non branch location ~NI|Not Interested|,Already Loan applied Competitor,Does not Require loans,Requires High loan Amount,Requires Low Rate of interest,Requires Other loans LAP,Requires Other loans HL,Customer Irrate-DND,Service Issues', 30);
--
-- Indexes for dumped tables
--
--
-- Indexes for table `hrms_masters`
--
ALTER TABLE `hrms_masters`
ADD PRIMARY KEY (`mid`);
--
-- AUTO_INCREMENT for dumped tables
--
--
-- AUTO_INCREMENT for table `hrms_masters`
--
ALTER TABLE `hrms_masters`
MODIFY `mid` int(11) NOT NULL AUTO_INCREMENT, AUTO_INCREMENT=31;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;