C Oracle Health Sciences Information Gateway 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:

• Using the Secure Health Email Tables

C.1 Using the Secure Health Email Tables

This appendix includes the following OHIG Secure Health Email tables:

• Table C-1, "ADDRESS"

• Table C-2, "ANCHORChanges to the ANCHOR table require a restart of the application."

• Table C-3, "CERTIFICATE"

• Table C-4, "DOMAINChanges to the DOMAIN table require a restart of the application."

• Table C-5, "SEQUENCE"

• Table C-6, "SETTINGChanges to the SETTING table require a restart of the application."

Table C-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 (XD or SMTP)
UPDATETIME	TIMESTAMP(6)	Update time

Table C-2 ANCHOR^Foot 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 C-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 C-4 DOMAIN^Foot 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 C-5 SEQUENCE

COLUMN_NAME	DATA_TYPE	COMMENTS
SEQ_COUNT	NUMBER(38,0)	Sequence count
SEQ_NAME	VARCHAR2(50 BYTE)	Sequence name

Table C-6 SETTING^Foot 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

Table C-7 Required Settings

NAME	DEFAULT	VALUE	COMMENT
AnchorStoreType	n/a	WS	Required to be WS
PublicStoreType	n/a	WS	Required to be WS
PrivateStoreType	n/a	WS	Required to be WS

Table C-8 Optional Settings

NAME	DEFAULT	VALUE	COMMENT
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