Table Detail Report

RCR_RVU_MODIFIER_FORMULA



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Reporting RVU Modifier Formula
Definition: This table defines the formula to use when calculating the RVU value for each modifier.
Table Type: REFERENCE





Column Detail - RCR_RVU_MODIFIER_FORMULA


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.
BEG_EFFECTIVE_DT_TM DATETIME N 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.
BILLING_ENTITY_ID DOUBLE N The Billing Entity for which the modifier formula is built.
CALCULATION_VALUE DOUBLE N The value by which the specific Modifier will alter the RVU
CREATE_DT_TM DATETIME N Contains the record creation date.
END_EFFECTIVE_DT_TM DATETIME N 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.
GLOBAL_IND DOUBLE N Indicates if the calculation value will be applied individually or to the entire RVU.
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.
MODIFIER_IDENT VARCHAR(50) Y Identifies the Modifier for which the formula applies.
MODIFIER_POSITION_NBR DOUBLE N The position of the modifier assignment (e.g. Primary, Secondary, etc.)
PERCENTAGE_IND DOUBLE N Indicates if the calculation value is a percent or normal number.
RCR_RVU_MODIFIER_FORMULA_ID DOUBLE N Unique generated number that identifies a single row on the RCR_RVU_MODIFIER_FORMULA table.
RVU_OVERRIDE_IND DOUBLE N This is set to True if the modifier within the RVU formula will override the RVU value to be 0.0 rather than the calculated value.
SOURCE_VOCABULARY_CD DOUBLE N The source vocabulary for which the modifier formula is built (e.g. CPT4, HCPCS)
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 - RCR_RVU_MODIFIER_FORMULA


