Stored Procedures - Production Units by Detail Item

Production Units by Detail Item Stored Procedure Changes  [PMID Ref No 27558] 10.2.0.3 BLUE  

The stored procedures that are used in the screen entries and MAR reporting for the Production Units by Detail Item processes have been updated and the original stored procedures have been saved as an archived version.  The BidItemMaster table that is produced from these procedures has been updated with two new fields and a formula change for the Bid Item Percent Complete field.

•TaskHoursAllowed - this field represents the hours earned on the bid item tasks

•BidItemHoursAllowed - this field represents the hours earned on the bid items for all related bid item tasks

•BidItemPcntCompl - This formula has been changed to now compute the percentage complete on the bid items using the estimated bid items and the hours earned on the bid items

The following stored procedures were updated with the new changes:

•abm_Get_DPU_BidItemMasterRecs_Lookup

•abm_Get_DPU_BidItemMasterRecs_FullDetail_Lookup

The original stored procedures have been maintained in the library for archive purposes:

•abm_Get_DPU_BidItemMasterRecs_Lookup_03092022

•abm_Get_DPU_BidItemMasterRecs_FullDetail_Lookup_03092022