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 |