Child Column in RCR_RVU_MODIFIER_FORMULA(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID
LOGICAL_DOMAIN_ID LOGICAL_DOMAIN LOGICAL_DOMAIN_ID


RCR_TRANS_DIST



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Reporting - Transaction Distribution
Definition: Rows represent current a log of automatic distributions of posted payment amounts across one or more posted charges. Purpose of table is to render scattered financial information into a form that can be used for business accounting reports.
Table Type: ACTIVITY





Column Detail - RCR_TRANS_DIST


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.
ACTIVITY_DT_TM DATETIME N Date and Time the transaction was posted.
ACTIVITY_ID DOUBLE N Uniquely identifies the related transaction
BEG_EFFECTIVE_DT_TM DATETIME N 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.
BILLING_ENTITY_ID DOUBLE N Uniquely identifies the related billing entity
CHARGE_AMT DOUBLE N The total chare amount for the specific charge or group of charges.
CHARGE_ITEM_ID DOUBLE N Uniquely identifies the related charge item
DETAIL_SUMMARY_FLG DOUBLE N Indicates whether this row represents the distribution of a portion of the transaction to a specific charge, or to a group of charges.
DISTRIBUTED_AMT DOUBLE N The amount of the transaction that was distributed to the charge.
END_EFFECTIVE_DT_TM DATETIME N 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.
FACILITY_CD DOUBLE N Uniquely identifies the facility where the patient was located when the charge was incurred.
FIN_NUMBER_ALIAS VARCHAR(200) Y Secondary identifier for the financial encounter.
NOMENCLATURE_ID DOUBLE N Uniquely identifies the nomenclature associated with the proceure alias.
ORDERING_PHYSICIAN_ID DOUBLE N Uniquely identifies the physician responsible for ordering material or service.
PFT_ENCNTR_ID DOUBLE N Uniquely identifies the related financial encounter.
POSTED_BY_ID DOUBLE N Uniquely identifies the personnel responsible for posting the charge.
PROCEDURE_ALIAS VARCHAR(200) Y Identifies the procedure associated with the charge.
RCR_TRANS_DIST_ID DOUBLE N Uniquely identifies a row that represents a current log of automatic distributions of posted payment amounts across one or more posted charges.
RENDERING_PHYSICIAN_ID DOUBLE N Uniquely identifies the physician responsible for rendering service.
SERVICE_DT_TM DATETIME Y Date and Time the service was rendered.
TRANS_SUB_TYPE_CD DOUBLE N An optional identifier that further defines the type of transaction.
TRANS_TYPE_CD DOUBLE N Identifies the type of transaction (payment or adjustment)
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 - RCR_TRANS_DIST


Child Column in RCR_TRANS_DIST(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID
CHARGE_ITEM_ID CHARGE CHARGE_ITEM_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
PFT_ENCNTR_ID PFT_ENCNTR PFT_ENCNTR_ID
ORDERING_PHYSICIAN_ID PRSNL PERSON_ID
POSTED_BY_ID PRSNL PERSON_ID
RENDERING_PHYSICIAN_ID PRSNL PERSON_ID
ACTIVITY_ID TRANS_LOG ACTIVITY_ID


RCR_UPDATE_QUAL



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle - Update Qualified
Definition: This table contains all quailified IDs per each execution of a Revenue Cycle Analytics cleanup and or update script.
Table Type: ACTIVITY





Column Detail - RCR_UPDATE_QUAL


Column Name Type Null? Definition
CREATE_DT_TM DATETIME Y Date and time the row was added.
PROCESS_IND DOUBLE N Indicates whether the particular ID is processed by the execution script or not.
QUALIFIED_IDENT DOUBLE N The identifier that qualified as a part of the qualification process.
QUAL_BEGIN_DT_TM DATETIME Y Stores the begin date from the input prompt.
QUAL_END_DT_TM DATETIME Y Stores the end date from the input prompt.
RCR_UPDATE_QUAL_ID DOUBLE N Unique generated umber that identifies a single row on the RCR_UPDATE_QUAL_ID.
RCR_UPDATE_REGISTRY_ID DOUBLE N Uniquely identifies the related RCR_UPDATE_REGISTRY record.
REQUALIFIED_IND DOUBLE N Indicates whether the corresponing ID is requalified during the cleanup validation process.
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 - RCR_UPDATE_QUAL


Child Column in RCR_UPDATE_QUAL(FK) Parent Table Name Parent Column Name
Parents: RCR_UPDATE_REGISTRY_ID RCR_UPDATE_REGISTRY RCR_UPDATE_REGISTRY_ID


RCR_UPDATE_REGISTRY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle - Update Registry
Definition: This table contains data related to Revenue Cycle analytics clean up and update scripts.
Table Type: ACTIVITY





Column Detail - RCR_UPDATE_REGISTRY


Column Name Type Null? Definition
AUDIT_SCRIPT_NAME VARCHAR(40) Y Column stores the name of the Audit script associated with a particular cleanup.
COMPLETED_DT_TM DATETIME Y Stores the successful completion date time of the execution script.
CREATE_DT_TM DATETIME Y Date and time the row was added.
EXECUTION_SCRIPT_NAME VARCHAR(40) N Name of the cleanup Script. Update script/execution script.
LOCK_IND DOUBLE N Indicates whether the script attached to the execution can be run toghether with another execution script or it has to be run stand alone.
PROCESS_BY_SLICE_IND DOUBLE N Indicates whether we need to process the execution scripts in a batch or single mode.
QUALIFIED_CNT DOUBLE N Number of rows which qualified in the qualification script.
QUAL_BEGIN_DT_TM DATETIME Y Stores the begin date from the input prompt.
QUAL_END_DT_TM DATETIME Y Stores the end date from the input prompt.
QUAL_SCRIPT_NAME VARCHAR(40) N Name of the qualification script which qualifies a list of ids for the cleanup script to clean up.
RCR_UPDATE_REGISTRY_ID DOUBLE N Unique generated number that identifies a single row on the RCR_UPDATE_REGISTRY table.
RECOMMENDED_RANGE_MTHS DOUBLE N Recommended number of months that the update script can be run.
SLC_SIZE_CNT DOUBLE N Indicates the maximum size of the slice.
START_DT_TM DATETIME Y Stores the date and time the execution script was started.
SUMMARY_IND DOUBLE N Indicates whether the summarization is required or not.
UPDATE_REQUEST_IDENT VARCHAR(40) N The CR number to identify the clean up.
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 - RCR_UPDATE_REGISTRY




Parent Column in RCR_UPDATE_REGISTRY (PK) Child Table Name Child Column Name
Children: RCR_UPDATE_REGISTRY_ID RCR_UPDATE_QUAL RCR_UPDATE_REGISTRY_ID


RC_AF_PATIENT_AR_BALANCE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Revenue Cycle Ancillary Fact Patient AR Balance
Definition: This table contains data related to a Patient AR Balance.
Table Type: ACTIVITY





Column Detail - RC_AF_PATIENT_AR_BALANCE


Column Name Type Null? Definition
ACCOUNT_NBR_IDENT VARCHAR(50) N Contains the identifier of a Patient AR Account.
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.
BEG_EFFECTIVE_DT_TM DATETIME N 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.
DUNNING_LEVEL VARCHAR(40) N Obsolete - No longer used on this table. Contains the collections state that a financial encounter is in.
END_EFFECTIVE_DT_TM DATETIME N 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.
FINANCIAL_STATUS VARCHAR(40) N Obsolete - No longer used on this table. Status of the financial encounter.
FINANCIAL_SUB_STATUS VARCHAR(40) N Obsolete - No longer used on this table. Sub status of the financial encounter.
FIN_NBR_IDENT VARCHAR(50) N identifier of a financial number.
FIRST_PROCESS_DT_TM DATETIME N The date/time that the first ETL process started that created this record.
LAST_PROCESS_DT_TM DATETIME N The date/time that the last ETL process started that updated this record.
MRN_NBR_IDENT VARCHAR(50) N Identifier of a medical record number.
RC_AF_PATIENT_AR_BALANCE_ID DOUBLE N Uniquely identifies data related to the RC_F_Patient_AR_Balance table.
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 - RC_AF_PATIENT_AR_BALANCE




Parent Column in RC_AF_PATIENT_AR_BALANCE (PK) Child Table Name Child Column Name
Children: RC_AF_PATIENT_AR_BALANCE_ID RC_F_BALANCE_AR RC_AF_PATIENT_AR_BALANCE_ID
RC_F_CLAIM_EVENT RC_AF_PATIENT_AR_BALANCE_ID
RC_F_DENIAL RC_AF_PATIENT_AR_BALANCE_ID
RC_F_PATIENT_AR_BALANCE RC_AF_PATIENT_AR_BALANCE_ID
RC_F_REVENUE RC_AF_PATIENT_AR_BALANCE_ID
SHR_F_ENCOUNTER_VISIT RC_AF_PATIENT_AR_BALANCE_ID