Table Detail Report

HE_OBJECT



Column Section Relationship Section Top of Page


Table-level Detail

Description: HE_OBJECT
Definition: Store serialized health expert objects for future reuse. These object will include knowledge base versions, resolved fact patterns, and other objects used to optimize processing by the health expert jobs.
Table Type: ACTIVITY





Column Detail - HE_OBJECT


Column Name Type Null? Definition
HE_OBJECT_ID DOUBLE N PRIMARY KEY
OBJECT_NAME VARCHAR(250) N Uniquely identifies the type of health expert object being serialized. The object name provides a way to group together object entries under a single name (type).
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - HE_OBJECT




Parent Column in HE_OBJECT (PK) Child Table Name Child Column Name
Children: HE_OBJECT_ID HE_OBJECT_ENTRY HE_OBJECT_ID


HE_OBJECT_ENTRY



Column Section Relationship Section Top of Page


Table-level Detail

Description: HE_OBJECT_ENTRY
Definition: Store ENTRIES for serialized health expert objects for future reuse. These object will include knowledge base versions, resolved fact patterns, and other objects used to optimize processing by the health expert jobs.
Table Type: ACTIVITY





Column Detail - HE_OBJECT_ENTRY


Column Name Type Null? Definition
ENTRY_NAME VARCHAR(250) N Uniquely identifies this entry by a name. Each entry may have only one row.
FULL_ENTRY_NAME LONGTEXT Y This column will be storing the keys for the fact pattern resolver cache, a key could be event set name, order catalog mnemonic, source string or identifier or concept CKI and source vocabulary for nomenclatures
HE_OBJECT_ENTRY_ID DOUBLE N PRIMARY KEY
HE_OBJECT_ID DOUBLE N Unique identifier of the health expert object name that this entry is saved under.
LONG_BLOB_ID DOUBLE N Reference to the long blob where then contents of the entry are serialized.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - HE_OBJECT_ENTRY


Child Column in HE_OBJECT_ENTRY(FK) Parent Table Name Parent Column Name
Parents: HE_OBJECT_ID HE_OBJECT HE_OBJECT_ID
LONG_BLOB_ID LONG_BLOB LONG_BLOB_ID


HE_RULE_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Health Expert Rule Group
Definition: Associates rule groups with appropriate rule text information
Table Type: REFERENCE





Column Detail - HE_RULE_GROUP


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
ACTIVE_STATUS_CD DOUBLE N Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
RULE_GROUP_CD DOUBLE N The code value for the rule group this row is for
RULE_GROUP_ID DOUBLE N Unique generated number that identifies a single row on the HE_RULE_GROUP table.
RULE_TEXT_ID DOUBLE N The reference to the rule text on long_text_reference
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - HE_RULE_GROUP


Child Column in HE_RULE_GROUP(FK) Parent Table Name Parent Column Name
Parents: ACTIVE_STATUS_CD CODE_VALUE CODE_VALUE
RULE_GROUP_CD CODE_VALUE CODE_VALUE
RULE_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID


HE_SESSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Health Expert Sessions
Definition: Keeps the current state of health expert rules sessions
Table Type: ACTIVITY





Column Detail - HE_SESSION


Column Name Type Null? Definition
BLOB_LENGTH DOUBLE Y original length of the blob. this should be the uncompressed length if the blob is compressed.
EXPIRATION_DT_TM DATETIME Y The date at which this session is considered expired.
JOB_INSTANCE_NBR DOUBLE Y This column is used to identify which instance of a health expert job is currently trying to process the session.
KNOWLEDGEBASE_NAME VARCHAR(100) N The unique name of the knowledge base associated with the session.
KNOWLEDGEBASE_VERSION VARCHAR(255) N ** OBSOLETE ** This column will be cleared of data or set to a constant value. No longer needed as part of unique index. This columns is being replaced by column KNOWLEDGEBASE_VERSION2
KNOWLEDGEBASE_VERSION2 VARCHAR(255) N The version number for the knowledgebase associated with the session.
LONG_BLOB_ID DOUBLE N The identifier of the row on the LONG_BLOB table containing persisted data.
PARENT_ENTITY_ID DOUBLE N The parent entity id associated with the session.
PARENT_ENTITY_NAME VARCHAR(30) N The parent entity name that is represented by the parent id.
PRIORITY DOUBLE N The priority in which the session will be executed
RULE_VERSION_NBR DOUBLE N The rule version this session was last executed against
SESSION_BLOB LONGBLOB Y long raw (BLOB) defined column stores large binary data for the session.
SESSION_ID DOUBLE N The unique identifier of the session.
STATUS_FLAG DOUBLE N The status of the session.
UPDT_APPLCTX DOUBLE N The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic.



Relationship Detail - HE_SESSION


Child Column in HE_SESSION(FK) Parent Table Name Parent Column Name
Parents: LONG_BLOB_ID LONG_BLOB LONG_BLOB_ID




Parent Column in HE_SESSION (PK) Child Table Name Child Column Name
Children: SESSION_ID HE_SESSION_CONSEQUENT SESSION_ID


HE_SESSION_CONSEQUENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Health Expert Session Consequents
Definition: Keeping the current state of health expert session consequents.
Table Type: ACTIVITY





Column Detail - HE_SESSION_CONSEQUENT


Column Name Type Null? Definition
ACTIVE_IND DOUBLE N The table row is active or inactive. A row is generally active unless it is in an inactive state such as logically deleted, combined away, pending purge, etc.
BEG_EFFECTIVE_DT_TM DATETIME Y The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time.
CERTAINTY DOUBLE N The certainty of this consequent. This will range from -100 to +100.
CONSEQUENT_NAME VARCHAR(100) N The name of the consequent.
CONSEQUENT_VALUE_TXT VARCHAR(255) N The value of the consequent.
END_EFFECTIVE_DT_TM DATETIME Y The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive.
EXPLANATION VARCHAR(255) N The explanation of why this consequent was inferred.
KNOWLEDGEBASE_NAME VARCHAR(100) Y The name of the Knowledgebase
SERIALIZED_CLASS VARCHAR(500) Y Class path of the SERIALIZED_OBJECT
SERIALIZED_OBJECT VARCHAR(4000) Y JSON representation of the consequent containing data outside the scope of a Simple Consequent
SESSION_CONSEQUENT_ID DOUBLE N The unique identifier for each session consequent row.
SESSION_ID DOUBLE N The identifier of the session this consequent is associated with.
UPDT_APPLCTX DOUBLE N The application context number from the record info block.
UPDT_CNT DOUBLE N Set to 0 on insert. Incremented by 1 on update. Used to recognize update conflict where data in a row updated by one application is at risk of being lost by a second application attempting to update the row.
UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
UPDT_ID DOUBLE N The person_id of the person from the personnel table (prsnl) that caused the last insert or update of the row in the table.
UPDT_TASK DOUBLE N The registered (assigned) task number for the process that inserted or updated the row.



Relationship Detail - HE_SESSION_CONSEQUENT


Child Column in HE_SESSION_CONSEQUENT(FK) Parent Table Name Parent Column Name
Parents: SESSION_ID HE_SESSION SESSION_ID




Parent Column in HE_SESSION_CONSEQUENT (PK) Child Table Name Child Column Name
Children: SESSION_CONSEQUENT_ID HE_CONSEQUENT_QUEUE SESSION_CONSEQUENT_ID