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 |