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 |