Looking at the SQL, it appears that PERSON doesn't contain one row per person but rather multiple rows per person for each status change. I think you can leverage row_number() function and rank the result the way you need.
"Do not seek to follow in the footsteps of the wise. Instead, seek what they sought." - Matsuo Basho