Oracle® Health Sciences Information Manager Policy Monitor Installation and Configuration Guide Release 3.0 E61289-01 |
|
|
PDF · Mobi · ePub |
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).The Policy Monitor's audit syslog messages are inserted into the database table ARR_SYS_MSG (see Table C-1) or ARR_SYS_MSG_DI (see Table C-2) 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 http://tools.ietf.org/html/rfc5424
). The tables whose name do not end with the string _DI, map the rfc3881 audit message structure (see http://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.
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 |
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