Clarity

Hello Friends!

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.

Thanks,

Abhishek.

Have you checked by changing the status of the resources on the application and then checking the database ?

NJ

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 )

NJ

If the resource is financially active then active field is set in PAC_MNT_RESOURCES table. This field is not related to that.