DBE Payment Report

Version 6.4 Changes

• Added a Second Tier Subcontractor parameter/filter to the report.

• Added a Report Style parameter to allow the user to specify whether to display the output data in “Summary” form, in “Line Item Breakdown” form, or in “Estimate Breakdown” form.

• In the “Include” parameter section, the checkbox options for “Estimate Breakdown” and “Estimate Line Item Breakdown” have been removed (and are now included under the new Report Style parameter mentioned earlier). A new Second Tier indicator has been added to allow the user to designate whether or not to display Second Tier data.

• Removed the logic to only display approved Subcontracts as of the Estimate To Date. Note: This may give the appearance that the subcontractor should have been paid on each estimate. Users should verify the Subcontract Approval Date against the various estimates to determine when the payments really should have been made.

• Modified the report to only pull information from estimates in a Paid status.

• Removed the “Goals Unit Price” column from the Estimate Line Item Breakdown version of the report.

• In the Summary version of the report, the “Goals Unit Price” column header has been changed to “Subcontract Goals Amount” and the value is the sum of the goals unit price multiplied by the subcontracted line item quantity for each line item on the subcontract.

• Modified the report to show the most recent estimate for the selected contract where the estimate thru date falls between the report parameter for Estimate Period From and To.

Version 6.3 Changes

• Added new filter fields for Estimate Number, Estimate Period, Subcontractor, DBE Type to give greater control over the set of records to be retrieved, reviewed and printed.

• Enhanced the reporting features to allow DBE payment data to be displayed by estimate and/or by estimate line item and provided the option of including estimate line items that had a quantity of zero paid.

• Corrected a problem that caused state-funded projects to display the wrong certification types.

New for Version 6.2.1

• This is a new report that shows the estimated amounts that should have been paid to each subcontractor on a contract to date. This information is based on the estimate payments paid to the Prime Contractor on those line items and the Subcontractor percentage for those line items. It can be used to verify pending Disadvantaged Business Enterprise (DBE) payments on the DBE Payment Tracking web site.

  The calculation used to determine the Estimated Amount Paid to Sub is the following:

  (Est qty divided by Bid Qty) * Cert Percent * (Goals amount)

  where Est qty is the Estimate Line Item Total Quantity

  Bid Qty is the Contract Plan Quantity

  Cert Percent is the Subcontract Line Item Certification Percent

  Goals Amount is the Subcontracted qty * Goals Unit Price

  If the Bid qty = 1000

  Est qty = 100

  Subcontracted qty = 1000

  Goals unit price = $4.00

  Cert percent = 100%

  then the Estimated Amount Paid to Sub is 100/1000 * 1 * (1000 * 4.00) = $400

All users can access the complete HiCAMS and DOH Vendor System Release Notes here

Page last updated 28 October 2008