SRMJ0010 - Send Batch Email Response

Purpose

This job sends email responses to Service Requests in Batch mode

SubSystem Enquiry Management
Normally Run by Enquiry Specialist

Anticipated Frequency

As required

Structure Blocks Send Service Request Response Email
Tab Parameters

 

The purpose of this job is to send email responses to Service Requests in batch mode. Each email may comprise a response contained in the body of the email, as well as one or more attachments. The subject text for the email is taken from the Request Correspondence Configuration. The email address to be used is sourced from the Person ID record if it exists; otherwise form a current address record or a current person delivery type destination record.

The function creates the following correspondence records:

  • Correspondence item
  • Correspondence detail
  • Correspondence detail attachment if required
  • Outgoing correspondence
  • Outgoing correspondence reference

The Issue Date and Message Content are populated in the Outgoing Correspondence/Correspondence Detail records.

This function also produces an exception report for any exceptions logged into the s_log_entry table while sending the email responses to Service Request person.

 

The Send Service Request Response Email block contains:

Parameters Tab

Select either ...

  • Log Creation Date (LOV)

Or a combination of the following parameters ...

  • Correspondence Type (LOV)
  • Service Request Organisational Unit (LOV)
  • Split Response If Max Size Exceeded check box

Rules/Notes:

Validations include:

  • The person does not have a current valid email address
  • Attachment file name not found in the specified directory
  • Response size exceeded maximum limit for sending
  • Attachment size exceeded maximum limit for sending.

Exception Report Layout:

Send Service Request Response Email - Batch Exception Report
         
Creation Date:        
Person ID Name Service Request ID Response ID Message Text
6 David Jones 1000 1110 Email Address is not a valid address.
         
Total Exceptions Reported: 1
Note: Person Name displayed will be person.context_block_name

Email Format produced for each Service Request ID and Response ID

Re: Request ID 657665 Part 1/10 <request_corr_configuration.display_request_id_ref concatenated with the service_request. request_id>

Dear John, < “Dear” concatenated with person.Preferred_given_name or person.given_name or person.title|| ‘ ‘ ||person.surname or person.surname, based on the request_corr_configuration.salutation field value >

If you missed your exam for medical reasons or special circumstances you can apply for a deferred exam. The deferred exam application form is available on the Student Central web-site. If you missed your exam because you misread the timetable you must contact your lecturer to see if he or she is able to make other arrangements for you.

Yours sincerely, < request_corr_configuration.signature_block >
V Helpful
Service Center Manager

OR

Dear John,

Re: Request ID 657665 Part 1/10

If you missed your exam for medical reasons or special circumstances you can apply for a deferred exam. The deferred exam application form is available on the Student Central web-site. If you missed your exam because you misread the timetable you must contact your lecturer to see if he or she is able to make other arrangements for you.

Yours sincerely,
V Helpful
Service Center Manager

Rules/Notes:

 

 

Below is the structure of the table columns and the source they are populated from.

CORRESPONDENCE_ITEM

Field Name Source/Value
CORRESPONDENCE_TYPE
Correspondence_type.correspondence_type
REFERENCE_NUMBER Auto generated number
CREATE_DT Sysdate
ORIGINATOR_PERSON_ID Request.person_id
REQUEST_NUM Request.request_num
S_JOB_NAME SRMJ0010
REQUEST_JOB_ID Request_job_run.request_job_id
OUTPUT_NUM 1
REQUEST_JOB_RUN_ID Request_job_run.request_job_run_id
CAL_TYPE Null
CI_SEQUENCE_NUMBER Null
COURSE_CD Null
CV_VERSION_NUMBER Null
UNIT_CD Null
UV_VERSION_NUMBER Null
S_OTHER_REFERENCE_TYPE SRV-RQST
OTHER_REFERENCE p_request_id|| ‘|’ || p_response_id
UPDATE_WHO User
UPDATE_ON Sysdate
COMMENTS Null

CORRESPONDENCE_DTL

