Table Detail Report

BE_GL_ALIAS_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Billing Entity General Ledger Alias Relation
Definition: Contains information about the relationship between a Billing Entity and a General Ledger Alias.
Table Type: REFERENCE





Column Detail - BE_GL_ALIAS_RELTN


Column Name Type Null? Definition
ACCT_ID DOUBLE N Uniquely identifies the related account.
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_GL_ALIAS_RELTN_ID DOUBLE N Primary Key
BILLING_ENTITY_ID DOUBLE N FK to the billing_entity table
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.
GL_ALIAS_ID DOUBLE N FK to the gl_alias table
LOCATION_CD DOUBLE N Location code related to the given GL alias.
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_GL_ALIAS_RELTN


Child Column in BE_GL_ALIAS_RELTN(FK) Parent Table Name Parent Column Name
Parents: ACCT_ID ACCOUNT ACCT_ID
BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID
GL_ALIAS_ID GL_ALIAS GL_ALIAS_ID


BE_GROUP_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

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





Column Detail - BE_GROUP_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.
BE_GROUP_RELTN_ID DOUBLE N Billing Entity Group Relation
BILLING_ENTITY_ID DOUBLE N Billing Entity ID
BT_COND_CRIT_R_ID DOUBLE N Bill Template Condition Criteria Relation 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.
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_GROUP_RELTN


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


BE_HARD_CLOSE



Column Section Relationship Section Top of Page


Table-level Detail

Description: Billing Entity Hard Close
Definition: Tracks the Billing Entity's financial close date for a given month and year
Table Type: ACTIVITY





Column Detail - BE_HARD_CLOSE


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.
BE_HARD_CLOSE_ID DOUBLE N Uniquely identifies information about a Billing Entities hard close date by month and year.
BILLING_ENTITY_ID DOUBLE N Uniquely identifies the related billing entity.
HARD_CLOSE_DT_TM DATETIME N Holds the date and time that a billing entity will be hard closed for a given Month and Year
HARD_CLOSE_MONTH DOUBLE N Month that is being closed
HARD_CLOSE_STATUS_CD DOUBLE N Status of the current hard close month.
HARD_CLOSE_YEAR DOUBLE N Year of the Month that is being closed.
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_HARD_CLOSE


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


BE_HISTORY



Column Section Relationship Section Top of Page


Table-level Detail

Description: Stores a copy of the Billing_Entity table to keep a history of changes.
Definition: Billing Entity History
Table Type: REFERENCE





Column Detail - BE_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.
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.
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 User defined description of the billing entity.
BE_HISTORY_ID DOUBLE N Primary Key
BE_NAME VARCHAR(50) Y User defined name
BE_NAME_KEY VARCHAR(250) Y Key field top match BE_Name for indexing
BE_VRSN_NBR DOUBLE N Version Number is used to track changes to the billing entity.
BILLING_ENTITY_ID DOUBLE N Foreign Key to the Billing_Entity table.
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.
CURRENCY_TYPE_CD DOUBLE N Indicates the default currency that is used for this billing entity.
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 that late charges are allowed to accumulate until late charge processing needs to take place.
DEFAULT_SELFPAY_HP_ID DOUBLE N The default self pay health plan id
DEF_POST_METHOD_CD DOUBLE N The default posting method used for this Billing Entity another is not specified.
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
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 Foreign Key to the Organization table.
PARENT_BE_ID DOUBLE N Used to store the hierarchical relationship of the billing entity.
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 N Determines whether or not the billing entity will have procedure coding logic ran when the charges on the claim don't have a revenue code.
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 bill should be generated for the prior month. only be valued if recur_bill_opt_flag = 1. Valid values are between 1-28.
RECUR_GEN_DELAY DOUBLE Y stores the value for the number of days to wait for activity before automatically generating a recurring bill
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. Should 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
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 financial encounter. (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 - BE_HISTORY


Child Column in BE_HISTORY(FK) Parent Table Name Parent Column Name
Parents: BILLING_ENTITY_ID BILLING_ENTITY BILLING_ENTITY_ID
ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID


BE_ORG_RELTN



Column Section Relationship Section Top of Page


Table-level Detail

Description: Billing Entity Organization Relation
Definition: Conatins information on the relationship between a Billing Entity and an Organization.
Table Type: REFERENCE





Column Detail - BE_ORG_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.
BE_ORG_RELTN_ID DOUBLE N Billing Entity Organization 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.
ORGANIZATION_ID DOUBLE N Organization 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_ORG_RELTN


Child Column in BE_ORG_RELTN(FK) Parent Table Name Parent Column Name
Parents: ORGANIZATION_ID ORGANIZATION ORGANIZATION_ID