Articles in this section

See more

DataBridge Views Reference

Avatar
Erin Gough
Updated

All views reside in the DATABRIDGE schema. Every view includes TENANT_ID (the customer environment) and most include ORG_ID/ORG_NAME (the Filevine organization). 

For full column-level detail, query VW_DATABRIDGE_DATA_DICTIONARY_V1.

Version pattern summary: The primary V1→V2 change across nearly all views is the addition of LAST_MODIFIED (UTC timestamp for incremental/CDC processing). Person address, email, and phone views also gained ITEM_POSITION in V2. The Docs view is the only 3-version view (V2 added disabled FOLDER_PATH, V3 enabled it). Project Sections has 4 versions (V2 = internal improvements, V3 = added LAST_MODIFIED, V4 = data/logic refinements).

Client & Tenant Info

ViewDescriptionVersion History
VW_DATABRIDGE_CLIENT_INFODataBridge tenant/share metadata: tenant ID, name, Snowflake account ID, share name, and active share statusV1 only
VW_DATABRIDGE_DATA_DICTIONARYSelf-describing data dictionary with column names and comments for every DataBridge viewV1 only

Users

ViewDescriptionVersion History
VW_DATABRIDGE_USERSFilevine user accounts: ID, name, email, username, and active statusV2 adds LAST_MODIFIED

Projects

ViewDescriptionVersion History
VW_DATABRIDGE_PROJECT_LIST_DATACore project listing with name, type, phase, client, primary user, billing balances (current, overdue aging buckets), and Filevine URLV2 adds LAST_MODIFIED, PHASE_SORT_ORDER
VW_DATABRIDGE_PROJECT_SECTIONS_DATACustom section field values for projects (EAV-style)—includes section name, field name/type, and typed value columns (string, bool, date, int, decimal, variant)V2 no column changes (internal improvements). V3 adds LAST_MODIFIED. V4 same schema as V3 (data/logic refinements).
VW_DATABRIDGE_PROJECT_CONTACTS_DATAContact-to-project associations with their role on the projectV2 adds LAST_MODIFIED
VW_DATABRIDGE_PROJECT_TAGS_DATATags applied to projectsV2 adds LAST_MODIFIED
VW_DATABRIDGE_PROJECT_TEAMS_DATATeam assignments on projects (team name and description)V2 adds LAST_MODIFIED
VW_DATABRIDGE_PROJECT_CALENDARProject calendar events: deadlines, appointments, chain deadlines, custom deadlines with dates, location, and notesV2 adds LAST_MODIFIED

Notes, Tasks & Comments

ViewDescriptionVersion History
VW_DATABRIDGE_NOTES_DATAActivity feed items (notes, tasks, SMS, fax, email, phone call logs) with body, subject, author, assignee, completion status, delivery status, and timestampsV2 adds LAST_MODIFIED
VW_DATABRIDGE_NOTE_TAGS_DATATags applied to notes and tasksV2 adds LAST_MODIFIED
VW_DATABRIDGE_COMMENTS_DATAComments on notes/tasks — body, author, source, destination, delivery statusV2 adds LAST_MODIFIED

Contacts / People

ViewDescriptionVersion History
VW_DATABRIDGE_PERSON_STANDARD_DATAStandard contact info: name, company, job title, birth/death dates, archived/deceased flagsV2 adds LAST_MODIFIED
VW_DATABRIDGE_PERSON_ADDRESSES_DATAPerson mailing addresses (lines, city, state, zip, country)V2 adds LAST_MODIFIED, ITEM_POSITION
VW_DATABRIDGE_PERSON_EMAILS_DATAPerson email addresses with labels and notesV2 adds LAST_MODIFIED, ITEM_POSITION
VW_DATABRIDGE_PERSON_PHONES_DATAPerson phone numbers with SMS/fax capability flagsV2 adds LAST_MODIFIED, ITEM_POSITION
VW_DATABRIDGE_PERSON_CUSTOM_DATACustom contact card fields (EAV-style) with typed value columnsV2 adds LAST_MODIFIED
VW_DATABRIDGE_PERSON_TAGS_DATATags applied to peopleV2 adds LAST_MODIFIED
VW_DATABRIDGE_PERSON_TYPES_DATAPerson type classificationsV2 adds LAST_MODIFIED

Documents

ViewDescriptionVersion History
VW_DATABRIDGE_DOCSDocuments attached to projects/notes: file name, uploader, protected/read-only flags, docable typeV2 adds LAST_MODIFIED and FOLDER_PATH (disabled). V3 enables FOLDER_PATH.
VW_DATABRIDGE_DOC_TAGS_DATATags applied to documentsV1 only

Billing & Invoicing

ViewDescriptionVersion History
VW_DATABRIDGE_BILLING_ITEM_DATALine-item billing data: time entries, expenses, flat fees with rate, quantity, billable/chargeable flags, and draft statusV2 adds LAST_MODIFIED
VW_DATABRIDGE_BILLING_CONTACT_DATABilling contacts on projects and whether they receive billing emailsV2 adds LAST_MODIFIED
VW_DATABRIDGE_BILLING_TRANSACTION_DATAPayment transactions: amount, type, source, void/write-off flags, and invoice linkageV2 adds LAST_MODIFIED
VW_DATABRIDGE_INVOICE_DATAInvoice header data: number, dates, terms, total, outstanding balance, finalized/voided/sent datesV2 adds LAST_MODIFIED

Tags (Global)

ViewDescriptionVersion History
VW_DATABRIDGE_TAGS_DATAMaster tag definitions: name, description, color, archived status. Referenced by project/note/person/doc tag viewsV2 adds LAST_MODIFIED

Audit & Automation

ViewDescriptionVersion History
VW_CLIENT_AUDIT_DATAAudit trail of user and system actions: action type, target, product feature, user info, and JSON contextV1 only
VW_DATABRIDGE_ACTIONBUTTONTASKFLOWTRIGGERHISTORYHistory of action button / taskflow triggers on project sections: which action was triggered, when, and on which field/section.V1 only

Comments

0 comments

Article is closed for comments.

Related articles