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 |