SRMJ0040 - Service Request Response - Batch

Purpose

This job prints responses in batch mode

SubSystem Enquiry Management
Normally Run by Enquiry Specialist

Anticipated Frequency

As required

Structure Block Send Batch Email Service Request Response
Tab Parameters

 

This function enables a user to print responses in batch mode. It would be used where Response Method = Mail, Fax or In Person and Response Mode = Batch. The following details are added to each printed response: Date, Reference number of request, Salutation, Recipient’s address and Signature block. Salutation and Signature block details are taken from the Request Correspondence Configuration.

The function creates the following correspondence records:

  • Correspondence item
  • Correspondence detail
  • Outgoing correspondence
  • Service Request Response outgoing correspondence.

The Correspondence Type used is the Printed Correspondence Type defined in the Request Correspondence Configuration for the owner Org Unit and linked to this job.

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

The function creates a Person ID Group (PIG) containing the Person ID corresponding to each response printed. Note that a Person may be in the PIG more than once, since a Person my have more than one response in the same batch. The PIG can then be used to print mailing labels for the responses. The PIG will have a name that identifies it as a Service Request Response PIG, and will be date-stamped (date and time). The ownership of the Person ID Group defaults to the current user (i.e. the user who scheduled the job). This parameter allows the user access to the ID group for running IDGR2100 (see Produce Mailing Labels).

The function also creates a picking list that lists all the requests included in a batch print job, and the response method for each. There may be multiple requests per person ID in the same job. The list shows the following data:

  • Request ID
  • Person ID
  • Name (in Context Block Name format)
  • Response Method.

This job is accessed from the main menu.

 

The Send Batch Email Service Request Response block contains:

Parameters

Select either ...

  • Log Creation Date (LOV)

Or a combination of the following parameters ...

  • Correspondence Type (LOV)
  • Service Request Organisational Unit (LOV)

Rules/Notes:

Validations include:

  • No Correspondence Type defined for the job
  • No current Correspondence address

Layout of Each Service Request Response

Mr John Jones <person_display_v.title_name>
3 Lorimer Street <person_addr_mail_v.addr_line> (record1)
South Melbourne <person_addr_mail_v.addr_line> (record2)
VIC 3333 <person_addr_mail_v.addr_line> (record3)

11 May 2005 <sysdate>

Re: Request ID 657665 <request_corr_configuration.request_id_ref_text||’ ‘||service_request.person_request_id>

Dear John, <Refer to the logic specified in processing for saluation name>

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 Centre Manager

Rules/Notes:

A new page is started for each Response ID and the page number is restarted for each Request ID and Response ID. A page number is printed at the bottom right hand corner of each page.

Layout of the Picking List

Request ID Response ID Person ID Name Response Method
123462 10 623446 Jones, Mr John Mail
123463 20 544523 Smith, Ms Jane Mail
123464 50 656746 Jenkins, Ms Julia Mail
123465 70 544523 Smith, Ms Jane Fax
123466 100 345335 Green, Ms Jenny Fax
Rules/Notes:

Layout of the Batch Exception Report

Service Request Response – Batch Exception Report

Creation Date: <sysdate>

Person ID Name Request ID Response ID Message
6 DAVID JONES 100 89 No
Correspondence Type is defined for this job and Org Unit
1000052846 DAVIES, MISS POPPY 100 66 Person does not have a current correspondence address
Total Exceptions: 2
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
request_corr_configuation.correspondence_type
REFERENCE_NUMBER Sequence number
CREATE_DT Sysdate
ORIGINATOR_PERSON_ID Service_request.request_person_id
REQUEST_NUM Null
S_JOB_NAME SRMJ0040
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
request_corr_configuation.correspondence_type
REFERENCE_NUMBER Correspondence_item.reference_number
S_CORD_FORMAT_TYPE Text
CORD_TEXT Null
EXTERNAL_REFERENCE Null
UPDATE_WHO User
UPDATE_ON Current date
S_MESSAGE_CONTENT_TYPE Null
MESSAGE_CONTENT Null
SUBJECT Null

OUTGOING_CORRESPONDENCE

Field Name Source/Value
PERSON_ID Service_request.request_person_id
CORRESPONDENCE_TYPE request_corr_configuation.correspondence_type
REFERENCE_NUMBER Correspondence_item.reference_number
ISSUE_DT Correspondence_item.create_dt
DT_SENT Null
UNKNOWN_RETURN_DT Null
ADDR_TYPE Null
TRACKING_ID Null
UPDATE_WHO User
UPDATE_ON Current date
COMMENTS Null
MESSAGE_SEQUENCE_NUMBER Null
S_MESSAGE_DELIVERY_TYPE Null
MESSAGE_DESTINATION Null
MESSAGE_STATUS Null
MESSAGE_FAILURE_REASON Null
S_MESSAGE_CONTENT_TYPE Null

OUT_CORRESPONDENCE_REF

Field Name Source/Value
PERSON_ID
Service_request.request_person_id
CORRESPONDENCE_TYPE request_corr_configuation.correspondence_type
REFERENCE_NUMBER Correspondence_item.reference_number
ISSUE_DT Correspondence_item.create_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

 

Last Modified on 12 May, 2005