Table Detail Report

BE_PRSNL_GROUP_R



Column Section Relationship Section Top of Page


Table-level Detail

Description: Billing Entity Personnel Group Relation
Definition: Contains information about the relationship between a Billing Entity and a Personnel Group.
Table Type: REFERENCE





Column Detail - BE_PRSNL_GROUP_R


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_PRSNL_GROUP_R_ID DOUBLE N Billing Entity PersonnelGroup Relation ID
BILLING_ENTITY_ID DOUBLE N Billing Entity ID
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.
PFT_PRSNL_GROUP_ID DOUBLE N ProFit PersonnelGroup ID
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_PRSNL_GROUP_R


Child Column in BE_PRSNL_GROUP_R(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID
PFT_PRSNL_GROUP_ID PFT_PRSNL_GROUP PFT_PRSNL_GROUP_ID


BE_SECURITY_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: This reference table stores security relationships between certain entities
Definition: This reference table stores security relationships between certain entities and billing entities
Table Type: REFERENCE





Column Detail - BE_SECURITY_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_SECURITY_RELTN_ID DOUBLE N Unique Identifier of this table
BILLING_ENTITY_ID DOUBLE N Foreign key to the billing entity table
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 ID of the related entity identified in the parent_entity_name
PARENT_ENTITY_NAME VARCHAR(32) N Name of related entity whos id is identified in the parent_entity_id
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_SECURITY_RELTN


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


BE_SUPPRESS_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: BE SUPPRESS RELTN
Definition: Holds the items that can cause encounters to be suppressed from a statement
Table Type: REFERENCE





Column Detail - BE_SUPPRESS_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_SUPPRESS_RELTN_ID DOUBLE N This is the value of the unique primary identifier of the be suppress reltn id table. It is an internal system assigned number
BILLING_ENTITY_ID DOUBLE N Foreign key to billing_entity table
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_NAME VARCHAR(32) Y Name of the related entity
PARENT_ENTITY_VALUE DOUBLE N This is the value of the related entry (It can be an ID, Code Value, or number) Default -0
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_SUPPRESS_RELTN


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


BILLING_ENTITY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Billing Entity
Definition: A billing entity is any organization in your enterprise that will be generating bills. All billingentities will also be an organization in the organization table. This table also allows us to storethe hierarchy of the enterprise by using the parent_bi
Table Type: REFERENCE





Column Detail - BILLING_ENTITY


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.
ADD_ON_FLY_IND DOUBLE N This column is to indicate whether the fly health plan should be considered or not.
AR_ACCT_ID DOUBLE N The default a/r - general account that transactions will be posted to if there is no match found.
ASSIGN_EXT_FPP_IND DOUBLE Y Indicator to determine whether a billing entity is assigned to an external FPP.
BAD_DEBT_CHECK_IND DOUBLE N This indicator is set if the billing entity wants to use the bad debt balance in the history calculations.
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_DESC VARCHAR(250) Y Allows the user to enter a custom description of the billing entity.
BE_NAME VARCHAR(50) Y Allows for the billing entity to have a different name than the Organization that it is related to.
BE_NAME_KEY VARCHAR(250) Y Key Field for Billing Entity Name, allows for indexing the table
BE_NAME_KEY_A_NLS VARCHAR(1000) Y BE_NAME_KEY_A_NLS column
BE_NAME_KEY_NLS VARCHAR(502) Y Stores the corresponding non-English character set values for the BE_NAME_KEY column.
BILLING_ENTITY_ID DOUBLE N Unique Identifier
BILLING_START_CD DOUBLE N Will not be used - No longer used
BYPASS_RM_BAD_DEBT_IND DOUBLE N Indicator to determine whether registration modifications should be bypassed on financial encounters that are in bad debt.
BYPASS_RM_HISTORICAL_IND DOUBLE N Indicator to determine whether registration modifications should be bypassed on financial encounters that are in history.
CALCULATED_BALANCE_IND DOUBLE N Preference indicator which determines whether to display the calculated balance in TRANSACTION BATCH ENTRY.
CHARGE_DATE_POSTED_FLAG DOUBLE N This flag represents how charges belonging to this billing entity will assign their posted date upon charge posting.
COST_CENTER_CD DOUBLE N Will not be used - No longer used
CURRENCY_TYPE_CD DOUBLE N The Billing Entities default currency.
CURRENT_SEQ_NBR DOUBLE N This field holds the value of the current sequence number that can be used when generating Short Doyles.
DAYS_TO_EVAL DOUBLE N Stores the number of days to evaluate late charges. After this number of days each charge is evaluated charge by charge.
DEFAULT_SELFPAY_HP_ID DOUBLE N The default self pay health plan id
DEF_PAT_TEMPL_ID DOUBLE N Will not be used - No longer used
DEF_POST_METHOD_CD DOUBLE N Sets the default posting method for all accounts owned by this billing entity.
ENCNTR_LIFE_IND DOUBLE N This indicator is set if the Billing Entity requires Encounter history viewing.
ENCNTR_MOD_ON_FAC_TRANSFER_IND DOUBLE N This field stores the preference of the billing entity to whether trigger the encounter modification during facility transfer
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.
FEE_SCHED_FLAG DOUBLE Y Preference defined by billing entity to determine if and what type of fee schedule information is shown in TBE
FISCAL_REPORTING_FLAG DOUBLE N Describes the fiscal reporting structure of the billing entity.
FREQ_DUR_ID DOUBLE N Will not be used - No longer used
GLOBAL_BILLING_IND DOUBLE N Indicates if the benefit_order is global or not.
GL_DATE_ACTIVITY_FLAG DOUBLE N This flag indicates either the room and bed charge service date or activity date to populate in the activity date field of general ledger solution ( 0 = Standard, 1 = GL Activity date of room and bed charges uses service date)
GL_ORIGINAL_FACILITY_FLAG DOUBLE N This field stores the preference of billing entity to perform GL Aliasing and A/R reclasification based on original facility where the service was rendered. 0 - Default - Will not perform GL Aliasing and A/R reclassification based on original facility where the service was rendered rather will alias based on current facility where encounter exists.1 - Facility Transfer, 2 - Moved Charge, 3 - Facility Transfer and Moved Charge
GL_PROCESSING_FLAG DOUBLE N This flag indicates user to decide which date system should qualify for GL alias processing for different charges( 0 = current date, 1 = activity date for the charges)
HCFA_1500_DX_FLAG DOUBLE Y Stores the HCFA 1500 creation/diagnosis preference for the billing entity
ORGANIZATION_ID DOUBLE N Identifies the Organization from the Organization Table that the Billing Entity is a part of.
PARENT_BE_ID DOUBLE N Used to store the hierarchical parent.
PLACE_OF_SERVICE VARCHAR(2) Y Place of Service code
POST_CD DOUBLE N Determines whether the 835 batch posts automatically and which general A/R account is used when there is no match .
PROC_CODE_IND DOUBLE Y This is a preference indicator determining if a charge going through a particular billing entity will be processed by the procedure coding logic.
PRODUCE_BILL_CD DOUBLE N Will not be used - No longer used
PROGRAM_CD DOUBLE N This field holds the value of the program code for the given billing entity.
PROVIDER_OF_RECORD_FLAG DOUBLE N Holds preference of who the physician of record is for the billing entity.
QCF_ROUNDING_FLAG DOUBLE N This column stores the rounding option for the QCF calculation.
RECLASS_RECEIVE_IND DOUBLE N The purpose of this field is to store the value whether or not the billing entity allows for the reclassification of the A/R.
RECUR_BILL_OPT_FLAG DOUBLE Y stores the recurring billing preference for the Billing Entity
RECUR_BILL_WHAT_DAY DOUBLE Y stores the value for the day of the month that recurring encounter bills should be generated for the prior month.
RECUR_GEN_DELAY DOUBLE Y stores the value for the number of days to wait for activity before automatically generating a recurring bill. Only be valued if recur_gen_delay_ind = 1.
RECUR_GEN_DELAY_IND DOUBLE Y stores the preference for if a recurring bill should be generated automatically after a certain number of days without activity on the clinical recurring encounter. Only be valued if recur_bill_opt_flag = 1.
RECUR_WAIT_CODE_FLAG DOUBLE Y stores the preference for using the wait for coding hold for recurring billing. Should only be valued if recur_bill_opt_flag = 1.
RUG_CD_ORDER_FLAG DOUBLE Y stores the skilled nursing billing preference for placement of RUG codes in the line item section of the HCFA 1450.
SEQ_START_NBR DOUBLE N This field holds the value of the starting sequence number for a given billing entity.
SKIP_REBILL_FLAG DOUBLE N Preference to skip rebilling when there is health plan change performed and the health plan belongs to the same payer. 0 - Don't skip rebill,.1 - Skip rebill primary only. 2 - Skip rebill non-primary only. 3 - Skip rebill for both primary and non-primary.
STD_DELAY DOUBLE Y Standard Delay
STMT_BILLING_LEVEL_CD DOUBLE Y ** OBSOLETE ** This column is no longer used. This field indicates the level at which statements are billed for the billing entity. (Ex. Encounter, Balance) **OBSOLETE**
SUPPRESS_OFFSET_DRCR_IND DOUBLE N Preference defined by billing entity to determine if the offsetting debits and credits are displayed in TBE.
TRANS_DISTRIB_METHOD_CD DOUBLE N Holds preference of how transactions will be distributed per billing entity beyond default posting logic.
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.
ZERO_BALANCE_WAIT DOUBLE N This field will store the period to wait for moving encounters to history.



Relationship Detail - BILLING_ENTITY


Child Column in BILLING_ENTITY(FK) Parent Table Name Parent Column Name
Parents: AR_ACCT_ID ACCOUNT ACCT_ID
DEFAULT_SELFPAY_HP_ID HEALTH_PLAN HEALTH_PLAN_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID




Parent Column in BILLING_ENTITY (PK) Child Table Name Child Column Name
Children: BILLING_ENTITY_ID ACCOUNT BILLING_ENTITY_ID
BATCH_TRANS BILLING_ENTITY_ID
BATCH_TRANS_RELTN BILLING_ENTITY_ID
BE_AT_RELTN BILLING_ENTITY_ID
BE_CUSTOM_OBJ_RELTN BILLING_ENTITY_ID
BE_DOMAIN BILLING_ENTITY_ID
BE_GL_ALIAS_RELTN BILLING_ENTITY_ID
BE_GROUP_RELTN BILLING_ENTITY_ID
BE_HARD_CLOSE BILLING_ENTITY_ID
BE_HISTORY BILLING_ENTITY_ID
BE_PRSNL_GROUP_R BILLING_ENTITY_ID
BE_SECURITY_RELTN BILLING_ENTITY_ID
BE_SUPPRESS_RELTN BILLING_ENTITY_ID
BILLING_ENTITY_GROUP_RELTN BILLING_ENTITY_ID
BILL_REC BILLING_ENTITY_ID
BT_COND_CRIT_GRP_RELTN BILLING_ENTITY_ID
CHRG_GRP_EXCEPTION BILLING_ENTITY_ID
COLLECTION_LETTER BILLING_ENTITY_ID
CONTACT_TEXT BILLING_ENTITY_ID
DAILY_ACCT_BAL BILLING_ENTITY_ID
DELIVERY_SYSTEM BILLING_ENTITY_ID
GL_TRANS_LOG BILLING_ENTITY_ID
GL_TRANS_QUALIFIER BILLING_ENTITY_ID
INTERFACE_FILE BILLING_ENTITY_ID
PFT_ACCT_NUMBER BILLING_ENTITY_ID
PFT_AP_OPTIONS BILLING_ENTITY_ID
PFT_AR_CONV_INFO BILLING_ENTITY_ID
PFT_BALANCE BILLING_ENTITY_ID
PFT_BE_CNVT_RATE_RELTN BILLING_ENTITY_ID
PFT_CHARGE BILLING_ENTITY_ID
PFT_COLLECTION_AGENCY BILLING_ENTITY_ID
PFT_COMPARE BILLING_ENTITY_ID
PFT_DAILY_BALANCE_BAL BILLING_ENTITY_ID
PFT_DAILY_BILL_BAL BILLING_ENTITY_ID
PFT_DAILY_BO_HP_BAL BILLING_ENTITY_ID
PFT_ENCNTR BILLING_ENTITY_ID
PFT_ENCNTR_CENSUS_SUMMARY BILLING_ENTITY_ID
PFT_ENCNTR_FACT BILLING_ENTITY_ID
PFT_EXPCT_ACTUAL_DEF BILLING_ENTITY_ID
PFT_FISCAL_PERIOD BILLING_ENTITY_ID
PFT_HOLD BILLING_ENTITY_ID
PFT_HP_MEDIA_RELTN BILLING_ENTITY_ID
PFT_PAYMENT_PLAN BILLING_ENTITY_ID
PFT_PAY_PLAN_HIST BILLING_ENTITY_ID
PFT_QUEUE_ITEM BILLING_ENTITY_ID
PFT_QUEUE_ITEM_HIST BILLING_ENTITY_ID
PFT_QUEUE_ITEM_WF_HIST BILLING_ENTITY_ID
PFT_REVENUE_SUMMARY BILLING_ENTITY_ID
PFT_RVU_CONTENT BILLING_ENTITY_ID
PFT_TRANS_DIST_CONFIG BILLING_ENTITY_ID
PROCEDURE_CODE_TIER BILLING_ENTITY_ID
RCR_RVU_MODIFIER_FORMULA BILLING_ENTITY_ID
RCR_TRANS_DIST BILLING_ENTITY_ID
STATEMENT_CYCLE BILLING_ENTITY_ID
TPM_RULE_TIER BILLING_ENTITY_ID


BILLING_ENTITY_GROUP



Column Section Relationship Section Top of Page


Table-level Detail

Description: Billing Entity Group
Definition: This reference table stores the billing entity groups.
Table Type: REFERENCE





Column Detail - BILLING_ENTITY_GROUP


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 a billing entity group
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.
GROUP_NAME VARCHAR(250) N Name of the billing entity group
ORIG_BILLING_ENTITY_GROUP_ID DOUBLE N Represents the primary key of the original row for the given billing entity group.
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


Child Column in BILLING_ENTITY_GROUP(FK) Parent Table Name Parent Column Name
Parents: ORIG_BILLING_ENTITY_GROUP_ID BILLING_ENTITY_GROUP BILLING_ENTITY_GROUP_ID




Parent Column in BILLING_ENTITY_GROUP (PK) Child Table Name Child Column Name
Children: BILLING_ENTITY_GROUP_ID BILLING_ENTITY_GROUP ORIG_BILLING_ENTITY_GROUP_ID
BILLING_ENTITY_GROUP_RELTN BILLING_ENTITY_GROUP_ID
CONS_BO_SCHED BILLING_ENTITY_GROUP_ID
PFT_PAYMENT_PLAN BILLING_ENTITY_GROUP_ID