Table Detail Report

AT_ACCT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Indicates the Account Template that the Account was created from.
Definition: Account Template Account Relation
Table Type: REFERENCE





Column Detail - AT_ACCT_RELTN


Column Name Type Null? Definition
ACCT_ID DOUBLE N Foreign Key to the Account table.
ACCT_TEMPL_ID DOUBLE N Foreign Key to the Acct_Template table.
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.
AT_ACCT_RELTN_ID DOUBLE N Primary Key
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.
CREATED_DT_TM DATETIME Y Date and time the record was created.
CREATED_PRSNL_ID DOUBLE N Unique identifier of the person that created the record.
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 - AT_ACCT_RELTN


Child Column in AT_ACCT_RELTN(FK) Parent Table Name Parent Column Name
Parents: ACCT_ID ACCOUNT ACCT_ID
ACCT_TEMPL_ID ACCT_TEMPLATE ACCT_TEMPL_ID
CREATED_PRSNL_ID PRSNL PERSON_ID


BENEFIT_ORDER



Column Section Relationship Section Top of Page


Table-level Detail

Description: Store the information related to a benefit order.
Definition: Benefit Order
Table Type: ACTIVITY





Column Detail - BENEFIT_ORDER


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.
ALIAS_SEQ DOUBLE Y ** OBSOLETE ** Alias sequence for insurance benefit orders. ** OBSOLETE **
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.
BEG_SERVICE_DT_TM DATETIME Y The service date and time at which the benefit order begins.
BENEFIT_ORDER_ID DOUBLE N System defined unique identifier of a benefit order.
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.
BT_CONDITION_ID DOUBLE N Foreign key to the bt_condition table
COLLECTION_ST_CD DOUBLE N ** OBSOLETE ** CodeSet 25095 Identifies the collection state ** OBSOLETE **
CONS_BO_SCHED_ID DOUBLE N Foreign key reference to the cons_bo_sched table.
CROSS_OVER_IND DOUBLE Y Indicates whether or not health plan is a cooperative plan.
DISP_NONCOVERED_IND DOUBLE Y Indicates whether or not to display non-covered charges on a bill.
DUNNING_HOLD_IND DOUBLE N ** OBSOLETE ** Indicates if this benefit order remains at the same dunning level regardless of the other criteria. ** OBSOLETE **
DUNNING_IND DOUBLE N ** OBSOLETE ** Indicates whether this financial encounter is excluded from dunning messages ** OBSOLETE **
DUNNING_LEVEL_CD DOUBLE N ** OBSOLETE ** Specifies the state of an account ** OBSOLETE **
DUNNING_LEVEL_CHANGE_DT_TM DATETIME Y ** OBSOLETE ** Date the dunning level was changed by the bill record generation process ** OBSOLETE **
DUNNING_LEVEL_CNT DOUBLE Y ** OBSOLETE ** Indicates how many times a bill has been sent at the current dunning level code. ** OBSOLETE **
DUNNING_NO_PAY_CNT DOUBLE Y ** OBSOLETE ** The number of times that no payament has been received at this dunning level. ** OBSOLETE **
DUNNING_PAY_CNT DOUBLE Y ** OBSOLETE ** The number of times that an acceptable payment has been received at this dunning level. ** OBSOLETE **
DUNNING_UNACC_PAY_CNT DOUBLE Y ** OBSOLETE ** The number of times and an unacceptable payment has been received at this dunning level. ** OBSOLETE **
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.
END_SERVICE_DT_TM DATETIME Y Service date and time at which the benefit order ends.
EOP_DT_TM DATETIME Y The End of Period date for the charge group's encounter. Used to quickly determine if a new charge group must be created during charge group creation
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.
MAN_EDIT_IND DOUBLE Y Indicates whether or not BO has been manually edited.
ORIG_BILL_DT_TM DATETIME Y The date and time the bill was originally billed.
ORIG_DUE_DT_TM DATETIME Y The date and time when the bill is originally due.
PARENT_BO_ID DOUBLE N Allows relationships between Benefit Orders - No longer used
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 Indicate whether a patient should be billed at the same time when the bill is sent to the health paln
PFT_ENCNTR_ID DOUBLE N Foreign key to the pft_encntr_id
PREVIOUS_PFT_ENCNTR_ID DOUBLE N Stores the pft_encntr_id that this benefit_order was previously associated to prior to a financial encounter combine.
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.
PRORATION_FLAG DOUBLE Y Shows if this Benefit_order is affected by proration. 0 - No proration has been done, but needs to be. 1 - Proration has been done. 2 - No proration calculations are to be done.
SEC_CONCURRENT_IND DOUBLE Y Indicates whether or not health plan allows concurrent billing of other plans when this plan is not primary.
SELF_PAY_STATUS_CD DOUBLE Y ** OBSOLETE ** Uniquely identifies pay status. ** OBSOLETE **
STATEMENT_CYCLE_ID DOUBLE Y ** OBSOLETE ** Uniquely identifies the related row on the statement_cycle table. ** OBSOLETE **
SUBSCRIBER_ID DOUBLE N Identifies the person who is the subscriber of the health plan.
TOTAL_CHARGE_AMT DOUBLE N The sum of all group charges
TOTAL_CHARGE_AMT_DR_CR_FLAG DOUBLE Y The debit/credit flag for the total_charge_amt field
UB_BILL_CLASS_CD DOUBLE N UB bill class cd - No longer used
UB_BILL_FREQ_CD DOUBLE N Bill Frequency code - No longer used
UB_FACILITY_TYPE_CD DOUBLE N UB Facility Type Code - No longer used
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 - BENEFIT_ORDER


