Nippin information

Nippin information

Last updated: 2024-02-09 11:33

Nippin message different status in the database:

StatusDescription
ARCHIVEDMessages are put on ARCHIVED only if the NippinCleanup table has 0 records. The messages will not be processed.
INVALIDXML payload is invalid, a ticket can be created at our Servicedesk
BUFFEREDnot used
ERRORHD4DP2.0 was not able to send the message to MyCarenet or SFTP folder
SENTHD4DP.20 was able to send the message to MyCarenet or SFTP folder

The ARCHIVED messages will completely be ignored and not touched anymore.  

Queries

Count records grouped by the type and status:

nippin=# select interface_type, status, count(id) from nippin_message group by interface_type,status;
 interface_type | status  | count
----------------+---------+-------
 FILE_SYSTEM    | SENT    |   117
 FILE_SYSTEM    | INVALID |   352
 FILE_SYSTEM    | TO_SEND |  9238
(3 rows)

Get all error and invalid information:

select id, message_id, project_id, dcd_id, payload_after_validation from nippin_message where status in ('INVALID', 'ERROR');

Get previous and current registrationcode:

select id, message_id, project_id, dcd_id, previous_registrationcode, current_registrationcode from nippin_message;

MyCareNet integration-specific queries

Count records with status SENT and group them based on the reference ID received from Mycarenet.

 select postresponse_tack_result_major, postresponse_tack_reference, count(*)  from nippin_message where status = 'SENT' group by status, postresponse_tack_result_major, postresponse_tack_reference;
  postresponse_tack_result_major   |     postresponse_tack_reference      | count
-----------------------------------+--------------------------------------+-------
 urn:nip:tack:result:major:success | ***** |   2
 urn:nip:tack:result:major:success | ***** |   88