Where can you find the meaning for the ASSIGNMENT_STATUS_TYPE_ID number?
Hi,
When running the below query, the table contains ASSIGNMENT_STATUS_TYPE_ID. This is a NUMBER value. Does anyone know where I could find the meaning of the value returned?
I typically see a '1', which I was told by Oracle during a call for an SR, that represents 'Active' or a '4' which represents 'Inactive'. I have found an ASSIGNMENT_STATUS_TYPE_ID that is returning 8002 and cannot understand what that means. Would be helpful if I knew where the value meaning is stored in the system.
SELECT*
FROM PER_ALL_ASSIGNMENTS_M
WHERE PERSON_ID=<'enter PERSON_ID'> and ASSIGNMENT_TYPE='ET' ORDER BY ASSIGNMENT_ID,EFFECTIVE_START_DATE