HEALTH_PLAN_FIELD_FORMAT



Column Section Relationship Section Top of Page


Table-level Detail

Description: Health Plan Field Format
Definition: Contains field formatting rules for Health Plan fields.
Table Type: REFERENCE





Column Detail - HEALTH_PLAN_FIELD_FORMAT


Column Name Type Null? Definition
FIELD_REQUIRED_IND DOUBLE N Indicates that the Health Plan field is required.
FIELD_TYPE_MEANING_TXT VARCHAR(12) Y The meaning of the type of Health Plan field. Valid values would be "MEMBER" or "GROUP".
FORMAT_MASK_TXT VARCHAR(100) Y The format mask of the Health Plan field.
HEALTH_PLAN_FIELD_FORMAT_ID DOUBLE N Uniquely identifies a Health Plan field format.
HEALTH_PLAN_ID DOUBLE N Uniquely identifies the related Health Plan
MIN_FORMAT_MASK_CHAR_CNT DOUBLE N The minimum character count for the Health Plan field format mask.
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 - HEALTH_PLAN_FIELD_FORMAT


Child Column in HEALTH_PLAN_FIELD_FORMAT(FK) Parent Table Name Parent Column Name
Parents: HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID


RCA_CONVERSATION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Ambulatory - Conversation
Definition: Stores the details about conversation for the Revenue Cycle solution.
Table Type: REFERENCE





Column Detail - RCA_CONVERSATION


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.
CONVERSATION_TYPE_CD DOUBLE N The type of Revenue Cycle conversation.
CONVERSATION_UUID VARCHAR(100) N Will uniquely identify the conversation universally.
DESCRIPTION_TXT VARCHAR(255) Y The description of the Revenue Cycle conversation.
DISPLAY_TXT VARCHAR(100) Y The display of the Revenue Cycle conversation.
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.
LONG_BLOB_ID DOUBLE N Uniquely identifies the contents of the Revenue Cycle conversation.
MAJOR_VERSION_NBR DOUBLE N Defines the major version of a conversation.
PRIORITY_SEQ DOUBLE N The priority sequence of the Revenue Cycle conversation compared to the other conversations of the same type.
RCA_CONVERSATION_ID DOUBLE N Uniquely identifies details about a conversation for the Revenue Cycle solution.
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.
VERSION_NBR DOUBLE N The version number of the Revenue Cycle conversation.



Relationship Detail - RCA_CONVERSATION


Child Column in RCA_CONVERSATION(FK) Parent Table Name Parent Column Name
Parents: LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID
LONG_BLOB_ID LONG_BLOB_REFERENCE LONG_BLOB_ID




Parent Column in RCA_CONVERSATION (PK) Child Table Name Child Column Name
Children: RCA_CONVERSATION_ID RCA_CONVERSATION_RULE_R RCA_CONVERSATION_ID
RCA_CONV_GROUP_CONV_R RCA_CONVERSATION_ID
RCA_REG_ACTION_CONV_RELTN RCA_CONVERSATION_ID


RCA_CONVERSATION_RULE_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Ambulatory - Conversation Rule Relationship
Definition: Contains relationships between the conversation and rule tables.
Table Type: REFERENCE





Column Detail - RCA_CONVERSATION_RULE_R


Column Name Type Null? Definition
EXECUTION_TYPE_MEANING_TXT VARCHAR(100) Y The execution type of relationship which indicates when the RCA_RULE should be executed for the related RCA_CONVERSATION.
FORM_TYPE_MEANING_TXT VARCHAR(100) Y The form type of relationship which indicates where the RCA_RULE should be used for the related RCA_CONVERSATION.
PRIORITY_SEQ DOUBLE N The priority sequence for the relationship in relation to other relationships between the same RCA_CONVERSATION and RCA_RULE rows.
RCA_CONVERSATION_ID DOUBLE N The unique identifier that identifies a single row on the RCA_CONVERSATION table across domains.
RCA_CONVERSATION_RULE_R_ID DOUBLE N Uniquely Identifies a relationship between a RCA_CONVERSATION row and a RCA_RULE row for the Revenue Cycle solution.
RCA_RULE_ID DOUBLE N Uniquely identifies the related RCA rule.
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_CONVERSATION_RULE_R


Child Column in RCA_CONVERSATION_RULE_R(FK) Parent Table Name Parent Column Name
Parents: RCA_CONVERSATION_ID RCA_CONVERSATION RCA_CONVERSATION_ID
RCA_RULE_ID RCA_RULE RCA_RULE_ID


RCA_CONV_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Ambulatory - Conversation Group
Definition: Stores the details about the conversation groups for the Revenue Cycle Registration solution.
Table Type: REFERENCE





Column Detail - RCA_CONV_GROUP


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.
ALTERNATE_GROUP_NAME VARCHAR(50) Y An alternate name for the conversation group. It can be used to identify one or more conversation groups.
CONV_GROUP_NAME VARCHAR(100) N The name of the Revenue Cycle conversation group.
DESCRIPTION_TXT VARCHAR(255) N The description of the Revenue Cycle conversation group.
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_GROUP_ID DOUBLE N Unique generated number that identifies a single row on the RCA_CONV_GROUP 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


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




Parent Column in RCA_CONV_GROUP (PK) Child Table Name Child Column Name
Children: RCA_CONV_GROUP_ID RCA_CONV_GROUP_CONV_R RCA_CONV_GROUP_ID
RCA_CONV_GROUP_POSITION_R RCA_CONV_GROUP_ID


RCA_CONV_GROUP_CONV_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Ambulatory Conversation Group Relation
Definition: Stores the relationship between conversation groups and conversations.
Table Type: REFERENCE





Column Detail - RCA_CONV_GROUP_CONV_R


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 that is related to the conversation group on this row.
RCA_CONV_GROUP_CONV_R_ID DOUBLE N Unique generated number that identifies a single row on the RCA_CONV_GROUP_CONV_R table.
RCA_CONV_GROUP_ID DOUBLE N The unique identifier that identifies a single row on the RCA_CONVERSATION_GROUP table across domains that is related to the conversation on this row.
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_CONV_R


Child Column in RCA_CONV_GROUP_CONV_R(FK) Parent Table Name Parent Column Name
Parents: RCA_CONVERSATION_ID RCA_CONVERSATION RCA_CONVERSATION_ID
RCA_CONV_GROUP_ID RCA_CONV_GROUP RCA_CONV_GROUP_ID