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 |