Skip to main content Skills Marketplace Discover and explore AI skills built by the community.
Install with Codex or Claude Copy this prompt, paste it into Codex, Claude, or another assistant, and let it review the skill page and install it for you.
Show prompt details A direct command skips the review prompt. Inspect the source before running it.
npx skills add https://github.com/datadrivenconstruction/DDC_Skills_for_AI_Agents_in_Construction --skill lien-waiver-trackerThe command stays on one line. Scroll horizontally to inspect it before copying.
Prefer a local copy? Download the files currently available to SkillsMP.
Download Zip Downloading... More from this repository Related occupations SOC
Based on SOC occupation classification
name lien-waiver-tracker description Track and manage construction lien waivers. Monitor conditional and unconditional waivers, ensure compliance before payments, and prevent lien exposure. homepage https://datadrivenconstruction.io metadata {"openclaw":{"emoji":"📝","os":["darwin","linux","win32"],"homepage":"https://datadrivenconstruction.io","requires":{"bins":["python3"]}}}
Lien Waiver Tracker
Overview
Track and manage lien waivers throughout the construction payment process. Ensure proper waivers are received before releasing payments, monitor waiver status by subcontractor, and minimize lien exposure.
Lien Waiver Types
┌─────────────────────────────────────────────────────────────────┐
│ LIEN WAIVER TYPES │
├─────────────────────────────────────────────────────────────────┤
│ │
│ CONDITIONAL UNCONDITIONAL │
│ ─────────── ───────────── │
│ 📋 Progress - Conditional ✅ Progress - Unconditional │
│ Effective when paid Immediately effective │
│ Use with payment Use after check clears │
│ │
│ 📋 Final - Conditional ✅ Final - Unconditional │
│ For final payment For final payment │
│ Upon receipt of funds After funds received │
│ │
└─────────────────────────────────────────────────────────────────┘
Technical Implementation
from dataclasses import dataclass, field
from typing import List , Dict , Optional
from datetime import datetime, timedelta
from enum import Enum
class WaiverType (Enum ):
CONDITIONAL_PROGRESS = "conditional_progress"
UNCONDITIONAL_PROGRESS = "unconditional_progress"
CONDITIONAL_FINAL = "conditional_final"
UNCONDITIONAL_FINAL = "unconditional_final"
class WaiverStatus (Enum ):
REQUESTED = "requested"
RECEIVED = "received"
VERIFIED = "verified"
REJECTED = "rejected"
MISSING = "missing"
class PaymentStatus (Enum ):
PENDING = "pending"
APPROVED = "approved"
HELD = "held"
RELEASED = "released"
@dataclass
class Subcontractor :
id : str
name: str
trade: str
contract_amount: float
contact_name: str
contact_email: str
tier: int = 1
@dataclass
Quick Start
tracker = LienWaiverTracker("PRJ-001" , "Office Tower" )
tracker.add_subcontractor(
"SUB-001" , "ABC Mechanical" , "HVAC" ,
contract_amount=500000 ,
contact_name="John Smith" ,
contact_email="john@abcmech.com"
)
tracker.add_subcontractor(
"SUB-002" , "XYZ Electric" , "Electrical" ,
contract_amount=350000 ,
contact_name="Jane Doe" ,
contact_email="jane@xyzelectric.com"
)
pa1 = tracker.create_payment_application(
number=1 ,
period_end=datetime.now(),
subcontractor_id="SUB-001" ,
amount_requested=50000
)
waiver_id = f"LW-SUB-001-1"
tracker.receive_waiver(waiver_id, "/waivers/sub001_pa1.pdf" , "PM" )
result = tracker.can_release_payment("SUB-001" , 1 )
print (f"Can release: {result['can_release' ]} - {result['reason' ]} " )
exposure = tracker.calculate_exposure("SUB-001" )
print (f"Lien exposure: ${exposure.exposure:,.2 f} " )
print (tracker.generate_report())
Requirements
pip install (no external dependencies)
class
LienWaiver
id
str
str
int
float
Optional
None
str
""
str
""
str
""
@dataclass
class
PaymentApplication
int
str
float
float
float
bool
False
Optional
None
@dataclass
class
LienExposure
str
str
float
float
float
float
class
LienWaiverTracker
"""Track and manage construction lien waivers."""
def
__init__
self, project_id: str , project_name: str
self
self
self
Dict
str
self
Dict
str
self
Dict
str
def
add_subcontractor
self, id : str , name: str , trade: str ,
contract_amount: float , contact_name: str ,
contact_email: str , tier: int = 1
"""Add subcontractor to tracking."""
id
id
self
id
return
def
create_payment_application
self, number: int , period_end: datetime,
subcontractor_id: str , amount_requested: float ,
retainage_rate: float = 0.10
"""Create payment application record."""
if
not
in
self
raise
f"Subcontractor {subcontractor_id} not found"
f"{subcontractor_id} -{number} "
self
self
return
def
request_waiver
self, subcontractor_id: str , pay_app_number: int ,
through_date: datetime, amount: float ,
waiver_type: WaiverType = WaiverType.CONDITIONAL_PROGRESS
"""Request lien waiver from subcontractor."""
f"LW-{subcontractor_id} -{pay_app_number} "
id
self
return
def
receive_waiver
self, waiver_id: str , file_path: str ,
verified_by: str = ""
"""Record receipt of lien waiver."""
if
not
in
self
raise
f"Waiver {waiver_id} not found"
self
self
return
def
verify_waiver
self, waiver_id: str , verified_by: str
"""Verify waiver details are correct."""
if
not
in
self
raise
f"Waiver {waiver_id} not found"
self
return
def
reject_waiver
self, waiver_id: str , reason: str
"""Reject waiver (incorrect amount, wrong form, etc.)."""
if
not
in
self
raise
f"Waiver {waiver_id} not found"
self
f"Rejected: {reason} "
return
def
convert_to_unconditional
self, waiver_id: str , payment_date: datetime
"""Convert conditional waiver to unconditional after payment clears."""
if
not
in
self
raise
f"Waiver {waiver_id} not found"
self
if
else
return
self
def
_check_pay_app_waivers
self, subcontractor_id: str , pay_app_number: int
"""Check if all waivers for pay app are received."""
f"{subcontractor_id} -{pay_app_number} "
if
not
in
self
return
self
for
in
self
if
and
all
in
for
in
def
calculate_exposure
self, subcontractor_id: str
"""Calculate lien exposure for subcontractor."""
if
not
in
self
raise
f"Subcontractor {subcontractor_id} not found"
self
sum
for
in
self
if
and
sum
for
in
self
if
and
in
and
in
sum
for
in
self
if
and
in
and
in
return
def
get_missing_waivers
self
List
Dict
"""Get list of missing or pending waivers."""
for
in
self
if
in
self
"waiver_id"
id
"subcontractor"
if
else
"pay_app"
"amount"
"type"
"requested_date"
"days_outstanding"
return
sorted
lambda
"days_outstanding"
def
get_waiver_status_by_sub
self, subcontractor_id: str
Dict
"""Get waiver status summary for subcontractor."""
if
not
in
self
raise
f"Subcontractor {subcontractor_id} not found"
self
for
in
self
if
for
in
0
1
return
"subcontractor"
"total_waivers"
len
"by_status"
"total_amount"
sum
for
in
"verified_amount"
sum
for
in
if
def
can_release_payment
self, subcontractor_id: str , pay_app_number: int
Dict
"""Check if payment can be released."""
f"{subcontractor_id} -{pay_app_number} "
if
not
in
self
return
"can_release"
False
"reason"
"Payment application not found"
self
for
in
self
if
and
and
if
not
return
"can_release"
False
"reason"
"No conditional waiver received"
for
in
if
not
in
return
"can_release"
False
"reason"
f"Waiver {w.id } not verified"
return
"can_release"
True
"reason"
"All waivers verified"
"amount"
def
generate_report
self
str
"""Generate lien waiver status report."""
"# Lien Waiver Status Report"
""
f"**Project:** {self.project_name} "
f"**Date:** {datetime.now().strftime('%Y-%m-%d' )} "
""
"## Summary"
""
f"- Total Subcontractors: {len (self.subcontractors)} "
f"- Total Waivers Tracked: {len (self.waivers)} "
f"- Missing Waivers: {len (self.get_missing_waivers())} "
""
"## Exposure by Subcontractor"
""
"| Subcontractor | Paid | Unconditional | Exposure |"
"|---------------|------|---------------|----------|"
0
for
in
self
self
f"| {exposure.subcontractor_name} | ${exposure.total_paid:,.0 f} | "
f"${exposure.unconditional_waivers:,.0 f} | ${exposure.exposure:,.0 f} |"
f"| **TOTAL** | | | **${total_exposure:,.0 f} ** |"
""
"## Missing Waivers"
""
self
if
"| Subcontractor | Pay App | Amount | Days Outstanding |"
"|---------------|---------|--------|------------------|"
for
in
10
f"| {m['subcontractor' ]} | #{m['pay_app' ]} | "
f"${m['amount' ]:,.0 f} | {m['days_outstanding' ]} |"
else
"*No missing waivers*"
return
"\n"
