Table Detail Report
RCA_RULE_SERVICE
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Ambulatory |
Definition: | Defines a rule service for RCA. |
Table Type: | REFERENCE |
Column Detail - RCA_RULE_SERVICE
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. |
DESCRIPTION_TXT | VARCHAR(500) | N | The textual description of the rule service. |
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_RULE_SERVICE_ID | DOUBLE | N | Unique generated number that identifies a single row on the rca_rule_service table. |
RULE_CATEGORY_MEANING_TXT | VARCHAR(100) | N | The meaning of the rule category with which this service is associated. |
RULE_TYPE_MEANING_TXT | VARCHAR(100) | N | The meaning of the rule type this service is associated with. |
SERVICE_DISPLAY_NAME | VARCHAR(100) | N | The user facing display of the rule service. |
SERVICE_NAME | VARCHAR(100) | N | The technical name of the rule service. |
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_SERVICE
Child Column in RCA_RULE_SERVICE(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LOGICAL_DOMAIN_ID | LOGICAL_DOMAIN | LOGICAL_DOMAIN_ID |
Parent Column in RCA_RULE_SERVICE (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RCA_RULE_SERVICE_ID | RCA_RULE_SERVICE_PARAM | RCA_RULE_SERVICE_ID |
RCA_RULE_SERVICE_RELTN | RCA_RULE_SERVICE_ID | ||
RCA_RULE_SERVICE_RESULT | RCA_RULE_SERVICE_ID |
RCA_RULE_SERVICE_PARAM
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Service Parameter |
Definition: | This table contains parameters related to RCA rule services. |
Table Type: | REFERENCE |
Column Detail - RCA_RULE_SERVICE_PARAM
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. |
DATA_TYPE_CD | DOUBLE | N | The code value of the parameter's data type. Values come from code set 4124000. |
FIELD_KEY_TXT | VARCHAR(255) | N | The key that identifies the field that the value comes from, which is being passed into the service as a parameter. |
LITERAL_IND | DOUBLE | N | This indicator indicates whether or not the value stored in the FIELD_KEY_TXT is a literal value or not. |
RCA_RULE_SERVICE_ID | DOUBLE | N | Uniquely identifies the Rule Service that is using this record. |
RCA_RULE_SERVICE_PARAM_ID | DOUBLE | N | Unique generated number that identifies a single row on the RCA_RULE_SERVICE_PARAM table. |
SERVICE_KEY_TXT | VARCHAR(100) | N | The key that the service uses to map to the actual field key. We do not want the service to hold the actual field key to support future field key migrations. |
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_SERVICE_PARAM
Child Column in RCA_RULE_SERVICE_PARAM(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RCA_RULE_SERVICE_ID | RCA_RULE_SERVICE | RCA_RULE_SERVICE_ID |
RCA_RULE_SERVICE_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Ambulatory Rule Service Relationship |
Definition: | This table defines a relationship between a rule and a rule service. |
Table Type: | REFERENCE |
Column Detail - RCA_RULE_SERVICE_RELTN
Column Name | Type | Null? | Definition |
---|---|---|---|
RCA_RULE_ID | DOUBLE | N | Uniquely identifies the rule in this relationship. |
RCA_RULE_SERVICE_ID | DOUBLE | N | Uniquely identifies the related RCA_RULE_SERVICE. |
RCA_RULE_SERVICE_RELTN_ID | DOUBLE | N | Uniquely identifies a relationship between an RCA_RULE and an RCA_RULE_SERVICE. |
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_RULE_SERVICE_RELTN
Child Column in RCA_RULE_SERVICE_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RCA_RULE_ID | RCA_RULE | RCA_RULE_ID |
RCA_RULE_SERVICE_ID | RCA_RULE_SERVICE | RCA_RULE_SERVICE_ID |
RCA_RULE_SERVICE_RESULT
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Ambulatory Rule Service Result |
Definition: | This table defines an RCA rule service result. |
Table Type: | REFERENCE |
Column Detail - RCA_RULE_SERVICE_RESULT
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. |
DATA_TYPE_CD | DOUBLE | N | The code value of the result's data type. Values come from code set 4124000. |
RCA_RULE_SERVICE_ID | DOUBLE | N | Uniquely identifies the related RCA_RULE_SERVICE. |
RCA_RULE_SERVICE_RESULT_ID | DOUBLE | N | Unique generated number that identifies a single row on the RCA_RULE_SERVICE_RESULT table. |
SERVICE_KEY_TXT | VARCHAR(100) | N | The key used in the service that identifies the value for this result. |
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_SERVICE_RESULT
Child Column in RCA_RULE_SERVICE_RESULT(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | RCA_RULE_SERVICE_ID | RCA_RULE_SERVICE | RCA_RULE_SERVICE_ID |
RVR_CLEANUP_CONFIG
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Revenue Cycle Registration - Cleanup Configuration |
Definition: | Revenue Cycle Registration - Used to store cleanup configuration information. |
Table Type: | ACTIVITY |
Column Detail - RVR_CLEANUP_CONFIG
Column Name | Type | Null? | Definition |
---|---|---|---|
ACTIVE_IND | DOUBLE | Y | 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. |
ACTIVE_STATUS_CD | DOUBLE | Y | Indicates the status of the row itself (not the data in the row) such as active, inactive, combined away, pending purge, etc. |
ACTIVE_STATUS_DT_TM | DATETIME | Y | The date and time that the active_status_cd was set. |
ACTIVE_STATUS_PRSNL_ID | DOUBLE | Y | The person who caused the active_status_cd to be set or change. |
BATCH_SIZE_NBR | DOUBLE | Y | The maximum number of rows used by each batch mode script. Changeable. |
BEG_EFFECTIVE_DT_TM | DATETIME | Y | The date and time for which this table row becomes effective. Normally, this will be the date and time the row is added, but could be a past or future date and time. |
END_EFFECTIVE_DT_TM | DATETIME | Y | The date/time after which the row is no longer valid as active current data. This may be valued with the date that the row became inactive. |
FREQUENCY_TXT | VARCHAR(25) | Y | The frequency a cleanup program is called. D-Daily, W-Weekly, M-Monthly |
LAST_PERSON_ID | DOUBLE | Y | LAST_PERSON_ID changed. Used by Scripts in batch mode. |
LAST_RUN_BATCH_CNT | DOUBLE | Y | The batch number that was last processed in ALL mode. |
LAST_RUN_DT_TM | DATETIME | Y | The date this script was last run in ALL mode. |
MAX_ROWS_NBR | DOUBLE | Y | Maximum rows updated per execution in ALL mode. |
PROGRAM_NAME | VARCHAR(100) | Y | The name of the CCL program that is to be run during a clean up. |
RVR_CLEANUP_CONFIG_ID | DOUBLE | N | A system generated number used to uniquely identify a row on the RVR_CLEANUP_CONFIG 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 - RVR_CLEANUP_CONFIG
Child Column in RVR_CLEANUP_CONFIG(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | LAST_PERSON_ID | PERSON | PERSON_ID |
Parent Column in RVR_CLEANUP_CONFIG (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | RVR_CLEANUP_CONFIG_ID | RVR_CLEANUP_LOG | RVR_CLEANUP_CONFIG_ID |