Skip Headers
Oracle® Health Sciences Information Gateway Secure Health Email Installation and Configuration Guide
Release 1.2

Part Number E22884-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

B OHIG Secure Health Email Tables

This appendix provides six OHIG Secure Health Email tables that list column names and their data type.

This appendix includes the following section:

B.1 Using the OHIG Secure Health Email Tables

This appendix includes the following OHIG Secure Health Email tables:

Table B-1 ADDRESS

COLUMN_NAME DATA_TYPE COMMENTS

ID

NUMBER(19,0)

Primary key

CREATETIME

TIMESTAMP(6)

Create time

DISPLAYNAME

VARCHAR2(255 BYTE)

Display name

DOMAINID

NUMBER(19,0)

Foreign key to address's DOMAIN

EMAILADDRESS

VARCHAR2(255BYTE)

Internal secure email address

ENDPOINT

VARCHAR2(255 BYTE)

Internal corporate email address

STATUS

NUMBER(10,0)

Object status (0=NEW, 1=ENABLED, 2=DISABLED)

TYPE

VARCHAR2(64 BYTE)

Type of address (should be "XD")

UPDATETIME

TIMESTAMP(6)

Update time


Table B-2 ANCHORFoot 1 

COLUMN_NAME DATA_TYPE COMMENTS

ID

NUMBER(19,0)

Primary key

CERTIFICATEDATA

BLOB

Anchor binary data

CERTIFICATEID

NUMBER(19,0)

<deprecated>

CREATETIME

TIMESTAMP(6)

Create time

FORINCOMING

NUMBER(1,0)

Use anchor for incoming messages (0=NO, 1=YES)

FOROUTGOING

NUMBER(1,0)

Use anchor for outgoing messages (0=NO, 1=YES)

OWNER

VARCHAR2(255 BYTE)

Domain hostname (see DOMAIN) or User name

STATUS

NUMBER(10,0)

Object status (0=NEW, 1=ENABLED, 2=DISABLED)

THUMBPRINT

VARCHAR2(255 BYTE)

Anchor thumbprint

VALIDENDDATE

TIMESTAMP(6)

Anchor expiration date

VALIDSTARTDATE

TIMESTAMP(6)

Anchor start date


Footnote 1 Changes to the ANCHOR table require a restart of the application.

Table B-3 CERTIFICATE

COLUMN_NAME DATA_TYPE COMMENTS

ID

NUMBER(19,0)

Primary key

CERTIFICATEDATA

BLOB

Certificate binary data

CREATETIME

TIMESTAMP(6)

Create time

OWNER

VARCHAR2(255 BYTE)

Certificate associated email address

PRIVATEKEY

NUMBER(1,0)

Holds public and private key (0=NO public only, 1=YES)

STATUS

NUMBER(10,0)

Object status (0=NEW, 1=ENABLED, 2=DISABLED)

THUMBPRINT

VARCHAR2(255 BYTE)

Certificate thumbprint

VALIDENDDATE

TIMESTAMP(6)

Certificate expiration date

VALIDSTARTDATE

TIMESTAMP(6)

Certificate start date


Table B-4 DOMAINFoot 1 

COLUMN_NAME DATA_TYPE COMMENTS

ID

NUMBER(19,0)

Primary key

CREATETIME

TIMESTAMP(6)

Create time

DOMAINNAME

VARCHAR2(255 BYTE)

Domain hostname

POSTMASTERADDRESSID

NUMBER(19,0)

Foreign key to domain's postmaster ADDRESS

STATUS

NUMBER(10,0)

Object status (0=NEW, 1=ENABLED, 2=DISABLED)

UPDATETIME

TIMESTAMP(6)

Update time


Footnote 1 Changes to the DOMAIN table require a restart of the application.

Table B-5 SEQUENCE

COLUMN_NAME DATA_TYPE COMMENTS

SEQ_COUNT

NUMBER(38,0)

Sequence count

SEQ_NAME

VARCHAR2(50 BYTE)

Sequence name


Table B-6 SETTINGFoot 1 

COLUMN_NAME DATA_TYPE COMMENTS

ID

NUMBER(19,0)

Primary key

CREATETIME

TIMESTAMP(6)

Create time

NAME

VARCHAR2(255 BYTE)

Setting name

STATUS

NUMBER(10,0)

Object status (0=NEW, 1=ENABLED, 2=DISABLED)

UPDATETIME

TIMESTAMP(6)

Update time

VALUE

VARCHAR2(1024 BYTE)

Setting value


Footnote 1 Changes to the SETTING table require a restart of the application.

Required and Optional SETTINGs

NAME DEFAULT VALUE COMMENT
Required SETTINGs      
AnchorStoreType n/a WS Required to be WS
PublicStoreType n/a WS Required to be WS
PrivateStoreType n/a WS Required to be WS
       
Optional SETTINGs      
AnchorResolverType uniform uniform, multidomain uniform
  • FORINCOMING anchors, are used for both incoming and outgoing messages

multidomain

  • FORINCOMING anchors, are used for incoming messages

  • FORINCOMING anchors, are used for outgoing messages

BadMessageSaveFolder null <directory name> Test directory for logging bad messages
IncomingMessageSaveFolder null <directory name> Test directory for logging incoming messages
OutgoingMessageSaveFolder null <directory name> Test directory for logging outgoing messages
RawMessageSaveFolder null <directory name> Test directory for logging raw messages