Clarity PPM

Expand all | Collapse all

EMPLYSTATUS in PAC_MNT_RESOURCES table

  • 1.  EMPLYSTATUS in PAC_MNT_RESOURCES table

    Posted 11-15-2013 12:47 PM

    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.



  • 2.  RE: EMPLYSTATUS in PAC_MNT_RESOURCES table

    Posted 11-15-2013 01:09 PM

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

    NJ



  • 3.  RE: EMPLYSTATUS in PAC_MNT_RESOURCES table

    Posted 11-15-2013 01:17 PM

    Yes. This is not related to srm_resources.is_active field.



  • 4.  RE: EMPLYSTATUS in PAC_MNT_RESOURCES table

    Posted 11-15-2013 01:28 PM

    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 devil)

    NJ



  • 5.  RE: EMPLYSTATUS in PAC_MNT_RESOURCES table

    Posted 11-15-2013 01:32 PM

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