Store Maintenance and Facilities Management

Start of the Workflow/Process.

Retrieve all entries from the 'Maintenance Requests' data model where status is 'Open' or 'Urgent'.

Retrieve all equipment entries from the 'Assets' data model to check for repair history.

Create a new entry in the 'Work Orders' data model based on the details of a maintenance request.

Create a task assigned to a specific Facilities Manager or Technician to inspect the reported issue.

Create a task for the janitorial staff with a predefined 'Deep Clean' checklist attached.

Update the 'Status' field in the 'Assets' data model to 'Under Repair' once a work order is active.

Sum the 'Parts Cost' and 'Labor Cost' variables to determine the total estimated cost of the repair.

Aggregate all 'Completed' work orders to sum the total 'Cost' property for the current month.

Update the 'Maintenance Score' in the 'Store Location' data model based on recent completion rates.

Send an email to the Store Manager notifying them that a critical facility issue has been logged.

Send an SMS alert to the on-call technician for urgent plumbing or electrical failures.

Create a task for the Store Supervisor to verify that the repair was completed to standard.

Update the status of the 'Work Order' entry to 'Closed' once the inspection task is completed.

Create a new entry in the 'Maintenance Logs' data model to archive the completed work details.

Create a PDF/Summary report aggregating all completed tasks and costs for the monthly management review.

Delete duplicate or erroneously created work order entries from the data model.

End of the Workflow/Process.