Forum Discussion

Dave_the_Automator's avatar
Dave_the_Automator
Copper Contributor
Apr 13, 2024

Project for the Web - msdyn_projects statuscode

Hi there   I am troubleshooting a filtering issue on our P4TW Power BI Project report.   Issue concerns the field statuscode from table msdyn_projects.    What does this field represent? Values...
Projects for Web
  • RodFromm's avatar
    RodFromm
    Apr 15, 2024

    Dave_the_Automator - Listed below are the values for the statuscode field.  It would be extremely helpful if Microsoft would publish schema documentation.

     

    • 1 = Active
    • 2 = Inactive - Sets project to read only
    • 192350000 = Closed - Set projects to read only and cancel future bookings
Dave_the_Automator's avatar
Dave_the_Automator
Copper Contributor
Apr 15, 2024
Excellent, thanks so much!
RodFromm's avatar
RodFromm
Steel Contributor
Apr 15, 2024
Glad to help. Let me know if you have any other P4W schema questions as I have quite of bit of time invested in developing our data model.

Resources