Table Detail Report

RCA_REG_ACTION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Ambulatory - Registration Action
Definition: Defines the base information about the Registration Action.
Table Type: REFERENCE





Column Detail - RCA_REG_ACTION


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.
CONFIG_LONG_BLOB LONGBLOB Y The long blob that contains generic configuration for a revenuecycle registration action.
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_REG_ACTION_ID DOUBLE N Unique generataed number that identifies a single row on the RCA_REG_ACTION table.
REG_ACTION_DESC VARCHAR(100) N The description of the registration action.
REG_ACTION_KEY_TXT VARCHAR(100) N The uniquely identifiable key per logical domain.
REG_ACTION_NAME VARCHAR(100) N The name of the Registration Action.
REG_ACTION_TYPE_CD DOUBLE N The type of Registration Action.
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_REG_ACTION


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




Parent Column in RCA_REG_ACTION (PK) Child Table Name Child Column Name
Children: RCA_REG_ACTION_ID RCA_REG_ACTION_CONV_RELTN RCA_REG_ACTION_ID
RCA_REG_ACTION_ITEM RCA_REG_ACTION_ID


RCA_REG_ACTION_CONV_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Ambulatory - Registration Action Conversation Relationship
Definition: Stores the relationship between Registration Actions and Conversations.
Table Type: REFERENCE





Column Detail - RCA_REG_ACTION_CONV_RELTN


Column Name Type Null? Definition
RCA_CONVERSATION_ID DOUBLE N The unique identifier that identifies a single row on the RCA_CONVERSATION table across domains.
RCA_REG_ACTION_CONV_RELTN_ID DOUBLE N Unique generated number that identifies a single row on the RCA_REG_ACTION_CONV_RELTN.
RCA_REG_ACTION_ID DOUBLE N The unique identifier that identifies a single row on the RCA_REG_ACTION table across domains.
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_REG_ACTION_CONV_RELTN


Child Column in RCA_REG_ACTION_CONV_RELTN(FK) Parent Table Name Parent Column Name
Parents: RCA_CONVERSATION_ID RCA_CONVERSATION RCA_CONVERSATION_ID
RCA_REG_ACTION_ID RCA_REG_ACTION RCA_REG_ACTION_ID


RCA_REG_ACTION_ITEM



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Ambulatory - Registration Action Launch Item
Definition: This table will represent launch items that can be associated to a registration action.
Table Type: REFERENCE





Column Detail - RCA_REG_ACTION_ITEM


Column Name Type Null? Definition
LAUNCH_ITEM_CD DOUBLE N Identifies the type of launch item
PRIORITY_SEQ DOUBLE N The priority of this launch item in relation to other launch items associated to the same registration action.
RCA_REG_ACTION_ID DOUBLE N Uniquely identifies the related row on the RCA_REG_ACTION table.
RCA_REG_ACTION_ITEM_ID DOUBLE N System generated number to uniquely identify a row on the RCA_REG_ACTION_ITEM 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_REG_ACTION_ITEM


Child Column in RCA_REG_ACTION_ITEM(FK) Parent Table Name Parent Column Name
Parents: RCA_REG_ACTION_ID RCA_REG_ACTION RCA_REG_ACTION_ID


RCA_RULE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Ambulatory - Rule
Definition: Represents a rule for the Revenue Cycle Solution
Table Type: REFERENCE





Column Detail - RCA_RULE


Column Name Type Null? Definition
ACTIONS_LONG_BLOB_ID DOUBLE N The XML representation of the actions for the RCA_RULE row when the condition return is true.
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.
CATEGORY_MEANING_TXT VARCHAR(100) Y The type of RCA_RULE that is used to categorize the RCA_RULE rows.
CONDITION_LONG_BLOB_ID DOUBLE N The XML representation of the condition for the RCA_RULE row.
DESCRIPTION_TXT VARCHAR(255) Y The description of the RCA_RULE row that is displayed to end users and provides more detail than the Display_txt value.
DISPLAY_TXT VARCHAR(100) Y The display or name value of the RCA_RULE row that is displayed to end users.
ELSE_ACTIONS_LONG_BLOB_ID DOUBLE N The XML representation of the actions for the RCA_RULE row when the condition returns false.
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.
MAJOR_SCHEMA_VERSION_NBR DOUBLE N Defines the major version of an RCA rule.
RCA_RULE_ID DOUBLE N Uniquely identifies a rule for the Revenue Cycle Solution
SCHEMA_VERSION_NBR DOUBLE N The current version of the schema that the RCA_RULE row is build on top of.
TYPE_MEANING_TXT VARCHAR(100) Y The sub type of RCA_RULE that is used to categorize the RCA_RULE rows inn addition to the type_meaning column.
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_RULE


Child Column in RCA_RULE(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
ACTIONS_LONG_BLOB_ID LONG_BLOB_REFERENCE LONG_BLOB_ID
CONDITION_LONG_BLOB_ID LONG_BLOB_REFERENCE LONG_BLOB_ID
ELSE_ACTIONS_LONG_BLOB_ID LONG_BLOB_REFERENCE LONG_BLOB_ID




Parent Column in RCA_RULE (PK) Child Table Name Child Column Name
Children: RCA_RULE_ID RCA_CONVERSATION_RULE_R RCA_RULE_ID
RCA_NOTIFICATION RCA_RULE_ID
RCA_RULE_RULE_RELTN CHILD_RCA_RULE_ID
RCA_RULE_RULE_RELTN PARENT_RCA_RULE_ID
RCA_RULE_SERVICE_RELTN RCA_RULE_ID


RCA_RULE_RULE_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Access Rule to Rule Relationship
Definition: The relationship between two RCA Rules
Table Type: REFERENCE





Column Detail - RCA_RULE_RULE_RELTN


Column Name Type Null? Definition
CHILD_RCA_RULE_ID DOUBLE Y The identifier of the rule rule in the relationship.
PARENT_RCA_RULE_ID DOUBLE Y The identifier of the parent rule in the relationship.
RCA_RULE_RULE_RELTN_ID DOUBLE N A system generated identifier to uniquely identify a row on the RCA_RULE_RULE_RELTN table.
UPDT_APPLCTX DOUBLE Y 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 Y 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 Y 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 Y 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 Y 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_RULE_RULE_RELTN


Child Column in RCA_RULE_RULE_RELTN(FK) Parent Table Name Parent Column Name
Parents: CHILD_RCA_RULE_ID RCA_RULE RCA_RULE_ID
PARENT_RCA_RULE_ID RCA_RULE RCA_RULE_ID