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 |