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