Before a VAC comes out of impact training mode there must be at least 30 impacts, 1 hour of motion, 1 usage record from the time that the feature was enabled. If the criteria is not met the VAC will stay in impact training mode.
SELECT
@lNumImpacts_thresh = 30
,@dMotionHours_thresh = 1
,@lNumUsageDays_thresh = 1
,@dPctAdjustment = .1
,@nMinDaysSinceLastAdj = 45
,@nRaiseUBoundImpact_thresh = 3
,@lMinStatImpacts = 30
,@sPercentile = 0.75
,@lVehicleID = -1
-- Retrieve actual values for thresholds
SELECT @lNumImpacts_thresh = CONVERT(INTEGER, szValue)
FROM tLookUp
WHERE szKey = 'IMP ADJ NUM IMPACTS'
SELECT @dMotionHours_thresh = CONVERT(NUMERIC(14,2), REPLACE(szValue,',','.'))
FROM tLookUp
WHERE szKey = 'IMP ADJ MOTION'
SELECT @lNumUsageDays_thresh = CONVERT(INTEGER, szValue)
FROM tLookUp
WHERE szKey = 'IMP ADJ USAGE DAYS'
SELECT @dPctAdjustment = CONVERT(NUMERIC(4,1), REPLACE(szValue,',','.'))
FROM tLookUp
WHERE szKey = 'IMP ADJ PCT'
SELECT @nMinDaysSinceLastAdj = CONVERT(INTEGER, szValue)
FROM tLookUp
WHERE szKey = 'IMP ADJ MIN DAYS'
SELECT @nRaiseUBoundImpact_thresh = CONVERT(INTEGER, szValue)
FROM tLookUp
WHERE szKey = 'IMP ADJ RECS SET'
SELECT @lMinStatImpacts = CONVERT(INTEGER, szValue)
FROM tLookUp
WHERE szKey = 'IMP ADJ MIN SAMPLE'
SELECT @sPercentile = CONVERT(REAL, szValue)
FROM tLookUp
WHERE szKey = 'IMP ADJ PERCENTILE'
SET @lBadImpactThreshold = 20
SELECT @lBadImpactThreshold = CONVERT(INTEGER, szValue)
FROM tLookUp
WHERE szKey = 'IMP BAD THRESHOLD'