D Policy Monitor Database Overview

This section provides information about the following:

• "Overview of Policy Monitor Database"

  
  

  Note: The Policy Monitor is called the Audit Record Repository Server in Oracle Healthcare Master Person Index Working With IHE Profiles (Part Number E18591-01).

  
  

D.1 Overview of Policy Monitor Database

The Policy Monitor's audit syslog messages are inserted into the database table ARR_SYS_MSG (see the below table) whose columns parallel the structure of a rfc5424 syslog message (see http://tools.ietf.org/html/rfc5424). The remaining tables map the rfc3881 audit message structure (see http://tools.ietf.org/html/rfc3881) into database tables enabling Java Persistence Query Language (JPQL) features.

Table D-1 ARR_SYS_MSG

Column	Type
ID	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