File
Home
Insert
Page Layout
Formulas
Data
Review
View
DLC-M01-004 · Rev. 2026-Q1
Delphoria Platform Field Map
Matter:
Vendor:
Reference (read-only)
Input (vendor completes)
Formula (calculated)
Fields marked required must be present for the BI dashboard to function.
| A | B | C | D | E | F | G | |
|---|---|---|---|---|---|---|---|
| 1 | Identity & Custody Fields | ||||||
| 2 | Field Name | Type | Source | Required | BI Role | Widget | Notes |
| 3 | DLPUniqueID | String(40) | Collection | Required | Key | — | Primary key across every dashboard join. |
| 4 | MatterCode | String(12) | Collection | Required | Facet | Filter | Global matter filter on executive view. |
| 5 | Custodian | String(80) | Collection | Required | Facet | Filter | Roll-up for volume-by-custodian bar chart. |
| 6 | CustodianCode | String(6) | Collection | Required | Facet | — | Anonymized display when custodian names sensitive. |
| 7 | SourceCode | String(6) | Collection | Required | Facet | Filter | Source-type filter: M365, LAP, MOB, WA, SLK, etc. |
| 8 | CollectionDate | DateTime | Collection | Required | Timeseries | Line | Feeds the "collections over time" trend chart. |
| 9 | ChainOfCustodyURL | URL | Collection | If Any | Ref | Link | Deep-link from BI row to COC PDF. |
| 10 | Volume & Content Fields | ||||||
| 11 | Field Name | Type | Source | Required | BI Role | Widget | Notes |
| 12 | RawSizeGB | Decimal(9,3) | Collection | Required | Metric | KPI | Pre-processing size at time of collection. |
| 13 | ProcessedSizeGB | Decimal(9,3) | Processing | Required | Metric | KPI | Post-culling / de-dup. Feeds cull-ratio widget. |
| 14 | RawItemCount | Int | Collection | Required | Metric | KPI | Documents at collection. |
| 15 | ProcessedDocCount | Int | Processing | Required | Metric | KPI | Documents after dedup / exclusions. |
| 16 | DedupRatio | Decimal(4,2) | Processing | Required | Metric | Gauge | 1 − (ProcessedDocCount / RawItemCount). |
| 17 | ExceptionCount | Int | Processing | Required | Metric | KPI | All items in the exceptions report. |
| 18 | ExceptionRemediableCount | Int | Processing | If Any | Metric | Bar | Feeds remediation-cost estimator. |
| 19 | Review & Analytics Fields | ||||||
| 20 | Field Name | Type | Source | Required | BI Role | Widget | Notes |
| 21 | ReviewToolName | String(40) | Loading | Required | Facet | Filter | Relativity, Reveal, Everlaw, etc. |
| 22 | WorkflowType | Enum | Review | Required | Facet | Filter | Linear / TAR1 / TAR2 / GenAI / Hybrid. |
| 23 | DocsCoded | Int | Review | Required | Metric | Line | Cumulative doc-coding count over time. |
| 24 | RelevantCount | Int | Review | Required | Metric | Bar | By reviewer / by batch. |
| 25 | PrivilegeCount | Int | Review | Required | Metric | Bar | Feeds priv-log projection. |
| 26 | SampleRecallEstimate | Decimal(4,3) | Review | If TAR | Metric | Gauge | Latest sampling round elusion-derived recall. |
| 27 | AnalyticsUsed | JSON | Review | If Any | Facet | Filter | List of analytics families run: clustering, concept, entity, GenAI. |
| 28 | Production & Log Fields | ||||||
| 29 | Field Name | Type | Source | Required | BI Role | Widget | Notes |
| 30 | ProductionSetName | String(60) | Production | Required | Facet | Filter | Prod 001, Prod 002, etc. |
| 31 | BatesRangeStart | String(20) | Production | Required | Metric | — | First Bates in the production set. |
| 32 | BatesRangeEnd | String(20) | Production | Required | Metric | — | Last Bates in the production set. |
| 33 | ProdDate | Date | Production | Required | Timeseries | Line | Feeds production-cadence chart. |
| 34 | ProdVolumeGB | Decimal(9,3) | Production | Required | Metric | KPI | Delivered volume by set. |
| 35 | RedactionCount | Int | Production | If Any | Metric | Bar | Redaction-QC pass rate widget dependency. |
| 36 | PrivLogRows | Int | Priv Log | Required | Metric | KPI | Rows on the log for this production. |
| 37 | ThreadingStrategy | Enum | Priv Log | Required | Facet | — | Inclusive / All / Categorical. |
| 38 | Cost & Vendor Fields | ||||||
| 39 | Field Name | Type | Source | Required | BI Role | Widget | Notes |
| 40 | CollectionVendor | String(80) | Collection | Required | Facet | Filter | Named vendor entity. |
| 41 | HostingVendor | String(80) | Loading | Required | Facet | Filter | Where the review data lives. |
| 42 | MonthlyHostingUSD | Decimal(9,2) | Loading | Required | Metric | Line | Feeds cost-over-time chart. |
| 43 | ProcessingSpendUSD | Decimal(9,2) | Processing | If Invoiced | Metric | Bar | One-time processing cost. |
| 44 | AnalyticsSpendUSD | Decimal(9,2) | Review | If Any | Metric | Bar | Analytics-family spend rollup. |
| 45 | ReviewerHours | Decimal(7,2) | Review | Required | Metric | Line | Total contract-reviewer hours to date. |
| 46 | CostPerDocResp | Decimal(6,2) | Derived | — | Metric | KPI | (All spend) / RelevantCount. Executive KPI. |
| 47 | Defensibility & Metadata Fields | ||||||
| 48 | Field Name | Type | Source | Required | BI Role | Widget | Notes |
| 49 | ProtocolVersion | String(20) | Collection | Required | Ref | — | DLC-M01-002 protocol version applied. |
| 50 | SamplingRoundCount | Int | Review | If TAR | Metric | Bar | Rounds completed to date. |
| 51 | MeetAndConferDate | Date | Case | Recommended | Ref | — | Milestone anchor on timeline. |
| 52 | SunsetDate | Date | Case | Recommended | Ref | — | When hosting can be wound down. |
How this feeds the Delphoria Platform. Vendors export these fields at each EDRM stage. The Delphoria Platform ingests the file (CSV, JSON, or direct API) and joins on DLPUniqueID. The executive dashboard rolls the joined rows into three top-level widgets: Volume by Custodian, Cost per Responsive Document, and Defensibility Timeline. Every filter above becomes a dashboard facet — click a custodian bar, the entire dashboard scopes to that custodian.