Table Detail Report
RCM_TLC_ACCT_ORG_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | RevWorks Care Management - Total Living Choices Account Organization Relation |
Definition: | Account organization relation. They find facilities to place patients who are being discharged who need long term care. |
Table Type: | REFERENCE |
Column Detail - RCM_TLC_ACCT_ORG_R
Column Name | Type | Null? | Definition |
---|---|---|---|
ORGANIZATION_ID | DOUBLE | N | Uniquely identifies the related organization |
RCM_TLC_ACCOUNT_ID | DOUBLE | N | Uniquely identifies the related account. |
RCM_TLC_ACCT_ORG_R_ID | DOUBLE | N | The account organization relation. They find facilities to place patients who are being discharged who need long term care. |
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_ORG_R
Child Column in RCM_TLC_ACCT_ORG_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ORGANIZATION_ID | ORGANIZATION | ORGANIZATION_ID |
RCM_TLC_ACCOUNT_ID | RCM_TLC_ACCOUNT | RCM_TLC_ACCOUNT_ID |
RCM_TLC_FACILITY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | RevWorks Care Management - Total Living Choices Facility |
Definition: | Facilities returned from the TLC service. |
Table Type: | REFERENCE |
Column Detail - RCM_TLC_FACILITY
Column Name | Type | Null? | Definition |
---|---|---|---|
CITY_NAME | VARCHAR(100) | N | Contains the name of the city. |
COUNTRY_NAME | VARCHAR(100) | N | Name of the country. |
DELIVER_TO_TXT | VARCHAR(100) | N | Contains the attention line of the address. |
PHONE | VARCHAR(100) | N | Contains the phone number. |
POSTAL_CODE | VARCHAR(25) | N | Contains the postal code. |
RCM_TLC_FACILITY_ID | DOUBLE | N | Uniquely identifies facility data on the table will represent long term care facilities that Total Living Choices (TLC) is using to place patients. |
STATE_NAME | VARCHAR(100) | N | Contains the state name. |
STREET_NAME | VARCHAR(100) | N | Contains the name of the street. |
TLC_FACILITY_IDENT | VARCHAR(100) | N | Identifies data coming from a third party. |
TLC_FACILITY_NAME | VARCHAR(100) | N | Name of the facility returned from TLC. |
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_FACILITY
Parent Column in RCM_TLC_FACILITY (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RCM_TLC_FACILITY_ID | ENCNTR_AVOIDABLE_DAYS | TLC_FACILITY_ID |
ENCNTR_READMIT_ASSESS | TLC_FACILITY_ID | ||
RCM_TLC_FAC_TYPE_FAC_R | RCM_TLC_FACILITY_ID | ||
RCM_TLC_PLACEMENT | FINAL_TLC_FACILITY_ID | ||
RCM_TLC_PLACEMENT_FAC_R | RCM_TLC_FACILITY_ID | ||
RCM_TLC_SERVICE | FINAL_TLC_FACILITY_ID | ||
RCM_TLC_SERVICE_FAC_R | RCM_TLC_FACILITY_ID |
RCM_TLC_FACILITY_TYPE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | RevWorks Care Management - Total Living Choices Facility Type |
Definition: | Stores the TLC Facility Type |
Table Type: | REFERENCE |
Column Detail - RCM_TLC_FACILITY_TYPE
Column Name | Type | Null? | Definition |
---|---|---|---|
RCM_TLC_FACILITY_TYPE_ID | DOUBLE | N | Uniquely identifies a TLC facility type. |
TLC_FACILITY_TYPE_DISPLAY | VARCHAR(100) | N | Display value for the TLC facility type. |
TLC_FACILITY_TYPE_IDENT | VARCHAR(100) | N | Uniquely identifies a TLC Facility Type. |
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_FACILITY_TYPE
Parent Column in RCM_TLC_FACILITY_TYPE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RCM_TLC_FACILITY_TYPE_ID | RCM_TLC_FAC_TYPE_FAC_R | RCM_TLC_FACILITY_TYPE_ID |
RCM_TLC_FAC_TYPE_FAC_R
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | RevWorks Care Management - Total Living Choices Facility & Facility Type Related |
Definition: | Relates Total Living Choice Facilities and the type of facility. |
Table Type: | REFERENCE |
Column Detail - RCM_TLC_FAC_TYPE_FAC_R
Column Name | Type | Null? | Definition |
---|---|---|---|
RCM_TLC_FACILITY_ID | DOUBLE | N | Uniquely identifies the related TLC facility |
RCM_TLC_FACILITY_TYPE_ID | DOUBLE | N | Uniquely identifies the related TLC facility type. |
RCM_TLC_FAC_TYPE_FAC_R_ID | DOUBLE | N | Uniquely identifies the relationship between a facility and a facility type. |
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_FAC_TYPE_FAC_R
Child Column in RCM_TLC_FAC_TYPE_FAC_R(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RCM_TLC_FACILITY_ID | RCM_TLC_FACILITY | RCM_TLC_FACILITY_ID |
RCM_TLC_FACILITY_TYPE_ID | RCM_TLC_FACILITY_TYPE | RCM_TLC_FACILITY_TYPE_ID |
RCM_TLC_PLACEMENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | RevWorks Care Management - Total Living Choices Placement |
Definition: | Stores the facaility the patient was placed for discharge. |
Table Type: | ACTIVITY |
Column Detail - RCM_TLC_PLACEMENT
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. |
ENCNTR_ID | DOUBLE | N | Uniquely identifies the related encounter |
FINAL_TLC_FACILITY_ID | DOUBLE | N | Identifies the facility at which the patient will be placed. |
RCM_TLC_PLACEMENT_ID | DOUBLE | N | Records and contains the facility the patient was placed at for discharge. |
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_PLACEMENT
Child Column in RCM_TLC_PLACEMENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
FINAL_TLC_FACILITY_ID | RCM_TLC_FACILITY | RCM_TLC_FACILITY_ID |
Parent Column in RCM_TLC_PLACEMENT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RCM_TLC_PLACEMENT_ID | RCM_TLC_PLACEMENT_FAC_R | RCM_TLC_PLACEMENT_ID |