SRMJ0020 - Send Immediate Email Response

Purpose

This job sends an immediate single email response after its creation.

SubSystem Enquiry Management
Normally Run by Enquiry Specialist

Anticipated Frequency

As required

Structure Block No block

 

The purpose of this job is to send a single email response immediately after the creation of the response. It is activated from the Send button in Maintain Service Request Response (SRMF2200). The email comprises 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 taken from the Person table record if possible, otherwise from a current person address record or a valid person delivery type destination record respectively.

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 job has no block and is run when the Send button is selected in Maintain Service Request Response (SRMF2200).

 

No block

Rules/Notes:

Validations include:

  • No Correspondence Type found (checking that the Correspondence Type they entered exists).
  • 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 .

Example of an email response:

Re: Request ID 657665

Dear John,

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 Sequence number
CREATE_DT Sysdate
ORIGINATOR_PERSON_ID Request.person_id
REQUEST_NUM Null
S_JOB_NAME SRMJ0020
REQUEST_JOB_ID Null
OUTPUT_NUM 1
REQUEST_JOB_RUN_ID Null
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.resp-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 Sysdate
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

 

Last Modified on 16 June, 2005