Definitions & Timing of WIA Measures

(common measure)

measure menu | intro

Adult: Average Earnings
definition | logic | timing | documentation issues | show all

Logic

Adult: Average Earnings: Logic


Adult Average Earnings Numerator

Sum of (WAGES 2 nd QUARTER AFTER THE EXIT QUARTER and WAGES 3 rd QUARTER AFTER THE EXIT QUARTER) where ADULT 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)

Adult Average Earnings Denominator

Count of unique RECORDS where ADULT 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