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 |