Subcontractor Compliance and Insurance Tracking

Rozpoczęcie przepływu pracy/procesu.

Retrieve the initial data entry containing the subcontractor's basic company information and contact details.

Initialize a new record in the Subcontractor Master Data Model to track ongoing compliance status.

Assign a task to the Compliance Officer to validate the submitted business registration documents.

Update the 'License Verified' boolean field in the Subcontractor Profile once the check is complete.

Fetch the uploaded Certificate of Insurance (COI) entries and their respective expiration dates.

Subtract the current date from the insurance expiration date to determine the remaining coverage period.

Assign a task to the Risk Manager to ensure the coverage amounts meet the minimum contract requirements.

Update the Subcontractor entry with an 'Alert' status if the insurance limits are below the threshold.

Send an automated email to the subcontractor contact detailing which documents are missing or expired.

Retrieve all insurance entries where the expiration date is within the next 30 days.

Aggregate the number of insurance entries that have passed their expiration date to assess total risk.

Create a task for the compliance team whenever a subcontractor uploads a new certificate.

Update the Subcontractor Master record to 'Compliant' once all tasks and documents are verified.

Generate a summary report of all active subcontractors, their compliance percentages, and upcoming expirations.

Send an SMS alert to the Procurement Manager when a mission-critical subcontractor's insurance expires within 24 hours.

Delete temporary entries for subcontractor applications that were abandoned or rejected during the initial intake.

Koniec przepływu pracy/procesu.