Forum Discussion
Solved
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 I see are 1, 2 and 192350002 (which I find quite strange).
Is 1 for active and 2 for deactivated projects?
Thanks!
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 - 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
- Excellent, thanks so much!
- 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.
