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 |