ENCNTR_AVOIDABLE_DAYS
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Avoidable Days |
Definition: | The avoidable day periods for an encounter. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_AVOIDABLE_DAYS
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_DT_TM | DATETIME | Y | The begin date and time of the avoidable days period for the encounter. |
COMMENT_LONG_TEXT_ID | DOUBLE | N | Unique generated number that identifies a single row on the Long_text table that is used to record any comments for the avoidable days period. |
ENCNTR_AVOIDABLE_DAYS_ID | DOUBLE | N | Unique generated number that identifies a single row on the Encntr_avoidable_days table. |
ENCNTR_ID | DOUBLE | N | The ID of the encounter the avoidable days are related to. |
END_DT_TM | DATETIME | Y | The begin date and time of the avoidable days period for the encounter. |
POST_ACUTE_PROVIDER_ID | DOUBLE | N | Uniquely identifies the related post-acute provider. |
REASON_CD | DOUBLE | N | The reason for the avoidable days period for the encounter. |
REASON_TYPE_CD | DOUBLE | N | The type of reason for the avoidable days period for the encounter. |
RESP_PARTY_BUSINESS_ORG_ID | DOUBLE | N | The business organization that is responsible for the avoidable days period. |
RESP_PARTY_BUSINESS_TYPE_CD | DOUBLE | N | The type code of the responsible business party. |
RESP_PARTY_NURSE_UNIT_CD | DOUBLE | N | The nurse unit that is responsible for the avoidable days period. |
RESP_PARTY_OTHER_CD | DOUBLE | N | The entity that is responsible for the avoidable days period. |
RESP_PARTY_PAYER_ORG_ID | DOUBLE | N | The insurance payer organization that is responsible for the avoidable days period. |
RESP_PARTY_PRSNL_ID | DOUBLE | N | The personnel that is responsible for the avoidable days period. |
RESP_PARTY_SELF_IND | DOUBLE | N | Indicator for whether the patient or their family are responsible for the avoidable days period. |
RESP_PARTY_SERVICE_TYPE_CD | DOUBLE | N | The Service that is responsible for the avoidable days period. |
TLC_FACILITY_ID | DOUBLE | N | The uniquely identifies facility data on the table will represent long term care facilities that total living choices (tlc) is using to place patients. |
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_AVOIDABLE_DAYS
Child Column in ENCNTR_AVOIDABLE_DAYS(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
COMMENT_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
RESP_PARTY_BUSINESS_ORG_ID | ORGANIZATION | ORGANIZATION_ID | |
RESP_PARTY_PAYER_ORG_ID | ORGANIZATION | ORGANIZATION_ID | |
RESP_PARTY_PRSNL_ID | PRSNL | PERSON_ID | |
POST_ACUTE_PROVIDER_ID | RCM_POST_ACUTE_PROVIDER | RCM_POST_ACUTE_PROVIDER_ID | |
TLC_FACILITY_ID | RCM_TLC_FACILITY | RCM_TLC_FACILITY_ID |
ENCNTR_CARE_MGMT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Care Management |
Definition: | Stores care management fields for an encounter. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_CARE_MGMT
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. |
CLINICAL_REVIEW_DUE_DT_TM | DATETIME | Y | The date and time of when the next clinical review is due for this encounter. |
DISCH_PLAN_DUE_DT_TM | DATETIME | Y | The date and time of when the next discharge plan is due for this encounter. |
DISCH_PLAN_STATUS_CD | DOUBLE | N | The discharge plan status for this encounter. |
DOCUMENT_REVIEW_DUE_DT_TM | DATETIME | Y | The date and time of when the next document review is due for this encounter. |
DOCUMENT_REVIEW_STATUS_CD | DOUBLE | N | The document review status for this encounter. |
ENCNTR_CARE_MGMT_ID | DOUBLE | N | The unique primary key of this table. It is an internally assigned number. |
ENCNTR_ID | DOUBLE | N | Foreign key to the Encounter table. It identifies which encounter the care management information is for. |
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. |
UTLZTN_MGMT_STATUS_CD | DOUBLE | N | The clinical utilization status for this encounter. |
Relationship Detail - ENCNTR_CARE_MGMT
Child Column in ENCNTR_CARE_MGMT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
ENCNTR_CARE_MGMT_COMM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Care Management Communication |
Definition: | Stores a record of faxes and other communication that were sent from care management solution. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_CARE_MGMT_COMM
Column Name | Type | Null? | Definition |
---|---|---|---|
AUTH_NUMBER | VARCHAR(50) | Y | The authorization or reference number associated to this fax, saving here in case the authorization row is reused for a new authorization. |
COMMENT_ID | DOUBLE | N | This is the comment for the communication, stored on the long text table. |
COMMUNICATION_STATUS_CD | DOUBLE | N | The communication status of the fax such as pending, success or error. |
COMMUNICATION_TYPE_CD | DOUBLE | N | This is the type of communication that was performed, i.e., fax, phone, website. |
COMPLETE_DT_TM | DATETIME | Y | The approximate date and time the sending document is complete. |
CORRESPONDENCE_CD | DOUBLE | N | This is the value from a code set 4002584 and denotes the type of correspondence. |
DOCUMENT_TYPE_CD | DOUBLE | N | The type of document transmitted. From code set 4002585. |
ENCNTR_CARE_MGMT_COMM_ID | DOUBLE | N | The unique primary key of this table. It is an internally generated number. |
ENCNTR_ID | DOUBLE | N | The foreign key to the encounter table. It identifies all the communications for the encounter. |
FT_CONTACT_FAX_TXT | VARCHAR(50) | Y | The free-text fax number from the sender for this communication |
FT_CONTACT_NAME | VARCHAR(100) | Y | The free-text contact name for this communication. |
FT_CONTACT_PHONE | VARCHAR(50) | Y | The free-text phone number for this communication. |
FT_FORMATTED_PHONE_NUMBER | VARCHAR(100) | Y | The free text formatted fax number. |
HANDLE_ID | DOUBLE | N | Storing a link to the OUTPUTCTX table to retrieve information about outbound faxes status and acknowledgement, to store on this table, before the OUTPUTCTX table is purged. |
HEALTH_PLAN_ID | DOUBLE | N | The health plan that is part of the communication. |
NUMBER_OF_PAGES | DOUBLE | N | The number of pages sent. |
ORGANIZATION_ID | DOUBLE | N | The organization the communication is being sent to. |
OUTPUT_DEST_ID | DOUBLE | N | The output destination identifier that is from output_dest table. It is the device destination for transmitting the fax. |
PHONE_SUFFIX | VARCHAR(50) | Y | This field holds the phone number when ad-hoc faxing is used. |
RECIPIENT_NAME | VARCHAR(100) | Y | The name of the intended recipient. |
REPORT_REQUEST_ID | DOUBLE | N | The identifier of the report request from cr_report_request table. |
SENDER_PRSNL_ID | DOUBLE | N | The personnel that sent the fax |
SENT_DT_TM | DATETIME | Y | Date and time that document was sent. |
TRANSMISSION_STATUS_CD | DOUBLE | N | The current RRD transmission status of the document. |
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_CARE_MGMT_COMM
Child Column in ENCNTR_CARE_MGMT_COMM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | REPORT_REQUEST_ID | CR_REPORT_REQUEST | REPORT_REQUEST_ID |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
HEALTH_PLAN_ID | HEALTH_PLAN | HEALTH_PLAN_ID | |
COMMENT_ID | LONG_TEXT | LONG_TEXT_ID | |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID | |
HANDLE_ID | OUTPUTCTX | HANDLE_ID | |
OUTPUT_DEST_ID | OUTPUT_DEST | OUTPUT_DEST_CD | |
SENDER_PRSNL_ID | PRSNL | PERSON_ID |
Parent Column in ENCNTR_CARE_MGMT_COMM (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ENCNTR_CARE_MGMT_COMM_ID | ENCNTR_CARE_MGMT_COMM_RLTN | ENCNTR_CARE_MGMT_COMM_ID |
ENCNTR_CARE_MGMT_COMM_RLTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Care Management Comunication Relationship |
Definition: | Links the communication recorded on the encntr_care_mgmt_comm table with one or more clinical results or discharge plans. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_CARE_MGMT_COMM_RLTN
Column Name | Type | Null? | Definition |
---|---|---|---|
ENCNTR_CARE_MGMT_COMM_ID | DOUBLE | N | Reference to Encntr_Care_mgmt_comm table |
ENCNTR_CARE_MGMT_COMM_RLTN_ID | DOUBLE | N | The unique primary key of this table. It is an internally generated number. |
PARENT_ENTITY_ID | DOUBLE | N | Identify for the parent table for which the communication was sent for. |
PARENT_ENTITY_NAME | VARCHAR(30) | N | This is the table the parent_entity_id can be found on |
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_CARE_MGMT_COMM_RLTN
Child Column in ENCNTR_CARE_MGMT_COMM_RLTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_CARE_MGMT_COMM_ID | ENCNTR_CARE_MGMT_COMM | ENCNTR_CARE_MGMT_COMM_ID |
ENCNTR_CLIN_REVIEW
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Encounter Clinical Review |
Definition: | Stores the clinical reviews for an encounter. |
Table Type: | ACTIVITY |
Column Detail - ENCNTR_CLIN_REVIEW
Column Name | Type | Null? | Definition |
---|---|---|---|
CLINICAL_REVIEW_ID | DOUBLE | N | The identifier that links multiple clinical reviews together. |
CONTENT_SOURCE_CD | DOUBLE | N | The source of the review content. |
CONTENT_VERSION_CD | DOUBLE | N | Contains the content version code. |
ENCNTR_CLIN_REVIEW_ID | DOUBLE | N | The unique primary key for this table. It is an internally generated number. |
ENCNTR_ID | DOUBLE | N | The Encounter ID of the encounter to be reviewed. |
EPISODE_IDENT | VARCHAR(100) | Y | Identifies the related episode for the review. |
RESULT_XML_LONG_BLOB_ID | DOUBLE | N | Uniquely identifies the related sml text. This field should be used instead of result_xml_long_text_id. |
RESULT_XML_LONG_TEXT_ID | DOUBLE | N | *** obsolete. No longer being used. This column has been replaced by RESULT_XML_LONG_BLOB_ID. Uniquely identifies the related XML text. Obsolete *** |
REVIEWED_DT_TM | DATETIME | Y | The date and time of when the clinical review occurred. |
REVIEW_COMMENT_ID | DOUBLE | N | The comments that pertain to the review as a whole. |
REVIEW_RESULT_CD | DOUBLE | N | The result of the clinical review. |
REVIEW_STATUS_CD | DOUBLE | N | The status of the clinical review. |
REVIEW_SUB_TYPE | VARCHAR(255) | Y | The sub type of clinical review needed for the given encounter. Column is OBSOLETE. |
REVIEW_SUB_TYPE_ID | DOUBLE | N | The sub-type of clinical review needed for the given encounter stored on the long text table. |
REVIEW_TYPE_CD | DOUBLE | N | The type of clinical review needed for the given encounter. |
REVIEW_TYPE_UNIT_VALUE | DOUBLE | N | The numeric unit value for the review type. For example, the type is Guildline Day and the unit value is 1. |
TRANSMITTED_DT_TM | DATETIME | Y | The date and time the review was transmitted by fax, email, etc. Column is OBSOLETE. |
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. |
VERSION_DT_TM | DATETIME | Y | The version date and time marks the date the record became historical. |
Relationship Detail - ENCNTR_CLIN_REVIEW
Child Column in ENCNTR_CLIN_REVIEW(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CLINICAL_REVIEW_ID | ENCNTR_CLIN_REVIEW | ENCNTR_CLIN_REVIEW_ID |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
RESULT_XML_LONG_BLOB_ID | LONG_BLOB | LONG_BLOB_ID | |
RESULT_XML_LONG_TEXT_ID | LONG_TEXT | LONG_TEXT_ID | |
REVIEW_COMMENT_ID | LONG_TEXT | LONG_TEXT_ID | |
REVIEW_SUB_TYPE_ID | LONG_TEXT | LONG_TEXT_ID |
Parent Column in ENCNTR_CLIN_REVIEW (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | ENCNTR_CLIN_REVIEW_ID | ENCNTR_CLIN_REVIEW | CLINICAL_REVIEW_ID |
ENCNTR_CLIN_REVIEW_RESULT | CLINICAL_REVIEW_ID | ||
ENCNTR_CLIN_SEC_REVIEW | CLINICAL_REVIEW_ID |