HE_CONFIGURATION



Column Section Top of Page


Table-level Detail

Description: Health Expert Configuration
Definition: This table will contain all healthexpert configurations. (a place to store configurations that are specific to the health expert team.; )
Table Type: REFERENCE





Column Detail - HE_CONFIGURATION


Column Name Type Null? Definition
ACTIVE_IND DOUBLE Y 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.
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.
HE_CONFIGURATION_ID DOUBLE N PRIMARY KEY
HE_CONFIG_KB VARCHAR(250) Y The knowledgebase of configuration
HE_CONFIG_NAME VARCHAR(250) Y The name of configuration
HE_CONFIG_TYPE VARCHAR(25) Y The type of configurations that the row is associated with
HE_CONFIG_VALUE VARCHAR(500) Y The value of configuration;
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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.


HE_CONSEQUENT_QUEUE



Column Section Relationship Section Top of Page


Table-level Detail

Description: HEALTH EXPERT CONSEQUENT QUEUE
Definition: This table will contain all healthexpert session consequents to be published
Table Type: ACTIVITY





Column Detail - HE_CONSEQUENT_QUEUE


Column Name Type Null? Definition
HE_CONSEQUENT_QUEUE_ID DOUBLE N PRIMARY KEY
JOB_INSTANCE_NBR DOUBLE Y The instance number of the publishing job currently publishing the consequent.;
KNOWLEDGEBASE_NAME VARCHAR(100) Y The unique name of the knowledge base associated with the session.
PRIORITY_NBR DOUBLE Y The priority of each consequent to be published
SESSION_CONSEQUENT_ID DOUBLE Y The ID of the consequent to be published (FK) from the he_session_consequent
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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_CONSEQUENT_QUEUE


Child Column in HE_CONSEQUENT_QUEUE(FK) Parent Table Name Parent Column Name
Parents: SESSION_CONSEQUENT_ID HE_SESSION_CONSEQUENT SESSION_CONSEQUENT_ID


HE_JOB



Column Section Relationship Section Top of Page


Table-level Detail

Description: Health Expert Jobs
Definition: Keeps the current state of health expert priming and coherency stateful session jobs.
Table Type: ACTIVITY





Column Detail - HE_JOB


Column Name Type Null? Definition
CURRENT_POINT VARCHAR(2000) N ** OBSOLETE **The current point of the job's progress.** THIS COLUMN BECOMES OBSOLETE AFTERTHE ADDITION OF COLUMN CURRENT_POINT_BLOB.
CURRENT_POINT_BLOB LONGBLOB Y This new column will store the coherency job points along with fact vestiges.
END_POINT VARCHAR(2000) Y The point where the job should end (for Priming jobs only).
JOB_ID DOUBLE N The unique identifier for each job row.
LAST_ACTION_BY_ID DOUBLE N The last prsnl_id of the person who took the last action.
LAST_ACTION_BY_NAME VARCHAR(100) Y The name of the person who took the last action on the job
LAST_ACTION_DT_TM DATETIME Y The date/time of the last action taken on this job.
STARTED_BY_ID DOUBLE N The prsnl_id of the person who started the job.
STARTED_BY_NAME VARCHAR(100) Y The name of the person who started the job.
STARTED_DT_TM DATETIME Y The date/time the job was started.
START_POINT VARCHAR(2000) Y The point where the job should start (for Coherency jobs only).
STATUS_FLAG DOUBLE N The status of the job.
TYPE_FLAG DOUBLE N The type of Job (Priming or Coherency)
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_JOB




Parent Column in HE_JOB (PK) Child Table Name Child Column Name
Children: JOB_ID HE_JOB_ATTRIBUTE JOB_ID


HE_JOB_ATTRIBUTE



Column Section Relationship Section Top of Page


Table-level Detail

Description: UPDT_ID NUMBER DEFAULT 0 NOT NULL
Definition: Used to keep track of all attributes related to a health expert job.
Table Type: ACTIVITY





Column Detail - HE_JOB_ATTRIBUTE


Column Name Type Null? Definition
ATTRIBUTE_NAME VARCHAR(100) N The name of the attribute being saved for the job.
ATTRIBUTE_VALUE_TXT VARCHAR(255) Y The value of the attribute being saved for the job.
JOB_ATTRIBUTE_ID DOUBLE N The unique identifier for each job detail row.
JOB_ID DOUBLE N The unique identifier for each job row.
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_JOB_ATTRIBUTE


Child Column in HE_JOB_ATTRIBUTE(FK) Parent Table Name Parent Column Name
Parents: JOB_ID HE_JOB JOB_ID


HE_KNOWLEDGEBASE



Column Section Relationship Section Top of Page


Table-level Detail

Description: HE KNOWLEDGE BASE
Definition: Track the state and versioning of knowledge bases used by health expert.
Table Type: ACTIVITY





Column Detail - HE_KNOWLEDGEBASE


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 N 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.
KNOWLEDGEBASE_ID DOUBLE N PRIMARY KEY
KNOWLEDGEBASE_NAME VARCHAR(100) N The name of the knowledge base instance. Each knowledge base must have a unique name. (CAN BE MULTIPLE VERSIONS PER KNOWLEDGEBASE NAME)
KNOWLEDGEBASE_VERSION VARCHAR(255) N The rule version number of this instance of the knowledge base.
OVERRIDE_FACT_VERSION VARCHAR(255) Y Indicates what fact type version was ovrerridden
OVERRIDE_RULE_VERSION_IND DOUBLE N Indicates if the rule version was overridden.
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.
VERSION_BLOB_ID DOUBLE N A reference to a blob which is a serialized representation of the knowledge base version.



Relationship Detail - HE_KNOWLEDGEBASE


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