Top of SRM | Index | Table of Contents | Feedback | ![]() |
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:
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 ...
Or a combination of the following parameters ...
|
Rules/Notes: Validations include:
|
||||||||||||||||||||||||||||||||||||||||
Exception Report Layout:
|
|||||||||||||||||||||||||||||||||||||||||
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 > 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, |
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