Table Detail Report

BT_CONDITION



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bill Template Condition
Definition: Contains Information about the Bill Template Condition
Table Type: REFERENCE





Column Detail - BT_CONDITION


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 N 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 N The person who caused the active_status_cd to be set or change.
AUTO_SUBMIT_CD DOUBLE N The period of time to lapse before auto submit occurs
AUTO_SUBMIT_IND DOUBLE N Indicates whether or not the group of charges identified by this condition should be submitted automatically on a bill
AUTO_SUBMIT_VAL DOUBLE N The amount of time to lapse before auto submit occurs
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.
BILLING_PERIOD_TYPE_CD DOUBLE N Defines how often an insurance benefit order will bill (All, Monthly, Weekly, Daily)
BILL_TYPE_CD DOUBLE N The type of bill for the condition
BT_CONDITION_ID DOUBLE N Uniquely identifies each bill template condition.
BT_CONDITION_TREE_ID DOUBLE N Uniquely identifies the tree of bill template conditions.
BT_COND_LOGIC_IND DOUBLE N Indicates whether a criteria is associated with any relational or logical operator defined in a charge group condition rule.
CONDITION_NAME VARCHAR(200) Y Contains the name of a particular bill template condition.
CONDITION_NAME_KEY VARCHAR(255) Y Contains the name of a particular bill template condition. This column will be in all capitals with special characters and spaces removed.
ENCNTR_TYPE_CLASS_CHRG_GRP_IND DOUBLE N Indicates whether Charge grouping functionality for non-Inpatient encounters needs to be used or not.
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.
FOLLOW_UP_CD DOUBLE N The period of time to lapse before follow up occurs
FOLLOW_UP_IND DOUBLE N Indicates whether or not the group of charges identified by this condition should be followed up on before they are submitted on a bill
FOLLOW_UP_VAL DOUBLE N The amount of time to lapse before follow up occurs
INTERVAL_DAYS DOUBLE N Charges to be groupd based on Number of Interval days
MAN_REVIEW_IND DOUBLE N Indicates whether or not the group of charges identified by this condition should be manually reviewed before being sent out on a bill
PARENT_BT_COND_ID DOUBLE N A unique identifier indicating the parent of a bill template condition.
PHYS_GROUPING_FLAG DOUBLE N Physician grouping option at the bill template condition level. Indicates how to group professional charges 0 - group by performing physician 1 - group all together 2 - group by ordering physician 0 - default to how it is done today 1 - group all professional charges into one professional charge group 2 - group professional charges by ordering physician
PRE_ADMIT_CHRG_DAYS DOUBLE N Number of days prior to the admit date to be grouped separately.
PRE_ADMIT_CHRG_IND DOUBLE N Indicates whether charges prior to admit date time needs to be grouped separately.
PRIORITY_SEQ DOUBLE Y Sequence of related rows
QUALIFYING_DT_TYPE_FLAG DOUBLE N Sotres the values for the different qualifying date types.
REPROCESS_IND DOUBLE N Stores the REPROCESS_IND value - The value is 1 - when user updated charge group manually in bt condition tool(this is used in charge group reprocessing tool), 0(default) if not
SINGLE_CHRG_IND DOUBLE N Indicates whether a charge group can contain only a single charge. A value of "1" indicates the charge group can contain only a single charge. A value of "0" indicates the charge group can contain multiple charges.
SINGLE_CHRG_ROLL_IND DOUBLE N Indicates whether a charge will roll to another when using single charge, charge groups.
STD_DELAY_DAYS DOUBLE N Defines a standard delay period in days for when a bill is to be submitted or transmitted.
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 - BT_CONDITION


Child Column in BT_CONDITION(FK) Parent Table Name Parent Column Name
Parents: PARENT_BT_COND_ID BT_CONDITION BT_CONDITION_ID
BT_CONDITION_TREE_ID BT_CONDITION_TREE BT_CONDITION_TREE_ID




Parent Column in BT_CONDITION (PK) Child Table Name Child Column Name
Children: BT_CONDITION_ID BENEFIT_ORDER BT_CONDITION_ID
BT_CONDITION PARENT_BT_COND_ID
BT_COND_CRIT_GRP_RELTN BT_CONDITION_ID
BT_COND_CRIT_RELTN BT_CONDITION_ID
PFT_CHRG_GRP_RPRCS BT_CONDITION_ID
PFT_CHRG_GRP_RPRCS_HIST BT_CONDITION_ID


