HEALTH_CONCERN



Column Section Relationship Section Top of Page


Table-level Detail

Description: HEALTH CONCERNS
Definition: Health Concerns of Patients outside of Family or Social Histories
Table Type: ACTIVITY





Column Detail - HEALTH_CONCERN


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.
ACTIVE_STATUS_DT_TM DATETIME N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
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.
CATEGORY_CD DOUBLE N Defines the type of health concern. (transportation, pyschosocial etc) from code set 4270007
COMMENTS VARCHAR(500) Y COMMENTS
CONCERNED_PERSON_RELTN_CD DOUBLE N the individual with a health concern for the patient. Value from code set 12023
DESCRIPTION VARCHAR(500) N The concern associated to the patient
DOCUMENTED_ENCNTR_ID DOUBLE N Encounter on which the health concern was documented
END_EFFECTIVE_DT_TM DATETIME N 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.
HEALTH_CONCERN_GROUP_ID DOUBLE N This field contains a value (pulled from the sequence) which groups Health Concerns.
HEALTH_CONCERN_ID DOUBLE N PRIMARY KEY
HEALTH_CONCERN_INSTANCE_UUID VARCHAR(255) N INSTANCE UNIQUE IDENTIFIER
HEALTH_CONCERN_UUID VARCHAR(255) N Used to version related health concerns.
LAST_UPDT_DT_TM DATETIME N The date and time this row was last updated by personnel.
LAST_UPDT_ENCNTR_ID DOUBLE N The identifier of the encounter on which the health concern is last updated.
LAST_UPDT_ID DOUBLE N Identification of the person who performed the Last Update on this row.
NOMENCLATURE_ID DOUBLE N The Nomenclature term that was searched by a user to add the health concern.
ONSET_DT_TM DATETIME Y Absolute Date for the Concern Onset
PERSON_ID DOUBLE N Person identifier
RECORDED_DT_TM DATETIME Y DATE AND TIME THE C ONCERN WAS RECORDED
RECORDED_PRSNL_ID DOUBLE N PERSON WHO RECORDED THE CONCERN
RESOLVED_DT_TM DATETIME Y DATE The Concern was Resolved
RESOLVED_PRSNL_ID DOUBLE N The USER shom marked the health concern as resolved
STATUS_CD DOUBLE N The status of the health concern. (active, inactive, resolved, canceled)
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 - HEALTH_CONCERN


Child Column in HEALTH_CONCERN(FK) Parent Table Name Parent Column Name
Parents: DOCUMENTED_ENCNTR_ID ENCOUNTER ENCNTR_ID
LAST_UPDT_ENCNTR_ID ENCOUNTER ENCNTR_ID
HEALTH_CONCERN_GROUP_ID HEALTH_CONCERN HEALTH_CONCERN_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
PERSON_ID PERSON PERSON_ID
LAST_UPDT_ID PRSNL PERSON_ID
RECORDED_PRSNL_ID PRSNL PERSON_ID
RESOLVED_PRSNL_ID PRSNL PERSON_ID




Parent Column in HEALTH_CONCERN (PK) Child Table Name Child Column Name
Children: HEALTH_CONCERN_ID HEALTH_CONCERN HEALTH_CONCERN_GROUP_ID


HISTORY_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: HISTORY ACTION
Definition: Track users reviewing the patient's history data captured through powerforms or powernote in the Social, Family, Past Medical, Procedure and Pregnancy history components.
Table Type: ACTIVITY





Column Detail - HISTORY_ACTION


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N Review action taken date time
ACTION_DT_TZ DOUBLE N Review action taken date time zone
COMP_TYPE_MEAN VARCHAR(12) N Name of the history component that review action was taken
ENCNTR_ID DOUBLE N This is the value of the unique primary identifier of the encounter table. It is an internal system assigned number.
HISTORY_ACTION_ID DOUBLE N this is the table's primary key. the unique identifier for a history_action table.
PERSON_ID DOUBLE N this is the value of the unique primary identifier of the person table. it is an internal system assigned number.
PRSNL_ID DOUBLE N prsnl id. 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.
VIEW_TYPE_MEAN VARCHAR(12) N History view type when the review action was taken



Relationship Detail - HISTORY_ACTION


