Can you help me add the assignment status (Active/Inactive/Suspended,etc) to this SQL query?

Summary:

Hello team!

I have this code, but I don't know how to add the assignment status (Active/Inactive/Suspended, etc). Could you please help me with that? Thank you so much!

Content (please ensure you mask any confidential information):

SELECT DISTINCT

(SELECT DISTINCT K3.PERSON_NUMBER FROM PER_ALL_PEOPLE_F K3 WHERE K3.PERSON_ID = K2.PERSON_ID) "PERSON_NUMBER",

(SELECT DISTINCT K.SCHEDULE_NAME FROM ZMM_SR_SCHEDULES_TL K WHERE K1.SCHEDULE_ID = K.SCHEDULE_ID) "SCHEDULE_NAME",

K1.RESOURCE_TYPE,

TO_CHAR(K1.START_DATE,'MM/DD/YYYY') "START_DATE",

TO_CHAR(K1.END_DATE,'MM/DD/YYYY') "END_DATE",