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