Table Detail Report

RCA_CONV_GROUP_POSITION_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Ambulatory Conversation Group Position Relation
Definition: Defines the relationship between a Conversation Group and a list of one to many user positions.
Table Type: REFERENCE





Column Detail - RCA_CONV_GROUP_POSITION_R


Column Name Type Null? Definition
POSITION_CD DOUBLE N The position code that has a relationship with the conversation group.
RCA_CONV_GROUP_ID DOUBLE N The unique identifier that identifies a single row on the RCA_CONV_GROUP table across domains and has a relationship with the position code on this row.
RCA_CONV_GROUP_POSITION_R_ID DOUBLE N Unique generated number that identifies a single row on the RCA_CONV_GROUP_POSITION_R 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 - RCA_CONV_GROUP_POSITION_R


Child Column in RCA_CONV_GROUP_POSITION_R(FK) Parent Table Name Parent Column Name
Parents: RCA_CONV_GROUP_ID RCA_CONV_GROUP RCA_CONV_GROUP_ID


RCA_CONV_TRANSIENT_FIELD



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Access Conversation Transient Field
Definition: Represents a transient field for a registration conversation within the Revenue Cycle Solution.
Table Type: REFERENCE





Column Detail - RCA_CONV_TRANSIENT_FIELD


Column Name Type Null? Definition
CODE_SET DOUBLE N The code set number of the transient field if the transient field type meaning is CODE.
CONV_FORM_TYPE_MEAN VARCHAR(100) N The meaning of the conversation form type the field will be transient within.
FIELD_TYPE_MEAN VARCHAR(100) N The meaning of the type of transient field.
LOGICAL_DOMAIN_ID DOUBLE N The unique identifier for a logical domain. This identifier allows the data to be grouped by logical domain. For example, If you assign clients a logical_domain_id this would allow you to store data for multiple clients on this table.
RCA_CONV_TRANSIENT_FIELD_ID DOUBLE N Unique generated number that identifies a single row on the RCA_CONV_TRANSIENT_FIELD table.
TRANSIENT_FIELD_KEY_TXT VARCHAR(100) N The textual key of the transient field.
TRANSIENT_FIELD_NAME VARCHAR(100) N The name of the transient field.
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 - RCA_CONV_TRANSIENT_FIELD


Child Column in RCA_CONV_TRANSIENT_FIELD(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID


RCA_MOBILE_SESSION



Column Section Relationship Section Top of Page


Table-level Detail

Description: RCA Mobile Session
Definition: Stores mobile Kiosk session information for Kiosk Tracking Board in CPM solution.
Table Type: ACTIVITY





Column Detail - RCA_MOBILE_SESSION


Column Name Type Null? Definition
ENCNTR_ID DOUBLE N The encounter identifier of the mobile session.
PERSON_ID DOUBLE N The person identifier of the mobile session.
RCA_MOBILE_PROFILE_ID DOUBLE N The identifier of the mobile profile.
RCA_MOBILE_SESSION_ID DOUBLE N Unique generated number that identifies a single row on the RCA_MOBILE_SESSION table.
SESSION_BEG_DT_TM DATETIME N The date and time the mobile session begins.
SESSION_END_DT_TM DATETIME Y The date and time the mobile session ends.
SESSION_STATE_CD DOUBLE N The current state of the mobile session.
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 - RCA_MOBILE_SESSION


Child Column in RCA_MOBILE_SESSION(FK) Parent Table Name Parent Column Name
Parents: ENCNTR_ID ENCOUNTER ENCNTR_ID
PERSON_ID PERSON PERSON_ID
RCA_MOBILE_PROFILE_ID RCA_MOBILE_PROFILE RCA_MOBILE_PROFILE_ID




Parent Column in RCA_MOBILE_SESSION (PK) Child Table Name Child Column Name
Children: RCA_MOBILE_SESSION_ID RCA_MOBILE_SESSION_ACT RCA_MOBILE_SESSION_ID


RCA_MOBILE_SESSION_ACT



Column Section Relationship Section Top of Page


Table-level Detail

Description: RCA Mobile Session Activity
Definition: Stores mobile Kiosk activity information for Kiosk Tracking Board in CPM solution.
Table Type: ACTIVITY





Column Detail - RCA_MOBILE_SESSION_ACT


Column Name Type Null? Definition
ACT_DT_TM DATETIME N The date and time the session activity was occurred.
ACT_TYPE_CD DOUBLE N The type of the activity for the session.
PARENT_ENTITY_ID DOUBLE N Identifies to which entity this row is related for the activity.
PARENT_ENTITY_NAME VARCHAR(50) N Identifies to which entity this row is related for the activity.
RCA_MOBILE_SESSION_ACT_ID DOUBLE N Unique generated number that identifies a single row on the RCA_MOBILE_SESSION_ACTIVITY table.
RCA_MOBILE_SESSION_ID DOUBLE N The identifier of the mobile session.
RESULT_ACTION_CD DOUBLE N The result action was performed on the activity.
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 - RCA_MOBILE_SESSION_ACT


Child Column in RCA_MOBILE_SESSION_ACT(FK) Parent Table Name Parent Column Name
Parents: RCA_MOBILE_SESSION_ID RCA_MOBILE_SESSION RCA_MOBILE_SESSION_ID


RCA_NOTIFICATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Ambulatory - Notification
Definition: Represents notification actions for the Revenue Cycle solution.
Table Type: REFERENCE





Column Detail - RCA_NOTIFICATION


Column Name Type Null? Definition
LOGICAL_DOMAIN_ID DOUBLE N Uniquely identifies the related logical domain.
PRIORITY_SEQ DOUBLE N The sequence index for the RCA_RULE_ID for a given LOGICAL_DOMAIN and TYPE_MEANING.
RCA_NOTIFICATION_ID DOUBLE N Uniquely identifies a notification action for the Revenue Cycle solution.
RCA_RULE_ID DOUBLE N Uniquely identifies a related Revenue Cycle Ambulatory Rule.
TYPE_MEANING_TXT VARCHAR(100) Y The meaning of the type of notification for the given Logical_Domain_ID. Valid values are "PATIENT"
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 - RCA_NOTIFICATION


Child Column in RCA_NOTIFICATION(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
RCA_RULE_ID RCA_RULE RCA_RULE_ID