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 |