search

mtcuison / Telemarketing-3C

0 stars 0 forks source link

Re-activation of 3C System #1

Open mtcuison opened 1 year ago

mtcuison commented 1 year ago

Programs:

  1. Running on server in java. Proposed utility interval is 5minis.
  2. 3C System(Call Center.exe, ggcCallModem.dll, ggcLRCollUnitSched.dll)

Rules:

  1. Customers that will appear as leads must be 1 to 2 months delayed or partially paid for a monthly payment
  2. 3C agent must be registered on LR_3C_Agent table to authorize use of the system
  3. Calls are done using mobile phones provided to agents

Main Form image

Press F2 to before call.

image

Call status can be (Answered, No Answer or Unattended)

image

If answered, agent can encode the conversation and if the customer promises to pay. Please explore the input fields. If no answer or unattended, the system will inform the user to call the customer again for up to three times. If still unanswered, another customer will be generated for call.

How to check if there is a customer for call? SELECT sTransNox, nDelayAvg, dLastPaym, dTransact, cAcctStat FROM (SELECT a.sTransNox, a.sAsgAgent, a.sAgentIDx, a.cTranStat, b.nDelayAvg, b.dLastPaym, b.cAcctStat, a.dTransact FROM LR_Calls_Master a, MC_AR_Master b WHERE a.sAcctNmbr = b.sAcctNmbr AND a.dTransact >= '2023-08-01' AND ( ( a.cTranStat IS NULL OR a.cTranstat = '0' ) OR ( ( a.cTranStat = '6' OR a.cTranStat = '5' ) ) ) AND ( a.sAgentIDx = '' OR a.sAgentIDx = 'M00111005387' ) ORDER BY a.dTransact DESC, a.sTransNox DESC LIMIT 100) Source WHERE sTransNox > '' ORDER BY sTransNox LIMIT 1;

If no record was found, inform mac.

Affected tables: LR_Calls_Master LR_Calls_Detail LR_Collection_Unit LR_3C_Appointment

Note: This system is not going thru replication log. Because it is only used by main office and to save storage for database.

Implementation contact person: Mam Loraine Buclares RG Caraulia - Team Lead 3C

Thank you.

szirabanal commented 1 year ago

good morning po sir's, report ko lang po yung concern upon testing yesterday sa Telemarketing-3C System.

Appointment Type - 3C \ sa 3C lang po ito; sa DATE TRANSACT, palitan nalang po to DATE APPOINTMENT yung Label kasi jan po tayo mababase kung anong sasabihin ni customer at kung kailan iaadjust yung date as promise to pay.

F8 - encoding the details or reasons while having a conversation between the user and the customer. \ nakakapag encode na po kasi kahit hindi pa napipindot yung F8.