Table Detail Report

ENCNTR_READMIT_ASSESS



Column Section Relationship Section Top of Page


Table-level Detail

Description: encounter readmission asssessment
Definition: The readmission assessment for the encounter
Table Type: ACTIVITY





Column Detail - ENCNTR_READMIT_ASSESS


Column Name Type Null? Definition
AVOIDABLE_READMISSION_IND DOUBLE N Indicates if the readmission was avoidable.
CLASSIFICATION_CD DOUBLE N Code value that defines the classification of the readmission. Code set is 4002598.
COMMENT_ID DOUBLE N identifier of the row on the long_text that holds the comment text for the readmission.
ENCNTR_ID DOUBLE N Unique generated number that identifies a single row on the Encounter table that relates to the readmission.
ENCNTR_READMIT_ASSESS_ID DOUBLE N Unique generated number that identifies a single row on the encntr_readmit_assess table.
ORGANIZATION_ID DOUBLE N identifier of the organization associated to the readmission.
POST_ACUTE_PROVIDER_ID DOUBLE N Uniquely identifies the related post-acute provider.
PREVIOUS_ENCNTR_ID DOUBLE N Unique generated number that identifies a single row on the Encounter table. This identifier represents the original encounter that was prior to the readmitted encounter.
READMISSION_REASON_CD DOUBLE N Code value that defines the reason for the readmission. Code set is 4002603.
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.
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_READMIT_ASSESS


