I'd do such a thing in the script as this :
Suppose we have a table named table containing 3 fields, one field is named ProgressStatus and has as values PastDue and else.
Here is what I would do:
from your source;
'Past Due' as "Progress Status" //this is a new field
resident table where ProgressStatus=PastDue;
'On Time' as "Progress Status"
resident table where ProgressStatus<>PastDue;
Drop table table;