Policy Monitor database overview

This section provides information about the Policy Monitor database. The Policy Monitor is called the Audit Record Repository Server in Oracle Healthcare Master Person Index Working With IHE Profiles (Part Number E18591-01).

The Policy Monitor's audit syslog messages are inserted into the database table ARR_SYS_MSG (see table below) or ARR_SYS_MSG_DI (see table below) based on the message structure in the received syslog message (RFC-3881 XML Schema compliant or DICOM XML Schema complaint). The columns in the table are parallel to the structure of a rfc5424 syslog message (see https://datatracker.ietf.org/doc/html/rfc5424). The tables whose name do not end with the string _DI, map the rfc3881 audit message structure (see https://tools.ietf.org/html/rfc3881) into database tables. The tables whose name end with the string _DI, map the dicom audit message structure (http://dicom.nema.org/medical/dicom/current/output/html/part15.html#sect_A.5.1) into database tables. These tables enable the data querying using JavaPersistence Query Language (JPQL) features.

Table B-1 ARR_SYS_MSG database table

Column	Type
ID	NUMBER
TRANSPORT	VARCHAR
LOCALADDR	VARCHAR
LOCALHOST	VARCHAR
LOCALPORT	NUMBER
REMOTEADDR	VARCHAR
REMOTEHOST	VARCHAR
REMOTEPORT	NUMBER
FACILITY	NUMBER
SEVERITY	NUMBER
PRIORITY	NUMBER
VERSION	NUMBER
TIMESTAMP	DATE
HOSTNAME	VARCHAR
APPLICATIONNAME	VARCHAR
PROCESSID	VARCHAR
MESSAGEID	VARCHAR
STRUCTUREDDATA	VARCHAR
MESSAGEENCODING	VARCHAR
MESSAGERAWBYTES	BLOB
ADT_MSG_ID	NUMBER

Table B-2 ARR_SYS_MSG_DI

Column	Type
ID	NUMBER
TRANSPORT	VARCHAR
LOCALADDR	VARCHAR
LOCALHOST	VARCHAR
LOCALPORT	NUMBER
REMOTEADDR	VARCHAR
REMOTEHOST	VARCHAR
REMOTEPORT	NUMBER
FACILITY	NUMBER
SEVERITY	NUMBER
PRIORITY	NUMBER
VERSION	NUMBER
TIMESTAMP	DATE
HOSTNAME	VARCHAR
APPLICATIONNAME	VARCHAR
PROCESSID	VARCHAR
MESSAGEID	VARCHAR
STRUCTUREDDATA	VARCHAR
MESSAGEENCODING	VARCHAR
MESSAGERAWBYTES	BLOB
ADT_MSG_DICOM_ID	NUMBER

Note:

If parsing of audit message fails, the Policy Monitor stores the messageRawBytes and other data elements of received messages in:

• ARR_SYS_MSG database table if the messageID value is IHE+RFC-3881
• ARR_SYS_MSG_DI database table if the messageID value is IHE+DICOM or some arbitrary string