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 |