These cookies are required for the website to function properly. They ensure security, enable basic features like page navigation, and store user session data. You cannot disable these cookies.
- EMI Calculator & Tracker
- Data model
The tables behind EMI Calculator & Tracker
EMI Calculator & Tracker ships with 15 tables, grouped here by the feature that uses them. Every record your team works with lives in one of them, and you can add fields and tables in Proto.
- Tables
- 15
- Features
- 6, plus shared settings
- Change it
- Add fields and tables in Proto
How the model is organised
Organization and people
Organizations, Borrowers, team members and Users identify scope and actors.
Application and decision
Loan applications, repayment scenarios and review decisions hold requests and review outcomes.
Provider activity
Loan accounts, Disbursements, repayment schedules and Repayments hold account and movement records.
Evidence and control
Record attachments, application evidence and operation receipts keep supporting and reconciliation records. Exchange rates is a read-only rate reference.
Every table, by feature
- Application intake4
- Credit review4
- Scenario review4
- Loan accounts5
- Repayment movements4
- Evidence and controls5
- Shared and settings2
- Loan applications
Loan applications moving through underwriting, decision and approval.
Linked to Organizations, Team members, Borrowers - Borrowers
Borrowers eligible for loan applications, with contact details and eligibility notes.
Linked to Organizations - Organizations
Banking organizations whose treasury operations are run in this app.
- Team members
Preparers, approvers, auditors and administrators working in the organization.
Linked to Users, Organizations
- Loan applications
Loan applications moving through underwriting, decision and approval.
Linked to Organizations, Team members, Borrowers - Review decisions
Independent approver decisions recorded against a frozen instruction revision.
Linked to Loan applications, Team members - Team members
Preparers, approvers, auditors and administrators working in the organization.
Linked to Users, Organizations - Record attachments
Supporting documents attached to a banking instruction.
Linked to Loan applications, Team members
- Repayment scenarios
Reviewed repayment scenarios prepared against a loan application.
Linked to Loan applications, Organizations - Loan applications
Loan applications moving through underwriting, decision and approval.
Linked to Organizations, Team members, Borrowers - Organizations
Banking organizations whose treasury operations are run in this app.
- Review decisions
Independent approver decisions recorded against a frozen instruction revision.
Linked to Loan applications, Team members
- Loan accounts
Provider-held loan accounts owned by a borrower.
Linked to Borrowers - Disbursements
Debit and credit loan account legs funding a loan application.
Linked to Loan applications, Loan accounts - Borrowers
Borrowers eligible for loan applications, with contact details and eligibility notes.
Linked to Organizations - Loan applications
Loan applications moving through underwriting, decision and approval.
Linked to Organizations, Team members, Borrowers - Repayment schedules
Dated provider position rows recorded against a loan account.
Linked to Loan accounts
- Repayments
Source-identified provider movements matched against loan applications.
Linked to Loan accounts, Loan applications - Loan accounts
Provider-held loan accounts owned by a borrower.
Linked to Borrowers - Loan applications
Loan applications moving through underwriting, decision and approval.
Linked to Organizations, Team members, Borrowers - Repayment schedules
Dated provider position rows recorded against a loan account.
Linked to Loan accounts
- Application evidence
Provider statements, confirmations, settlement notices and corrections attached to a loan application.
Linked to Loan applications - Record attachments
Supporting documents attached to a banking instruction.
Linked to Loan applications, Team members - Operation receipts
Idempotent operation receipts with stable operation keys and actual effect references.
Linked to Loan applications - Loan applications
Loan applications moving through underwriting, decision and approval.
Linked to Organizations, Team members, Borrowers - Review decisions
Independent approver decisions recorded against a frozen instruction revision.
Linked to Loan applications, Team members
Keys and references
The application links to its organization, owner and borrower. A review decision and attachment link back to the application. A repayment movement points to a loan account and its matched application. Provider event and snapshot identities let the team compare imported records with their source. Keep operation keys stable during retries.
Migration order
- Set scope. Load Organizations, Users, team members and Borrowers.
- Bring in requests. Add loan applications with their owners and counterparties.
- Attach review. Add record attachments, review decisions and repayment scenarios.
- Bring in provider records. Add loan accounts, Disbursements, repayment schedules and Repayments.
- Reconcile evidence. Add application evidence and operation receipts after their parent applications exist.
Set up EMI Calculator & Tracker your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.