Table Detail Report

RCM_INTERQUAL_ACCOUNT



Column Section Relationship Section Top of Page


Table-level Detail

Description: RevWorks Care Management Interqual Account
Definition: Stores interqual account information.
Table Type: REFERENCE





Column Detail - RCM_INTERQUAL_ACCOUNT


Column Name Type Null? Definition
ACCOUNT_DESC VARCHAR(100) N A unique description of the account.
ACCOUNT_PASSWORD VARCHAR(150) N The encrypted InterQual account password.
ACCOUNT_USERNAME VARCHAR(100) N The InterQual Account username.
PARAMS_LONG_TEXT_ID DOUBLE N Uniquely identifies the interqual parameters xml.
RCM_INTERQUAL_ACCOUNT_ID DOUBLE N Uniquely identifies and InterQual account.
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.
URL_LONG_TEXT_ID DOUBLE N Contains the InterQual URL.



Relationship Detail - RCM_INTERQUAL_ACCOUNT


Child Column in RCM_INTERQUAL_ACCOUNT(FK) Parent Table Name Parent Column Name
Parents: URL_LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in RCM_INTERQUAL_ACCOUNT (PK) Child Table Name Child Column Name
Children: RCM_INTERQUAL_ACCOUNT_ID RCM_INTERQUAL_ACCT_ORG_R RCM_INTERQUAL_ACCOUNT_ID


RCM_INTERQUAL_ACCT_ORG_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: RevWorks InterQual Account Organization Relationship
Definition: Associates interqual account information by organization.
Table Type: REFERENCE





Column Detail - RCM_INTERQUAL_ACCT_ORG_R


Column Name Type Null? Definition
ORGANIZATION_ID DOUBLE N Uniquely identifies to which this InterQual accounts related.
RCM_INTERQUAL_ACCOUNT_ID DOUBLE N Uniquely identifies the InterQual Account for which the Organization is related.
RCM_INTERQUAL_ACCT_ORG_R_ID DOUBLE N Uniquely identifies a relationship between an InterQual Account and an Organization.
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_INTERQUAL_ACCT_ORG_R


Child Column in RCM_INTERQUAL_ACCT_ORG_R(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
RCM_INTERQUAL_ACCOUNT_ID RCM_INTERQUAL_ACCOUNT RCM_INTERQUAL_ACCOUNT_ID


RCM_MSG_CENTER_COMM



Column Section Relationship Section Top of Page


Table-level Detail

Description: RevWorks Care Management Message Center Communication
Definition: Stores a record of Message Center communication from care management solution.
Table Type: ACTIVITY





Column Detail - RCM_MSG_CENTER_COMM


Column Name Type Null? Definition
LONG_TEXT_ID DOUBLE N Uniquely identifies the actual communication text.
PARENT_ENTITY_ID DOUBLE N The value of the primary identifier of the table to which the communication row is related. (i.e., encntr_clin_sec_review_id, rcm_doc_review_id, etc.)
PARENT_ENTITY_NAME VARCHAR(30) N The name of the table to which this communication row is related (i.e., encntr_clin_sec_review, rcm_doc_review, etc.)
RCM_MSG_CENTER_COMM_ID DOUBLE N Uniquely identifies a record of Message Center communication from care management solution.
SENDER_PRSNL_ID DOUBLE N Uniquely identifies the personnel that sent the document to the Message Center.
SENT_DT_TM DATETIME Y Date and time that the document was sent.
TASK_ID DOUBLE N Uniquely identifies the task created and returned from Message Center.
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_MSG_CENTER_COMM


Child Column in RCM_MSG_CENTER_COMM(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
SENDER_PRSNL_ID PRSNL PERSON_ID




Parent Column in RCM_MSG_CENTER_COMM (PK) Child Table Name Child Column Name
Children: RCM_MSG_CENTER_COMM_ID RCM_MSG_CENTER_COMM_RELTN RCM_MSG_CENTER_COMM_ID


RCM_MSG_CENTER_COMM_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: RevWorks Care Management - Message Center Communication Relationship
Definition: Links the Message Center communication recorded on the RCM_MSG_CENTYER_COMM table with one or more recipients.
Table Type: ACTIVITY





Column Detail - RCM_MSG_CENTER_COMM_RELTN


Column Name Type Null? Definition
RCM_MSG_CENTER_COMM_ID DOUBLE N Uniquely identifies the related row on the RCM_MSG_CENTER_COMM table.
RCM_MSG_CENTER_COMM_RELTN_ID DOUBLE N Uniquely identifies a relationship between the RCM_MSG_CENTER_COMM table and one or more recipients.
RECIPIENT_CC_IND DOUBLE N The indicator of the carbon copy recipient.
RECIPIENT_PRSNL_GROUP_ID DOUBLE N Identifies the personnel group to which this record is related.
RECIPIENT_PRSNL_ID DOUBLE N The identifier of the recipient of the message that was sent.
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_MSG_CENTER_COMM_RELTN


Child Column in RCM_MSG_CENTER_COMM_RELTN(FK) Parent Table Name Parent Column Name
Parents: RECIPIENT_PRSNL_ID PRSNL PERSON_ID
RCM_MSG_CENTER_COMM_ID RCM_MSG_CENTER_COMM RCM_MSG_CENTER_COMM_ID


RCM_NOTE



Column Section Relationship Section Top of Page


Table-level Detail

Description: RevWorks Care Management - Note
Definition: Stores notes for Care Management solution.
Table Type: ACTIVITY





Column Detail - RCM_NOTE


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.
CREATE_DT_TM DATETIME Y Date and time the note was created.
CREATE_PRSNL_ID DOUBLE N Uniquely identifies the person who created the note.
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.
LAST_UPDT_PRSNL_ID DOUBLE N The person that last updated the note.
LONG_TEXT_ID DOUBLE N Uniquely identifies the related long text row where additional information is stored.
NOTE_PRIORITY_CD DOUBLE N Identifies the importance of this note.
NOTE_TYPE_CD DOUBLE N Identifies the type of note.
PERSON_ID DOUBLE N Uniquely identifies the related person.
PREV_RCM_NOTE_ID DOUBLE N Used to track versions of the note. 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.
RCM_NOTE_ID DOUBLE N Uniquely identifies a note recorded for Care Management.
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_NOTE


Child Column in RCM_NOTE(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
LONG_TEXT_ID LONG_TEXT LONG_TEXT_ID
PERSON_ID PERSON PERSON_ID
CREATE_PRSNL_ID PRSNL PERSON_ID
LAST_UPDT_PRSNL_ID PRSNL PERSON_ID