SSP-1367 Build external reg status ID from business key not row_number()

Dramatically improves performance b/c you don't need a table scan just to
calculate the ID for any given row/s.