Clarity

  • 1.  Financially Active resource

    Posted Apr 04, 2017 02:14 AM

    Hi,

    Can I know the table and column name where the resource Financially active field is saved in DB?

     

    Thanks in advance.

     

    Monica



  • 2.  Re: Financially Active resource

    Posted Apr 04, 2017 04:15 AM

    Table Name: pac_mnt_resources

     

    The financial properties that are related to the resource. If the financial properties:

    • Do not exist, then the resource is imported without any association to financial properties.
    • Exist, then they are also imported (e.g., RESOURCE_CLASS, TRANSCLASS, etc)

     

    NJ



  • 3.  Re: Financially Active resource

    Posted Apr 04, 2017 04:16 AM

    EMPLYSTATUS in PAC_MNT_RESOURCES table

     

    https://communities.ca.com/message/104782505 

     

    NJ



  • 4.  Re: Financially Active resource
    Best Answer

    Posted Apr 04, 2017 04:26 AM

    PAC_MNT_RESOURCES.ACTIVE tells if the financial properties of the employee row are active.



  • 5.  Re: Financially Active resource

    Posted Apr 04, 2017 04:49 AM

    Thank you so much navzjoshi00 urmas