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.
- Loan Origination System
- Data model
The tables behind Loan Origination System
Loan Origination System 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
- Change it
- Add fields and tables in Proto
How the model is organised
Operating parties
Organizations and team members define the team scope; Borrowers identifies eligible banks, custodians and settlement counterparties.
Banking work
Loan applications holds the instruction, Disbursements its debit and credit account scope, and loan accounts the provider-held account identities.
Decisions
Review decisions records independent decisions on the instruction revision; application decisions follows the related provider-account request.
Evidence and effects
Record attachments and application evidence preserve support and provider events. Operation receipts records claimed effects and review states; Repayments records provider movements.
Account context
Repayment schedules stores dated provider balance snapshots, and exchange rates supplies read-only effective rates.
Every table, by feature
- Organization and access5
- Counterparties and accounts6
- Banking instructions6
- Independent decisions6
- Provider evidence5
- Settlement reconciliation6
- 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 - Users
Users
Linked to Users - Borrowers
Banks, custodians and settlement counterparties eligible for banking instructions.
Linked to Organizations - Loan applications
Typed banking instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Borrowers
- Borrowers
Banks, custodians and settlement counterparties eligible for banking instructions.
Linked to Organizations - Loan accounts
Provider-held financial accounts owned by a counterparty.
Linked to Borrowers - Organizations
Banking organizations whose treasury operations are run in this app.
- Disbursements
Debit and credit account scopes that make an instruction balanced.
Linked to Loan applications, Loan accounts - Loan applications
Typed banking instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Borrowers - Exchange rates
Read-only effective exchange rates for this app.
- Loan applications
Typed banking instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Borrowers - Disbursements
Debit and credit account scopes that make an instruction balanced.
Linked to Loan applications, Loan accounts - Loan accounts
Provider-held financial accounts owned by a counterparty.
Linked to Borrowers - Borrowers
Banks, custodians and settlement counterparties eligible for banking instructions.
Linked to Organizations - Record attachments
Supporting documents attached to a banking instruction.
Linked to Loan applications, Team members - Exchange rates
Read-only effective exchange rates for this app.
- Loan applications
Typed banking instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Borrowers - Review decisions
Independent approver decisions recorded against a frozen instruction revision.
Linked to Loan applications, Team members - Application decisions
Applications to open a provider-authorized account against a banking instruction.
Linked to Loan applications, Organizations - Record attachments
Supporting documents attached to a banking instruction.
Linked to Loan applications, Team members - Team members
Preparers, approvers, auditors and administrators working in the organization.
Linked to Users, Organizations - Application evidence
Provider statements, confirmations, settlement notices and corrections for an instruction.
Linked to Loan applications
- Loan applications
Typed banking instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Borrowers - Operation receipts
Idempotent operation receipts with stable operation keys and actual effect references.
Linked to Loan applications - Application evidence
Provider statements, confirmations, settlement notices and corrections for an instruction.
Linked to Loan applications - Record attachments
Supporting documents attached to a banking instruction.
Linked to Loan applications, Team members - Review decisions
Independent approver decisions recorded against a frozen instruction revision.
Linked to Loan applications, Team members
- Repayments
Source-identified provider movements matched against banking instructions.
Linked to Loan accounts, Loan applications - Repayment schedules
Dated provider balance snapshots for a financial account.
Linked to Loan accounts - Loan accounts
Provider-held financial accounts owned by a counterparty.
Linked to Borrowers - Loan applications
Typed banking instructions moving through authorization, submission and confirmation.
Linked to Organizations, Team members, Borrowers - Application evidence
Provider statements, confirmations, settlement notices and corrections for an instruction.
Linked to Loan applications - Operation receipts
Idempotent operation receipts with stable operation keys and actual effect references.
Linked to Loan applications
Keys and references
Loan applications.record number is the human instruction reference. Its Organization, Owner and Counterparty point to the operating context. Disbursements.Loan and loan account connect account scope to the instruction. Review decisions.Parent and source revision identify the instruction version the reviewer saw. Application evidence.Parent and operation receipts.Parent retain the same case boundary. Provider instruction ID, provider application ID and provider event ID preserve external identities for reconciliation; operation receipts.operation key protects repeated operations. Repayments.matched instruction is the link from a provider movement back to its instruction.
Migration order
- Import Organizations and Users, then link team members to their organization and user identities.
- Import Borrowers and loan accounts, resolving counterparty ownership and external account identifiers.
- Import loan applications and their Disbursements and record attachments, preserving record numbers and revision history.
- Bring in application decisions and review decisions with their parent and source-revision links.
- Import application evidence, Repayments, repayment schedules and operation receipts with provider identifiers and effect references.
- Check exchange rates for the effective dates and currencies used in pilot cases.
Set up Loan Origination System your way.
Start free, then use Proto to change fields, steps and approvals before your team goes live.