Inquiry Response Process, ExcelOnline Branch 20230825
This process manages the progress of an inquiry from receipt to response. The response person is automatically allocated according to the product inquired about. The assignment is based on a master table in Excel Online.
Worker (#of Swimlane: 4)
  • General Inquiry Desk Leader
    • Head of the inquiry response team.
  • Development Section 1
    • Department responsible for responding to inquiries.
  • Development Section 2
    • Department responsible for responding to inquiries.
  • Development Section 3
    • Department responsible for responding to inquiries.
Business Flow (Complexity of Workflow: 21)
  • 61. Designation of Target Products
    • The person responsible for the enquiry response team will amend the enquiry if necessary.
  • 132-1. Answer
    • The query responder enters the answer.
  • 352-2. Answer
    • The query responder enters the answer.
  • 362-3. Answer
    • The query responder enters the answer.
  • 193. Evaluation of response
    • The head of the enquiry response team evaluates the results of the response.
  • 8x1. Subject
    • The workflow platform sets the subject line.
  • 9x2. Subject, Destination, Response Email Text
    • The workflow platform sets the recipients of response emails, etc.
  • 39 x3. Selection ID → Converted to String type
  • 33 x4. Product Master Search
  • 38 x5. Product Master Data Acquisition
Business Process Variables (#of Data Item: 25)
  • ▼ Contact Information ▼ 0
  • Name q_name 1 *
  • Company Name q_company 2 *
  • Email Addressq_email3*
    • The email address of the enquiring party is stored.
  • Telephone Numberq_tel4
    • The telephone number of the enquiring party is stored.
  • ▼ Inquiry Form ▼ 6
  • Date Receivedq_receiveDatetime7
    • The date and time of receipt of the query is stored.
    • processInstanceStartDatetime
  • Inquiry IDq_id8
    • #{#sformat(‘%d’, processInstanceId)}#{#sformat(‘%04d’, processInstanceSequenceNumber)}
  • Target Product q_product 25
  • Search String q_searchKey 18
  • Search hit line q_hitRow 19
  • Data obtained (department in charge) q_hitData 24
  • Inquiry Detailq_inquiryDetail12*
    • The query details are stored.
  • Inquiry Filesq_inquiryFile13
    • The files relevant to the query are stored.
  • ▼ Response Details ▼ 14
  • Handlerq_operator16
    • The person in charge of creating the query response is stored.
  • Date and Time of Responseq_responseDatetime17
    • The date and time of the response to the enquirer is stored.
  • Reply Email Addressq_mailTo20
    • Contains the address to which query response emails are sent.
  • Reply Email Sent Fromq_mailFrom21
    • The source address of the query response email is stored.
    • customer-service@example.com
  • Response Email Textq_mailBody22
    • The body of the enquiry response email is stored.
  • Files related to the responseq_responseFile33
    • The files related to the query answers are stored.
  • ▼ Internal Communication ▼ 29
  • Correspondence Ratingq_point30
    • The grade for the response to the query is stored.
  • Knowledge should be shared within the companyq_knowledgeFlag31
    • The content and results of the enquiry are stored whether the knowledge should be shared within the company or not.
  • Commentsq_comment32
    • Notes and comments are stored.

Field Name, num, Initial Value

Download

This archive contains the BPMN icons that are not available in the Basic edition.

Notes

Capture

See also

%d bloggers like this: