Top of SRM | Index | Table of Contents | Feedback | ![]() |
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:
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:
|
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, |
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