Table · Cases
Cases
Row-level securityThe hub of the app: every loan file from first lead to post-close, with its status, assigned manager and age, so staff always know where each case stands.
- 7 fields · 8 recs
- 1 text
- 2 select
- 1 rich_text
- 1 connection
- 2 equation
Table · Clients
Clients
Row-level securityBorrowers and co-borrowers on each case, with the contact details that drive questionnaire delivery and portal access.
- 6 fields · 7 recs
- 1 name
- 1 email
- 1 phone
- 1 select
- 1 connection
- 1 equation
Table · Questionnaires
Questionnaires
Row-level securityDigital questionnaires sent to each client on a case so borrowers answer online instead of over email, with completion tracked back to the manager.
- 9 fields · 17 recs
- 1 text
- 1 select
- 1 date
- 1 long_text
- 3 connection
- 2 equation
Table · Property Information
Property Information
Row-level securityThe subject property on each case: address, property type, occupancy and purchase price or value, so appraisal, title and closing all work from one record.
- 5 fields · 2 recs
- 1 address
- 1 select
- 1 currency
- 1 radio
- 1 connection
Table · Loan Details
Loan Details
Row-level securityLoan amount, rate, term and key dates for each case, with the interest rate masked from borrowers by row-level security.
- 7 fields · 2 recs
- 1 select
- 1 currency
- 2 number
- 1 date
- 1 connection
- 1 equation
Table · Documents
Documents
Row-level securityEvery requested and uploaded file such as paystubs, W-2s and IDs, classified by AI on upload and tied to both the case and the client who supplied it.
- 6 fields · 2 recs
- 2 select
- 1 files
- 1 rich_text
- 2 connection
Table · Conditions
Conditions
Row-level securityUnderwriting conditions that stand between a file and clear-to-close, each with an owner and due date so nothing slips into closing week.
- 5 fields · 2 recs
- 2 select
- 1 date
- 2 connection
Table · Tasks & Milestones
Tasks & Milestones
Row-level securityMilestones and to-dos on each case, including the trailing-items tasks created automatically the moment a loan closes.
- 5 fields · 2 recs
- 1 text
- 2 select
- 1 date
- 1 connection
Table · Communication Logs
Communication Logs
Row-level securityA running log of every call, email and note exchanged on a case, stamped with the channel and time, so anyone picking up the file can see the full conversation history.
- 5 fields · 1 recs
- 1 select
- 1 text
- 1 rich_text
- 1 date_time
- 1 connection
Table · QC Findings
QC Findings
Row-level securityQuality-control audit findings logged against a case by a reviewer, so compliance issues are tracked to resolution.
- 5 fields · 1 recs
- 2 select
- 1 radio
- 2 connection
Table · Closing/Post-Close
Closing/Post-Close
Row-level securityClosing date, closing status and closing notes for each case, and the record the daily risk sweep checks for loans closing within 7 days that still have open conditions.
- 4 fields · 1 recs
- 1 date
- 1 select
- 1 rich_text
- 1 connection
Table · Client-Case Information
Client-Case Information
Row-level securitySupplementary details and follow-up notes attached to a specific document, such as what was requested, its status and the date it is due back from the borrower.
- 5 fields · 0 recs
- 1 text
- 1 rich_text
- 1 select
- 1 date
- 1 connection
Table · Property Customer Relations
Property Customer Relations
Row-level securityLinks a client to a property with the nature of the relationship, its status and key dates, for cases where a borrower is tied to more than one property or a property to several clients.
- 7 fields · 0 recs
- 2 select
- 2 date
- 1 long_text
- 2 connection
Connects to
- Property Information
- Clients