Materialised Views
Materialised Views are a powerful feature in Banclo that automatically creates customised data summaries for your loan applications. Think of them as smart reports that gather information from different parts of your loan file and present it in an easy-to-read format.
What Are Materialised Views?
A Materialised View is like having a personal assistant who automatically collects specific information from your loan application and organises it exactly how you need it. Instead of manually checking different sections of the application, the system does this for you and presents the information in a clear, structured format.
For example, a view might automatically gather:
- The applicant's income from employment verification
- Their credit score from credit checks
- The loan amount from the application
- Property value from valuations
This information is then presented together in one convenient location, formatted according to your preferences.
How Do Materialised Views Work?
The Process
Data Collection: When tasks are completed (like employment verification or credit checks), the system automatically identifies which views need updating.
Smart Mapping: Each view has pre-defined rules that tell the system exactly which information to collect and how to present it.
Automatic Updates: Whenever relevant information changes, the view automatically refreshes to show the latest data.
Secure Storage: All view data is encrypted for security and only accessible to authorised users.
Key Benefits
For Loan Officers and Agents
Materialised Views transform your daily workflow by eliminating the need to manually gather information from different screens throughout the system. Instead of clicking through multiple tabs and sections to piece together an applicant's profile, you can see everything relevant in one consolidated view that updates automatically whenever underlying data changes.
This consistency means that regardless of which loan officer handles an application, they'll see the information presented in exactly the same format. You'll always have confidence that you're looking at a complete, up-to-date picture of each loan application, making it easier to make informed decisions quickly.
For Bank Management
From a management perspective, Materialised Views ensure standardisation across your entire organisation. Every team member sees loan information in the same structured format, reducing errors that can occur when different people interpret data differently. This standardisation extends to compliance tracking, as the system maintains a complete audit trail of who has viewed or acted on specific information.
The flexibility to create different views for different roles means you can tailor information presentation to match job responsibilities. Senior officers might see risk metrics and approval recommendations, while loan processors focus on documentation completeness and verification status. This targeted approach improves efficiency while maintaining proper oversight and control.
Types of Information in Views
Materialised Views can display information from several sources throughout your loan processing system. Application data forms the foundation, including personal details of all applicants, their contact information, employment history, and declared income details. This basic applicant information provides the starting point for any comprehensive view.
Verification results add credibility and risk assessment to the picture. Credit scores and credit history give you insight into the applicant's financial reliability, while employment and income verification results confirm the accuracy of declared information. Identity checks ensure you're dealing with legitimate applicants throughout the process.
Property information becomes crucial for mortgage applications, encompassing property valuations, location details, and property type characteristics. This information helps you understand both the collateral value and any location-specific risks that might affect the loan.
Financial calculations from your loan processing system provide valuable insights. The system can pull calculated ratios and metrics that help you make informed lending decisions based on comprehensive financial pictures rather than isolated data points.
Loan details round out the view with practical lending information including loan amounts and terms, proposed interest rates, associated fees and charges, and support for multiple facility types such as primary mortgages combined with finishing or furnishing loans.
Multi-Participant Support
For joint applications with multiple applicants, views can intelligently organise information by person:
This intelligent organisation allows you to see individual information for each person alongside combined totals such as household income and comparative data between applicants. The system automatically groups information by participant roles, making it easy to distinguish between main applicants, co-applicants, and guarantors while still providing the combined view you need for overall assessment.
Multi-Facility Loan Support
For loans with multiple components (mortgage, finishing loan, furnishing loan), views can show:
For loans with multiple components (mortgage, finishing loan, furnishing loan), Views can display individual facility details while also providing combined totals across all facilities, weighted average interest rates, and a clear picture of the overall loan structure. This comprehensive approach means you can understand both the specific terms of each loan component and how they work together as a complete financing package as displayed below
Security and Access Control
Views respect your existing security settings through comprehensive role-based access controls that ensure different job roles see only the views appropriate to their responsibilities. All view data is encrypted when stored, maintaining the same security standards as the rest of your loan data.
Complete audit tracking provides a detailed log of who accessed what information and when, supporting both compliance requirements and internal oversight. The system integrates seamlessly with your existing user permissions, so you don't need to manage separate access controls for views.
Next Steps
To start using Materialised Views, begin by having your system administrator configure views in the Settings section, following the detailed guidance in our setup documentation. Once configured, views will appear as a new tab in your loan applications, giving you immediate access to consolidated information.
Work closely with your system administrator to create views that match your specific workflow and information needs. The flexibility of the system means you can start with basic views and gradually add more sophisticated ones as your team becomes comfortable with the feature.
How Views Are Built: The Three Components
Understanding how Materialised Views are constructed can help you work more effectively with your system administrator when creating or modifying views. Each view consists of three main components that work together:
Mappings: The Data Collector
Think of mappings as instructions for a very organised assistant. They tell the system exactly where to find each piece of information you want to see. For example, a mapping might say "Go to the Employment Verification task and get the Annual Income field, then display it as 'Yearly Salary'."
The mappings are like a shopping list that specifies not just what information you want, but exactly where in the system to find it. They handle the complex work of navigating through different tasks, forms, and data sources to gather everything you need.
JSON Schema: The Structure Planner
The JSON Schema is like a blueprint that describes what information your view will contain and what type each piece should be. It doesn't contain the actual data, but rather describes the "shape" of the information.
For instance, it might specify that your view will have an "Applicant Name" (which should be text), a "Loan Amount" (which should be a number), and an "Application Date" (which should be a date). This helps ensure that the information is properly organised and validated.
UI Schema: The Display Designer
The UI Schema controls how the information appears on your screen. It's like the layout instructions for a newsletter, deciding whether information should be displayed in columns, what size headings to use, which fields should be grouped together, and how everything should be formatted.
This component ensures that the view is not just functional but also easy to read and understand, with proper spacing, grouping, and formatting that makes sense for your workflow.
How They Work Together
When you request a Materialised View, here's what happens:
- Mappings go out and collect the required information from various sources throughout the system
- JSON Schema ensures the collected information is properly structured and valid
- UI Schema formats everything into a clear, readable display that matches your preferences
- The result is presented to you as a comprehensive, well-organized view of all relevant information
This three-part system ensures that views are not just comprehensive and accurate, but also user-friendly and tailored to how you prefer to work with information.
Materialised Views transform how you work with loan data by bringing together all the information you need in one place, automatically updated and always current.