Table Detail Report
BILLING_ENTITY_GROUP_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Billing Entity Group Relationship |
Definition: | This table stores the relationship between billing entity and billing entity group. |
Table Type: | REFERENCE |
Column Detail - BILLING_ENTITY_GROUP_RELTN
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_GROUP_ID | DOUBLE | N | Uniquely identifies the related billing entity group. |
BILLING_ENTITY_GROUP_RELTN_ID | DOUBLE | N | Uniquely identifies a relationshipbetweena billing entity and a billing entity group. |
BILLING_ENTITY_ID | DOUBLE | N | Uniquely identifies the related billing entity. |
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. |
ORIG_ID | DOUBLE | N | Represents the primary key of the original for a group of billing entity relationships. |
PARENT_IND | DOUBLE | N | Represents the parent billing entity of a group of billing entities. |
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 - BILLING_ENTITY_GROUP_RELTN
Child Column in BILLING_ENTITY_GROUP_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BILLING_ENTITY_ID | BILLING_ENTITY | BILLING_ENTITY_ID |
BILLING_ENTITY_GROUP_ID | BILLING_ENTITY_GROUP | BILLING_ENTITY_GROUP_ID | |
ORIG_ID | BILLING_ENTITY_GROUP_RELTN | BILLING_ENTITY_GROUP_RELTN_ID |
Parent Column in BILLING_ENTITY_GROUP_RELTN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | BILLING_ENTITY_GROUP_RELTN_ID | BILLING_ENTITY_GROUP_RELTN | ORIG_ID |
BO_GEN_EVENT_LOG
Column Section | Top of Page |
Table-level Detail
Description: | Stores any additional information related to the benefit order generation event. |
Definition: | Benefit Order Generation Event Log |
Table Type: | ACTIVITY |
Column Detail - BO_GEN_EVENT_LOG
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. |
BO_GEN_EVENT_ID | DOUBLE | N | Primary 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. |
LOG_LEVEL_CD | DOUBLE | N | Code value related to the log level for the entry. e.g. audit, error, warning etc. |
LOG_MESSAGE | VARCHAR(250) | Y | Test message logged for an entry. |
PFT_EVENT_OCCUR_LOG_ID | DOUBLE | N | Foreign key to the pft_event_occur_log 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. |
BO_HISTORY
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Store the history of the changes made to the benefit order. |
Definition: | Benefit Order History |
Table Type: | ACTIVITY |
Column Detail - BO_HISTORY
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. |
BENEFIT_ORDER_ID | DOUBLE | N | Foreign key reference to the benefit_order table. |
BO_HISTORY_ID | DOUBLE | N | Primary Key |
BO_STATUS_CD | DOUBLE | N | State of the benefit order at a particular instance of time |
BO_STATUS_REASON_CD | DOUBLE | N | Reason for state of benefit order. |
CONS_BO_SCHED_ID | DOUBLE | N | foreign key to cons_bo_sched table |
CROSS_OVER_IND | DOUBLE | Y | Indicates whether or not health plan is a cooperative plan. |
DISP_NONCOVD_IND | DOUBLE | Y | Indicates whether or not to display non-covered charges on a bill. |
ENCNTR_PLAN_RELTN_ID | DOUBLE | N | Foreign key reference to Encntr_plan_reltn. |
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. |
EPR_UPT_CNT | DOUBLE | Y | Number of times Encounter Plan Relation has been updated. |
FIN_CLASS_CD | DOUBLE | N | Financial class of health plan. |
HEALTH_PLAN_ID | DOUBLE | N | Foreign key reference to health plan table. |
MAN_EDIT_IND | DOUBLE | Y | Indicates whether or not BO has been manually edited. |
ORIG_BILL_DT_TM | DATETIME | Y | Date of the original bill |
ORIG_DUE_DT_TM | DATETIME | Y | Date the original bill was due |
PARENT_BO_ID | DOUBLE | N | Parent benefit order id |
PAT_BILL_PREF_FLAG | DOUBLE | Y | Values: (0) Sequential patient billing, (1) Concurrent patient billing, (2) Don't bill patient, (3) Bill patient only when due |
PAT_CONCURRENT_IND | DOUBLE | Y | Indicates whether the patient is being billed concurrently with claims |
PRIORITY_SEQ | DOUBLE | Y | Priority sequence of health plan in which it is billed. |
PRI_CONCURRENT_IND | DOUBLE | Y | Indicates whether or not health plan allows concurrent billing of secondary plan when this plan is primary. |
SEC_CONCURRENT_IND | DOUBLE | Y | Indicates whether or not health plan allows concurrent billing of other plans when this plan is not primary. |
SUBSCRIBER_ID | DOUBLE | N | Identifies the person who is the subscriber of the health plan. |
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 - BO_HISTORY
Child Column in BO_HISTORY(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | HEALTH_PLAN_ID | HEALTH_PLAN | HEALTH_PLAN_ID |
BO_HP_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | BENEFIT ORDER HEALTH PLAN RELATION |
Definition: | Stores benefit order and health plan relationships for claim generation |
Table Type: | ACTIVITY |
Column Detail - BO_HP_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. |
AMOUNT_OWED | DOUBLE | N | Current amount owed for this health plan |
AMOUNT_OWED_DR_CR_FLAG | DOUBLE | Y | Debit/Credit flag for the Amount Owed |
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. |
BENEFIT_ORDER_ID | DOUBLE | N | Foreign key to the benefit_order table |
BILL_TEMPL_ID | DOUBLE | N | Relates this record to a specific Bill Template. |
BO_HP_RELTN_ID | DOUBLE | N | Primary key to the bo_hp_reltn table |
BO_HP_STATUS_CD | DOUBLE | N | Status of the bo_hp |
ENCNTR_PLAN_RELTN_ID | DOUBLE | N | Identifier of the encounter plan relation |
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. |
FIN_CLASS_CD | DOUBLE | N | Financial class code from the clinical encounter |
HEALTH_PLAN_ID | DOUBLE | N | Foreign key to the health plan table |
LAST_ADJUST_DT_TM | DATETIME | Y | Date of last adjustment received |
LAST_BILLED_DT_TM | DATETIME | Y | Date that the benefit order/health plan was billed |
LAST_PAYMENT_DT_TM | DATETIME | Y | Date of last payment received |
ORIG_BILL_DT_TM | DATETIME | Y | Date that original bill was generated |
ORIG_BILL_SUBMIT_DT_TM | DATETIME | Y | A date / time stamp that will identify the date/time the bill was originally submitted to a third party. |
ORIG_BILL_TRANSMIT_DT_TM | DATETIME | Y | A date / time stamp that will identify the date/time the bill was originally transmitted to a third party. |
PAYOR_ORG_ID | DOUBLE | N | Contains the id from the organization table that represents the payor organization. |
PRIORITY_SEQ | DOUBLE | N | Sequence of related rows |
RELTN_TYPE_CD | DOUBLE | N | Contains the type of relationship between the benefit order and a health plan. |
RESUBMISSION_CNT | DOUBLE | N | Represents the number of times the claim has been resubmitted |
ROLL_DT_TM | DATETIME | Y | Date that the benefit order was rolled |
ROLL_REASON_CD | DOUBLE | N | Rolled reason code (i.e. manual, actual, expected, automated) |
ROLL_REVIEW_IND | DOUBLE | N | This indicator is used to identify whether or not the bo_hp_reltn record is sitting in workflow waiting for review. |
ROLL_TASK_ID | DOUBLE | N | Task identifier of what task rolled the benefit order. This field is populated with the current task that is executing in CCL (reqinfo->updt_task ) when an amount is "rolled" (transferred) from one bo_hp_reltn row to another. |
ROLL_USER_ID | DOUBLE | N | User identifier for who rolled the benefit order |
STMT_STATUS_CD | DOUBLE | N | statement status code (i.e. none, generated, generated with late charges) |
TIMELY_FILE_IND | DOUBLE | N | The column indicates if the BO_HP_RELTN should qualify for claim generation ignoring all holds. |
TOTAL_ADJ_AMOUNT | DOUBLE | N | Total amount of adjustments that have been applied |
TOTAL_ADJ_DR_CR_FLAG | DOUBLE | N | Flag to identify whether the total_adj_amount is a debit or credit |
TOTAL_BILLED_AMOUNT | DOUBLE | N | Total amount that has been billed |
TOTAL_BILLED_DR_CR_FLAG | DOUBLE | N | Flag to identify whether total_billed_amount is a debit or credit |
TOTAL_PAID_AMOUNT | DOUBLE | N | The total amount paid by the payor. |
TOTAL_PAID_DR_CR_FLAG | DOUBLE | N | Flag to identify whether the total_paid_amount is a debit or credit |
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 - BO_HP_RELTN
Child Column in BO_HP_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | BENEFIT_ORDER_ID | BENEFIT_ORDER | BENEFIT_ORDER_ID |
HEALTH_PLAN_ID | HEALTH_PLAN | HEALTH_PLAN_ID |
Parent Column in BO_HP_RELTN (PK) | Child Table Name | Child Column Name | |
---|---|---|---|
Children: | BO_HP_RELTN_ID | EXT_REQ_STATUS | BO_HP_RELTN_ID |
PE_STATUS_REASON | BO_HP_RELTN_ID | ||
PFT_BALANCE | BO_HP_RELTN_ID | ||
PFT_BILL_ACTIVITY | BO_HP_RELTN_ID | ||
PFT_BR_EDIT_FAILURE | BO_HP_RELTN_ID | ||
PFT_CM_EVENT_LOG | BO_HP_RELTN_ID | ||
PFT_DAILY_BALANCE_BAL | BO_HP_RELTN_ID | ||
PFT_DAILY_BO_HP_CHRG_BAL | BO_HP_RELTN_ID | ||
PFT_PRORATION | BO_HP_RELTN_ID | ||
PFT_QUEUE_ITEM | BO_HP_RELTN_ID | ||
PFT_QUEUE_ITEM_HIST | BO_HP_RELTN_ID | ||
PFT_UNIFIED_BILLING_RELTN | INST_BO_HP_RELTN_ID | ||
PFT_UNIFIED_BILLING_RELTN | PROF_BO_HP_RELTN_ID |
CBOS_ACTIVITY_RELTN
Column Section | Relationship Section | Top of Page |
Table-level Detail
Description: | Consolidated Benefit Order Schedule Activity Relationship |
Definition: | Relates activty entity information back to its parent Consolidated Benefit Order Schedule Benefit Order Relation row. |
Table Type: | ACTIVITY |
Column Detail - CBOS_ACTIVITY_RELTN
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. |
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. |
CBOS_ACTIVITY_RELTN_ID | DOUBLE | N | Unique generated number that identifies a single row on the CBOS_ACTIVITY_RELTN table. |
CBOS_PE_RELTN_ID | DOUBLE | N | Relates a Consolidated Benefit Order Schedule record to a Pft Encounter and its respective Statement Cycle and Dunning Level information. |
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. |
PARENT_ENTITY_ID | DOUBLE | N | Key to identify a specific row in a table as set by the Parent_Entity_Name |
PARENT_ENTITY_NAME | VARCHAR(30) | N | Contains the table name for the PARENT_ENTITY_ID key column. |
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 - CBOS_ACTIVITY_RELTN
Child Column in CBOS_ACTIVITY_RELTN(FK) | Parent Table Name | Parent Column Name | |
---|---|---|---|
Parents: | CBOS_PE_RELTN_ID | CBOS_PE_RELTN | CBOS_PE_RELTN_ID |