HIS_OBSERVATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: HEALTHE INTENT SOLUTONS OBSERVATION LOG
Definition: Stores Patients observation information
Table Type: ACTIVITY





Column Detail - HIS_OBSERVATION


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.
EVENT_DT_TM DATETIME Y The date and time the observation occurred.
HIS_OBSERVATION_ID DOUBLE N PRIMARY KEY
OBSERVATION_CREATED_DT_TM DATETIME Y The date and time the observation outcome was identified.
OBSERVATION_DESCRIPTION_CLOB LONGTEXT Y The description of the observation.
OBSERVATION_IDENT VARCHAR(100) N The unique identifier of the observation.
OBSERVATION_NAME VARCHAR(255) N The name of the observation.
OBSERVATION_NAME_KEY VARCHAR(255) N The key for the name of the observation.
PERSON_ID DOUBLE N This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
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 - HIS_OBSERVATION


Child Column in HIS_OBSERVATION(FK) Parent Table Name Parent Column Name
Parents: PERSON_ID PERSON PERSON_ID




Parent Column in HIS_OBSERVATION (PK) Child Table Name Child Column Name
Children: HIS_OBSERVATION_ID HIS_OBS_ACTIVITY HIS_OBSERVATION_ID
HIS_OBS_ACTIVITY_H HIS_OBSERVATION_ID


HIS_OBS_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Healthe Intent Solutions Observation Activity Log
Definition: Stores patient's observation activity information
Table Type: ACTIVITY





Column Detail - HIS_OBS_ACTIVITY


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.
HIS_OBSERVATION_ID DOUBLE N Uniquely identifies the observation information of the patient.
HIS_OBS_ACTIVITY_ID DOUBLE N Unique, generated number that identifies a single row on the HIS_OBS_ACTIVITY table.
LAST_UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated.
LAST_UPDT_PRSNL_ID DOUBLE N The id that caused the last insert or update of the row in the table.
STATUS_CD DOUBLE N Contains the code that defines the observation status for the 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 - HIS_OBS_ACTIVITY


Child Column in HIS_OBS_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: HIS_OBSERVATION_ID HIS_OBSERVATION HIS_OBSERVATION_ID
LAST_UPDT_PRSNL_ID PRSNL PERSON_ID




Parent Column in HIS_OBS_ACTIVITY (PK) Child Table Name Child Column Name
Children: HIS_OBS_ACTIVITY_ID HIS_OBS_ACTIVITY_H HIS_OBS_ACTIVITY_ID


HIS_OBS_ACTIVITY_H



Column Section Relationship Section Top of Page


Table-level Detail

Description: HealtheIntent Solutions Observation Activity History Log
Definition: Stores patient's observation activity information history
Table Type: ACTIVITY





Column Detail - HIS_OBS_ACTIVITY_H


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.
HIS_OBSERVATION_ID DOUBLE N Uniquely identifies the observation information of the patient.
HIS_OBS_ACTIVITY_H_ID DOUBLE N Unique, generated number that identifies a single row on the HIS_OBS_ACTIVITY_H table.
HIS_OBS_ACTIVITY_ID DOUBLE N Uniquely identifies the observation activity information of the patient.
LAST_UPDT_DT_TM DATETIME N The date and time the row was last inserted or updated by the process.
LAST_UPDT_PRSNL_ID DOUBLE N The id that caused the last insert or update of the row in the table using the process.
STATUS_CD DOUBLE N This field contains the code that defines the observation status for the 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 - HIS_OBS_ACTIVITY_H


Child Column in HIS_OBS_ACTIVITY_H(FK) Parent Table Name Parent Column Name
Parents: HIS_OBSERVATION_ID HIS_OBSERVATION HIS_OBSERVATION_ID
HIS_OBS_ACTIVITY_ID HIS_OBS_ACTIVITY HIS_OBS_ACTIVITY_ID
LAST_UPDT_PRSNL_ID PRSNL PERSON_ID