BT_CONDITION_TREE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bill Template Condition Tree
Definition: Contains information about the Bill Template Condition Tree
Table Type: REFERENCE





Column Detail - BT_CONDITION_TREE


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 N 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 N The person who caused the active_status_cd to be set or change.
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.
BILL_CLASS_CD DOUBLE N Bill Class Code
BT_CONDITION_TREE_ID DOUBLE N Bill Template Condition Tree ID
BT_COND_TREE_DESC VARCHAR(250) Y Bill Template Condition Tree Description
BT_COND_TREE_NAME VARCHAR(100) Y Bill Template Condition Tree Name
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.
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 - BT_CONDITION_TREE




Parent Column in BT_CONDITION_TREE (PK) Child Table Name Child Column Name
Children: BT_CONDITION_TREE_ID BT_CONDITION BT_CONDITION_TREE_ID


BT_COND_CRIT_GRP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Charge Condition Group Criteria Relationship
Definition: Stores the required information to save or evaluate a rule created in charge group condition tool
Table Type: REFERENCE





Column Detail - BT_COND_CRIT_GRP_RELTN


Column Name Type Null? Definition
ACCT_ID DOUBLE Y Uniquely identifies the related row on the Account Table
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.
ACTIVE_STATUS_CD DOUBLE N 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 N The date and time that the active_status_cd was set.
ACTIVE_STATUS_PRSNL_ID DOUBLE N The person who caused the active_status_cd to be set or change.
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 Y Uniquely identifies the related row on the BILLING_ENTITY table.
BILL_ITEM_ID DOUBLE Y Uniquely identifies a related row on the BILL_ITEM table.
BT_CONDITION_ID DOUBLE N Uniquely Identifies the related row on the BT_CONDITION table.
BT_COND_CRIT_GRP_RELTN_ID DOUBLE N System generated number to uniquely identify a row on the BT_COND_CRIT_GRP_RELTN table.
BT_COND_CRIT_R_ID DOUBLE N Uniquely identifies the related row on the BT_COND_CRIT_R table.
BT_CRITERIA_CAT_ID DOUBLE N Uniquely identifies the related row on the BT_CRITERIA_CATALOG table.
CODE_VALUE DOUBLE Y This is the code value from the given code set that allows multiple values.
COND_VALUE_DT_TM DATETIME Y Contains the date and time value for the respective criteria.
COND_VALUE_IND DOUBLE Y Contains the condition value for indicator sub critieria category.
CRITERIA_GROUP_NBR DOUBLE Y Determines the group of criteria values selected.
CRITERIA_SEQ_NBR DOUBLE N Determines the order of the object within a collection.
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.
HEALTH_PLAN_ID DOUBLE Y Uniquely identifies the related row to the HEALTH_PLAN table.
INTERFACE_FILE_ID DOUBLE Y Uniquely identifies the related row on the interface_file table.
LIMIT_TYPE_CD DOUBLE Y code value for a specific type of limit from code set 21757 (Ex: age, balance etc.)
LIMIT_VAL_TYPE_CD DOUBLE Y code value for a specific value of limit from code set 21758(Ex: Days, Months, Financial Units etc)
LOGICAL_OPERATOR_CD DOUBLE Y Determines the logical operator assigned to a criteria in the rule
LWR_LIMIT_VALUE DOUBLE Y Lower Limit Value of limit value type specified
NOMENCLATURE_ID DOUBLE Y This is the unique primary identifier from the nomenclature table for a corresponding bill code
ORGANIZATION_ID DOUBLE Y Uniquely identifies the related organization on the organization table to which the Billing Entity is related.
ORG_TYPE_CD DOUBLE Y Type of organization from code set 278
PRSNL_ID DOUBLE Y Uniquely identifies the related row on the PRSNL table.
RELATIONAL_OPERATOR_CD DOUBLE N Determines the relation operator assigned to a criteria in the rule.
SOURCE_VOCAB_CD DOUBLE Y Source Vocabulary for a specific patient code from code set 400 (Ex: ICD10)
TEXT_COND_CRIT_CD DOUBLE Y Code value for any free text crieria definition curently used for CDM code value.
TEXT_COND_CRIT_TXT VARCHAR(200) Y Value for any free text criteria definition currently used for CDM code value.
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.
UPR_LIMIT_VALUE DOUBLE Y Upper Limit Value of limit value type specified



