Queries for the Lot Start Coordinator Persona

The queries for the lot start coordinator persona are associated with the Lot Master (P44H201), Sales Workbench (P44H500), Homebuilder Purchase Order (P44H703), and Lot Start Workfile Maintenance (P44H711) programs.

The following table lists and describes the queries available for the lot start coordinator:

Query Name	Program	Criteria
Projected Starts	Lot Master (P44H201)	Construction Completion Date is between 01/01/2003 and today's date You must modify the date range for the Construction Completion Date in the query based on your requirements.
Under Construction	Sales Workbench (P44H500)	Close Date is < 01/01/1950 Construction Start Date is < Today You must modify the date range for the Close Date in the query based on your requirements.
Projected Closings	Sales Workbench (P44H500)	Close Date is < 01/01/1950 Projected Close Date is >= Today You must redefine the Projected Close Date as today's date plus the number of days in the future that you would like to see.
Unapproved EPOs	Homebuilder Purchase Order (P44H703)	Default data selection
Estimated Quantities	Lot Start Workfile Maintenance (P44H711)	Commitment Posting Status = E
Unassigned TBD	Lot Start Workfile Maintenance (P44H711)	Commitment Posting Status = T TBD record is not assigned to a supplier
Wokfile On Hold	Lot Start Workfile Maintenance (P44H711)	Commitment Posting Status = H
Workfile Unposted	Lot Start Workfile Maintenance (P44H711)	Commitment Posting Status = Blank