kcigeospatial / balt_co_ETL

This will provide a place to track internal issues around the Baltimore County NPDES NCT application ETL.
0 stars 0 forks source link

D_BMP_Status > dBMPStatus domain mapping #3

Closed gerrykelly closed 6 years ago

gerrykelly commented 7 years ago

dBMPStatus now only has 2 values: ACT | Active & REM | Removed

D_BMP_Status has 5 Active Cancelled Duplicate Proposed Removed

I know you're giving me info on this, so I'll leave it as is (but delete the existing PROP code for dBMPStatus from domains_baltco_mde_equivalency

leeensminger commented 6 years ago

Active ==> ACT Cancelled ==> None (these will be removed from the selection set, see #25 ) Duplicate ==> None (these will be removed from the selection set, see #25 ) Proposed ==> None (these will be removed from the selection set, see #25 ) Removed ==> REM

gerrykelly commented 6 years ago

With that clarification, should be good as-is: image

leeensminger commented 6 years ago

The Active and Removed values appear to be good and translate correctly. The other values (Cancelled, Duplicate, Proposed) still are outputted, when they shouldn't be, per issue #25 . So I'm closing this, since these two values are good.