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 |