[S] Update ORCS Number of Park

[JLWade]

This ticket is to resolve the data issue identified through connecting A&R to the data register.

Change 3883 ORC in A&R to 0281 for any park with 3883, remove 3883 as that is not a park.

This will enable updating A&R from the data register for the new name and it should read Tsutswecw Park instead of Roderick Haig-Brown Park for all years in A&R (can validate this by checking standard export report).

Acceptance Criteria:

• 3883 number is replaced with 0281 for Tsutswecw park in A&R
• No data is affected other than ORC number is updated and Park Name can now be updated via data register

[cameronpettit]

@JLWade @Christopher-walsh22 For clarification here: Do we need to preserve all of the records in the database that are within ORCS 3883, ie, a record for 3883 becomes a record for 0281? If so, that would necessitate a migration which will be a little more complicated than just creating a new park.

The other option is to leave 3883 as is and create a new park for 0281 (and all of its child subareas) which will capture all new records. All existing subareas will be locked against further editing. If I remember correctly, this is what we have done in the past when this occurs, though I cannot remember fully right now.

[JLWade]

@cameronpettit this one is tricky - all records under 3883 need ot be moved to 0281. Is there a way to just change the orc number in the database?
All subareas need to follow suit as well. We had this park under the wrong ORC (data register revealed this issue) so will need ot basically move everything to the correct number.
Does that help?

[cameronpettit]

@JLWade possible but not easily done. @Christopher-walsh22 you will need to write a migration that does the following

1. collect all parks, subareas, activity records, config objects and variances associated with ORCS 3883
2. duplicate all the records collected in step 1 with the correct ORCS 0281, then reinsert them into the database
3. delete all of the records collected in step 1 from the database
4. Update all permissions related to 3883 in Keycloak to use 0281
5. Verify that variance tracking still works properly

[JLWade]

thanks Cam!

[JLWade]

Leave accents in the park name - they did not translate via email well to this ticket

[Christopher-walsh22]

During code review @marklise noticed that in the data register park 0281 is named 'Tsútswecw' instead of 'Tsutswecw'. I have confirmed with @JLWade that is the proper spelling for park 0281.