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 |