Work Orders Tracker

The Work Orders table is the core component of the database, capturing detailed information about each maintenance request. It includes fields such as Property/Unit #, Priority, and Complaint to record the nature and urgency of the request. The table also tracks Status, Scheduled Date, and Man Hours Worked, allowing for comprehensive management of the work order lifecycle. Additionally, financial aspects like Billable Rate, Parts and Materials Cost, and Amount to Bill are documented to manage costs and billing effectively.

The Properties/Units table provides detailed information about each property or unit where work orders may be requested. It includes fields such as Property/Unit #, Property Title, and Address to identify and locate the property. The table also tracks Unit Status, Monthly Rent, and Square Feet, which are important for understanding the characteristics and condition of each unit. This table helps in associating work orders with specific properties and managing property-related details effectively.

Together, these tables ensure that work orders are managed efficiently, with all relevant details about properties and maintenance requests organized in one comprehensive system.