Tablet Accessory User Manual

Database Schema Reference
Appendix B Engine Database Schema 343
Table B-18 WFHSessAttributes
Name Index Null? Type Description
SESSIONID
✔
NOT
NULL
NUMBER(38) Identifier for the session between the
engine and client application.
ATTNAME NOT
NULL
VARCHAR2(64) Name of a process attribute in the
session.
ATTTYPE NOT
NULL
NUMBER(38) The type of the process attribute.
ATTSEGMENTID NOT
NULL
NUMBER(38) Internal use only.
ATTSEGLENGTH NOT
NULL
NUMBER(38) Internal use only.
ATTVALUE NOT
NULL
VARCHAR2(255) The value of the attribute (in text
format).
SETNUMBER
✔
NOT
NULL
NUMBER(38) Internal use only.
Table B-19 WFHSession
Name Index Null? Type Description
ID
✔
NOT
NULL
NUMBER(38) Unique identifier for this client session.
SESSNAME VARCHAR2(64) The session name.
USERNAME VARCHAR2(64) The user name of the user on the session.
PROFILENAME VARCHAR2(64) The profile name of the user on the
session.
STATE NUMBER(38) The state of the session:
210 – WFSession.ACTIVE
220 – WFSession.SUSPENDED
SESSMODE NUMBER(38) Internal use only.
SESSTXID VARCHAR2(255) The transaction ID, used only in iIS
two-phase commit operations.
OTHERINFO VARCHAR2(64) The otherInfo attribute associated with a
user profile.