Child Column in HISTORY_ACTION(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
PRSNL_ID PRSNL PERSON_ID


SHX_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: SHX_ACTION
Definition: Each row on the table represents clinician's access to the patient's social history assessment record
Table Type: ACTIVITY





Column Detail - SHX_ACTION


Column Name Type Null? Definition
ACTION_DT_TM DATETIME N Action taken date and time
ACTION_TYPE_MEAN VARCHAR(12) N Indicates the type of entry on the social history personnel relation table. it can be CREATE, REVIEW, INACTIVATE
ACTION_TZ DOUBLE N Action taken date time zone
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 N 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.
PRSNL_ID DOUBLE N Prsnl id. This is the value of the unique primary identifier of the person table. it is an internal system assigned number
SHX_ACTION_ID DOUBLE N SEQUENCE NAME = :PROBLEM_SEQ This is the table's primary key. the unique identifier for a shx_action table.
SHX_ACTIVITY_GROUP_ID DOUBLE N ACTIVITY GROUP ID FROM THE SHX_ACTIVITY table
SHX_ACTIVITY_ID DOUBLE N SEQUENCE NAME: PROBLEM_SEQ unique identifier for the SHX_ ACTIVITY table.
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 - SHX_ACTION


Child Column in SHX_ACTION(FK) Parent Table Name Parent Column Name
Parents: PRSNL_ID PRSNL PERSON_ID
SHX_ACTIVITY_ID SHX_ACTIVITY SHX_ACTIVITY_ID


SHX_ACTIVITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: SHX_ACTIVITY
Definition: Each row on the table represents patient's discrete response of an assessment made for a category.
Table Type: ACTIVITY





Column Detail - SHX_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.
ASSESSMENT_CD DOUBLE N Indicates overall assessment for a category
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 N 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.
LONG_TEXT_ID DOUBLE N The is the value of the unique primary identifier of a long_text table. It is an internal system assigned number.
ORGANIZATION_ID DOUBLE N SEQUENCE NAME: organization_seq The field will store org id for the user who writes out the data. we will use this field to enforce person data sharing rules.
ORIGINATING_ENCNTR_ID DOUBLE N The value of the unique primary identifier of the encounter table
PERFORM_DT_TM DATETIME N Date and time when the assessment was made.
PERSON_ID DOUBLE N SEQUENCE NAME:PERSON_ONLY_SEQ This is the value of the unique primary identifier of the person table. It is an internal system assigned number.
SHX_ACTIVITY_GROUP_ID DOUBLE N SEQUENCE NAME: PROBLEM_SEQ Non unique identifier for the SHX_ ACTIVITY table. Each change or revision made to a social history discrete response creates a new social history response instance.
SHX_ACTIVITY_ID DOUBLE N SEQUENCE NAME:PROBLEM_SEQ This is the table's primary key. The unique identifier for a shx_activity. It will be used to uniquely identify discrete response. Uniquely defines a social history discrete detail within the shx_activity table. The shx_ activity_id can be associated with multiple social history detail instances. When a new social history discrete response is added to the shx_activity table the shx_ activity_id
SHX_CATEGORY_DEF_ID DOUBLE N SEQUENCE NAME: PROBLEM_SEQ The is the value of the unique primary identifier for a Social History category view instance on SHX_CATEGORY_DEF table. It is an internal system assigned number.
SHX_CATEGORY_REF_ID DOUBLE N The ID value from related CAREGORY REF table. Added for performance reasons (de-normalized) to avood extra join to CATEGORY DEF table..
STATUS_CD DOUBLE N Unique code value that identifies section.
TYPE_MEAN VARCHAR(12) N Indicates the type of entry on the SHX_ ACTIVITY table. It can be PERSON, CATEGORY, DETAIL
UNABLE_TO_OBTAIN_IND DOUBLE N Indicates that assessment was not made as it was unable to obtain from the patient.
UPDATE_ENCNTR_ID DOUBLE N The most recent encounter Id to update the social history row
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 - SHX_ACTIVITY


Child Column in SHX_ACTIVITY(FK) Parent Table Name Parent Column Name
Parents: ORIGINATING_ENCNTR_ID ENCOUNTER ENCNTR_ID
UPDATE_ENCNTR_ID ENCOUNTER ENCNTR_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PERSON_ID PERSON PERSON_ID
SHX_CATEGORY_DEF_ID SHX_CATEGORY_DEF SHX_CATEGORY_DEF_ID
SHX_CATEGORY_REF_ID SHX_CATEGORY_REF SHX_CATEGORY_REF_ID




Parent Column in SHX_ACTIVITY (PK) Child Table Name Child Column Name
Children: SHX_ACTIVITY_ID SHX_ACTION SHX_ACTIVITY_ID
SHX_COMMENT SHX_ACTIVITY_ID
SHX_RESPONSE SHX_ACTIVITY_ID


SHX_ALPHA_RESPONSE



Column Section Relationship Section Top of Page


Table-level Detail

Description: SHX_ALPHA_RESPONSE
Definition: Each row on the table represents discrete response for an assessment made
Table Type: ACTIVITY





Column Detail - SHX_ALPHA_RESPONSE


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 N 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.
NOMENCLATURE_ID DOUBLE N This is the value of the unique primary identifier of the nomenclature table.
OTHER_TEXT VARCHAR(255) N Indicates the type of entry on the SHX_ RESPONSE table. It can be ALPHA, NUMERIC, DATE
SHX_ALPHA_RESPONSE_ID DOUBLE N SEQUENCE NAME: PROBLEM_SEQ This is the table's primary key. the unique identifier for a shx_act_assessment table.
SHX_RESPONSE_ID DOUBLE N SEQUENCE NAME: PROBLEM_SEQ unique identifier for the SHX_ ACTIVITY table.
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 - SHX_ALPHA_RESPONSE


Child Column in SHX_ALPHA_RESPONSE(FK) Parent Table Name Parent Column Name
Parents: NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
SHX_RESPONSE_ID SHX_RESPONSE SHX_RESPONSE_ID