Table Detail Report
RCM_POST_ACUTE_EVENT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | RevWorks Care Management - Post Acute Event |
Definition: | Stores referral event and booking information from post-acute providers |
Table Type: | ACTIVITY |
Column Detail - RCM_POST_ACUTE_EVENT
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. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
DIRECT_EMAIL_IND | DOUBLE | N | Indicates if the event provider has been sent an email. |
DISCHARGE_PRSNL_ID | DOUBLE | N | The PRSNL_ID of the discharge planner who initiated the post-acute referral. |
ENCNTR_ID | DOUBLE | N | Uniquely identifies the related Encounter for this post-acute referral event. |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
EVENT_DT_TM | DATETIME | Y | The post-acute referral event date and time |
EVENT_IDENT | VARCHAR(100) | N | The external unique event identifier from the third party system. |
EVENT_TYPE_CD | DOUBLE | N | The type of post-acute event. |
HOSPITAL_STATUS_CD | DOUBLE | N | The referral status from the hospital or the patient's facility. |
POST_ACUTE_PROVIDER_ID | DOUBLE | N | Uniquely identifies the post-acute provider. |
PREV_POST_ACUTE_EVENT_ID | DOUBLE | N | Used to track versions of the post-acute event. This field will always point back to the initial value created. This may be used to find the correct version when combined with the begin and end effective dates and times. |
PROVIDER_RESPONSE_CD | DOUBLE | N | The referral response status from the post-acute provider. |
RCM_POST_ACUTE_EVENT_ID | DOUBLE | N | Uniquely identifies referral event and booking information from post-acute providers. |
SERVICE_CD | DOUBLE | N | The level of care or service type such as shelter, assisted living, durable medical equipment... of the referral that is provided by the post-acute provider. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - RCM_POST_ACUTE_EVENT
Child Column in RCM_POST_ACUTE_EVENT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
DISCHARGE_PRSNL_ID | PRSNL | PERSON_ID | |
PREV_POST_ACUTE_EVENT_ID | RCM_POST_ACUTE_EVENT | RCM_POST_ACUTE_EVENT_ID | |
POST_ACUTE_PROVIDER_ID | RCM_POST_ACUTE_PROVIDER | RCM_POST_ACUTE_PROVIDER_ID |
Parent Column in RCM_POST_ACUTE_EVENT (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RCM_POST_ACUTE_EVENT_ID | RCM_POST_ACUTE_EVENT | PREV_POST_ACUTE_EVENT_ID |
RCM_POST_ACUTE_PROVIDER
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | RevWorks Care Management Post Acute Provider |
Definition: | Stores post-acute provider information. |
Table Type: | REFERENCE |
Column Detail - RCM_POST_ACUTE_PROVIDER
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. |
CITY | VARCHAR(100) | N | The city of the post-acute provider. |
PHONE | VARCHAR(100) | N | The phone number of the post-acute provider. |
POSTAL_CODE | VARCHAR(25) | N | The postal code of the post-acute provider. |
PROVIDER_IDENT | VARCHAR(100) | N | This is the value of the external unique identifier of the post-acute provider. |
PROVIDER_NAME | VARCHAR(100) | N | The name of the post-acute provider. |
RCM_POST_ACUTE_PROVIDER_ID | DOUBLE | N | Uniquely identifies post-acute provider information. |
STATE | VARCHAR(100) | N | The state of the post-acute provider. |
STREET_ADDR | VARCHAR(100) | N | Contains line one of the street address of the post-acute provider. |
STREET_ADDR2 | VARCHAR(100) | N | Contains line two of the street address of the post-acute provider. |
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_POST_ACUTE_PROVIDER
Parent Column in RCM_POST_ACUTE_PROVIDER (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RCM_POST_ACUTE_PROVIDER_ID | ENCNTR_AVOIDABLE_DAYS | POST_ACUTE_PROVIDER_ID |
ENCNTR_READMIT_ASSESS | POST_ACUTE_PROVIDER_ID | ||
RCM_POST_ACUTE_EVENT | POST_ACUTE_PROVIDER_ID | ||
RCM_POST_ACUTE_PROV_EMAIL | RCM_POST_ACUTE_PROVIDER_ID |
RCM_POST_ACUTE_PROV_EMAIL
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Management Post Acute Provider Email |
Definition: | Stores post acute provider email addresses |
Table Type: | ACTIVITY |
Column Detail - RCM_POST_ACUTE_PROV_EMAIL
Column Name | Type | Null? | Definition |
---|---|---|---|
EMAIL_ADDR | VARCHAR(100) | N | Contains the provider email address. |
RCM_POST_ACUTE_PROVIDER_ID | DOUBLE | N | Uniquely identifies the associated post acute provider. |
RCM_POST_ACUTE_PROV_EMAIL_ID | DOUBLE | N | Unique generated number that identifies a single row on the RCM_POST_ACUTE_PROVIDER_EMAIL table. |
UPDT_APPLCTX | DOUBLE | N | The application context number from the record info block. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_DT_TM | DATETIME | N | The date and time the row was last inserted or updated. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
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. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
UPDT_TASK | DOUBLE | N | The registered (assigned) task number for the process that inserted or updated the row. The UPDT family of columns are typically used for housekeeping and external system process and should never be depended on for solution specific logic. |
Relationship Detail - RCM_POST_ACUTE_PROV_EMAIL
Child Column in RCM_POST_ACUTE_PROV_EMAIL(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RCM_POST_ACUTE_PROVIDER_ID | RCM_POST_ACUTE_PROVIDER | RCM_POST_ACUTE_PROVIDER_ID |
RCM_POST_ACUTE_UPLOAD
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Management - Post Acute Upload |
Definition: | Stores post_acute upload packet information. |
Table Type: | ACTIVITY |
Column Detail - RCM_POST_ACUTE_UPLOAD
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. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
ENCNTR_ID | DOUBLE | N | Uniquely identifies the related encounter. |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
PREV_RCM_POST_ACUTE_UPLOAD_ID | DOUBLE | N | Used to track versions of the upload. this field will always point back to the initial value created. this may be used to find the correct version when combined with begin and end effective dates and times. |
RCM_POST_ACUTE_UPLOAD_ID | DOUBLE | N | Uniquely identifies post-acute upload packet information. |
REPORT_REQUEST_ID | DOUBLE | N | Uniquely identifies the related report request. |
TEMPLATE_ID | DOUBLE | N | Uniquely identifies the related 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_STATUS_CD | DOUBLE | N | The status of the upload, such as success, report, error, or upload error. |
UPLOAD_STATUS_DT_TM | DATETIME | Y | The date and time of the upload status. |
Relationship Detail - RCM_POST_ACUTE_UPLOAD
Child Column in RCM_POST_ACUTE_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 | |
ENCNTR_ID | ENCOUNTER | ENCNTR_ID | |
PREV_RCM_POST_ACUTE_UPLOAD_ID | RCM_POST_ACUTE_UPLOAD | RCM_POST_ACUTE_UPLOAD_ID |
Parent Column in RCM_POST_ACUTE_UPLOAD (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RCM_POST_ACUTE_UPLOAD_ID | RCM_POST_ACUTE_UPLOAD | PREV_RCM_POST_ACUTE_UPLOAD_ID |
RCM_SECURITY_TOKEN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | RevWorks Care Management - Security Token |
Definition: | Stores security token information. |
Table Type: | ACTIVITY |
Column Detail - RCM_SECURITY_TOKEN
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. |
ACTIVE_STATUS_DT_TM | DATETIME | N | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | N | The person who caused the active_status_cd to be set or change. |
BEG_EFFECTIVE_DT_TM | DATETIME | N | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
ENCNTR_ID | DOUBLE | N | Uniquely identifies the related encounter. |
END_EFFECTIVE_DT_TM | DATETIME | N | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
PERSON_ID | DOUBLE | N | Uniquely identifies the related person. |
RCM_SECURITY_TOKEN_ID | DOUBLE | N | Uniquely identifies security token information. |
SECURITY_TOKEN_UUID | VARCHAR(36) | N | The unique generated security token (UUID) |
TOKEN_TYPE_CD | DOUBLE | N | The type of security token |
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_SECURITY_TOKEN
Child Column in RCM_SECURITY_TOKEN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | ENCNTR_ID | ENCOUNTER | ENCNTR_ID |
PERSON_ID | PERSON | PERSON_ID |