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