How to track assignments? RRS feed

  • Question

  • Hello everybody.

    I need to create a report to show tasks waiting approval by manager, waiting report by resource, sent back to resource and stuffs like this.

    I classified rows at the view Assignment on Published database this way:
     - if WASSN_MGR_UPDATED is 1, manager sent the task back to resource
     - if WASSN_RESOURCE_UPDATE is 1, resource sent task to approval by manager
     - WASSN_UPDATES_ACCEPTED is 1, manager has approved
     - WASSN_UPDATE_STATUS is 1, task is waiting for manager's approval. If it's 0, the resource didn't update the task.

    But, as you can see, these report is confusing and didn't work very well. Seems like some assignments are missing.

    Can somebody help me with this issue? Am I using the right Database and the right table/view? Which is the mapping of the assignments status?

    Thanks a lot!


    Monday, November 4, 2013 9:47 PM

All replies

  • Gabriel,

    Nope--wrong database.  Go on over to the Reporting Database.  See the MSP_TimesheetStatus table.

    • Edited by Edward Hanna Tuesday, November 5, 2013 5:02 PM Remove signature
    Tuesday, November 5, 2013 5:02 PM