All views reside in the DATABRIDGE schema. Every view includes TENANT_ID (customer environment) and most include ORG_ID/ORG_NAME (Filevine organization). For full column-level detail, query VW_DATABRIDGE_DATA_DICTIONARY_V1.
Version pattern summary: the primary V1 to V2 change across nearly all views is the addition of LAST_MODIFIED, a UTC timestamp for incremental and CDC processing. Person address, email and phone views also gained ITEM_POSITION in V2. Three views have gone further: Project Sections now has six versions, Docs five, and Notes four.
Client & Tenant Info
View
Description
Version History
VW_DATABRIDGE_CLIENT_INFO
DataBridge tenant and share metadata: tenant ID, name, Snowflake account ID, share name, and active share status
V1 only
VW_DATABRIDGE_DATA_DICTIONARY
Self-describing data dictionary with column names and comments for every DataBridge view
V1 only
Users
View
Description
Version History
VW_DATABRIDGE_USERS
Filevine user accounts: ID, name, email, username, and active status
V2 adds LAST_MODIFIED
Projects
View
Description
Version History
VW_DATABRIDGE_PROJECT_LIST_DATA
Core project listing with name, type, phase, client, primary user, billing balances (current, overdue aging buckets), and Filevine URL
V2 adds LAST_MODIFIED, PHASE_SORT_ORDER
VW_DATABRIDGE_PROJECT_SECTIONS_DATA
Custom section field values for projects (EAV-style). Includes section name, field name/type, and typed value columns (string, bool, date, int, decimal, variants
V3 adds LAST_MODIFIED. V4 has the same columns as V3 (SELECTOR and VALUE_VARIANT value corrections). V5 adds SECTION_SELECTOR, FIELD_INTERNAL_NAME, FIELD_SELECTOR, FIELD_OBJECT. V6 adds COLLECTION_ITEM_CREATED_DATE.
VW_DATABRIDGE_PROJECT_CONTACTS_DATA
Contact-to-project associations with their role on the project
V2 adds LAST_MODIFIED
VW_DATABRIDGE_PROJECT_TAGS_DATA
Tags applied to projects
V2 adds LAST_MODIFIED
VW_DATABRIDGE_PROJECT_TEAMS_DATA
Team assignments on projects (team name and description)
V2 adds LAST_MODIFIED
VW_DATABRIDGE_PROJECT_CALENDAR
Project calendar events: deadlines, appointments, chain deadlines and custom deadlines, with dates, location and notes
V2 adds LAST_MODIFIED
VW_DATABRIDGE_PROJECT_CAN_ACCESS
Which active users can access which projects: one row per user and project pair, with org, project name, user ID and username
Comments on notes and tasks: body, author, source, destination, delivery status
V2 adds LAST_MODIFIED
Contacts / People
View
Description
Version History
VW_DATABRIDGE_PERSON_STANDARD_DATA
Standard contact info: name, company, job title, birth and death dates, archived and deceased flags
V2 adds LAST_MODIFIED
VW_DATABRIDGE_PERSON_ADDRESSES_DATA
Person mailing addresses: lines, city, state, zip, country
V2 adds LAST_MODIFIED, ITEM_POSITION
VW_DATABRIDGE_PERSON_EMAILS_DATA
Person email addresses with labels and notes
V2 adds LAST_MODIFIED, ITEM_POSITION
VW_DATABRIDGE_PERSON_PHONES_DATA
Person phone numbers with SMS and fax capability flags
V2 adds LAST_MODIFIED, ITEM_POSITION
VW_DATABRIDGE_PERSON_CUSTOM_DATA
Custom contact card fields, EAV-style, with typed value columns
V2 adds LAST_MODIFIED
VW_DATABRIDGE_PERSON_TAGS_DATA
Tags applied to people
V2 adds LAST_MODIFIED
VW_DATABRIDGE_PERSON_TYPES_DATA
Person type classifications
V2 adds LAST_MODIFIED
Documents
View
Description
Version History
VW_DATABRIDGE_DOCS
Documents attached to projects and notes: file name, uploader, protected and read-only flags, docable type
V2 adds LAST_MODIFIED and FOLDER_PATH (disabled). V3 enables FOLDER_PATH. V4 adds UPLOAD_DATE. V5 has the same columns as V4 (internal sourcing change, no schema change).
VW_DATABRIDGE_DOC_TAGS_DATA
Tags applied to documents
V1 only
Billing & Invoicing
View
Description
Version History
VW_DATABRIDGE_BILLING_ITEM_DATA
Line-item billing data: time entries, expenses and flat fees with rate, quantity, billable and chargeable flags, and draft status
V2 adds LAST_MODIFIED
VW_DATABRIDGE_BILLING_CONTACT_DATA
Billing contacts on projects and whether they receive billing emails
V2 adds LAST_MODIFIED
VW_DATABRIDGE_BILLING_TRANSACTION_DATA
Payment transactions: amount, type, source, void and write-off flags, and invoice linkage
V2 adds LAST_MODIFIED
VW_DATABRIDGE_INVOICE_DATA
Invoice header data: number, dates, terms, total, outstanding balance, and finalized, voided and sent dates
V2 adds LAST_MODIFIED
Tags (Global)
View
Description
Version History
VW_DATABRIDGE_TAGS_DATA
Master tag definitions: name, description, color, archived status. Referenced by the project, note, person and doc tag views
V2 adds LAST_MODIFIED
Audit & Automation
View
Description
Version History
VW_CLIENT_AUDIT_DATA
Audit trail of user and system actions: action type, target, product feature, user info, and JSON context
V1 only
VW_DATABRIDGE_ACTIONBUTTONTASKFLOWTRIGGERHISTORY
History of action button and taskflow triggers on project sections: which action was triggered, when, and on which field or section
Comments
0 comments
Article is closed for comments.