Table Detail Report

ENCNTR_CLIN_REVIEW_ADDNDM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Clinical Review Addendum
Definition: Stores the addendums of a clinical review for an encounter.
Table Type: ACTIVITY





Column Detail - ENCNTR_CLIN_REVIEW_ADDNDM


Column Name Type Null? Definition
ADDENDUM_COMMENT_ID DOUBLE N The comments for the addendum for the clinical review.
ENCNTR_CLIN_REVIEW_ADDNDM_ID DOUBLE N The unique primary key for this table. It is an internally generated number.
ENCNTR_CLIN_REVIEW_RESULT_ID DOUBLE N The Encntr_clin_review_result row for which this addendum belongs. Column is OBSOLETE.
PARENT_ENTITY_ID DOUBLE N The ID for the table row which for the table represented by the parent_entity_name.
PARENT_ENTITY_NAME VARCHAR(30) N The table which is being referenced.
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_CLIN_REVIEW_ADDNDM


Child Column in ENCNTR_CLIN_REVIEW_ADDNDM(FK) Parent Table Name Parent Column Name
Parents: ADDENDUM_COMMENT_ID LONG_TEXT LONG_TEXT_ID


ENCNTR_CLIN_REVIEW_RESULT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Clinical Review Result
Definition: Stores the result of a clinical review for an encounter.
Table Type: ACTIVITY





Column Detail - ENCNTR_CLIN_REVIEW_RESULT


Column Name Type Null? Definition
CLINICAL_REVIEW_ID DOUBLE N The identifier that links multiple clinical reviews together.
ENCNTR_CLIN_REVIEW_RESULT_ID DOUBLE N The unique primary key for this table. It is an internally generated number.
RESULT_CD DOUBLE N The result of the clinical review.
RESULT_COMMENT_ID DOUBLE N The comments for the result for the clinical review.
RESULT_LONG_BLOB_ID DOUBLE N Reference id for any additional metadata associated to the clinical review result. The data will vary based on the content_source_cd of the associated encntr_clin_review.
RESULT_LONG_TEXT_ID DOUBLE N ** obsolete** This column has been replaced.There are 2 different workflows that write data to the table. MCG workflow - XML from a 3rd party is stored in encntr_clin_review_result.result_long_text_id and a parsed version is stored as json in encntr_clin_review_result .result_long_blob_id. Interqual workflow - XML from a 3rd party is originally stored in encntr_clin_review.result_xml_long_text_id, and once the review is finalized the data is parsed and stored as plain text in result_long_text_id
RESULT_TEXT_LONG_BLOB_ID DOUBLE N Reference id for any additional metadata associated to the clinical review result. The data will vary based on the content_source_cd of the associated encntr_clin_review.
RESULT_TYPE_CD DOUBLE N The result type of the clinical review.
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_RESULT


Child Column in ENCNTR_CLIN_REVIEW_RESULT(FK) Parent Table Name Parent Column Name
Parents: CLINICAL_REVIEW_ID ENCNTR_CLIN_REVIEW ENCNTR_CLIN_REVIEW_ID
RESULT_LONG_BLOB_ID LONG_BLOB LONG_BLOB_ID
RESULT_TEXT_LONG_BLOB_ID LONG_BLOB LONG_BLOB_ID
RESULT_COMMENT_ID LONG_TEXT LONG_TEXT_ID
RESULT_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID


ENCNTR_CLIN_SEC_REVIEW



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Clinical Review Secondary Review
Definition: Stores the clinical reviews secondary review for an encounter.
Table Type: ACTIVITY





Column Detail - ENCNTR_CLIN_SEC_REVIEW


Column Name Type Null? Definition
CLINICAL_REVIEW_ID DOUBLE N The identifier that links multiple clinical reviews together.
CLIN_SEC_REVIEW_ID DOUBLE N Uniquely identifies a related secondary review.
COMMUNICATION_TYPE_CD DOUBLE N The type of communication was performed for the secondary review.
ENCNTR_CLIN_SEC_REVIEW_ID DOUBLE N The unique primary key for this table. It is an internally generated number.
EXTERNAL_REVIEW_IND DOUBLE N Indicates if the clinical review was performed by an external provider.
SEC_REVIEW_COMMENT_ID DOUBLE N The comments for the secondary review.
SEC_REVIEW_OUTCOME_CD DOUBLE N The outcome of the secondary review.
SEC_REVIEW_REASON_CD DOUBLE N The secondary review reason.
SEC_REVIEW_RESP_PARTY_ID DOUBLE N Uniquely identifies the person who reviews for the secondary review.
SEC_REVIEW_RESP_PARTY_TXT VARCHAR(100) Y The responsible party identified for the secondary review.
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.
VERSION_DT_TM DATETIME Y The version date and time marks the date the record became historical.



