Nippin database

What is the NIPPIN?

For the secured exchange of their data the Nationaal Intermutualistisch College (NIC) / Collège Intermutualist National (CIN) provides the NIPPIN platform, i.e. Nationaal Intermutualistisch Platform (NIP) / Platforme Intermutualiste Nationale (PIN).

The platform aims at standardizing data exchanges between providers / institutions and the insurance corporations. The platform also wants to make new services available.

The different statuses of a Nippin_message in the database

Nippin_message information table

Granted privileges

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 registration code:

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

• Get nippin cleanup information:

select * from nippin_cleanup;

MyCareNet integration-specific queries

Only for hospitals that are using the Nippin integration in HD4DP v2.

• 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