Table Detail Report

RCM_THIRD_PARTY_ACCOUNT



Column Section Relationship Section Top of Page


Table-level Detail

Description: RevWorks Care Management - Third Party Account
Definition: This stable stores third party account information for RevWorks Care Management system
Table Type: REFERENCE





Column Detail - RCM_THIRD_PARTY_ACCOUNT


Column Name Type Null? Definition
ACCOUNT_NAME VARCHAR(100) N Stores the name of the account.
ALL_FACILITY_IND DOUBLE N Indicates this account is shared for all the facilities within the logical domain.
LOGICAL_DOMAIN_ID DOUBLE N The identifier of the logical domain for the account. This identifies the data to be grouped by logical domain
RCM_THIRD_PARTY_ACCOUNT_ID DOUBLE N Uniquely identifies a third party account.
THIRD_PARTY_TYPE_CD DOUBLE N The type of the third party such as JATA or MILLIMAN.
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 Uniquely identifies the record on the long text reference table that is related to the URL.



Relationship Detail - RCM_THIRD_PARTY_ACCOUNT


Child Column in RCM_THIRD_PARTY_ACCOUNT(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
URL_LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in RCM_THIRD_PARTY_ACCOUNT (PK) Child Table Name Child Column Name
Children: RCM_THIRD_PARTY_ACCOUNT_ID RCM_THIRD_PARTY_ACCT_ATTR RCM_THIRD_PARTY_ACCOUNT_ID
RCM_THIRD_PARTY_ACCT_ORG_R RCM_THIRD_PARTY_ACCOUNT_ID


RCM_THIRD_PARTY_ACCT_ATTR



Column Section Relationship Section Top of Page


Table-level Detail

Description: RevWorks Care Management - Third Party Account Attribute
Definition: This table stores third party additional security attribute informaiton
Table Type: REFERENCE





Column Detail - RCM_THIRD_PARTY_ACCT_ATTR


Column Name Type Null? Definition
ATTRIBUTE_TYPE_CD DOUBLE N Identifies the type of attribute for the account.
LONG_TEXT_ID DOUBLE N Uniquely identifies the record on the long text reference table which contains the information of the attribute.
RCM_THIRD_PARTY_ACCOUNT_ID DOUBLE N Uniquely identifies the third party account to which these attributes relate.
RCM_THIRD_PARTY_ACCT_ATTR_ID DOUBLE N Uniquely identifies additional security attribute information related to a given 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.



Relationship Detail - RCM_THIRD_PARTY_ACCT_ATTR


Child Column in RCM_THIRD_PARTY_ACCT_ATTR(FK) Parent Table Name Parent Column Name
Parents: LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
RCM_THIRD_PARTY_ACCOUNT_ID RCM_THIRD_PARTY_ACCOUNT RCM_THIRD_PARTY_ACCOUNT_ID


RCM_THIRD_PARTY_ACCT_ORG_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: RevWorks Care Management Third Party Account Organization Reltionship
Definition: This table stores third party account and facility relationship information
Table Type: REFERENCE





Column Detail - RCM_THIRD_PARTY_ACCT_ORG_R


Column Name Type Null? Definition
ORGANIZATION_ALIAS VARCHAR(100) Y A third party alias value that is assigned to the organization for the account. A facility code would be an example for Curaspan.
ORGANIZATION_ID DOUBLE N Uniquely identifies the facility organization related to the given account.
RCM_THIRD_PARTY_ACCOUNT_ID DOUBLE N Uniquely identifies the Account to which the facility is related.
RCM_THIRD_PARTY_ACCT_ORG_R_ID DOUBLE N Uniquely identifies a relationship between an account and a facility.
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_THIRD_PARTY_ACCT_ORG_R


Child Column in RCM_THIRD_PARTY_ACCT_ORG_R(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
RCM_THIRD_PARTY_ACCOUNT_ID RCM_THIRD_PARTY_ACCOUNT RCM_THIRD_PARTY_ACCOUNT_ID


RCM_TLC_ACCOUNT



Column Section Relationship Section Top of Page


Table-level Detail

Description: RevWorks Care Management - Total Living Choices Account
Definition: This table is used to find facilities to place patients who are being discharged.
Table Type: REFERENCE





Column Detail - RCM_TLC_ACCOUNT


Column Name Type Null? Definition
ACCOUNT_DESC VARCHAR(100) N The description of the account. Must be unique.
RCM_TLC_ACCOUNT_ID DOUBLE N Uniquely identifies a TCL account.
TLC_PRIVATE_KEY_LONG_TEXT_ID DOUBLE N Uniquely identifies the long text record related to the private key.
TLC_PUBLIC_KEY_LONG_TEXT_ID DOUBLE N Uniquely identifies the record on the long text reference table related to the public key.
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 Uniquely identifies the record on the long text reference table that is related to the URL



Relationship Detail - RCM_TLC_ACCOUNT


Child Column in RCM_TLC_ACCOUNT(FK) Parent Table Name Parent Column Name
Parents: TLC_PRIVATE_KEY_LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
TLC_PUBLIC_KEY_LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID
URL_LONG_TEXT_ID LONG_TEXT_REFERENCE LONG_TEXT_ID




Parent Column in RCM_TLC_ACCOUNT (PK) Child Table Name Child Column Name
Children: RCM_TLC_ACCOUNT_ID RCM_TLC_ACCT_LD_R RCM_TLC_ACCOUNT_ID
RCM_TLC_ACCT_ORG_R RCM_TLC_ACCOUNT_ID


RCM_TLC_ACCT_LD_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: RevWorks Care Management - Total Living Choices Account Logical Domain ID
Definition: Account Logical domain relation Total Living Choices Account Logical Domain Identifier
Table Type: REFERENCE





Column Detail - RCM_TLC_ACCT_LD_R


Column Name Type Null? Definition
LOGICAL_DOMAIN_ID DOUBLE N Uniquely identifies the related logical domain.
RCM_TLC_ACCOUNT_ID DOUBLE N Uniquely identifies the related account
RCM_TLC_ACCT_LD_R_ID DOUBLE N Uniquely identifies the relationship between the account and the logical domain 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_TLC_ACCT_LD_R


Child Column in RCM_TLC_ACCT_LD_R(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
RCM_TLC_ACCOUNT_ID RCM_TLC_ACCOUNT RCM_TLC_ACCOUNT_ID