C 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).

C.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 C-1 ARR_SYS_MSG

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