The Client Applications table captures the details of applications submitted by tenants for rental properties. It includes information such as the tenant’s social security number, name, client name, and various application statuses like whether the application was sent, the base charge, and whether a credit report was done. This table is crucial for tracking the status and details of each tenant application.
The Clients table maintains information about the property management companies or landlords who are utilizing the tenant screening services. It includes details such as the client’s name, address, and contact information. This table is essential for organizing and accessing information about the clients who are requesting tenant screenings.
The Tenants table holds personal and identification details of the tenants being screened. This includes their social security number, birth date, phone number, and driving license information. This table is key for maintaining accurate records of tenants and facilitating their evaluation during the screening process.
The Addresses table records information related to the tenant’s previous addresses, including move-in and move-out dates, reasons for leaving, and landlord details. This table helps in verifying the tenant’s rental history and ensures that all relevant address information is captured.
The Employers table documents the employment details of tenants, including the name of the employer, contact information, position held, and tenant identification. This table supports the verification of tenant employment history, which is an important aspect of the screening process.
Any support materials, such as spreadsheets and real-life work samples would be very helpful as they would help us better understand your business process.