Change the column name in the “price_subm_2023.csv” global lookup table too generic titles as detailed below. Rewire all references within code to take account of the column name changes. The new names are as follows.
entity >> ref_code1
year >> ref_code1
balance_type >> lookup_key1
service >> lookup_key2
asset_category >> lookup_key2
cost_driver >> lookup_key3
year_operational >> ref_value1
notes >> notes
regulatory life >> ref_value2
tax_life >> ref_value3
amount >> ref_value4
At a later point add columns ref1, ref2, ref3 and ref4.
At a later point combine this file with “reference.csv”
See also issue - Data upload file
Change the column name in the “price_subm_2023.csv” global lookup table too generic titles as detailed below. Rewire all references within code to take account of the column name changes. The new names are as follows.
entity >> ref_code1
year >> ref_code1
balance_type >> lookup_key1
service >> lookup_key2
asset_category >> lookup_key2
cost_driver >> lookup_key3
year_operational >> ref_value1
notes >> notes
regulatory life >> ref_value2
tax_life >> ref_value3
amount >> ref_value4
At a later point add columns ref1, ref2, ref3 and ref4.
At a later point combine this file with “reference.csv”
See also issue - Data upload file