Relationship Detail - ENCNTR_CLIN_SEC_REVIEW


Child Column in ENCNTR_CLIN_SEC_REVIEW(FK) Parent Table Name Parent Column Name
Parents: CLINICAL_REVIEW_ID ENCNTR_CLIN_REVIEW ENCNTR_CLIN_REVIEW_ID
CLIN_SEC_REVIEW_ID ENCNTR_CLIN_SEC_REVIEW ENCNTR_CLIN_SEC_REVIEW_ID
SEC_REVIEW_COMMENT_ID LONG_TEXT LONG_TEXT_ID
SEC_REVIEW_RESP_PARTY_ID PRSNL PERSON_ID




Parent Column in ENCNTR_CLIN_SEC_REVIEW (PK) Child Table Name Child Column Name
Children: ENCNTR_CLIN_SEC_REVIEW_ID ENCNTR_CLIN_SEC_REVIEW CLIN_SEC_REVIEW_ID


ENCNTR_ORG_SERVICE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Organization Service Relation
Definition: Post Acute services provided by an organization for an enounter.
Table Type: ACTIVITY





Column Detail - ENCNTR_ORG_SERVICE_RELTN


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.
AUTH_NUMBER VARCHAR(100) Y The authentication number of the service.
COMMENT_LONG_TEXT_ID DOUBLE N Comments for the organization service relationship.
ENCNTR_ID DOUBLE N Unique generated number that identifies a single row on the Encounter table.
ENCNTR_ORG_SERVICE_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the Encntr_org_service_reltn table.
FINAL_SELECTION_IND DOUBLE N Indicator for which organization relationship will be providing the service.
ORGANIZATION_ID DOUBLE N Unique generated number that identifies a single row on the Organization table.
PATIENT_REASON_CD DOUBLE N The patients reason for selecting the post acute organization to provide the service.
PAYER_ORG_ID DOUBLE N Identifier for the payer organization.
PRIORITY_SEQ DOUBLE N The priority given to the organization relationship per service.
REFERRING_PRSNL_ID DOUBLE N Identifier for the referring personnel
RESPONSE_CD DOUBLE N The response from the post acute service organization to the service request.
RESPONSE_REASON_CD DOUBLE N The reason for the response from the post acute service organization to the service request.
SERVICE_BEG_DT_TM DATETIME Y Identifies the date the service should start.
SERVICE_CD DOUBLE N The post acute service to be provided to the encounter by the organization.
SERVICE_END_DT_TM DATETIME Y Identifies the date the service should start.
SERVICE_FREQUENCY VARCHAR(100) Y Frequency of the service to be provided.
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_ORG_SERVICE_RELTN


Child Column in ENCNTR_ORG_SERVICE_RELTN(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
COMMENT_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PAYER_ORG_ID ORGANIZATION ORGANIZATION_ID
REFERRING_PRSNL_ID PRSNL PERSON_ID


ENCNTR_POSTACUTE_ORG_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Encounter Post Acute Organization Relation
Definition: Post acute organization candidates for an encounter.
Table Type: ACTIVITY





Column Detail - ENCNTR_POSTACUTE_ORG_RELTN


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.
COMMENT_LONG_TEXT_ID DOUBLE N Unique generated number that identifies a single row on the Long_text table that represents a comment for this relationship.
ENCNTR_ID DOUBLE N Unique generated number that identifies a single row on the Encounter table.
ENCNTR_POSTACUTE_ORG_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the Encntr_postacute_org_reltn table.
FINAL_PLACEMENT_IND DOUBLE N Indicates the post acute organization that was selected as the placement for the encounter. There can only be one row marked as TRUE per encounter.
ORGANIZATION_ID DOUBLE N Unique generated number that identifies a single row on the Organization table.
PATIENT_REASON_CD DOUBLE N The patients reason for selecting the post acute organization for final placement.
PRIORITY_SEQ DOUBLE N The priority of the post acute organizations for the encounter.
RESPONSE_CD DOUBLE N The response from the post acute organization to the placement request.
RESPONSE_REASON_CD DOUBLE N The reason for the response from the post acute organization to the placement request.
SELECTED_ORG_TYPE_CD DOUBLE N The selected post acute organization type for this dandidate.
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_POSTACUTE_ORG_RELTN


Child Column in ENCNTR_POSTACUTE_ORG_RELTN(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
COMMENT_LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID