Project for the Web - msdyn_projects statuscode

[Dave_the_Automator]

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 I see are 1, 2 and 192350002 (which I find quite strange).

Is 1 for active and 2 for deactivated projects?

Thanks!

[#2 · Accepted solution]

@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

[#3]

Excellent, thanks so much!

[#4]

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.