ENCNTR_CMNTY_CASE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Community Case
Definition: Stores information about community case management.
Table Type: ACTIVITY





Column Detail - ENCNTR_CMNTY_CASE


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.
CASE_STATUS_CD DOUBLE N The case status identifies the state of a particular case from the time it is initiated until it is closed (i.3., new, pending enrollment, enrolled, active, pending closure, closed).
CLOSURE_REASON_CD DOUBLE N The reason the case was closed.
ENCNTR_CMNTY_CASE_ID DOUBLE N Stores information about community case management.
ENCNTR_ID DOUBLE N Uniquely identifies the related Encounter.
ENROLLMENT_DT_TM DATETIME Y The date and time of the patient's enrollment on the case encounter.
INITIAL_IDENT_DT_TM DATETIME Y The date and time the case was initially identified.
REFERRAL_REASON_CD DOUBLE N The reason the case was referred.
RISK_FACTOR_SCORE_NBR DOUBLE N The decimal number value representing the risk factor score of the patient.
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 - ENCNTR_CMNTY_CASE


Child Column in ENCNTR_CMNTY_CASE(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID




Parent Column in ENCNTR_CMNTY_CASE (PK) Child Table Name Child Column Name
Children: ENCNTR_CMNTY_CASE_ID ENCNTR_CMNTY_CASE_ID_PGM ENCNTR_CMNTY_CASE_ID
ENCNTR_CMNTY_CASE_RISK_DRV ENCNTR_CMNTY_CASE_ID


ENCNTR_CMNTY_CASE_ID_PGM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Community Case Identification Program
Definition: Stores the program used for identification of the community case.
Table Type: ACTIVITY





Column Detail - ENCNTR_CMNTY_CASE_ID_PGM


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.
ENCNTR_CMNTY_CASE_ID DOUBLE N Uniquely identifies a community case.
ENCNTR_CMNTY_CASE_ID_PGM_ID DOUBLE N Uniquely identifies a program used for identification of the community case.
IDENTIFICATION_DT_TM DATETIME Y The date and time the case management program was identified.
PROGRAM_NAME VARCHAR(255) N The name of the case management program used for identification.
SOURCE_IDENT VARCHAR(255) N The external unique source identifier of the case management program used for identification.
SUP_FACTS_LONG_TEXT_ID DOUBLE N This is the value of the unique primary identifier of the long_text table. It is an internal system assigned number and used to store the program's supporting facts.
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 - ENCNTR_CMNTY_CASE_ID_PGM


Child Column in ENCNTR_CMNTY_CASE_ID_PGM(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_CMNTY_CASE_ID ENCNTR_CMNTY_CASE ENCNTR_CMNTY_CASE_ID
SUP_FACTS_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID


ENCNTR_CMNTY_CASE_RISK_DRV



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Community Case Risk Driver
Definition: The contribution that each condition (clinical category) contributes to the clinical portion of each individual's total risk score for the community case.
Table Type: ACTIVITY





Column Detail - ENCNTR_CMNTY_CASE_RISK_DRV


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.
CODING_SYSTEM_IDENT VARCHAR(255) Y The external unique coding system identifier of the risk driver.
ENCNTR_CMNTY_CASE_ID DOUBLE N Uniquely identifies the related encounter community case.
ENCNTR_CMNTY_CASE_RISK_DRV_ID DOUBLE N The contribution that each condition (clinical category) contributes to the clinical portion of each individual's total risk score for the community case.
RISK_DRIVER_DISPLAY_TXT VARCHAR(255) Y The display of the clinical risk driver.
RISK_DRIVER_VALUE_TXT VARCHAR(255) N The numeric or string representation of the clinical risk driver.
SOURCE_IDENT VARCHAR(255) N The external unique source identifier of the clinical risk driver.
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 - ENCNTR_CMNTY_CASE_RISK_DRV


Child Column in ENCNTR_CMNTY_CASE_RISK_DRV(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_CMNTY_CASE_ID ENCNTR_CMNTY_CASE ENCNTR_CMNTY_CASE_ID


HCM_COMM_EVENT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Healthe Care Management Communication Event
Definition: Stores communication information of patients/personnel
Table Type: ACTIVITY





Column Detail - HCM_COMM_EVENT


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.
COMM_DT_TM DATETIME N The documented communication event date and time for the row.
COMM_PERSON_ROLE_CD DOUBLE N This column contains the code that defines the communication person role for the row.
COMM_TYPE_CD DOUBLE N This field contains the code that defines the communication type for the row.
CONTACTED_PERSON_ID DOUBLE N Uniquely identifies the personnel contacted.
CONTACTED_PERSON_NAME VARCHAR(255) N The free text name of the person contacted for the row.
CONTACTED_PRSNL_ID DOUBLE N Uniquely identifies the personnel making the contact.
CREATED_BY_ID DOUBLE N Uniquely identifies the person that created the row on the table.
CREATED_DT_TM DATETIME Y Indicates the date a communication event was created.
DURATION_IN_MIN DOUBLE Y The duration of the contact in minutes.
ENCNTR_ID DOUBLE N Uniquely identifies the related encounter
HCM_COMM_EVENT_ID DOUBLE N Uniquely identifies communication information of patients/personnel.
METHOD_CD DOUBLE N This field contains the code that defines the communication method for this row.
MODIFIED_BY_ID DOUBLE N The ID of the person who modified the communication event.
MODIFIED_DT_TM DATETIME Y Indicates the date a communication event was modified.
NOTES_CLOB LONGTEXT Y Contains free text notes.
PERSON_ID DOUBLE N Uniquely identifies the person to which this communication is related.
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 - HCM_COMM_EVENT


Child Column in HCM_COMM_EVENT(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
CONTACTED_PERSON_ID PERSON PERSON_ID
PERSON_ID PERSON PERSON_ID
CONTACTED_PRSNL_ID PRSNL PERSON_ID
CREATED_BY_ID PRSNL PERSON_ID
MODIFIED_BY_ID PRSNL PERSON_ID




Parent Column in HCM_COMM_EVENT (PK) Child Table Name Child Column Name
Children: HCM_COMM_EVENT_ID HCM_COMM_EVENT_H HCM_COMM_EVENT_ID
HCM_COMM_EVENT_OUTCOME HCM_COMM_EVENT_ID
HCM_COMM_EVENT_OUTCOME_H HCM_COMM_EVENT_ID


HCM_COMM_EVENT_H



Column Section Relationship Section Top of Page


Table-level Detail

Description: Healthe Care Management Communication Event History
Definition: Stores communication information of patients/personnel
Table Type: ACTIVITY





Column Detail - HCM_COMM_EVENT_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.
COMM_DT_TM DATETIME N The documented communication event date and time for the row.
COMM_PERSON_ROLE_CD DOUBLE N This column contains the code that defines the communication person role for the row.
COMM_TYPE_CD DOUBLE N This field contains the code that defines the communication type for the row.
CONTACTED_PERSON_ID DOUBLE N Uniquely identifies the personnel contacted.
CONTACTED_PERSON_NAME VARCHAR(255) N The free text name of the person contacted for the row.
CONTACTED_PRSNL_ID DOUBLE N Uniquely identifies the personnel making the contact.
CREATED_BY_ID DOUBLE N Uniquely identifies the person that created the row on the table.
CREATED_DT_TM DATETIME Y Indicates the date a communication event was created.
DURATION_IN_MIN DOUBLE Y The duration of the contact in minutes.
ENCNTR_ID DOUBLE N Uniquely identifies the related encounter
HCM_COMM_EVENT_H_ID DOUBLE N Uniquely identifies a historical record related to a communication event.
HCM_COMM_EVENT_ID DOUBLE N Uniquely identifies communication information of patients/personnel.
METHOD_CD DOUBLE N This field contains the code that defines the communication method for this row.
MODIFIED_BY_ID DOUBLE N The ID of the person who modified the communication event.
MODIFIED_DT_TM DATETIME Y Indicates the date a communication event was modified.
NOTES_CLOB LONGTEXT Y Contains free text notes.
PERSON_ID DOUBLE N Uniquely identifies the person to which this communication is related.
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 - HCM_COMM_EVENT_H


Child Column in HCM_COMM_EVENT_H(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
HCM_COMM_EVENT_ID HCM_COMM_EVENT HCM_COMM_EVENT_ID
CONTACTED_PERSON_ID PERSON PERSON_ID
PERSON_ID PERSON PERSON_ID
CONTACTED_PRSNL_ID PRSNL PERSON_ID
CREATED_BY_ID PRSNL PERSON_ID
MODIFIED_BY_ID PRSNL PERSON_ID