This glossary maps legacy BigTime table names to their new, cleaned-up versions in Data Hub. Use it to assist with cross-referencing during migration or while building queries.
| Old Table Name | New Table Name | Description | Source System |
|---|---|---|---|
| stblsettings_vocabulary | firm_lexicon | Stores custom lexicon configured within your BigTime firm | BigTime |
| tblactivity | activity | Stores the list of activities around the BigTime site | BigTime |
| tblbudget_allocation | budget_allocation | Stores budget allocation data | BigTime |
| tblbudget_estimate | budget_estimate | Stores estimated budget amounts | BigTime |
| tblclient | client | Stores the list of clients added within BigTime | BigTime |
| tblclient_contact | client_contact | Stores contact information for each client | BigTime |
| tblesignature | esignature | Stores the list of signatures for DCAA timesheet verifications | BigTime |
| tblexchangerate_custom | exchange_rate_custom | Stores firm-specific exchange rates, allowing for the definition of custom currency conversion rates | BigTime |
| tblexpense | expense | Stores the list of expenses | BigTime |
| tblexpense_fx | expense_fx | Stores the list of expenses using multi-currency values | BigTime |
| tblexpense_reject | expense_reject | Stores rejected expense submissions | BigTime |
| tblexpense_rpt | expense_report | Stores the list of expense reports | BigTime |
| tblexpense_udf | expense_udf | Stores the list of custom fields configured for expenses | BigTime |
| tblfirm_currency | firm_currency | Maps available currencies to specific firms, defines which currencies a firm can use, identifies the default (baseline) currency for each firm, and tracks the active or inactive status of each currency per firm | BigTime |
| tblinvoice_line | invoice_line | Stores line-item details for invoices created | BigTime |
| tblinvoice_project | invoice_project | Maps invoices to their associated projects | BigTime |
| tblmodelschema | model_schema | Stores configuration settings for UI layout and behavior across different parts of BigTime | BigTime |
| tblnotice_custom | notice_custom | Stores the list of custom notifications setup | BigTime |
| tblother | other | Stores contact information for non-primary recipients of invoices | BigTime |
| tblpayments | payment | Stores individual firm payment records, including total amounts | BigTime |
| tblpayments_transaction | payment_transaction | Stores the distribution of a single payment across associated invoices | BigTime |
| tblpayroll_request | payroll_request | Stores available payroll request data | BigTime |
| tblproject | project | Stores the list of projects | BigTime |
| tblproject_autopay | project_autopay | Stores auto-payment settings for projects | BigTime |
| tblproject_budgetcat | project_budget_category | Maps labor codes (budget categories) to projects | BigTime |
| tblproject_contactadd | project_contact_additional | Maps projects and additional contacts beyond the primary and billing contacts | BigTime |
| tblproject_expensecode | project_expense_code | Maps expense codes to projects and defines which codes are allowed for use on each project | BigTime |
| tblproject_fields | project_fields | Stores core project information shared across all instances of BigTime | BigTime |
| tblproject_ratecustom | project_rate_custom | Stores custom billing rates defined at the project level | BigTime |
| tblproject_ratecustom_cost | project_rate_custom_cost | Stores custom cost rates defined at the project level | BigTime |
| tblproject_ratecustom_expense | project_rate_custom_expense | Stores custom expense rates and pricing defined at the project level | BigTime |
| tblproject_task | project_task | Stores the list of tasks associated with a project | BigTime |
| tblproject_task_allocations | project_task_allocations | Stores data on how resources are allocated to specific project tasks | BigTime |
| tblproject_task_baseline | project_task_baseline | Stores baseline task data to measure project progress and historical comparisons from the initial plan | BigTime |
| tblproject_task_series | project_task_series | Stores recurring task series within a project | BigTime |
| tblproject_team | project_team | Stores information on project team composition, including each member's role | BigTime |
| tblproject_udf | project_udf | Stores custom user-defined fields associated with projects | BigTime |
| tblprojecttask_udf | project_task_udf | Stores custom user-defined fields associated with tasks | BigTime |
| tblratecard | rate_card | Stores billing rate cards that can be applied to projects | BigTime |
| tblratecardrates | rate_card_rates | Stores individual entries within rate cards, specifying billing rates based on combinations of staff, categories, and groups. Each entry defines a unique rate configuration applicable to project billing | BigTime |
| tblskill | skill | Stores the list of skills | BigTime |
| tblskill_role | skill_role | Maps skills to roles by creating associations between defined skill sets and staff roles within BigTime | BigTime |
| tblstaff | staff | Stores core staff information, including key employee data | BigTime |
| tblstaff_accrual | staff_accrual | Stores staff leave/time-off accruals by tracking accrual rates, rollover balances, and total accumulated time for various leave types | BigTime |
| tblstaff_contract | staff_contract | Stores staff contract details, including work schedules, daily capacity, contract duration, and associated cost rates | BigTime |
| tblstaff_history | staff_history | Stores historical changes to staff records, maintaining an audit trail of modifications to staff data | BigTime |
| tblstaff_hr | staff_hr | Stores HR-related staff data such as hire dates, compensation history, and other personnel records | BigTime |
| tblstaff_org | staff_org | Maps each staff member to their assigned department | BigTime |
| tblstaff_pref | staff_preferences | Stores staff configuration settings | BigTime |
| tblstaff_settings | staff_settings | Stores global staff configuration settings and defaults used across BigTime | BigTime |
| tblstaff_skill | staff_skill | Maps staff members to their associated skills | BigTime |
| tblstaff_skill_certification | staff_skill_certification | Stores certifications held by staff members | BigTime |
| tblstaff_teammember | staff_team_member | Stores staff team assignments and team roles | BigTime |
| tblstaff_udf | staff_udf | Stores custom user-defined fields associated with staff records | BigTime |
| tbltaxreturn | tax_return | Stores information related to individual tax returns | BigTime |
| tbltaxreturn_preparers | tax_return_preparers | Stores tax return preparers and their assignments | BigTime |
| tbltaxreturn_statuslinks | tax_return_status_links | Maps tax return status values between systems | BigTime |
| tbltaxreturn_statuslist | tax_return_status_list | Stores the master list of tax return statuses | BigTime |
| tbltime | time | Stores time entries that have been submitted | BigTime |
| tbltime_auditlog | time_audit_log | Stores historical changes to time entries, maintaining an audit trail of modifications and actions performed on time entries | BigTime |
| tbltime_deleted | time_deleted | Stores an archive for deleted time entries | BigTime |
| tbltime_in | time_in | Stores time entries that have been saved but not yet submitted | BigTime |
| tbltime_reject | time_reject | Stores information about time entries that have been rejected | BigTime |
| tbltime_vendorbill | time_vendor_bill | Stores vendor bills linked to time entries | BigTime |
| tbltimer | legacy_timer | Stores time entry data from timers (legacy) | BigTime |
| tbltimer_udf | timer_udf | Stores values for custom user-defined fields associated with timers | BigTime |
| tbltimesheet_udf | timesheet_udf | Stores values for custom user-defined fields associated with timesheets | BigTime |
| tblvendor | vendor | Stores vendor and supplier information within BigTime | BigTime |
| tblwallet_transaction | wallet_transaction | Stores payment transactions processed through the BigTime Wallet | BigTime |
| tblzapiersubscription | zapier_subscription | Stores Zapier integration webhooks and subscription data | BigTime |
| timer | timer | Stores time entry data from timers | BigTime |
| timerproperty | timer_property | Stores custom properties and user-defined fields associated with timer entries | BigTime |
| timerrun | timer_run | Stores individual timer run sessions | BigTime |
| tlkpaccrual | accrual | Stores leave and time-off types along with their associated accrual rules | BigTime |
| tlkpccard | credit_card | Stores the list of credit cards | BigTime |
| tlkpccard_assign | credit_card_assign | Stores the list of credit card assignments | BigTime |
| tlkpexpense_catudf | expense_category_udf | Stores custom fields tied to expense categories | BigTime |
| tlkpholiday | firm_holidays | Stores company holiday dates and details | BigTime |
| tlkpinvoice_customrate | invoice_custom_rate | Stores custom billing rates used for invoicing purposes | BigTime |
| tlkpinvoice_emaillist | invoice_email_list | Stores invoice email distribution rules based on account roles | BigTime |
| tlkpinvoice_linetype | invoice_line_type | Stores the various types of line items that can appear on an invoice | BigTime |
| tlkpinvoice_type | invoice_type | Stores definitions and attributes for various invoice types | BigTime |
| tlkpinvoice_typedetails | invoice_type_details | Stores supplementary configuration settings for each invoice type | BigTime |
| tlkpmodelpropertylist | model_property_list | Stores metadata about fields and properties across various model schemas within BigTime | BigTime |
| tlkppayroll_codes | payroll_codes | Stores definitions of payroll codes | BigTime |
| tlkppayroll_codesettings | payroll_code_settings | Stores additional configuration settings related to payroll codes | BigTime |
| tlkppayroll_codesqb | payroll_codes_qb | Maps BigTime payroll codes to QuickBooks items | BigTime |
| tlkpperiod_allocation | period_allocation | Stores time periods for resource and budget allocation | BigTime |
| tlkpproject_fields | project_fields_def | Stores the available fields for a project, such as retainer, deposit, budget cap, and milestone payments | BigTime |
| tlkpproject_tpl | project_template | Stores templates used for creating standardized projects | BigTime |
| tlkpprojecttasktype_udflist | project_task_type_udf_list | Maps user-defined fields (UDFs) to specific project task types | BigTime |
| tlkptime_notekeys | time_note_keys | Stores predefined text snippets and templates for use in time entry notes | BigTime |
| tlkptime_sidlist | time_sid_list | Maps system identifiers (SIDs) to their corresponding names and types within time tracking | BigTime |
| tlkptswk | timesheet_week | Stores how time entries are displayed, formatted, and managed within BigTime | BigTIme |
| _data_hub_assignment_daily_data | _data_hub_assignment_daily_data | Stores the list of daily assignment data | Foresight |
| _data_hub_assignment_timeentries | _data_hub_assignment_timeentries | Stores the list of time entries tied to assignments | Foresight |
| _data_hub_assignments | _data_hub_assignments | Stores the list of assignments | Foresight |
| _data_hub_demand_daily_data | _data_hub_demand_daily_data | Stores the list of daily demand data | Foresight |
| _data_hub_demand_skills | _data_hub_demand_skills | Stores the list of skills tied to demands | Foresight |
| _data_hub_demands | _data_hub_demands | Stores the list of demands | Foresight |
| _data_hub_experience_skills | _data_hub_experience_skills | Stores the list of skills tied to staff experiences | Foresight |
| _data_hub_experiences | _data_hub_experiences | Stores the list of staff experiences | Foresight |
| _data_hub_seniorities | _data_hub_seniorities | Stores the list of seniorities | Foresight |
| _data_hub_skills | _data_hub_skills | Stores the list of skills | Foresight |