bcgov / bcparks-ar-admin

BCParks Attendance and Revenue Admin
Apache License 2.0
4 stars 11 forks source link

Update exporter to include legacy fields #270

Open kgorana opened 1 year ago

kgorana commented 1 year ago

Description

Update the A&R exporter to include legacy fields - for example, legacy Net Revenue columns can now either be calculated (with new records) or can be saved in the system (historical records). The exporter will have to search for legacy Net Revenue values before performing the Net Revenue calculation.

Additionally, the exporter may need to include legacy fields that are not associated with any activity, though business may choose to just never incorporate them in the exporter. There are 5 of these:

Gross Misc Day Use Revenue (Activity: DAY USE)
Net Misc Day Use Revenue (Activity: DAY USE)
Additional Details (Activity: LEGACY DATA)
Source Data (Activity: LEGACY DATA)
Picnic Shelter Variance Note (Activity: DAY USE)

Acceptance Criteria:

(Transferred from #256) For the historical data, the display would be the same, but will need to be implemented a little differently. This is because the historical data’s display is showing a Total Attendance field that is really Total Camping Party Nights, as no 3.2 multiplier is being applied. So for the historical data the current Total Attendance would be mapped to/ re-labelled as Total Camping Party Nights, and then the Total Attendance would be that number multiplied by 3.2.

Image

Notes

Spreadsheet of legacy fields to be provided. See

Get legacy field names from result of BRS-816: Migrate historical data into A&R system

Linked issues

blocks

created by

is blocked by

is cloned by

relates to

LindsayMacfarlane commented 3 weeks ago

October 11, 2024 prioritization session: this ticket is linked to 348 - 'old' data isn't showing in export. No priority provided.

Mural board: https://app.mural.co/t/bcparks2575/m/bcparks2575/1728427370222/4c9714df914c7ec8bdcf20a9ee1999cc9e664a27?wid=0-1728427872927