Table Detail Report

RCM_TLC_PLACEMENT_FAC_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: RevWorks Care Management - Total Living Choices Placement Facility Relationship
Definition: Relates the placement to the facility.
Table Type: ACTIVITY





Column Detail - RCM_TLC_PLACEMENT_FAC_R


Column Name Type Null? Definition
CANCEL_REASON_CD DOUBLE N Contains the reason this placement was cancelled.
DISCHARGE_PRSNL_ID DOUBLE N The discharge planner personnel identifier that initiated the post-acute referral.
PRIORITY_SEQ DOUBLE N Sequences the priority of the facility placement relationships.
RCM_TLC_FACILITY_ID DOUBLE N Uniquely identifies the related TLC Facility Identifier
RCM_TLC_PLACEMENT_FAC_R_ID DOUBLE N Uniquely identifies a relationship between the TLC placement and facility.
RCM_TLC_PLACEMENT_ID DOUBLE N Uniquely identifies the related TLC placement.
REPORT_REQUEST_ID DOUBLE N Identifies the report sent to the facility.
RESPONSE_CD DOUBLE N This is the codified response such as, Accepted, Declined, Considering, or Pending
TLC_EVENT_TYPE_CD DOUBLE N This is the codified event type such as, Send Referral, Send CLINICAL, RECEIVEDRESP, PLACEPATIENT, or SENDFAXFAIL
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.
VERSION_DT_TM DATETIME N Provides a version date and time history.



Relationship Detail - RCM_TLC_PLACEMENT_FAC_R


Child Column in RCM_TLC_PLACEMENT_FAC_R(FK) Parent Table Name Parent Column Name
Parents: REPORT_REQUEST_ID CR_REPORT_REQUEST REPORT_REQUEST_ID
DISCHARGE_PRSNL_ID PRSNL PERSON_ID
RCM_TLC_FACILITY_ID RCM_TLC_FACILITY RCM_TLC_FACILITY_ID
RCM_TLC_PLACEMENT_ID RCM_TLC_PLACEMENT RCM_TLC_PLACEMENT_ID


RCM_TLC_SERVICE



Column Section Relationship Section Top of Page


Table-level Detail

Description: RevWorks Care Management - Total Living Choices Service
Definition: Contains records the facility and the service provided per encounter.
Table Type: ACTIVITY





Column Detail - RCM_TLC_SERVICE


Column Name Type Null? Definition
ENCNTR_ID DOUBLE N Uniquely identifies the related encounter, which may be associated to many services.
FINAL_TLC_FACILITY_ID DOUBLE N Identifies the facility that will perform the service.
RCM_TLC_SERVICE_ID DOUBLE N Uniquely identifies the services provided.
SERVICE_CD DOUBLE N Services provided such as IV THERAPY, OXYGEN...
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_SERVICE


Child Column in RCM_TLC_SERVICE(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_SERVICE (PK) Child Table Name Child Column Name
Children: RCM_TLC_SERVICE_ID RCM_TLC_SERVICE_FAC_R RCM_TLC_SERVICE_ID


RCM_TLC_SERVICE_FAC_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: RevWorks Care Management - Service Facility Relationship
Definition: Relates the TLC Service to the Facility
Table Type: ACTIVITY





Column Detail - RCM_TLC_SERVICE_FAC_R


Column Name Type Null? Definition
CANCEL_REASON_CD DOUBLE N The reason for this service was cancelled
DISCHARGE_PRSNL_ID DOUBLE N The discharge planner personnel identifier that initiated the post-acute referral.
PRIORITY_SEQ DOUBLE N Sequences the priority of this relationship relative to other service/facility relationships.
RCM_TLC_FACILITY_ID DOUBLE N Uniquely identifies the related facility
RCM_TLC_SERVICE_FAC_R_ID DOUBLE N Uniquely identifies a relationship between the TLC service and facility.
RCM_TLC_SERVICE_ID DOUBLE N Uniquely identifies the related service.
REPORT_REQUEST_ID DOUBLE N Identifies the report sent to the facility.
RESPONSE_CD DOUBLE N This is the codified response.
TLC_EVENT_TYPE_CD DOUBLE N This is the codified event type such as, Send Referral, Send CLINICAL, RECEIVEDRESP, PLACEPATIENT, or SENDFAXFAIL
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.
VERSION_DT_TM DATETIME N Provides a version date and time history.



Relationship Detail - RCM_TLC_SERVICE_FAC_R


Child Column in RCM_TLC_SERVICE_FAC_R(FK) Parent Table Name Parent Column Name
Parents: REPORT_REQUEST_ID CR_REPORT_REQUEST REPORT_REQUEST_ID
DISCHARGE_PRSNL_ID PRSNL PERSON_ID
RCM_TLC_FACILITY_ID RCM_TLC_FACILITY RCM_TLC_FACILITY_ID
RCM_TLC_SERVICE_ID RCM_TLC_SERVICE RCM_TLC_SERVICE_ID


RCM_TLC_UPLOAD



Column Section Relationship Section Top of Page


Table-level Detail

Description: RevWorks Care Management - Total Living Choices Upload
Definition: Stores the templates uploaded to Total Living Choices
Table Type: ACTIVITY





Column Detail - RCM_TLC_UPLOAD


Column Name Type Null? Definition
ENCNTR_ID DOUBLE N Uniquely identifies the related encounter
RCM_TLC_UPLOAD_ID DOUBLE N Uniquely identifies a template uploaded to Total Living Choices.
REPORT_REQUEST_ID DOUBLE N Contains the request identifier for the report
SOURCE_TYPE_CD DOUBLE N Used to identify either placement or service upload document.
TEMPLATE_ID DOUBLE N The identifier for the report template.
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.
UPLOAD_DT_TM DATETIME N The date and time of the upload.
UPLOAD_END_DT_TM DATETIME Y The date and time when the actual uploading is complete.
UPLOAD_STATUS_CD DOUBLE N The status of the upload, such as success, report, error, or upload error.



Relationship Detail - RCM_TLC_UPLOAD


Child Column in RCM_TLC_UPLOAD(FK) Parent Table Name Parent Column Name
Parents: REPORT_REQUEST_ID CR_REPORT_REQUEST REPORT_REQUEST_ID
TEMPLATE_ID CR_REPORT_TEMPLATE REPORT_TEMPLATE_ID


RCM_TMPLT_EVENT_SET_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: RevWorks Care Management Template Event Set Relationship
Definition: This table stores pre-defined or pre-qualified clinical events for Clinical Reporting templates.
Table Type: REFERENCE





Column Detail - RCM_TMPLT_EVENT_SET_RELTN


Column Name Type Null? Definition
EVENT_SET_NAME VARCHAR(40) Y The name of the event set
QUALIFICATION_TYPE_CD DOUBLE N The type of qualification criteria for retrieving results. (ALL, FIRSTN, LASTN, LOOKBACK...)
QUALIFICATION_VALUE DOUBLE N This field holds the qualification number value for the selected qualification type.
RCM_TMPLT_EVENT_SET_RELTN_ID DOUBLE N Uniquely defines a pre-defined or pre-qualified clinical event for Clinical Reporting templates.
TEMPLATE_ID DOUBLE N The identifier of the Clinical Reporting template.
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_TMPLT_EVENT_SET_RELTN


Child Column in RCM_TMPLT_EVENT_SET_RELTN(FK) Parent Table Name Parent Column Name
Parents: TEMPLATE_ID CR_REPORT_TEMPLATE REPORT_TEMPLATE_ID