Prevent edits to specific fields (and manage a report)

Bud

We have municipal asset FCs in an Oracle 18c 10.7.1 enterprise geodatabase. Our Finance department has asked if they can do the following:

1. Get me to add additional finance-related fields to the FCs.
2. Finance staff would edit those new fields, but not edit any of the other fields.
3. Finance staff want to create & manage their own reports on the data, including complex calculated fields.

Questions:

1. What are my options for getting people with no GIS skills to edit GIS data? The solution needs to let staff see all fields in the FCs, but only lets them edit certain fields.
   • For example, use ArcGIS Pro or a Portal web map. I'm leaning towards ArcGIS Pro since the users would need to do field calculations.
2. I plan to use Excel as a user-maintained reporting tool. Will that work?
   • The spreadsheet would use real-time GIS data via an ODBC connection and Microsoft Query. I would set up a true Excel table using the GIS data so Finance staff could easily create calculated columns (enter the formula once, it auto-fills the column's formula).
   • The reason why I want to use Excel is that Finance staff have already mocked up all of their complex calculations in a spreadsheet. It would be easier for Finance staff to use their existing Excel formulas in the Excel report rather than get me to rewrite the math as SQL or Arcade in a different platform.

What do you think? Thanks. 

Eugene_Adkins

With Pro, from the data design/fields option of the feature class, you can make certain fields read only. That will prevent the user from editing those specific fields but leave other fields as editable.