Child Column in ENCNTR_READMIT_ASSESS(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PREVIOUS_ENCNTR_ID ENCOUNTER ENCNTR_ID
COMMENT_ID LONG_TEXT LONG_TEXT_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
POST_ACUTE_PROVIDER_ID RCM_POST_ACUTE_PROVIDER RCM_POST_ACUTE_PROVIDER_ID
TLC_FACILITY_ID RCM_TLC_FACILITY RCM_TLC_FACILITY_ID


RCA_MOBILE_PROFILE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Mobile Profile
Definition: Defines a profile to be usied by the registration kiosk.
Table Type: REFERENCE





Column Detail - RCA_MOBILE_PROFILE


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.
APPLICATION_SOURCE_CD DOUBLE N ** OBSOLETE ** This column was replaced by mobile_profile_type_cd
FACILITY_ORG_ID DOUBLE N Associates a profile to an organization.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
LONG_BLOB_ID DOUBLE N Uniquely identifies the related long blob
MOBILE_PROFILE_TYPE_CD DOUBLE N Identifies the source feed for the data from which the row was populated. This is mainly used to determine the exact application source for data. Ex. Mobile Kiosk, Esig.
PROFILE_NAME VARCHAR(100) N Name of the profile
PROFILE_TYPE_MEANING VARCHAR(12) N type of profile, ESIG or KIOSK
RCA_MOBILE_PROFILE_ID DOUBLE N Uniquely a profile to be used by the registration kiosk.
SCHEMA_VERSION_NBR DOUBLE N The schema version number for the mobile kiosk profile.
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 - RCA_MOBILE_PROFILE


Child Column in RCA_MOBILE_PROFILE(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
LONG_BLOB_ID LONG_BLOB_REFERENCE LONG_BLOB_ID
FACILITY_ORG_ID ORGANIZATION ORGANIZATION_ID




Parent Column in RCA_MOBILE_PROFILE (PK) Child Table Name Child Column Name
Children: RCA_MOBILE_PROFILE_ID RCA_MOBILE_SESSION RCA_MOBILE_PROFILE_ID


RCM_ACTION



Column Section Top of Page


Table-level Detail

Description: Care Management - Action
Definition: Records user actions for the Care Management workflows.
Table Type: ACTIVITY





Column Detail - RCM_ACTION


Column Name Type Null? Definition
ACTION_DT_TM DATETIME Y The date and time of when the user did the action.
ACTION_MEANING VARCHAR(12) Y The meaning of the type of action that the user performed.
ACTION_PRSNL_ID DOUBLE N The identifier of the person who performed the action.
ACTION_TYPE_CD DOUBLE N The type of action that the user performed.
PARENT_ENTITY_ID DOUBLE N The identifier for the parent row.
PARENT_ENTITY_NAME VARCHAR(32) Y The name of the parent table for the parent row.
RCM_ACTION_ID DOUBLE N Uniquely identifies a recorded user action from the Care Management workflow.
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.


RCM_CLARIFICATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: RevWorks Care Management - Clarification
Definition: Stores Clarificaiton for the Care Management Solution
Table Type: ACTIVITY





Column Detail - RCM_CLARIFICATION


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.
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.
CLARIFICATION_CODE VARCHAR(50) N The J A Thomas code Identifier
CLARIFICATION_IDENT VARCHAR(50) N The unique J A Thomas clarification identifier.
CLARIFICATION_RESP_CD DOUBLE N The code describing the responses of clarification
CLARIFICATION_TYPE_CD DOUBLE N Identifies the type of clarification.
CREATE_DT_TM DATETIME Y The date and time the clarification was created.
DOCUMENT_REVIEW_ID DOUBLE N The identifier of the rcm_doc_review row containing the clarification.
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.
LONG_TEXT_ID DOUBLE N The identifier of the long_text row containing the clarification text.
PREV_RCM_CLARIFICATION_ID DOUBLE N Used to track versions of the clarification information. This field will always point back to the initial value created. This may be used to find the correct version when combined with begin and end effective dates and times.
PRSNL_GROUP_ID DOUBLE N Identifies the personnel group for this clarification.
PRSNL_ID DOUBLE N The physician personnel of the clarification.
RCM_CLARIFICATION_ID DOUBLE N Uniquely identifies a clarification for the Care Management solution.
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_CLARIFICATION


Child Column in RCM_CLARIFICATION(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PRSNL_ID PRSNL PERSON_ID
PRSNL_GROUP_ID PRSNL_GROUP PRSNL_GROUP_ID
DOCUMENT_REVIEW_ID RCM_DOC_REVIEW RCM_DOC_REVIEW_ID


RCM_DIRECT_COMM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Care Management - Direct Communication
Definition: Contains information about Cerner Direct communications from Cerner Care Management.
Table Type: ACTIVITY





Column Detail - RCM_DIRECT_COMM


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.
ENCNTR_ID DOUBLE N Uniquely identifies the related encounter.
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.
MEDIA_IDENT VARCHAR(255) Y The MMF media identifier. It is used to look up generated file from CAMM.
PARENT_ENTITY_ID DOUBLE N Uniquely identifies the parent entity id of the communication that was sent.
PARENT_ENTITY_NAME VARCHAR(30) N Uniquely identifies the parent table related to this row.
PERSON_ID DOUBLE N Uniquely identifies the person related to this row.
RCM_DIRECT_COMM_ID DOUBLE N Unique generated number that identifies a single row on the RCM_DIRECT_COMM table.
SENDER_PRSNL_ID DOUBLE N Uniquely identifies the person who sent the communication.
SENT_DT_TM DATETIME N The date and time the communication was sent.
STATUS_FLAG DOUBLE N The status of communication. 0 - Default;1 - Failed to Generate CCD; 2 - Failed to Save CCD to CAMM;3 - Failed to send Direct message;4 - Success
TEMPLATE_ID DOUBLE N Uniquely identifies the related XR template used to generate the XR report.
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


Child Column in RCM_DIRECT_COMM(FK) Parent Table Name Parent Column Name
Parents: TEMPLATE_ID CR_REPORT_TEMPLATE REPORT_TEMPLATE_ID
ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
SENDER_PRSNL_ID PRSNL PERSON_ID




Parent Column in RCM_DIRECT_COMM (PK) Child Table Name Child Column Name
Children: RCM_DIRECT_COMM_ID RCM_DIRECT_COMM_EMAIL RCM_DIRECT_COMM_ID