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