CASE WHEN COUNT(DISTINCT "Workforce Management - Accrual Real Time"."Worker"."Employee Ethnicity Code" BY "Workforce Management - Accrual Real Time"."Worker"."Person Number")>1 AND CAST(CASE WHEN "Workforce Management - Accrual Real Time"."Worker"."Employee Ethnicity Code" IS NULL THEN '0' WHEN "Workforce Management - Accrual Real Time"."Worker"."Employee Ethnicity Code" ='8' THEN '0' ELSE "Workforce Management - Accrual Real Time"."Worker"."Employee Ethnicity Code" END AS INTEGER)<>0THEN 'Two or More Races' WHEN "Workforce Management - Accrual Real Time"."Worker"."Employee Ethnicity Code" IS NULL THEN 'Not disclosed' ELSE "Workforce Management - Accrual Real Time"."Worker"."Employee Ethnicity" END as EthnicityRecast, CASE WHEN ROUND("Workforce Management - Accrual Real Time"."Incremental Plan"."Accrual Balance"/ CASE WHEN CAST(TIMESTAMPDIFF(SQL_TSI_DAY,"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date",CURRENT_DATE)/365 AS DOUBLE)<2 THEN 160 WHEN CAST(TIMESTAMPDIFF(SQL_TSI_DAY,"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date",CURRENT_DATE)/365 AS DOUBLE)<4 THEN 176 WHEN CAST(TIMESTAMPDIFF(SQL_TSI_DAY,"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date",CURRENT_DATE)/365 AS DOUBLE)<5 THEN 192 WHEN CAST(TIMESTAMPDIFF(SQL_TSI_DAY,"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date",CURRENT_DATE)/365 AS DOUBLE)<8 THEN 200 ELSE 240 END,2)*100 <25 THEN '<25% Full' WHEN ROUND("Workforce Management - Accrual Real Time"."Incremental Plan"."Accrual Balance"/ CASE WHEN CAST(TIMESTAMPDIFF(SQL_TSI_DAY,"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date",CURRENT_DATE)/365 AS DOUBLE)<2 THEN 160 WHEN CAST(TIMESTAMPDIFF(SQL_TSI_DAY,"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date",CURRENT_DATE)/365 AS DOUBLE)<4 THEN 176 WHEN CAST(TIMESTAMPDIFF(SQL_TSI_DAY,"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date",CURRENT_DATE)/365 AS DOUBLE)<5 THEN 192 WHEN CAST(TIMESTAMPDIFF(SQL_TSI_DAY,"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date",CURRENT_DATE)/365 AS DOUBLE)<8 THEN 200 ELSE 240 END,2)*100 <50 THEN '25%-49% Full' WHEN ROUND("Workforce Management - Accrual Real Time"."Incremental Plan"."Accrual Balance"/ CASE WHEN CAST(TIMESTAMPDIFF(SQL_TSI_DAY,"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date",CURRENT_DATE)/365 AS DOUBLE)<2 THEN 160 WHEN CAST(TIMESTAMPDIFF(SQL_TSI_DAY,"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date",CURRENT_DATE)/365 AS DOUBLE)<4 THEN 176 WHEN CAST(TIMESTAMPDIFF(SQL_TSI_DAY,"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date",CURRENT_DATE)/365 AS DOUBLE)<5 THEN 192 WHEN CAST(TIMESTAMPDIFF(SQL_TSI_DAY,"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date",CURRENT_DATE)/365 AS DOUBLE)<8 THEN 200 ELSE 240 END,2)*100 <75 THEN '50%-74% Full' WHEN ROUND("Workforce Management - Accrual Real Time"."Incremental Plan"."Accrual Balance"/ CASE WHEN CAST(TIMESTAMPDIFF(SQL_TSI_DAY,"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date",CURRENT_DATE)/365 AS DOUBLE)<2 THEN 160 WHEN CAST(TIMESTAMPDIFF(SQL_TSI_DAY,"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date",CURRENT_DATE)/365 AS DOUBLE)<4 THEN 176 WHEN CAST(TIMESTAMPDIFF(SQL_TSI_DAY,"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date",CURRENT_DATE)/365 AS DOUBLE)<5 THEN 192 WHEN CAST(TIMESTAMPDIFF(SQL_TSI_DAY,"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date",CURRENT_DATE)/365 AS DOUBLE)<8 THEN 200 ELSE 240 END,2)*100 <100 THEN '75%-99% Full' WHEN ROUND("Workforce Management - Accrual Real Time"."Incremental Plan"."Accrual Balance"/ CASE WHEN CAST(TIMESTAMPDIFF(SQL_TSI_DAY,"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date",CURRENT_DATE)/365 AS DOUBLE)<2 THEN 160 WHEN CAST(TIMESTAMPDIFF(SQL_TSI_DAY,"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date",CURRENT_DATE)/365 AS DOUBLE)<4 THEN 176 WHEN CAST(TIMESTAMPDIFF(SQL_TSI_DAY,"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date",CURRENT_DATE)/365 AS DOUBLE)<5 THEN 192 WHEN CAST(TIMESTAMPDIFF(SQL_TSI_DAY,"Workforce Management - Work Relationship Real Time"."Work Relationship Details"."Adjusted Service Date",CURRENT_DATE)/365 AS DOUBLE)<8 THEN 200 ELSE 240 END,2)*100 >=100 THEN 'At Max' Else 'ERROR' END as PctFullBucket,