Relationship Detail - BT_COND_CRIT_GRP_RELTN


Child Column in BT_COND_CRIT_GRP_RELTN(FK) Parent Table Name Parent Column Name
Parents: ACCT_ID ACCOUNT ACCT_ID
BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID
BILL_ITEM_ID BILL_ITEM BILL_ITEM_ID
BT_CONDITION_ID BT_CONDITION BT_CONDITION_ID
BT_COND_CRIT_R_ID BT_COND_CRIT_RELTN BT_COND_CRIT_R_ID
BT_CRITERIA_CAT_ID BT_CRITERIA_CATALOG BT_CRITERIA_CAT_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
INTERFACE_FILE_ID INTERFACE_FILE INTERFACE_FILE_ID
NOMENCLATURE_ID NOMENCLATURE NOMENCLATURE_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID
PRSNL_ID PRSNL PERSON_ID


BT_COND_CRIT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bill Template Condition Criteria Relation
Definition: Contains information about how a charge group condition is related with al the criteria defined in the charge group condition tool.
Table Type: REFERENCE





Column Detail - BT_COND_CRIT_RELTN


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 N 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 N The person who caused the active_status_cd to be set or change.
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.
BT_CONDITION_ID DOUBLE N This column relates this record to a specific Bill Template Condition record.
BT_COND_CRIT_R_ID DOUBLE N Uniquely identifies a specific relationship between a Bill Template Condition and a Criteria record.
BT_COND_LOGIC_IND DOUBLE N Indicates whether a criteria is associated with any relational or logical operator defined in a charge group condition rule.
BT_CRITERIA_CAT_ID DOUBLE N This column relates this record to a specific Criteria Catalog record.
BT_SUB_CRITERIA_CD DOUBLE Y This is the code value from the given code set 4002352 that allows multiple values for sub criteria value.
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.
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 - BT_COND_CRIT_RELTN


Child Column in BT_COND_CRIT_RELTN(FK) Parent Table Name Parent Column Name
Parents: BT_CONDITION_ID BT_CONDITION BT_CONDITION_ID
BT_CRITERIA_CAT_ID BT_CRITERIA_CATALOG BT_CRITERIA_CAT_ID




Parent Column in BT_COND_CRIT_RELTN (PK) Child Table Name Child Column Name
Children: BT_COND_CRIT_R_ID BT_COND_CRIT_GRP_RELTN BT_COND_CRIT_R_ID
BT_CRITERIA_LIMIT BT_COND_CRIT_R_ID
BT_PRSNL_GRP_RELTN BT_COND_CRIT_R_ID
CODE_VAL_GRP_RELTN BT_COND_CRIT_R_ID
HP_GROUP_RELTN BT_COND_CRIT_R_ID
NOMEN_GROUP_RELTN BT_COND_CRIT_R_ID
ORG_GROUP_RELTN BT_COND_CRIT_R_ID
PFT_BILL_ITEM_COND_CRIT_RELTN BT_COND_CRIT_R_ID
TEXT_COND_CRIT_RELTN BT_COND_CRIT_R_ID


BT_CRITERIA_CATALOG



Column Section Relationship Section Top of Page


Table-level Detail

Description: Bill Template Criteria Catalog
Definition: Bill Template Criteria Catalog
Table Type: REFERENCE





Column Detail - BT_CRITERIA_CATALOG


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 N 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 N The person who caused the active_status_cd to be set or change.
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.
BILL_CLASS_CD DOUBLE N Bill Class Code
BT_CRITERIA_CAT_ID DOUBLE N Bill Template Criteria Catalog ID
CODE_SET DOUBLE Y Code Set
CONTROL_NBR DOUBLE Y Control Number
CRITERIA_DESC VARCHAR(250) Y Criteria Description
CRITERIA_NAME VARCHAR(250) Y Criteria Name
CRITERIA_NAME_KEY VARCHAR(250) Y Criteria Name Key
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.
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 - BT_CRITERIA_CATALOG




Parent Column in BT_CRITERIA_CATALOG (PK) Child Table Name Child Column Name
Children: BT_CRITERIA_CAT_ID BT_COND_CRIT_GRP_RELTN BT_CRITERIA_CAT_ID
BT_COND_CRIT_RELTN BT_CRITERIA_CAT_ID