The selection set for Impervious Removal needs to be updated for the new domain values in D_Impl_Status. Values Duplicate Record, Plan Revised, and Unknown need to be excluded from the selection set, so they don't go to MDE.
The original selection set was:
All IMPERVIOUS_REM records where :
REPORTING_YEAR <= user selected reporting year
So the new selection set is:
All IMPERVIOUS_REM records where :
REPORTING_YEAR <= user selected reporting year
IMPL_STATUS = Complete OR Planning OR Under Construction OR Abandoned OR Design OR Removed [all domain values except Duplicate Record, Plan Revised, and Unknown]
The selection set for Impervious Removal needs to be updated for the new domain values in D_Impl_Status. Values Duplicate Record, Plan Revised, and Unknown need to be excluded from the selection set, so they don't go to MDE.
The original selection set was:
All IMPERVIOUS_REM records where :
So the new selection set is:
All IMPERVIOUS_REM records where :