Can someone please let me know what EMPLYSTATUS field show in PAC_MNT_RESOURCES table? I have checked tech docs for the same. That only says "Employee Status Code" and in database table available values are 1 and null.
Have you checked by changing the status of the resources on the application and then checking the database ?
Yes. This is not related to srm_resources.is_active field.
For those null values check if the resource financial data is filled or not. If the resource is not financially active then they would be null. (think so )
If the resource is financially active then active field is set in PAC_MNT_RESOURCES table. This field is not related to that.