Table Detail Report
RCM_DIRECT_COMM_EMAIL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Care Management Direct Communication Email |
Definition: | Contains information about Cerner Direct communication secure email information from Cerner Care Management. |
Table Type: | ACTIVITY |
Column Detail - RCM_DIRECT_COMM_EMAIL
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_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
EMAIL_ADDR | VARCHAR(254) | N | Contains the secure email address. |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
RCM_DIRECT_COMM_EMAIL_ID | DOUBLE | N | Unique Generated number that identifies a single row on the RCM_DIRECT_COMM_EMAIL table. |
RCM_DIRECT_COMM_ID | DOUBLE | N | Uniquely identifies the related row on the RCM_DIRECT_COMM table. |
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 - RCM_DIRECT_COMM_EMAIL
Child Column in RCM_DIRECT_COMM_EMAIL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RCM_DIRECT_COMM_ID | RCM_DIRECT_COMM | RCM_DIRECT_COMM_ID |
RCM_DOC_REVIEW
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | RevWorks Care Management - Document Review |
Definition: | Stores a record of care management documentation done by a document specialist for a patient's visit. |
Table Type: | ACTIVITY |
Column Detail - RCM_DOC_REVIEW
Column Name | Type | Null? | Definition |
---|---|---|---|
COMMENT_TEXT_ID | DOUBLE | N | The comments or findings regarding the review. |
DOCUMENT_REVIEWED_DT_TM | DATETIME | Y | The date and time when the document review occurred. |
DOCUMENT_REVIEW_ID | DOUBLE | N | The identifier that links multiple document reviews. |
DOCUMENT_REVIEW_TYPE_CD | DOUBLE | N | The type of review documented for the encounter. |
ENCNTR_ID | DOUBLE | N | Uniquely identifies the encounter related to this review. Used to identify all document reviews for a given encounter. |
RCM_DOC_REVIEW_ID | DOUBLE | N | Uniquely identifies a record of care management documentation done by a document specialist for a patient's visit. |
REVIEW_STATUS_CD | DOUBLE | N | The status of this review 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. |
VERSION_DT_TM | DATETIME | Y | The version date and time marks the date the record became historical. |
Relationship Detail - RCM_DOC_REVIEW
Child Column in RCM_DOC_REVIEW(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
COMMENT_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
Parent Column in RCM_DOC_REVIEW (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RCM_DOC_REVIEW_ID | RCM_CLARIFICATION | DOCUMENT_REVIEW_ID |
RCM_DOC_REVIEW_FOLLOWUP
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | RevWorks Care Management |
Definition: | Stores a record of communication or follow up done by a document specialist for a patient's visit. |
Table Type: | ACTIVITY |
Column Detail - RCM_DOC_REVIEW_FOLLOWUP
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTUAL_RESPONSE_DT_TM | DATETIME | Y | The actual date and time the response was received from the physician. |
DOCUMENT_REVIEW_ID | DOUBLE | N | Uniquely identifies a document review. Used to link multiple document reviews. |
DOC_COMMUNICATION_TYPE_CD | DOUBLE | N | The type of communication that took place between the document specialist and the physician. |
DOC_REVIEW_FOLLOWUP_ID | DOUBLE | N | The identifier that links multiple document review follow ups. |
DOC_REVIEW_OUTCOME_CD | DOUBLE | N | The document review outcome of the follow up or the communication. |
EXPECTED_RESPONSE_DT_TM | DATETIME | Y | The date and time the response is expected from the physician. |
FOLLOWUP_PRSNL_ID | DOUBLE | N | The physician who was communicated or followed up about the review. |
OUTCOME_COMMENT_TEXT_ID | DOUBLE | N | The additional comments regarding the outcome. |
RCM_DOC_REVIEW_FOLLOWUP_ID | DOUBLE | N | Uniquely identifies a record of communication or follow up done by a document specialist for a patient's visit. |
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 - RCM_DOC_REVIEW_FOLLOWUP
Child Column in RCM_DOC_REVIEW_FOLLOWUP(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | OUTCOME_COMMENT_TEXT_ID | LONG_TEXT | LONG_TEXT_ID |
FOLLOWUP_PRSNL_ID | PRSNL | PERSON_ID | |
DOC_REVIEW_FOLLOWUP_ID | RCM_DOC_REVIEW_FOLLOWUP | RCM_DOC_REVIEW_FOLLOWUP_ID |
Parent Column in RCM_DOC_REVIEW_FOLLOWUP (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RCM_DOC_REVIEW_FOLLOWUP_ID | RCM_DOC_REVIEW_FOLLOWUP | DOC_REVIEW_FOLLOWUP_ID |
RCM_DRG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Management - DRG |
Definition: | Loaded select drg (by contributor system) which are first on our worklists from a care management load from an encounter. |
Table Type: | ACTIVITY |
Column Detail - RCM_DRG
Column Name | Type | Null? | Definition |
---|---|---|---|
CONTRIBUTOR_SYSTEM_CD | DOUBLE | N | Contributor system identifies the source feed of data from which a row was populated. This is mainly used to determine how to update a set of data that may have originated from more than one source feed. |
DRG_PRIORITY_NBR | DOUBLE | Y | The selected working drg priority number. |
ENCNTR_ID | DOUBLE | N | Uniquely identifies the encounter related to this row. |
RCM_DRG_ID | DOUBLE | N | Unique generate number that identifies a single row on the RCM_DRG table. |
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 - RCM_DRG
Child Column in RCM_DRG(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
RCM_FACILITY_PLAN_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | RCM_FACILITY_PLAN_RELTN |
Definition: | Stores facility health plan relationships for Care Management solution. |
Table Type: | REFERENCE |
Column Detail - RCM_FACILITY_PLAN_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
HEALTH_PLAN_ID | DOUBLE | N | The value of the primary identifier of the health_plan which is related to the facility. |
ORGANIZATION_ID | DOUBLE | N | The value of the primary identifier of the organization which is related to the health plan. |
RCM_FACILITY_PLAN_RELTN_ID | DOUBLE | N | Unique generated number that identifies a single row on the RCM_FACILITY_PLAN_RELTN table. |
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 - RCM_FACILITY_PLAN_RELTN
Child Column in RCM_FACILITY_PLAN_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | HEALTH_PLAN_ID | HEALTH_PLAN | HEALTH_PLAN_ID |
ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |