Definitions & Timing of WIA Measures

(common measure)

measure menu | intro

Dislocated Worker: DW Average Earnings
definition | logic | timing | documentation issues | show all

Logic

Dislocated Worker: Average Earnings: Logic


DW Average Earnings Numerator

Sum of (WAGES 2 nd QUARTER AFTER THE EXIT QUARTER and WAGES 3 rd QUARTER AFTER THE EXIT QUARTER) where DISLOCATED WORKER and MORE THAN SELF-SERVICE and (WAGES 1 ST QUARTER AFTER EXIT QUARTER > 0 and WAGES 1 ST QUARTER AFTER EXIT QUARTER < 999999.99) and (WAGES 2 nd QUARTER AFTER EXIT QUARTER > 0 and WAGES 2 nd QUARTER AFTER EXIT QUARTER < 999999.99) and (WAGES 3 rd QUARTER AFTER EXIT QUARTER > 0 and WAGES 3 rd QUARTER AFTER EXIT QUARTER < 999999.99) and DATE OF EXIT is within the reporting period and (OTHER REASONS FOR EXIT is null or OTHER REASONS FOR EXIT = 00 or OTHER REASONS FOR EXIT = 98 )

DW Average Earnings Denominator

Count of unique RECORDS where DISLOCATED WORKER and MORE THAN SELF-SERVICE and (WAGES 1 ST QUARTER AFTER EXIT QUARTER > 0 and WAGES 1 ST QUARTER AFTER EXIT QUARTER < 999999.99) and (WAGES 2 nd QUARTER AFTER EXIT QUARTER > 0 and WAGES 2 nd QUARTER AFTER EXIT QUARTER < 999999.99) and (WAGES 3 rd QUARTER AFTER EXIT QUARTER > 0 and WAGES 3 rd QUARTER AFTER EXIT QUARTER < 999999.99) and DATE OF EXIT is within the reporting period and (OTHER REASONS FOR EXIT is null or OTHER REASONS FOR EXIT = 00 or OTHER REASONS FOR EXIT = 98

 


Visit FutureWork's Website, the leader in WIA Performance Measures Management| Performance Matters Plus, Web-based performance management for WIA performance measures