Field Name Source/Value
CORRESPONDENCE_TYPE
Correspondence_type.correspondence_type
REFERENCE_NUMBER Correspondence_item.reference_number
S_CORD_FORMAT_TYPE Null
CORD_TEXT Null
EXTERNAL_REFERENCE Null
UPDATE_WHO User
UPDATE_ON Current date
S_MESSAGE_CONTENT_TYPE ‘TEXT/PLAIN’
MESSAGE_CONTENT Populated with the non-attachment category responses stored in a v_total_non_attachment_text variable. (crty.faq, crty.faq_response, ctry.response-text)
SUBJECT Request_corr_configuration.subject_text

CORRESPONDENCE_DTL_ATTACHMENT

Field Name Source/Value
CORRESPONDENCE_TYPE Correspondence_type.correspondence_type
REFERENCE_NUMBER Correspondence_item.reference_number
ATTACHMENT_NO Auto number (Used to uniquely identify each attachment associated with a specific correspondence detail record. For each correspondence_type reference_number it Starts with 1 and increments by one for each attachment file)
DESCRIPTION Filename of the attachment file. (attachment_filename.attachment_filename)
S_MESSAGE_CONTENT_TYPE Attachment_filename.s_message_content_type
(based on s_mime_content_type of the attachment_file for the filename of the attachment)
CHAR_ATTACHMENT If the attachment type (s_mime_content_type of the attachment file) is text/plain this column is populated with Contents of the response type attachment file
BINARY_ATTACHMENT If the attachment type (s_mime_content_type of the attachment file) is any other than text/plain this column is populated with Contents of the response type attachment file
URL_REFERENCE Null
FILE_NAME Attachment.attachment_filename
UPDATE_WHO User
UPDATE_ON Current date

OUTGOING_CORRESPONDENCE

Field Name Source/Value
PERSON_ID Service_request.request_person_id
CORRESPONDENCE_TYPE Correspondence_type.correspondence_type
REFERENCE_NUMBER Correspondence_item.reference_number
ISSUE_DT Current date
DT_SENT Current Date
UNKNOWN_RETURN_DT Null
ADDR_TYPE Null
TRACKING_ID Null
UPDATE_WHO User
UPDATE_ON Current date
COMMENTS Null
MESSAGE_SEQUENCE_NUMBER Sequence_number
S_MESSAGE_DELIVERY_TYPE ‘EMAIL’
MESSAGE_DESTINATION Person email address obtained from the person table or person_addr table or person_dlvry_type_dstntn table
MESSAGE_STATUS ‘CREATED’
MESSAGE_FAILURE_REASON Null (messaging functionality may update this)
S_MESSAGE_CONTENT_TYPE Correspondence_dtl.s_message_content_type

OUT_CORRESPONDENCE_REF

Field Name Source/Value
PERSON_ID
Service_request.request_person_id
CORRESPONDENCE_TYPE Correspondence_type.correspondence_type
REFERENCE_NUMBER Correspondence_item.reference_number
ISSUE_DT Correspondence_item.issue_dt
SEQUENCE_NUMBER Auto number generated
CAL_TYPE Null
CI_SEQUENCE_NUMBER Null
COURSE_CD Null
CV_VERSION_NUMBER Null
UNIT_CD Null
UV_VERSION_NUMBER Null
OTHER_REFERENCE p_request_id|| ‘|’ || p_response_id
S_OTHER_REFERENCE_TYPE ‘SRV-RQST’

S_LOG

Field Name Source/Value
S_LOG_TYPE
‘SRV-REQ-EM’
CREATION_DT Current Date
KEY p_correspondence_type||‘|’||
p_service_req_org_unit || ‘|’
||p_org_unit_start_dt
(These are the job parameters passed)

S_LOG_ENTRY

Field Name Source/Value
S_LOG_TYPE
‘SRV-REQ-EM’
CREATION_DT S_log.creation_dt
SEQUENCE_NUMBER S_log_entry.Sequence_number
KEY p_request_id||‘|’||
p_response_id||’|’||
p_service_req_org_unit||‘|’||
p_org_unit_start_dt || ‘|’ ||
serr.request_person_id (this is person id of the service request person)
MESSAGE_NUMBER S_MESSAGE.MESSAGE_NUMBER
TEXT S_MESSAGE.MESSAGE_TEXT

 

Last Modified on 16 June, 2005