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