Child Column in BENEFIT_ORDER(FK) Parent Table Name Parent Column Name
Parents: PARENT_BO_ID BENEFIT_ORDER BENEFIT_ORDER_ID
BT_CONDITION_ID BT_CONDITION BT_CONDITION_ID
CONS_BO_SCHED_ID CONS_BO_SCHED CONS_BO_SCHED_ID
HEALTH_PLAN_ID HEALTH_PLAN HEALTH_PLAN_ID
PFT_ENCNTR_ID PFT_ENCNTR PFT_ENCNTR_ID




Parent Column in BENEFIT_ORDER (PK) Child Table Name Child Column Name
Children: BENEFIT_ORDER_ID BENEFIT_ORDER PARENT_BO_ID
BO_HP_RELTN BENEFIT_ORDER_ID
PFT_BILL_SUMMARY BENEFIT_ORDER_ID
PFT_CHARGE_BO_RELTN BENEFIT_ORDER_ID
PFT_CHRG_GRP_RPRCS BENEFIT_ORDER_ID
PFT_CHRG_GRP_RPRCS_HIST BENEFIT_ORDER_ID
PFT_ENCNTR_COLLECTION_RELTN BENEFIT_ORDER_ID


BE_AT_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Billing Entity / Account Template Relation
Definition: This table is used to solve the many to many relationship when it comes to the access rights that abilling entity may have to templates from another billing entity.
Table Type: REFERENCE





Column Detail - BE_AT_RELTN


Column Name Type Null? Definition
ACCESS_CD DOUBLE N Determines what rights the billing entity has in relationship to the account template. (read only, update, no access) - No longer used
ACCT_TEMPL_ID DOUBLE N Identifies the account template in the relationship.
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.
BE_AT_RELTN_ID DOUBLE N Billing Entity Account Template Relation
BILLING_ENTITY_ID DOUBLE N Relates the billing entity to this relationship.
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 - BE_AT_RELTN


Child Column in BE_AT_RELTN(FK) Parent Table Name Parent Column Name
Parents: ACCT_TEMPL_ID ACCT_TEMPLATE ACCT_TEMPL_ID
BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID


BE_CUSTOM_OBJ_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores the default/custom script names needed for printing and interfaces
Definition: be custom obj reltn
Table Type: REFERENCE





Column Detail - BE_CUSTOM_OBJ_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 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.
BE_CUSTOM_OBJ_RELTN_ID DOUBLE N Primary Key
BILLING_ENTITY_ID DOUBLE N Foreign key reference to the Billing Entity table
BILL_TYPE_CD DOUBLE N Bill Type
CUSTOM_IMAGE1 VARCHAR(250) Y Stores the name of a custom image used at a client site
CUSTOM_IMAGE2 VARCHAR(250) Y Stores the name of a custom image used at a client site
CUSTOM_OBJ_NAME VARCHAR(32) Y Name of the object to be executed
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.
MEDIA_TYPE_CD DOUBLE N The code value associated to the bill submission media.
TRANSFORMATION_OBJ_NAME_TXT VARCHAR(30) Y Name of the transformation object program used to transform the data retrieved by the corresponding custom object into a structure or format that is used to generate the final output.
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 - BE_CUSTOM_OBJ_RELTN


Child Column in BE_CUSTOM_OBJ_RELTN(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID


BE_DOMAIN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Billing Entity Domain
Definition: Contains information about the Billing Entity Domain
Table Type: REFERENCE





Column Detail - BE_DOMAIN


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.
BE_DOMAIN_ID DOUBLE N Billing Entity Domain
BILLING_ENTITY_ID DOUBLE N Billing Entity ID
DOMAIN_TYPE_CD DOUBLE N Domain Type
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.
LIFETIME_ENCNTR_IND DOUBLE Y Lifetime Encounter Indicator
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 - BE_DOMAIN


Child Column in BE_DOMAIN(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID




Parent Column in BE_DOMAIN (PK) Child Table Name Child Column Name
Children: BE_DOMAIN_ID ENCNTR_CLASS_GROUP BE_DOMAIN_ID