This page outlines the object schema for the Document Insights application when integrated with Ocrolus. The schema is designed to support OCR data extraction from documents such as bank statements, identity verification files, income forms, and more.
🧩 Object Relationship Overview
-
Document Insights is the central object and aggregates all extracted financial and verification data.
-
Only Document Insight Item has a Master-Detail relationship with Document Insights.
-
All other related objects are connected via Lookup relationships.
-
This model is built to support a wide variety of documents: bank statements, income proofs, ID verifications, etc.
🧾 Object Schema
1. Document Insights
|
Field |
Description |
|---|---|
|
Average Revenue |
Average revenue across all uploaded statements. |
|
Average Balance |
Aggregated average balance across bank accounts. |
|
Total Bank Accounts |
Total number of distinct bank accounts identified. |
|
Source Record Link |
Lookup to the source record (Loan, Application, etc.). |
|
Dashboard (LWC) |
Lightning Web Component visualizes insights and summaries. |
Relationships:
Children: Document Insight Item (Master-Detail), all others (Lookup)
2. Document Insight Item
|
Field |
Description |
|---|---|
|
Total Debits |
Cumulative debits for a specific bank account. |
|
Total Credits |
Cumulative credits for a specific bank account. |
Relationship:
Parent: Document Insights (Master-Detail)
One per bank account uploaded.
3. Statement Summary
|
Field |
Description |
|---|---|
|
Total Credits |
Total credits for the given statement month. |
|
Total Debits |
Total debits for the statement month. |
|
Average Balance |
Monthly average balance. |
|
Statement Month & Year |
Month and year of the bank statement. |
Relationship:
Parent: Document Insights (Lookup)
4. Bank Transactions
|
Field |
Description |
|---|---|
|
Transaction Amount |
Amount of the transaction. |
|
Transaction Date |
Date of the transaction. |
|
Bank Account Info |
Associated account for the transaction. |
Relationship:
Parent: Document Insights (Lookup)
One record per bank transaction from uploaded statements.
5. Fraud Signals
|
Field |
Description |
|---|---|
|
Authenticity Score |
Score from 0–100 indicating confidence in document authenticity (higher = more authentic). |
|
Contributing Factors |
Flags such as alignment issues, reconciliation mismatches, calculation errors. |
Relationship:
Lookup to Document Insights
6. Historical Balance
|
Field |
Description |
|---|---|
|
Cash Flow |
Daily inflow and outflow per account. |
|
Ending Balance |
Closing balance for each day. |
|
Statement Date |
Date associated with the record. |
Relationship:
Lookup to Document Insights
One record per day per bank account.
7. Income Insight
|
Field |
Description |
|---|---|
|
Document Type |
Type of income document (e.g., Paystub, SSA-1099, Tax Form). |
|
OCR Status |
Whether OCR was successful or failed. |
|
Document Source |
Source of the income file. |
Relationship:
Lookup to Document Insights
Children: Income Insight Item (Master-Detail or Lookup, depending on implementation)
8. Income Insight Item
|
Field |
Description |
|---|---|
|
Earning Type |
Type of earning (e.g., Gross Pay, Net Pay). |
|
Deduction Type |
Type of deduction (e.g., Tax, Insurance). |
|
Amount |
Corresponding amount. |
Relationship:
Lookup to Income Insight
One record per line item from OCR’d document.
9. Identity Verification
|
Field |
Description |
|---|---|
|
Document Type |
Type of ID document (e.g., Driver’s License, Passport). |
|
Full Name |
Name extracted from the ID document. |
|
Date of Birth |
DOB extracted via OCR. |
|
ID Number |
SSN, License No., etc., depending on document. |
Relationship:
Lookup to Document Insights
📊 Visual Overview
