Springbrook Analytics
The grid below displays the table names and last published date for each of the published data sources. This grid will be updated to reflect new additions or changes to existing data sources.
| DataSource Name | Last Published Date | Table Name |
|---|---|---|
| AP 1099 | 6/24/2021 | ap_1099_print |
| AP Distribution | 11/4/2022 | ap_distribution |
| AP History and GL Journal Entries | 2/6/2023 | department |
| ap_vendor | ||
| ap_history | ||
| gl_history | ||
| gl_journal_entry | ||
| AP Vendor and GL Chart | 11/4/2022 | gl_chart |
| ap_vendor | ||
| AP Vendor and History | 9/13/2023 | department |
| ap_vendor | ||
| ap_history | ||
| po_line_item | ||
| ap_check | ||
| po_history | ||
| po_purchase_order | ||
| ap_check_history | ||
| wf_history | ||
| wf_work_flow | ||
| AP Vendor and History with GL Account 1 | 2/6/2023 | department |
| ap_vendor | ||
| ap_history | ||
| gl_account_1 | ||
| AP Vendor and History with Uniform GL | 3/18/2023 | Custom SQL Query |
| AP Vendor and Purchase Orders | 2/6/2023 | department |
| ap_vendor | ||
| department1 | ||
| ap_history | ||
| po_line_item | ||
| ap_check | ||
| po_history | ||
| po_purchase_order | ||
| AP Vendor with Alerts and Contacts | 11/4/2022 | ap_vendor |
| ap_vendor_contact | ||
| ap_vendor_alert | ||
| AP Vendor with Checks and Business License | 11/4/2022 | ap_vendor |
| ap_check | ||
| lp_master | ||
| AP Vendor with Checks and Contacts | 2/6/2023 | department |
| ap_vendor | ||
| ap_history | ||
| ap_check | ||
| ap_check_history | ||
| ap_vendor_contact | ||
| AP Vendor with History and BR Check | 2/6/2023 | department |
| br_check | ||
| ap_vendor | ||
| ap_history | ||
| ap_check | ||
| ap_check_history | ||
| AP Vendor with History and GL Accounts | 2/6/2023 | department |
| gl_chart | ||
| ap_vendor | ||
| ap_history | ||
| AP Vendor with History and PM Task | 2/6/2023 | department |
| ap_vendor | ||
| ap_history | ||
| pm_task | ||
| AR Account and History | 11/4/2022 | lot |
| customer | ||
| ar_account | ||
| ar_detail | ||
| ar_tran | ||
| ar_comment | ||
| AR Account with Customer and Receipts | 11/4/2022 | customer |
| cr_receipt | ||
| cr_line_item | ||
| cr_receipt_payment | ||
| ar_account | ||
| AR Accounts with Recurring Invoices | 11/4/2022 | ar_account |
| ar_fee | ||
| ar_recurring | ||
| ar_recurring_detail | ||
| ar_recurring_group | ||
| AR Accounts with Transactions | 11/4/2022 | lot |
| customer | ||
| ar_account | ||
| ar_detail | ||
| ar_tran | ||
| AR Accounts with Transactions and associated Cash Receipts | 11/4/2022 | lot |
| customer | ||
| cr_receipt | ||
| cr_line_item | ||
| cr_receipt_payment | ||
| ar_account | ||
| ar_detail | ||
| ar_tran | ||
| AR Transactions | 11/4/2022 | ar_detail |
| ar_tran | ||
| ar_detail1 | ||
| ar_tran1 | ||
| Attachment | 5/18/2022 | attachment |
| Audit Trail | 6/24/2021 | ss_audit_trail |
| Batch | 12/17/2020 | batch_step |
| BP Master and History | 11/4/2022 | lot |
| customer | ||
| bp_detail | ||
| bp_tran | ||
| bp_master | ||
| bp_contractor | ||
| bp_master_approval | ||
| bp_master_comment | ||
| bp_master_fee | ||
| bp_master_step | ||
| bp_master_step_result | ||
| bp_master_to_contractor | ||
| bp_master_valuation | ||
| bp_permit_type | ||
| BP Master with Transactions and associated Cash Receipts | 11/4/2022 | lot |
| customer | ||
| cr_receipt | ||
| bp_detail | ||
| bp_tran | ||
| bp_master | ||
| BP Transactions | 11/4/2022 | bp_detail |
| bp_tran | ||
| bp_detail1 | ||
| bp_tran1 | ||
| BR Check | 6/17/2021 | br_check |
| BR Check with Bank Account and Vendor | 2/6/2023 | br_check |
| ap_vendor | ||
| db_bank_account | ||
| BR Deposit | 12/17/2020 | br_deposit |
| BT Business | 12/17/2020 | lot |
| customer | ||
| customer1 | ||
| bt_master | ||
| bt_fee | ||
| bt_master_to_tax_type | ||
| bt_tax_type | ||
| bt_tax_type_to_fee | ||
| bt_tax_type_to_fee1 | ||
| bt_business_type | ||
| bt_master_fee | ||
| bt_master_schedule | ||
| bt_schedule | ||
| bt_tax_type1 | ||
| BT Business and History | 11/4/2022 | lot |
| customer | ||
| customer1 | ||
| bt_master | ||
| bt_detail | ||
| bt_tran | ||
| bt_detail1 | ||
| bt_tran1 | ||
| BT Business with associated Customer and Receipts | 11/4/2022 | lot |
| customer | ||
| cr_receipt | ||
| cr_line_item | ||
| bt_master | ||
| bt_fee | ||
| bt_master_to_tax_type | ||
| bt_tax_type | ||
| bt_tax_type_to_fee | ||
| bt_tax_type_to_fee1 | ||
| bt_fee_revision | ||
| BT Businesses with Returns and Payments | 11/4/2022 | lot |
| customer | ||
| cr_receipt | ||
| customer1 | ||
| cr_line_item | ||
| cr_receipt_payment | ||
| bt_master | ||
| bt_detail | ||
| bt_tran | ||
| BT Master and Lot with History | 11/4/2022 | lot |
| bt_master | ||
| bt_fee | ||
| bt_master_to_tax_type | ||
| bt_tax_type | ||
| bt_tax_type_to_fee | ||
| bt_detail | ||
| bt_tran | ||
| CH Distribution | 11/4/2022 | ch_distribution |
| CM Issues | 12/17/2020 | lot |
| customer | ||
| customer1 | ||
| cm_issue | ||
| cm_issue_comment | ||
| cm_issue_contact | ||
| cm_issue_detail | ||
| cm_issue_type | ||
| customer2 | ||
| CR Category | 6/17/2021 | cr_category |
| CR Distribution | 11/4/2022 | cr_distribution |
| CR Pay Method and Slip | 11/4/2022 | cr_pay_method |
| cr_pay_method_to_cr_slip | ||
| cr_slip | ||
| CR Receipt | 11/4/2022 | cr_receipt |
| cr_line_item | ||
| cr_receipt_payment | ||
| cr_pay_method | ||
| CR Receipt with Customer and Lot | 2/6/2023 | lot |
| customer | ||
| cr_receipt | ||
| cr_line_item | ||
| cr_receipt_payment | ||
| batch_step | ||
| Customer | 12/17/2020 | customer |
| EB Entry and Details | 2/6/2023 | department |
| gl_chart | ||
| department1 | ||
| eb_activity | ||
| eb_detail | ||
| eb_entry | ||
| EB Header and Activity | 2/6/2023 | department |
| gl_chart | ||
| department1 | ||
| eb_activity | ||
| eb_detail | ||
| eb_entry | ||
| eb_header | ||
| FA Assets and Transactions | 2/6/2023 | department |
| ic_item | ||
| ic_fixed_asset | ||
| ic_transaction | ||
| fa_tran | ||
| FA Items | 2/6/2023 | department |
| ic_item | ||
| ic_fixed_asset | ||
| GL Chart and Budget | 11/4/2022 | gl_chart |
| gl_acct_type | ||
| gl_chart_budget | ||
| GL Chart and History | 11/4/2022 | gl_chart |
| gl_history | ||
| gl_journal_entry | ||
| gl_account_1 | ||
| gl_account_2 | ||
| gl_acct_type | ||
| gl_account_3 | ||
| gl_goto_account | ||
| GL Chart Budget Group | 11/4/2022 | gl_chart |
| gl_budget_group | ||
| gl_master | ||
| GL Chart with History and Uniform GL | 3/18/2023 | Custom SQL Query |
| GL Chart with JE and Vendor History | 2/6/2023 | department |
| gl_chart | ||
| ap_vendor | ||
| ap_history | ||
| gl_history | ||
| gl_journal_entry | ||
| GL Chart with PO and AP Encumbrance Data | 2/6/2023 | department |
| gl_chart | ||
| ap_vendor | ||
| department1 | ||
| ap_history | ||
| gl_history | ||
| gl_journal_entry | ||
| po_line_item | ||
| department2 | ||
| po_line_item_change | ||
| po_requisition | ||
| po_requisition_line_item | ||
| GL History | 11/4/2022 | gl_chart |
| gl_history | ||
| gl_journal_entry | ||
| gl_account_1 | ||
| gl_account_2 | ||
| gl_acct_type | ||
| GL History and Budget History | 2/6/2023 | department |
| gl_history | ||
| gl_bud_hist | ||
| GL History and PM Task | 2/6/2023 | gl_history |
| pm_task | ||
| GL History with Uniform GL | 4/28/2023 | Custom SQL Query |
| GL VRI Report | 6/17/2021 | gl_vri_report |
| gl_vri_set | ||
| gl_vri_set_group | ||
| HR Bulk Emp Ded | 2/6/2023 | department |
| pr_employee | ||
| pr_deduction | ||
| pr_ded_rev | ||
| pr_ded_step | ||
| hr_bulk_emp_ded | ||
| HR Cola | 6/17/2021 | hr_cola_grade |
| hr_cola_step | ||
| HR Employees and PAF | 2/6/2023 | department |
| pr_employee | ||
| department1 | ||
| department2 | ||
| hr_paf_master | ||
| hr_paf_comment | ||
| hr_paf_step | ||
| HR Employees and Type Codes | 2/6/2023 | department |
| pr_employee | ||
| pr_emp_fin_rev | ||
| department1 | ||
| hr_union_unit | ||
| department2 | ||
| pr_emp_position | ||
| hr_paf_master | ||
| hr_career_event | ||
| hr_emp_type_code | ||
| hr_emp_type_code_data | ||
| hr_type | ||
| hr_type_code | ||
| hr_type_field | ||
| hr_type1 | ||
| pr_emp_dependent | ||
| IC Item and GL Account | 11/4/2022 | ic_item |
| ic_transaction | ||
| ic_item_gl_account | ||
| Lot | 6/17/2021 | lot |
| Lot and Customer | 6/17/2021 | lot |
| customer | ||
| Lot with associated UB Account and BT Business | 11/4/2022 | lot |
| ub_master | ||
| bt_master | ||
| LP License with Customer and Lot | 6/17/2021 | lot |
| customer | ||
| lp_master | ||
| lp_businesstype | ||
| lp_master_fee | ||
| lp_master_to_businesstype | ||
| ss_contact | ||
| ss_contact_type | ||
| LP Master and History | 11/4/2022 | lot |
| customer | ||
| lp_master | ||
| lp_detail | ||
| lp_tran | ||
| lp_businesstype | ||
| lp_master_fee | ||
| lp_master_to_businesstype | ||
| lp_master_approval | ||
| lp_master_comment | ||
| LP Master with Transactions and associated Cash Receipts | 11/4/2022 | lot |
| customer | ||
| cr_receipt | ||
| cr_line_item | ||
| cr_receipt_payment | ||
| lp_master | ||
| lp_detail | ||
| lp_tran | ||
| LP Transactions | 11/4/2022 | lp_detail |
| lp_tran | ||
| lp_detail1 | ||
| lp_tran1 | ||
| Organization Settings | 6/17/2021 | db_header |
| PM Project and Task by GL Account with AP and PR History | 2/6/2023 | department |
| ap_history | ||
| gl_history | ||
| batch_step | ||
| pr_distribution | ||
| PM Project and Task with GL History for Vendor | 2/6/2023 | ap_vendor |
| gl_history | ||
| gl_journal_entry | ||
| pm_task | ||
| pm_project | ||
| pm_budget | ||
| pm_task_group | ||
| pm_type | ||
| PM Project and Task with PO and GL History | 11/4/2022 | gl_history |
| po_line_item | ||
| pm_task | ||
| pm_project | ||
| pm_budget | ||
| pm_task_group | ||
| pm_type | ||
| PM Project, Task, and GL History | 11/4/2022 | gl_chart |
| gl_history | ||
| gl_journal_entry | ||
| pm_task | ||
| gl_account_1 | ||
| pm_project | ||
| gl_account_2 | ||
| gl_account_3 | ||
| PM Project, Task, and GL History with Uniform GL | 4/28/2023 | Custom SQL Query |
| PM Task | 11/4/2022 | pm_task |
| PO Purchase Orders with Vendors and GL Chart | 2/6/2023 | department |
| gl_chart | ||
| ap_vendor | ||
| po_line_item | ||
| po_history | ||
| po_purchase_order | ||
| PR Check and Distribution | 4/28/2023 | department |
| pr_employee | ||
| br_check | ||
| pr_check | ||
| pr_history | ||
| pr_history_detail | ||
| pr_distribution | ||
| PR Deduction | 11/4/2022 | pr_deduction |
| PR Distribution and GL Chart | 9/13/2023 | gl_chart |
| batch_step | ||
| pr_distribution | ||
| PR Employee | 9/13/2023 | department |
| pr_employee | ||
| pr_emp_fin_rev | ||
| gl_chart | ||
| pr_emp_ded | ||
| pr_emp_ded_rev | ||
| pr_emp_time_card | ||
| pr_pay_schedule | ||
| pr_emp_dist | ||
| ss_role | ||
| pr_emp_premium | ||
| pr_premium | ||
| pr_premium_level | ||
| pr_emp_fin_rev1 | ||
| pr_emp_flsa_periodic | ||
| PR Employee and Accrual History | 4/28/2023 | department |
| pr_employee | ||
| br_check | ||
| pr_check | ||
| pr_emp_accr_history | ||
| pr_accr_rate | ||
| pr_accrual | ||
| pr_accrual_type | ||
| pr_emp_accr | ||
| PR Employee and Pay History | 4/28/2023 | pr_employee |
| br_check | ||
| pr_check | ||
| pr_history | ||
| PR Employee and Reporting Group | 2/6/2023 | department |
| pr_employee | ||
| pr_emp_reporting_group | ||
| pr_reporting_group | ||
| PR Employee and Timecard with Pay Information | 4/28/2023 | department |
| pr_employee | ||
| pr_emp_fin_rev | ||
| br_check | ||
| pr_check | ||
| pr_history | ||
| pr_emp_time_card | ||
| pr_pay_schedule | ||
| pr_emp_dist | ||
| pr_rate_emp | ||
| PR Employee Max Fin Rev | 9/13/2023 | department |
| pr_employee | ||
| gl_chart | ||
| pr_emp_ded | ||
| pr_emp_ded_rev | ||
| pr_emp_time_card | ||
| pr_pay_schedule | ||
| pr_emp_dist | ||
| ss_role | ||
| pr_emp_premium | ||
| pr_premium | ||
| pr_premium_level | ||
| pr_emp_fin_rev1 | ||
| pr_emp_flsa_periodic | ||
| Custom SQL Query | ||
| PR Employee Position Control and Union Unit | 9/13/2023 | pr_employee |
| pr_emp_fin_rev | ||
| pr_emp_ded | ||
| pr_emp_ded_rev | ||
| pr_emp_reporting_group | ||
| pr_reporting_group | ||
| pr_deduction | ||
| hr_union_unit | ||
| pr_ded_rev | ||
| pr_ded_step | ||
| pr_position_control | ||
| PR Employee with Check and Accrual History | 9/13/2023 | department |
| pr_employee | ||
| pr_emp_fin_rev | ||
| br_check | ||
| pr_check | ||
| pr_history | ||
| pr_pay_schedule_period | ||
| pr_emp_accr_history | ||
| PR Employee with Checks and Deductions | 9/13/2023 | department |
| pr_employee | ||
| pr_emp_fin_rev | ||
| br_check | ||
| pr_check | ||
| pr_history | ||
| pr_emp_ded | ||
| pr_emp_ded_rev | ||
| pr_deduction | ||
| pr_deduction1 | ||
| PR Employee with Checks, Distributions and GL Chart | 9/13/2023 | department |
| pr_employee | ||
| gl_chart | ||
| br_check | ||
| pr_check | ||
| pr_pay_type | ||
| batch_step | ||
| pr_distribution | ||
| PR Employee with Deductions and Reporting Group | 2/6/2023 | department |
| pr_employee | ||
| pr_emp_fin_rev | ||
| pr_emp_ded | ||
| pr_emp_ded_rev | ||
| pr_emp_reporting_group | ||
| pr_reporting_group | ||
| pr_emp_dist | ||
| pr_deduction | ||
| pr_rate_emp | ||
| pr_ded_rev | ||
| pr_ded_step | ||
| PR Employee with Pay and Work Periods | 4/28/2023 | department |
| pr_employee | ||
| br_check | ||
| pr_check | ||
| pr_history | ||
| pr_work_period_inst | ||
| pr_work_period | ||
| PR Employee with Pay History, Pay Type, and Deductions | 4/28/2023 | department |
| pr_employee | ||
| br_check | ||
| pr_check | ||
| pr_history | ||
| pr_emp_ded | ||
| pr_deduction | ||
| pr_pay_type | ||
| PR Employee with Position and History | 2/6/2023 | department |
| pr_employee | ||
| department1 | ||
| pr_history | ||
| pr_position_control | ||
| pr_position | ||
| PR Employee with Rates | 2/6/2023 | department |
| pr_employee | ||
| pr_emp_fin_rev | ||
| pr_rate_emp | ||
| pr_rate_code | ||
| pr_rate_rev | ||
| PR Employee with Reporting Group, Premiums and Pay Types | 2/6/2023 | department |
| pr_employee | ||
| pr_emp_fin_rev | ||
| pr_emp_reporting_group | ||
| pr_reporting_group | ||
| pr_pay_type | ||
| pr_emp_premium | ||
| pr_premium | ||
| pr_premium_level | ||
| pr_premium_to_pay_type | ||
| PR Employee with Timesheet info | 3/18/2023 | department |
| pr_employee | ||
| department1 | ||
| pr_pay_type | ||
| ds_work_history | ||
| ds_work_timesheet | ||
| PR Employee with Timesheets and Supervisor | 3/18/2023 | department |
| pr_employee | ||
| department1 | ||
| pr_pay_type | ||
| ss_role | ||
| pr_pay_schedule_period | ||
| users | ||
| ds_work_history | ||
| ds_work_timesheet | ||
| pr_employee1 | ||
| pr_pay_schedule_timesheet | ||
| PR Employee, HR Application, Union and IC Location | 3/18/2023 | department |
| pr_employee | ||
| pr_emp_fin_rev | ||
| pr_emp_time_card | ||
| pr_pay_schedule | ||
| pr_emp_reporting_group | ||
| pr_reporting_group | ||
| pr_rate_emp | ||
| hr_union_unit | ||
| pr_pay_schedule_period | ||
| pr_emp_position | ||
| hr_applicant | ||
| hr_union_unit_to_accrual | ||
| ic_location | ||
| pr_emp_web_timesheet | ||
| pr_pay_schedule_item | ||
| PR History Calc | 11/4/2022 | pr_history |
| pr_history_calc | ||
| pr_history_calc_detail | ||
| PR OT History | 11/4/2022 | pr_history |
| pr_history_detail | ||
| pr_history_calc | ||
| pr_history_calc_detail | ||
| pr_ot_detail | ||
| PR Pay with Details | 4/28/2023 | br_check |
| pr_check | ||
| pr_history | ||
| pr_history_detail | ||
| pr_history_calc | ||
| pr_work_period_inst | ||
| pr_history_calc_detail | ||
| PR Position Control | 2/6/2023 | department |
| pr_position_control | ||
| pr_position | ||
| PR Tax | 6/28/2021 | pr_tax |
| pr_tax_rate | ||
| pr_tax_revision | ||
| PR W2 Print | 6/17/2021 | pr_w2_print |
| PR Work Comp | 6/17/2021 | pr_work_comp |
| PR Work Periods and History | 4/28/2023 | br_check |
| pr_check | ||
| pr_history | ||
| pr_history_detail | ||
| pr_history_calc | ||
| pr_work_period_inst | ||
| Quick Time Entry and Timesheets | 2/6/2023 | department |
| pr_employee | ||
| department1 | ||
| ds_work_history | ||
| ds_work_timesheet | ||
| SA Master and History | 11/4/2022 | lot |
| customer | ||
| sa_detail | ||
| sa_master | ||
| sa_master_comment | ||
| sa_tran | ||
| SA Master and History with Cash Receipts | 9/13/2023 | lot |
| customer | ||
| cr_receipt | ||
| cr_line_item | ||
| cr_receipt_payment | ||
| sa_detail | ||
| sa_master | ||
| sa_master_comment | ||
| sa_tran | ||
| SS Security | 6/18/2021 | users |
| user_group | ||
| user_group_member | ||
| ss_group_security | ||
| ss_security | ||
| ss_user_security | ||
| TC Original Dollar | 3/18/2023 | lot |
| tc_bill_header | ||
| tc_bill_property_header | ||
| tc_district | ||
| tc_property_class | ||
| tc_sequence | ||
| tc_year_sequence | ||
| UB Account with Billing and Meter History | 9/13/2023 | lot |
| customer | ||
| ub_master | ||
| ub_device | ||
| ub_meter_con | ||
| ub_device_type | ||
| customer1 | ||
| ub_bill_detail | ||
| ub_meter_hist | ||
| ub_bill_detail_tier | ||
| ub_device_hist | ||
| UB Account with Comments | 11/4/2022 | ub_master |
| ub_comments | ||
| UB Account with Lot, Customer, Comments, Financials, and Adj Type | 11/4/2022 | lot |
| customer | ||
| ub_master | ||
| ub_history | ||
| ub_financial | ||
| ub_comments | ||
| ub_adj_type | ||
| UB Account with Lot, Meter, and Class | 11/4/2022 | lot |
| ub_master | ||
| ub_device | ||
| ub_meter_con | ||
| ub_meter_hist | ||
| ub_class | ||
| ub_meter_hist1 | ||
| UB Account with Past Due | 2/6/2023 | lot |
| customer | ||
| ub_master | ||
| ub_device | ||
| ub_meter_con | ||
| ub_device_type | ||
| ub_past_due | ||
| UB Accounts and Winter Averaging | 11/4/2022 | lot |
| customer | ||
| ub_master | ||
| ub_device | ||
| ub_meter_con | ||
| ub_device_type | ||
| ub_winter_average | ||
| UB Accounts with CR Receipts | 11/4/2022 | ub_master |
| cr_receipt | ||
| ub_history | ||
| UB Accounts with Customer, Lot and Meter History | 11/4/2022 | lot |
| customer | ||
| ub_master | ||
| ub_meter_con | ||
| customer1 | ||
| ub_meter_hist | ||
| UB Accounts with History | 11/4/2022 | lot |
| customer | ||
| ub_master | ||
| ub_history | ||
| UB Accounts with History, Services, and Tax | 6/21/2023 | ub_master |
| ub_bill_detail | ||
| ub_history | ||
| ub_service | ||
| ub_service_detail | ||
| ub_service_to_tax | ||
| ub_tax | ||
| UB Accounts with Plans attached | 11/4/2022 | lot |
| customer | ||
| ub_master | ||
| ub_financial | ||
| ub_master_plan | ||
| ub_master_plan_installment | ||
| UB Accounts with Service Rates and Details | 11/4/2022 | lot |
| customer | ||
| ub_master | ||
| customer1 | ||
| ub_history | ||
| ub_service_rate | ||
| ub_service | ||
| ub_service_detail | ||
| UB Backflow | 9/30/2022 | lot |
| customer | ||
| ub_master | ||
| ub_device | ||
| ub_device_type | ||
| ub_backflow_con | ||
| ub_backflow_test | ||
| UB Balance | 6/18/2021 | ub_balance |
| UB Bill Detail | 6/18/2021 | ub_bill_detail |
| UB Bill Detail and Tiers | 6/18/2021 | ub_bill_detail |
| ub_bill_detail_tier | ||
| UB Bill To | 6/18/2021 | ub_bill_to |
| UB Category | 6/18/2021 | ub_category |
| ub_category_member | ||
| UB Co Applicant with CR Receipts | 11/4/2022 | customer |
| ub_master | ||
| cr_receipt | ||
| cr_receipt_payment | ||
| UB Comments | 11/9/2021 | ub_comments |
| UB Container with Accounts, Service Rates, and Customer | 11/4/2022 | lot |
| customer | ||
| ub_master | ||
| ub_service_rate | ||
| ub_container | ||
| UB Devices | 12/17/2020 | ub_device |
| ub_device_type | ||
| UB History | 6/18/2021 | ub_history |
| UB History Customer and CR Receipt | 3/18/2023 | customer |
| cr_receipt | ||
| ub_history | ||
| UB History with Details and Meters | 5/18/2022 | ub_device |
| ub_meter_con | ||
| ub_bill_detail | ||
| ub_meter_hist | ||
| ub_history | ||
| ub_bill_detail_tier | ||
| ub_serv_header | ||
| UB History with Meters | 6/30/2021 | ub_device |
| ub_meter_con | ||
| ub_device_type | ||
| ub_meter_hist | ||
| ub_history | ||
| UB Installment Plan Accounts with CR Receipts | 3/18/2023 | lot |
| customer | ||
| ub_master | ||
| cr_receipt | ||
| cr_line_item | ||
| cr_receipt_payment | ||
| ub_master_plan | ||
| ub_master_plan_installment | ||
| ub_master_plan_installment_payment | ||
| UB Master | 11/4/2022 | ub_master |
| UB Master and Service Rate | 11/4/2022 | ub_master |
| ub_service_rate | ||
| UB Master with Bill Detail and Service Rate | 11/4/2022 | ub_master |
| ub_bill_detail | ||
| ub_service_rate | ||
| UB Master with Financials, Service Rate, and Bill Detail | 9/13/2023 | lot |
| ub_master | ||
| ub_bill_detail | ||
| ub_bill_detail_tier | ||
| ub_service_rate | ||
| ub_financial | ||
| ub_service_rate1 | ||
| UB Master with Lot and Bill Detail | 11/4/2022 | lot |
| ub_master | ||
| ub_bill_detail | ||
| UB Master with Lot and Bill Detail Tiers | 3/18/2023 | lot |
| customer | ||
| ub_master | ||
| customer1 | ||
| ub_bill_detail | ||
| ub_bill_detail_tier | ||
| UB Meter | 6/18/2021 | ub_device |
| ub_meter_con | ||
| ub_device_type | ||
| UB Meter and Bill Detail | 6/28/2021 | ub_device |
| ub_meter_con | ||
| ub_device_type | ||
| ub_bill_detail | ||
| ub_device_type1 | ||
| ub_device1 | ||
| UB Meter and Lot | 6/28/2021 | lot |
| ub_device | ||
| ub_meter_con | ||
| ub_device_type | ||
| UB Meter Detail | 12/17/2020 | Meter Detail |
| UB Meter with Device and History | 6/18/2021 | ub_device |
| ub_meter_con | ||
| ub_device_type | ||
| ub_meter_hist | ||
| UB Meters with Reading History and Accounts | 11/4/2022 | lot |
| customer | ||
| ub_master | ||
| ub_device | ||
| ub_meter_con | ||
| ub_device_type | ||
| ub_meter_hist | ||
| UB Rate Group | 6/18/2021 | ub_rate_group |
| ub_rate_group_member | ||
| UB Service Rates with Cons Levels | 11/4/2022 | ub_service_rate |
| ub_service | ||
| ub_service_detail | ||
| ub_service_cons_lvl | ||
| ub_service_percent_cons_lvl | ||
| UB Service Requests with Accounts and Meters | 11/4/2022 | lot |
| customer | ||
| ub_master | ||
| ub_device | ||
| ub_meter_con | ||
| ub_device_type | ||
| ub_srv_req | ||
| ub_srv_req_dev | ||
| UB Service Requests with Meters | 6/28/2021 | ub_device |
| ub_meter_con | ||
| ub_device_type | ||
| ub_srv_req | ||
| ub_srv_req_dev | ||
| UB Services | 11/4/2022 | ub_service |
| ub_service_detail | ||
| ub_service_cons_lvl | ||
| ub_service_percent_cons_lvl | ||
| UB Statement | 12/17/2020 | UB Statement |
| Users | 6/18/2021 | users |
| Users and Groups | 6/18/2021 | users |
| user_group | ||
| user_group_member | ||
| Users and Reporting Roles | 6/18/2021 | users |
| ss_reporting_role | ||
| ss_reporting_role_table | ||
| WO Equipment Analysis | 6/18/2021 | wo_equipment_analysis |