ADMR3910- CHESSN Allocation Report

Purpose

This function enables the reporting of errors and outcomes from CHESSN Allocation or retrieval processing

Subsystem Admissions
Normally Run By Administration Specialist
Anticipated Frequency As required
Structure Block CHESSN Allocation Report
Tab Parameters
Button Find Person (ADMF1211)

 

This function will be run as part of the Batch CHESSN Allocation Results (ADMJ3910) process or on demand as required.
The report includes:

  • Request/Response detail and messages from within the Request and Request Message tables.
  • Transaction Request/Response detail and messages from within the Transaction and Transaction Message tables.

For further information see Maintain Person CHESSN (ADMF32W0); Person CHESSN Detail History (AUDF3192), or Batch CHESSN Allocation Results (ADMJ3910).

 

The CHESSN Allocation Report block contains:

Parameters Tab

  • Process Results check box
  • Request ID (LOV)
  • Person ID
  • Transaction Status

    Button

Rules/Notes:

Process Results check box and Transaction Status are Mandatory. 

Validations include:

  • At least one of Request ID or Person ID must be specified
  • Person ID selected does not exist within the HEIMS_TRANSACTION table
  • If Process Results is checked then both the Request & Person IDs must be %
  • Person ID selected does not exist within the selected Request ID
  • Request ID selected and the Person ID specified doesn’t exist within that request
  • Process Results check box
    Can be checked to ‘Request Results’ or can be unchecked to run ‘Report Only’.
    If checked, then both Request ID and Person ID will be %. If unchecked, then existing Validations for both Request ID and Person ID described in Rules/Notes apply
  • Request ID
    Value can be % (ALL) or a Request ID existing in HEIMS_REQUEST. If % then Person ID must be set. Must be set to Null if Process Results is checked
  • Person ID
    Value can be % (ALL) or a Person ID existing in HEIMS_TRANSACTION. If % then Request ID must be set. Must be set to Null if Process Results is checked
  • Transaction Status
    INVALID/FAILURE or INVALID/FAILURE/WARNING or ALL

This report will be run using the following two methods:

  • As part of the Batch CHESSN Allocation Results (ADMJ3910) process, which will only occur when the Process Results parameter is checked
  • By running the report for a previous request, that is, when the Process Results parameter is unchecked and specified parameters described above are entered.

To run this function as part of the Batch CHESSN Allocation Results (ADMJ3910) process (the Process Results parameter is checked), the s_job entry details for ADMJ3910 is modified to execute this report, where this report initially activates the Batch CHESSN Allocation Results package. Using the Results Request Job Run ID generated within ADMJ3910 process, this report accepts this Request Job Run ID as a parameter and assigns the value of ‘%’ to both Request ID and Person ID on the parameter form. A selection can then be made for the required Transaction Status – the default being ‘INVALID/FAILURE’. Based on this information, this reports on all errors and outcomes created from the Batch CHESSN Allocation Results process.

If a report needs to reproduced, achieved by not checking the Process Results parameter, then the Batch CHESSN Allocation Results package will not be activated in this instance. At least one of Request ID and Person ID must be set, i.e. cannot be NULL.

If the report produces no records when scheduled, that is, when there are no outstanding requests, then the report is still produced with a message specifying that no records were found.

The processing of the report, based on the possible parameter scenarios above, retrieves necessary information from the HEIMS Request, HEIMS Request Message, HEIMS Transaction and HEIMS Transaction Message tables.

Rules/Notes: 

The processing of the report allows the report to be executed, based on the following scenarios:

Parameters/Possible Values:

Scenario Process
Results
Request
ID
Person
ID
Transaction
Status
Outcome
1 tick % % INVALID/FAILURE or
INVALID/FAILURE/ WARNING or ALL
Request Results
+
Report Produced
2   1 % INVALID/FAILURE or
INVALID/FAILURE/ WARNING or ALL
Report Produced Only – For all persons in Request ID
3   % 12345 INVALID/FAILURE or
INVALID/FAILURE/ WARNING or ALL
Report Produced Only – For all requests in which person 12345 in included
4   1 12345 INVALID/FAILURE or
INVALID/FAILURE/ WARNING or ALL
Report Produced Only – for request ID 1 and person 12345

 

 

An example of the report:

CHESSN Allocation Report
Request ID Request Time Status HEIMS Request Status HEIMS Request Status Last Interaction Date
1 21-Jun-2004 11:59:21 COMPLETE SUCCESS SUCCESS  
           
Message Code Description   Severity    
108  The Request ID given does not match ERROR    
109  Request ID error ERROR    
           
Person ID Person Name Record Status Message Code Severity Description
3 Maxwell Smart INVALID 10714 ERROR The returned CHESSN exists
888 Sam Smart INVALID 10714 ERROR The returned CHESSN exists

 

Last Modified on 15 September, 2003